=E*

a. Formulate and solve a linear programming model on a spreadsheet for this revised version of the problem.

b. Formulate this same model algebraically.

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?

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 below 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.