Please keep at least 4 decimals for your answer. Tracksaws, Inc. makes tractors and lawn mowers. The firm makes a profit of $30 on each tractor and $30 on each lawn mower, and they sell all they can produce. The time requirements in the machine shop, fabrication, and tractor assembly are given in the table. Machine Shop Fabrication Assembly Tractor 2 hours 2 hours 1 hour Lawn Mower 1 hour 3 hours O hour Hrs. Available 60 hours 120 hours 45 hours Here is the results from Excel (let's call it Table 2), Variable Cells Cell Name $B$11 tractor=tractor $B$12 mower=tractor Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease 15 0 30 30 10 30 0 30 15 15 Constraints Cell Name $D$5 machine shop usage $D$6 Fabrication usage $D$7 Assembly usage Final Shadow Constraint Allowable Allowable Value Price R.H. Side Increase Decrease 60 7.5 60 40 20 120 7.5 120 60 60 15 0 45 1E+30 30 2). (10) How many tractors and mowers should be produced as their optimal solution, and how much profit will they make? Please explain how do you obtain your answer from Table 2 above (from example, for which column and which row and what kind of calculation you have taken). 3) (20) Determine the sensitivity range for the profit for tractors (show where you get the number you use in your calculation). If we change the unit profit of mower to $18, holding other things constant, what will happen to the optimal solution as well as the profit (please obtain the value of them)? Please keep at least 4 decimals for your answer. Tracksaws, Inc. makes tractors and lawn mowers. The firm makes a profit of $30 on each tractor and $30 on each lawn mower, and they sell all they can produce. The time requirements in the machine shop, fabrication, and tractor assembly are given in the table. Machine Shop Fabrication Assembly Tractor 2 hours 2 hours 1 hour Lawn Mower 1 hour 3 hours O hour Hrs. Available 60 hours 120 hours 45 hours Here is the results from Excel (let's call it Table 2), Variable Cells Cell Name $B$11 tractor=tractor $B$12 mower=tractor Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease 15 0 30 30 10 30 0 30 15 15 Constraints Cell Name $D$5 machine shop usage $D$6 Fabrication usage $D$7 Assembly usage Final Shadow Constraint Allowable Allowable Value Price R.H. Side Increase Decrease 60 7.5 60 40 20 120 7.5 120 60 60 15 0 45 1E+30 30 2). (10) How many tractors and mowers should be produced as their optimal solution, and how much profit will they make? Please explain how do you obtain your answer from Table 2 above (from example, for which column and which row and what kind of calculation you have taken). 3) (20) Determine the sensitivity range for the profit for tractors (show where you get the number you use in your calculation). If we change the unit profit of mower to $18, holding other things constant, what will happen to the optimal solution as well as the profit (please obtain the value of them)
