Contents
Tiered Rates are rates which increase or decrease when the unit being measured reaches a certain amount. Tiered Rates can have many “thresholds,” or amounts which trigger the change in the rate. You can create and manage Tiered Rates in Planning Maestro through the Tiered Rates application, which is in the Automation module.
Example: A company’s products might sell for $20/product for the first 100 products a customer buys, $15/product for 101-200 units, and $10/product for any more than 200 units. This Tiered Rate is an incentive to buy in bulk. |
After you add a Tiered Rate to Planning Maestro, you can use that Tiered Rate to set up discounts in Payment Schedules and Receivable Schedules (also located in the Automation module).
This document shows you, a Planning Maestro user, how to add, edit, and delete Tiered Rates.
Locating Tiered Rates
To manage Tiered Rates, open the Automation module and select Tiered Rates.
The Tiered Rates page opens. Use this page to add, edit, and delete Tiered Rates.
Adding Tiered Rates
Step 1: To add a new Tiered Rate, on the Tiered Rates page, click + New Tiered Rate.
A New Tiered Rate pane opens on the right.
Step 2: Enter the following information in the fields provided:
Name – Enter a name that you and other users can easily understand in this field.
Description (Optional) – Enter a description for this Tiered Rate in this field.
Tier Type – Click on this dropdown menu and select one of the following options:
- Volume – Select this option if you want the Tiered Rate to apply to the whole amount at once.
Example: The rate for carbon water filters is $20 per filter for the first 100, $15 per filter for 101-200, and $10 for any more than 200. If a customer orders 230 filters, their rate is $10/filter for the whole order. |
- Step – Select this option if you want the Tiered Rate to progressively apply to each tier of the amount.
Example: The rate for carbon water filters is the tiered rate described above. If a customer orders 230 water filters, their rate is $20/filter for 100 of those filters, $15/filter for the next 100 filters, and $10/filter for the remaining 30 filters. |
Percent Multiplier – To turn this Tiered Rate into a multiplier such as 3% instead of changing the price, click on this toggle switch to turn it to the ON position.
To leave this Tiered Rate as a flat amount that changes the price of each unit purchased, leave this toggle switch in the OFF position.
Running Total – To use a Running Total, click on this toggle switch to turn it to the ON position. A Running Total adds up the total amount for purchases for a certain time period and continues to apply the rate.
Example: A Tiered Rate for boxes of trail mix uses a Running Total set to run for a year. Every time a customer buys more boxes, those boxes are added to the Running Total and priced based on the tier that the whole amount has reached. At the end of the year, the rate resets.
|
If you turn the Running Total toggle switch ON, new fields appear below:
- Time Hierarchy – The structure of your calendar view (often Fiscal Calendar Month).
- Running Total Level – Click on this dropdown menu and select the time period in which orders “add up” for the Tiered Rate before resetting to zero: Year, Quarter of Year, or Period of Year.
- Running Total Length – Click on this dropdown menu to select how many years, quarters, or periods the orders add up before resetting to zero. For example, if you selected Quarter of Year above and want the rate to reset after a year, enter 4 in this field for 4 quarters.
To not use a Running Total so that every purchase of this item has the Tiered Rate applied to it individually, leave the Running Total toggle switch in the OFF position.
Example: Every time a customer purchases boxes of trail mix, that order has the Tiered Rate applied to it individually (no matter how many other orders they have made that period, quarter, or year). |
Adding Thresholds
Thresholds – Use this section to add the thresholds or levels of this Tiered Rate (the amounts which trigger a change in the rate).
Step 1: To add a new threshold, click + New Threshold.
Step 2: An Add Threshold popup appears. Enter the number of the first tier in the space provided.
You can also hover over the field and click on the up and down arrows to reach the correct number.
Step 3: Click Apply.
Please Note: The first threshold is the number at which the rate changes. For example, if the price changes after you buy 100 units of something, enter 101 as the first threshold. |
The first tier appears in the table. Now, the table should have two rows: one from negative infinity to your first tier, and the second from your first tier to infinity.
Adding More Thresholds
To add more thresholds, click + New Threshold and repeat steps 1-3.
Removing Thresholds
To remove a threshold, click the Remove icon ( ) next to the threshold.
You cannot edit thresholds. If you need to change a threshold, remove the threshold and add it again. Click the Remove icon ( ) next to the threshold and then click + New Threshold to add the updated threshold. You cannot edit the From and Up To columns directly in the table.
Remove the threshold:
Add an updated threshold:
After adding your thresholds, enter the price or rate for items within that threshold in the Value column. For example, if carbon water filters are $20 up to the first 101, enter 20 in the Value column.
To save this Tiered Rate, click Save & Exit.
- A confirmation message appears.
- The Tiered Rate is saved. You can use this Tiered Rate to add discounts to Payment and Receivable Schedules.
Editing Tiered Rates
Step 1: To open the Tiered Rates application, see above.
Step 2: Select the name of the Tiered Rate you want to edit.
Step 3: The Tiered Rate’s information opens on the right. Edit as needed and click Save & Exit.
- Your changes are saved.
- A confirmation message appears.
Deleting Tiered Rates
Step 1: To open the Tiered Rates application, see above.
Step 2: Click the Delete icon ( ) under the Tiered Rate you want to delete.
Step 3: Click Confirm.
- The Tiered Rate is deleted.
- A confirmation message appears.
Please Note: If you try to delete a Tiered Rate that a Payment or Receivable Schedule currently uses, you receive the following message: |
To delete the Tiered Rate, remove it from the Payment and Receivable Schedule(s) using it, and then repeat steps 1-3.
Comments
Another good guide with great detail and clarity, good diction and a step-by-step display of the actual relevant user interface.
There are a few minor edits needed:
1) First Example: The use of the word Cost may be confusing since in Revenue records we use the term Cost to identify all costs associated with the record. I would probably say: “A company’s products might sell for $20…”
Additionally, “201 units” should be changed to “200 units” since the tier break occurs at the 201st unit (more than 200).
2) Second Example: “201” should be changed to “200” (same reason as #1 above).
3) Third Example: “101” should be “100” and “29” should be “30”.
Thanks, Alan!
Please sign in to leave a comment.