National MBA 674 The Martinez Model Car Company produces four different radio-controlled model
Question # 00264058
Posted By:
Updated on: 04/27/2016 12:25 PM Due on: 05/27/2016
The Martinez Model Car Company produces four different radio-controlled model cars based on exotic production models: Ferrari, BMW, Lotus and Tesla. Each model requires production in five departments: molding, sanding, polishing, painting, and finishing. The number of minutes for each product in each department, the selling per unit, and the minutes available in each department each day are shown below.
(a) How many of each type of car should be produced to maximize profit?
(b) If marketing requires that at least 25 units of each be produced each day, what is the optimal production plan and profit? Before you solve this, how would you expect the profit to compare with your answer to part (a)?
This should be solved in Excel help please.
-
Rating:
/5
Solution: National MBA 674 The Martinez Model Car Company produces four different radio-controlled model