Supply Chain Tools
Bullwhip Effect Analyzer
Paste one time period per line to compare incoming demand with outgoing replenishment orders and detect demand amplification.
Period; customer demand; replenishment order Example: Week 1; 120; 140
The tool compares the variability of orders against the variability of demand. A bullwhip effect is typically present when order variance is greater than demand variance.
Mean demand = average of all demand values
Mean orders = average of all replenishment order values
Sample variance is used for both series
Bullwhip ratio = variance of orders / variance of demand
Interpretation:
Ratio > 1.00 → amplification present
Ratio ≈ 1.00 → similar variability
Ratio < 1.00 → orders are smoother than demand
EOQ Calculator
Calculate the economic order quantity and estimate annual ordering, holding, and purchase cost.
EOQ = √(2DS / H)
Orders per year = D / EOQ
Annual ordering cost = (D / EOQ) × S
Annual holding cost = (EOQ / 2) × H
ABC / XYZ Classification
Paste one item per line in the following format:
SKU; annual consumption value; coefficient of variationSemicolon and comma separated input is supported. The coefficient of variation is optional.
ABC thresholds by cumulative annual consumption value:
A ≤ 80%, B ≤ 95%, C > 95%
XYZ thresholds by coefficient of variation:
X ≤ 0.5, Y ≤ 1.0, Z > 1.0
Pallet / Container Fill Calculator
Estimate how many cartons fit into a pallet or container based on dimensions, stacking height, and the better layer orientation.
Two layer orientations are checked: carton length aligned with pallet length, and carton width aligned with pallet length.
The better layer result is selected, then multiplied by the number of full layers fitting in the usable height.
Landed Cost Calculator
Estimate total landed cost per unit including product value, freight, insurance, duties, import fees, and inland transport.
Goods value = unit cost × quantity
Customs value ≈ goods value + international freight + insurance
Duty amount = customs value × duty rate
Total landed cost = goods value + freight + insurance + duty + fees + inland freight
Safety Stock & Reorder Point Calculator
Estimate safety stock and reorder point based on daily demand variability, lead time, and target service level.
Safety stock ≈ Z × σLT
σLT = σdaily × √(lead time)
ROP ≈ average daily demand × lead time + safety stock