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 ->> 285 320 345 380 325 265 270 285 275 300 325 350    
 - 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    
 - 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     7,963
  - 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 285 320 345 380 325 265 270 285 275 300 325 350    
 -  New products/services 10 30 40 60 70 85    
Total sales ($000) 830 995 1,175 1,320 1,326 1,205 1,290 1,421 1,495 1,510 1,620 1,670    
     
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 ->> 30.0 30.0 30.0 30.0 30.0 30.0 30.0 30.0 30.0 30.0 30.0 30.0    
 - 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.1 33.5 35.0 34.4 34.6 34.5 34.5 34.4 34.2 33.9 33.8 33.5     33
 -Labor ->> 13.0 14.1 14.5 15.4 14.0 14.0 14.0 14.0 14.0 14.0 14.0 14.0     14
 -Other ->> 9.2 9.8 9.2 9.4 9.0 9.0 9.0 9.0 9.0 9.0 9.0 9.0     9
                     
Overhead expenses ($000):                    
 -Operational (indirect) ->> 89 89 89 89 90 93 96 99 102 105 108 111     2,600
 -Selling & freight ->> 89 94 100 102 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) 461 466 472 474 474 485 496 507 528 539 555 566    
                                       
 
Supplementary Data & Calculations: