| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 36 Months |
|
|
|
|
2005 |
2005 |
2005 |
2005 |
2005 |
2005 |
2005 |
2005 |
2005 |
2005 |
2005 |
2005 |
2006 |
2006 |
2006 |
2006 |
2006 |
2006 |
2006 |
2006 |
2006 |
2006 |
2006 |
2006 |
2007 |
2007 |
2007 |
2007 |
2007 |
2007 |
2007 |
2007 |
2007 |
2007 |
2007 |
2007 |
2005 |
2006 |
2007 |
|
|
| to
end Dec 2007 |
|
|
|
|
Jan |
Feb |
Mar |
Apr |
May |
Jun |
Jul |
Aug |
Sep |
Oct |
Nov |
Dec |
Jan |
Feb |
Mar |
Apr |
May |
Jun |
Jul |
Aug |
Sep |
Oct |
Nov |
Dec |
Jan |
Feb |
Mar |
Apr |
May |
Jun |
Jul |
Aug |
Sep |
Oct |
Nov |
Dec |
Year |
Year |
Year |
|
|
| MONTHLY
ASSUMPTIONS No. 1 - SALES & FINISHED GOODS INVENTORY TARGETS |
|
|
|
|
|
|
|
| |
|
|
|
Set cells below to zero
if not entering seasonal assumptions |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Total |
Total |
Total |
|
|
| 3-year seasonal indices |
->> |
31.00 |
28.00 |
31.00 |
30.00 |
31.00 |
30.00 |
31.00 |
31.00 |
30.00 |
31.00 |
30.00 |
31.00 |
31.00 |
28.00 |
31.00 |
30.00 |
31.00 |
30.00 |
31.00 |
31.00 |
30.00 |
31.00 |
30.00 |
31.00 |
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 |
365.0 |
365.0 |
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Sales
- Group1 (000s units or $000): |
|
|
Use either sales volumes
or turnover values throughout this group |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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 |
170.0 |
185.0 |
200.0 |
215.0 |
230.0 |
245.0 |
260.0 |
275.0 |
290.0 |
305.0 |
320.0 |
335.0 |
350.0 |
365.0 |
380.0 |
395.0 |
410.0 |
425.0 |
440.0 |
455.0 |
470.0 |
485.0 |
500.0 |
515.0 |
1,435.0 |
3,030.0 |
5,190.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 |
170.0 |
185.0 |
200.0 |
215.0 |
230.0 |
245.0 |
260.0 |
275.0 |
290.0 |
305.0 |
320.0 |
335.0 |
350.0 |
365.0 |
380.0 |
395.0 |
410.0 |
425.0 |
440.0 |
455.0 |
470.0 |
485.0 |
500.0 |
515.0 |
515.0 |
515.0 |
515.0 |
|
|
| |
|
1,435.0 |
3,030.0 |
5,190.0 |
|
|
| Sales
- Group2 (000s units or $000): |
|
|
Use either sales volumes
or turnover values throughout this group |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Subgroup 2a |
|
<<->> |
33.5 |
57.0 |
70.4 |
77.1 |
70.4 |
83.8 |
93.8 |
103.9 |
110.6 |
107.2 |
120.6 |
115.0 |
100.0 |
105.0 |
110.3 |
115.8 |
121.6 |
127.6 |
134.0 |
140.7 |
147.7 |
155.1 |
162.9 |
171.0 |
179.6 |
188.6 |
198.0 |
207.9 |
218.3 |
229.2 |
240.7 |
252.7 |
265.3 |
278.6 |
292.5 |
307.2 |
1,043.3 |
1,591.7 |
2,858.5 |
|
|
| 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 |
115.0 |
100.0 |
105.0 |
110.3 |
115.8 |
121.6 |
127.6 |
134.0
|
140.7
|
147.7
|
155.1
|
162.9
|
171.0
|
179.6
|
188.6
|
198.0
|
207.9
|
218.3
|
229.2
|
240.7
|
252.7
|
265.3
|
278.6
|
292.5
|
307.2
|
307.2 |
307.2 |
307.2 |
|
|
| |
|
1,043.3 |
1,591.7 |
2,858.5 |
|
|
| Sales
- Group3 (000s units or $000): |
|
|
Use either sales volumes
or turnover values throughout this group |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Subgroup 3a |
|
<<->> |
16.5 |
28.1 |
34.7 |
38.0 |
34.7 |
41.3 |
46.2 |
51.2 |
54.5 |
52.8 |
59.4 |
65.0 |
60.0 |
66.0 |
72.6 |
79.9 |
87.8 |
96.6 |
106.3 |
116.9 |
128.6 |
141.5 |
155.6 |
171.2 |
188.3 |
207.1 |
227.8 |
250.6 |
275.7 |
303.3 |
333.6 |
367.0 |
403.6 |
444.0 |
488.4 |
537.3 |
522.4 |
1,283.1 |
4,026.8 |
|
|
| 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 |
65.0 |
60.0 |
66.0 |
72.6 |
79.9 |
87.8
|
96.6
|
106.3 |
116.9
|
128.6
|
141.5 |
155.6 |
171.2 |
188.3 |
207.1 |
227.8
|
250.6 |
275.7 |
303.3 |
333.6
|
367.0 |
403.6
|
444.0 |
488.4 |
537.3 |
537.3 |
537.3 |
537.3 |
|
|
| |
|
522.4 |
1,283.1 |
4,026.8 |
|
|
| Sales
- Group4 (000s units or $000): |
|
|
Use either sales volumes
or turnover values throughout this group |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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 |
10.0 |
20.0 |
30.0 |
40.0 |
50.0 |
60.0 |
70.0 |
80.0 |
90.0 |
100.0 |
110.0 |
120.0 |
130.0 |
140.0 |
150.0 |
160.0 |
170.0 |
180.0 |
190.0 |
200.0 |
210.0 |
220.0 |
230.0 |
240.0 |
120.0 |
780.0 |
2,220.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 |
10.0 |
20.0 |
30.0 |
40.0 |
50.0 |
60.0 |
70.0 |
80.0 |
90.0 |
100.0 |
110.0 |
120.0 |
130.0 |
140.0 |
150.0 |
160.0 |
170.0 |
180.0 |
190.0 |
200.0 |
210.0 |
220.0 |
230.0 |
240.0 |
240.0 |
240.0 |
240.0 |
|
|
| |
|
120.0 |
780.0 |
2,220.0 |
|
|
| Sales
- Group5 (000s units or $000): |
|
|
Use either sales volumes
or turnover values throughout this group |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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 |
20.0 |
40.0 |
60.0 |
80.0 |
100.0 |
120.0 |
140.0 |
160.0 |
180.0 |
200.0 |
220.0 |
240.0 |
260.0 |
280.0 |
300.0 |
320.0 |
340.0 |
360.0 |
380.0 |
400.0 |
420.0 |
440.0 |
460.0 |
480.0 |
240.0 |
1,560.0 |
4,440.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 |
20.0 |
40.0 |
60.0 |
80.0 |
100.0 |
120.0 |
140.0 |
160.0 |
180.0 |
200.0 |
220.0 |
240.0 |
260.0 |
280.0 |
300.0 |
320.0 |
340.0 |
360.0 |
380.0 |
400.0 |
420.0 |
440.0 |
460.0 |
480.0 |
480.0 |
480.0 |
480.0 |
|
|
| |
|
240.0 |
1,560.0 |
4,440.0 |
|
|
| Sales
- Group6 (000s units or $000): |
|
|
Use either sales volumes
or turnover values throughout this group |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Subgroup 6a |
|
<<->> |
56.6 |
51.1 |
56.6 |
54.8 |
56.6 |
54.8 |
56.6 |
56.6 |
54.8 |
56.6 |
54.8 |
56.6 |
56.6 |
51.1 |
56.6 |
54.8 |
56.6 |
54.8 |
56.6 |
56.6 |
54.8 |
56.6 |
54.8 |
56.6 |
56.6 |
51.1 |
56.6 |
54.8 |
56.6 |
54.8 |
56.6 |
56.6 |
54.8 |
56.6 |
54.8 |
56.6 |
666.7 |
666.7 |
666.7 |
|
|
| Subgroup 6b |
|
<<->> |
|
|
|
|
|
|
| Subgroup 6c |
|
<<->> |
|
|
|
|
|
|
| Subgroup 6d |
|
<<->> |
|
|
|
|
|
|
| Subgroup 6e |
|
<<->> |
|
|
|
|
|
|
| Total sales - Group6 |
|
|
56.6
|
51.1
|
56.6
|
54.8
|
56.6
|
54.8
|
56.6
|
56.6
|
54.8
|
56.6
|
54.8
|
56.6
|
56.6
|
51.1
|
56.6
|
54.8
|
56.6
|
54.8
|
56.6
|
56.6
|
54.8
|
56.6
|
54.8
|
56.6
|
56.6
|
51.1
|
56.6
|
54.8
|
56.6
|
54.8
|
56.6
|
56.6
|
54.8
|
56.6
|
54.8
|
56.6
|
56.6 |
56.6 |
56.6 |
|
|
| |
|
666.7 |
666.7 |
666.7 |
|
|
| Net
selling prices ($/unit): |
|
|
Set cells below to 1.0
unless using sales units |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Average |
Average |
Average |
|
|
| - Group1 |
|
->> |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0
|
1.0
|
1.0 |
|
|
| - Group2 |
|
->> |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0
|
1.0
|
1.0 |
|
|
| - Group3 |
|
->> |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0
|
1.0
|
1.0 |
|
|
| - Group4 |
|
->> |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0
|
1.0
|
1.0 |
|
|
| - Group5 |
|
->> |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0
|
1.0
|
1.0 |
|
|
| - Group6 |
|
->> |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0
|
1.0
|
1.0 |
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Total
sales ($000): |
|
|
Note: These values will
not be reflected in cashflow projections until credit terms have been
specified in sheet M_B |
|
Total |
Total |
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 |
170.0 |
185.0 |
200.0 |
215.0 |
230.0 |
245.0 |
260.0 |
275.0 |
290.0
|
305.0
|
320.0
|
335.0
|
350.0
|
365.0
|
380.0
|
395.0
|
410.0
|
425.0
|
440.0
|
455.0
|
470.0
|
485.0
|
500.0
|
515.0
|
1,435.0 |
3,030.0 |
5,190.0 |
|
|
| - Group2 |
|
33.5 |
57.0 |
70.4 |
77.1 |
70.4 |
83.8 |
93.8 |
103.9 |
110.6 |
107.2 |
120.6 |
115.0 |
100.0 |
105.0 |
110.3 |
115.8 |
121.6 |
127.6 |
134.0 |
140.7 |
147.7
|
155.1
|
162.9
|
171.0
|
179.6
|
188.6
|
198.0
|
207.9
|
218.3
|
229.2
|
240.7
|
252.7
|
265.3
|
278.6
|
292.5
|
307.2
|
1,043.3 |
1,591.7 |
2,858.5 |
|
|
| - Group3 |
|
16.5 |
28.1 |
34.7 |
38.0 |
34.7 |
41.3 |
46.2 |
51.2 |
54.5 |
52.8 |
59.4 |
65.0 |
60.0 |
66.0 |
72.6 |
79.9 |
87.8 |
96.6 |
106.3 |
116.9 |
128.6
|
141.5
|
155.6
|
171.2
|
188.3
|
207.1
|
227.8
|
250.6
|
275.7
|
303.3
|
333.6
|
367.0
|
403.6
|
444.0
|
488.4
|
537.3
|
522.4 |
1,283.1 |
4,026.8 |
|
|
| - Group4 |
|
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |