create chase aggregate plan using information below

Description Maximum regular hours per worker per quarter Maximum overtime hours per worker per quarter Maximum number of workers Starting workforce Hiring cost per worker Firing cost per worker Regular time wage Overtime wage Subcontract Cost Back order cost Holding cost per pair of shoes per quarter Ending Inventory Period 0 Value 480 100 90 75 1900 1200 18 27 60 20 2 2200 Aggregate Planning Quarter Casual Athletic Running Total 9903 9910 10867 30680 2 10776 10006 10248 310301 Aggregate Demand 3 4 11568 12446 11420 14615 11147 14509 34135 415701 5 16915 18734 16731 52380 6 18126 20469 19515 58110 11268 14478 14274 400201 10690 13745 14710 39145 Control Sheet Chase Level Mix MPS MRP CHASE AGGREGATE PLAN 2 3 5 8 |Period Forecast Production Regular Time Overtime Subcontract Total Production Number of Workers Inventory Beginning Ending Average Backlog Labor Costs Regular Overtime Subcontract Hire Fire Total Labor Cost Inventory Costs Holding Cost Back Order Total Production Cost Total Cost Aggregate Planning A chase and level plan must be created for the project. The planning horizon is for two years, starting one year out. Each period in the aggregate plans represent one quarter. Aggregate by product for each quarter. The marketing department is planning to attend a series of fairs and conventions during periods 5 and 6, resulting in a projected spike in forecasted demand. Chase Plan Rules: o The forecast demand must be met each quarter o Overtime and subcontracting is authorized o No backorders are permitted Level Plan Rules: o Regular production will be calculated and rounded up to the nearest whole number using the level production equation (do not just hide decimal places) o No overtime or subcontracting may be used A mixed plan is an optional assignment for 20 bonus points. To score the bonus points, the plan must meet the conditions for the Mix Aggregate Plan listed below. Mix Aggregate Plan Rules: o Plan must be free of errors o The cost of the plan must beat the cost provided (target cost to be provided on Canvas) o At the end of the last period, all backlog must be cleared o Employment level cannot ever go above the maximum number of workers as stated in the Aggregate Planning spreadsheet Description Maximum regular hours per worker per quarter Maximum overtime hours per worker per quarter Maximum number of workers Starting workforce Hiring cost per worker Firing cost per worker Regular time wage Overtime wage Subcontract Cost Back order cost Holding cost per pair of shoes per quarter Ending Inventory Period 0 Value 480 100 90 75 1900 1200 18 27 60 20 2 2200 Aggregate Planning Quarter Casual Athletic Running Total 9903 9910 10867 30680 2 10776 10006 10248 310301 Aggregate Demand 3 4 11568 12446 11420 14615 11147 14509 34135 415701 5 16915 18734 16731 52380 6 18126 20469 19515 58110 11268 14478 14274 400201 10690 13745 14710 39145 Control Sheet Chase Level Mix MPS MRP CHASE AGGREGATE PLAN 2 3 5 8 |Period Forecast Production Regular Time Overtime Subcontract Total Production Number of Workers Inventory Beginning Ending Average Backlog Labor Costs Regular Overtime Subcontract Hire Fire Total Labor Cost Inventory Costs Holding Cost Back Order Total Production Cost Total Cost Aggregate Planning A chase and level plan must be created for the project. The planning horizon is for two years, starting one year out. Each period in the aggregate plans represent one quarter. Aggregate by product for each quarter. The marketing department is planning to attend a series of fairs and conventions during periods 5 and 6, resulting in a projected spike in forecasted demand. Chase Plan Rules: o The forecast demand must be met each quarter o Overtime and subcontracting is authorized o No backorders are permitted Level Plan Rules: o Regular production will be calculated and rounded up to the nearest whole number using the level production equation (do not just hide decimal places) o No overtime or subcontracting may be used A mixed plan is an optional assignment for 20 bonus points. To score the bonus points, the plan must meet the conditions for the Mix Aggregate Plan listed below. Mix Aggregate Plan Rules: o Plan must be free of errors o The cost of the plan must beat the cost provided (target cost to be provided on Canvas) o At the end of the last period, all backlog must be cleared o Employment level cannot ever go above the maximum number of workers as stated in the Aggregate Planning spreadsheet