tasamo makes two types of vehicles Tasamo makes two types of vehicle- SUV and Pi
ID: 452156 • Letter: T
Question
tasamo makes two types of vehicles Tasamo makes two types of vehicle- SUV and Pickup Truck These vehicles require three types of speoial materials: meterial A material B material C. Each SUV requires 30 pounds of material A 20 pounds of material B, and 50 pounds of mateniel C Esch Pickup Truck requires 30 pounds of material A 40 pounds of material B, and 80 pounds of material C. The profit for each SUV is $3000 and the profit for each Pickup Truck is $5500. Due to suppliers' capacity limits, Tony can only obtain 6000 pounds of material A 5000 pounds of material B, and 8500 pounds of material C per month. Tasamo also needs to produce at least 50 SUV per month to fulfill s contract Tasamo wants to find a production plan (ie, the number of SUV and Pickup Truck to make) to maximize his monthly proft Let x be the number of SUV to make per month. Let y be the number of Pickup Truck to make per month. Tasamo has formulated this decision problem as a linear program and solved it with Excel Solver Tesamo obtained the foillowing report from Excel Solver Variable Cells program and solved it with Excel Solver Tasamo obtained the following report from Excel S Cell $C$2 $D$2 Final ReducedObjective Allowable Allowable Value Cost Coefficient Increase Decrease 250 500 2500 Name 2500 Decision Variable X150 Decision Variable y 50 0 3000 5500 Constraints Final Shadow Constraint Allowable Allowable R.H. Side Increase Decrease 1500 1000 Value Price R Cell SE$11 AAvailability SE$12 B Availability SE$13 CAvailability SE$15 Minimum # of SUV Name 3 6000 16.66666667 6000 5000 6500 50 1500 2000 1E+30 9 5000 125 6500 150 100 1E+30 Use the report to answer the following questions. A)Explanation / Answer
1-Optimal Solution=150*3000+50*5500=725000
2-Yes the production plan will, since the allowable decrease in constraints is 250 i.e to 3000-250=2750 and if the profit becomes 2700 then optimal solution shall change.
3-each unit B increase will increase the objective function by 125 hence 100 unit increase will increase objective function by 125*100=12500
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.