Paper instructions:

    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)
    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 are able to deduce each number.                               (5 marks)
    1. 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)
    1. 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)
    1. 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)
    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)
  1. 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)
  2. Tired of low grades? We can help you write a successful essay that will boost your grades.
    Order With Us Today!

Never use plagiarized sources. Get Your Original Essay on
Write the Excel Formula for Cells B6 and D9.   
Hire Professionals Just from $11/Page
Order Now Click here
Open chat
Lets chat on via WhatsApp
Hello, Welcome to our WhatsApp support. Reply to this message to start a chat.