For Questions 4 and 5, please consider the following information. You are a manager at a starfighter production facility that is tasked with maximizing profits from making starfighters. One of your analysts has run a linear programming analysis to find the best combination of starfighters, and then performed a sensitivity analysis on the solution using Excel. This analyst has provided you with the following output. Product Final Value Reduced Cost Objective Coefficient Allowable Increase Allowable Decrease TIE 25,000 0 1500 750 1000 Interceptors TIE Defenders 10,000 0 2500 1000 1000 Constraint Final Value Shadow Price Laser Targeting Calibration 1500000 2500 4) Please provide a detailed interpretation of the numeric value that corresponds to each of the items below as it pertains to TIE Interceptors. Your interpretation of the Allowable Increase and Allowable Decrease should also include why a manager might be concerned with these values. Final Value: Objective Coefficient: Allowable Increase: Allowable Decrease: 5) Consider the shadow price of Laser Targeting Calibration above. What does this value tell us, and why might a manager be concerned about this value? + For Questions 4 and 5, please consider the following information. You are a manager at a starfighter production facility that is tasked with maximizing profits from making starfighters. One of your analysts has run a linear programming analysis to find the best combination of starfighters, and then performed a sensitivity analysis on the solution using Excel. This analyst has provided you with the following output. Product Final Value Reduced Cost Objective Coefficient Allowable Increase Allowable Decrease TIE 25,000 0 1500 750 1000 Interceptors TIE Defenders 10,000 0 2500 1000 1000 Constraint Final Value Shadow Price Laser Targeting Calibration 1500000 2500 4) Please provide a detailed interpretation of the numeric value that corresponds to each of the items below as it pertains to TIE Interceptors. Your interpretation of the Allowable Increase and Allowable Decrease should also include why a manager might be concerned with these values. Final Value: Objective Coefficient: Allowable Increase: Allowable Decrease: 5) Consider the shadow price of Laser Targeting Calibration above. What does this value tell us, and why might a manager be concerned about this value? +