Given the following production plan, use a

$($a$)$ chase production strategy, and

$($b$)$ level production strategy

$($c$)$ mixed production strategy

to compute the monthly production, ending inventory$/($backlog$)$ and workforce levels. A worker is capable of producing $100$ units per month. Assume the beginning inventory as of January is zero, and the firm desires to have zero inventory at the end of December.

In addition to the plan, calculate how many employees are required each month and what is the # if hires and layoffs $---$ starting employees are $40$

Make your tables dynamic using Excel formulas, i$.$e$.$ changes in worker processing time, monthly demand will automatically update the outcomes.