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 |
|
|
|
|
|
|
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 |
|
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 |
|
|
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: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|