Auto Selling Price Calculation

This function allows you to have selling prices adjust automatically based on the ROI of the item.

 

For example, a rental item that has an ROI below 150% should sell for the selling price in the rental file. But, an item that has an ROI above 150% but below 175% should sell for the selling price less 10%, and an item between 175% and 200%

should sell for the selling price less 20%.

 

Step 1 – Go to the new “ROI Selling Discount” file, 2-F from the main menu, and set up the table as described above, and

shown below (you can set up as many or as few different ROI levels as you wish):

ROISellingDiscount

 

Step 2 – In the “Selling For” field in the rental file, enter the price that you would normally sell it for before any discounting.

 

Bench Test

Item has a selling price of $17,000. Based on the table example above:

If the ROI on an item is over 150% and less than 175%, selling price will be $17,000 (17000 X 100%)

If the ROI on an item is over 175% and less than 200%, selling price will be $15,300 (17000 X 90%)

If the ROI on an item is over 200% and a multiplier of 80%, selling price will be $13,600 (17000 X 80%)

Note: Multipliers can be set to OVER 100% to increase selling prices.

 

Areas in which this table will affect selling prices:

Item Lookup – Search for an item. Right click on the item and select "Rental Information". The Selling Price field will auto-adjust based on the ROI level and multiplier.

Order Processing – When you sell a rental item on an order (rental order or sales order), the selling price will auto-adjust based on the ROI level and multiplier.