please show formulas

Question 4 - 4 Marks The Central Supply has 1200 units of Product X on hand. No more shipments will be forthcoming in the near future as the manufacturer is currently on strike. The inventory and usage / requirements of the local DC's are below: DC On hand Usage/week Usage/day (5 day week) E F G TIM 55 80 165 300 100 100 100 How many units of X should the Central Supply ship to each of the local DC's? Total inventory in entire system # days supply in entire system The following quantities will be shipped to each DC E F G Total Allocated Question 5 - 5 Marks Warehouse A B Requirements per week (5 day week) On Hand Week 1 Week 2 Week 3 Week 4 Week 5 Req'ts/day 110 100 100 100 100 100 120 2001 2001 200 200 200 70 100 100 100 100 100 If the Central Supply has 300 units and a Fair Shares approach will be used to allocate inventory, what qty should each warehouse receive from the Central Supply? Total Inventory in System Reqts/day for system Days Supply in system Qty to ship Warehouse A B Total OUD