- Supply chain analyst
- Junior
- 30 min
Net requirements
Calculate demand minus usable stock, with a minimum of zero. Usable stock is physical stock minus quarantined stock. Enter a formula in B12. The inputs belong to Pine Harbor Distribution, a fictional distributor.
Skills and rubricNet requirements
- Quarantine remains in the physical count but cannot fulfill customer demand. I would reconcile physical units to released units before calculating the net requirement. Otherwise the plan understates the purchase needed. The row-level quarantine status must agree with the stock snapshot date; a release tomorrow cannot satisfy demand due today.
- Usable supply rises by 10 units while the physical count stays unchanged. Reduce quarantine by 10 and recalculate the net requirement, which falls by 10 until it reaches zero. Do not add the released units to physical stock as well: that would count the same movement twice. Verify the release is effective before demand is due.
- I retain the source material, the saved answer and the decision owner because a plausible answer alone does not show which requirement was checked. I name the unresolved exception and the next review date.