Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please show calculations in excel Problem 3 Let's build on the pizza parlor example from the notes. In addition to selling cheese pizzas for S7,
please show calculations in excel
Problem 3 Let's build on the pizza parlor example from the notes. In addition to selling cheese pizzas for S7, 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. Problem 3 Let's build on the pizza parlor example from the notes. In addition to selling cheese pizzas for S7, 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 SolverStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started