Question 4 Interpretation of the MS Excel solution, Sensitivity Report, and Answer report to the linear programming model given below. You have found the report. Give a brief answer to each of the following questions. 1. Calculate the missing numbers (BLANKS 1, 2, 3). (3 marks) 2. With a specific numeric example, Interpret the ranges of optimality. (1 mark) 3. With a specific numeric example, define and interpret the reduced cost. (1 mark) 4. What would happen if the coefficients of "P2" increase to S60? Explain the reason. (1 mark) 5. What would happen if the right-hand side value for constraint number 3 decreases by 8? (1 mark) 6. Additional labour overtime of 25 hours has become available and will cost an additional $10 per hour (additional to the current cost of $20 per hour). To include this into the model, show the changes to the objective function and the constraints. (3 marks) SEE NEXT PAGE FOR THE LP EXCEL SOLUTIONS Question 4 Interpretation of the MS Excel solution, Sensitivity Report, and Answer report to the linear programming model given below. You have found the report. Give a brief answer to each of the following questions. 1. Calculate the missing numbers (BLANKS 1, 2, 3). (3 marks) 2. With a specific numeric example, Interpret the ranges of optimality. (1 mark) 3. With a specific numeric example, define and interpret the reduced cost. (1 mark) 4. What would happen if the coefficients of "P2" increase to S60? Explain the reason. (1 mark) 5. What would happen if the right-hand side value for constraint number 3 decreases by 8? (1 mark) 6. Additional labour overtime of 25 hours has become available and will cost an additional $10 per hour (additional to the current cost of $20 per hour). To include this into the model, show the changes to the objective function and the constraints. (3 marks) SEE NEXT PAGE FOR THE LP EXCEL SOLUTIONS