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. 3 - OVERHEAD EXPENSES Help with Entering Assumptions
 
      Set cells in this row 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
      The variable descriptions in blue below can be changed          
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
 -Power (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 <<->>    
 -Other operating o'heads 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)   32.0 32.0 32.0 32.0 32.0 32.0 32.0 32.0 32.0 32.0 32.0 32.0 384.0
   
Selling & freight expenses ($000):     The variable descriptions in blue below can be changed         Tot/Avg
 -Freight expenses as % sales ->> 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 & commission as % sales ->> 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 staff 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.3 6.6 6.5 7.2 6.6 7.9 7.8 8.4 9.1 9.2 9.3 9.7 93.6
 -Selling expenses/commission    X = 0 to 4 2.7 3.3 3.3 3.6 3.3 4.0 3.9 4.2 4.6 4.6 4.7 4.9 46.8
 -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
 -Special promotion 1 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
 -Special promotion 2 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/dist 2 <<->>    
Total selling & freight expenses ($000)   44.5 46.4 46.3 47.3 46.4 48.4 48.2 49.1 50.2 50.3 50.5 51.1 578.4
   
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 below 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 below 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 A 2 <<->>    
 -Other administration B 2 <<->>    
 -Other administration C 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 below 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 establishment A 1 <<->>    
 -Other establishment B 1 <<->>    
 -Other establishment C 1 <<->>    
 -Other establishment D 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)         171.0 172.9 172.8 173.8 172.9 174.9 174.7 175.6 176.7 176.8 177.0 177.6 2,096.4
Supplementary Data & Calculations: