Introduction

Effective inventory management is about more than just optimizing the costs of ordering and storing goods. Pricing strategy is also a crucial factor, as it directly influences customer demand. Price elasticity of demand helps predict how changes in prices will affect sales volume. This article will show how to combine the Economic Order Quantity (EOQ) model with price optimization and price elasticity of demand to achieve the best results in managing inventory and maximizing profits.

1. EOQ Basics with Price Optimization

The EOQ (Economic Order Quantity) model is a tool used to determine the ideal order size that minimizes the costs associated with inventory management and placing orders. Traditional EOQ focuses on balancing holding costs and ordering costs, but it can be expanded to include price optimization by considering demand as a function of price.

The EOQ formula:

where:

• D – annual demand for the product,
• S – cost to place an order,
• H – holding cost (often a percentage of the product’s unit price).

If demand depends on price, it’s expressed as a function D(P). This means the optimal order size will depend on the price you set, allowing for more dynamic inventory management.

Example:

Imagine a company that sells electronic devices and wants to determine the optimal order size to minimize both ordering and inventory costs while also optimizing prices. The data is as follows:

• Annual demand for the product (laptops) is D = 5000 units.
• The cost of placing an order is S = $1000.
• The holding cost is H = $100 per unit per year.

The EOQ formula gives us:

Interpretation:

The optimal one-time order quantity is 316 units, which minimizes the combined costs of holding inventory and placing orders.

Price Optimization Example: If the company changes the price of the laptops, demand will also change based on the price elasticity of demand (see the next section). The company can simulate different price points to find the optimal price that minimizes inventory costs while increasing demand.

2. Price Elasticity of Demand: The Key to Optimization

Price elasticity of demand (E) measures how much demand changes when the price changes. It’s calculated as:

n a price optimization model, inventory quantity (Q) and price (P) are connected through this relationship. The demand function might look like:

where: 

• D₀ = initial demand at the original price P₀, 
• E = price elasticity of demand.

Example:

Suppose a company sells smartphones and decides to lower prices to boost sales. When the smartphone price was P₀ = $3000, the company sold D₀ = 1000 units per year. After lowering the price to P = $2700, annual sales increased to D = 1200 units. We can calculate the price elasticity of demand as:

Interpretation:

An elasticity of -2 means demand is highly sensitive to price changes. For every 1% drop in price, demand increases by 2%. This allows the company to set prices more effectively based on customer sensitivity.

3. Margin Optimization: Calculating the Optimal Price

 To maximize profit margins, the optimal price (P*) depends on both the unit cost (C) and the price elasticity of demand (E). The formula for the price that maximizes profit is:

Example:

Let’s assume a company manufactures washing machines, and the cost to produce one machine is C = $1000. Based on the elasticity from the previous example (E = -2), we can calculate the optimal price:

Interpretation:

To maximize profit, the company should price the washing machines at $2000 each, accounting for the elasticity of demand.

4. Simulating Inventory Levels at Different Price Points

To simulate inventory levels at different price points, a modified EOQ model can be used. This model considers the impact of price on demand. Combining EOQ with price elasticity of demand results in the following formula for inventory at variable prices:

where:

• Q(P) is the inventory that will be needed at a given price P,
• C is the cost of purchasing a unit of the product.

Example:

Suppose a company sells computers and wants to analyze the inventory needed at different prices. Using the EOQ model and elasticity of demand, we assume:

• The cost to purchase a computer is C = $1500.
• The original price was P₀ = $3000, and the company changes it to P = $2800.

If the initial EOQ is 500, we can calculate the new optimal inventory level:

Interpretation:

At a price of $2800, the company should maintain an inventory of 366 units to minimize costs while meeting demand.

5. Algorithm for Price and Inventory Optimization

A step-by-step algorithm might look like this:

   1) Identify the key parameters:

• • Initial demand D₀,
  • Unit cost C,
  • Initial price P₀,
  • Ordering cost S,
  • Holding cost H,
  • Price elasticity of demand E.

   2) Establish the price-dependent demand function:

   3) Calculate the optimal price P*:

   4) Determine new demand at the optimal price:

   5) Calculate the optimal order size (EOQ) at the new price:

   6) Simulate inventory levels based on the new demand, price, and costs.

Example:

Let’s assume that a company sells printers and wants to run a simulation of inventory levels and optimal pricing. Below is a step-by-step algorithm for the simulation:

   1) Defining the basic parameters:

• Initial demand is D₀ = 1000 units,
• Unit cost is C = $500,
• Initial price is P₀ = $800,
• Ordering cost is S = $100,
• Holding cost is H = $50,
• Elasticity is E = -1.5.

   2) Determining the demand function dependent on price:

If the price changes to P = $750, the demand will be:

D(750) = 1093 units

   3) Calculating the optimal price:

Interpretation:

At a price of $750, with demand at 1093 units, the company should order 209 units to minimize inventory costs.

6.  Managing Product Relationships: Cannibalization and Complementarity

To manage product relationships, such as cannibalization (where sales of one product reduce sales of another) or complementarity (where increased sales of one product boost sales of another), coefficients representing these relationships can be integrated into the algorithm. The simulation could include:

1) Defining dependency functions between products using cannibalization (K) and complementarity (C) coefficients:

and

where:

• Kij is the coefficient of cannibalization between products i and j,
• Cij is the coefficient of complementarity between products i and j.

   2) Updating product demand based on the effects of one product’s price on the sales of another.

   3) Recalculating optimal prices and inventory levels for all related products.

Example:

Suppose a company sells laptops and mice. The price of laptops may affect mouse sales (complementarity) and the sales of older laptop models (cannibalization). The simulation parameters are:

• Demand for new laptops is D₁ = 1000 units, and for old laptops, D₂ = 500 units.
• Cannibalization coefficient K12=0.3 (selling new laptops reduces old model sales by 30%),
• Complementarity coefficient C13=0.2 (increased laptop sales boost mouse sales by 20%).

After updating the demand:

Interpretation:

An increase of 200 units in new laptop sales results in a decrease of 60 units for older laptops (cannibalization) and an increase of 40 units for mice (complementarity). By factoring in the relationships between products, the company can better manage both inventory and pricing strategies.

Summary

Optimizing inventory and pricing using price elasticity of demand is essential for businesses operating in competitive environments. Combining the EOQ model with a dynamic pricing strategy enables companies to minimize inventory costs while maximizing profits by adjusting prices to market conditions. Additionally, considering product relationships such as complementarity and cannibalization provides a more comprehensive view for managing a portfolio of products. This helps companies respond to changes in demand more effectively, achieving greater operational and financial efficiency.