| 12
Months |
|
|
|
|
2004 |
2004 |
2004 |
2004 |
2004 |
2004 |
2004 |
2004 |
2004 |
2004 |
2004 |
2004 |
2004 |
|
| to end Dec |
|
|
|
|
|
Jan |
Feb |
Mar |
Apr |
May |
Jun |
Jul |
Aug |
Sep |
Oct |
Nov |
Dec |
Year |
|
| ASSUMPTIONS
No. 1 - SALES TARGETS |
|
|
|
|
|
|
| |
|
|
|
Set cells in this row to
zero if not entering seasonal assumptions |
|
|
|
Total |
|
| Seasonal index |
|
->> |
31.00 |
28.00 |
31.00 |
30.00 |
31.00 |
30.00 |
31.00 |
31.00 |
30.00 |
31.00 |
30.00 |
31.00 |
365.0 |
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Sales
($000): |
|
|
|
Subgroup descriptions in blue can
be overwritten |
|
|
|
|
|
|
|
|
|
Total |
|
| Subgroup a |
|
<<->> |
17.0 |
17.5 |
18.0 |
18.5 |
19.0 |
19.5 |
20.0 |
20.5 |
21.0 |
21.5 |
22.0 |
22.5 |
237.0 |
|
| Subgroup b |
|
<<->> |
5.0 |
5.3 |
5.5 |
5.8 |
6.1 |
6.4 |
6.7 |
7.0 |
7.4 |
7.8 |
8.1 |
8.6 |
79.6 |
|
| Subgroup c |
|
<<->> |
|
|
|
| Subgroup d |
|
<<->> |
|
|
|
| Subgroup e |
|
<<->> |
|
|
|
| Total
sales ($000) |
|
|
22.0 |
22.8 |
23.5
|
24.3
|
25.1 |
25.9
|
26.7
|
27.5
|
28.4
|
29.3
|
30.1
|
31.1
|
316.6 |
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Note: Cashflows relating to sales
will not be calculated until values have been entered into table 2 at sheet
RecPay. |
|
| Supplementary Data &
Calculations: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|