Consider product #$1$ with the following bill of material:

please answer a$)$ on excel with formulas

Consider product #$1$ with the following bill of material:

The following planning factors and inventory records are also given:

a$)$ Create the product structure diagram of this product. Then, use a spreadsheet to develop the

MRP records for all the parts on the product structure for the next $6$ weeks, and identify the

planned order releases for all these parts.