Question

Let’s build on the pizza parlor example from the notes. In addition to selling cheese pizzas for $7, supreme pizzas for $12 and calzones for $6, the pizza parlor will also sell vegetarian pizzas for $10.50 and pepperoni pizzas for $9.75. Because of limitations to the quantity of ingredients and oven capacity, the pizza parlor has the following constraints:

• Can only make 950 total items a day

• Can make a maximum of 550 pizzas total

• Can make a maximum of 250 supreme pizzas

• Can make a maximum of 300 pizzas containing peppers (this includes the supreme and vegetarian pizza)

Taking these constraints into account, what quantity of each item does the pizza parlor need to sell to maximize revenue? You need to use Solver.

Answer 1

Soln : Please refer here the solution

Type	Rates(in $)	Numbers	Revenue
Cheese pizzas	7.00	0	0.000
Supreme Pizzas	12.00	250	3000.000
Calzones	6.00	400	2400.000
Veg. Pizzas	10.50	50	525.000
Pepperoni pizzas	9.75	250	2437.500
Total		950	8363
Pizza Total		550
Pepper based pizza total		300

We have calculated using the solver, please refer the conditions here:

We have marked the conditions as given here in the ques. , please note we have taken last condition as pizzas containing pepper for only supreme and veg pizzas.