Inventory Position Calculator with Backorders
Calculate inventory position in units by combining stock on hand with confirmed inbound orders and subtracting quantities already backordered.
Formula & assumptions
Inventory position = on hand + on order − backorders
Count each open supply order once. A negative balance means backorders exceed available and inbound quantities.
Worked example
- On hand (units)
- 125
- On order (units)
- 60
- Backordered (units)
- 35
- Inventory position
- 150 units
Interpreting the result
A position of −15 units means available and inbound quantities together still leave 15 backordered units uncovered.