Product Mix Problem This Pizza Man is a local shop that plans to make all of its sales this Saturday from its sidewalk tables during the town's holiday parade. On this occasion, the shop's owners know that customers will buy by the slice and any kind of pizza offered will sell. The Pizza Man offers plain, meat, vegetable, and supreme pizza. Each variety has its own requirement for sauce, cheese, dough, and toppings (in ounces), and each has its own selling price. Plain Meat Vegetable Supreme Available
Dough 5 5 5 5 200
Sauce 3 3 3 3 90
Cheese 4 3 3 4 120
Meat 0 3 0 2 75
Vegetables 0 0 3 2 40
Price $8 $10 $12 $15

Required:
a. Write the Linear Program formulation for the above optimization problem. Make your formulation clear by defining the variables, constraints, objective function etc. clearly.
b. Solve it using Excel solver. Please attach your clearly annotated Solver model and output (including Answer and Sensitivity Report
c. What is the maximum sales revenue? What mix of pizzas should be made to achieve this sales revenue?
d. Which ingredients are economically scarce (i. e., they are limiting to profits)?