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 BB H (2 required H ( D F 12 required) (3 required) Routing and Standard Time Data: Lot Sizes Operation Work Center Standard Setup Standard Run Time Hours Hours per Unit End Products 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 1. For the master production schedule and the information below, develop a capacity planning for workcenters 1, 2, and 3 using the CPOF method. (10 points) MPS Product Period-1 Period-2 Period-3 AA 6 7 6 BB 5 9 4 CC 8 7 7 Direct labor time per end product unit: Product Labor time AA 1 hr BB 2 hrs CC 3 hrs Historical percentages of total hours worked in each workcenter: Product Usage WC1 50% WC2 30% WC3 20% 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 BB H (2 required H ( D F 12 required) (3 required) Routing and Standard Time Data: Lot Sizes Operation Work Center Standard Setup Standard Run Time Hours Hours per Unit End Products 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 1. For the master production schedule and the information below, develop a capacity planning for workcenters 1, 2, and 3 using the CPOF method. (10 points) MPS Product Period-1 Period-2 Period-3 AA 6 7 6 BB 5 9 4 CC 8 7 7 Direct labor time per end product unit: Product Labor time AA 1 hr BB 2 hrs CC 3 hrs Historical percentages of total hours worked in each workcenter: Product Usage WC1 50% WC2 30% WC3 20%