Homework Help is Here – Start Your Trial Now!
Business
Operations Management
Your bakery makes a variety of products: cookies, cupcakes, muffins, and donuts. You want to maximize your profit by optimizing the mix of products you make. You cannot use any more materials or labor than is available, nor do you want to make more goods than the amount that is demanded because the excess would go to waste. You only make batches of a complete dozen, so make sure the changing cells are integers. Use Solver to calculate the optimal number of dozens of product to make. Cookies Cupcakes Muffins Donuts Produced in dozens 125 163 400 293 Demand in dozens 600 500 400 300 Price/Dozen $2.50 $3.25 $3.50 $5.00 Cost/Dozen $1.80 $1.50 $2.00 $2.70 Profit/Dozen $0.70 $1.75 $1.50 $2.30 Materials used per dozen Flour 0.5 1.25 1.75 3.25 Sugar 0.3 0.75 0.3 0.75 Eggs 0.4 1 1 2 Butter 0.2 0.3 0.25 0.25 Chocolate Chips 0.5 0.5 Labor Hours 0.5 0.4 0.4 0.6 Used Available Flour 1920 2000 Sugar 500 500 Eggs 1200 1200 Butter 247 500 Chocolate Chips 262 600 Labor Hours 464 800 Profit $1,648.00

Your bakery makes a variety of products: cookies, cupcakes, muffins, and donuts. You want to maximize your profit by optimizing the mix of products you make. You cannot use any more materials or labor than is available, nor do you want to make more goods than the amount that is demanded because the excess would go to waste. You only make batches of a complete dozen, so make sure the changing cells are integers. Use Solver to calculate the optimal number of dozens of product to make. Cookies Cupcakes Muffins Donuts Produced in dozens 125 163 400 293 Demand in dozens 600 500 400 300 Price/Dozen $2.50 $3.25 $3.50 $5.00 Cost/Dozen $1.80 $1.50 $2.00 $2.70 Profit/Dozen $0.70 $1.75 $1.50 $2.30 Materials used per dozen Flour 0.5 1.25 1.75 3.25 Sugar 0.3 0.75 0.3 0.75 Eggs 0.4 1 1 2 Butter 0.2 0.3 0.25 0.25 Chocolate Chips 0.5 0.5 Labor Hours 0.5 0.4 0.4 0.6 Used Available Flour 1920 2000 Sugar 500 500 Eggs 1200 1200 Butter 247 500 Chocolate Chips 262 600 Labor Hours 464 800 Profit $1,648.00

Practical Management Science
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 33P: Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand...
See similar textbooks
icon
Related questions
Question

Please provide formula and answer

Your bakery makes a variety of products: cookies, cupcakes, muffins, and donuts. You want to maximize your profit by optimizing the mix of products you make. You cannot use any more materials or labor than is available, nor do you want to make more goods than the amount that is demanded because the excess would go to waste. You only make batches of a complete dozen, so make sure the changing cells are integers. Use Solver to calculate the optimal number of dozens of product to make. Cookies Cupcakes Muffins Donuts Produced in dozens 125 163 400 293 Demand in dozens 600 500 400 300 Price/Dozen $2.50 $3.25 $3.50 $5.00 Cost/Dozen $1.80 $1.50 $2.00 $2.70 Profit/Dozen $0.70 $1.75 $1.50 $2.30 Materials used per dozen Flour 0.5 1.25 1.75 3.25 Sugar 0.3 0.75 0.3 0.75 Eggs 0.4 1 1 2 Butter 0.2 0.3 0.25 0.25 Chocolate Chips 0.5 0.5 Labor Hours 0.5 0.4 0.4 0.6 Used Available Flour 1920 2000 Sugar 500 500 Eggs 1200 1200 Butter 247 500 Chocolate Chips 262 600 Labor Hours 464 800 Profit $1,648.00
Transcribed Image Text:Your bakery makes a variety of products: cookies, cupcakes, muffins, and donuts. You want to maximize your profit by optimizing the mix of products you make. You cannot use any more materials or labor than is available, nor do you want to make more goods than the amount that is demanded because the excess would go to waste. You only make batches of a complete dozen, so make sure the changing cells are integers. Use Solver to calculate the optimal number of dozens of product to make. Cookies Cupcakes Muffins Donuts Produced in dozens 125 163 400 293 Demand in dozens 600 500 400 300 Price/Dozen $2.50 $3.25 $3.50 $5.00 Cost/Dozen $1.80 $1.50 $2.00 $2.70 Profit/Dozen $0.70 $1.75 $1.50 $2.30 Materials used per dozen Flour 0.5 1.25 1.75 3.25 Sugar 0.3 0.75 0.3 0.75 Eggs 0.4 1 1 2 Butter 0.2 0.3 0.25 0.25 Chocolate Chips 0.5 0.5 Labor Hours 0.5 0.4 0.4 0.6 Used Available Flour 1920 2000 Sugar 500 500 Eggs 1200 1200 Butter 247 500 Chocolate Chips 262 600 Labor Hours 464 800 Profit $1,648.00
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 3 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Marketing
Marketing
Marketing
ISBN:
9780357033791
Author:
Pride, William M
Publisher:
South Western Educational Publishing
MARKETING 2018
MARKETING 2018
Marketing
ISBN:
9780357033753
Author:
Pride
Publisher:
CENGAGE L
Foundations of Business (MindTap Course List)
Foundations of Business (MindTap Course List)
Marketing
ISBN:
9781337386920
Author:
William M. Pride, Robert J. Hughes, Jack R. Kapoor
Publisher:
Cengage Learning
Foundations of Business - Standalone book (MindTa…
Foundations of Business - Standalone book (MindTa…
Marketing
ISBN:
9781285193946
Author:
William M. Pride, Robert J. Hughes, Jack R. Kapoor
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS