wd 19-23 - Maximum Cakes 200 Price $16.95 Profit Margin 20...

Info iconThis preview shows pages 1–6. Sign up to view the full content.

View Full Document Right Arrow Icon
Wilfredo De Leon 2a57e0a8438bc6291c1bc524a9cceee0fb33c6bc.xls Scenario Summary 10/30/2010 Scenario Summary Current Values: 1%Multiplier 3%Ultiplier 2%Multiplier Changing Cells: ExtraCakes 25 50 17 25 Result Cells: $D$13 $720.38 $678.00 $715.67 $720.38 Notes: Current Values column represents values of changing cells at time Scenario Summary Report was created. Changing cells for each scenario are highlighted in gray.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Wilfredo De Leon 2a57e0a8438bc6291c1bc524a9cceee0fb33c6bc.xls EasterCakes 10/30/2010 Klassy Kow Ice Cream Shop Easter Rainbow Ice Cream Cake Shop Capacity
Background image of page 2
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Background image of page 4
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Background image of page 6
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Maximum Cakes 200 Price $16.95 Profit Margin 20% Over Capacity Extra Cakes 25 Multiplier 2% Profit From: Shop Capacity 678.00 Over Capacity 42.38 Total Profit $720.38 The formula to determine profit for cakes over 20 Price*Profit Margin*Extra Cakes*(1-Multiplier*Ex Cakes). If each cake made can be sold, how ma cakes should a shop make to maximize profits? Wilfredo De Leon 2a57e0a8438bc6291c1bc524a9cceee0fb33c6bc.xls EasterCakes 10/30/2010 00 is xtra any 1%Multiplier Page 4 50 3%Ultiplier Page 5 16.67 2%Multiplier Page 6 25...
View Full Document

{[ snackBarMessage ]}

Page1 / 6

wd 19-23 - Maximum Cakes 200 Price $16.95 Profit Margin 20...

This preview shows document pages 1 - 6. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online