Use the following information to do the aggregate planning. Use a STABLE workforce for this model Hint: Remember to make the variable workers as integer. Yellow cell should be solved using SOLVER

$\backslash$table$[[,,,,,,,,,,],[$Workers available on day $1,17,$workers,,Workers,,,,,,$],[$Production$,8\mathrm{.}5,$units$/$worker$/$day$,,,,,,,,],[$Hiring cost per worker,$$425,$worker,,,,,,,,$],[$Holding Cost,$$5,$units$/$month$,,,,,,,,],[$Wages$,$$$1,200,$worker$/$monthly$,,,,,,,,],[$Lay off cost per worker,$$850,,,,,,,,,],[$Backorder cost$,$$$25,$units$/$month$,,,,,,,,],[$Initial inventory,$100,$units,,,,,,,,$],[,$April,May,June,July,August,September,October,November,December,$],[$Work Days within the month,$21,22,21,23,20,20,21,22,15,],[$Demand$,1500,1600,1800,2000,1800,1500,1200,1100,1000,],[$Workers needed $(=$$G$$4),0,0,0,0,0,0,0,0,0,0],[$Workers available on $1$st day of month,,,,,,,,,,$],[$Workers hired,,,,,,,,,,$],[$Hiring cost$,,,,,,,,,,],[$Workers fired,,,,,,,,,,$],[$Lay off cost,,,,,,,,,,$],[$Number of workers $($at end of month$),,,,,,,,,,],[$Cost to pay the workforce,,,,,,,,,,$],[$Units produced,,,,,,,,,,$],[$Net stock $($implied at end of month$),,,,,,,,,,],[$Holding cost$,,,,,,,,,,],[$Backorder cost$,,,,,,,,,,],[$Total Cost,,,,,,,,,,$],[,,,,,,,,,,],[,,,,,,,,,,],[,,,,,,,,,,],[$you have opposite things like "workers hired",rkers fire,use the IF function,,,,,,,,$]]$