Quiz 7: Network Flow Models 

Business

Step 1: Plot the points on the metro map of Paris as shown below: img Step 2: Plot the network model as shown below: img Option 1: Suppose Ms. K started her journey from point M. She can follow the following route so that she can explore all the famous attraction sites: img Therefore total travelling time taken to explore all these sites will be 112 mins. Option 2: If Ms. K starts her journey from point M and head towards point H, the total travelling time will be as shown below: img Therefore the total travelling time will be 109.30 mins. Therefore, it can be concluded from above path that, she can cover all the sites in a day as the maximum travelling time is 112 mins only. Moreover, the capacity to cover all the sites will also depends on the time spent by her at each sites.

Person PTF had wagered his fellow members that he could travel around the complete world in 80days. Actual data regarding the distances between different cities, routes and expected time are provided in a chart. These data are tabulated in an excel sheet, as shown below: img img img img img img Access "Excel solver" from menu bar and enter the following values in the pop-up window: img Click on "Solve" option. Then, following pop up would appear: img Now, click on "OK" button. It would give the following results: img img img Hence, the total time required by Person J to complete his journey around the world is 81. The shortest possible route for this journey is City Lo - City Pr - City Bcl - City Npl - City Atn - City Cro - City Ad - City Bb - City Clt - City Sgp - City HK - City Shg - City Ykhm - City Sfs - City Dnv - City Cg - City NYK - City Lo As per the wager, total time required to complete this journey is within 80 days. Therefore, Person PTF could not win the wager using this path , because the shortest possible time to complete this journey is 81 days.

Solve the network flow model problem using excel solver. Follow the given steps to find out the optimal route for the trucks. Step 1: Formulate an excel sheet using given values and formulas: img img img Step 2: Formulated spreadsheet is shown below: img img Access "Excel solver" from menu bar and enter the following values in the pop-up window: img Click on "Solve" option. Then, the following pop up would appear: img Now, click on "OK" button. It would give the following results: img img The optimal route for the truck is 1-2-11-15-16-19-23-28-31-33. The least number of people exposed to the trucks are 7.03 million.

There is no answer for this question