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 Low Volume Salary 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              
3  PANEL 17 8.5 50% 5.5 3 35.30% 9
  REAR              
4  BODY  5 3.5 30% 2 1.5 43% 6
   PANEL              
                 
0 ROOF 24.5 18 26% 13.5 4.5 25.50% 0
  "A,B,or C"              
0.5  PILLAR 14 11 21.50% 7.5 3.5 32% 1.75
  & ROCKER              
  VAN              
0.25 SIDE 24 20.4 15.00% 12 12 50% 3
  RADIATOR              
4 CORE 8.1 6 26% 3.2 2.8 47% 11.2
  SUPPORT              
  Pickup              
1 Bed-Side 11.4 5.7 50.00% 3.5 2.2 38.60% 2.2
          TOTAL HOURS SAVED    33.15
               
     HOURLY SHOP RATE          $                  40.00
                 
    GROSS PROFIT SAVED PER HOUR        $                  40.00
               
  TOTAL EXTRA GROSS PROFIT PER MONTH      $             1,326.00
               
  Net Return of Investment       14.89 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