Question 2 Space Electronics Corporation primarily manufactures four highly technical products, which it supplies to aerospace firms that hold NASA contracts. Each of the products must pass through the following departments before they are shipped: wiring, drilling, assembly, and inspection. The time requirements in each department (in hours) for each unit produced and its corresponding profit value are summarized in this table The production time available in each department each month and the minimum monthly production requirement to fulfil contracts are as follows: Formulate this production-mix situation as an LP problem. The production manager first specifies production levels for each product for the coming month. He lets: X1 = number of units of XJ201 produced X2 = number of units of XM897 produced X3 = number of units of TR29 produced X4 = number of units of BR788 produced Answer the following questions (a-k) using the output below please be brief. If there are two possible answers one will suffice. Where necessary a range analysis must be shown. a) What is the optimal solution and what is the value of the objective function (2 marks) b) Which constraints are binding and which constraint show extra capacity? 2 marks c) 10 hours extra of Drilling time became available .Evaluate the effect? Explain-( 2 marks) d) 20 hours extra of Wiring time became available .Evaluate the effect? Explain-( 2 marks) e) The profit per unit for TR29 was increased by $5 per unit. Evaluate the effect (2 marks) f) Identify the range of optimality for the objective function coefficient BR768 (unit profit).(1 marks) g) Suppose the profit for the XJ model is increased by $5 per unit, the profit for the XM model is decreased by $1 per unit, and the profit for the TR MODEL is increased by $4 per unit and for BR model is increased by 3. ( use the 100% rule)What will be the new optimal solution be? 2 marks h) If the Minimum capacity of XJ201 is increased by 10 , evaluate the effect. 2 marks i) What are the allowable values within which the minimum capacity for TR29 can vary without affecting the shadow price ?- (1 mark) j) Is the problem degenerate? Explain! (2 marks) k) Are there alternative optima in this problem? Explain (2 marks) Microsoft Excel 15.0 Answer Report Worksheet: [Assignment 1 S2 2020-21 solution.xlsx]Sheet2 Report Created: 13/02/2021 14:37:15 Objective Cell (Max) Cell Name Original Value Final Value $F$4 profit 12350.00004 12350 Variable Cells Cell Name Original Value Final Value Integer $B$3 number of units XJ201 149.999999 150 Contin $C$3 number of units XM897 300.000004 300 Contin $D$3 number of units TR29 200 200 Contin $E$3 number of units BR768 400 400 Contin Constraints Cell Name Cell Value Formula Status Slack $F$10 XJ201 LHS 150 $F$10>=$H$10 Binding 0 $F$11 XM897 LHS 300 $F$11>=$H$11 Not Binding 200 $F$12 TR29 LHS 200 $F$12>=$H$12 Binding 0 $F$13 BR768 LHS 400 $F$13>=$H$13 Binding 0 $F$6 WIRING LHS 1225 $F$6<=$H$6 Not Binding 275 $F$7 DRILLING LHS 2350 $F$7<=$H$7 Binding 0 $F$8 ASSEMLY LHS 2500 $F$8<=$H$8 Not Binding 100 $F$9 INSPECTION LHS 675 $F$9<=$H$9 Not Binding 525 Microsoft Excel 15.0 Sensitivity Report Worksheet: [Assignment 1 S2 2020-21 solution.xlsx]Sheet2 Report Created: 13/02/2021 14:37:16 Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$3 number of units XJ201 150 0 9 27 1E+30 $C$3 number of units XM897 300 0 12 1E+30 4.5 $D$3 number of units TR29 200 0 15 9 1E+30 $E$3 number of units BR768 400 0 11 25 1E+30 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $F$10 XJ201 LHS 150 -27 150 66.66666667 10 $F$11 XM897 LHS 300 0 100 200 1E+30 $F$12 TR29 LHS 200 -9 200 100 14.28571429 $F$13 BR768 LHS 400 -25 400 66.66666667 10 $F$6 WIRING LHS 1225 0 1500 1E+30 275 $F$7 DRILLING LHS 2350 12 2350 25 200 $F$8 ASSEMLY LHS 2500 0 2600 1E+30 100 $F$9 INSPECTION LHS 675 0 1200 1E+30 5