Excel: Put response in a single spreadsheet and Include an Answer Report

STACycles manufactures bikes at factories in Albany, Syracuse, and Rochester. The bikes are sent to regional distributors in Detroit, Knoxville, and Atlanta, with varying shipping costs. The company would like to find the least-cost way to meet the demands at each of the distribution centers. Detroit needs to receive 800 bikes each month, Knoxville needs 600, and Atlanta needs 200. Albany produces 850 each month, Syracuse 650, and Rochester 300. The shipping cost per unit from each pair of cities is given in the table below:

Distributor

Factory Detroit Knoxville Atlanta

Albany 8 12 10

Syracuse 10 14 9

Rochester 11 8 12

Is it possible for STACycles to meet the given demands with its available supply? What is a possible routing plan which minimizes costs, and what is the minimal cost?