Problem 3 [35 points! The Moon Coffee Shop blends coffee on the premises for its customers. It sells three basic blends in lpound bags= Special. Moon Dark= and Moon Regular. It uses four different types of coffee to produce the blends Brazili an: Mocha: Columbian. and Mild. The shop used the following blend recipe requirements. {4 Mi: Requirements Selling Price-"pound (3) Special At least 40% Columbi an. at least 30% Mocha Dark At least 50% Brazilian: no more than 10% Mild Regular No more than 50% Mild: at least 30% Brazilian + R\" u The cost ofErazilian coffee is 33.00 per pound: the cost ofMocha is 53.?5 per pound: the cost of Wis 53.90 per pound: and the cost of Mild is 52.?0 per pound. The shop has 110 pounds ofBrazilian coffee: 7'0 pounds of Mocha: 30 pounds of Columbi an. and 150 pounds of Mild coffee available per week. The shop wants to know the amount of each blend it should prepare each steel: to maximize the profit [i.e., res'enne cost}. (a) Formulate algebraically the Linear Programming (LP) model for this problem. Define the decision variables, objective function, and constraints. (19 points) (b) Formulate this same linear programming problem on a spreadsheet and SOLVE using Excel Solver (Provide the corresponding "Excel Spreadsheet" and the "Answer Report"). Include "managerial statements" that communicate the results of the analyses (i.e. describe verbally the results). (16 points)