Question: solve using excel only, please reply as soon as possible. 1 D E F G 1 J H P B L M N O Toyota

solve using excel only, please reply as soon as possible. solve using excel only, please reply as soon as
1 D E F G 1 J H P B L M N O Toyota International considering the make of two new models: Pajero and Morando Pajero requires 300days of labor and $10,000 in materials Morando required 500 days of labor and S15000 in materials. The profit contribution of each Pajero is $8000 whereas that of each Morando is: $12000. The plant has a capacity of 200,000 working days per month, and the material budget is $8 million per month Marketing department requires that at least 100 units of Pajero and at least 200 units of Morando be produced each month (a) How many of each car models should be produced per month to achieve the maximum profit? (b) To avoid manufacturing too many cars, the administration decided to fix the total profit to S4 million. In this case, how many of each car models should be produced? X1 (a) X2 (b) X1 X2 Profit Profit

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!