| # | Objective Function | Average of Number of Customers Rejected |
|---|---|---|
| 1 | OF1 | 16.2875 |
| 2 | OF2 | 15.6250 |
| 3 | OF3 | 10.9625 |
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.
Which of the following alternatives correctly describes the configuration of the pivot table in Table 1?
- Rows: None / Values: Average of Customers Rejected / Filters: Service Level = SL1 / Columns: Objective Function
- Rows: Objective Function / Values: Average of Customers Rejected / Filters: Service Level = SL2 / Columns: None
- Rows: None / Values: Average of Customers Rejected / Filters: Service Level = SL2 / Columns: Objective Function
- Rows: Objective Function / Values: Average of Customers Rejected / Filters: Service Level = SL1 / Columns: None