oducts you make. You cannot use any more materials or labor than is ailable, nor do you want to make more goods than the amount that demanded because the excess would go to waste. You only make tches of a complete dozen, so make sure the changing cells are cegers. Use Solver to calculate the optimal number of dozens of oduct to make. Donuts Cookies Cupcakes Muffins 50 oduced in dozens mand in dozens 50 50 50 600 500 400 300 ce/Dozen st/Dozen $2.50 $3.25 $3.50 $5.00 $1.80 $1.50 $2.00 $2.70 ofit/Dozen $0.70 $1.75 $1.50 $2.30 aterials used per dozen lour Fugar 0.5 1.25 1.75 3.25 0.3 0.75 0.3 0.75 ggs utter Chocolate Chips abor Hours 0.4 1 1 2 0.2 0.3 0.25 0.25 0.5 0.5 0.5 0.4 0.4 0.6
oducts you make. You cannot use any more materials or labor than is ailable, nor do you want to make more goods than the amount that demanded because the excess would go to waste. You only make tches of a complete dozen, so make sure the changing cells are cegers. Use Solver to calculate the optimal number of dozens of oduct to make. Donuts Cookies Cupcakes Muffins 50 oduced in dozens mand in dozens 50 50 50 600 500 400 300 ce/Dozen st/Dozen $2.50 $3.25 $3.50 $5.00 $1.80 $1.50 $2.00 $2.70 ofit/Dozen $0.70 $1.75 $1.50 $2.30 aterials used per dozen lour Fugar 0.5 1.25 1.75 3.25 0.3 0.75 0.3 0.75 ggs utter Chocolate Chips abor Hours 0.4 1 1 2 0.2 0.3 0.25 0.25 0.5 0.5 0.5 0.4 0.4 0.6
MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
Related questions
Question
bakery
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
50
50
50
50
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
Eggs
0.3
0.75
0.3
0.75
0.4
1
1
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
337.5
2000
Sugar
105
500
Eggs
220
1200
Butter
50
500
Chocolate Chips
50
600
Labor Hours
95
800
Profit
$312.50
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 3 images
Recommended textbooks for you
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman