Definitions - Data Help index

Please select to view either 'Monthly KPI's Definitions' or 'Data Definitions'.
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z
A
Admin Employees: Includes all full-time management, sales, estimating, and clerical employees. Includes everyone that does not produce billable hours. Excludes detailers and porters.
B


C
CSI: This is the overall Customer Satisfaction Index value generated by the collision center's CSI system or vendor.

Cycle Time: Cycle time is the average of the cycle times of each individual repair completed (RO closed during the month). Cycle time is defined as the number of calendar days elapsed from the date vehicle is received from the customer to the date of delivery to the customer.
D
Daily Booth Operating Hours: The number of hours each day that each Paint Booth operates. For instance, if a collision center that operates from 8:00 AM to 5:00 PM, with a one-hour lunch has two Paint Booths, that's 8 hours per Booth. The Daily Booth Operating Hours for this collision center would then be 16.
E


F


G Back to top
Gallons of Waste Generated: The total gallons of paint and solvent waste logged during the month whether or not recycled.
H Back to top


I Back to top


J Back to top


K Back to top


L Back to top
Labor Door Rate: The hourly rate posted and charged in your collision center for labor.
M Back to top


N Back to top


O Back to top


P Back to top
P&M Cost: The cost of all the Paint & Materials your collision center purchased or consumed. This includes all paint products as well as associated products used to perform the repair such as abrasives, masking products, cleaners and solvents, and detailing supplies. Total of Paint & Materials invoices.

Paint & Materials Include:

Paint products:
- Primers
- Color
- Reducers
- Clear coat
- Hardeners
- Flex additive
- Other paint specialty products

Other P&M Associates products:
- Abrasives
- Masking products
- Solvents
- Car covers
- Buffing products
- Shop towels and rags
- Body Plastic
- Hazardous waste removal costs

These items are not included in P&M Costs:
- Small tools & equipment
- Air hoses
- Maintenance and janitorial supplies
- Welding supplies and gas
- Booth filters and fuel
- Safety supplies
- Clips / fasteners

P&M Door Rate: The hourly rate posted and charged in your collision center for Paint & Materials.

P&M Gross Profit $: P&M Sales minus P&M Cost

P&M Sales: The total of all Paint & Material Sales. Your RO should include both the hourly allowance for Paint & Material Sales and also all additional paint & material items charged separately such as flex additive, seam sealers, car covers, hazardous waste removal, etc. These are generally miss-classified as sublet or parts on automated estimates.

Paint & Materials Sales should include: The $ allowance based on paint labor hours X Paint & Materials door rate plus additional not-included Paint & Material items such as:
- Flex additive
- Seam and glass sealants
- Car covers
- Sound deadening pads
- Hazardous waste removal charges
- All other paint & material related items charged on the estimate

Paint Booths: The total number of booths used for painting vehicles. Include a proportionate share of any prep-decks used for painting vehicles or performing small repairs. If the prep-deck is used 25% of the time for this purpose, count it as .25 booth; 50% as .5 booth, etc.

Paint Hours: Total paint hours on all RO's. (For dealerships, Paint Hours will include hours for warranty and internal work.) Paint Hours is included in Total Labor Hours.

Paint Labor Cost: The gross wages paid to paint techs and helpers producing Paint Hours. (excluding payroll taxes and benefits).

Paint Labor Gross Profit $: Paint Labor Sales minus Paint Labor Cost.

Paint Labor Sales: The Paint Labor sales charged on R.O.'s from Paint Hours. Note for dealerships - warranty and internal labor sales are included in Paint Labor Sales.

Paint Only Cost: The cost of paint sprayable products only. (Liquids)
- Primers
- Sealers
- Color
- Reducers
- Clear Coat
- Hardeners
- Flex additive
- Other paint specialty products
(All items with a BASF label, only.)

Parts Cost: The cost of all the parts included in Parts Sales. Total of all Parts invoices.

Parts Cost include:
- OE Parts
- Aftermarket parts
- Used or LKQ parts
- Tires, wheels, batteries
- Mechanical parts
- A/C Refrigerant
- Fasteners, clips
- Vehicle light bulbs

Parts Gross Profit $: Parts Sales minus Parts Cost.

Parts Sales: The total of all parts sold and installed by your technicians to perform the repair including OE, used, aftermarket, glass, tires, wheels, batteries, nuts, bolts, and clips, etc. Your financial statement should include all parts listed on the RO as parts including items often listed on automated estimates as "sublet" such as salvage parts, non-OE parts, etc.

Parts Sales include:
- OE Parts
- Aftermarket parts
- Used or Salvage parts
- Tires, wheels, batteries
- Mechanical parts
- A/C Refrigerant
- Fasteners, clips
- Vehicle light bulbs

Percent of Time Work is at Door: This is an indication of the strength of your work backlog. What percentage of an average month do you have a comfortable flow of new work?

Production Square Feet: The total amount of area (in square feet) used for production including stalls, aisles, paint booth(s), staging areas and equipment. Excludes office or parts storage space.
Q Back to top


R Back to top
R.O.'s: The number of closed repair orders. (Note: do not count multiple R.O.'s for the same repair. (i.e. towing, customer paid detailing, rental billings, total losses, re-do's and comebacks, etc.). Dealerships should include R.O.'s for warranty and internal work.
S Back to top
Shift Profile: (Check all that apply)
- You work a normal day shift.
- You work routinely work techs overtime (i.e. over 40 hours per week)
- You work a second shift.
- You work a Saturday shift.

Stalls - Paint: The total number or Stalls or workspaces regularly used for production in the paint department including paint booth(s), prep areas, prep decks, and cool down stalls. Does not include aisles.

Stalls - Total: The total number of Stalls regularly used for production including frame racks, paint booth(s), prep areas, mechanical work and lifts. Does not include aisles.

Sublet Cost: The cost of only those items properly included in sublet sales, for vehicle repair performed by non-collision center personnel. Total of all Sublet invoices received form Sublet vendors.
Sublet items may include:
- Towing & storage
- Lock services
- Outside glass or stripe services
- Outside upholstery services
- Any vehicle repair or service performed by non-collision center personnel
- Nothing else!

Sublet Gross Profit $: Sublet Sales minus Sublet Cost.

Sublet Sales: Sublet sales is only the value of those operations performed by non-collision center personnel. These may include towing, key coding, glass replacement, upholstery work and stripping. If your technicians perform any of these operations, then it is no sublet.
Sublet items may include:
- Towing & storage
- Lock services
- Outside glass or stripe services
- Outside upholstery services
- Any vehicle repair or service performed by non-collision center personnel
- Nothing else!

Sublet items DO NOT include: (sometimes classified as sublet on estimate)
- Paint & Material items
- Frame labor (performed in-house)
T Back to top
Tech Clock Hours - Paint: The actual clock hours worked by all paint techs & helpers.

Tech Clock Hours - Total: The actual clock hours worked by all techs and helpers. Includes body, frame, mechanical, and paint. Excludes detail techs and porters. For accuracy, it is important to collect this information from your technicians by having them punch a time clock or signing a time sheet.

Techs - Body & Helpers: Includes body, frame, mechanical techs and helpers or apprentices working in the collision center body department.

Techs - Painters & Helpers: Includes all painters, prep techs, helpers and apprentices working in the collision center paint department.

Techs - Total: Includes all body techs, paint techs, and helpers. Excludes detail techs and porters.

Total Labor Cost: The gross wages paid to all technicians and helpers (excluding payroll taxes and benefits). Includes Body, frame, mechanical and paint. Excludes porters.

Total Labor Gross Profit $: Total Labor Sales minus Total Labor Cost.

Total Labor Hours: Total billed hours on all R.O.'s including body, paint, mechanical, frame, and detail labor functions.

Total Labor Sales: The total of all labor operations or categories performed by your technicians including body labor, mechanical labor, frame labor, paint labor and detail labor. Your financial statement should reflect all labor items on the RO including those items that are sometimes listed as sublet or other on insurance estimates such as a lump sum for frame time, the labor portion of glass replacement, alignments, (if performed by your technicians) etc.

Total Sales: Total of all Labor, Parts, P&M, and Sublet Sales.
U Back to top


V Back to top


W Back to top
Waste Removal Cost: The total dollar value of waste removal costs incurred during the month. For those using a service such as Safety-Kleen, it should include those costs. For those using a recycler, it should include the direct costs of using the recycler (i.e. bags) and for removal of residual waste.

Workdays: The number of days in the month your collision center was operating.
X Back to top


Y Back to top


Z Back to top



Go to Help index master list