Formula Library

40+ Supply Chain Calculators

Inventory, MRP, production, procurement, logistics, customs, warehouse, supplier and automation calculations.

FORMULA 01

EOQ

√(2DS/H)




Result
FORMULA 02

Safety Stock

Average lead time




Result
FORMULA 03

Reorder Point

Demand × Lead Time + Safety Stock




Result
FORMULA 04

Inventory Turns

COGS ÷ Average Inventory



Result
FORMULA 05

Inventory Days

Inventory ÷ COGS × 365



Result
FORMULA 06

OTIF

OTIF ÷ Total × 100



Result
FORMULA 07

OTD

On-time ÷ Eligible × 100



Result
FORMULA 08

Fill Rate

Supplied ÷ Demanded × 100



Result
FORMULA 09

MAPE

Average(|A-F|/A) × 100



Result
FORMULA 10

WAPE

Σ|A-F| ÷ ΣA × 100



Result
FORMULA 11

Forecast Bias

Σ(F-A) ÷ ΣA × 100



Result
FORMULA 12

PPV

(Actual − Reference) × Quantity




Result
FORMULA 13

Supply Achievement

Actual ÷ Plan × 100



Result
FORMULA 14

Supplier Score

KPI Total − Penalties



Result
FORMULA 15

Capacity Load

Required ÷ Available × 100



Result
FORMULA 16

Capacity Utilization

Actual ÷ Available × 100



Result
FORMULA 17

OEE

Availability × Performance × Quality




Result
FORMULA 18

Yield

Good ÷ Input × 100



Result
FORMULA 19

Scrap Rate

Scrap ÷ Input × 100



Result
FORMULA 20

Rework Rate

Rework ÷ Production × 100



Result
FORMULA 21

Supplier PPM

Defects ÷ Supply × 1,000,000



Result
FORMULA 22

Picking Accuracy

Correct ÷ Total × 100



Result
FORMULA 23

Warehouse Productivity

Units ÷ Hours



Result
FORMULA 24

Warehouse Space Utilization

Occupied ÷ Available × 100



Result
FORMULA 25

Container Cube Utilization

Used ÷ Available × 100



Result
FORMULA 26

Freight Cost / Unit

Freight ÷ Units



Result
FORMULA 27

Freight Cost / KM

Freight ÷ KM



Result
FORMULA 28

Freight Cost / KG

Freight ÷ KG



Result
FORMULA 29

Premium Freight %

Premium ÷ Total × 100



Result
FORMULA 30

Landed Cost

Product + Freight + Other Costs




Result
FORMULA 31

Customs Duty

Value × Rate



Result
FORMULA 32

Cash Conversion Cycle

DIO + DSO − DPO




Result
FORMULA 33

Inventory Carrying Cost

Inventory × Rate



Result
FORMULA 34

Cost per Purchase Order

Cost ÷ Orders



Result
FORMULA 35

Perfect Order

Perfect ÷ Eligible × 100



Result
FORMULA 36

Backorder Rate

Backorders ÷ Demand × 100



Result
FORMULA 37

Kanban Cards

Demand × (1+Safety) ÷ Container




Result
FORMULA 38

MRP Net Requirement

Gross − Stock − Receipts




Result
FORMULA 39

Transport Load Factor

Actual ÷ Rated × 100



Result
FORMULA 40

Dock Utilization

Occupied ÷ Available × 100



Result
FORMULA 41

Order Cycle Time

Shipment − Order



Result
FORMULA 42

Automation ROI

(Benefit − Cost) ÷ Cost × 100



Result