Calculated measures and KPIs
This table shows the measures that are calculated in the cube:
| Measure | Description |
|---|---|
| Avg Book Rate | Book rate divided by the number of records |
| Avg Fleet Age | Fleet age divided by the number of records |
| Avg Net Rate | Net rate divided by the number of records |
| Book Rate Util % | The possible rental income divided by the possible book revenue |
| Financial Util % | Rental revenue divided by the original equipment cost |
| Maint & Rep vs Revenue % | The sum of maintenance and repair costs divided by the rental revenue |
| Maint vs Revenue % | Maintenance costs divided by the rental revenue |
| Net Rate Util % | The actual rental income divided by the possible net revenue |
| Net Time Util % | The net rented days divided by the possible rental days |
| Possible Financial Util % | The possible book revenue divided by the acquisition cost |
| Rate Yield % | To evaluate the daily rate pricelist compared with the actual rental rates, the actual rental income is divided by the possible book revenue |
| Repair vs Revenue % | Repair costs divided by the rental revenue |
| Rental Gross Margin % | Rental gross profit divided by the rental revenue |
| Rental Gross Profit | Rental revenue minus the sum of depreciation and maintenance costs |
| Time Util % | The number of actual rental days divided by the possible rental days |
| Weighted Fleet Age | Fleet age divided by the original equipment cost |
| Weighted Time Util % | The original equipment cost multiplied by the rental days excluding out of service time divided by the original item cost multiplied by the possible rental days for the period |