Complete the following capacity bills production schedule. there is no more datawe should find total req'd capacity and filling out the periods and total hours as well

4 quid ( required Routing and Standard Time Data Work Standard Standard Setup Standard Run Time Total Hours Lot Sizes Operation Centre Setup Hours Hours per Unit Hours Per Unit per Unit End Products 40 1 of 1 100 1.00 0.025 0.025 0.0500 B 20 1 of 1 100 1.00 0.050 1.25 1.3000 Components 40 1 of 2 200 1.00 0.025 0.575 0.6000 2 of 2 300 1.00 0.025 0.2000 D 60 1 of 1 200 2.00 0.033 0.067 0.1003 E 100 1 of 1 200 2.00 0.020 0.08 0.1000 F F 100 200 2.00 0.020 0.0425 0.0625 Master Production Schedule (in units): 0.175 1 of 1 5 9 End Product A B B 1 32 15 2 31 15 3 30 16 4 35 15 Period 6 15 15 7 14 23 35 15 8 28 24 11 35 10 26 24 28 23 12 34 23 13 35 24 Total 378 253 21 Bill of Capacity: End Product Work Centre A B 100 0.050 1.300 200 0.950 1.50033 300 0.200 0 Total time/ unit 1.200 2.800 Period Total Hours 1 2 3 5 6 7 8 9 10 11 12 13 Work Centre 100 200 300 Total Req'd Capacity 4 quid ( required Routing and Standard Time Data Work Standard Standard Setup Standard Run Time Total Hours Lot Sizes Operation Centre Setup Hours Hours per Unit Hours Per Unit per Unit End Products 40 1 of 1 100 1.00 0.025 0.025 0.0500 B 20 1 of 1 100 1.00 0.050 1.25 1.3000 Components 40 1 of 2 200 1.00 0.025 0.575 0.6000 2 of 2 300 1.00 0.025 0.2000 D 60 1 of 1 200 2.00 0.033 0.067 0.1003 E 100 1 of 1 200 2.00 0.020 0.08 0.1000 F F 100 200 2.00 0.020 0.0425 0.0625 Master Production Schedule (in units): 0.175 1 of 1 5 9 End Product A B B 1 32 15 2 31 15 3 30 16 4 35 15 Period 6 15 15 7 14 23 35 15 8 28 24 11 35 10 26 24 28 23 12 34 23 13 35 24 Total 378 253 21 Bill of Capacity: End Product Work Centre A B 100 0.050 1.300 200 0.950 1.50033 300 0.200 0 Total time/ unit 1.200 2.800 Period Total Hours 1 2 3 5 6 7 8 9 10 11 12 13 Work Centre 100 200 300 Total Req'd Capacity