Analysis for SKU $=123-456789$

SUMLEV REGION DIVISION STATE NAME Population Estimate for $2022$ Percentage of Sales Annual Sales Forecast $($units$)$ EOQ $($units$)$ ROP $($units$)$ Number of Orders per Year that you'll make as the Purchasing Agent

$10000$ United States $329,092,106100\%$

SUMLEV REGION DIVISION STATE Note $--$ to compute these values, use the computed results below that are pulled from previous worksheets

$20100$ Northeast Region $55,982,803$

$20200$ Midwest Region $68,329,004$

$20300$ South Region $125,580,448$

$20400$ West Region $79,199,851$

Inventory Analysis: NOTE $--$ data sheets MUST BE FILTERED for a single SKU analysis.

SKU to analyze $=123-456789$

Demand $=($computed by region, see above$)$

Order Processing Cost $=$ $$95\mathrm{.}88$ per order

Inventory Holding Cost Rate $=38\mathrm{.}3\%$ annually

Cost per Unit $=$ $$60\mathrm{.}79$

Lead time $=39\mathrm{.}3$ days

StDev of Lead Time $=6\mathrm{.}04$ days

StDev of Demand $=7\mathrm{.}59$ units

Service level $=97\%($assumption for high service but avoiding higher costs$)$

z $=1\mathrm{.}881$