1. The shadow price and allowable range for constraint 1 and 2 are missing from the sensitivity report. What are the shadow price and allowable range for constraint 1 and 2? Explain how you can deduce each number. (5 marks)

If the profit of Item A is $7 instead of $10, do the optimal quantity change? Do the total profit change and by how much?

3. Given the Spreadsheet and sensitivity report below, answer the following questions without using Excel Solver. (**Note: each part is independent, i.e. any change made in one part does not apply to any other parts.) A B C D E F | Item A 3 Profit for Unit 10 4 Quantity Item B 12 Total Profit A Item B > Item 2 5 2 3 9 Constraint 1 10 Constraint 2 11 Constraint 3 12 Constraint 4 4 Available 120 520 230 300 vil v 300