Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Help me with the Excel Model, please.. I have got the equations sorted I just want help with Excel Model Tell me what to put

Help me with the Excel Model, please.. I have got the equations sorted I just want help with Excel Model

Tell me what to put in the excel to make a model pleaseeeee

Bryant's Pizza, Inc., is a producer of frozen pizza products. The company makes a profit of $1.00 for each pepperoni pizza it produces and $1.50 for each double-pepperoni pizza produced. Each pizza includes a combination of dough mix and topping mix. The firm currently has 150 pounds of dough mix and 50 pounds of topping mix. Each pepperoni pizza uses one pound of dough mix and 4 ounces of topping mix. Each double-pepperoni pizza uses one pound of dough mix and 8 ounces of topping mix. It takes 15 minutes to cook a pepperoni pizza, while it takes 20 minutes to cook a double-pepperoni pizza. Bryant has 50 hours of cooking time available. Based on past demand Bryant can sell at least 50 pepperoni pizzas and at least 25 double-pepperoni pizzas. How many of each type should the company produce to maximize profits?

Explanation:

In order to maximize profits, the company should produce 50 pepperoni pizzas and 25 double pepperoni pizzas.

To maximize profits, the company should bake 50 pepperoni pizzas and 25 double-pepperoni pizzas. Because of these factors, the company will make a total profit of $75.

This requires us to first determine how much money we make from selling each pizza flavor. An individual pepperoni pizza, which requires one pound of dough mix and four ounces of topping mix, costs one dollar. It looks like the company makes $0.25 on every pizza they sell. One pound of dough mix and eight ounces of topping mix are needed to make a pizza with double the amount of pepperoni for $1.50. Based on these numbers, it appears that the company pockets $0.50 in profit from every pizza it sells.

Now comes the time to calculate how many of each pizza variety the business can actually sell. Based on past demand, the business can expect to sell at least 50 pepperoni pizzas and at least 25 double-pepperoni pizzas.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Financial Management For Decision Makers

Authors: Peter Atrill, Paul Hurley

2nd Canadian Edition

138011605, 978-0138011604

Students also viewed these General Management questions

Question

What role did Korean enterprises play in creating the 1997 crisis?

Answered: 1 week ago

Question

List the Holland vocational preferences. AppendixLO1

Answered: 1 week ago

Question

What is a career? AppendixLO1

Answered: 1 week ago