Average Metrics by Method and Objective Function

You are interested in comparing the average performance metrics (distance traveled, delivery delay, and customers rejected) across different methods and objective functions. You decide to create a pivot table in Excel to summarize the average metrics for each method and objective function to identify the best-performing combinations.

Table 1: Pivot Table Structure for Average Metrics by Method and Objective Function
# Method Objective Function Average of Delivery Delay Average of Distance Traveled Average of Customers Rejected
1 M1 OF1 5.28800 769.62350 11.200
2 M1 OF2 4.51100 878.00800 11.025
3 M1 OF3 5.15050 915.37325 7.400
4 M2 OF1 4.55200 706.72200 8.475
5 M2 OF2 3.72050 791.60325 7.800
6 M2 OF3 4.32475 826.31875 5.625
7 M3 OF1 3.99625 603.40225 6.025
8 M3 OF2 3.36675 693.14400 5.800
9 M3 OF3 3.85475 711.60200 4.150
10 M4 OF1 4.21725 645.73750 6.875
11 M4 OF2 3.50525 745.93275 6.625
12 M4 OF3 3.98525 753.89725 4.750

Which of the following alternatives correctly describes the configuration of the pivot table in Table 1?

  1. Rows: Method, Objective Function / Values: Average of Distance Traveled (km), Average of Delivery Delay (hours), Average of Customers Rejected / Filters: None / Columns: None
  2. Rows: Method, Objective Function / Values: Sum of Distance Traveled (km), Sum of Delivery Delay (hours), Sum of Customers Rejected / Filters: None / Columns: None
  3. Rows: None / Values: Average of Distance Traveled (km), Average of Delivery Delay (hours), Average of Customers Rejected / Filters: Method, Objective Function / Columns: None
  4. Rows: None / Values: Average of Distance Traveled (km), Average of Delivery Delay (hours), Average of Customers Rejected / Filters: Distance Traveled, Delivery Delay, Customers Rejected / Columns: Method, Objective Function