Author:
Dannie Young

http://homework.plus/busn603-ms-excel-prob-set-8/

1. If Electrocomp decides that at least 20 air conditioners should be produced but no more than 80 fans should be produced, the optimal production mix of air conditioners and fans is __________. (The first number is for air conditioners and the second for fans.)

A.(50,30)

B.(20,80)

C.(40,60)

D.(26.67,80)

2. In the optimal solution for the above question (Question 1), the slack for the four constrains — Total hours of wiring, Total hours of drilling, Number of air conditioners, Number of fans are_________, respectively. (Hint: A negative number shows that the constraint is binding downward, i.e. it sets a lower rather than an upper limit. You may take the negative sign out hen interpreting the results.)

A.0, 0, 20, 20

B.0, 0, 10, 20

C.0, 0, 20, 10

D.10, 10, 10, 1

3. If Electrocomp decides that at least 30 air conditioners should be produced but no more than fans should be produced, the optimal production of air conditioners is and the optimal production of fans is . (Please only enter an integer and include no units.)

4. In the optimal solution for the above question (Question 3), the slack for the four constrains — Total hours of wiring, Total hours of drilling, Number of air conditioners, Number of fans are _________, respectively. (Hint: A negative number shows that the constraint is binding downward, i.e. it sets a lower rather than an upper limit. You may take the negative sign out when interpreting the results.)

A.0, 0, 15, 10

B.5, 0, 15, 0

C.0, 5, 15, 0

D.0, 0, 10, 15

5. The optimal production of benches is 262 and the optimal production of tables is 25. (Please only enter an integer and include no units. Hint: Because of the resource constraints, you may not be able to produce 4 tables even if the solution is 3.8; you may have to just produce 3 tables.)

6. The optimal dollar amount invested in Petrochemical stock is _________ dollars, and the optimal

Dollar amount invested in Utility stock is ___________ dollars. (Please only enter an integer and include no units. Hint: The total risk on each stock is the risk index times the investment in dollars. When you use Excel QM, you need to end the total risk in the right hand side of the constraint not simply the risk index.

A.20,000, 30,000

B.30,000, 20,000

C.10,000, 15,000

D.15,000, 10,000

7. The average risk index (not in dollar amount) for the optimal investment is 6, and the estimated best/maximum return for this investment is 4200. (Please only enter an integer and include no units.)

8. The optimal money invested in the five stocks and bonds — Municipal bonds, Electronics, Aerospace, Drugs, and Nursing homes are __________ dollars, respectively.

A.50,000, 50,000, 50,000, 50,000, 50,000

B.50,000, 0, 0, 175,000, 25,000

C.25,000, 0, 0, 175,000, 50,000

D.50,000, 25,000, 25,000, 125,000, 25,000

9. The optimal number of medical patients per year is 2791, and optimal number of surgical patients per year is 2105. The maximum annual profit is 9,551,659 dollars. (Please round to the closest integer and include no units.)

10. Among the additional beds, _______ beds should be used for medical patients and

_______ beds used for surgical patients.

A.45, 45

B.60, 30

C.61, 29

D.29, 61

11. At the optimal, there are 0 empty beds, 876 lab tests of unused capacity,0 x-rays of unused capacity, and 695 unused operation rooms available. (Please round to the closest integer and include no units.)

Tutorial