Using the attached Excel file, populate the highlighted yellow cells in order to create a production plan with lowest possible cost using temporary workers.

Month $123456$ Total

Forecast demand $5,0005,0007,0009,00013,0004,00043,000$

Output

Regular permanent $0$

Temporary $0$

Overtime $0000000$

Output $-$ Forecast $0$

Inventory $0$

Beginning $2,5002,500$

Ending $0$

Average $0$

Back order $0$

Costs

Labour

Regular perm $($at $X$/$unit$)$ $$-$

Temporary staff quantity

Temporary $($at $X$/$unit$)$ $$-$

Overtime $($at $X$/$unit$)$ $$-$

Hire temporary $($at $X$/$unit$)$ $$-$

Inventory $($at $X$/$unit$/$month$)$ $$-$

Back order $($at $X$/$unit$/$month$)$ $$-$

Total cost $$2,500$ $$-$ $$-$ $$-$ $$-$ $$-$ $$2,500$

Permanent workforce $=375$

Production per month $=6,000$ units or $16$ per worker

Initial inventory $=2,500$ units $125000$

Desired ending inventory at end of the sixth month $=2,000$ units

Costs

Labour

Regular time $=$ $$250\mathrm{.}00$ per unit

overtime $=$ $$375\mathrm{.}00$ per unit

Temporary $=$ $$250\mathrm{.}00$ per unit

Hire cost $=$ $$900\mathrm{.}00$ per temporary worker or $$60$ per unit

Inventory $=$ $$50\mathrm{.}00$ per unit per month

Backorder $=$ $$225\mathrm{.}00$ per unit per month