May 17, 2017
Lesson 5: Ordering
It doesn’t do you any good to have a meticulously crafted inventory policy if your ordering process is haphazard.
You have to place Purchase Orders in line with your stocking policy, otherwise you’re going nowhere. Different classes of items should be ordered differently. Here’s a look at some different classes of items:
Never order these! Even if your supplier gives you a good deal or a good incentive, don’t order them. They will only gather dust in your warehouse and cost you money. Ultimately, you’re going to throw these items out and write it off.
Only order these if your customer has ordered them from you and you don’t have enough inventory to fulfill the customer order. Don’t order a single unit more.
All other items
Remember the min and max levels you calculated previously? Just a reminder: the minimum level is your Safety Stock level in days. The maximum level is the Safety Stock level + the Replenishment Cycle in days. We should identify all items that are below the min level and order them.
One small complication here is the Lead Time for getting the items from your supplier. You have to find the items that will be below the minimum level after the lead time. That way, if you order those items today, the stock level will be at the minimum level the day the next shipment arrives from your supplier. The safety stock at that point should buffer you from late deliveries, under deliveries or under forecasts.
Let’s say you have an item that is forecast to sell 100 units per month, every month. Let’s say you have the following policy:
- Lead Time – 30 days
- Safety Stock – 15 days
- Replenishment Cycle – 30 days
So from now until the end of the Lead Time, you will sell 100 units (30 days at 100 per month).
From that Lead Time to the end of your Safety Stock you will sell another 50 units (15 days at 100 per month).
This total of 150 units is your re-order point. If your current stock-on-hand is less than 150 units, you have to place an order right now.
How much to order? Simply add your Replenishment Cycle to your re-order point. That’s another 100 units (30 days at 100 per month).
This total of 250 units is your order-up-to.
Let’s say your inventory level is at 120 units, which is below the re-order point of 150 units. You have to place an order and the size of the order will be 250 – 120 = 130 units.
By placing this order of 130, you will drive your inventory level towards your stocking policy.
Of course, there may be other factors that influence the order. Your supplier may have some constraints in place such as a minimum order quantity or pack size. These constraints may force you to order 150, for example, which is more than the 130 you ideally require.
Filling a container
The above example is good for calculating the perfect order for a single item. But you probably want to order all the items from a specific supplier at the same time.
You could set up a spreadsheet to calculate the recommended order for all the items supplied by a specific supplier.
This will form the basis for the Purchase Order you’ll create in your ERP system. There may be more manipulations that you have to perform. Here are some examples:
You may need to fill containers before the supplier will ship anything to you. However, the last thing you want to do is just randomly add items to the order. Or add items where the supplier may give you a large discount.
One of the best strategies to add more items to the container is to look at items where the available inventory is still above the re-order point, but already under the order-up-to point. These items will come up for ordering in the next order cycle.
So for each of those items you can simply place an order for the difference between the order-up-to level and the current inventory level. Keep adding the most important items first (think A items) until you’ve met the container size constraint.
Using this method you will still drive your inventory levels towards your ideal Stocking Policy, but you may be slightly in excess on certain items. Make sure you’re in excess on High Velocity items, so that the excess situation won’t last too long.
Back to the ERP
Once you have your spreadsheet of recommended orders, you can now open up a new Purchase Order on your ERP system on the supplier. Capture the products and their order quantities from the spreadsheet into the Purchase Order. Double check that you have not made a mistake. These can be very costly, especially if you capture the wrong product code or order quantity.
Once you’re happy with the Purchase Order on the ERP, you can send that off and start the whole process again for the next supplier.