Set up a spreadsheet and use solver to find the optimal location of the new factory to minimize the total transportation cost

All of the data is provided in the picture posted

5 Moving resources efficiently from supplier to consumer is a challenging problem that can be solved using O.R. techniques. The figure below shows a map of blue factories that supply food to orange towns. The numbers below the factories and towns indicate how much food (in kg) each supplies and demands, respectively. Any factory can supply any amount of food to one or several towns. A new factory is being built that can supply 1,000 kg of food but the location of the factory has not yet been determined. The distance between adjacent cells on the map is 1 km. The cost to transport 1 kg of food 1 km is $10. 1500 If the new factory is optimally located, what is the total transportation cost to satisfy the demand of all towns? The new factory cannot occupy a cell that already contains an existing factory or town. Source: This problem taken from John Toczek ORMS Today, February 2009. p. 16