Question

PLEASE SHOW IN EXCEL SOLVER A sudden increase in the demand for smoke detectors has left...

PLEASE SHOW IN EXCEL SOLVER

A sudden increase in the demand for smoke detectors has left Acme Alarms with insufficient capacity to meet demand. The company has seen monthly demand for its electronic and battery-operated detectors rise to 20,000 and 10,000, respectively; and Acme wishes to continue meeting demand. Acme’s production process involves three departments: fabrication, assembly, and shipping. The relevant quantitative data on production and prices are summarized below. Monthly Hours Hours/Unit Hours/Unit Department Available (Electronic) (Battery) Fabrication 2000 0.15 0.10 Assembly 4200 0.20 0.20 Shipping 2500 0.10 0.15 Variable cost/unit $18.80 $16.60 Retail price $29.50 $28.00 The company also has the option to obtain additional units from a subcontractor, who has offered to supply up to 20,000 units per month in any combination of electronic and battery-operated models, at a charge of $21.50 per unit. For this price, the subcontractor will test and ship its models directly to the retailers without using Acme’s production process. a. What are the optimal profit and corresponding make/buy levels? (Fractional quantity decisions are acceptable because this is a planning model.) [20 points] b. Suppose Acme is able to increase its fabrication capacity by 10%. How will the optimal profit and corresponding make/buy mix change? [10 points]

0 0
Add a comment Improve this question Transcribed image text
Know the answer?
Add Answer to:
PLEASE SHOW IN EXCEL SOLVER A sudden increase in the demand for smoke detectors has left...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT