Work center capacity should end up as$21\mathrm{.}6$ hrs$.$ Stock level for $6/2025$ should be $45.$ One of the periods of production will result in stock levels greater than $45$ becsuse of capacity constraints on future periods. Have to update th sales line and then adjust the priduction line based on constraints. Stock level will be updated automatically in SAP. Planned safety stock is $45.$ Build up to stock level of $45$ as fast as possible without exceeding available capacity and then never go below stock levels of $5.$ Objective is to minimize inventory. Dontt end a period greater than stock level of $45$ unless absolutely reqdired whili minimizing total amount of inventory to carry from one period to the nex

$\backslash$table$[[$Months$,$Jan$-25,$Feb$-25,$Mar$-25,$Apr$-25,$May$-25,$Jun$-25],[$Sales$,280,280,319,298,330,330],[$Production$,,,,,,],[$Stock Level,$-280,-560,-879,-1177,-1507,-1837]]$

Values given in the SAP Lab $6$ assignment. $*$Input your Production Plan in this row. Do not change the formulas in this row

$\backslash$table$[[$Months$,$Jan$-25,$Feb$-25,$Mar$-25,$Apr$-2\mathrm{.}5,$May$-25,$Jun$-25],[$Resource Usage $($# of hours $=1\mathrm{.}4*$Production$),0,0,0,0,0,0],[$Available Capacity $($# of hours$),432,410,497,454,454,475],[$Capacity Load Percentage,$0\%,0\%,0\%,0\%,0\%,0\%$