There are currently 2 warehouses with a total inventory of 500. What would the estimated inventory be for 4 warehouses?

The following formula should be used Please show the formula in excel please

ESTIMATING RISK POOLING EFFECT Square Root of N Rule Use information from previous example X = SS for I warehouse X 2 = (X)(Jnalni) X = 147.6 (SS for 2 warehouses) n2 = I warehouse - Where: X = total inventory in prospective facilities X, = total inventory in existing facilities n2 = number of prospective facilities ng = number of existing facilities Demonstrates the considerable rise in safety stock with more stocking point locations . . n = 2 warehouse