Why Economic Order Quantity May Be Right (Or Wrong) for You

Economic Order Quantity can take the guesswork out of reordering stock, find out how.

Economic Order Quantity can take the guesswork out of reordering stock, find out how.

Would you like to know exactly when you need to reorder stock and how much you need to reorder?

Then you need to calculate your economic order quantity (EOQ).

EOQ – much like a reorder point formula – helps you take the guesswork out of stocking your warehouse and keeping up with customer demand.

We’ll show you how to use an EOQ formula, it’s advantages and disadvantages, and the one tool you need to optimize your use of EOQ and any other inventory formulas.

What is Economic Order Quantity?

Economic order quantity is the lowest amount of inventory you must order to meet peak customer demand without going out of stock and without producing obsolete inventory.

That’s the ideal use of EOQ.

Its purpose is to reduce inventory as much as possible to keep the cost of inventory as low as possible.

The EOQ model assumes that demand is constant and that inventory is depleted at a predictable rate. While this isn’t the case for many businesses, the model still helps companies better approximate when they need to replenish their inventory and how much they should order.

How Do You Calculate Economic Order Quantity?

To help you calculate EOQ, here is the formula from Kenneth Boyd, author of Cost Accounting for Dummies:

Economic order quantity uses three variables: demand, relevant ordering cost, and relevant carrying cost. Use them to set up an EOQ formula:

  • Demand: The demand, in units, for the product for a specific time period.
  • Relevant ordering cost: Ordering cost per purchase order.
  • Relevant carrying cost: Carrying costs for one unit. Assume the unit is in stock for the time period used for demand.

Note that the ordering cost is calculated per order. The carrying costs are calculated per unit. Here’s the formula for economic order quantity:

Economic order quantity = square root of [(2 x demand x ordering costs) ÷ carrying costs]

That’s easier to visualize as a regular formula:

381676.image0

Q is the economic order quantity (units). D is demand (units, often annual), S is ordering cost (per purchase order), and H is carrying cost per unit.

What are the Advantages of EOQ?

Economic order quantity has been successfully used for decades by businesses of all types, so it certainly has a few advantages.

Here are some of them:

Helps Lower Inventory Costs

The primary purpose of EOQ is to help keep inventory carrying costs as low as possible.

The more inventory you have on hand, the more you have to pay for insurance, taxes, security, etc.

Accurately calculating how much inventory you need will help you maintain a budget you can afford.

Makes Restocking Easy

Economic order quantity can help you understand how often you should be ordering. You may discover that ordering small quantities more often is better for your bottom line or vice versa.

By calculating how much you need in proportion to how much you sell over a given period of time, you can ensure you always have enough stock to satisfy your customers.

Helps You Find the Best Deal

Many vendors advertise deals throughout the year to entice you to buy more of their inventory which usually ends up increasing your cost of inventory even if you received a discounted price.

The EOQ model helps you purchase only what you’re going to use.

It’ll help you take advantage of a vendor deal if, after plugging the numbers into your EOQ formula, you find out you’re not overpurchasing but getting the right amount at a lower price.

What are the Disadvantages of EOQ?

While economic order quantity has some benefits and a long history of use, it’s not without its shortcomings.

Here are a couple of them:

Requires Numerous Assumptions

The largest complaint about EOQ is that it requires numerous assumptions.

The model assumes that there’s steady demand, steady sales, and fixed costs.

Plus, the basic EOQ model assumes you have a one-product business. If you sell multiple products, you’ll have to calculate and track each one separately.

Doesn’t Account for Fluctuations During Seasons

The biggest problem with assumptions of steady demand and steady sales in the EOQ model is that it doesn’t allow you to account for fluctuations in demand during holidays or particular seasons.

If your sales yo-yo throughout the year, then EOQ won’t be able to keep up.

How to Make EOQ Work for You

Realistically, you’re unlikely (and not lucky enough) to operate a business with fixed rates and steady sales that almost never fluctuate.

If you run a business similar to the rest of ours, then you’re constantly dealing with uncertainties in your reorder point and customer demand forecasts.

EOQ can still help you make more informed guesses about when and how much inventory should be ordered, but to make EOQ calculations work properly, you’re going to need a way to monitor and track your order quantities, reorder points, safety stock levels, etc.

With the right inventory management system, you could even forget about EOQ altogether and use more up-to-date formulas that automate reordering for all of your products.

Interested in such a system?

Then we can help…

Our Inventory Management System Can Improve EOQ or Make it Irrelevant

Whether you want to use economic order quantity or not, our cloud-based inventory management system will help you streamline your business processes. From tracking your inventory in real-time to producing up-to-the-minute reports on past sales and future projections, DEAR Inventory will make sure you avoid stockouts and obsolete inventory while effectively serving your customers.

Start your free 14-day trial of DEAR Inventory today!

Try DEAR for Free

No Credit Card Required

Reorder Point Formula: This Is What You Need to Avoid Stockouts

Do you really need a reorder point formula to effectively manage your inventory?

Do you really need a reorder point formula to effectively manage your inventory?

Do you know when you’ll need to order more inventory before selling out?

Have you already experienced a few stockouts and don’t how to prevent them?

Are you relying on your “instincts” to calculate your reorder point?

You can stop being a victim to market spikes and slumps by using a proven, mathematical equation to help you consistently order the right amount of stock each month.

This equation is called a reorder point formula.

To help you improve your business processes, we’ll show you what a reorder point formula is, how to apply it effectively, and how to stop worrying about running out of stock.

By the end, you’ll be empowered with a formula that’ll help you stay on top of demands and streamline your supply chain management by accurately calculating your reorder quantity.

What is a Reorder Point Formula and How is it Calculated?

A reorder point formula tells you approximately when you should order more stock – when you’ve reached the lowest amount of inventory you can sustain before you need more.

Here’s the reorder point formula you can use today:

(Average Daily Unit Sales x Average Lead Time in Days) + Safety Stock = Reorder Point

To make this as easy as possible for you, we’ll show you how to calculate your average unit sales and lead time.

You will need to know your safety stock to make this formula work, but instead of going over that in this post, you can discover how to calculate your safety stock by visiting our post “The Power of Safety Stock Inventory and How to Calculate It.”

For the other two calculations, let’s start with daily unit sales.

How to Calculate Average Daily Unit Sales

Your average daily unit sales is the number of units you sell of a particular item over a specified period of time.

To take that out of the abstract, let’s use an example for the rest of this post to make it easy to understand.

Suppose you sell staplers.

To calculate your average daily unit sales, you would divide how many units of staplers you sold over a specified period of time.

If you sold 100 staplers over 30 days, you would divide 100 by 30.

100 divided by 30 = 3.33

So, your average daily unit sales is 3.33.

Let’s continue this example into average lead time.

How to Calculate Average Delivery Lead Time

The lead time is the amount of time it takes to receive a shipment of stock.

To get the average delivery lead time, you divide your total number of lead times by a set period of time, like 6 months.

In our stapler example, if you place an order every month, your lead time probably varies month-to-month and may look something like this:

January 8 Days
February 11 Days
March 9 Days
April 6 Days
May 7 Days
June 5 Days

Here’s how you calculate your average lead time:

Add up all the days (8+11+9+6+7+5) = 46.

Divide the total (46) by the number of orders placed, which is 6 because orders were placed once a month over 6 months.

46 divided by 6 = 7.67

7.67 is your daily average lead time.

Now that you have your average lead time and unit sales, you need to calculate your safety stock.

Again, we won’t go over that here, but you can easily calculate it using our formula in our other post on safety stock inventory.

For our purposes, let’s assume your safety stock is 20 staplers. Now, we’re ready to use our reorder point formula.

How to Calculate the Reorder Point Formula

Now that we’ve got all the numbers we need for our Stapler company example, we’re ready to plug everything into our reorder point formula.

Remember, the formula is:

(Average Daily Unit Sales x Average Lead Time in Days) + Safety Stock = Reorder Point

So, for our stapler example it would look like this:

(3.33 x 7.67) + 20 = 45.54

There you have it.

In our example, once your inventory gets down to 45 or 46 staplers, you should place an order for more.

This is a simple reorder point formula that you can use for each of your products. There are certainly more in-depth formulas you can use like this one, but the formula we’ve provided should be sufficient for most businesses.

However, just knowing the reorder point formula isn’t enough to streamline your business processes…

Here’s What You Need Next

To streamline your business, you’ll need to improve your rate of inventory turnover, upgrade your SCM software, and accelerate your stocktaking process.

But to make these processes and the reorder point formula work properly, you’ll need some way to track your orders, sales, and inventory levels

An Excel spreadsheet or pen and paper are error-prone methods that are dangerous and costly, especially when your business depends on correct and highly specific data.

If you want to manage your inventory with ease, receive real-time reports, and streamline your supply chain management, then you need to invest in cloud-based inventory management.

Use Inventory Management Software to Optimize Your Reorder Point Formula

Our cloud-based inventory management software will track every item from your supplier to your warehouse and on to your customer. You’ll know exactly how much inventory you have and how much you need, and can check those numbers any time of day, from anywhere in the world. We automate your processes and integrate our software with all your other business systems, ensuring your reorder point formula has the precise data it requires to work properly.

Start your free 14-day trial of DEAR Inventory today!

Try DEAR for Free

No Credit Card Required

 

The Power of Safety Stock Inventory and How to Calculate It

Calculating safety stock inventory is easier (and more beneficial) than you think

Calculating safety stock inventory is easier (and more beneficial) than you think

What would happen if there was a sudden spike in market demand for your products?

Would you have enough inventory to satisfy your customers?

Or would you have to hang up the dreaded “out of stock” sign?

If you’re unsure, then you probably need to invest in safety stock inventory.

Even if you think you could handle that type of situation, your business is still vulnerable to uncertain shifts in the market and supply chain.

One of the best ways to safeguard your business and satisfy your customers is to have safety stock inventory.

We’re going to go over some of the benefits of safety stock and show you how to use one simple formula to calculate it.

But first, let’s define safety stock inventory.

What is Safety Stock Inventory?

As the name implies, safety stock inventory is a small, surplus amount of inventory you keep on hand to guard against variability in market demand and lead times.

If you’re trying to implement just-in-time (JIT) inventory, then you probably won’t want to invest in safety stock.

But, if you’re like the majority of retailers and wholesalers who use a just-in-case (JIC) inventory strategy, safety stock is critical to your business operations and offers many benefits to your bottom line.

What are the Benefits of Safety Stock Inventory?

Safety stock plays an integral role in the smooth operations of your supply chain in various ways.

Here are just a few:

  • Protection against unexpected spikes in demand
  • Prevention of stockouts
  • Compensation for inaccurate market forecasts
  • And a buffer for longer-than-expected lead times

You probably noticed that the benefits of safety stock are all tied to mitigating problems that could seriously harm your business.

That’s because without safety stock inventory you could experience:

  • Loss of revenue
  • Lost customers
  • And a loss in market share

With safety stock, you can safely avoid most of these problems.

Of course, despite its benefits, too much safety stock can incur substantial carrying costs, in which case you’ll need to reduce inventory or increase your rate of inventory turnover.

This is why it’s crucial to know how to order just the right amount to safeguard against variability in the market and supply chain, while not ordering too much and risk losing capital over the long-term.

To get it just right, let’s look at how to calculate safety stock inventory using a proven formula.

How Do You Use a Safety Stock Formula for Accurate Calculation?

A safety stock formula is relatively straightforward and requires only a few inputs for calculation.

Here’s the formula we recommend using if you’re just starting out:

(Max Daily Sales x Max Lead Time in Days) – (Average Daily Sales x Average Lead Time in Days) = Safety Stock Inventory

To take this out of the abstract and show you how it works, here’s an example to demonstrate this formula:

Suppose there’s a store in the USA called Harry’s Honey Shop. Harry sells honey that’s imported from Brazil.

On average, he sells about 5 bottles of honey every weekday. On the weekends, he operates a stand at his local farmers market and sells about 10 bottles of honey.

His average lead time to get a fresh shipment of Brazilian honey is 40 days. Although, because of the limited availability of flowers and other environmental factors, it can take up to 50 days to receive a shipment (maximum lead time).

If Harry wants to make sure he always has enough honey in stock to satisfy customer demand, he can use this formula to figure it out:

(10 x 50) – (5 x 40) = 300

If Harry sells about 45 bottles a week (5 every weekday, 10 on the weekends) equaling 180 bottles a month, then with these calculations he would have enough stock to last him about a month and a half.

If Harry orders honey every month, he would have plenty of safety stock. Maybe even too much.

Now that Harry knows how much honey he needs to have, and how much extra he would probably have left over, he can slightly reduce the amount of honey he orders to guarantee a nice buffer in case there’s a spike in demand or longer lead times.

Now, this is a pretty basic safety stock formula that will get you up and running quickly. But, you should never solely rely on basic formulas like these to calculate safety stock.

Use them as a baseline, test them, and expand your calculations with more nuanced formulas to deal with large volumes of inventory, different types of stock, and volatile market demands.

If you want to dive deeper into safety stock formulas, you should check out this excellent article that will help you handle more complex variances, deviations, and variables in your calculations.

How Do You Make Calculating Safety Stock Easier?

A safety stock formula is only useful if you have accurate inventory metrics.

If you don’t have an effective SCM software, a successful stocktaking process, or a proven perpetual inventory system, then you run the risk of having inaccurate forecasts, inefficient stock counts, and error-ridden data.

Before you can optimize your inventory ordering process and factor in safety stock, you should upgrade your inventory management system.

Accurately Calculate Your Safety Stock Using Proven Inventory Management Software

Our cloud-based inventory management software will track all your sales, generate real-time reports on buyer behavior, forecast spikes and slumps in demand, and monitor every piece of inventory the moment it arrives and the moment it’s used or sold. If you want to reap the rewards of safety stock inventory, then you should invest in a powerful inventory management system.

Start your free 14-day trial of DEAR Inventory today!

Try DEAR for Free

No Credit Card Required