Rental Performance Report
Action: RP_RINVPERF
WinTPS® optional software feature. This report shows how well each rental inventory item is being utilized. It is useful when making decisions about which styles or sizes to purchase, or which styles or sizes to remove from inventory.
Several output options exist for it, it can break the rental inventory down by Style or Size. The ‘by Style’ option can be further limited to a specific Item Type. When the report is ran by Size it can be optionally limited to a specific Style code.
In either case, the report shows the following information for each item listed: Total units available for rental (count from Rental Sizes) The total turns for the item the number of units owned for each style/size as a percentage of the total, the number of turns as a percentage of the total, the turns month to date the turns year to date
Finally, it shows the Fill Qty, which is the (YTD percentage of rentals – percentage of total units) * total rental units for the item. The closer the fill number is to the quantity owned indicates how well the item is performing.
The goals are to have each item's fill quantity equal other items fill quantity indicating level performance across each item AND to have the fill quantity be as close as possible to the units owned for the item. to equal the total unit quantity for the item.
Example: formula: (YTD rental % - % of all units owned) * # units owned for the item (20% - 8%) * 53 = 6.36 ( 1% - 8%) * 53 = 0 (90% - 1%) * 53 = 47.17
Criteria
Filter by Rental Item Type... The report prints all styles for the item type and provides # of units, turns, percentages and FILL qty by style
Print Sizes for Selected Styles... Groups rental inventory by selected Style and all it's sizes providing the same data column as the item type selection..