Pearlsburg Rescue Squad Case.

In Excel $--$ Create and populate a matrix$/$spreadsheet that has three columns. $(24$ points$)$

Starting location $($Always Pearlsburg$)$

The other locations

Shortest route solution total time for that path $[$NOTE: MUST USE SHORTEST ROUTE METHOD $-$ Show work$]$

Hint: You should have $12$ rows.

You can use Excel, Excel QM or QM for Windows. $--$ Show the solution for two of the paths from above, using Solver.

Pearlsburg to Holbrook $(13$ points$)$

Pearlsburg to Wells Farm $(13$ points$)$

Submit the results on Canvas. You will have three tabs$.$

Shortest route from part $1.$

Pearlsburg to Holbrook.

Pearlsburg to Wellis Farm.