fill out figure 3 using figure 1 & 2 information. please note the rules. thank you!

figure 1

figure 2

figure 3

rules

Value 480 100 90 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 75 1900 1200 18 27 60 20 2 2200 Aggregate Planning E F G K L M 1 7 8 Quarter Casual Athletic Running Total 9903 9910 10867 30680 2 10776 10006 10248 31030 H Aggregate Demand 3 4 5 11568 12446 16915 11420 14615 18734 11147 14509 16731 34135 41570 52380 18126 20469 19515 58110 11268 14478 14274 40020 10690 13745 14710 39145 C D E F F G H K 2 3 4 5 6 7 8 B 1 CHASE AGGREGATE PLAN 2 3 Period 4 Forecast 5 Production 6 Regular Time 7 Overtime 8 Subcontract 9 Total Production 10 Number of Workers 11 Inventory 12 Beginning 13 Ending 14 Average 15 Backlog 16 17 Labor Costs 18 Regular 19 Overtime 20 Subcontract Hire 22 Fire 23 Total Labor Cost 24 25 Inventory Costs 26 Holding Cost 27 Back Order 28 29 Total Production Cost 30 31 Total Cost 32 ADD Styles 15 Edit 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. O . Chase Plan Rules The forecast demand must be met each quarter o Overtime and subcontracting is authorized 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 The cost of the plan must beat the cost provided (target cost to be provided on Canvas) At the end of the last period, all backlog must be cleared Employment level cannot ever go above the maximum number of workers as stated in the Aggregate Planning spreadsheet Value 480 100 90 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 75 1900 1200 18 27 60 20 2 2200 Aggregate Planning E F G K L M 1 7 8 Quarter Casual Athletic Running Total 9903 9910 10867 30680 2 10776 10006 10248 31030 H Aggregate Demand 3 4 5 11568 12446 16915 11420 14615 18734 11147 14509 16731 34135 41570 52380 18126 20469 19515 58110 11268 14478 14274 40020 10690 13745 14710 39145 C D E F F G H K 2 3 4 5 6 7 8 B 1 CHASE AGGREGATE PLAN 2 3 Period 4 Forecast 5 Production 6 Regular Time 7 Overtime 8 Subcontract 9 Total Production 10 Number of Workers 11 Inventory 12 Beginning 13 Ending 14 Average 15 Backlog 16 17 Labor Costs 18 Regular 19 Overtime 20 Subcontract Hire 22 Fire 23 Total Labor Cost 24 25 Inventory Costs 26 Holding Cost 27 Back Order 28 29 Total Production Cost 30 31 Total Cost 32 ADD Styles 15 Edit 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. O . Chase Plan Rules The forecast demand must be met each quarter o Overtime and subcontracting is authorized 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 The cost of the plan must beat the cost provided (target cost to be provided on Canvas) At the end of the last period, all backlog must be cleared Employment level cannot ever go above the maximum number of workers as stated in the Aggregate Planning spreadsheet