Allocating Ingredients $(15$ points$)$

The 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 pizzas. Each variety has its own requirement for sauce, cheese, dough, and toppings $($in ounces,

as shown in the table$),$ and each has its own selling price. The Pizza Man expects to use its entire stock of ingredients and wishes to maximize revenues from its sales.

$(1)$ How many Supreme pizzas should be made? $($Assume that fractions can be sold$)$ What is the

maximum sales revenue? $(10$ points$)$

$(2)$ Is sauce economically scarce $($does it limit profits$)?(5$ points$)$

Respond with an Excel response