| # | Method | Number of Customers | OF1 | OF2 | OF3 |
|---|---|---|---|---|---|
| 1 | M1 | 100 | 258.4290 | 293.5395 | 301.6355 |
| 2 | M1 | 500 | 1280.8180 | 1462.4765 | 1529.1110 |
| 3 | M2 | 100 | 236.3005 | 265.0785 | 277.0325 |
| 4 | M2 | 500 | 1177.1435 | 1318.1280 | 1375.6050 |
| 5 | M3 | 100 | 201.6600 | 227.1070 | 236.2345 |
| 6 | M3 | 500 | 1005.1445 | 1159.1810 | 1186.9695 |
| 7 | M4 | 100 | 213.6790 | 242.6425 | 253.7560 |
| 8 | M4 | 500 | 1077.7960 | 1249.2230 | 1254.0385 |
Average Distance Traveled by Method, Objective Function, and Number of Customers
You decide to create a pivot table in Excel to summarize the average distance traveled for each method, objective function, and demand size to understand how these factors influence the total distance traveled.
Which of the following alternatives correctly describes the configuration of the pivot table in Table 1?
- Rows: Number of Customers, Method / Values: Average of Distance Traveled (km) / Filters: None / Columns: Objective Function
- Rows: Objective Function, Method / Values: Average of Distance Traveled (km) / Filters: Number of Customers / Columns: None
- Rows: Method, Objective Function / Values: Distance Traveled (km) / Filters: None / Columns: Number of Customers
- Rows: Method, Number of Customers / Values: Average of Distance Traveled (km) / Filters: None / Columns: Objective Function