Three basic ingredients to create a simple inventory and ordering system

By: Jim Compton Originally published: May 24, 2017 ABRN

Original  ABRN Article Link

There are several advanced methods to consider for inventory and ordering. Two options include CollisionLink, which is offered through jobbers utilizing the Comcept (jobber) management system. NuVentory is a program that works in conjunction with several jobber systems. Both of these systems provide ordering, inventory and reports. With links to the jobber systems, these programs provide dynamic content that updates current prices part numbers as they come to market. These and other systems can be found online or via your jobber.

However, for this article, we will talk about some simple, basic ways to start managing inventory and ordering. Many find it easier to start off with very basic methods, get everyone onboard then have the option to migrate to more advanced or dynamic systems. While this article is intended to talk paint and materials inventory, a similar approach should work with anything purchased on a regular basis.

For most shops, enlisting the support of their jobber can greatly help and simplify this task. We will use three basic ingredients to create a simple inventory and ordering system — standard operating procedures (SOPs), historic purchases (from the jobber reports) and input from staff.

First, we need to have some basic SOPs in place. These establish a basic framework for how we are going to do things and therefore what we are going to need to get those tasks done. For example, if we have determined that all repair work will be finished with 180 grit by our body techs, we don’t need to maintain body tech inventory in anything finer and only a few grits coarser. Similar SOPs can help reduce the part number count in the paint, detail and other departments of the shop.

Every jobber should be able to provide a report of purchases. Using a full 12 months will provide a very complete list covering just about everything used on a regular basis. Remove anything that is not used on a regular basis and therefore does not need to be part of regular stock.

With our SOPs in hand, we can consider only those products that fit within our SOPs as the regular or “Authorized Stock List.” This can help thin our regular stocked part numbers, making inventory simpler and setting a basis for ordering.

Getting technicians and other staff involved will help get buy in and support. We can now discuss what we need to stock, and then how much we need to stock. The purchase list from the jobber can be narrowed to fit SOPs with input from staff on what products, sizes, grits and methods works best. This can then be pared down to our authorized stock list. I suggest determining 12 months worth of supplies divided by 26 to give us a two-week supply.

A two-week supply can, in most cases, provide enough inventory to last at least one week, with minimal overstock and less rush or fill-in orders. Filling back up to this level with each order will keep inventory fairly stable and aid in accounting for inventory. For example, a shop using 100 gallons/units of clear per year will need 4 (100 ÷ 26 and rounded up) gallons/units on hand, along with the required activators. While the mix of activators may change through the year based on temperature and humidity, the quantity doesn’t need to change very much. For this example, the 4 units of clear will also require 4 units of activator. Sometimes that will be one fast, two medium and one slow, and other times that mix may change.

Why not one week of supply, some may ask. Even though most shops can get multiple weekly deliveries, two weeks seems to work better and reduce added deliveries, time spent ordering, receiving and other administrative tasks associated with inventory. Down the road, reducing from the proposed two-week stock to a one-week level may be feasible. It is at this point that consideration may be given to a more advanced system (like those mentioned above).

Using this pared-down list and calculated quantities, we can now not only create an order form, but also a recommended stock level that ties into our SOPs.

Several shops have taken the approach that only those items on the order form (authorized stock list) can be ordered and delivered by the jobber; any other items require a signature or approval from management.

These order forms can also serve as an inventory form, providing a tool for the jobber to aid in the physical inventory (counting) process. Many jobber systems will allow for an order or quote to be created, providing an extended inventory valuation. These order forms can also be part of the process when reviewing and updating SOPs.

Another advantage of the now-stable set inventory level is an easier accounting for costs. In a production environment, cost of goods sold (CGS) is generally accounted for by taking beginning inventory plus purchases minus ending inventory. (Please keep in mind that this example for calculating CGS is over simplified — there is more involved.) CGS should be compared to sales every month to determine margins or profits. With a fairly stable and consistent level of inventory, we can calculate our margins each month without an inventory count and adjustment. Annual or bi-annual physical inventory counting and reconciliation is still recommended.

Adjusting inventory
As new techniques, procedures and regulations come into play, an adjusted authorized stock list may be needed. Many shops and jobbers have further edited these lists into specific department order forms, including  body shop, paint shop, detail and general shop. Leaving room on these forms for quick additions will help with small changes in SOPs or needs. A regular review of SOPs and authorized parts will help keep this system working.

The other systems, two of which are mentioned above, can be a more precise and dynamic method of keeping inventory and ordering. Here we discussed one of the simplest methods; walk before you run. This can still be a big improvement for those who don’t have a system in place and are just starting to embark on improved ordering and inventory control.

One thing everyone agrees on is that better management of inventory and ordering can help with improved P&M margins, reduced time and inventory on the shelf. Whether you choose the simple methods or some of the more dynamic tools available, better management of inventory leads to better P&M margins.

Advertisements

Response to Simple yet Hard working Inventory Programs

In response to inquiries to our May 30th, 2017 blog, several people have contacted us and asked for more information on simple easy to implement inventory programs.

There are several industry (Auto Body/ Collision Repair) specific and more sophisticated systems approach such as Nuventory, LeanTec, Paint Logic/Computer Logic, Collision Scan etc. Each of these systems offers some great attributes.

For a lot of Jobbers and Shops these systems are great. Others may want to start with something a little more economical, with a lot of the basic functions. We suggested ways for Jobbers (in the ABRN article) to work with their Shop clients and create: Authorized Stock Lists, Order Forms, Replenishment Levels, internally using Jobber system reports, Shop SOPs and MS-Excel.

We were asked by a couple folks about something a bit more sophisticated, with better controls, ordering functions, etc. Being heavy users of MS-Excel ourselves, we really like the MS-Excel based, Inventory Magic system by RWS Information Systems. Why reinvent the wheel?

https://www.imsinventorysystem.com/ click on the IMS Quick Tours three videos of 3-4 minutes. Or here on Word Press

For $9.95 you can get IMS basic to see just how simple this process can be. The IMS Pro at $89.95 is the greatest value in our opinion, obviously with more tools, reports and attributes. And for the middle of the road there is the IMS Deluxe at $49.95 (at the time of this post)

The Keys to Paint Department Profitability

The Keys to Paint Department Profitability
Managing paint and materials sales and costs requires careful attention to KPIs and a unified team effort. Ensure profitability is part of shop culture by discussing these numbers with your team, from the paint department to the estimators.

For 30 days, he dedicated time and effort to it. On each successive job, he concentrated on his efficiency, his technique, his use of a primer surfacer when refinishing vehicles, all in an effort to improve the tool’s profitability.

 

Read the full article on Fenderbender.com: https://www.fenderbender.com/articles/9046-the-keys-to-paint-department-profitability

 

 

2017 Excellence in Material Management Awards

FOR IMMEDIATE RELEASE: July 20th, 2017

CONTACT: Jim Compton of J. Hunter & Associates

Email: jim@LeanMaterialManagement.com

2017 Excellence in Material Management Awards

Dallas Texas, July 2017 – Awards were announced for Auto Body Repair shops achieving Excellence in Material Management. One shop is chosen from each of the Mike Anderson Axalta Business Council Groups.

Shops must meet high industry standards in order to be considered for these awards, including meeting or exceeding all environmental regulations, minimizing waste and using quality warranted paint materials. Shops are compared with six separate metrics that include measurements demonstrating the minimization of waste and environmental impact, cost control as measured in per RO and per refinish labor unit, and producing quality repairs. Their cumulative ranking in six KPIs determined their rank within their peer group.

These shops were chosen out of the groups who 1) Agreed to have their KPIs compared within their respective group 2) Had their purchases submitted independently 3) Supplied several key sales inputs needed to complete the calculations 4) Lean Material Management Reports compared for at least one year.

Finalists:

  • MSO Group 2-5 locations              Scotts Collision Center, Pennsylvania.
  • Independent single location        Latuff Brothers, Inc., Minnesota.
  • Dealer Shop/Group                        Five Star Automotive, Georgia.
  • MSO group 6-20 locations            The Collision Centers, New York

And the Grand Prize Winner of the 2017 Excellence in Material Management is …

Pro Care Automotive & Collision, Texas

2017 marks the third year that J. Hunter & Associates has presented these awards. J. Hunter & Associates is an independent third party company that assists body Auto Body shops and PBE jobbers nationwide in managing material usage and the shop level. More information about J. Hunter & Associates can be found at their web site. www.LeanMaterialManagement.com.

 

 

How to conduct safety meetings for your body shop

… One recommendation for managers or owners attending safety meetings is to sit down and take notes. Unless you are leading the meeting, allow your employees to be involved to ask questions and share their thoughts and experiences.  Your presence at the meeting and taking notes shows everyone that you value the subject being discussed and are willing to learn just like everyone else.

Read the full article @ ABRN

Full Lean Material Management Presentation, Material and Reports being developed in Spanish and French.

Here is a sample of a joint presentation by J. Hunter & Associates and Miguel Hernandez of Auto Tek Brokerage (click for more info) and the early release of the Spanish version, there is no audio on this presentation (yet).  We will be posting an updated more robust version with audio in the near future. Hoping to get a little feedback as we work on the final draft of the Spanish version, the French version is expected to be out later this year.

Lean Material Management goes Mutli-Lingual

J. Hunter & Associates has plans to support more countries and languages with the addition of French and Spanish Language versions of some their most popular reports.  With requests from Canada and countries in the Caribbean for versions of the LM2 (Lean Material Management) reports and other support tools, this seems a natural evolution in a growing progressive market. While still in early testing stages the customer feedback has been great.  If you have an opinion we would like to hear it.