please use blank template to show the answer.

1. Consider the following bill of material. A B(1) C (2) D (2) E (1) D(1) F (1) F (4) Eighty 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 components (B, C, D, E, F) in order to meet the demand for product A. You must use the template provided by the instructor and provide all the information needed for each item A, B, C, D, E, F in a table of the template. There are no scheduled receipts for all the components. Eighty 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 components (B, C, D, E, F) in order to meet the demand for product A. You must use the template provided by the instructor and provide all the information needed for each item A, B, C, D, E, F in a table of the template. There are no scheduled receipts for all the components. Item B C On-hand Lead time Inventory (weeks) 0 2 20 2 0 1 10 3 0 2 15 3 D E F Item: LT= 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