please use excel to solve this problem amd show how you got calculations in excel

8. The bills of materials for two finished products (D and E), inventory status, and other relevant information are given below. Compute the planned order releases and projected on-hand balances for parts D, E, and F E B F R 2 required 3 required 2 required 3 required 2 required L M L M PART D 5 11 5 8 Gross Requirements Scheduled to Projected On hand Planned Oider Releases = = 1555 = 0 PARTE 2 3 4 15 11 Gegen Scheduled to Projected Un and try PARTF 1 1 2 3 4. 5 6 60 Gross Requirements Scheduled Receipts Projected On-hand Inventory Planned Order Releases 20 0 = 60, LT = 1:5S=0