Answered step by step
Verified Expert Solution
Link Copied!

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,

image text in transcribed

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 Solver

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Capital And Finance

Authors: Peter Lewin, Nicolás Cachanosky

1st Edition

0367514559, 978-0367514556

More Books

Students also viewed these Finance questions

Question

c. What were you expected to do when you grew up?

Answered: 1 week ago

Question

4. Describe how cultural values influence communication.

Answered: 1 week ago

Question

3. Identify and describe nine cultural value orientations.

Answered: 1 week ago