E 21 AB=== - 4 1 Normal No Spac.. Heading 1 Heading 2 Heading 3 Heading 4 Paragraph E Problem #5 (30 pts) 150 units of end item Z are needed at the beginning of week Z. On hand balances: Z=30. A = 60, B = 80. and C = 20 units. There is a scheduled receipt of 10 units of in week 4. Lead times are 2 weeks fot Z and B and I week for other items. Lot-for-lot ordering is used for all items. The product structure tree is shown below: 2 A131 B12! C121 D3) E 31 C14 Prepare a material requirement plan for components Z, A, B, and C. You can enter your answers in the tables below or the Excel file (Problem-5 worksheet), You Master Production Schedule Week Beg.Inv. 2 3 4 5 6 7 Hem 1 2 4 5 6 3 8 LT Week Beginv. Got requirements scheduled receipt Projected on hand Neroquirements planned-order receipt Planned order Item 1 2 4 5 6 2 IT Week seg. In Crossegurements scheduled receipt Focled on hond Felnements Planned order receipt Poned-ceder Foto Moni Week Begin 2 5 > cheduled OL 0 - 1 - Exam2 Instructions SP2022 - Word ings Review View Help Tell me what you want to do 92! A AaBbcc Aabbcc AaBb Aalbi AaBbc AaBE 1 Normal No Spac. Heading Heading 2 Heading 3 Headin Paragraph Items Beg. inv. 2 3 14 5 8 8 LT Week Gross requirements scheduled receipts Projected on hand Nel requirements planned-order receip Planned-order release Gage em 1 2 3 4 5 6 7 8 LT= Week Beg. In Cross requirements Scheduled receipts Projected on hand Netreguvements Planned order receipt planned order rele Q 0 1