Raj Computer located in Punjab India is a small computer manufacturing company. The company makes three models of computers; Laptop, Tablet and a Mini Tablet.
The following table shows the parts required to build the three products and the available parts inventory.
|
Parts Required by each device
|
Inventory level
|
|
Part Name
|
Laptop
|
Tablet
|
Mini Tablet
|
Inventory
|
|
Chassis
|
1
|
1
|
0
|
450
|
|
LCD Screen
|
1
|
0
|
0
|
250
|
|
Speaker Cone
|
2
|
2
|
1
|
800
|
|
Power supply
|
1
|
1
|
0
|
450
|
|
Electronics
|
2
|
1
|
1
|
600
|
The profit for each products are as follow:
|
Product Profit
|
|
|
Laptop
|
Tablet
|
Mini Tablet
|
|
Profit/Unit
|
$ 75
|
$ 50
|
$ 35
|
The production manager Mr. Chandra has hire you to help him determine how many of the three computer models to produce taking into the available inventory, so that his profits for the company is maximized.
You decided to take the job as you are very confident that you can design a Decision Support System using Excel Solver to help Mr. Chandra decide the number of units to produce in order to maximize his profits.
At the meeting you will hand him the Excel spreadsheet of the production matrix and a memo that contains your production recommendation based on the results of your optimization tool and all pertinent information that it contains to enable him to make the production decision.