Pearlsburg Rescue Squad Case. (see case study below)

1. In Excel, or Excel QM or QM for Windows -- Create and populate a matrix/spreadsheet that has three columns. (24 points)
   1. Starting location (Always Pearlsburg)
   2. The other locations
   3. Shortest route solution total time for that path [NOTE: MUST USE SHORTEST ROUTE METHOD - Show work]

Hint: You should have 12 rows.

2. In Excel -- Show the solution for two of the paths from above, using Solver.
   1. Pearlsburg to Holbrook (13 points)
   2. Pearlsburg to Wells Farm (13 points)

3. Submit the results. You will have three tabs.
   1. Shortest route from part 1.
   2. Pearlsburg to Holbrook.
   3. Pearlsburg to Wellis Farm.

Note: use this numbering scheme

1	Pearlsburg
2	Kitchen Corner
3	Quarry
4	Morgan Creek
5	Stone House
6	Cedar Creek
7	Cutters Store
8	Blakes Crossing
9	Homer
10	McKinney Farm
11	Wellis Farm
12	Bottom Town
13	Holbrook

Case Problem

The Pearlsburg Rescue Squad

The Pearlsburg (West Virginia) Rescue Squad serves a mountainous, rural area in southern West Virginia. The only access to the homes, farms, and small crossroad communities and villages is a network of dirt, gravel, and poorly paved roads. The rescue squad had just returned from an emergency at Blakes Crossing, and two of the squad members, Melanie Hart and Ben Cross, were cleaning up and getting the truck back in proper order for the next call.

You know, Ben, said Melanie, that was close. We could have lost little Randy if we had been a few minutes later in getting to their farm.

Yep, said Ben.

After a moment Melanie continued, I was sort of wondering about the route Dave took to get there. It seems to me if we had gone around by Cedar Creek, we could have gotten there a few minutes sooner. And as close as things got, a few minutes could have made a big difference, dont you think?

Yep, said Ben.

Well, I was wondering, Ben, why dont we study all these different ways to get to the little communities and farms around here so we will always know what the quickest way to all the different places is?

Ben thought a moment before answering. It would take us a while to time all the different ways you could get from here to everywhere we go.

Thats true, Melanie answered, but Ive been studying a way to work out this sort of problem in one of my college courses. All we have to do is get the times it takes to travel each piece of road between all these little communities, and I think I can do the rest. Will you help me?

Sure, Ben said.

Okay, then, heres what well do. Ill write down all the routes you should time, and Ill time the rest all the way over to Holbrook.

Here is the combined list of times (in minutes) Melanie and Ben compiled for all the route segments between Pearlsburg and Holbrook:

Segment	Time
Pearlsburg to Kitchen Corner	10
Pearlsburg to Quarry	15
Pearlsburg to Morgan Creek	12
Kitchen Corner to Cutters Store	20
Kitchen Corner to Stone House	14
Kitchen Corner to Quarry	8
Quarry to Blakes Crossing	18
Quarry to Cedar Creek	9
Morgan Creek to Quarry	16
Morgan Creek to Cedar Creek	7
Morgan Creek to Homer	18
Morgan Creek to McKinney Farm	11
Stone House to Cutters Store	10
Stone House to Blakes Crossing	6
Cedar Creek to Blakes Crossing	10
Cedar Creek to Wellis Farm	17
Cedar Creek to Homer	5
Cutters Store to Blakes Crossing	12
Cutters Store to Bottom Town	14
Blakes Crossing to Bottom Town	6
Blakes Crossing to Holbrook	15
Blakes Crossing to Wellis Farm	9
Homer to Wellis Farm	11
Homer to McKinney Farm	8
McKinney Farm to Wellis Farm	21
Wellis Farm to Holbrook	10
Bottom Town to Holbrook	12

Determine the shortest routes from Pearlsburg to all the different communities and farms visited by the rescue squad.

PLEASE SHOW ME STEP BY STEP HOW TO COMPLETE IN EXCEL. The top part is the assignment and the bottom portion is the case study portion for the assignment.