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
I'll solve this Economic Order Quantity (EOQ) problem with quantity discounts and defective units step by step:
Step 1: Adjust Demand for Defective Units
- Total annual demand: 10,000 units
- Defective rate: 2%
- Usable units needed: 10,000 ÷ (1 - 0.02) = 10,204.08 units
Step 2: Calculate Order Quantities and Total Annual Costs for Each Price Tier
Tier 1 (0-3,000 units at $4.00):
- Order Quantity (Q1): 3,000 units
- Unit Price: $4.00
- Ordering Cost per Order: $300
- Annual Ordering Cost: (10,204.08 ÷ 3,000) × 1,021.41
- Annual Purchase Cost: 10,204.08 × 40,816.32
- Holding Cost (usable units): (3,000 ÷ 2) × 600
- Disposal Cost: 3,000 × 0.02 × 120
- Total Annual Cost (TAC1): $42,557.73
Tier 2 (3,001-6,000 units at $3.90):
- Order Quantity (Q2): 6,000 units
- Unit Price: $3.90
- Annual Ordering Cost: (10,204.08 ÷ 6,000) × 510.20
- Annual Purchase Cost: 10,204.08 × 39,795.91
- Holding Cost: (6,000 ÷ 2) × 1,200
- Disposal Cost: 6,000 × 0.02 × 240
- Total Annual Cost (TAC2): $41,746.11
Tier 3 (>6,000 units at $3.80):
- Order Quantity (Q3): 10,204.08 units (rounded to 10,205)
- Unit Price: $3.80
- Annual Ordering Cost: (10,204.08 ÷ 10,205) × 300
- Annual Purchase Cost: 10,204.08 × 38,775.50
- Holding Cost: (10,205 ÷ 2) × 2,041
- Disposal Cost: 10,205 × 0.02 × 408.20
- Total Annual Cost (TAC3): $41,524.70
Step 3: Determine Optimal Order Quantity
The lowest Total Annual Cost is in Tier 3: 3.80
Final Answer
- Optimal Order Quantity: 10,205 units
- Lowest Annual Total Cost: $41,524.70
Key considerations:
- Adjusted demand for defective units
- Evaluated all price tiers
- Included disposal costs for defective units
- Calculated comprehensive total annual cost
Other models, same or similar prompt
Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.