Financial Forecast By Building Report
Purpose
Provides information about the cost information for each building by years and seats.
Navigate
From the top menu, click Report icon. Then from the Reports module, click Lease/Costs> Financial Forecast By Building.
Special Filters
You can apply filters to the graphs and tables and when the filter is applied the Filter icon will display the exact number. If needed the filters can shown/hidden, click the Filter icon and to clear the filter click X icon or clear all the filters, click the filter results X icon.
- Start Year/To Year Filter - Select the Start Year and the To Year.
- Calculate Metrics for Filter - Select the year.
- Regions Filter - Select the region.
- Countries Filter - Select the country or countries.
- Locations Filter - Select the location(s). This displays the seats for the selected locations.
- Sizes Filter - Select the size(s) of the building.
Special Data Elements
By default, the page is loaded without any filters applied and for the current assignment plan. When you apply the filters the results automatically display.
Financial Forecast Summary ($) Table
Displays the number of employees (seated in the building today).
Details Table
Displays the detailed costs and all your building data and insights.
The table consists of the following columns:
| Column | Description | Type |
|---|---|---|
| Building | Building name | Text |
| Size |
The size is measured by the number of employees (seated in the building today): Large: 150+ Medium: 50-150 Small-Med: 20-50 Small: <20 |
Number |
| Current HC | Current HC | Number |
| Lease Expiration | Lease Expiration date(takes the earliest one) | Date |
| Financial Forecast per year | (History, present, future, in millions) | Number |
| % Of Total Cost | Building cost Year X / Total operating costs (all Building) | Number |
| Seat demand |
HC Projections for year X for this building. Based on the data that the customer uploaded. | Number |
|
Costs($)/Seat Demand |
Year X building cost in millions / building HC Projections | Number |
| Demand % Of Total | HC Projections for this building in year X / total projections for all buildings for year X | Number |
| Available Seats | Available seats year X | Number |
| Total seats | Total Available seats year X | Number |
Sort Columns
By default, the columns are not sorted. You can sort the column, click the header to sort either ascending or descending.
Export
The export of the data is super quick, click the Export icon (top right). If you want all the data then make sure all the filters have been removed or if there are filters applied then the export will only export the filtered data to a CSV file.