please do the problem 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. D E F B F 3 required 2 required 2 required 3 required 2 required M M PARTD 1 5 6 7 11 9 5 8 6 10 Grous Requirements Scheduled Receptes Protestand Inventory Planned Order Releases Q = 30.01 = 1:55=0 PARTE 1 2 3 15 11 6 8 11 15 Gross Regurements Scheduled Recripts Proxected Onlund Inventory Planned Order Pes Q=1FL:LT=2553 Part 3 Operations Issues in Supply Chain Management 2 3 PARTE Gons Requirements Scheduled Recipes Projected and Inventory Planned Order Reos 20 0=60,0 = 1550