Fleet Stats and Financial Summary Report

Location

REPORT > Management Reports > Revenue

Purpose

The Fleet Statistics and Financial Summary Report provides daily and cumulative utilization percentages, revenue totals, and vehicle costs for a specified time period up to three months. It gives a detailed view of each vehicle class’ activity by location.

The report is divided into four sections. The first section provides data on available fleet, daily T&M and coverage rates, and utilization. The Total Revenue Statistics section shows the total amount of revenue for the given time period. The Daily Revenue Statistics section shows revenue by daily average. The Vehicle Cost and Gross Profit section shows fleet costs and depreciation subtracted from revenue.

Note: Some of the values in this report are obtained from the summary tables used by the Location Performance Report. See the "Options" button section for details.

Columns

Average Avail Fleet – Average number of vehicles available for rental. Taken from the LPR’s In Flt column.

Average Actual Fleet – Average number of vehicles in the fleet. Taken from the LPR’s InFlt, O/S, and Unavl columns.

Avail Rental Days – Total number of days that available vehicles can be on-rent. Taken from the LPR’s Days Avail column.

Actual Rental Days – Number of days that vehicles were actually on-rent. Taken from the LPR’s Closed Days column.

% Utilization – Actual Rental Days divided by Avail Rental Days.

T&M Daily Rental Rate – The average daily T&M rate for the contracts in the report’s date range.

T&M Charge Per Mile – The average charge per mile for the contracts in the report’s date range.

T&M Daily Free Miles – The average daily free miles for the contracts in the report’s date range.

Average Miles Per Day – Sum of mileage per contract divided by number of contracts.

Average Days Per Rental – Sum of charged days per contract divided by number of contracts.

Coverage Daily Rates – Daily rate values taken from each coverage, for each class.

Total Revenue Statistics

Avail Rental Revenue – Avail Rental Days multiplied by the T&M Daily Rental Rate and miscellaneous charges daily rates.

Standard Rental Revenue – Actual Rental Days multiplied by the T&M Daily Rental Rate and miscellaneous charges daily rates.

Actual Rental Revenue – T&M added up from contracts, minus discounts, plus miscellaneous charges.

Deviation From Standard – Standard Rental Revenue minus Actual Rental Revenue.

% Utilization – Actual Rental Revenue divided by Avail Rental Revenue.

Daily Average – Actual Rental Revenue divided by Actual Rental Days.

Avail Coverage Revenue – Coverage Daily Rate multiplied by Avail Rental Days.

Actual Coverage Revenue – Coverage Daily Rate multiplied by Actual Rental Days.

% Utilization – Actual Coverage Revenue divided by Avail Coverage Revenue.

Total Contracts – Total number of contracts closed during the report’s date range.

% With Coverages – Rentals with coverage divided by Total Contracts.

Daily Revenue Statistics

Avail Mileage Revenue – Average Miles Per Day multiplied by the T&M Charge Per Mile.

Actual Mileage Revenue – Total amount of mileage charges.

Avail Time Revenue – Avail Rental Days multiplied by the T&M Daily Rental Rate.

Actual Time Revenue – Time charges added up from contracts.

Avail T&M Revenue – Avail Rental Days multiplied by the T&M Daily Rental Rate.

Actual T&M Revenue – T&M charges added up from contracts, minus discounts.

% Utilization – Avail T&M Revenue divided by Actual T&M Revenue.

Avail Coverage Revenue – Avail Rental Days multiplied by the Coverage Daily Rate.

Actual Coverage Revenue – Coverage charges added up from contracts.

% Utilization – Avail Coverage Revenue divided by Actual Coverage Revenue.

Avail Total Revenue – Avail T&M Revenue plus Avail Coverage Revenue.

Actual Total Revenue – Actual T&M Revenue plus Actual Coverage Revenue.

% Utilization – Actual Total Revenue divided by Avail Total Revenue.

Average Gas Revenue – Sum of fuel charges divided by total number of contracts.

Car Costs & Gross Profit

The Daily Depreciation Rate Used value will be calculated from the vehicles’ depreciation rates to come up with an average depreciation rate.

Average Car Cost – Sum of acquisition prices divided by number of cars.

Number Of Purchase Days – Number of days during the report period that the cars are being depreciated.

Total Deprec Expense – Daily Depreciation Rate Used multiplied by the number of cars multiplied by the Number Of Purchase Days.

Number Of License Days – Number of days during the report period that the cars’ licenses are being depreciated.

Total License Cost – Sum of license costs multiplied 365 multiplied by the Number Of License Days.

Actual Revenue Per Car Day – Actual Rental Revenue divided by Number Of Purchase Days.

Deprec Exp Per Car Day – Average Car Cost multiplied by Daily Depreciation Rate Used.

Lic Cost Per Car Day – Total License Cost divided by 365.

Total Expenses Per Car Day – Deprec Exp Per Car Day plus Lic Cost Per Car Day.

Gross Profit Per Car Day – Actual Revenue Per Car Day minus Total Expenses Per Car Day.

Gross Profit For The Period – Actual Rental Revenue minus Total Expenses Per Car Day times Number Of Purchase Days.