Answer using the Aggregate Planning Spreadsheet The operations manager of Ebay must determine how 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 vacation scheduling. o First, the manager divides the next year into six time periods, each one 2 months long. Each part-time employee can work a maximum of 20 hours per week on regular time, but the actual number can be less. o Instead of paying undertime, each worker's day is shortened during slack periods. Once on the payroll, each worker is used each day, but they may work only a few hours. Overtime can be used during peak periods. The distribution center's forecasted demand is shown as the number of part-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 employees working 20 hours per week on regular time will be needed. 1 2 3 4 5 6 Total be needed. 1 2 3 4 5 6 Total Forecasted demand 6 12 18 15 13 14 78 Currently, 10 part-time clerks are employed. They have not been subtracted from forecasted demand shown. Constraints and cost information are as follows: A. The size of training facilities limits the number of new hires in any period to no B. No backorders are permitted; demand must be met each period. C. Overtime cannot exceed 20 percent of the regular-time capacity in any period. any part-time employee can work is 1.20(20)=24 hours/week D. The following costs can be assigned: Regular-time wage $2,000 per time period at 20 rate hours per week Regular-time wage $2,000 per time period at 20 rate hours per week Overtime wages 150% of the regular-time rate Hires $1,000 per person Layoffs $500 per person 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.) Time Period-> 1 2 3 4 15 16 17 18 In periods Total Inputs Forecasted Demand Work force level Undertime Layoffs Calculated Utilized time cost Undertime cost Overtime cost Inventory cost Hiring cost Layoff cost Total Cost Edit View Insert Format Tools Table 12pt Paragraph M B I U AY2 Tv