This is the master production as mentioned above

2. For the master production schedule in Problem-1, based on the BOM file and the routing and standard time data below, develop a capacity planning for workcenters 1, 2, and 3 using the capacity bills method. (20 points) Product structure data: AA CC D E D G a BB H (2 required D F (2 required) J (3 required) Routing and Standard Time Data: Lot Sizes Operation Work Center Standard Setup Standard Run Time Hours Hours per Unit End Products AA 50 1 of 1 WC1 10 0.3 BB 50 1 of 1 WC1 20 0.8 CC 30 1 of 1 WC1 12 1.1 Components D 50 1 of 1 WC2 5 0.2 E 60 1 of 2 WC1 3 0.05 100 2 of 2 WC2 4 0.06 F 80 1 of 1 WC3 8 0.15 G 100 1 of 2 WC2 5 0.05 50 2 of 2 WC3 3 0.04 H 100 1 of 1 WC2 10 0.1 J 200 1 of 1 WC3 10 0.05 This is the capacity planning for each workcenter. Workcenter Period 1 Period 2 Period 3 WC1 20 23 17.5 WC 2 12 13.8 10.5 WC 3 8 9.2 7 Total Hours 40 46 35 2. For the master production schedule in Problem-1, based on the BOM file and the routing and standard time data below, develop a capacity planning for workcenters 1, 2, and 3 using the capacity bills method. (20 points) Product structure data: AA CC D E D G a BB H (2 required D F (2 required) J (3 required) Routing and Standard Time Data: Lot Sizes Operation Work Center Standard Setup Standard Run Time Hours Hours per Unit End Products AA 50 1 of 1 WC1 10 0.3 BB 50 1 of 1 WC1 20 0.8 CC 30 1 of 1 WC1 12 1.1 Components D 50 1 of 1 WC2 5 0.2 E 60 1 of 2 WC1 3 0.05 100 2 of 2 WC2 4 0.06 F 80 1 of 1 WC3 8 0.15 G 100 1 of 2 WC2 5 0.05 50 2 of 2 WC3 3 0.04 H 100 1 of 1 WC2 10 0.1 J 200 1 of 1 WC3 10 0.05 This is the capacity planning for each workcenter. Workcenter Period 1 Period 2 Period 3 WC1 20 23 17.5 WC 2 12 13.8 10.5 WC 3 8 9.2 7 Total Hours 40 46 35