 |
|---|
| Formula Number | Forecast Equals |
|---|
| F1 = Q1 | on the average what we sold in the last 3 months times the seasonal curve. |
|---|
| F2 = (Q1 + Q2)/2 | on the average what we sold in the last 6 months times the seasonal curve. |
|---|
| F3=(Q1&Q2&Q3)/3 | on the average what we sold in the last 9 months times the seasonal curve. |
|---|
| F4=Y/4 | on the average what we sold last year times the seasonal curve. |
|---|
| F5=(Q1&Q1&Q2)/3 | on the average what we sold in the weighted average times the seasonal curve. |
|---|
| F6=Q1/3 | on the average 1/3 what we sold in the last 3 months times the seasonal curve. |
|---|
| F7=2(Q1/3) | on the average 2/3 what we sold in the last 3 month times the seasonal curve. |
|---|
| 8. | Not Used. |
|---|
| 9. | Not Used. |
|---|
| F10=Q4 | month by month what we sold last year. |
|---|
| F11=Q4(Q1/Q5) | month by month what we sold last year times the %+ or - in the past 3 months. |
|---|
| F12=Q4(Q1&Q2)/(Q5&Q6) | month by month what we sold last year times the %+ or - in the past 6 months. |
|---|
| F13=Q4(Q1&Q2&Q3)/(Q5&Q6&Q7) | month by month what we sold last year times the %+ or - in the past 9 months. |
|---|
| F14=Q4(TY/LY) | month by month what we sold last year times the %+ or - in the past year. |
|---|
| F15=Q4(Co%+/-) | month by month what we sold last year times the %+ or - using the company expectation. |
|---|
| 16. | Not Used. |
|---|
| 17. | Not Used. |
|---|
| 18. | Not Used. |
|---|
| 19. | Not Used. |
|---|
| 20. | Not Used. |
|---|
| F21=12(M1) | 12 times the current month's sales. |
|---|
| (MTD) | If MTD follows the formula , Month to Date sales was used for the period 1 forecast. |
|---|