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$ SKU Description Cost $($$ per unit$)$ Annual sales $($units$)$ Average sales $($units per day$)$

$123-456789$ Voice Assistant IoT Add$-$on Box, $4$ GB $$60\mathrm{.}7915,764259\mathrm{.}3$ Date of Order SKU Quantity $($units$)$ Purchase Order Cost $($$$)$ Cost to process order, S $($$$)$ Delivery Date Lead$-$time $($days$)$

January $1,2021123-456789864$ $$40,342$ $$79\mathrm{.}95$ February $19,202149$

January $19,2021123-456789790$ $$36,575$ $$82\mathrm{.}08$ March $2,202142$

February $5,2021123-456789801$ $$37,133$ $$87\mathrm{.}11$ March $23,202146$

February $28,2021123-456789790$ $$36,571$ $$102\mathrm{.}43$ April $13,202144$

March $19,2021123-456789750$ $$34,553$ $$95\mathrm{.}97$ May $2,202144$

April $9,2021123-456789732$ $$33,624$ $$112\mathrm{.}26$ May $23,202144$

April $22,2021123-456789836$ $$38,910$ $$107\mathrm{.}22$ June $2,202141$

May $13,2021123-456789813$ $$37,725$ $$95\mathrm{.}16$ June $15,202133$

May $31,2021123-456789856$ $$39,946$ $$78\mathrm{.}54$ July $2,202132$

June $14,2021123-456789783$ $$36,200$ $$107\mathrm{.}40$ July $18,202134$

July $2,2021123-456789850$ $$39,608$ $$92\mathrm{.}71$ August $9,202138$

July $23,2021123-456789833$ $$38,743$ $$82\mathrm{.}35$ August $29,202137$

August $17,2021123-456789773$ $$35,709$ $$105\mathrm{.}12$ September $23,202137$

August $29,2021123-456789767$ $$35,423$ $$82\mathrm{.}37$ September $28,202130$

September $19,2021123-456789785$ $$36,334$ $$105\mathrm{.}14$ November $5,202147$

October $11,2021123-456789789$ $$36,539$ $$112\mathrm{.}56$ November $21,202141$

October $29,2021123-456789825$ $$38,325$ $$85\mathrm{.}15$ November $28,202130$

November $18,2021123-456789795$ $$36,807$ $$111\mathrm{.}33$ December $21,202133$

December $8,2021123-456789867$ $$40,501$ $$96\mathrm{.}83$ January $22,202245$