Answer using the Aggregate Planning Spreadsheet The operations manager of Eary must determine haw many part-time stockpickers to maintain on the payroll. She wants to develop a staffing plan that minimizes total costs, and wants to begin with the chase strategy and level strategy. - For the level strategy, she wants to first try the workforce level that meets demand with the minimum use of undertime and not consider vacatian echeduling - First, the manager divides the next year into six time periods, each one 2 months long. - Each part-time emplovee can work a maximum of 20 hours per week on regular time, but the actual number can be less. - Instead of paying undertime, each worker's day is shartened during slack periods. Once on the payroll, each worker is used each day, but they may work. anly a few hours. Overtime can be used during peak periods. The distribution center's farecasted damand is shawn as the number of port-time employees required for each time period at the maximum regular time of 20 hours per week. For example, in period 3, an estimated 18 part-time emplayees working 20 hours per week an regular time will be needed. - Currently, 10 part-time clerks are emplayed. They have not been subtracted from the forecasted demand shown. Conatraints and cost information are as follows: A. The size of training facilities limits the number of new hires in ary period to no more than 10 B. No backorders are permitted; demand must be met each period. C. Overtime cannot exceed 20 percent of the regular-time capacity in arry period. The most that arry part-time employee can work is 1.20/20)-24 hours/week D. The follawing costs can be assigned: Question : Use the following Aggregate Planning Spreadsheet format to plan a Chase Strategy and find what is the total cost of this strategy. (You may copy this table format to answer in the textbox)