INVENTORY MANAGEMENT | 5 minute read
Everything is better in moderation, they say. This is particularly true when it comes to inventory stock. There should not be too much or too little as it can greatly affect your sales and profitability. Here’s when inventory planning and management can help.
Companies that source, produce and manufacture raw materials must analyze demand, decide when and how much to order. This is called inventory planning. Effective inventory planning augments company efforts in forecasting demand while minimizing costs. It also reduces the amount of inventory stored (and therefore, storage costs) and make best use of their manufacturer’s space, time and equipment.
Merchants that deal with partially completed goods (called work in progress or WIP), finished goods and/or goods-in-transit to warehouses or customers (or GIT) must focus on inventory review and tracking.
You’re probably thinking… with all this work involved, why should I hold inventory, then?
There are 3 main reasons to hold inventory:
Related blog: Identify & optimize top selling products with ABC inventory management
Most successful eCommerce merchants and retail operators are driven by a precautionary motive to avoid stockouts. Using a deterministic inventory model – like the Economic Order Quantity (EOQ) model – will help you compute an optimal order quantity that minimizes inventory costs (and avoid the most feared aspect of eCommerce).
The EOQ is a formula that calculates the most economical number of items a business should order to minimize costs and maximize value when re-stocking inventory.
For example:
ACME Inc. produces cosmetics to sell to wholesalers. One of the raw materials it purchases is lavender hydrosol, bought at the rate of $22.50 per ton. ACME Inc.’s forecasts show an estimated requirement of 5,75,000 tons of lavender hydrosol for the coming year. The annual total carrying cost for this material is 40% for cost of acquisition, and the ordering cost is $595. What is the Most Economical Order Quantity?
D = 5,75,000 tons
C =0.40(22.50) = $9.00/Ton/Year
S = $595/Order
= 27,573.135 tons per Order
This means that if you order 27,573 tons of lavender hydrosol of inventory, every time you place an order, you will minimize your inventory costs – both your ordering and carrying costs.
However, the EOQ model assumes constant (steady) demand of a product and immediate availability of items to be restocked. It does not account for seasonal or economic fluctuations. It assumes fixed costs of inventory units, ordering charges and holding charges. No stockouts are permitted.
This inventory model requires continuous monitoring of inventory levels. The effectiveness of the basic EOQ model is most limited by the assumption of a one-product business, and the formula does not allow interaction between products.
Moreover, EOQ assumes an infinite planning horizon and that there’s no limit on capital availability.
Related blog: QuickBooks Commerce and Inventory Planner: Integration
Accurate business accounting also requires inventory counting. Two methods allow you to review your inventory on two different timeframes:
Continuous (or perpetual) inventory system keeps a constant track of quantities; as soon as they get below a cutoff level (called the reorder point), the manager places an order for a predetermined quantity which is calculated to keep inventory costs low.
Advantages:
Disadvantages:
Periodic inventory system uses a very simple method: counting what's in the store or the warehouse by hand. Using this system, the amount of stock on hand is assessed periodically (i.e., every week or month or some other fixed-time interval). The amount to order is then determined based on the amount on hand and expected demand. Therefore, all the orders are placed in one batch per period.
Advantages:
Disadvantages:
For most businesses, these three models can seem daunting. Imagine calculating the above EOQ formula manually! Or paying a professional inventory company to come in to count your inventory manually.
Good inventory planning and management lies in understanding what stock you have on hand, where it is in your warehouse(s), and how it’s coming in and out. With the right inventory planning tool, you’ll be able to:
Spend less time on these back office functions, and remain at the forefront of making a profit for your business with an inventory planning tool like QuickBooks Commerce.
