Purchasing & Procurement
EOQ, Safety Stock & Supplier Volume Discount Optimizer
Balances order setup costs, warehouse holding costs, and supplier tiered price breaks to find your lowest total annual cost.
Presets:
Optimal Order Size (Q*)
Tier 2 Discount
1,000 units
12.0 orders/year • $48.00/unit
Min Total Annual Cost
$595,400
Includes material, setup & holding
Reorder Point (ROP)
685 units
Includes 192 units Safety Stock
Annual Savings vs. Naive
+$24,850
vs. unoptimized monthly ordering
1. Demand & Cost Parameters
Annual Demand (D)
12,000 units
Order Setup / PO Cost (S)
$250 / order
Annual Holding Cost Rate (H)
22% of unit cost
Base Unit Price (Tier 1: <1,000)
$50.00
2. Supplier Discounts & Lead Time
Tier 2 Discount (1,000+ units)
4.0% off
Tier 3 Discount (2,500+ units)
8.0% off
Supplier Lead Time
15 days
Annual Ordering, Holding & Total Inventory Cost Curve
Illustrates how ordering larger quantities lowers setup costs but raises warehouse carrying costs
Supplier Volume Discount & EOQ Decision Matrix
Evaluates all 3 price tiers + standard EOQ| Scenario / Tier | Order Qty (Q) | Unit Price | Annual Material | Setup Cost | Holding Cost | Total Annual Cost |
|---|
