| | | | | Step 1 | Step 2 | Step 3 | | Step 4 | | | | Step 5 |
| | | | | | | "=abs(number)" | | 4th Quarter Budgeted Sales | | | | Look at the Sales (Revenue) total from your company's income statement. See image below. |
| Date | Day of Week | Closing Price | Opening Price | Change in Price | Multiplier | Absolute Value | | October | November | December |
| 12-Oct | Monday | $ 82.38 | $ 77.92 | 4.46 | $ 446,000.00 | 446,000 | October Sales | $ 1,207,000 | $ 1,218,000 | $ 1,274,000 |
| 13-Oct | Tuesday | $ 78.60 | $ 82.32 | -3.72 | $ (372,000.00) | 372,000 |
| 14-Oct | Wednesday | $ 79.67 | $ 79.29 | 0.38 | $ 38,000.00 | 38,000 |
| 15-Oct | Thursday | $ 76.19 | $ 77.74 | -1.55 | $ (155,000.00) | 155,000 |
| 16-Oct | Friday | $ 75.34 | $ 73.38 | 1.96 | $ 196,000.00 | 196,000 |
| 19-Oct | Monday | $ 70.83 | $ 70.58 | 0.25 | $ 25,000.00 | 25,000 | November Sales |
| 20-Oct | Tuesday | $ 74.87 | $ 72.62 | 2.25 | $ 225,000.00 | 225,000 |
| 21-Oct | Wednesday | $ 68.16 | $ 72.72 | -4.56 | $ (456,000.00) | 456,000 |
| 22-Oct | Thursday | $ 62.10 | $ 62.95 | -0.85 | $ (85,000.00) | 85,000 | | | | | | In this example, the annual total is 18,611. On average, this is revenue of $1,550.92 per month |
| 23-Oct | Friday | $ 69.92 | $ 65.65 | 4.27 | $ 427,000.00 | 427,000 | | | | | | You have to make your sales forecast make sense for your most recent income statement |
| 26-Oct | Monday | $ 58.59 | $ 60.32 | -1.73 | $ (173,000.00) | 173,000 | December Sales | | | | | Therefore, I will move the decimal three places in my forecast which will give me the following: |
| 27-Oct | Tuesday | $ 58.98 | $ 59.55 | -0.57 | $ (57,000.00) | 57,000 |
| 28-Oct | Wednesday | $ 56.33 | $ 55.38 | 0.95 | $ 95,000.00 | 95,000 |
| 29-Oct | Thursday | $ 61.41 | $ 56.23 | 5.18 | $ 518,000.00 | 518,000 | | | | | | 4th Quarter Budgeted Sales |
| 30-Oct | Friday | $ 58.03 | $ 62.34 | -4.31 | $ (431,000.00) | 431,000 | | | | | | October | November | December |
| | | | | | | | | | | | | $ 1,207 | $ 1,218 | $ 1,274 |
| | | | | | | | | | | | | This is the budgeted sales forecast I will use to make my Master Budget |
MaxZhou
TermAssignmentSalesForecastCalculations.xlsx
