how do do find the Central Method answer for question 1?

Questions 1. ( Pts) Now, we are considering building a new warehouse to accommodate total production volume from those four existing facilities - TMMC, TMMK, TMMI, or NUMMI - using the Centroid method. In this case, you could use the annual automobile production capacity of each facility in the tables 1 - 4 as the volume information (See Appendices). You could also use the following Google Map to compute the coordinate. A 500 m A-NUMMI MB - TMMC 500 km C = TMMK DTMMI Oregon Idaho Wyoming Nevada Utah Colorado North Dakota Minnesota South Dakota Wisconsin Michigan NI Nebraska Kansas California lowa Pennsy Illinoiy Ohio Diac West Missouri Virginia Kentucky Virgini Tennessee North Caroline Mississippi South Carolina Alabama Georgia Louisiana Oklahoma Arkansas Arizona New Mexico Texas Questions 2. (5 pts) Now, we are considering a transportation plan with current existing automobiles. The marketing department divided a market into the five segments as follows: NY, Houston, Dallas, LA in USA and Toronto in Canada. Each segment has its own estimated demand (requirements). The capacities of all four facilities are described in the last column. We assume that all automobiles are transported by truck. The distance between facilities and market segments are computed as follows in terms of miles. TMMC TMMK TMMI NUMMI requirement NY 486 708 854 2925 198450 Houston 1571 1073 983 1911 102900 Dallas 1378 880 770 1803 102900 LA 2462 2154 1986 364 205800 Toronto 64 574 720 2656 58800 supply 150000 375000 112500 281250 Develop the automobile transportation plan to minimize the total transportation cost in terms of the distance while satisfying all market demand. You may consider total travel distance as transportation cost. Provide the Excel Solver Questions 3. (5 pts) Now reconsider the problem 2 where we assume that all suppliers (plants) directly transport their automobiles to destinations (markets) and the transportation cost was calculated for each individual automobile since we calculated total travel distance for all automobiles. In other words, it was assumed that each individual automobile is transported separately. Since this is very unrealistic, we reformulated the problem again. Now we assume that one track can transport up to 20 automobiles. Therefore, it could significantly reduce the transportation cost. Based on this new assumption, solve the problem 2 again. Is there any difference in the resulting solutions compared to the original solution in question 2 Questions 1. ( Pts) Now, we are considering building a new warehouse to accommodate total production volume from those four existing facilities - TMMC, TMMK, TMMI, or NUMMI - using the Centroid method. In this case, you could use the annual automobile production capacity of each facility in the tables 1 - 4 as the volume information (See Appendices). You could also use the following Google Map to compute the coordinate. A 500 m A-NUMMI MB - TMMC 500 km C = TMMK DTMMI Oregon Idaho Wyoming Nevada Utah Colorado North Dakota Minnesota South Dakota Wisconsin Michigan NI Nebraska Kansas California lowa Pennsy Illinoiy Ohio Diac West Missouri Virginia Kentucky Virgini Tennessee North Caroline Mississippi South Carolina Alabama Georgia Louisiana Oklahoma Arkansas Arizona New Mexico Texas Questions 2. (5 pts) Now, we are considering a transportation plan with current existing automobiles. The marketing department divided a market into the five segments as follows: NY, Houston, Dallas, LA in USA and Toronto in Canada. Each segment has its own estimated demand (requirements). The capacities of all four facilities are described in the last column. We assume that all automobiles are transported by truck. The distance between facilities and market segments are computed as follows in terms of miles. TMMC TMMK TMMI NUMMI requirement NY 486 708 854 2925 198450 Houston 1571 1073 983 1911 102900 Dallas 1378 880 770 1803 102900 LA 2462 2154 1986 364 205800 Toronto 64 574 720 2656 58800 supply 150000 375000 112500 281250 Develop the automobile transportation plan to minimize the total transportation cost in terms of the distance while satisfying all market demand. You may consider total travel distance as transportation cost. Provide the Excel Solver Questions 3. (5 pts) Now reconsider the problem 2 where we assume that all suppliers (plants) directly transport their automobiles to destinations (markets) and the transportation cost was calculated for each individual automobile since we calculated total travel distance for all automobiles. In other words, it was assumed that each individual automobile is transported separately. Since this is very unrealistic, we reformulated the problem again. Now we assume that one track can transport up to 20 automobiles. Therefore, it could significantly reduce the transportation cost. Based on this new assumption, solve the problem 2 again. Is there any difference in the resulting solutions compared to the original solution in question 2