Complete the spreadsheets for chase strategy and level strategy

A retailer experiences a seasonal demand pattern. Labor requirements over six months are reported in the following table. Currently, 10 part-time workers are employed. Instead of paying undertime, each worker's day is shortened during undertime periods. Overtime cannot exceed 25 percent of the regular time. Costs associated with the operations are as follows: Regular time wage rate: $4,000 per person per month Overtime wages: 150% of the regular-time rate Hires: $1,000 per person Layoffs: $500 per person Use the spreadsheet approach to find the total cost of the staffing plan for chase and level strategy. Chase Strategy: 5 6 Total 12 15 20 10 16 Month Forecasted Demand Workforce Level Overtime Undertime Utilized time Hires Layoffs Utilization Cost Overtime Cost Undertime Cost Hiring Cost Layoff cost Total cost Xe 1 9 2 12 3 15 4 20 5 10 6 16 Total Level Strategy: Month Forecasted Demand Workforce Level Overtime Undertime Utilization time Hires Layoffs Utilization Cost Overtime cost Undertime cost Hiring cost Layoff cost Total cost A retailer experiences a seasonal demand pattern. Labor requirements over six months are reported in the following table. Currently, 10 part-time workers are employed. Instead of paying undertime, each worker's day is shortened during undertime periods. Overtime cannot exceed 25 percent of the regular time. Costs associated with the operations are as follows: Regular time wage rate: $4,000 per person per month Overtime wages: 150% of the regular-time rate Hires: $1,000 per person Layoffs: $500 per person Use the spreadsheet approach to find the total cost of the staffing plan for chase and level strategy. Chase Strategy: 5 6 Total 12 15 20 10 16 Month Forecasted Demand Workforce Level Overtime Undertime Utilized time Hires Layoffs Utilization Cost Overtime Cost Undertime Cost Hiring Cost Layoff cost Total cost Xe 1 9 2 12 3 15 4 20 5 10 6 16 Total Level Strategy: Month Forecasted Demand Workforce Level Overtime Undertime Utilization time Hires Layoffs Utilization Cost Overtime cost Undertime cost Hiring cost Layoff cost Total cost