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. 4 - OVERHEAD EXPENSES Help with Entering Assumptions
 
      Set cells below to zero if not entering seasonal assumptions         Total
Seasonal index ->> 4.33 4.33 4.33 4.33 4.33 4.33 4.33 4.33 4.33 4.33 4.33 4.33 52.0
                           
Operational (indirect) expenses ($000):     Use the cells below to accommodate semi-variable and indirect operating costs     Tot/Avg
 -Indirect labor (Persons) ->> 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
 -Indirect payroll/benefits ($000/pers/mth) ->> 1.400 1.400 1.400 1.400 1.400 1.400 1.400 1.400 1.400 1.400 1.400 1.400 1.400
 -Supervisory staff (Persons) ->> 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0
 -Supervisory payroll/benefits ($000/pers/mth)  X = 0 to 4 1.600 1.600 1.600 1.600 1.600 1.600 1.600 1.600 1.600 1.600 1.600 1.600 1.600
 -Repairs/maintenance (fixed) 1 <<->> 2.5 2.5 2.5 2.5 2.5 2.5 2.5 2.5 2.5 2.5 2.5 2.5 30.0
 -Cleaning 1 <<->>    
 -Utilities (fixed) 1 <<->>    
 -Miscellaneous indirect expenses 1 <<->> 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 60.0
Total operational expenses ($000) 29.5 29.5 29.5 29.5 29.5 29.5 29.5 29.5 29.5 29.5 29.5 29.5 354.0
   
Selling & freight expenses ($000):    X = 0 to 4     The variable descriptions in blue can be changed           Tot/Avg
 -Freight expenses as % sales 2 <<->> 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0
 -Selling exs & comm's as % sales 1 <<->> 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
 -Sales & marketing staff (Persons) ->> 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0
 -Sales payroll/benefits ($000/pers/mth) ->> 2.500 2.500 2.500 2.500 2.500 2.500 2.500 2.500 2.500 2.500 2.500 2.500 2.500
 -Freight expenses 5.9 6.6 6.0 7.3 7.2 7.8 8.5 8.6 8.7 9.1 9.1 9.1 93.9
 -Selling expenses/commission    X = 0 to 4 3.0 3.0 3.3 3.0 3.7 3.6 3.9 4.3 4.3 4.4 4.6 4.6 45.4
 -Advertising & brochures 2 <<->> 8.0 8.0 8.0 8.0 8.0 8.0 8.0 8.0 8.0 8.0 8.0 8.0 96.0
 -Travel expenses 2 <<->>    
 -Public relations, exhibitions 2 <<->>    
 -Miscellaneous selling/freight 2 <<->>    
Total selling & freight expenses ($000) 29.4 30.1 29.8 30.8 31.4 31.9 32.9 33.4 33.5 34.0 34.2 34.2 385.3
   
Management/administration staff expenses:                         Tot/Avg
 -Clerical staff (Persons) ->> 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
 -Clerical payroll/benefits ($000/pers/mth) ->> 1.500 1.500 1.500 1.500 1.500 1.500 1.500 1.500 1.500 1.500 1.500 1.500 1.500
 -Management staff (Persons) ->> 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
 -Management payroll/benefits ($000/pers/mth) ->> 3.500 3.500 3.500 3.500 3.500 3.500 3.500 3.500 3.500 3.500 3.500 3.500 3.500
Total management/admin staff expenses ($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 600.0
   
Research & development     The variable descriptions in blue can be changed           Tot/Avg
 -Staff (Persons) ->> 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0
 -Staff payroll/benefits ($000/pers/mth)    X = 0 to 4 2.200 2.200 2.200 2.200 2.200 2.200 2.200 2.200 2.200 2.200 2.200 2.200 2.200
 -Consultancy 1 <<->> 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 120.0
 -Materials 1 <<->>    
Total research & development ($000) 21.0 21.0 21.0 21.0 21.0 21.0 21.0 21.0 21.0 21.0 21.0 21.0 252.0
   
Administration expenses ($000):    X = 0 to 4     The variable descriptions in blue can be changed           Total
 -Office supplies etc. 1 <<->> 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 18.0
 -Mail, telephone, telex & fax 2 <<->> 2.5 2.5 2.5 2.5 2.5 2.5 2.5 2.5 2.5 2.5 2.5 2.5 30.0
 -Travel 2 <<->> 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 60.0
 -Pensions 2 <<->>    
 -Computer supplies etc. 2 <<->>    
 -Vehicle expenses 2 <<->>    
 -Other administration expenses 2 <<->>    
Total administration expenses ($000) 9.0 9.0 9.0 9.0 9.0 9.0 9.0 9.0 9.0 9.0 9.0 9.0 108.0
   
Occupancy/general expenses ($000):    X = 0 to 4     The variable descriptions in blue can be changed           Total
 -Utilities  1 <<->> 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 6.0
 -Rent & property taxes 2 <<->> 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 48.0
 -Professional fees & audit 1 <<->> 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 120.0
 -Insurances 1 <<->>    
 -Other establish expenses A 1 <<->>    
 -Other establish expenses B 1 <<->>    
Total occupancy/general expenses ($000) 14.5 14.5 14.5 14.5 14.5 14.5 14.5 14.5 14.5 14.5 14.5 14.5 174.0
   
Total overhead expenses ($000)         153.4 154.1 153.8 154.8 155.4 155.9 156.9 157.4 157.5 158.0 158.2 158.2 1,873.3
Supplementary Data & Calculations: