Chapter 7, Problem 26QP

The following network describes a transportation scenario in which there are four sources A, B, C, and D, and three destinations P, Q, and R. (The numbers next to each arrow represent the cost of transporting one unit from that particular source to the destination located at the other end of that arrow). Write the mathematical formulation of the problem. Use the Excel Solver to solve the problem. Generate the answer and sensitivity reports in Excel, and submit your Excel workbook as a separate attachment. Provide the solution obtained in the space provided. What is the optimal cost of transportation?

The Hills County, Michigan, superintendent of education is responsible for assigning students to the three high schools in his county. He recognizes the need to bus a certain number of students, for several sectors, A - E, of the county are beyond walking distance to a school. The superintendent partitions the county into five geographic sectors as he attempts to establish a plan that will minimize the total number of student miles traveled by bus. He also recognizes that if a student happens to live in a certain sector and is assigned to the high school in that sector, there is no need to bus him because he can walk to school. The three schools are located in sectors B, C, and E. The accompanying table reflects the number of high-school-age students living in each sector and the distance in miles from each sector to each school: Distance to School Sector School in Sector School in Sector School in Sector B C E A B C D E Total 7 0 4 5 12 5 4 0 4 7 6 12 7 7 0 Number of Students 700 500…

At the end of a cycle of schedules, a trucking firm has a surplus of one vehicle each in cities A, B, C, D, E, and F and a deficit of one vehicle each in cities 1, 2, 3, 4, 5, and 6. The distances between cities with a surplus and the cities with a deficit are shown below. Find an assignment of surplus vehicles to deficit cities that will result in a minimum total distance. What is the total distance? -Solve the following transportation models using Excel Solver. -Find the optimal solution for the transportation problem having the cost and requirement tablebelow.

Santa Cruz Bottling is a manufacturer of organic soft drinks on the coast of central California. Its products are enjoying a growing reputation and increased demand throughout the American Southwest. Because of the high cost of transportation soft drinks, they are considering a new plant to serve the states of New Mexico and Arizona. A key concern in their search for a new location is the resultant transportation cost to serve their key markets. Following is a list of cities where their main wholesale customers are located, along with estimated annual demand in cased of product for each.  CITY                x-COORDINATES       y-COORDINATES           # OF CASES  Phoenix                  281                                   281                    24,500  Tucson                    381                                  156                    20,000  Albuquerque          831                                   481                    28,000  Santa Fe                  881…

In the original Gorman Construction Company problem, we found the shortest distance from the office (node 1) to the construction site located at node 6. Because some of the roads are highways and others are city streets, the shortest-distance routes between the office and the construction site may not necessarily provide the quickest or shortest-time route. Shown here is the Gorman road network with travel time rather than distance. Find the shortest route from Gorman’s office to the construction site at node 6 if the objective is to minimize travel time rather than distance.

A chain of home health care firms in Louisiana needs to locate a central office from which to conduct internal audits and other periodic reviews of its facilities. These facilities are scattered throughout the state, as detailed in the following table. Each site, except for Houma, will be visited three times each year by a team of workers, who will drive from the central office to the site. Houma will be visited five times a year. Q City Covington Donaldsonville Houma Monroe Natchitoches New Iberia Opelousas Ruston Map Coordinates X 750 9.4 7.5 7.8 00 00 4.8 2.8 5.7 4.8 4.0 Y 3N-∞0 60 Nm 0o ∞0 277 00 - 9 N 3.8 N 00 2.2 1.7 8.7 6.8 2.1 3.9 8.2 For the location of the new central office, the coordinates should be near: x = (round your response to two decimal places). b.) y should =____? c.) The center-of-gravity approach minimizes the distance traveled assuming straight lines. This approach ignores geographical features that would tend to violate the straight line constraint such as…

Rauschenberg Manufacturing is investigating which locations would best position its new plant relative to three important customers (located in cities A, B, and C). As shown in the table below, all three customers require multiple daily deliveries. Management limited the search for this plant to those three locations and compiled the following information: Location A B C Coordinates (miles) (200,100) (400,200) (300,100) a. Which of these three locations yields the smallest load-distance score, based on Euclidean distances? Location one decimal place.) b. Which of these locations is best, based on rectilinear distances? yields the smallest load-distance score of Location whole number.) c. What are the coordinates of the center of gravity? is the best, yielding a load-distance score of * The center of gravity is x = decimal place.) * Deliveries per day miles, y = 5 7 9 (Enter your response rounded to (Enter your response as a miles. (Enter your responses rounded to one

Please help me with part b

Explain along with examples related to Freight Traffic Assignment Problems and vehicle routing problem in the logistics activities of manufacturing and service companies! Solve the following case study using the transportation method: Suppose there is a manufacturing company that produces and distributes its products to various customer locations across the country. This company has three production plants (Plant A, Plant B, and Plant C) located in different locations, and there are also five distribution centers (DC 1, DC 2, DC 3, DC 4, and DC 5) scattered across various regions. The company's goal is to determine the most efficient transportation routes for delivering products from the plants to the distribution centers, considering transportation costs and available capacities.