Hi Pastry Sales Mix Objective (target cell) • To maximize Total Contribution Margin Variable (changing cells) Constraints ● ● I Pounds made for the various pastries Pastries made cannot exceed Demand Flour used cannot exceed 3000 ounce Eggs used cannot exceed 1500 pieces Labor used cannot exceed 4500 man-hour At least 100 Banana Muffins must be produced (it's famous for banana muffins) Required 1. Submit a workbook that includes the maximum TCM, the variables and the constraints 2. The workbook should include the Answer Report, the Sensitivity Report and the Limits Report 12 st L8 Get & Transform Data 4 6 7 1 2 Available Product 3 8 9 10 11 12 13 A 14 15 16 17 18 19 20 All :X ✓ fx B Pounds made Workbook Links Queries & Connections 3000 Flour (ounce) 1500 Egg (piece) 4500 Labor (man-hour) Unit Price Variable Cost Demand UCM Adiucted C 3.2 1.5 6 D $12.50 $6.50 960 $6.00 2.6 1.5 5 Data Types $11.00 $5.70 928 $5.30 E 1.5 1 4 <1 $9.00 $3.60 1041 $5.40 F 0 0 0 0 Banana Muffin Choc Muffin Banana Cookies Choc Cookies Milk Bread White Bread 0.7 0.3 0.5 0 2.5 1.5 $6.00 $3.00 $2.20 $1.20 1084 1055 $3.80 $1.80 AV 0 0.8 1 3 G $7.00 $2.80 977 $4.20 Sort & Filter H Advanced 0
Hi Pastry Sales Mix Objective (target cell) • To maximize Total Contribution Margin Variable (changing cells) Constraints ● ● I Pounds made for the various pastries Pastries made cannot exceed Demand Flour used cannot exceed 3000 ounce Eggs used cannot exceed 1500 pieces Labor used cannot exceed 4500 man-hour At least 100 Banana Muffins must be produced (it's famous for banana muffins) Required 1. Submit a workbook that includes the maximum TCM, the variables and the constraints 2. The workbook should include the Answer Report, the Sensitivity Report and the Limits Report 12 st L8 Get & Transform Data 4 6 7 1 2 Available Product 3 8 9 10 11 12 13 A 14 15 16 17 18 19 20 All :X ✓ fx B Pounds made Workbook Links Queries & Connections 3000 Flour (ounce) 1500 Egg (piece) 4500 Labor (man-hour) Unit Price Variable Cost Demand UCM Adiucted C 3.2 1.5 6 D $12.50 $6.50 960 $6.00 2.6 1.5 5 Data Types $11.00 $5.70 928 $5.30 E 1.5 1 4 <1 $9.00 $3.60 1041 $5.40 F 0 0 0 0 Banana Muffin Choc Muffin Banana Cookies Choc Cookies Milk Bread White Bread 0.7 0.3 0.5 0 2.5 1.5 $6.00 $3.00 $2.20 $1.20 1084 1055 $3.80 $1.80 AV 0 0.8 1 3 G $7.00 $2.80 977 $4.20 Sort & Filter H Advanced 0
Chapter1: Making Economics Decisions
Section: Chapter Questions
Problem 1QTC
Related questions
Question
Transcribed Image Text:Hi
Pastry Sales Mix
Objective (target cell)
• To maximize Total Contribution Margin
Variable (changing cells)
Constraints
●
●
I
Pounds made for the various pastries
Pastries made cannot exceed Demand
Flour used cannot exceed 3000 ounce
Eggs used cannot exceed 1500 pieces
Labor used cannot exceed 4500 man-hour
At least 100 Banana Muffins must be produced (it's famous for banana muffins)
Required
1. Submit a workbook that includes the maximum TCM, the variables and the constraints
2. The workbook should include the Answer Report, the Sensitivity Report and the
Limits Report
Transcribed Image Text:12
st
L8
Get & Transform Data
4
6
7
1
2 Available Product
3
8
9
10
11
12
13
A
14
15
16
17
18
19
20
All
:X ✓ fx
B
Pounds made
Workbook Links
Queries & Connections
3000 Flour (ounce)
1500 Egg (piece)
4500 Labor (man-hour)
Unit Price
Variable Cost
Demand
UCM
Adiucted
C
3.2
1.5
6
D
$12.50
$6.50
960
$6.00
2.6
1.5
5
Data Types
$11.00
$5.70
928
$5.30
E
1.5
1
4
<1
$9.00
$3.60
1041
$5.40
F
0
0
0
0
Banana Muffin Choc Muffin Banana Cookies Choc Cookies Milk Bread White Bread
0.7
0.3
0.5
0
2.5
1.5
$6.00
$3.00
$2.20
$1.20
1084
1055
$3.80
$1.80
AV
0
0.8
1
3
G
$7.00
$2.80
977
$4.20
Sort & Filter
H
Advanced
0
AI-Generated Solution
AI-generated content may present inaccurate or offensive content that does not represent bartleby’s views.
Unlock instant AI solutions
Tap the button
to generate a solution
Recommended textbooks for you
Principles of Economics (12th Edition)
Economics
ISBN:
9780134078779
Author:
Karl E. Case, Ray C. Fair, Sharon E. Oster
Publisher:
PEARSON
Engineering Economy (17th Edition)
Economics
ISBN:
9780134870069
Author:
William G. Sullivan, Elin M. Wicks, C. Patrick Koelling
Publisher:
PEARSON
Principles of Economics (12th Edition)
Economics
ISBN:
9780134078779
Author:
Karl E. Case, Ray C. Fair, Sharon E. Oster
Publisher:
PEARSON
Engineering Economy (17th Edition)
Economics
ISBN:
9780134870069
Author:
William G. Sullivan, Elin M. Wicks, C. Patrick Koelling
Publisher:
PEARSON
Principles of Economics (MindTap Course List)
Economics
ISBN:
9781305585126
Author:
N. Gregory Mankiw
Publisher:
Cengage Learning
Managerial Economics: A Problem Solving Approach
Economics
ISBN:
9781337106665
Author:
Luke M. Froeb, Brian T. McCann, Michael R. Ward, Mike Shor
Publisher:
Cengage Learning
Managerial Economics & Business Strategy (Mcgraw-…
Economics
ISBN:
9781259290619
Author:
Michael Baye, Jeff Prince
Publisher:
McGraw-Hill Education