Service

Target service level by ABC (annual $ value class) x XYZ (demand variability class), from the source workbook's Categories sheet. Drives the z-score/safety-stock calculation on Stocking Policy.

XYZ
A99%98%96%
B97%95%92%
C93%90%85%
D

The service-level frontier

Their own words: “it's very easy to meet that service level if you want your balance sheet to be super bloated.” This is that trade-off priced: the same engine rows with A-item safety stock re-scaled to each candidate target (2,573 A item-DCs of 5,873 replenished). Hover any point.

$39,987,237$42,157,715$44,328,192$46,498,67090%92.5%95%97%98%99%99.5%A-item service-level target (B/C items unchanged)today's policy