please include the formulas to type in excel. thanks!

Problem 1 (25 Points): Fill the MRP sheet for the given product structure tree and data. All terms have their usual meaning. Paste B Mergo & Center Conditio Formatti Q1 Problem 125 Points) 1 3 6 7 8 N Time Period 4 40 5 60 9 10 10 50 60 0 PERIOD 5 6 1 1 2 3 4 7 8 9 10 B(3) C(4) 5 5 5 5 5 20 D(4) E(3) Item: ALLC: Lot Size: L4L LT: Gross Requirements Scheduled Receipts Projected on Hand 3. Net Requirements 12 Planned Order Receipts Planned Order Releases 14 3 Item: B LLC - Lot Size: L4L LT: Gross Requirements Scheduled Receipts Projected on Hand 20 Net Requirements 21 Planned Order Receipts 22 Planned Order Releases 1 1 PERIOD 5 6 1 2 3 4 7 8 9 10 25 25 25 25 25 80 as Item: 1 1 PERIOD 5 6 1 2 3 4 7 8 9 10 40 40 40 40 40 C LLC: 2 Lot Size: L4L LT: 25 Gross Requirements 22 Scheduled Receipts a Projected on Hand Net Requirements 20 Planned Order Receipts 3. Planned Order Releases 60 Paste BIU EEE 3. Merge & Center 21 A V * Item: D 2 1 PERIOD 5 6 1 2. 3 4 7 8 9 10 50 50 50 LLC: 4 Lot Size: 50 LT: as Gross Requirements 36 Scheduled Receipts 22 Projected on Hand 3* Net Requirements >> Planned Order Receipts 40 Planned Order Releases 85 2 PERIOD 5 6 1 N 4 7 8 9 10 100 4 Item: E LLC: 4 Lot Size: 100 LT: 4 Gross Requirements 4s Scheduled Receipts Projected on Hand 47 Net Requirements 4 Planned Order Receipts 4 Planned Order Releases 100 110 + 51 52 54 55 6 Problem 1 (25 Points): Fill the MRP sheet for the given product structure tree and data. All terms have their usual meaning. Paste B Mergo & Center Conditio Formatti Q1 Problem 125 Points) 1 3 6 7 8 N Time Period 4 40 5 60 9 10 10 50 60 0 PERIOD 5 6 1 1 2 3 4 7 8 9 10 B(3) C(4) 5 5 5 5 5 20 D(4) E(3) Item: ALLC: Lot Size: L4L LT: Gross Requirements Scheduled Receipts Projected on Hand 3. Net Requirements 12 Planned Order Receipts Planned Order Releases 14 3 Item: B LLC - Lot Size: L4L LT: Gross Requirements Scheduled Receipts Projected on Hand 20 Net Requirements 21 Planned Order Receipts 22 Planned Order Releases 1 1 PERIOD 5 6 1 2 3 4 7 8 9 10 25 25 25 25 25 80 as Item: 1 1 PERIOD 5 6 1 2 3 4 7 8 9 10 40 40 40 40 40 C LLC: 2 Lot Size: L4L LT: 25 Gross Requirements 22 Scheduled Receipts a Projected on Hand Net Requirements 20 Planned Order Receipts 3. Planned Order Releases 60 Paste BIU EEE 3. Merge & Center 21 A V * Item: D 2 1 PERIOD 5 6 1 2. 3 4 7 8 9 10 50 50 50 LLC: 4 Lot Size: 50 LT: as Gross Requirements 36 Scheduled Receipts 22 Projected on Hand 3* Net Requirements >> Planned Order Receipts 40 Planned Order Releases 85 2 PERIOD 5 6 1 N 4 7 8 9 10 100 4 Item: E LLC: 4 Lot Size: 100 LT: 4 Gross Requirements 4s Scheduled Receipts Projected on Hand 47 Net Requirements 4 Planned Order Receipts 4 Planned Order Releases 100 110 + 51 52 54 55 6