Private test sheet

Synthetic Stock Check

Four sample items checked against their reorder thresholds. Change any count and every figure below updates as you type.

  • End = Start + Received − Shipped
  • REORDER only when End < Threshold
  • End equal to Threshold is OK

Summary

Total End

31

Across all four items

Reorder

  • M1
  • M4

End is below Threshold

Items

Click any count to change it. Arrow keys step by 1, Shift + arrow by 10.

Starting values

  • M1
    REORDER1 below threshold
    End6
  • M2
    OKAt threshold
    End14
  • M3
    OK1 above threshold
    End11
  • M4
    REORDER1 below threshold
    End0

Total End 31. Reorder M1, M4.

Everything here runs in your browser only. Nothing is saved, sent or shared, and reloading the page brings back the starting figures.