In addition to selling cheese pizzas for $7, supreme pizzas for $12 and calzones

Question

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? I have to use Solver in Excel. How would I go about that? Thanks!

Explanation / Answer

Maximize

C- Cheese Pizza, S - Supreme Pizza, Z- Calzones, V- Vegetarian Pizza, P- Pepperoni Pizza

7C+ 12S+ 6Z + 10.5V + 9.75P

Constraints c+ s+z+v+p < =950

s+v<= 300

c+s+v+p<= 550

s<= 250

Quantity of each product as answer for maximum revenue.

c= 0,s= 250,z= 400, v=50, p =250

Now,to use solver,

set the function to maximize as the target cell,

Add the above constraints in the constraints

the 5 variables as to change and click on solve to solve for the solution.

The max revenue we get is 8362.5

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.