Item Utilization Report

 

The Item Utilization Report shows the ROI, times out, and hours out for each item for the current month and the current year.  In addition, it also shows the utilization percentage for each item.  This report would be helpful to determine whether to buy more of a certain item.  If you had ten trailers and you were thinking about buying more, you could look at the utilization percentage to see how well the current ten are being rented.  If they had a low utilization maybe it wouldn't be a good candidate for more.  The best rental items will have a high utilization as well as a high ROI percentage.  There are four possibilities between Utilization % and ROI %.  The following is a general listing of the four and the possible scenarios for them.  Note that you must account for seasonal differences and other differences that occur in the real world.

Low Util - Low ROI: This is a bad item.  Decrease the quantity and increase the price.

Low Util - High ROI: Good money-making item, but maybe you have too many on hand.  Decrease the quantity.

High Util - Low ROI: This is a good renting item, but you aren't making any money on it.  Raise the price.

High Util - High ROI: Good money-making item and a good renting item.  You might consider buying more of this item otherwise it is perfect.

 

First you will see the following menu:

 

 

Category – this button allows you to select only a certain item category to be reported.

 

Date – select the month and year as the base month for the report.

 

Sort – the report is sorted by item category.  Within each category, you can choose whether it is sorted by item key, name, or number.  If you have Print Summary checked, then the sort options will not make any difference.

 

Select Printer – this button defines the printer that the report will print to.

 

Cancel – this button will cancel your previous selections and return you to the Program Menu.

 

Generate – this button will generate the report and display the report on your screen.

 

The report will look like this sample report:

 

 

The following descriptions define the information that is given on the report:

 

ROI - The return-on-investment will be printed as the ratio of income to purchase price.  For example, if the income is $150 and the purchase price is $100 the ROI would be 150.  If the purchase price is not specified in the item record, the ROI will be shown as “0”. 

Times - For rental items, the number of times rented.  For sales items, the quantity sold.