Scribd
Upload
76 views3 pages

Sales Forecast Scenarios and Analysis

The document summarizes three scenarios for a sales forecast model. The default scenario has sales growth of 5%, cost of goods sold of 20%, and expenses of 28%. Scenario 1 modifies sales growth to 8%, cost of goods sold to 18%, and expenses to 20%. Scenario 2 modifies sales growth to 2%, cost of goods sold to 25%, and expenses to 35%. Scenario 1 is categorized as the best scenario, the default scenario is most likely, and scenario 2 is the worst.

Uploaded by

Ankit Bavishi
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
76 views3 pages

Sales Forecast Scenarios and Analysis

The document summarizes three scenarios for a sales forecast model. The default scenario has sales growth of 5%, cost of goods sold of 20%, and expenses of 28%. Scenario 1 modifies sales growth to 8%, cost of goods sold to 18%, and expenses to 20%. Scenario 2 modifies sales growth to 2%, cost of goods sold to 25%, and expenses to 35%. Scenario 1 is categorized as the best scenario, the default scenario is most likely, and scenario 2 is the worst.

Uploaded by

Ankit Bavishi
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Scenario Summary

Current Values: Default S1 S2


Changing Cells:
$G$9 5% 5% 8% 2%
$G$10 20% 20% 18% 25%
$G$12 28% 28% 20% 35%
Result Cells:
$B$13 $ 130,000.00 $ 130,000.00 $ 130,000.00 $ 130,000.00
$C$13 $ 136,500.00 $ 136,500.00 $ 140,400.00 $ 132,600.00
$D$13 $ 136,500.00 $ 136,500.00 $ 140,400.00 $ 132,600.00
$E$13 $ 136,500.00 $ 136,500.00 $ 140,400.00 $ 132,600.00
$F$13 $ 539,500.00 $ 539,500.00 $ 551,200.00 $ 527,800.00
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.

Best: S1
Most Likely: Default
Worst: S2
Create sheet for following values
1. where the Sales_Growth percentage is 5%,Cost of Goods Sold(COGS) is 20%, and Expenses is 28%
2. All values for Qtr2 to Qtr4 are same
3. Calculate Total for all Qtrs

Sales Forecast for 2008


Qtr1 Qtr2 Qtr3 Qtr4
Sales $ 250,000.00 $ 262,500.00 $ 262,500.00 $ 262,500.00
Cost of goods sold $ 50,000.00 $ 52,500.00 $ 52,500.00 $ 52,500.00
Gross profit $ 200,000.00 $ 210,000.00 $ 210,000.00 $ 210,000.00
expenses $ 70,000.00 $ 73,500.00 $ 73,500.00 $ 73,500.00
Income $ 130,000.00 $ 136,500.00 $ 136,500.00 $ 136,500.00

4. Create scenarios for following values:


a. where the Sales_Growth percentage is 8%, COGS is 18%, and Expenses is 20%
b. where the Sales_Growth percentage is 2%, COGS is 25%, and Expenses is 35%
5. Categorise three scenarios as Best, Most Likely and Worst?
nd Expenses is 28%

Total Assumptions
$ 1,037,500.00 5%
$ 207,500.00 20%
$ 830,000.00
$ 290,500.00 28%
$ 539,500.00

You might also like