Assignment 5 Raj Computer located in Punjab India is a small computer manufacturing company. The com
Assignment 5
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. You did very well in a course you took at a University and is very confident that you can crank out the DSS in a couple of hours but decided to meet with Mr. Chandra at 11:59pm on Wednesday June 11th. 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.
Deliverable: Your worksheet and production recommendation in a memo to Mr. Chandra uploaded to Black Board.