Problem $19-14($Algo$)$

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

Evaluate the cost of production schedule.

The monthly forecasts for the product $x$ for January, February, and March are $1,010,1,540,$ and $1,180,$ 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 $530$ units.

Manufacturing cost is $$2,100$ per unit, storage cost is $$6$ per unit per month $($based on expected end$-$of$-$month levels

rate is $$18$ per hour, hiring and training cost is $$2,100$ per worker, layoff cost is $$3,100$ per worker, and worker productivity is $0\mathrm{.}1$ unit $p$

hour. Assume that you start off with $42$ workers and that they work $8$ hours per day.

Note: Leave no cells blank $-$ be certain to enter $"0"$ wherever required. Input all values as positive values. Round Workers Requir

up to next higher whole number. Round all other variables to nearest whole number.Problem $21-11($Algo$)$

Assume that Product $Z$ is made of two units of A and four units of $B.A$ is made of three units of $C$ and three of $D.$ D is made of three

units of $E.$

Lead times for the purchase or fabrication of each unit to final assembly are Z takes two weeks; A$,$ B$,$ C$,$ and D take one week each;

and $E$ takes three weeks.

Sixty five units are required in Period $10.($Assume that there is currently no inventory on$-$hand of any of these items.$)$

b$.$ Develop an MRP planning schedule showing gross and net requirements and order release and order receipt dates.

Note: Leave no cells blank $-$ be certain to enter $"0"$ wherever required.