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. 2 - COST OF MATERIALS/GOODS, INVENTORY & PURCHASES |
|
|
|
|
|
|
|
|
|
|
|
Set cells below to zero
if not entering seasonal assumptions |
|
|
|
|
Total |
Seasonal
index |
|
->> |
5.00 |
4.00 |
4.00 |
5.00 |
4.00 |
4.00 |
5.00 |
4.00 |
4.00 |
5.00 |
4.00 |
4.00 |
52.0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Cost
of materials/packaging or goods |
|
|
Set cells below to zero
only if a 'pure' services business |
|
|
|
|
Average |
for resale (as % sales) |
->> |
41.0 |
41.0 |
41.0 |
41.0 |
41.0 |
41.0 |
41.0 |
41.0 |
41.0 |
41.0 |
41.0 |
41.0 |
41.00 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Cost
of materials/packaging or |
|
Total |
goods for resale ($000) |
9.0 |
9.3 |
9.6 |
10.0 |
10.3 |
10.6 |
10.9 |
11.3 |
11.6 |
12.0 |
12.4 |
12.7 |
129.80 |
|
|
|
Desired
inventory of material/packaging |
|
|
|
|
or goods for resale |
|
Opening |
Targets ->> |
Set cells below to zero
if a 'pure' services business. Total values will be included in monthly
balance sheets |
|
($000): |
->> |
|
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 |
|
|
|
|
|
Opening value entered
via opening balance sheet |
|
|
|
|
|
|
Total
purchases ($000) |
9.0 |
9.3
|
9.6
|
10.0
|
10.3
|
10.6
|
10.9
|
11.3
|
11.6
|
12.0
|
12.4
|
12.7
|
129.8 |
|
|
|
|
|
|
Note: Purchases will
not be reflected in cashflow projections until credit terms have been
specified in sheet M_B |
|
|
Supplementary Data &
Calculations: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|