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	Ingredients 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
Pizza Price	$8.00	$10.00	$12.00	$15.00

The Pizza Man experts to use its entire stock of ingredients and wishes to maximize revenue from its sales.

Requirements:

1. Download the Excel template file and set up the model based on it. Answer all the questions listed in the file.

2. Please define the appropriate range names to make the Solver configuration more readable. Paste the used range names.

3. Run the sensitivity analysis using Solver.

4. Answer all the questions listed in the file.