parts a and b only. Formulate the problem in a textbox alongside the spreadsheet model. In addition to the instructions in the textbook, create an Answer report. For part b, ignore the sentence, (Turn in a copy of your spreadsheet and the formulas used in it.).

9. Jessica Lyell 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 market prices are $790/ton for Best and $700/ton for Economy. The firm is given the option of buying up to 100 tons of grade A at $800/ton, 100 tons of grade B at $600/ton, and 75 tons of grade C at $400/ton. 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 c-e. Do not resolve the prob- lem to answer these questions. Treat each question separate from the others