If you’re like most owners, that seems like a contradiction in terms. It doesn’t have to though. You can control your inventory rather than the other way around. What does inventory mean to you? Does it mean after-hours projects, such as extra paperwork or heated conversations with your bookkeeper over cost vs. markup vs. profitability? If you answered “yes,” inventory probably also means “piles of money” on the shelf.
Inventory is money on the shelf. National averages for a typical midsize business $10,0000 to $1,000,000 worth of inventory and 30 percent of that inventory is dead! A 21-month study conducted recently on what owners sell and what they stock, revealed that 11 percent of owners sell specialty items but don’t stock them, while 18 percent stock specialty items, but don’t have what they need.
What is the purpose of inventory? Many owners think it’s there to facilitate shop operation by reducing rack time and increasing gross profit. In reality, however, inventory exists to improve your level of service. How? The right amount of the right part numbers will provide you with what you need when you need it, without enormous stress on your operating capital.
Consider the following two methods of inventory control. Last In First Out (LIFO) means that when there is more than one of a given part number, you sell the last one received, fi rst. The rationale being that the newest is probably the most expensive. First In First Out (FIFO) means that when there is more than one of a given part number, you sell the one you’ve had the longest, fi rst. The rationale? To keep your stock rotating.
Whether you use LIFO or FIFO, the actual transfers are only taking place on paper. The old dusty part may be pulled off the shelf, but it’s the new expensive one that’s reduced from inventory. Ask your bookkeeper which is the correct method for your business.
Why should you even consider these inventory control methods listed above? Take a moment to compare the value of your inventory to the value of some piece of your equipment. When you purchased the expensive piece of equipment, you probably considered various things. You probably shopped for the best price and considered return on investment. If the equipment wouldn’t pay for itself, you probably would not have purchased it. After the purchase, you monitored your investment to maximize its use and, therefore, its return.
All the same rules apply to your inventory investment. There are some fundamental differences, however, between your inventory investment and your capital investments. Your equipment is depreciable, while your inventory is taxable. Your capital investments happen suddenly, while your inventory value creeps up gradually. At some point, most shop owners end up with a large inventory investment on which they pay taxes, yet rarely do they monitor or control it properly. Face it, it’s a time-consuming process in an industry that holds time at such a premium that you charge for it in six minute increments.
So what to do? Some think the best inventory is none at all. Inventory interferes with your productivity. How much time do you spend counting it, ordering and receiving it, tracking incorrect orders, stocking shelves and tracking returns? How much energy goes into protecting it? How often do you give something away?
When was the last time your parts percentage figures were at the level you require for profitability? There are two calculations that are often overlooked when determining inventory profitability.
The first is cost-to-order, the second is cost-to-keep. The factors involved in cost-to-order are time and money. Time to calculate order quantities and time to do paperwork, time to receive it, stock it, correct errors and then time to track them, and money to pay someone to do it all. To determine your cost-to-order, you first must learn how much:
• time is actually spent deciding what to order;
• time it takes to do the paperwork;
• time it takes to check in and stock the order;
• you pay the individual(s) that actually perform each step.
If the inventory value of the order received is $100, and if you sell parts at a 45 percent margin, you’d sell that $100 for $182. The formula here is:
selling price = cost of goods (in this case, $100) divided by the result of 1.00 minus the margin (.45 in this example).
If your cost-to-order is $10, what happens to the selling price? If it remains the same, you just lost money. (The cost of goods remains at $100, but the cost to order = $10. A $110 investment would gross $200.20 on a 45 percent margin). You just lost $18.20.
There is also a calculation called cost-to-keep. Space does not permit a lengthy discussion, but the important point to consider is how much it costs to buy inventory based on how long you own it, as well as how much return on investment you could get on that dollar if it wasn’t on the shelf.
You must also factor in cost-of-obsolescence. For example, if it costs you 10 percent to keep something on the shelf, and you receive a 5 percent quantity discount, maybe you shouldn’t buy it. The lowest price is not always the best price.
If gaining control of your inventory sounds like the impossible dream, it’s not. My recommendation is to look into just-in-time inventory. This means that you order on a regular basis and purchase only when you need to replenish what has been sold since the last order. Just-in-time inventory means you must have short inventory order cycles and accurate tracking to determine what and how much inventory to stock. It is an attainable goal.
March 7, 2023
Discover the top 5 favorite features in Scissortail for seamless payroll processing. From on-demand W2 to customizable reporting, find out how they can make your work faster and easier. Plus, learn what's new with our remote team members and our exciting developments outside of work!
February 16, 2023
Acumatica offers a trustworthy partner to help businesses of any size and in any industry through the digital transformation journey. Read more on our blog to learn how Acumatica's Customer Bill of Rights, award-winning cloud ERP software, and Value Added Resellers can help your business succeed.
February 16, 2023
Acumatica has recognized the dedication and commitment of their professionals by naming Troy Vars the Most Valuable Professional for 2023. Troy is the Manager of ERP and Development for CS3, and his contributions to the Acumatica community are invaluable.