Please answer problem in excel format with formulas showing.

4. The XYZ Company's finance manager is currently studying projected inventory investment for product 101 at the central (plant) warehouse. Quantities of product 101 are shipped from the central warehouse to warehouses A and B, based on individual warehouse requirements. The product costs $100 per unit. Using DRP parameters and inventory information for product 101, determine the planned order releases at the central warehouse. Week Warehouse A 1 2 3 4 5 6 Forecast Requirements 15 15 15 15 15 15 Scheduled Receipts 15 Projected Available Balance 10 T T T Planned Shipments Q-64, LT-1;SSO Week Warehouse B 1 2 3 4 5 Forecast Requirements 10 10 10 10 10 10 Scheduled Receipts Projected Available Balance Planned Shipments Q-32; LT=1; SS=0 Week Central Warehouse 1 2 3 4 5 6 Gross Requirements Scheduled Receipts Projected Available Balance 47 Planned Order Release Q-LAL: LT-1; SS=0 What is the planned order release (central warehouse) at week 4