Managing Tiered Rates

Follow

Table of Contents

Adding Tiered Rates

Adding Thresholds

Adding More Thresholds

Removing Thresholds

Editing Tiered Rates

Deleting Tiered Rates

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.png 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 Ratesopen 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:

T1g.png

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.png 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.png 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.

T1i.png

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.png 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.

T1j.png

If you turn the Running Total toggle switch ON, new fields appear below:

T1k.png

  • 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.

T1k1.png

  • 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.

T1k2.png

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.png 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.

T1l.png

Step 2: An Add Threshold popup appears. Enter the number of the first tier in the space provided.

T1m.png

You can also hover over the field and click on the up and down arrows to reach the correct number.

 T1n.png

Step 3: Click Apply.

Info.png 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.

T1o.png

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.

T1p.png

Adding More Thresholds

To add more thresholds, click + New Threshold and repeat steps 1-3.

T1q.png

Removing Thresholds

To remove a threshold, click the Remove icon ( Delete_green.png ) next to the threshold.

T1r.png

You cannot edit  thresholds. If you need to change a threshold, remove the threshold and add it again. Click the Remove icon ( Delete_green.png ) 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:

T1r.png

Add an updated threshold:

T1s.png

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.

T1t.png

To save this Tiered Rate, click Save & Exit.

T1u.png

  • 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 ( Delete.png ) under the Tiered Rate you want to delete.

Step 3: Click Confirm.

T2e.png

  • The Tiered Rate is deleted.
  • A confirmation message appears.

Warning.png Please Note: If you try to delete a Tiered Rate that a Payment or Receivable Schedule currently uses, you receive the following message:

T2g.png

To delete the Tiered Rate, remove it from the Payment and Receivable Schedule(s) using it, and then repeat steps 1-3.

1 out of 1 found this helpful

Comments

2 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”.

    0
    Comment actions Permalink
  • Thanks, Alan!

    0
    Comment actions Permalink

Please sign in to leave a comment.