12
Months 




2005 
2005 
2005 
2005 
2005 
2005 
2005 
2005 
2005 
2005 
2005 
2006 
0506 



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
 Group1 ($000): 














Total 

Subgroup 1a 

<<>> 
20.0 
22.0 
19.0 
23.0 
17.0 
26.0 
21.0 
25.0 
28.0 
29.0 
27.0 
30.0 
287.0 

Subgroup 1b 

<<>> 



Subgroup 1c 

<<>> 



Subgroup 1d 

<<>> 



Subgroup 1e 

<<>> 



Total sales  Group1 


20.0 
22.0 
19.0 
23.0 
17.0 
26.0 
21.0 
25.0 
28.0 
29.0 
27.0 
30.0 
287.0 

287.0 
287.0 





Sales
 Group2 ($000): 


















Subgroup 2a 

<<>> 
17.0 
21.0 
19.0 
20.0 
22.0 
22.0 
23.0 
22.0 
24.0 
25.0 
24.0 
27.0 
266.0 



Subgroup 2b 

<<>> 





Subgroup 2c 

<<>> 





Subgroup 2d 

<<>> 





Subgroup 2e 

<<>> 





Total sales  Group2 


17.0 
21.0 
19.0 
20.0 
22.0 
22.0 
23.0 
22.0 
24.0 
25.0 
24.0 
27.0 
266.0 

266.0 
266.0 





Total
sales ($000): 


Total 

 Group1 

20.0 
22.0 
19.0 
23.0 
17.0 
26.0 
21.0 
25.0 
28.0 
29.0 
27.0 
30.0 
287.0 

 Group2 

17.0 
21.0 
19.0 
20.0 
22.0 
22.0 
23.0 
22.0 
24.0 
25.0 
24.0 
27.0 
266.0 

Total
sales ($000) 


37.0 
43.0 
38.0 
43.0 
39.0 
48.0 
44.0 
47.0 
52.0 
54.0 
51.0 
57.0 
553.0 

553.0 
553.0 






Note: Sales values will
not be reflected in cashflow projections until credit terms have been
specified in sheet M_B 



Supplementary Data &
Calculations: 























