Key Takeaways
- Optimal order quantity, often calculated using the economic order quantity (EOQ) formula, helps businesses determine how much inventory to order to meet demand without tying up excess cash.
- Calculating EOQ requires a clear understanding of annual demand, order costs, and holding costs, all of which directly impact profitability and cash flow.
- While the EOQ formula provides a useful baseline, real-world factors like seasonality, lead time changes, supplier constraints, and fluctuating costs can affect its accuracy.
- Manually calculating optimal order quantity becomes increasingly difficult as product catalogs grow and demand patterns change more frequently.
- Automated inventory planning tools can continuously adjust order quantities based on live data, helping businesses place smarter orders and avoid stockouts or overstock.
Inventory management and planning are crucial components of any retail, e-commerce, or wholesale business’s assets and supply chain strategy. In order for your business to achieve a proper inventory balance, you must perform careful calculations and consider a variety of factors to ensure your stock levels can meet demand without becoming a drag on your cash flow due to inventory holding costs.
Achieving this balance requires merchants to engage in proper inventory planning to make sure they have the right amount of stock at the right time. When done right, inventory planning can help your business avoid stockouts, minimize unnecessary overstock and deadstock, improve stock turnover, prevent delays in fulfillment, and increase cash flow and revenue.
A critical component of inventory planning is accurately calculating optimal order quantity, which helps businesses know when and what to order to maintain customer satisfaction and profitability while avoiding unnecessary storage, administrative, and insurance costs.
What is Optimal Order Quantity?
Optimal order quantity, also known by the formula economic order quantity (EOQ), represents the ideal amount of inventory a business should have at any given time to meet demand without holding too much excess stock. Calculating optimal order quantity using an economic order quantity formula and incorporating other mitigating factors will provide you with the precise number of units to purchase for each product in your catalog. It can also help you determine your reorder point (ROP) when you should submit the next purchase order to your supplier.
Factors That Affect Optimal Order Quantity
While the EOQ formula can provide a baseline, optimal order quantity is heavily contingent on a variety of other factors, including how often you turn over inventory, the sales velocity of certain products, the manufacturing and lead times of your suppliers, minimum order quantities, shipping transit times, and more.
Before attempting to calculate your EOQ, there are a few inventory metrics you must know:
Annual demand
Annual demand, also known as annual usage, refers to how much customer demand there is for a particular product in any given year. You can determine this by looking at historical data points such as turnover ratio, previous reorder points, and past purchase orders. This will give you a clear picture of how many units you’ve sold year-over-year.
Order costs
Order costs, also known as setup costs, are all the costs associated with placing an order with your supplier. These include administrative costs involved in creating purchase orders and invoices, packaging and delivery costs, product inspections, receiving shipments at the warehouse, and other fulfillment costs that go into every order placed.
Holding costs
Your annual holding cost refers to how much it costs to keep the stock for one year. These include any expenses related to storing inventory as well as opportunity costs from inventory retention, including rent and operational fees for any warehousing or storage, interest on loans to purchase stock, insurance premiums, warehouse employee salaries, and depreciation costs.
To calculate holding costs, use the following formula:
(employee salaries + storage costs + associated costs + opportunity costs + depreciation costs) / total value of annual inventory = holding cost
By adding up employee salaries, storage and other inventory costs, opportunity costs, and depreciation costs, then dividing the sum by the total value of your annual inventory, you get your inventory holding cost (expressed in a percentage).
Once you’ve determined these three values, you have the information necessary to calculate optimal order quantity.
Automated purchasing suggestions
Let Inventory Planner work out your optimal order quantity
What is the Optimal Order Quantity Formula?
To calculate optimal order quantity (economic order quantity), you can use the following EOQ formula:
the square root of (2[DO] / H) = EOQ (optimal order quantity)
Where D = Annual unit demand, O = Cost per order, and H = Holding cost per unit
- First, you multiply annual unit demand (D) by the cost per order (O)
- Then you multiply that answer by two.
- Next, you take that number and divide it by your holding costs per unit (H)
- Finally, take the square root of that number to get your EOQ (optimal order quantity)
For example, if you sell 500 shirts a year, and you pay $6 per unit for an order, and $8 a unit to store the inventory for a year, your EOQ formula will look like this:
The square root of (2 x [500 shirts x $6 ordering cost]) / $8 holding cost = ~9.7
According to the formula, your optimal ordering quantity, or EOQ, is ~10 units. This amount will meet your customer demand without incurring excessive overhead costs.
How to Calculate Optimal Order Quantity with the EOQ Formula
Here’s how to find optimal order quantity using the economic order quantity (EOQ) formula:
the square root of (2[DO] / H) = EOQ (optimal order quantity)
Where D = Annual unit demand, O = Cost per order, and H = Holding cost per unit
- First, you multiply annual unit demand (D) by the cost per order (O)
- Then you multiply that answer by two.
- Next, you take that number and divide it by your holding costs per unit (H)
- Finally, take the square root of that number to get your EOQ (optimal order quantity)
For example, if you sell 500 shirts a year, and you pay $6 per unit for an order and $8 a unit to store the inventory for a year, your EOQ formula will look like this:
The square root of (2 x [500 shirts x $6 ordering cost]) / $8 holding cost = ~9.7
According to the formula, your optimal ordering quantity, or EOQ, is ~10 units. This amount will meet your customer demand without incurring excessive overhead costs.
Assumptions Affecting Optimal Ordering Quantity’s accuracy
While it is a useful calculation, the economic order quantity formula requires you to make six important assumptions that can negate its accuracy in practical applications:
- Demand will remain constant. This assumption becomes problematic when dealing with seasonal items or in markets where customer demand is continually and rapidly shifting due to various factors like influencer culture, macroeconomic changes, and emerging sales channels.
- The unit prices remain constant. This assumption does not hold true when production and shipping costs fluctuate.
- The holding cost per unit remains constant. This assumption does not hold true when inflation is high and overhead costs are subject to increases.
- The setup costs remain constant. This assumption does not hold true when delivery costs fluctuate, inspection regulations change, or other fulfillment costs go up.
- Orders are never delayed. This assumption does not account for supply chain disruptions due to reduced shipping capacities, warehouse space and labor shortages, as well as global events that may impede trade and shipping routes.
- There are no discounts on any of your orders. This assumption doesn’t work for businesses with strong seasonality or significant sales and promotions during retail holidays like Black Friday.
If any of these assumptions change during any given time period, and many will, it may affect the accuracy of your calculated optimal order quantity.
Limitations of Manually Calculating Optimal Order Quantity
Determining optimal order quantity and incorporating it into how and when you place your orders requires sophisticated calculations that factor in many dynamic variables to achieve accuracy. With today’s fast-moving customer demand, highly disrupted supply chains, and shifting lead times, it’s nearly impossible to keep your calculations up-to-date when done manually, especially if you have a large catalog or launch new products often. To ensure forecasting accuracy and precise ordering recommendations, you need automated, reliable inventory planning software that does all the heavy lifting for you. That’s where Inventory Planner comes in.
How Inventory Planner Can Help
By implementing dynamic inventory planning software like Inventory Planner, you can say goodbye to manually calculating complex formulas and trying to keep track of a variety of shifting variables for each of your SKUs. Inventory Planner automatically calculates how much inventory you need and when to place each order. It syncs with your business’s tech stack, using product and sales data from your online sales channels, accounting, shipping, inventory management, warehouse management, order management, ERP, and any other software you use to ensure up-to-date insights. It also factors in critical fluctuations like seasonality, customer demand shifts, promotions, and marketing activities for ultimate accuracy.
Not only does Inventory Planner tell you what to order and when to order, but it also offers insightful, customizable inventory performance reporting. Its 200+ meaningful metrics plus additional marketing metrics pulled from Google Analytics allow you to make truly data-driven decisions. So, ditch the spreadsheets and manual data entry for intuitive, dynamic inventory planning software that can streamline your economic order quantity process and save you time and money on inventory management.
Frequently Asked Questions
What is the difference between EOQ and optimal order quantity?
– EOQ, or economic order quantity, is a specific formula used to calculate optimal order quantity under a defined set of assumptions. Optimal order quantity is the broader concept. It represents the ideal amount of inventory to order based on demand, costs, and operational realities. In practice, optimal order quantity often starts with EOQ and is then adjusted to account for factors like seasonality, lead times, promotions, and supplier constraints.
How do you calculate the optimal order quantity?
– To calculate optimal order quantity, you begin by determining your annual demand, order costs, and holding costs. These values are used in the EOQ formula to produce a baseline quantity. From there, businesses typically refine that number by factoring in real-world conditions such as sales trends, inventory turnover, lead times, and minimum order requirements.
What is the EOQ formula?
– The EOQ formula is written as:
EOQ = √(2[DO] / H)
Where:
- D is annual unit demand
- O is the cost per order
- H is the holding cost per unit per year