PLEASE SHOW ME HOW TO DO THIS IN EXCEL. I WOULD ALSO GREATLY APPRECIATE IT IF YOU COULD SHOW WHAT FORMULAS TO USE.

6.14. Reconsider the Littletown Fire Department problem presented in Section 6.4 and depicted in Figure 6.11. Due to maintenance work on the one-mile road between nodes A and B, a detour currently must be taken that extends the trip between these nodes to four miles. Formulate and solve a spreadsheet model for this revised problem to find the new shortest path from the fire station to the farming community. 6.11. The diagram depicts a system of aqueducts that originate at three rivers (nodes R1,R2, and R3 ) and terminate at a major city (node T), where the other nodes are junction points in the system. Using units of thousands of acre feet, the following tables show the maximum amount of water that can be pumped through each aqueduct per day. 6.14. Reconsider the Littletown Fire Department problem presented in Section 6.4 and depicted in Figure 6.11. Due to maintenance work on the one-mile road between nodes A and B, a detour currently must be taken that extends the trip between these nodes to four miles. Formulate and solve a spreadsheet model for this revised problem to find the new shortest path from the fire station to the farming community. 6.11. The diagram depicts a system of aqueducts that originate at three rivers (nodes R1,R2, and R3 ) and terminate at a major city (node T), where the other nodes are junction points in the system. Using units of thousands of acre feet, the following tables show the maximum amount of water that can be pumped through each aqueduct per day