Q.3 (Inventory Management) Consider the following EOQ problem faced by a retailer…
- User
Q.3 (Inventory Management) Consider the following EOQ problem faced by a retailer sourcing a product with quantity discounts and a known defective rate. The key EOQ information is as follows: • Annual demand: 10,000 units • Ordering setup cost: 0.4 per unit (based on usable units) • Insurance rate is 0%. • Price discount scheme: Order Quantity Price per unit 0– 3,000 units 3.90 > 6,000 units 0.2 per unit immediately upon receipt and are not returned to the supplier. What is the optimal order quantity and the lowest annual total cost? Detailed solution steps are needed. (10 points)
Assistant
We are given an Economic Order Quantity (EOQ) problem with:
- Quantity discounts
- Defective rate of 2%, which reduces usable units and incurs disposal cost
- Holding cost is based on usable units
Step 1: Understand the Parameters
Given:
- Annual demand (D) = 10,000 usable units
- Ordering cost (S) = $300 per order
- Holding cost (H) = $0.40 per unit per year (based on usable units)
- Defect rate = 2%
- Disposal cost for defective items = $0.20/unit
- Price discount schedule:
Order Quantity Unit Price (c) 0 – 3,000 $4.00 3,001 – 6,000 $3.90 >6,000 $3.80
Step 2: Adjust Demand to Account for Defects
Since 2% of ordered units are defective, only 98% are usable.
Let Q be the actual number of units ordered. Then the number of usable units is:
So to get D = 10,000 usable units, we need to order:
This will be used in total cost calculations.
Step 3: EOQ Formula and Total Cost Function
The classic EOQ formula is:
But since there are quantity discounts, we must calculate the total annual cost (TAC) for each price range and determine the best one.
Step 4: Define Total Cost Components
Total annual cost includes:
-
Purchasing cost:
-
Ordering cost:
-
Holding cost:
-
Disposal cost for defective units:
Thus, the Total Annual Cost (TAC) function becomes:
Where:
- = unit cost from the price table
- = order quantity
Step 5: Compute EOQ for Each Price Range
We’ll compute the EOQ under each price level and then check if it lies within that price range. If not, we’ll test the boundary values.
Price Range 1: 0–3,000 units; c = $4.00
Compute EOQ:
But this falls outside the 0–3,000 range → Not applicable. So we'll use Q = 3,000.
Now compute TAC at Q = 3,000:
-
Purchasing cost:
-
Ordering cost:
-
Holding cost:
-
Disposal cost:
Total Cost = 40,000 + 1,000 + 588 + 12 = $41,600
Price Range 2: 3,001–6,000; c = $3.90
Compute EOQ again:
This lies within the range 3,001–6,000 ⇒ Use Q = 3,873
Compute TAC:
-
Purchasing cost:
-
Ordering cost:
-
Holding cost:
-
Disposal cost:
Total Cost ≈ 39,000 + 774.60 + 758.81 + 15.49 ≈ $40,548.90
Price Range 3: >6,000; c = $3.80
Compute EOQ:
Same as before ⇒ Q* = 3,873 < 6,000 ⇒ Not in range
So we test the lower bound of this range: Q = 6,000
Compute TAC at Q = 6,000:
-
Purchasing cost:
-
Ordering cost:
-
Holding cost:
-
Disposal cost:
Total Cost = 38,000 + 500 + 1,176 + 24 = $39,700
Step 6: Compare Total Costs
Order Qty Unit Price Total Cost 3,000 $4.00 $41,600 3,873 $3.90 $40,549 6,000 $3.80 $39,700 ✅
✅ Final Answer:
- Optimal Order Quantity: 6,000 units
- Lowest Annual Total Cost: $39,700
This accounts for:
- Quantity discounts
- 2% defect rate
- Disposal costs for defective units
- Holding cost based on usable units
Other models, same or similar prompt
Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.