Please fill all required fields
Average RO$   Enter Data in Yellow Cells Only    
Avg, # of RO/Month   Enter Current values in the First Table    
Category Sales Mix % GP% Avg Sales/RO GP$ %of Profit$
Body Labor      
Paint Labor      
Parts      
P&M      
Sublet      
Other      
  < must = 100%      
      Overall GP %>      
  What IF Sales Mix is Changed        
Category Sales Mix % GP% Avg Sales/RO GP$ %of Profit$ Delta $    
Body Labor    
Paint Labor    
Parts    
P&M    
Sublet Annual  
Other Change  
  < must = 100%  
      Overall GP %>      
  What IF GP% is Changed        
Category Sales Mix % GP% Avg Sales/RO GP$ %of Profit$ Delta $    
Body Labor 30.0%    
Paint Labor 20.0%    
Parts 36.0%    
P&M 10.0%    
Sublet 4.0% Annual  
Other 0.0% Change  
  < must = 100%  
      Overall GP %>      
Changes above are shown in BOLD on Excel version only not on Web version.