Problem 2 (20 Points) Below is information related to: historical average processing times for Products A and B historical percentage of work center load required to produce Produdcts A and B routing and standard times to produce Product B the product structure for Product B a MPS covering 3 periods for Products A and B. MPS in Units End Product 1 2 Processing Time A 25 50 WC Historical % End Product Hours/Unit B 30 30 100 40% 0.80 200 50% B 1.5 300 10% 3 45 25 B Routing and Standard Time Data End Product Lot Size Work Center Set Up (Hrs) Run Time/Unit (Hrs) Hrs/Unit B 40 100 1 1.25 D 50 200 2 0.07 E 100 200 0.08 F 100 300 2 0.04 D (2 Required) E (3 required) N F (2 required) A. Develp a rough cut capacity plan for the three work centers based on historical factors. Please fill in the table below with your final calculations. Show your work in the space below. (6 Pts.) Historical Total Work Center Percentage 1 2 3 Hours 100 200 300 Total Required Capacity Show any work here: B. Create a capacity bill for product B in the space provided. Consider lot sizes in your calculations. (8 pts.) Capacity Bill for Product B D (2 Required) (3 required) (2 required) C. Based on your capacity bill, and the given MPS for Product B, fill in the rough cut capacity loads for the three work centers. Please use the table below for your final answer. Show any work in the space provided. (6 pts.) Total Hours 1 2 3 Work Center 100 200 300 Total Required -w any work here