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. 1 - SALES Help with Entering Assumptions
 
      Set cells below to zero if not entering seasonal assumptions         Total
Seasonal index ->> 31.00 28.00 31.00 30.00 31.00 30.00 31.00 31.00 30.00 31.00 30.00 31.00 365.0
                           
Sales - Group1 ($000):                         Total
 Subgroup 1a <<->> 20.0 22.0 19.0 23.0 17.0 26.0 21.0 25.0 28.0 29.0 27.0 30.0 287.0
 Subgroup 1b <<->>    
 Subgroup 1c <<->>    
 Subgroup 1d <<->>    
 Subgroup 1e <<->>    
Total sales - Group1 20.0 22.0 19.0 23.0 17.0 26.0 21.0 25.0 28.0 29.0 27.0 30.0 287.0 287.0 287.0
   
Sales - Group2 ($000):                                
 Subgroup 2a <<->> 17.0 21.0 19.0 20.0 22.0 22.0 23.0 22.0 24.0 25.0 24.0 27.0 266.0      
 Subgroup 2b <<->>          
 Subgroup 2c <<->>          
 Subgroup 2d <<->>          
 Subgroup 2e <<->>          
Total sales - Group2 17.0 21.0 19.0 20.0 22.0 22.0 23.0 22.0 24.0 25.0 24.0 27.0 266.0   266.0 266.0
   
Total sales ($000): Total
 - Group1 20.0 22.0 19.0 23.0 17.0 26.0 21.0 25.0 28.0 29.0 27.0 30.0 287.0
 - Group2 17.0 21.0 19.0 20.0 22.0 22.0 23.0 22.0 24.0 25.0 24.0 27.0 266.0
Total sales ($000) 37.0 43.0 38.0 43.0 39.0 48.0 44.0 47.0 52.0 54.0 51.0 57.0 553.0 553.0 553.0
            Note: Sales values will not be reflected in cashflow projections until credit terms have been specified in sheet M_B  
Supplementary Data & Calculations: