| 6 Months |
|
|
|
|
2005 |
2005 |
2005 |
2005 |
2005 |
2005 |
2005 |
| to end Jul |
|
|
|
|
Feb |
Mar |
Apr |
May |
Jun |
Jul |
6-Mths |
| MONTHLY
ASSUMPTIONS No. 2 - COST OF MATERIALS/GOODS, INVENTORY |
|
|
| & PURCHASES |
|
|
|
|
| |
|
|
| Cost
of materials/pack 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.00 |
| |
|
|
|
|
|
|
|
|
| Cost
of materials/packaging or |
|
|
Total |
| goods for resale ($000) |
|
9.0 |
9.3 |
9.6 |
10.0 |
10.3 |
10.6 |
58.84 |
| |
|
|
| Desired
inventory of material/packaging |
|
|
| or goods for resale |
|
Opening |
Targets
->> Values will be included in
monthly balance sheets |
|
| ($000): |
->> |
|
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |
|
| |
|
Opening value entered
via opening balance sheet |
|
|
|
| Total
purchases of materials/pack & |
|
|
| goods for resale ($000) |
|
9.0 |
9.3
|
9.6
|
10.0
|
10.3
|
10.6
|
58.8 |
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Supplementary Data &
Calculations: |
|
|
|
Note:
Purchases will not be reflected in cashflow projections until credit |
|
|
terms have been
specified in sheet M_B |
|
|
|
|
|
|
|
|
|
|
|
|
|
|