Reports Menu -> Automatic Reporting -> Function RSPF119 -> runs Rental Age Report Export
This fleet age report applies only to rental equipment, and is
always output in spreadsheet format.
All exported values are based on the last "snapshot" captured from
the Rental Age Report Capture utility, which
also determines whether the spreadsheet will be generated for a
selected Period, or whether the output is a Rolling 13 Month
spreadsheet.
Whether using Automatic Reporting to
run the Rental Age Export or running the export manually, the
last capture is always used for the export report, whether
the capture was generated manually or by the job scheduler.
Refer to Rental Age Report Capture for more
details on using the automated feature.
The input parameter definitions include:
Note: If none of the Reporting Set, Class, or Group filters were used in the capture, the 'Period' spreadsheet will be generated in product detail with no sort.
Select Detail to list each product individually on the spreadsheet, sorted by the filter selection of Reporting Set, Class, Group or none.
Check this box to view and select the columns in the Select Columns to Export window that should be
displayed in the spreadsheet output for this report run.
Uncheck this box to generate the spreadsheet including all columns
available for this report.
Rolling 13 Month:
The KPI option also exports the monthly totals for the 13 month period, but provides a breakdown of various KPI revenue.
Resulting Spreadsheet Output:
The columns on the resulting spreadsheet can be explained as
follows:
COLUMN COMMENT DESCRIPTION : Current Product Description, not based on the capture. QTY : Quantity On-Hand with "Ratio" applied VENDOR : Current Product Vendor, not based on the capture. VENDOR PRD# : Current Vendor Product Number, not based on the capture. ACQ DATE : Non-Bulk Rentals only based on Acquired Date on Asset Tag ADJ 1ST COST : Products Adjusted First Cost value ADD PER TAG : Non-Bulk Rentals only based on Additions on Asset Tag SERVICE : Sum of Repair Transactions (WRPH) BOOK VALUE : Sum of Book Values on Asset Tags LIQ VALUE : QTY column * Group defined Liquidation Value Note: If status is 'D' then 'Liquidation Value' will be zero VAR TO NBV : 'Liquidation Value' column - 'Book Value' column TOT ORIG COST : - NON-BULK: Sum of Asset Tags Original Cost - BULK : Adjusted First Cost REVENUE : Using "Monthly History": Sum of Revenue Dollars based on (RSMH) Using "Utilization capture": Sum of Dollar Utilization DOLLAR UTE% : Based on Cost Type report selection filter of "Adjusted" Or "Original" ADJUSTED = Revenue / First Cost * 100 ORIGINAL = Revenue / Replacement * 100 "RATIO" also applied where RATIO = Days item is in stock in Period / Total Days in Reporting Period Note: This percent column is displayed as a decimal of 100, so the value can be easily used in a formula, but if the spreadsheet is reformatted the values in this column will display as percents. PERIOD $ UTE% : Revenue / (Cost X Average Quantity) - where the "Average Quantity" is the product quantity adjusted for the portion of time it has been active for the capture period. e.g. If the product became active after the "from date" or was disposed before the "to date", then the "Average Quantity" will be reduced accordingly. Note: This percent column is displayed as a decimal of 100, so the value can be easily used in a formula, but if the spreadsheet is reformatted the values in this column will display as percents. TAG STAT/DATE : Non-Bulk Rentals only based on Status in Asset Tag & if status is 'D' then Disposal date is exported TOT DAYS RENT : Using "Monthly History": Sum of (Monthly History Rental Hours / Calendar Hrs in Day) Using "Utilization capture": Total Rental Days from Utilization capture TIME UTE % : (Rental Days / (Qty * 100) * 100) / Days in Reporting Period AVG DAYS PER RENT : Days Rent / Number Of Rentals, where 'NUMBER OF RENTALS'= Sum of Sales History Qty based on Contract Note: If a contract is invoiced more than once then the system will only include the initial sales history record. AVG AGE : NORMAL CALC: (To Date - Date Acquired) / (365/12) IF DISPOSED : (Disposal Date - Date Acquired) / (365/12) USEFUL MONTH : Group defined Useful Life Months USEFUL HOURS : Group defined Useful Life Hours # OF RENTS : Number of Rentals based on Sales History (where a contract is only counted once) Refer to 'AVG DAYS/RENT' above OEC UTE% : ('OEC Rented' / 'OEC Value') * 100 Note: This percent column is displayed as a decimal of 100, so the value can be easily used in a formula ,but if the spreadsheet is reformatted the values in this column will display as percents. OEC RENTED : (Days Rented / [Days in Reporting Period * Qty] ) * Item Cost OEC VALUE : 'Owned Equipment Cost' = Qty * Item Cost Note: The report selection Cost Type determines whether Item Cost is 'First Adjusted Cost' or 'Average Cost'. Values are calculated based on average of the capture records for the period, or if no capture records are available for the period the product files values are used. LEASING VENDOR: Vendor number assigned in the Lease Information window of the Rental Inventory, on product detail output only. CURRENT METER READING: Non-Bulk Rental meter units for metered products. FAIR MARKET VALUE: FMV for Non-Bulk Rentals from the Appraisal Values ORDERLY LIQUIDATION VALUE: OLV for Non-Bulk Rentals from the Appraisal Values FORCED LIQUIDATION VALUE: FLV for Non-Bulk Rentals from the Appraisal Values
Definitions for columns on the KPI spreadsheet include:
QUANTITY :QUANTITY from 13 month report ORIGINAL EQUIPMENT COST (OEC) :ADJUSTED FIRST COST from 13 month report EQUIPMENT ACQUISITION COST (EAC):TOTAL ORIGINAL COST from 13 month report BOOK VALUE :BOOK VALUE from 13 month report RENTAL REVENUE :REVENUE from 13 month report SERVICE REVENUE :Total invoice selected services for given month (new capture) TOTAL REVENUE :RENTAL REVENUE + SERVICE REVENUE OEC RENTED :OEC RENTED from 13 month report using cost type "Adjusted First" [ORIGINAL EQUIPMENT COST (OEC)] EAC RENTED :OEC RENTED from 13 month report using cost type "Total Original" [EQUIPMENT ACQUISITION COST (EAC)] $ UTE ON OEC :ANNUALIZED RAW RENTAL REVENUE = ANNUALIZED DOLLAR UTE % from 13 month report using cost type "Adjusted First" and using RENTAL REVENUE $ UTE ON OEC :ANNUALIZED GROSS RENTAL REVENUE = as above except using TOTAL REVENUE $ UTE ON EAC :ANNUALIZED RAW RENTAL REVENUE = ANNUALIZED DOLLAR UTE % from 13 month report using cost type "Total Original" and using RENTAL REVENUE $ UTE ON EAC :ANNUALIZED GROSS RENTAL REVENUE = as above except using TOTAL REVENUE FINANCIAL UTE ON EAC :EAC RENTED / EQUIPMENT ACQUISITION COST FINANCIAL UTE ON OEC :OEC RENTED / ORIGINAL EQUIPMENT COST ANNUALIZED TIME UTE % (PHYSICAL):TIME UTE % (PHYSICAL) from 13 month report AVERAGE AGE (FORECAST) OEC :AVERAGE AGE (FORECAST) from 13 month report using cost type "Adjusted First" AVERAGE AGE (FORECAST) EAC :AVERAGE AGE (FORECAST) from 13 month report using cost type "Total Original"
ACTIONS:
Additional actions provided by buttons on
the Rental Age Report Export screen include:
Converted from CHM to HTML with chm2web Pro 2.85 (unicode) |