Avg Customers Rejected by Objective Function

You want to analyze the average number of customers rejected by each objective function. You decide to create a pivot table in Excel to summarize the average number of customers rejected for each objective function, so you can identify which objective function leads to the highest number of rejections. You filter the service level to SL1 to focus on scenarios where customers can be rejected.

Table 1: Pivot Table Structure for Total Customers Rejected by Objective Function Filtered by Service Level
# Objective Function Average of Number of Customers Rejected
1 OF1 16.2875
2 OF2 15.6250
3 OF3 10.9625

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

  1. Rows: None / Values: Average of Customers Rejected / Filters: Service Level = SL1 / Columns: Objective Function
  2. Rows: Objective Function / Values: Average of Customers Rejected / Filters: Service Level = SL2 / Columns: None
  3. Rows: None / Values: Average of Customers Rejected / Filters: Service Level = SL2 / Columns: Objective Function
  4. Rows: Objective Function / Values: Average of Customers Rejected / Filters: Service Level = SL1 / Columns: None