Sustainability & Risk / Energy / Energy Manager

What-if Scenarios

The What-if Scenarios report provides both a drill-down selection list and a Filter console. These features work together to help you define the data shown in the reports.

Selecting the Data

Drill-down selection lists: You can report on any level within the drill-down selection list. The program rolls up data from the building to the site to the city to the region to the country. The charts sum the appropriate data to the level you select in the selection list. When you switch between tabs, the data remains filtered to the level you have selected.

Filter Console: You can use the Filter console to show only data from a specific range of billing periods. You can also select specific bill types to show in the reports. When you switch between tabs, the data remains filtered to your selection in the drill-down selection list.

The Filter console also allows you to define a percent amount of change for either/both the Expense Amount and / or the Occupancy. The filter allows you to enter both positive and negative as well as fractional numbers.

The What-If Scenario Report

The What-if Scenarios give you an idea of possible financial impact based on two scenarios:

% Cost Change

• This takes the Total Expense for each building by month (based on the Billing Period selected) and increases / decreases it by the percentage entered in the Filter console.
• The Cost (Actual) shows the actual cost for the Billing Period shown.
• The Cost (Scenario) shows the value of the actual cost * the value entered into the Filter console.
• The Impact shows the impact of the change defined in the Filter console.

Note: The Cost Tab shows only adjusted values based on % Cost Change, while the Cost and Occupancy Tab shows adjusted values based on both % Cost Change entered and % Occupancy Change entered.

% Occupancy Change

• This takes the Cost per Headcount for each building by month (based on the Billing Period selected) and increases / decreases it by the percentage entered in the Filter Frame.
• This can also take the Total Expense for each building by month (based on the Billing Period selected) and increases / decreases it by the percentage entered in the Filter Frame.
• The Cost per Occupant (Actual) shows the actual cost per occupant for the Billing Period shown.
• The Cost per Occupant (Scenario) shows the value of the actual cost per occupant * the value(s) entered into the Filter Frame.
• The Impact per Occupant shows the impact of the change defined in the Filter Form.

How the Cost per Occupant is calculated

The Cost per Occupant is calculated in one of two ways depending on values in the database.

• Archibus first checks to see if there is a value in the Employee Headcount field in the Buildings table. If there is, the total energy cost for the building is divided by the Employee Headcount of the building.
• If there is not a value in the Employee Headcount field in the Buildings table, the total energy cost for the building is divided by the Building Occupancy field in the Buildings table.
• If both the Employee Headcount and Building Occupancy fields have no values (or have values of 0), Archibus will return a zero amount for the records in that building.