MS electronics supply highly complex components for military communications systems. Four products, named the MX range, share the labor hours available for each of the four production processes: wiring, drilling, assembly and finishing. For each product and each process, the hours of labor required for each unit of production and the total hours available per month are shown in the table below. The table also shows the profit earned per unit for each product and the minimum monthly demand for that product. Product Hours of labour per production unit Minimum Profit per unit (type of component) Wiring Drilling Assembly Finishing Demand ($) Time Time Time Time (no. of units) MX1 0.5 0.6 0.2 0.5 20 15000 MX2 1.5 1.0 3.5 0.9 30 500 MX3 3.0 1.5 1.0 0.5 35 1800 MX4 1.0 2.5 2.0 0.6 25 900 Labor available 16000 18000 12000 10000 (hours per month) MS electronics need to know how many of each type of component they should produce each month to achieve their objective subject to unit profit figures and constraints mentioned above. This problem was formulated as a linear programming model and then solved using Microsoft's Excel Solver Add-in. The relevant Solver output is given in the Appendix. Using the Solver output and where necessary the information given above, answer the following questions. APPENDIX (please note Dem: Demand and 1E+30 = Infinity (no limit)) Objective Cell (Max) Cell Name Original Value Final Value $F$3 Objective 0 429940 Variable Cells Cell Name $B$2 MX1 $C$2 MX2 $D$2 MX3 $E$2 MX4 Original Value 0 0 0 0 Final Value 15884 500 2136 900 Integer Contin Contin Contin Contin Constraints Cell $F$10 $F$11 $F$12 $F$5 $F$6 $F$7 $F$8 $F$9 Name Dem (MX2) Dem (MX3) Dem (MX4) Wiring Drilling Assembly Finishing Dem (MX1) Cell Value 500 2136 900 16000 15484.4 8862.8 10000 15884 Formula $F$10>=$H$10 $F$11>=$H$11 $F$12>=$H$12 $F$5=$H$9 Status Binding Not Binding Binding Binding Not Binding Not Binding Binding Not Binding Slack 0 336 0 0 2515.6 3137.2 0 884 Variable Cells Cell $B$2 $C$2 $D$2 $E$2 Constraints Name MX1 MX2 MX3 MX4 Final Value 15884 500 2136 900 Reduced Cost 0 0 Objective Coefficient 20 30 35 25 Allowable Allowable Increase Decrease 15 1.35 9.6 1E+30 85 8.75 1.4 1E+30 0 0 Cell $F$10 $F$11 $F$12 $F$5 $F$6 $F$7 $F$8 $F$9 Name Dem (MX2) Dem (MX3) Dem (MX4) Wiring Drilling Assembly Finishing Dem (MX1) Final Value 500 2136 900 16000 15484 8863 10000 15884 Shadow Price -9.6 0 -1.4 6 0 0 34 0 Constraint R.H. Side 500 1800 900 16000 18000 12000 10000 15000 Allowable Allowable Increase Decrease 566.7 500 336 1E+30 850 900 2210 840 1E+30 2515.6 1E+30 3137.2 840 368.3 884 1E+30 Question 27 2.5 points Save Answer How much per month would an extra 1000 units of wiring time be worth to MS electronics? The problem will need to be resolved to answer this question. O $16,000 O $6,000 $1000 O $ 16,000,000 Question 28 2.5 points Save Answer How many of each type of component should MS electronics produce each month and what will the objective function value be? O 15884MX1; 500MX2: 2136MX3; & 900MX4. Objective Function 429940. 15884MX1; 500MX2; 2136MX3; & 900MX4. Objective Function 15884. O 15000MX1; 500MX2: 1800MX3 & 900MX4. Objective Function 429940. O 20MX1; 30MX2:35MX3; & 25MX4. Objective Function 15884. O 20MX1; 30MX2: 35MX3; & 25MX4. Objective Function 429940. Question 29 What is the objective function for this problem? Min Labor hours 16000MX1 + 18000MX2 + 12000MX3 + 10000MX4 Max Profit 20MX1 + 30MX2 + 35MX3 + 25MX4 Max Profit 16000MX1 + 18000MX2 + 12000MX3 + 10000MX4 Min Cost 20MX1 + 30MX2 + 35MX3 + 25MX4 O Max Demand 15000MX1 + 500MX2 + 1800MX3 + 900MX4 Question 30 2.5 points Save Answer MS electronics think that a change in manufacturing location could increase profits by reducing costs. The following scenario is thought to be possible: unit profit for the MX2 increases by 30% and simultaneously the MX3 increases by 20%. How would these changes impact the optimal solution? These changes are allowed. The value of the objective function will increase by 50%. These changes are not allowed. The problem will need to be resolved to find the new optimal solution. The same decision variables will be positive, but their values, the objective function value, and the dual prices will change. These changes are allowed. The value of the objective function will increase by $19,452. O Nothing. The values of the decision variables, the shadow (dual) prices, and the objective function value will all remain the same