build table of stock levels across locations for shipment creation