A B C D E F G H J K M 123456789 10 11 12 13 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 any more than demanded because they would go to waste. We are only going to make batches of a complete dozen, so be sure to make sure the changing cells are integers. Use Solver to calculate the optimal number of dozens of product to make. Cookies Cupcakes Muffins Donuts 14 Produced in dozens 1 1 1 1 15 Demand in dozens 600 500 400 300 16 17 Price/Dozen 18 Cost/Dozen 19 Profit/Dozen $2.50 $3.25 $3.50 $5.00 $1.80 $1.50 $2.00 $2.70 $0.70 $1.75 $1.50 $2.30 20 21 Materials used per dozen 22 Flour 0.5 1.25 1.75 3.25 23 Sugar 0.3 0.75 0.3 0.75 24 Eggs 0.4 1 1 2 25 Butter 0.2 0.3 0.25 0.25 26 Chocolate Chips 0.5 0 0.5 0 27 Labor Hours 0.5 0.4 0.4 0.6 28 29 Used Available 30 Flour 6.75 2000 31 Sugar 2.1 500 32 Eggs 4.4 1200 33 Butter 1 500 34 Chocolate Chips 1 600 35 Labor Hours 1.9 800 36 37 Profit $6.25 38 39 40 41 42 43 ss Ready Event Profit Past Events PivotTable Questions Bakery ++ Accoccibilita Inuortigato
A B C D E F G H J K M 123456789 10 11 12 13 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 any more than demanded because they would go to waste. We are only going to make batches of a complete dozen, so be sure to make sure the changing cells are integers. Use Solver to calculate the optimal number of dozens of product to make. Cookies Cupcakes Muffins Donuts 14 Produced in dozens 1 1 1 1 15 Demand in dozens 600 500 400 300 16 17 Price/Dozen 18 Cost/Dozen 19 Profit/Dozen $2.50 $3.25 $3.50 $5.00 $1.80 $1.50 $2.00 $2.70 $0.70 $1.75 $1.50 $2.30 20 21 Materials used per dozen 22 Flour 0.5 1.25 1.75 3.25 23 Sugar 0.3 0.75 0.3 0.75 24 Eggs 0.4 1 1 2 25 Butter 0.2 0.3 0.25 0.25 26 Chocolate Chips 0.5 0 0.5 0 27 Labor Hours 0.5 0.4 0.4 0.6 28 29 Used Available 30 Flour 6.75 2000 31 Sugar 2.1 500 32 Eggs 4.4 1200 33 Butter 1 500 34 Chocolate Chips 1 600 35 Labor Hours 1.9 800 36 37 Profit $6.25 38 39 40 41 42 43 ss Ready Event Profit Past Events PivotTable Questions Bakery ++ Accoccibilita Inuortigato
Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
Chapter16: Manufacturing Accounting (mfg)
Section: Chapter Questions
Problem 4R: Open MFG2 and click the Chart sheet tab. The management of Twisp is convinced that the quality of...
Related questions
Question
Bakery
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 any more than demanded because they would go to waste. We are only going to make batches of a complete dozen, so be sure to make sure the changing cells are integers. Use Solver to calculate the optimal number of dozens of product to make.
| Use Solver to calculate the optimal number of dozens of product to make. Be sure to save your work. |
Transcribed Image Text:A
B
C
D
E
F
G
H
J
K
M
123456789
10
11
12
13
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 any more than demanded because they would go to
waste. We are only going to make batches of a complete
dozen, so be sure to make sure the changing cells are
integers. Use Solver to calculate the optimal number of
dozens of product to make.
Cookies Cupcakes Muffins Donuts
14
Produced in dozens
1
1
1
1
15
Demand in dozens
600
500
400
300
16
17
Price/Dozen
18
Cost/Dozen
19
Profit/Dozen
$2.50
$3.25
$3.50
$5.00
$1.80
$1.50
$2.00
$2.70
$0.70
$1.75
$1.50
$2.30
20
21
Materials used per dozen
22
Flour
0.5
1.25
1.75
3.25
23
Sugar
0.3
0.75
0.3
0.75
24
Eggs
0.4
1
1
2
25
Butter
0.2
0.3
0.25
0.25
26
Chocolate Chips
0.5
0
0.5
0
27
Labor Hours
0.5
0.4
0.4
0.6
28
29
Used Available
30
Flour
6.75
2000
31
Sugar
2.1
500
32
Eggs
4.4
1200
33
Butter
1
500
34
Chocolate Chips
1
600
35
Labor Hours
1.9
800
36
37
Profit
$6.25
38
39
40
41
42
43
ss
Ready
Event Profit
Past Events
PivotTable Questions
Bakery
++ Accoccibilita Inuortigato
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Recommended textbooks for you
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Essentials of Business Analytics (MindTap Course …
Statistics
ISBN:
9781305627734
Author:
Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:
Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Essentials of Business Analytics (MindTap Course …
Statistics
ISBN:
9781305627734
Author:
Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:
Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College