SOLVE IN EXCEL

W POB ompare your solution to , 36. The Yeasty Brewing Company produces a popular local beer known as Tron 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 forests are as follows: Month April May June July August September Production Days 11 22 20 23 16 20 Forecasted Demand (in hundreds of cases) B5 93 122 176 140 63 As of March 31, Yeasty had 86 workers on the payroll. Over a period of 26 work- ing days when there were 100 workers on the payroll, Yensty produced 12,000 cases of beer. The cost to hire each worker is $125 and the cost of laying off ench worker is $300. Holding costs amount to 75 cents per casc per month As of March 31, Yeasty expects to have 4,500 cases of beer in stock, and it wants to maintin a minimum buffer inventory of 1,000 cases each month. It plans to start October with 3,000 cases on hand. Susulation is a. Based on this information, find the minimum constant workforce plan for Yeasty over the six months, and determine hiring, firing, and holding costs associated with that plan. 5. Suppose that it takes one month to train a new worker. How will that affect your solution? c. Suppose that the maximum number of workers that the company can expect to be able to hire in one month is 10. How will that affect your solution to part (a)