CCM, LLC

Superior Insight and Innovation

Sample Reports
 
Below are sample reports.  Many more are available or can be created to suit your needs.

 

INVENTORY PERFORMANCE ANALYSIS :

 

Rental Fleet Inventory Performance Analysis including Acquisition Cost, Book Value, 4-Week Rental Rate, Total Days Rented, Maintenance, Expense, Income and Gross Profit.  Additional calculations include Adjusted Gross Profit, Maintenance to Income Percent, Expense to Income Percent, and Time Utilization Percent.  Results are e-mailed as an Excel spreadsheet.


 

EQUIPMENT RENTAL CONVERSION INFORMATION :

 

Provides Summary Information for Individual Equipment including Acquisition Cost, Paid Rental, Depreciations, Interest, Warranty and Repair/Maintenance. Each repair/maintenance work order (including open work orders) is listed. If Transportation is charged on Parts Documents via Dispatch Solutions, these documents are also listed.  This information can be used separately or in conjunction with DSPEMAGC (Agreement Conversion Inquiry) in DBS.  Results displayed on the screen and/or sent to a desired printer.


 

RENTAL FLEET ROLLOUT :

 

Recaps Revenue and Costs to facilitate optimal time to roll equipment out of the Rental Fleet. Includes Asset costs, and cumulative Maintenance, Revenue and Maintenance to Revenue Percent in 01-12, 13-24, 25-36, 37-48, 49-60 and 60+ buckets.  Results are e-mailed as an Excel spreadsheet.


 

WASHOUT REPORTS :

 

INDIVIDUAL EQUIPMENT WASHOUT:

 

Calculates Cash-In and Cash-Out to determine Washout Gross Profit $, Monthly Washout Gross Profit $ and Monthly ROA % for Individual Equipment. Override Sale Price, Monthly ROA % and Override Gross Profit Variables allow for “what-if” calculations.  Results displayed on the screen and/or sent to a desired printer.

 -

IN-INVENTORY FLEET WASHOUT :

-                                          

Calculates Cash-In and Cash-Out to determine Washout Gross Profit $, Monthly Washout Gross Profit $ and Monthly ROA % for In-Inventory Equipment. Monthly ROA % and Override Gross Profit Variables allow for “what-if” calculations.  Results are e-mailed as an Excel spreadsheet.

-

SOLD EQUIPMENT WASHOUT :

-

Calculates Cash-In and Cash-Out to determine Washout Gross Profit $, Monthly Washout Gross Profit $ and Monthly ROA % for Sold Equipment. Results are e-mailed as an Excel spreadsheet.


 

SLOW RENT REPORT :

 

Recaps Rental Fleet equipment Not On Rent for 30+ days.  Lists Model, Age, Days Since Last Rental and Income in 0-12, 13-24 and 25+ month buckets.  Results are e-mailed as an Excel spreadsheet.


 

RENTAL EQUIPMENT COUNT/AGING/UTILIZATION BY MODEL :

 

Recaps Time and Financial Utilization by Model, Average Number of Units in Inventory for the requested date range, Maximum Number of Units Simultaneously On Rent, Number of Days Maximum Number of Units On Rent, Ending Number of Units for the Date Range and the Age of the Ending Units in 0-12, 13-24, 25-36, 37-48, 49-60, 61-72 and 73+ Month Buckets.