Consider the following product structure (bill of material).                   One hundred and fifty (150) units of Product A are needed in week 10. Assuming no on-hand inventory of A exists, explode the bill of material, and use the following information to construct a net requirements plan for all the items. You must use the template provided by the instructor and provide all the information needed on the template. There are no scheduled receipts for all the items.       Item On-hand Inventory Lead time (weeks) A 0 2 B 20 2 C 10 1 D 0 3 E 5 1 F 10 3           Item: LT=   1 2 3 4 5 6 7 8 9 10 11 12 Gross Requirements                         Scheduled Receipts                         Projected on Hand                         Net Requirements                         Planned Order Receipts                         Planned Order Releases                                 Item: LT=   1 2 3 4 5 6 7 8 9 10 11 12 Gross Requirements                         Scheduled Receipts                         Projected on Hand                         Net Requirements                         Planned Order Receipts                         Planned Order Releases                                 Item: LT=   1 2 3 4 5 6 7 8 9 10 11 12 Gross Requirements                         Scheduled Receipts                         Projected on Hand                         Net Requirements                         Planned Order Receipts                         Planned Order Releases                                   Item: LT=   1 2 3 4 5 6 7 8 9 10 11 12 Gross Requirements                         Scheduled Receipts                         Projected on Hand                         Net Requirements                         Planned Order Receipts                         Planned Order Releases                                 Item: LT=   1 2 3 4 5 6 7 8 9 10 11 12 Gross Requirements                         Scheduled Receipts                         Projected on Hand                         Net Requirements                         Planned Order Receipts                         Planned Order Releases                                 Item: LT=   1 2 3 4 5 6 7 8 9 10 11 12 Gross Requirements                         Scheduled Receipts                         Projected on Hand                         Net Requirements                         Planned Order Receipts                         Planned Order Releases                                   Item: LT=   1 2 3 4 5 6 7 8 9 10 11 12 Gross Requirements                         Scheduled Receipts                         Projected on Hand                         Net Requirements                         Planned Order Receipts                         Planned Order Releases                                 Item: LT=   1 2 3 4 5 6 7 8 9 10 11 12 Gross Requirements                         Scheduled Receipts                         Projected on Hand                         Net Requirements                         Planned Order Receipts                         Planned Order Releases                                 Item: LT=   1 2 3 4 5 6 7 8 9 10 11 12 Gross Requirements                         Scheduled Receipts                         Projected on Hand                         Net Requirements                         Planned Order Receipts                         Planned Order Releases