Daily Location Summary Report

Location

REPORT > Management Reports > Revenue

Purpose

The Daily Location Summary Report provides a snapshot of a location’s revenue by calculating accrued revenue from contracts and factoring in fleet costs.

Options

Separate/Consolidated Locations – The report can show each location in a separate section or combine all locations.

Separate/Consolidated Classes – The report can show each class in a separate section or combine all classes.

Calc. Utilization By – The utilization figures can be calculated by the actual number of days that vehicles were rented or by the number of days charged on each contract.

Accruals – Open contracts can be accrued to their due back date or to the report’s date (as-of date).

Select Fleet Numbers By – When finding vehicles to include in the depreciation calculation, the report can use either the vehicles’ current location or the owning location.

Buttons

Options – The Options button allows you to change the way the report calculates the values. Because this report scans through many records, it summarizes some data and stores those values in the database.

If you select "Calculate real-time", the report will use the contract records for its calculations, ignoring the summary records. If you select "Use saved calculations", the report will use only the summary records for its calculations. If a needed record is missing or has become out-of-date, an asterisk will appear on the far-left side of the appropriate report line. If the "Recalculate out-of-date records" box is checked, the report will recalculate the missing or out-of-date summary records using the contract records.

Note: These settings are also used by the Location Performance Report. Changes to these settings will affect both reports.

Data Selection

• The "Units" columns are calculated using the vehicle transaction records. Each vehicle’s fleet position (In Fleet, Out of Service, Unavailable) is determined by finding the transaction each day.

• The revenue days column is based on the number of charged days per contract. See "Columns" below for more information on the calculation. The number of revenue days is used to calculate the utilization.

• Unlike the Location Performance Report, the revenue and T&M columns are not based on the report date. The revenue is spread across the rental period, similar to revenue days. This provides a better revenue figure for long-term rentals where the revenue would not otherwise be factored in until the contract closed.

Columns

Day – Day of the month.

Rev Days – Each day a vehicle is on rent, a revenue day is added. If a vehicle is rented from the 5th to the 7th (two rental days), one revenue day is added to the 5th and 6th.

Units In Flt – The total number of units available. This includes any unit that is not out of service or unavailable. The status types Prep'd, Non prep'd, and On Rent are used in this column.

Units O/S – The total number of units that are out of service. The status type Out of Service is used in this column.

Units Unavl – The total number of units that are unavailable. The status Unavailable is used in this column.

Days Avail – The total number of units that are in-fleet. This column is the addition of the Units Avail and Units O/S columns.

%Util Today – Fleet utilization for the day. This column is calculated by dividing the Rev Days by the Days Avail.

T&M – The net time & mileage charges for the day. This includes time charges, mileage charges, and the T&M discounts are subtracted out.

Revenue – The total revenue charges for the day. This includes net T&M and any miscellaneous charges that were selected.

T&M Dly Avg – The average time & mileage revenue per rental day. This is calculated by dividing the T&M by Rev Days.

Revenue Dly Avg – The average revenue per rental day. This is calculated by dividing the Revenue by Rev Days.

Fleet Cost – The cost of the vehicle fleet. This is calculated by adding up the depreciation for each vehicle in the fleet. If a vehicle is depreciated monthly, its monthly amount is multiplied times 12, then divided by 365 to get an average daily depreciation.

Daily Gr Profit – The daily gross profit. It is calculated by taking the Revenue and subtracting the Fleet Cost.