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  
  Help with Entering Assumptions
 
      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: