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. 1 - SALES TARGETS Help with Entering Assumptions
 
      Set cells in this row 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): Change group descriptions via menu *Setup | Enter Basic Model Info ...  Subgroup descriptions in blue can be overwritten                       Total
 Subgroup 1a <<->> 100.0 110.0 95.0 115.0 85.0 130.0 105.0 125.0 140.0 145.0 135.0 150.0 1,435.0
 Subgroup 1b <<->>    
 Subgroup 1c <<->>    
 Subgroup 1d <<->>    
 Subgroup 1e <<->>    
Total sales - Group1 100.0 110.0 95.0 115.0 85.0 130.0 105.0 125.0 140.0 145.0 135.0 150.0 1,435.0
   
Sales - Group2 ($000):                         Total
 Subgroup 2a <<->> 85.0 105.0 95.0 100.0 110.0 110.0 115.0 110.0 120.0 125.0 120.0 135.0 1,330.0
 Subgroup 2b <<->>    
 Subgroup 2c <<->>    
 Subgroup 2d <<->>    
 Subgroup 2e <<->>    
Total sales - Group2 85.0 105.0 95.0 100.0 110.0 110.0 115.0 110.0 120.0 125.0 120.0 135.0 1,330.0
   
Total sales ($000): Total
 - Group1 100.0 110.0 95.0 115.0 85.0 130.0 105.0 125.0 140.0 145.0 135.0 150.0 1,435.0
 - Group2 85.0 105.0 95.0 100.0 110.0 110.0 115.0 110.0 120.0 125.0 120.0 135.0 1,330.0
Total sales ($000) 185.0 215.0 190.0 215.0 195.0 240.0 220.0 235.0 260.0 270.0 255.0 285.0 2,765.0
                                     
Note: Cashflows relating to sales will not be calculated until values have been entered into table 2 at sheet RecPay.
Supplementary Data & Calculations: