PLEASE ONLY SOLVE IN EXCEL. SHOW ALL FORMULAS FOR ALL VALUES AND SHOW ALL WORK. I WILL PROVIDE A LIKE: Question $3(20$ points$)$

The Yeasty Brewing Company Produces a popular local beer known as Iron Stomach.

Beer sales are somewhat seasonal, and Yeasty is planning its production and workforce

levels on March $31$ for the next six months. The demand forecasts are as follows:

As of March $31,$ Yeasty had $60$ workers on the payroll. Over a period of $25$ working days

when there are $120$ workers on the pay roll, Yeasty produced $18,000$ cases of beer. The

cost to hire each worker is $$150$ and the cost of laying off each worker is $$300.$ Holding

costs amount to $1\mathrm{.}2$ dollar per case per month.

As of March $31,$ Yeasty expects to have $3,200$ cases of beer in stock. It plans to start

October with $3,700$ cases on hand.

a$)$ Formulate the problem of planning Yeasty's production levels as a linear

program. ON EXCEL ONLY

b$)$ Use Excel solver to solve the problem and give the solution $($decision variables

and objective value$)$