Years ending           2007 2007 2007 2007 2008 2008 2008 2008 2009 2009 2009 2009    
Dec           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 4th & 5th YEARS AND PROJECTIONS FOR 3rd YEAR - SALES & COSTS  
  Help with Entering Assumptions
 
Sales (000s units or $000):                    
 - Group1 ->> 1,095 1,230 1,365 1,500 1,700 1,785 1,874 1,968 2,066 2,170 2,278 2,392    
 - Group2 ->> 566 655 759 878 950 998 1,047 1,100 1,155 1,212 1,273 1,337    
 - Group3 ->> 623 830 1,104 1,470 1,750 1,950 2,150 2,350 2,550 2,750 2,950 3,150    
 - Group4 ->> 420 510 600 690 600 675 750 825 900 975 1,050 1,125    
 - Group5 ->> 840 1,020 1,200 1,380 1,530 1,607 1,687 1,771 1,860 1,953 2,050 2,153    
 - Group6 ->> 164 166 168 168 160 160 160 160 160 160 160 160    
 - Group7 ->>        
 - Group8 ->>        
 - Group9 ->>        
 - Group10 ->>        
 - New products/services ->> ->> ->> ->> ->>   90 170 320 400 500    
                     
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 1,095 1,230 1,365 1,500 1,700 1,785 1,874 1,968 2,066 2,170 2,278 2,392     54,343
 - Group2 566 655 759 878 950 998 1,047 1,100 1,155 1,212 1,273 1,337    
 - Group3 623 830 1,104 1,470 1,750 1,950 2,150 2,350 2,550 2,750 2,950 3,150    
 - Group4 420 510 600 690 600 675 750 825 900 975 1,050 1,125    
 - Group5 840 1,020 1,200 1,380 1,530 1,607 1,687 1,771 1,860 1,953 2,050 2,153    
 - Group6 164 166 168 168 160 160 160 160 160 160 160 160    
 - Group7    
 - Group8    
 - Group9    
 - Group10    
 - New products/services 90 170 320 400 500    
Total sales ($000) 3,709 4,411 5,196 6,086 6,690 7,174 7,668 8,264 8,861 9,540 10,162 10,817    
     
Matls/pack & goods for resale as % sales:                    
 - Group1 ->> 33.0 33.0 33.0 33.0 33.0 33.0 33.0 33.0 33.0 33.0 33.0 33.0    
 - Group2 ->> 28.9 26.8 24.7 22.6 23.0 23.0 23.0 23.0 23.0 23.0 23.0 23.0    
 - Group3 ->> 33.5 32.0 30.5 29.0 29.0 29.0 29.0 29.0 29.0 29.0 29.0 29.0    
 - Group4 ->> 33.5 32.0 30.5 29.0 29.0 29.0 29.0 29.0 29.0 29.0 29.0 29.0    
 - Group5 ->> 33.6 33.3 33.0 32.6 33.0 33.0 33.0 33.0 33.0 33.0 33.0 33.0    
 - 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 ->> ->> ->> ->> ->> 45.0 45.0 45.0 45.0 45.0 45.0 45.0 45.0    
                     
Direct costs as % sales:    
 -Total matls/pack & goods for resale 32.6 32.1 31.2 30.2 30.1 30.1 30.1 30.2 30.3 30.5 30.6 30.7     31
 -Labor ->> 13.5 12.8 12.1 11.5 12.0 12.0 12.0 12.0 12.0 12.0 12.0 12.0     12
 -Other ->> 6.2 5.9 5.5 5.2 5.5 5.5 5.5 5.5 5.5 5.5 5.5 5.5     6
                     
Overhead expenses ($000):                    
 -Operational (indirect) ->> 252 273 298 327 350 380 410 440 470 500 530 560     19,000
 -Selling & freight ->> 432 486 543 605 700 750 800 850 900 950 1,000 1,050    
 -Management/admin staff ->> 508 580 652 724 800 860 920 980 1,040 1,100 1,160 1,220    
 -Research & development ->> 209 242 274 307 325 365 405 445 485 525 565 605    
 -Administration ->> 101 116 134 155 175 193 212 233 256 282 310 341    
 -Occupancy/general ->> 129 129 129 129 170 170 170 170 220 220 220 220    
Total overhead expenses ($000) 1,630 1,826 2,030 2,246 2,520 2,718 2,917 3,118 3,371 3,577 3,785 3,996    
                                       
 
Supplementary Data & Calculations: