How to solve

Develop a production schedule to produ

Develop a production schedule to produce the exact production requirements by varying the workforce size for the following problem

The monthly forecasts for Product $x$ for January, February, and March are $1,020,1,550,$ and $1,220,$ respectively. Safety stock policy recommends that half of the forecast for that month be defined as safety stock. There are $22$ working days in January, $19$ in February, and $21$ in March. Beginning inventory is $560$ units.

Storage cost is $$3$ per unit per month based on ending inventory level, standard pay rate is $$8$ per hour, hiring and training cost is $$220$ per worker, layoff cost is $$320$ per worker, and worker productlvity is $0\mathrm{.}1$ unit per hour. Assume that you start off with $42$ workers and that they work $8$ hours per day. $($Leave no cells blank $-$ be certaln to enter $"0"$ wherever requlred. Input all values as positive values. Round Workers Required up to next higher whole number. Round all other varlables to nearest whole number.$)$

$\backslash$table$[[,$January,February,March$],[$Forecast$,1,020,1,550,1,220],[$Safety stock,$510,775,610],[$Beginning inventory,$560,500,525],[$Net production,$970,1,825,1,105],[$required$,97,183,111],[$Workers required,$55,86,28],[$Hired$,0,0,0],[$Laid oif,$970,1,825,1,105],[$Actual production,$500,525,530],[$Ending inventory,,,$]]$

$\backslash$table$[[,$January,February,March$],[$Labor cost$,5,704,$s$,1\mathrm{.}232,5,850],[$Inventorn cost$,,10120,,14\mathrm{.}52$;$,,0],[$Hiring cost$,,0,,0,,14\mathrm{.}080],[$Layoff cost$,,0,,0,,0],[$Total cost$,5,10\mathrm{.}824,$s$,15\mathrm{.}752,(,14\mathrm{.}960],[$Total$,,,,,$s$,41\mathrm{.}536]]$ce the exact production requirements by varying the workforce size for the following problem.

The monthly forecasts for Product $x$ for January, February, and March are $1,020,1,550,$ and $1,220,$ respectively. Safety stock policy recommends that half of the forecast for that month be defined as safety stock. There are $22$ working days in January, $19$ in February, and $21$ in March. Beginning inventory is $560$ units.

Storage cost is $$3$ per unit per month based on ending inventory level, standard pay rate is $$8$ per hour, hiring and training cost is $$220$ per worker, layoff cost is $$320$ per worker, and worker productivity is $0\mathrm{.}1$ unit per hour. Assume that you start off with $42$ workers and that they work $8$ hours per day. $($Leave no cells blank $-$ be certain to enter $"0"$ wherever required. Input all values as positive values. Round Workers Required up to next higher whole number. Round all other variables to nearest whole number.$)$

$\backslash$table$[[,$January,February,March$],[$Forecast$,1,020,1,550,1,220],[$Safety stock,$510,775,610],[$Beginning inventory,$560,500,525],[$Net production required,$970,1,825,1,105],[$Workers required,$97,183,111],[$Hired$,55,86,28],[$Laid off,$0,0,0],[$Actual production,$970,1,825,1\mathrm{.}105],[$Ending inventory,$500,525,530]]$