Aggragate planing problems Solve on excel Mr$.$ Meadows Cookie Company makes a variety of chocolate chip cookies in the plant in Albion, Michigan. Based on orders received and forecasts of buying habits, it is estimated that the demand for the next four months is $850,1,260,510,$ and $980,$ expressed in thousands of cookies. During a $46-$day period when there were $120$ workers, the company produced $1\mathrm{.}7$ million cookies. Assume that the number$-$of workdays over the four months are respectively $26,24,20,$ and $16.$ There are currently $100$ workers employed, and there is no starting inventory of cookies.

Assume that $c_{\text{I}}=10$ cents per cookie per month, $C_H=$$$100,$ and $C_F=$$$200$

a$.$ Implement the Level strategy and find the minimum constant workforce required to meet demand over the next four months. What is the total cost?

b$.$ Implement the Chase strategy and find the total cost

c$.$ Formulate as a linear program. Be sure to define all variables and include the required constraints

d$.$ Solve for the optimal solution.