answer in excel with detail please

Problem 3: 10 pts Companys pays regular-time wages of $5,000 per employee per period for any time worked up to 500 hours (including undertime). The overtime pay rate is $15 per hour. Overtime cannot exceed 20 percent of the regular-time capacity in any period. Hiring a new employee costs $7,000. Layoff costs are $1,500 per employee. Currently, 40 employees work for Company in this capacity. No delays in service, or backorders are allowed. The forecast demand considered for the S&OP is provided below: a. Prepare a chase strategy using only hiring and layoffs. What are the total numbers of employees hired and laid off? b. Develop a workforce plan that uses the level strategy, relaying only on overtime and undertime. Maximize the use of overtime during the peak period so as to minimize the workforce level and amount of undertime. Ulted time.com Undertime cost C. Propose an effective mixed-strategy plan. d. Compare the total costs of the three plans. Total 40 30 45 25 Inputs Forecated and Word level Undertime Overtime Derived Uted time Laryo Calculated Overtime cost Hiring con Totalcool