This is the problem what excel generated is below I only nee

This is the problem. what excel generated is below. I only need help answering a-d.

3. The given scenario is summarized in the optimization model below. Complete (a) -(d), Charles Watts Electronics manufactures the following five peripheral devices used in computers especially designed for jet fighter planes: internal modems, graphics circuit boards, and hard disk drives. Each of these technical products requires time, in minutes, on three types of electronic testing equipment. This information is given in the table below. Intemal Circuit Hard Modem Board Drives Test device 5 Test device 2 2 Test device 35 10 Test device 1 is available for 120 bours (7200 minutes) per week and Test device 2 is also available for 120 hours (7200 minutes) per week. Test device 3 is only available for 100 hours (6000 minules) per week. An internal modem has a profit of $180 per unit, a circuit board has a profit of $170 per unit, and a hard drive has a profit of $250 per unit. Watts Electronics would like to know what product mix will maximize profits. Maximize: 180+170 C+250 51+8C+ 1017200 21+4C+5 Hs 7200 51+3C1816(100 Subject to: a.) The solved Excel spreadsheet and sensitivity report are included on the next page. What is the product mix that gives the maximum profit? b.) What is the optimal profit? c.) What would you recommend spending for an extra minute of time on testing device 17 d.) Would it be worth spending $33,984 on an addition 1440 minutes of time on device 3? Why or Why not?

Solution

(a) From the excel results, we can see that the product mix for maximizing profit is:

Internal Modem: 1056

Circuit Board: 240

Harde Drives: 0

(b) From the excel sheet, we can see that the optimal profit is 230880

(c) It is not recommended to spend an extra minute on devide 1 as the testing tie for this device is maximum of all and therefore it will affect the profit adversely.

(d) Spending 33,984 is a huge amount (even more than the optimal profit), therefore, it is not recommended to spend this amount for 1440 minutes on device 3.