IMPORTANT....Look at the numbers in the green shaded area. You will need to change those numbers to reflect your shop's numbers
and the spread sheet will update automatically.  You will need Microsoft Excel installed on your computer to use this tool. If the sheet does not update call us and we will do the math for you.
RETURN ON INVESTMENT High Volume Commission Shop  
  Mig Welding Vs: STRSW              
               
NUMBER TYPE OF TIME ACTUAL NORMAL USING HOURS ADDITIONAL TOTAL
OF JOBS OPERATION ALLOWED TIME   PRO SPOT SAVED USING EFFICIENCY HOURS
PER MONTH   MITCHELL USING MIG FACTOR ACTUAL  PRO SPOT GAINED SAVED PER
    (HRS) (HRS) % (HRS) PER JOB % OPERATION
                 
  QUARTER              
15  PANEL 17 8.5 50% 5.5 3 35.30% 45
                 
  REAR              
15  BODY  5 3.5 30% 2 1.5 43% 22.5
   PANEL              
                 
1 ROOF 24.5 18 26% 13.5 4.5 25.50% 4.5
                 
  "A,B,or C"              
10  PILLAR 14 11 21.50% 7.5 3.5 32% 35
  & ROCKER              
  VAN              
1 SIDE 24 20.4 15.00% 12 12 50% 12
  RADIATOR              
20 CORE 8.1 6 26% 3.2 2.8 47% 56
  SUPPORT              
  Pickup              
3 Bed-Side 11.4 5.7 50.00% 3.5 2.2 38.60% 6.6
          TOTAL HOURS SAVED    181.6
    HOURLY SHOP RATE          $                40.00
    HOURLY COST OF LABOR          $                20.00
    GROSS PROFIT SAVED PER HOUR        $                20.00
               
  TOTAL EXTRA GROSS PROFIT PER MONTH      $          3,632.00
               
  Net Return of Investment        5.44 Months
               
Study does not include savings of materials such as mig wire, mig gases, grinding discs, extra compressor running time or single side applications
 

[ Home ]

Copyright WESCO Corp 2009 All Rights Reserved
Supplier Trademarks used by permission.
WESCO is the largest and most comprehensive source of products, services, technical support and business development consulting. We serve the automotive specialty and collision industry in the North West United States.
WESCO is the premier supplier of high quality paint, painting equipment, collision equipment, tools and accessories.
Our website was last updated on June  22nd,  2010 and is maintained by Coconut Telegraphics