Question: 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!