0
DAYS
0
HOURS
0
MINS
0
SECS
Over 2.2 million customers use QuickBooks.
Sign up for a free trial!

Determining Your Optimal Order Quantities

by Vera Lim

2 min read

Last week, we looked at how to optimize your inventory by organizing your products with an alphanumeric Stock Keeping Unit (SKU) system. Now that you have your SKU system all set up, you’ll know the popularity of your products right down to the individual variants. Knowing this helps you to make informed predictions about what’s worth investing in and how to adjust your order quantities to best suit customer demand.

Economic Order Quantity

To help you decide on your optimal order quantity, I’d like to introduce the Economic Order Quantity (EOQ) formula. The EOQ formula provides a useful gauge when you’re deciding on the ideal order quantity that minimizes inventory costs while matching customer demand.

Order Quantities 1

In order to calculate your EOQ, you need to know:

  • Your fixed cost per year: Fixed costs are your ordering costs. These are decided by the amount you have to spend on clerical costs to procure stock like order fees, inspections, so on
  • Your demand in units per year
  • Your carrying cost per unit per year: Carrying costs are the price you pay to maintain your inventory, covering ‘static’ costs like storage, utilities, and insurance

If your business is up and running, it’s just a matter of looking through your past records to figure out last year’s demand and your costs. However, if you’re still in the planning stages, you can run on estimates drawn from supplier quotes and researching your competitors.

Reorder Point

The EOQ tells you how much to order, but not when it’s time to reorder, and that’s why you need to know your reorder point. It’s a reminder for you to replenish your inventory to ensure you maintain optimal inventory levels.

Order Quantities 2

When calculating your reorder point, you need to know your lead time demand and safety stock level.

Lead time demand covers how long you’ll need to wait for new stock, because you want to have enough stock to keep your customers satisfied until the new shipment comes in.

Safety stock is the buffer stock you carry to protect your business against unpredictable events that can deplete your stock, either due to a surge in demand or the supply chain breaking down.

Setting your reorder points lets you cut down on excess spending while providing you with a buffer when things take an unexpected turn. But remembering to place a fresh order every time inventory levels hit the reorder point can be a challenge.

If you’re worried about missing the reorder point, it may be time to look into getting inventory management software for your business. It tracks your inventory movement across all channels, and once your stock levels hit the reorder point, it’ll prompt you to place a new purchase order.

In spite of your best efforts to calculate the optimal quantity of inventory to have on hand at any given time, you may find yourself stuck with stock that just aren’t selling well. We’ll be back next week to tell you all about dead stock and how you can get rid of it.

Related Articles

Navigating tax as an Uber driver

Want to earn some cash as an Uber driver? As much as…

Read more

How to develop an effective client onboarding strategy

You mightn’t know the feeling from a client’s perspective, but being onboarded…

Read more

BAS Centre - a brand new look

The BAS Centre has a whole new look to make it easier…

Read more