MAKE SURE TO DO PART B ON EXCEL PLEASE

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.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. b) Use Excel Solver to solve the problem and give the solution (decision variables and objective value)