Skip (a), (b), and (e). Use the Sensitivity Report below to answer (c), (d), and the question (f) below.Explain your reasoning referencing shadow price, reduced cost, range of feasibility, range of optimality, etc. where appropriate.

(f) A new supplier offers you 22 tons of grade A beans for $1600. You must buy all 22 tons or none at all. Should you accept the offer? If yes, how do the optimal solution and optimal profit change? Remember to consider the cost of the additional beans.

9. Jessica Kirst is the new owner of Coffee Country Roasters. They roast and blend coffee to sell on the internet. Their best sellers are "Best Blend" and "Economy Blend" coffee. Both are blended from three basic grades of coffee: Best blend: 50% grade A,20% grade B, and 30% grade C Economy: 20% grade A,50% grade B, and 30% grade C The firm is given the option of buying up to 100 tons of grade A, 100 tons of grade B, and 75 tons of grade C. The profit on the Best Blend is $150 per ton and the profit on the Economy Blend is $120 per ton. Jessica would like to maximize her profit. a. Formulate this problem as a linear program. b. Solve this problem using Excel Solver. (Turn in a copy of your spreadsheet and the formulas used in it.) Using the sensitivity report from Solver, answer parts ce. Do not resolve the problem to answer these questions. Treat each question separate from the others. c. The profit on Economy Blend coffee has dropped by $10 due to a bad economy. What impact will this have on our production plan and total profit? d. The bean broker just called to tell you that due to some flooding only 80 tons of grade B beans are available. How will this affect your production plan and profit? e. After you signed the contract for the purchase of beans according to your LP, another broker sent you an e-mail offering 12 tons of grade C coffee beans for a total of $3,000. You cannot buy less than 12 tons for this deal. Will you take this deal? Will this affect your production plan and profit? YES / NO Variable Cells Constraints