Poppa Bills restaurant needs your help creating a spreadsheet to determine the best way to optimize the inventory in his pizza warehouse. Poppa Bill wants to maximize profits while ensuring he makes enough pizzas to fulfill demand. Poppa Bill will distribute the pizzas to his chain of restaurants and any additional pizzas will be sold online as take-and-bake direct from the central pizza warehouse. In a particular production process, three materials are used to produce five different pizzas. The available ingredients for making the pizzas include the following:

Poppa Bills Pizzas

	Meat Lovers	Cheese	Vegetarian	Classic Italian	The Hawaiian
Sale Price	20	15	18	15	18
Cost	15	8	12	9	12

Ingredients Required (In Grams)

	Meat Lovers	Cheese	Vegetarian	Classic Italian	The Hawaiian
Flour	1.5	1.5	2	2	2.5
Pepperoni	3.5	0	0	.5	.5
Peppers	0	0	3	1	0
Mushrooms	0	0	7	1	0
Sausage	6	0	0	0	4
Sundried Tomatoes	0	0	5	2	0
Cheese	3.5	9	3	2	2

Ingredients Available

	Amount Available in Grams
Flour	800
Pepperoni	600
Peppers	1000
Mushrooms	200
Sausage	500
Sundried Tomatoes	300
Cheese	1000

Define the decision variables (changing variables)

Define the objective function in terms of the decision variables

Write the constraints in terms of the decision variables

Using Linear Programming determine the maximum profit for Poppa Bill (use Excel Solver)