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