- Please, answer everything in excel formulas.

Ml 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, vegatable, and supreme pizza. Each variety has its own requirement for sauce, cheese dough, and toppings (in ounces), and each has its own selling price The Pizza Man experts to use its entire stock of ingredients and wishes to maximize revenue from its sales. 1. What mix of pizzas should be made? (Assume that fractions can be sold). What is the maximum sales revenue? 2. Is there any type of pizza not made in the final plan? If yes, how should the its price be adjusted so that it will be made? 3. Which ingredients are economically scarce (which ones limits profits)? 4. Investigate the solution for cheese availability. As available cheese increases from 90 ounces to 150 ounces by the increment of 5 ounces, will the pattern of pizza mix plan remain? (pattern means certain types produced and others not) If not, how will it change? How will the shadow price of cheese change? 5. If the meat usage in Supreme changes from 1.5 ounces to 2.5 ounces by the increment of 0.1 counce, will the pattern of pizza mix plan remain? (pattern means certain types produced and others not). If not, how will it change? How will the maximum sales revenue change accordingly? 23 Pizza Man pizza min problem 24 25 Input data 26 Type 27 Dough 28 Sauce 29 Cheese 30 Meat 31 Vegetables 32 Price Plain MeatVegetable Supreme Available 5 200 75 2 40 $8.00 $10.00 12.00 $15.00 34 Pizza mi plan 35 Type 36 Number of pizza 37 38 Constraints Meat Vegetable Supreme Used Ayailable 40 Dough 42 Cheese 43 Meat 44 Vegetables 45 46 Objective 7 Total revenue 48