### Free Educational Resources

• > BUSN603 MS Excel Prob Set 8
+

# BUSN603 MS Excel Prob Set 8

##### Rating:
(0)
Author: Dannie Young
##### Description:

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.)

(more)
##### Try a College Course Free

Sophia’s self-paced online courses are a great way to save time and money as you earn credits eligible for transfer to over 2,000 colleges and universities.*

No credit card required

25 Sophia partners guarantee credit transfer.

221 Institutions have accepted or given pre-approval for credit transfer.

* The American Council on Education's College Credit Recommendation Service (ACE Credit®) has evaluated and recommended college credit for 19 of Sophia’s online courses. More than 2,000 colleges and universities consider ACE CREDIT recommendations in determining the applicability to their course and degree programs.

Tutorial