Problem 2(35%):Chapter 3-Question 9, parts a and b only.Do not complete parts c, d, or e. Formulate the problem in a textbox alongside the spreadsheet model. In addition to the instructions in the textbook, Make a 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 $700lton for Economy. The rm 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 prot on the Best Blend is $150 per ton and the prot 0n the Economy Blend is $120 per ton. Jessica would like to maximize her prot. 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 prob- lem to answer these questions. Treat each question separate from the others