Can you please fill out this chart . i have attached below

MGT 413 MRP Assignment 1. Consider the following bill of material. Items B, C, D, E, F are components used to make product A. The numbers in brackets are the quantities of each component required to make one unit of its parent. I A A B(1) C (2) D (2) E (1) D (1) F (1) F (4) Three hundred units of Product A are needed ten weeks ahead (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 A's components (B, C, D, E, F) in order to meet the demand for 300 units of product A ten weeks ahead. There are no previously scheduled receipts for all the components. On-hand inventory and lead time information are shown below. You must use the template provided by the instructor and provide all the information needed for each item on one table in the template. 5% IR or Add Page Insert Table Chart Text Shape Media Co components. On-hand inventory and lead time information are shown below. You mu template provided by the instructor and provide all the information needed for e on one table in the template. Item On-hand Inventory Lead time (weeks) A 0 2 B B 20 2 2 0 1 D 10 3 E 0 2 F 25 3 G TER Item: Weeks LT- 1 2 3 3 4 5 1 8 9 9 10 Gross Requirements Scheduled Receipts Projected on Hand Net Requirements Planned Order Receipts Planned Order Releases Item: LT- Weeks 1 2 3 4 5 6 6 7 . 10 Gross Requirements Scheduled Receipts Projected on Hand Net Requirements Planned Order Receipts Planned Order Releases Item: LT- Wecks 1 2 3 4 5 6 7 8 9 9 TO Gross Requirements Scheduled Receipts Projected on Hand Net Requirements Planned Order Receipts