Tracks, Inc. makes tractors and lawn mowers. The firm makes a profit of $30 on each tractor and 530 on each Lawn mower, and they sell all they can produce. The time requirements in the machine shop, fabrication, and tracto assembly are given in the table. Machine Shop Fabrication Assembly Tractor 2 hours 2 hours 1 hour Lawn Mower 1 hour 3 hours 0 hour Hrs. Available 60 hours 120 hours 45 hours 1) (23) Please fill in the blank in the Excel table (Table 1) below (Namely, all the cells that are labeled as X, where X stands for a letter such as BC,D,E,F,G, and stands for a numbes such as 2.5.6.7. 11. 12. 13) using either numbers, or signs or Excel formulas. For example, you can write "BS: 20". tractor mower profit B2 C2 labor hour constraints usage constraint available left over machine shop B5 C5 D5 ES F5 G5 Fabrication B6 C6 D6 E6 F6 G6 Assembly B7 C7 D7 F7 output tractor B11 mowers B12 profite B13 Here is the results from Excel (let's call it Table 2). Final Reduced objective Allowable Allowable Value Cost Coffee Bree Sail tractor actor Valor Price Ride Terese Dee So machine shoppe 073 S057 Assemblye 13. Please answer the following questions, if you use any numbers from Table to answer the following questions please indicate where the numbers are coming from. For instance, you can write the number is from the column of "reduced cost and the row of "mower"! 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 $15, holding other things constant, what will happen to the optimal solution as well as the profit (please obtain the value of them? 0.05) What is the shadow price for labor hours in the assembly? What is the meaning of it? When the available Labor hours in the assembly department is changing in which range would this shadow price be valid, holding other things constant? 5).(8) If each additional labor hour in the machining shop costs 510, would the manager be willing to pay in order to increase profit? Why or why not? You must use numbers obtained from Table 2 (not your feeling or believe to explain the reason 6). (24) A breakdown in fabrication causes the available hours to drop from 120 10 90 hours. Holding the things constant, how will this impact the optimal number of tractors and mowers produced? What is the new peolata? Is there any surplus or slack variables in this question? And if there are what are the value of them after the available hours of labor in fabrication drops from 120 to 90 hours? Tracks, Inc. makes tractors and lawn mowers. The firm makes a profit of $30 on each tractor and 530 on each Lawn mower, and they sell all they can produce. The time requirements in the machine shop, fabrication, and tracto assembly are given in the table. Machine Shop Fabrication Assembly Tractor 2 hours 2 hours 1 hour Lawn Mower 1 hour 3 hours 0 hour Hrs. Available 60 hours 120 hours 45 hours 1) (23) Please fill in the blank in the Excel table (Table 1) below (Namely, all the cells that are labeled as X, where X stands for a letter such as BC,D,E,F,G, and stands for a numbes such as 2.5.6.7. 11. 12. 13) using either numbers, or signs or Excel formulas. For example, you can write "BS: 20". tractor mower profit B2 C2 labor hour constraints usage constraint available left over machine shop B5 C5 D5 ES F5 G5 Fabrication B6 C6 D6 E6 F6 G6 Assembly B7 C7 D7 F7 output tractor B11 mowers B12 profite B13 Here is the results from Excel (let's call it Table 2). Final Reduced objective Allowable Allowable Value Cost Coffee Bree Sail tractor actor Valor Price Ride Terese Dee So machine shoppe 073 S057 Assemblye 13. Please answer the following questions, if you use any numbers from Table to answer the following questions please indicate where the numbers are coming from. For instance, you can write the number is from the column of "reduced cost and the row of "mower"! 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 $15, holding other things constant, what will happen to the optimal solution as well as the profit (please obtain the value of them? 0.05) What is the shadow price for labor hours in the assembly? What is the meaning of it? When the available Labor hours in the assembly department is changing in which range would this shadow price be valid, holding other things constant? 5).(8) If each additional labor hour in the machining shop costs 510, would the manager be willing to pay in order to increase profit? Why or why not? You must use numbers obtained from Table 2 (not your feeling or believe to explain the reason 6). (24) A breakdown in fabrication causes the available hours to drop from 120 10 90 hours. Holding the things constant, how will this impact the optimal number of tractors and mowers produced? What is the new peolata? Is there any surplus or slack variables in this question? And if there are what are the value of them after the available hours of labor in fabrication drops from 120 to 90 hours