Download User Manual - Rental Tracker

Average Quantity Owned - This is the average quantity owned within the date range specified. The
reason why it is average is items could have been purchase mid-way in the date range, an item could have
been retired mid-way.
Replacement Cost - This is the unit cost of the equipment item. The cost is the current market
Replacement Cost which comes from the Equipment table.
Extended Replacement Cost - This is the Qty Owned multiplied by the Replacement Cost.
Rental Days Available – This is the number of rental days the average quantity owned was available
during the date range.
Total Days Checked Out – This is the total number of calendar days items were checked out during
the date range.
Quantity * Weeks Billed - If the invoice was created within the date range specified then the
calculation is at the Invoice Rental detail level. It is the days billed divided by 7. There is no prorating.
If the report is being run for the month of January and the invoice was billed in January then the Invoice
Rental detail level is included. The Invoice Rental level detail could be for several months. All months
would then be included in the weeks billed.
List Price Per Unit – This is the unit replace price from the equipment table. This is the price which
would be charged to a client if the item is lost.
Total Revenue – If the invoice was created within the date range specified then the Invoice Rental
detail level is calculated. This is the extended amount for the line item. There is no prorating. If the
report is being run for the month of January and the invoice was billed in January then the Invoice Rental
detail level is included. The Invoice Rental level detail could be for several months. All months would
then be included in the revenue billed.
Blended Day Rate – Since there can be different day rates charged to customers a blended day rate is
calculated. This is the Total Revenue / Quantity Weeks Billed * the List Price
Maintenance Cost – If there is a repair ticket in the date range specified and repair cost is entered in
for the equipment the equipment is be calculated on the report.
Net Revenue – This is the Revenue – the Maintenance Cost
Utilization % = Days Rented / Days Owned – Days in Repair.
Rental Inventory Statistics Summary
This report will breakout the
revenue generated by production
and equipment code for a date
range.
There are 3 different reports.
By Production – This will pull data from the invoice level. If the invoice or credit creation date is
within the date range specified then it is included in the report. The data will be gathered from the
invoice rental detail level. The report separates out the report by production and breaks out by equipment
code.
By Equipment & Production - This will pull data from the invoice level. If the invoice or credit
creation date is within the date range specified then it is included in the report. The data will be gathered
from the invoice rental detail level. This report separates out by Equipment code and breaks out by each
production.
By Equipment & Order# - This report is an estimate of revenue. It does not pull from billing. It pulls
from the rental order entry level. If the usage begin date on the order header is within the date range
specified then it is included in the report. This report separates out by Equipment code and breaks out
each order.
261
Reports | © 2012 Rental Tracker, Inc.