PLEASE FAST

B D Problem 1. G 2 3 4 Reconsider the Profit & Gambit Co. problem described in Section 2.7. Suppose that the estimated data given in Table 2.2 5 Ingredients 6 Stain Remover Liquid Detergent Powder Detergent Cost per Ad 8 9 Increase in TV 5 20 15 $4 Min Required Sales Increase (9) > 50 > 40 Ce 60 Print Media 15 5 2 $2 10 11 a. Formulate and solve a linear programming model on a spreadsheet for this revised version of the problem. 13 14 un WN b. Formulate this same model algebraically. 6 7 8 9 c. Use the graphical method to solve this model. d. What were the key changes in the data that caused your answer for the optimal solution to change from the one for the original version of the problem? 0 1 2 3 e. Write a paragraph to the management of the Profit & Gambit Co. presenting your conclusions from the above parts. Include the potential effect of further refining the key data in the above table. Also point out the leverage that your results might provide to management in negotiating a decrease in the unit cost for either of the advertising media. Make sure that all formulas and Solver parameters are saved in this worksheet before submission. Groun Details Problem 1 Problem 2 Problem 3 Problem 4