solve it by hand no excel

Chapter 7 Problem 7P Done An office supply company makes notebooks with the following product structure: Notebook Pad Cover The company uses an MRP system, and has the following records for these three items. Week Notebook 1 2 3 4 5 6 Gross requirements 252525252525 Scheduled receipts Projected available balance 30 5OOOOO Planned order releases 2025252525 O Q = L4L, LT = 1, SS = 0. Pad 1 2 3 4 5 6 Gross requirements 20 25 25 25 250 Scheduled receipts 15 Projected available balance 10 5 10 15 20 2525 Planned order releases 30 30 30 300 6 Q = 30, LT = 1, SS = 0. Cover 1 2 3 4 5 6 Gross requirements 20 25252525 O Scheduled receipts 50 Projected available balance 1040 15 40 1540 40 Planned order releases 150 050 0 0 0 Q = 50, LT = 2, SS = 0. The notebooks are fabricated in the following work centers, listed with accompanying time requirements. Operation Work Setup Run Time Center Time Notebook 100 2 hours 10 assembly minutes Pad production 200 3 hours 5 minutes Cover production 300 2 hours 9 minutes Determine the weekly capacity requirements in each of the work centers. For the two scheduled receipts. assume that the setup is complete, and that in each case they are half complete. Chapter 7 Problem 7P Done An office supply company makes notebooks with the following product structure: Notebook Pad Cover The company uses an MRP system, and has the following records for these three items. Week Notebook 1 2 3 4 5 6 Gross requirements 252525252525 Scheduled receipts Projected available balance 30 5OOOOO Planned order releases 2025252525 O Q = L4L, LT = 1, SS = 0. Pad 1 2 3 4 5 6 Gross requirements 20 25 25 25 250 Scheduled receipts 15 Projected available balance 10 5 10 15 20 2525 Planned order releases 30 30 30 300 6 Q = 30, LT = 1, SS = 0. Cover 1 2 3 4 5 6 Gross requirements 20 25252525 O Scheduled receipts 50 Projected available balance 1040 15 40 1540 40 Planned order releases 150 050 0 0 0 Q = 50, LT = 2, SS = 0. The notebooks are fabricated in the following work centers, listed with accompanying time requirements. Operation Work Setup Run Time Center Time Notebook 100 2 hours 10 assembly minutes Pad production 200 3 hours 5 minutes Cover production 300 2 hours 9 minutes Determine the weekly capacity requirements in each of the work centers. For the two scheduled receipts. assume that the setup is complete, and that in each case they are half complete