wd 19-18 - time Scenario Summary Report was created....

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

View Full Document Right Arrow Icon
Wilfredo De Leon a147c4f8db28a80f55e8964337b888277c900e34.xls Scenario Summary 10/30/2010 Scenario Summary Current Values: Modest Sales Best Sales Worst Sales Assumes low sales. Changing Cells: Oct 23,000 10,500 23,000 9,000 Nov 24,000 10,000 24,000 10,000 Dec 25,000 9,000 25,000 9,500 Result Cells: $B$5 $50,370.00 $22,995.00 $50,370.00 $19,710.00 NovDollars $52,560.00 $21,900.00 $52,560.00 $21,900.00 DecDollars $54,750.00 $19,710.00 $54,750.00 $20,805.00 $E$5 $157,680.00 $64,605.00 $157,680.00 $62,415.00 Notes: Current Values column represents values of changing cells at
Background image of page 1

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

View Full DocumentRight Arrow Icon
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 DocumentRight Arrow Icon
Background image of page 4
Background image of page 5
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: time Scenario Summary Report was created. Changing cells for each scenario are highlighted in gray. Assumes average sales. Assumes high sales. Wilfredo De Leon a147c4f8db28a80f55e8964337b888277c900e34.xls 4thQtr 10/30/2010 Klassy Kow Ice Cream, Inc. Oct Nov Dec Total Units 23,000 24,000 25,000 72,000 Revenue $50,370.00 $52,560.00 $54,750.00 $157,680.00 Shakes and Malteds Forecast Fourth Quarter Projected Sales Modest Sales Page 3 10500 10000 9000 Best Sales Page 4 23000 24000 25000 Worst Sales Page 5 9000 10000 9500...
View Full Document

This note was uploaded on 10/30/2010 for the course FINANCE Excel taught by Professor Vahn during the Spring '10 term at City College of San Francisco.

Page1 / 5

wd 19-18 - time Scenario Summary Report was created....

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

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