Overhead Cost Worksheet
Overhead Cost Per Hour Worksheet
     
  Annual Service Department Overhead  
  Get your Annual Overhead from your financials  
  Monthly Average Overhead  
  Your service techs are going to come from your average number of techs employed  
  # of Service Techs  
  Your service techs are going to come from your average number of techs employed  
  Days per month  
  Days per month should be the minimum number of Days on average.  the lower the number of days the higher the daily rate. You want this number higher for breakage purposes.   
   
  Man Days per month  
  Productive Hours  
  Overhead Cost per Hour (Per Tech)  
  Overhead Cost Per Day (Per Tech)  
       
  Annual Service Department Desired Profit  
  Enter here your annual planned profit for your Service Department  
  Monthly Average Profit  
  Profit Plan per Hour (Per Tech)  
  Profit Plan Per Day (Per Tech)  
NOW CLICK ON THE HOURLY RATE CALCULATION PAGE BELOW
Copyright Enterprise Selling Solutions 2021
Hourly Rate Calculation
  Highest Paid Service Technician (Base Wage Rate)          
  Enter your highest paid technician to come up with your daily rate        
  Taxes/Benefits multiplier           
  Variable depending upon benefits offered and state taxes. Enter the number as a percentage        
  Loaded Labor Rate        
  Overhead per hour        
  Desired profit per hour        
  Target $ Per Hour        
  Production efficiency (include warranty, travel, breaks)          
  Your Production efficency is the amount of time your people are billing. The lower the number the higher the hourly rate.  You are accounting for time you cannot bill, into the rate/hours that you can.        
  Your Hourly Rate for Service          
Copyright Enterprise Selling Solutions 2021