A company needs to ship 100 units from Roanoke to Washington at the lowest possible cost. The costs associated with shipping between the cities are:

From/To

Lexington

Washington

Charlottesville

Roanoke

50

80

Lexington

50

40

Charlottesville

30

Create a spreadsheet model for this problem and solve it using Solver. Please take a screenshot when you set up the Solver window, then paste it in the same worksheet. Please use the decision variables defined as follows.(15)

Units to ship

From

To

X₁₂

1. ROA

2. LEX

X₁₃

1. ROA

3. CHA

X₂₃

2. LEX

3. CHA

X₂₄

2. LEX

4. WAS

X₃₄

3. CHA

4. WAS

3. CHA

X₂₄

2. LEX

4. WAS

X₃₄

3. CHA

4. WAS