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. 2 - DIRECT COSTS Help with Entering Assumptions
 
      Set cells in this row 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.00 41.00 41.00 41.00 41.00 41.00 41.00 41.00 41.00 41.00 41.00 41.00 41.00
                           
Cost of materials/packaging or  
     goods required ($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
   
Desired inventory of material/pack Opening                          
 or goods for resale ($000) ->> 50.0 50.0 50.0 50.0 50.0 50.0 50.0 50.0 50.0 50.0 50.0 50.0 50.0  
        The above values will be included in monthly balance sheets          
Purchases of materials/packaging &  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.8
                          Average
Direct labor (Persons) ->> 1.0 1.0 1.0 1.5 1.5 1.5 2.0 2.0 2.0 2.0 2.0 2.0 1.6
                           
Average payroll & benefits cost per direct     Include wages, bonuses, benefits, overtime and all other payroll costs & taxes     Average
person ($000/person/month) ->> 0.866 0.866 0.866 0.866 0.866 0.866 0.866 0.866 0.866 0.866 0.866 0.866 0.866
                           
Total direct payroll/benefit costs ($000) 0.9 0.9 0.9 1.3 1.3 1.3 1.7 1.7 1.7 1.7 1.7 1.7 16.9
  The variable descriptions in blue below can be changed  
Other direct costs ($000):        X = 0 to 4     Try to include all direct/variable costs here, irrespective of type of business     Total
 -Energy (variable)   <<->> 1.0 1.1 1.2 1.3 1.4 1.5 1.6 1.7 1.8 1.9 2.0 2.1 18.6
 -Repairs/maintenance (variable)   <<->> 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 24.0
 -Subcontract   <<->>    
 -Consumables   <<->>    
Total other direct costs ($000)   3.0 3.1 3.2 3.3 3.4 3.5 3.6 3.7 3.8 3.9 4.0 4.1 42.6
  Total
Cost of sales ($000) 12.9 13.3 13.7 14.6 15.0 15.4 16.3 16.7 17.2 17.6 18.1 18.6 189.3
                                     
Note: Cashflows relating to purchases will not be calculated until values have been entered into table 2 at sheet RecPay.
Supplementary Data & Calculations: