What If Analysis Table
Use the What If Analysis table to investigate "what if" pool cost and pool base scenarios for selected cost pools.
-
What If Pool Cost: Actual pool cost x What if percentage
-
What If Adjustment (for pool cost): Actual pool cost - What if pool cost
-
What If Pool Base: Actual pool base amount x What if percentage
-
What If Adjustment (for pool base): Actual pool base amount - What if pool base amount
-
What If Pool Rate: What if pool cost / What if pool base
Note: If you adjust the pool rate, the table calculates an adjusted "what if" amount for pool cost only. Pool base is not affected in this case.
Period and Year-to-Date Amounts and Rates
If you select the YTD option, the table displays actual year-to-date costs, base amounts, and rates.
If you select the Period option, the table displays actual costs, base amounts, and rates for the current period.
Filter Options
- Select the company for which you want to analyze indirect rates
- Focus the table on one or more types of cost pools
Export to Excel
To export the data in this table to a Microsoft® Excel® spreadsheet, click in the upper-right corner of the table.