PLEASE ONLY HELP ANSWER PARTS 3 & 4. i already have the math done and the answers to the first two parts.

12:51 1 + E + chegg.com I just need help with 3 & 4, please! 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. 1. What are the locations for the open plants and what is the optimal total cost of the network? Are all open plants being used to full capacity? Which, if any plant has excess capacity and what is the excess capacity available at this plant? operative plants are B. I, and J. Plant l's won't be using full capacity 2. Suppose that the maximum distance between a plant and a market cannot exceed 150 miles. What additional decision variables and/or constraints do you need to add to your model in question 1) to accommodate this condition? the optimal transportation plan does not include distance pairs that are over 150 miles, 3. Resolve the model developed and identify the new plant locations and the minimum cost. 4. Identify an additional scenario and develop a model for the scenario. Analyze the model and discuss your model results. TE 000 000" Plant Selections 1.00 200 3.00 4.00 5.00 6.00 Total Productie Capacity Xi-Capacity Plant Com 0.00 0.00 0.00 0.00 0.00 0.00 000" 0.00 22000 0.50 0.00A B 100 0.00 10000.00 2000.00 12000.00 0.00 0.00240000000000 0445 0.003 C 0.00 0.00 000 0.00 0.00280000 000C D 0.00 0.00 DO 0.00 0.00 0.00 000" 0.00 30000 040 0.000 0.00 0.00 000 0.00 0.00 0.00 0.00 0.00 30000.00 0.56 0.001 IF 0.00 0.00 0.00 0.00 0.00 0.00 0:00 260 050 lo 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 29000_001 0.50 0.0010 H 0.00 0.00 0.00 0.00 0.00 0.00 000000000 046 0000 1.00 300000 0.00 5000.00 0.00 10000.00 0.0018000.00 20000.00 -200000 100 13000.00 0.00 0.00 0.00 0.00 900000 21000 2100000 041 0.0011 Total 1400000 1000000 300000 1200000 10000.00 9000.00 De Market 100 2.00 3.00 4.00 3.00 600 0.00 26101 30:40 13940 72.60 11.70 76.10 Dod 7100 72 14450 3520 20.30 39610 $470 319 301 52301 18720 99 od 45:20 13.50 8550 23.00 14 6730 9.30 7100 0.00 1992 94.90 38.10 7730 138.20 0.00 2018 146.90 4701 10690 46.201 180.22 72601 1440 94501 20790 0.00 63.40 11.10 83701 3310 146.90 63.40 0.00 14000.00 2.000.000.000.000,00 2.000.000.00 000 00012 0.00 Variable Cou 4.00 6.00 1.00 000 2.00 041 CRO 093 5.00 0.45 0.02 08 041 0. Total Production Cont Total Fund & Trans Cout Total Com $ 27,150.00 5254.12.13 $20,932,13 OR 03 0.131 001 F Plant contin ) A 11.400.00 B 33310000 C 300.00 D 100000 E 310000 IF 16209.00 11800.00 H 91.000.00 196 3.00 0.19 041 029 033 022 000 0.89 DED 050 03 OG 0.91 0.03 00 205 080 LP NO 10 0:49 2000 00 0.00 1030000