Years ending           05-06 05-06 05-06 05-06 06-07 06-07 06-07 06-07 07-08 07-08 07-08 07-08    
Jan           1 Qtr 2 Qtr 3 Qtr 4 Qtr 1 Qtr 2 Qtr 3 Qtr 4 Qtr 1 Qtr 2 Qtr 3 Qtr 4 Qtr    
ASSUMPTIONS FOR 2nd & 3rd YEARS AND PROJECTIONS FOR 1st YEAR - SALES & COSTS  
  Help with Entering Assumptions
 
Sales (000s units or $000):                    
 - Group1 ->> 305 330 370 430 450 465 410 455 505 550 525 560    
 - Group2 ->> 161 231 308 342 369 318 402 436 452 402 469 452    
 - Group3 ->> 79 114 152 168 182 157 198 215 223 198 231 223    
 - Group4 ->> 30 30 30 30 182 157 198 215 223 198 231 223    
 - Group5 ->> 60 60 60 60 182 157 198 215 223 198 231 223    
 - Group6 ->> 285 320 345 380 325 265 270 285 275 300 325 350    
 - Group7 ->>        
 - Group8 ->>        
 - Group9 ->>        
 - Group10 ->>        
 - New products/services ->> ->> ->> ->> ->>   10 30 40 60 70 85    
                     
Net selling prices ($/unit):                    
 - Group1 ->> 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0    
 - Group2 ->> 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0    
 - Group3 ->> 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0    
 - Group4 ->> 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0    
 - Group5 ->> 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0    
 - Group6 ->> 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0    
 - Group7 ->>        
 - Group8 ->>        
 - Group9 ->>        
 - Group10 ->>        
 - New products/services ->> ->> ->> ->> ->> 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0    
                     
Sales ($000):    
 - Group1 305 330 370 430 450 465 410 455 505 550 525 560     10,177
 - Group2 161 231 308 342 369 318 402 436 452 402 469 452    
 - Group3 79 114 152 168 182 157 198 215 223 198 231 223    
 - Group4 30 30 30 30 182 157 198 215 223 198 231 223    
 - Group5 60 60 60 60 182 157 198 215 223 198 231 223    
 - Group6 285 320 345 380 325 265 270 285 275 300 325 350    
 - Group7    
 - Group8    
 - Group9    
 - Group10    
 -  New products/services 10 30 40 60 70 85    
Total sales ($000) 920 1,085 1,265 1,410 1,690 1,519 1,686 1,851 1,941 1,906 2,082 2,116    
     
Matls/pack & goods for resale as % sales:                    
 - Group1 ->> 36.0 36.0 36.0 36.0 35.0 34.7 34.3 34.0 33.6 33.3 33.0 32.6    
 - Group2 ->> 38.0 38.0 38.0 38.0 38.0 38.0 38.0 38.0 38.0 38.0 38.0 38.0    
 - Group3 ->> 35.0 35.0 35.0 35.0 35.0 34.5 34.0 33.5 33.0 32.5 32.0 31.5    
 - Group4 ->> 28.0 28.0 28.0 28.0 35.0 34.5 34.0 33.5 33.0 32.5 32.0 31.5    
 - Group5 ->> 25.0 25.0 25.0 25.0 35.0 34.5 34.0 33.5 33.0 32.5 32.0 31.5    
 - Group6 ->> 30.0 30.0 30.0 30.0 30.0 30.0 30.0 30.0 30.0 30.0 30.0 30.0    
 - Group7 ->>        
 - Group8 ->>        
 - Group9 ->>        
 - Group10 ->>        
 - New products/services ->> ->> ->> ->> ->> 35.0 35.0 35.0 35.0 35.0 35.0 35.0 35.0    
                     
Direct costs as % sales:    
 -Total matls/pack & goods for resale 36.0 32.9 34.4 33.8 34.7 34.5 34.4 34.2 33.9 33.6 33.4 33.1     33
 -Labor ->> 13.5 14.1 14.5 15.4 14.0 14.0 14.0 14.0 14.0 14.0 14.0 14.0     14
 -Other ->> 8.5 9.0 8.5 8.8 9.0 9.0 9.0 9.0 9.0 9.0 9.0 9.0     9
                     
Overhead expenses ($000):                    
 -Operational (indirect) ->> 96 96 96 96 90 93 96 99 102 105 108 111     2,600
 -Selling & freight ->> 140 145 150 153 100 103 106 109 112 115 118 121    
 -Management/admin staff ->> 150 150 150 150 150 152 154 156 158 160 162 164    
 -Research & development ->> 63 63 63 63 60 60 60 60 70 70 75 75    
 -Administration ->> 27 27 27 27 30 31 32 33 34 35 36 37    
 -Occupancy/general ->> 44 44 44 44 44 46 48 50 52 54 56 58    
Total overhead expenses ($000) 519 524 530 532 474 485 496 507 528 539 555 566    
                                       
 
Supplementary Data & Calculations: