please use solver in excel and show work! thank you!

Energy Soft Drinks Bottler (ESDB) Inc. has recently developed and started marketing a new soft drink. The sales of the soft drink have sky-rocketed and ESDB is evaluating the decision to set up a new plant to which some of the existing production can be moved. The annual fixed cost, the cost of production and the plant capacity for each of the ten plant locations (A thru J) ) is shown in Table 1. The distance in miles between the ten potential plants and the six markets ( 1 thru 6 ) is given in Table 2. Table 2 also shows the demand for the soft drink at the six markets. ESDB uses trucks for transporting the soft drink from the bottling plant to the different markets. These trucks have a capacity of 150 hectoliters and incur an operating cost of $0.92 per mile. After delivery to the market, the trucks return empty to the plant. Identify an additional scenario and develop a model for the scenario. Analyze the model and discuss your model results. Tahla 1 FSnR'e rnereand mamaniu. Table 2. Distance in miles between potential plants and markets