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 & FINISHED GOODS INVENTORY 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
 Group1 ($000): 
Change group descriptions via menu
*Setup  Enter Basic Model Info ...
Subgroup descriptions in blue can be overwritten 











Total 

Subgroup 1a 

<<>> 
100.0 
110.0 
95.0 
115.0 
85.0 
130.0 
105.0 
125.0 
140.0 
145.0 
135.0 
150.0 
1,435.0 

Subgroup 1b 

<<>> 



Subgroup 1c 

<<>> 



Subgroup 1d 

<<>> 



Subgroup 1e 

<<>> 



Total sales  Group1 


100.0 
110.0 
95.0 
115.0 
85.0 
130.0 
105.0 
125.0 
140.0 
145.0 
135.0 
150.0 
1,435.0 





Sales
 Group2 ($000): 












Total 

Subgroup 2a 

<<>> 
33.5 
57.0 
70.4 
77.1 
70.4 
83.8 
93.8 
103.9 
110.6 
107.2 
120.6 
113.9 
1,042.2 

Subgroup 2b 

<<>> 



Subgroup 2c 

<<>> 



Subgroup 2d 

<<>> 



Subgroup 2e 

<<>> 



Total sales  Group2 


33.5 
57.0 
70.4 
77.1 
70.4 
83.8 
93.8 
103.9 
110.6 
107.2 
120.6 
113.9 
1,042.2 





Sales
 Group3 ( $000): 












Total 

Subgroup 3a 

<<>> 
16.5 
28.1 
34.7 
38.0 
34.7 
41.3 
46.2 
51.2 
54.5 
52.8 
59.4 
56.1 
513.5 

Subgroup 3b 

<<>> 



Subgroup 3c 

<<>> 



Subgroup 3d 

<<>> 



Subgroup 3e 

<<>> 



Total sales  Group3 


16.5 
28.1 
34.7 
38.0 
34.7 
41.3 
46.2 
51.2 
54.5 
52.8 
59.4 
56.1 
513.5 





Sales
 Group4 ($000): 












Total 

Subgroup 4a 

<<>> 
10.0 
10.0 
10.0 
10.0 
10.0 
10.0 
10.0 
10.0 
10.0 
10.0 
10.0 
10.0 
120.0 

Subgroup 4b 

<<>> 



Subgroup 4c 

<<>> 



Subgroup 4d 

<<>> 



Subgroup 4e 

<<>> 



Total sales  Group4 


10.0 
10.0 
10.0 
10.0 
10.0 
10.0 
10.0 
10.0 
10.0 
10.0 
10.0 
10.0 
120.0 





Sales
 Group5 ($000): 












Total 

Subgroup 5a 

<<>> 
20.0 
20.0 
20.0 
20.0 
20.0 
20.0 
20.0 
20.0 
20.0 
20.0 
20.0 
20.0 
240.0 

Subgroup 5b 

<<>> 



Subgroup 5c 

<<>> 



Subgroup 5d 

<<>> 



Subgroup 5e 

<<>> 



Total sales  Group5 


20.0 
20.0 
20.0 
20.0 
20.0 
20.0 
20.0 
20.0 
20.0 
20.0 
20.0 
20.0 
240.0 





Sales
 Group6 ($000): 












Total 

Subgroup 6a 

<<>> 
85.0 
105.0 
95.0 
100.0 
110.0 
110.0 
115.0 
110.0 
120.0 
125.0 
120.0 
135.0 
1,330.0 

Subgroup 6b 

<<>> 



Subgroup 6c 

<<>> 



Subgroup 6d 

<<>> 



Subgroup 6e 

<<>> 



Total sales  Group6 


85.0 
105.0 
95.0 
100.0 
110.0 
110.0 
115.0 
110.0 
120.0 
125.0 
120.0 
135.0 
1,330.0 






Sales
 Group7 ($000): 












Total 

Subgroup 7a 

<<>> 



Subgroup 7b 

<<>> 



Subgroup 7c 

<<>> 



Subgroup 7d 

<<>> 



Subgroup 7e 

<<>> 



Total sales  Group7 





















Sales
 Group8 ($000): 












Total 

Subgroup 8a 

<<>> 



Subgroup 8b 

<<>> 



Subgroup 8c 

<<>> 



Subgroup 8d 

<<>> 



Subgroup 8e 

<<>> 



Total sales  Group8 





















Sales
 Group9 ($000): 












Total 

Subgroup 9a 

<<>> 



Subgroup 9b 

<<>> 



Subgroup 9c 

<<>> 



Subgroup 9d 

<<>> 



Subgroup 9e 

<<>> 



Total sales  Group9 





















Sales
 Group10 ($000): 












Total 

Subgroup 10a 

<<>> 



Subgroup 10b 

<<>> 



Subgroup 10c 

<<>> 



Subgroup 10d 

<<>> 



Subgroup 10e 

<<>> 



Total sales  Group10 



















Total
sales ($000): 


Total 

 Group1 

100.0 
110.0 
95.0 
115.0 
85.0 
130.0 
105.0 
125.0 
140.0 
145.0 
135.0 
150.0 
1,435.0 

 Group2 

33.5 
57.0 
70.4 
77.1 
70.4 
83.8 
93.8 
103.9 
110.6 
107.2 
120.6 
113.9 
1,042.2 

 Group3 

16.5 
28.1 
34.7 
38.0 
34.7 
41.3 
46.2 
51.2 
54.5 
52.8 
59.4 
56.1 
513.5 

 Group4 

10.0 
10.0 
10.0 
10.0 
10.0 
10.0 
10.0 
10.0 
10.0 
10.0 
10.0 
10.0 
120.0 

 Group5 

20.0 
20.0 
20.0 
20.0 
20.0 
20.0 
20.0 
20.0 
20.0 
20.0 
20.0 
20.0 
240.0 

 Group6 

85.0 
105.0 
95.0 
100.0 
110.0 
110.0 
115.0 
110.0 
120.0 
125.0 
120.0 
135.0 
1,330.0 

 Group7 















 Group8 















 Group9 















 Group10 















Total
sales ($000) 


265.0 
330.1 
325.1 
360.1 
330.1 
395.1 
390.0 
420.1 
455.1 
460.0 
465.0 
485.0 
4,680.7 

















Bad
debts as % sales 

>> 
0.5 
0.5 
0.5 
0.5 
0.5 
0.5 
0.5 
0.5 
0.5 
0.5 
0.5 
0.5 



















Desired
finished goods inventory (valued at SELLING 
Set
cells below to zero UNLESS manufacturer with finished goods inventories 



PRICES in $000): 

Opening 


Note:
These inventory amounts are automatically revalued
at cost rather than selling price in DirCost worksheet 











 Group1 
>> 

100.0 
100.0 
110.0 
95.0 
115.0 
85.0 
130.0 
105.0 
125.0 
140.0 
145.0 
135.0 
150.0 


 Group2 
>> 

33.5 
33.5 
57.0 
70.4 
77.1 
70.4 
83.8 
93.8 
103.9 
110.6 
107.2 
120.6 
113.9 


 Group3 
>> 

16.5 
16.5 
28.1 
34.7 
38.0 
34.7 
41.3 
46.2 
51.2 
54.5 
52.8 
59.4 
56.1 


 Group4 
>> 

10.0 
10.0 
10.0 
10.0 
10.0 
10.0 
10.0 
10.0 
10.0 
10.0 
10.0 
10.0 
10.0 


 Group5 
>> 

20.0 
20.0 
20.0 
20.0 
20.0 
20.0 
20.0 
20.0 
20.0 
20.0 
20.0 
20.0 
20.0 


 Group6 
>> 

85.0 
85.0 
105.0 
95.0 
100.0 
110.0 
110.0 
115.0 
110.0 
120.0 
125.0 
120.0 
135.0 


 Group7 
>> 





 Group8 
>> 





 Group9 
>> 





 Group10 
>> 





Total
inventory ($000) 
265.0 
265.0 
330.1 
325.1 
360.1 
330.1 
395.1 
390.0 
420.1 
455.1 
460.0 
465.0 
485.0 








If
manufacturer holding finished goods inventories,
also enter total opening value (based on COST) within DirCost worksheet 














Note: Cashflows relating to sales
will not be calculated until values have been entered into table 2 at sheet
RecPay. 

Supplementary Data &
Calculations: 





























