| 12
Months |
|
|
|
|
2005 |
2005 |
2005 |
2005 |
2005 |
2005 |
2005 |
2005 |
2005 |
2005 |
2005 |
2006 |
05-06 |
|
|
|
| to end Jan |
|
|
|
|
Feb |
Mar |
Apr |
May |
Jun |
Jul |
Aug |
Sep |
Oct |
Nov |
Dec |
Jan |
Year |
|
| MONTHLY ASSUMPTIONS No. 1 - SALES |
|
|
|
|
|
|
| |
|
|
|
Set cells below 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): |
|
|
|
|
|
|
|
|
|
|
|
|
|
Total |
|
| Group 1 |
|
<<->> |
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 |
|
| Group 2 |
|
<<->> |
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 |
|
| Group 3 |
|
<<->> |
|
|
|
| Group 4 |
|
<<->> |
|
|
|
| Group 5 |
|
<<->> |
|
|
|
| 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 |
|
316.6 |
316.6 |
| |
|
|
|
|
|
Note: Sales values will
not be reflected in cashflow projections until credit terms have been
specified in sheet M_B |
|
|
|
| Supplementary Data &
Calculations: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|