The Lease Benchmarks report presents a variety of key benchmarks for comparing leases on an even basis. The report provides these benchmarks for each lease and also summarizes data for all leases in the report by providing the Average, Minimum, and Maximum for lease data. The Average, Minimum, and Maximum enable you to compare a lease to the group of leases included in the report.
This report includes the following types of benchmarks:
See the Lease Benchmark Calculations section for a description of the calculations used for each benchmark.
You generate this report by selecting Cost Administration / Cost Administrator / Lease Benchmarks.
This topic includes the following information:
The Lease Benchmarks report presents its information on the following tabs from which you can set a restriction and view report data:
When reviewing the financial reports, be sure to consider how the Filter console was completed. See Understanding Financial Analysis Reports for more information on how costs are selected.
Note: To set a custom date range, Select Other Date Range, and then enter a Start and End Date.
See Using the Filter Console for more information on using filter consoles.
Note: When you export the report data to Excel, the Average, Minimum, and Maximum values are not exported. You can use Excel's features to calculate these values for the exported data.
The Lease Benchmarks report includes the following types of calculated fields:
Note: The measured areas based on a building performance CAD inventory are calculated when the Update Area Totals action is run from one of the processes for the Space Inventory & Personnel application, such as the Building Performance process. If your CAD specialist has made recent changes to your measured areas, ask your space manager or facility manager to run the Update Area Totals task so that these area changes are reflected in the Lease Administration, Portfolio Management, and Cost Administration reports.
For a description of each benchmark, see Lease Benchmark Calculations.
When the ARCHIBUS Enhanced Global Feature Set is enabled, the Lease Benchmarks report by default shows Base Costs (without VAT) in the Budget Currency, providing an assessment of lease costs and benchmarks independent of taxes paid and received.
You can generate the Lease Benchmarks report to show Total Costs, Base Costs, or VAT Costs using the Budget Currency, your User Default Currency, or a currency you select. Generating the report using the Budget Currency enables you to assess unit costs per occupancy or negotiated area using your organization's currency. The Payment Exchange Rate enables you to asses performance in the local currency.
From the Currency button, if you choose the "Select Currency" option, you can chose to display the monetary values using either the Payment Exchange Rate or the Budget Exchange Rate for the currency you select.
Just as when the ARCHIBUS Enhanced Global Feature Set is not enabled, the Lease Benchmarks report calculates benchmarks to compare leases on an even basis. However, when the ARCHIBUS Enhanced Global Feature Set is enabled, the report calculates lease costs using Total Costs, Base Costs, or VAT Costs depending on the selections you make to generate the report. See Selecting VAT Cost Types and Currency for Reports for a description of the cost fields used to show VAT costs in different currencies.
The Currency and VAT buttons affect the values shown on the Overview tab only. The Net Income and Yearly Total Cost/Neg. Rentable Area on the Details tab shows lease costs using Base Costs in Budget Currency, regardless of the selections you make on the overview tab.
Area fields are displayed in the User Display Units of Measure set in the User Profile for the logged on user.