Running a profitable business means managing inventory to suit the needs of the company, while meeting the demands of the market. One of the essential elements of effective inventory management used to grow and manage a business, calculating the EOQ can make a robust impact on profitability. Holding costs for over-purchased inventory can deplete profit, so it may be valuable to utilize the Economic Order and Quantity Model (EOQ) to best manage an appropriate flow of product.
The economic order quantity (EOQ) model assumes a continuous and constant rate for demand, and is meant to be used to discover the ideal order quantity a company should purchase for inventory. It is important to note that the EOQ is not the reorder point— the formula illustrates how much to order, not when to order it.
The EOQ model combines the costs associated with a product, including:
Combining these factors should “balance intangible inventory costs against the tangible costs of ordering” as discussed by Donal Erlenkotter in his analysis of the Economic Order Quantity Model.
The EOQ is calculated as follows:
The formula represents:
The goal of calculating the EOQ is to determine the optimum number of units to order while minimizing costs related to purchasing, delivery, and storage. Understanding the amount of needed product may release cash from being tied up in inventory balance which, in turn, may be used for other business purposes or investments. To do this, EOQ considers the ordering cost, and storage of assets.
Demand is the willingness of the consumer to pay a specific price to make a purchase on a good or service. This term can be applied both to a specific good, or the aggregate demand of the total number of goods in an economy. The tug of war between the demand and supply of a good is what determines the price, as set by the desire of the consumer. Businesses often try to determine the demand of the consumer over a given time period, to estimate and understand the supply quantity needed to sell at a reasonable price to meet equilibrium.
One component of the total inventory cost is storage. Holding cost is calculated as unsold inventory, which includes the storage space, labor, and insurance associated with storage. The price of damaged or spoiled goods may also be calculated into holding costs.
The logistics of sourcing, shipping, and storing cannabis and cannabis products can be difficult. This is especially true as markets continue to expand and require more tactful and complex management solutions to transporting and tracking a variety of cannabis products.
Consider a cannabis dispensary that sells edibles. Among the sourcing difficulties, there are two major considerations for keeping operation costs down: limited warehouse space, and shelf life of the product. Perhaps the dispensary does not have the storage available to hold on to too much inventory, and also does not want to purchase too much inventory that may spoil and increase holding costs. However, the company wants to ensure that they meet consumer buying habits. In this case, determining the EOQ is valuable to understanding the flow of the market and the amount of product needed to meet demand. There are many EOQ calculators available online to help, but the formula may be used as follows:
The dispensary sells 5,000 edibles per year. It costs the company $2 a year to hold an edible in storage. The fixed cost of placing an order is $5.
The formula would look as such:
Q=The Square root of (2 x 5,000 edibles x $5 order cost) / $2 holding cost
Q= 158.2 (rounded up)
The optimum order amount is just over 158.
It should be noted that this number does not represent the purchase cost of the product, nor does it provide insight into reordering. It merely represents the most optimal amount of product to be purchased per order. The reorder point formula is slightly more complicated and reflects the trigger of the placement of an order for additional products. The reorder point can also be manipulated to include a safety stock, which is determined by how crucial the item is to sales or production.
Utilizing the EOQ model helps lower, and keep inventory costs as low as possible, by:
Though the EOQ formula is quite simple to calculate, the calculation does require numerous assumptions including steady demand, sales, fixed costs, and readily available products to be restocked.
Another difficulty that may arise is that the EOQ is based on one product. If a company sells multiple products, an EOQ will need to be calculated and tracked for each. The EOQ also does not account for seasonal or economic fluctuations, and thus must be recalculated for seasonality and changes in the market. The best way to utilize EOQ is to manage and track products and variables in the industry, and to calculate a new EOQ with each order to ensure the minimum order quantity (MOQ) is being met.