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 & FINISHED GOODS INVENTORY 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 <<->> 33.5 57.0 70.4 77.1 70.4 83.8 93.8 103.9 110.6 107.2 120.6 113.9 1,042.2
 Subgroup 2b <<->>    
 Subgroup 2c <<->>    
 Subgroup 2d <<->>    
 Subgroup 2e <<->>    
Total sales - Group2 33.5 57.0 70.4 77.1 70.4 83.8 93.8 103.9 110.6 107.2 120.6 113.9 1,042.2
   
Sales - Group3 ($000):                         Total
 Subgroup 3a <<->> 16.5 28.1 34.7 38.0 34.7 41.3 46.2 51.2 54.5 52.8 59.4 56.1 513.5
 Subgroup 3b <<->>    
 Subgroup 3c <<->>    
 Subgroup 3d <<->>    
 Subgroup 3e <<->>    
Total sales - Group3 16.5 28.1 34.7 38.0 34.7 41.3 46.2 51.2 54.5 52.8 59.4 56.1 513.5
   
Sales - Group4 ($000):                         Total
 Subgroup 4a <<->> 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
 Subgroup 4b <<->>    
 Subgroup 4c <<->>    
 Subgroup 4d <<->>    
 Subgroup 4e <<->>    
Total sales - Group4 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
   
Sales - Group5 ($000):                         Total
 Subgroup 5a <<->> 20.0 20.0 20.0 20.0 20.0 20.0 20.0 20.0 20.0 20.0 20.0 20.0 240.0
 Subgroup 5b <<->>    
 Subgroup 5c <<->>    
 Subgroup 5d <<->>    
 Subgroup 5e <<->>    
Total sales - Group5 20.0 20.0 20.0 20.0 20.0 20.0 20.0 20.0 20.0 20.0 20.0 20.0 240.0
   
Sales - Group6 ($000):                         Total
 Subgroup 6a <<->> 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 6b <<->>    
 Subgroup 6c <<->>    
 Subgroup 6d <<->>    
 Subgroup 6e <<->>    
Total sales - Group6 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 33.5 57.0 70.4 77.1 70.4 83.8 93.8 103.9 110.6 107.2 120.6 113.9 1,042.2
 - Group3 16.5 28.1 34.7 38.0 34.7 41.3 46.2 51.2 54.5 52.8 59.4 56.1 513.5
 - Group4 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
 - Group5 20.0 20.0 20.0 20.0 20.0 20.0 20.0 20.0 20.0 20.0 20.0 20.0 240.0
 - Group6 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) 265.0 330.1 325.1 360.1 330.1 395.1 390.0 420.1 455.1 460.0 465.0 485.0 4,680.7
                           
Bad debts as % sales ->> 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5  
                           
Desired finished goods inventory (valued at SELLING Set cells below to zero UNLESS manufacturer with finished goods inventories  
 PRICES in $000): Opening     Note: These inventory amounts are automatically revalued at cost rather than selling price in DirCost worksheet                    
 - Group1 ->> 100.0 100.0 110.0 95.0 115.0 85.0 130.0 105.0 125.0 140.0 145.0 135.0 150.0  
 - Group2 ->> 33.5 33.5 57.0 70.4 77.1 70.4 83.8 93.8 103.9 110.6 107.2 120.6 113.9  
 - Group3 ->> 16.5 16.5 28.1 34.7 38.0 34.7 41.3 46.2 51.2 54.5 52.8 59.4 56.1  
 - Group4 ->> 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  
 - Group5 ->> 20.0 20.0 20.0 20.0 20.0 20.0 20.0 20.0 20.0 20.0 20.0 20.0 20.0  
 - Group6 ->> 85.0 85.0 105.0 95.0 100.0 110.0 110.0 115.0 110.0 120.0 125.0 120.0 135.0  
Total inventory ($000) 265.0 265.0 330.1 325.1 360.1 330.1 395.1 390.0 420.1 455.1 460.0 465.0 485.0  
            If manufacturer holding finished goods inventories, also enter total opening value (based on COST) within DirCost worksheet                        
Note: Cashflows relating to sales will not be calculated until values have been entered into table 2 at sheet RecPay.
Supplementary Data & Calculations: