10 pts Question 46 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 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. + ourses/77091/quizzes/296046/take needed 1 2 3 14 15 6 Total Forecasted demand 16 12 18 115 13 14 78 Currently, 10 part-time clerks are employed. They have not been subtracted from the 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 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 any period. The most that 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 hours per week rate 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 /77091/quizzes/296046/take 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 3 4 5 6 7 8 8 n periods Total 1 Period -> Inputs Forecasted Demand Work force level Undertime Overtime Derived Utilized time Inventory Hires Layoffs Calculated Utilized time cost Undertime cost Forecasted Demand Work force level Undertime Overtime Derived Utilized time Inventory Hires Layoffs Calculated Utilized time cost Undertime cost Overtime cost Inventory cost Hiring cost Layoff cost Total Cost