perform the chase wnd Level strategy

Answer uuine the Agrregate Planning Spreadsheet The operations macuker of Eboy must detemice how many part-fime atockgichers to makintain on the payroli. She wants to develop a stathne plan that minimlets total costs, and wants to becin with the chase strategy and level stratery. - For the litvel strategy, she wants to frat try the workforce level that meets demand with the ininimum uhe of umdertime and not consider vacation scheduling. - Fint, the manager divides the next vear into sis time gerlodi, each one 2 months long - Each part-time employee can woek a maximum of 20 hours per week on regular time, bue the actuat number can be lesk - Instead of paying undertime. each worler's day is shortened during slack periods. Once on the payrolt, each worker is ored each day, but they may work only a few hourh. Overtiene can be used darine peyk 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 woek. For example, in period 3 an estimated 18 part-time employees working 20 hours per week on regular time will be: necded. - Currently, 10 part-time cieries are employed. They have not been subtracted from the forecasted dernand shown. Constraints and cost information are as follows: A. The slre 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 ekceed 20 percent of the regular-time capacity in any period. The most that any part-time employee can work is 120(20)24 hours/week D. The following 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