Quantitative Analysis for Management, 13/e

Long description

The following instructions are in the spreadsheet:

• From the Excel QM ribbon, select Menu (Alphabetical or By Chapter). Select Network Analysis as LP and Shortest Route from the drop-down menu. Then fill in the number of branches or arcs (6). Click OK.

• When the worksheet opens, enter the distances in the table.

• After entering the data, click the Data tab and select Solver. Then click Solve.

A data table for distance from and to cities has the column and row headers from City 1 to City 6.

• The first row has the values 0, 100, 200, 0, 0, and 0.

• The second row has the values 100, 0, 50, 200, 100, and 0.

• The third row has the values 200, 50, 0, 0, 40, and 0.

• The fourth row has the values 0, 200, 0, 0, 150, and 100.

• The fifth row has the ...