Formulate and solve the following problems using EXCEL. What recommendations would you make to senior management and why? a) Aradio, a manufacturer of car radios, has received an order for 10,000...

Formulate and solve the following problems using EXCEL. What recommendations would you make to senior management and why? a) Aradio, a manufacturer of car radios, has received an order for 10,000 digital standard radios and an order for 6,000 digital radios with CD and MP3 capability. Because of other contractual commitments, Aradio may not be able to produce the total order on its own. That is, it may be necessary to subcontract the production of some of the radios. Another manufacturer, Bradio, has agreed to supply Aradio with standard digital radios at a cost of $65 per unit and digital CD MP3 radios at $115 per unit. Aradio must decide how many to purchase from Bradio. Aradio's production data is given below. Unit Production Times (hours) Product Assembly Standard 4.2 CD-MP3 5.1 Inspection 0.4 0.7 Packaging 0.2 0.2 Unit Production Cost $59 $103 Aradio estimates that its production hours available for assembly, inspection, and packaging will be 40,000, 6,000, and 3,000 respectively. Aradio will be receiving $70.20 for each standard radio and $126.50 for each CD-MP3 radio?

Jan 13, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here