1. 1. Write down the Excel formula for cells B6 and D9. (2 marks)
   2. Write down the Excel formula for cell D10 and its calculated value. (2 marks)
   3. What are the optimal quantities of Item A and Item B, and, total profit? (3 marks)
   4. What is the range of feasibility for RHS of Constraint 3? (2 marks)
2. 5. 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 are able to deduce each number. (5 marks)
3. 6. 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? (4 marks)
4. 7. If the profit of Item B is reduced by $2, do the optimal quantity change? Do the total profit change and by how much? (4 marks)
5. 8. If the profit of Item A is increased by 7 and the profit of Item B is decreased by $5, do the optimal quantity change? (5 marks)
6. 1. If the resources available for Constraint 4 decreases by 100, what will be the change to the total profit? Will the optimal quantity change? (4 marks)
7. J. Are you willing to pay $2 each for up to 15 more units of available resource in Constraint 3? Why or why not? (4 marks)

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