Volume Rebate Agreements

From this Maintenance, the user will be able to set up any Volume Rebate Agreement the company has signed with a specific Vendor.

In a Volume Rebate Agreement, the percentage (%) of the rebate will be directly influenced by the volume of purchases.

These kind of agreements will be signed between two parties to build customer loyalty.

Once a Volume Rebate Agreement is set up by the user in the following Maintenance, the rebate will not show on the face of the invoice. However, the system will calculate and estimate the rebate to be received based on everything that was set up, and an automated journal entry will be record. The user will also be able to run a report that will display the estimated Volume Rebate earned for each vendor.

The journal entry will be generate by the system only once the item is received in the Receiving Slips Entry. The system will generate a journal entry and post it to the General Ledger accounts set up in the GL Reference Menu.

If any modifications are made to an existing Volume Rebate Agreement - all changes are saved and can be visualize on the History tab of the Maintenance. This tab will show the user the whole list of changes, which field was changed, and the change was made by which user on what date/time. Therefore, it is easy to keep track of any changes done on a Volume Rebate Agreement.

Creation of a Volume Rebate Agreement

The first step to generate a new Volume Rebate Agreement will be to select the Vendor.

The Volume Rebate Agreement can be created by Group of items, or for a specific product depending on the type of Agreement signed.

i.e : Company X has a Volume Rebate Agreement with his vendor Y for any Gypsum products. If the Company orders for over 25K$ of any Gypsum product from this vendor, the Company will receive a volume rebate of 2% for each additional purchases of Gypsum.

However, if the Company orders specifically a Gypsum 1/2 X 4 X for over 10K$  from this vendor, the Volume rebate applied on this product will be 2.5%.

To set up a Volume Agreement for a Group of Product - the user will need to do the set up in the first part of the Maintenance:

To set up a Volume Agreement for a specific Product - the user will need to do the set up in the second part of the Maintenance:

During the calculation of the Volume Rebate, the system will always take in consideration the most precise level in term of Product Category. Therefore, if a Volume Rebate is set up for a specific item - the system will look at the Rebate set up on this item first while calculating the rebate applicable, even if the item is included in a Volume Rebate for a Group of Products.

If a Volume Rebate is set up as well on different level of Group Item - the system will consider first the rebate set up for a CAT 4, then CAT 3, CAT 2 and finally CAT 1.

Setting up a Volume Rebate for a Group of Product

To add a new Volume Agreement for a Group of Product, the user need to press the Add Bottom of the first part of the Maintenance.

Cat 1 to 4: From these fields, the user will define all category of items that are eligible to the Volume Rebate. The 4 levels of Categories are defined as follow:

                    Category 1: Major;

                    Category 2: Intermediate;

                    Category 3: Minor;

                    Category 4: Double Minor.

As explained above, the Volume Rebate will always be applied first to the most precise category (CAT 4), to the most global category (CAT 1).

By pressing F2 with the cursor positioned on One of the category - the system will default the Volume Rebate applicable to all Category created in the system.

To learn more about the definition of these 4 levels of Group Items, please refer to the Inventory Maintenance.

Maximum Amount: The Volume Rebate can be given by purchases level. i.e: If the purchases are between 0$ and 30K$ - the Volume rebate will be 2%. If the purchases are between 30,001$ and 50K$ - the Volume rebate will be 3%. If the purchases are 50,001$ and over - the Volume rebate will be 3.5%.

This is from this field that we define the maximum amount of purchases that is eligible to each specific volume rebates.

If the maximum level is unlimited, by pressing F2 with the cursor positioned in the Maximum Amount field - the system will default that field to 999,999,999 which is unlimited.

Start Date: This date should match with the Starting date of the Volume Rebate Agreement. The system will start to calculate a Volume Rebate on any Item purchase and receive included in the agreement as of this date.

End Date: This date should match as well with the Ending date of the Volume Rebate Agreement. The system will calculate a Volume Rebate on any item purchase and receive included in the agreement until the date specified over here. Therefore, if the Agreement is amended and extended, it is really important that the user updates the information from this screen.

Rebate 1 - 2 - 3 - 4: The system allows you to add up to 4 Rebates. The user most enter the percentage (%) of rebate as per the agreement. The system will look to the percentage entered in these fields when it will calculate the Volume Rebate on each transaction.

M: Under that field, the user specified how the Volume Rebate will be payable by the vendor. The options are defined as follow:

•          SC: If selected - the Agreement specified that the Volume Rebate will be pay back by the vendor with a Cheque;

•NC: If selected - the Agreement specified that the vendor will send a credit note to the Company to pay the cumulated Volume Rebate;

•CD: If selected - the Agreement specified that the Company should automatically deducted the amount of the cumulated Volume Rebate on the next payment. This one is rarely used since the Company does not need to wait for any consent from the vendor.

Deg: Can be selected only if the agreement included more than one level of rebates. If selected, the system will calculate the overall rebates entered under the Reb 1 to Reb 4 fields on a degressive basis. If this option is not selected, and the agreement included more than one level of rebates, the Volume Rebate will be a summed of all level of rebates.

i.e: Company X has signed a Volume Rebates Agreement with Vendor Y. If the Company buys over 40K$ product (all categories included) from this Vendor, the Volume Rebates should be calculated as follow: 1) 2%; 2) 1.5%; 3) 1%; 4) 0.5%.

If the Degressive options is selected and if the Company buys over 40K$ to this vendor, the system will calculate the volume rebate following this equation for each additional dollars of purchase: (1 x 0.02) + ((1 - 0.02) x 0.015) + ((1 - 0.02 - 0.015) x 0.01) + (1 - 0.02 - 0.015 - 0.01) x 0.005).

The overall all Volume Rebates will be 4.913%.

On the opposite side, if the Degressive option is not selected, the system will calculate the volume rebate using the following equation: 0.02 + 0.015 + 0.01 + 0.005.

The overall Volume Rebates will be higher and equals 5 %.

Retro: The Volume Rebate Agreement includes a notion of retroactive payment. A retroactive volume rebate can be given by the vendor once the Company reaches a certain level of purchase. The vendor will not give any rebates, or will give a lower percentage (%) of rebated on the first level of purchases - then if the Company reaches a certain dollars value of purchases, the rebates will be calculated on any additional purchases above, and will be calculate retroactively on all previous purchases.

i.e: Company X has a Volume Rebate Agreement signed with his vendor Y. The Volume Rebate Agreement his signed with the following criteria:

          - No Rebate will be given on any purchases below 50K$;

          - If the Company buys between 50,001$ and 100K$, a volume rebates of 2% will be given by the vendor;

          - If the Company buys between 100,001$ and above, a volume rebates of 3% will be given by the vendor.

          - As per the agreement, each rebates described above will be calculated retroactively.

Therefore - the Maintenance should be set up as follow by the user:

Therefore, as per this example – the Volume rebate will be calculated by the system as follow:

-For each dollars of purchase below 50K$ - the system will not calculate any volume rebates;

-Once, the total volume of purchases in respect with the specifications of this agreement reaches 50,001$, the system will start calculating a volume rebates of 2% on each dollars of purchase;

-The system will also back calculate a retroactive volume rebate on the first 50K$ of rebate. Therefore, the Retroactive Volume Rebate should be as per this example 50K$ * 2% = 1,000$;

-Please note that even if the user selected to apply a certain percentage on the cost of the product (please review section Product % below to have additional information on this field) – the Retroactive Volume Rebate will never be applied against the cost of the product. Since the Retroactive Volume Rebate is usually a big amount, the impact would be too important on the cost of the product.

-Therefore – when a Retroactive Volume Rebate is calculated by the system, the system will record the following journal entry:

Rebate receivable (DR) @ Rebate Gain (CR)

Result: The field will populate automatically by the System and should represent the total Volume Rebate per agreement based on all Rebate entered under the fields Rebate 1 to 4. The result will also be influenced if the Degressive option is selected or not.

Product %: This field gives the option to apply the Volume Rebate to the cost of the Product. The user is allow to apply the whole rebate, a part of the rebate, or to not apply anything at all.

Depending on the situation, the system will react differently:

•Applying 100% of the Rebates to the cost of the Product: The system will generate a journal entry and post the Volume Rebates as receivable from the vendor, and the offset will be post as a diminution of the Inventory cost;

•Applying partially the Rebates to the cost of the Product: The system will generate a journal entry, Post the Volume Rebates as receivable from the vendor, a part of the offset will be post as a diminution of the Inventory cost, and the remaining part will be post as a gain in the Profit or Loss (i.e Rebates earned);

•Not applying the Rebates to the cost of the Product: The system will generate a journal entry, Post the Volume Rebates as receivable from the vendor, and the offset will be completely post as a gain in the Profit or Loss (i.e Rebates earned).

This should be an internal decision taken by the user.

If the user apply 100% or a portion of the rebates against the cost of the product, the customer will partially benefit from this decision, especially if the retail price is calculated from the cost of the product. Since this reduce the cost of the product, the retail price will be impacted as well.

As explained above, if a retroactive Volume Rebate is calculated by the system once a certain level of purchases is achieved, even if the Product % field is checked, the system will never applied the Retroactive Volume Rebate on the cost of the Product. Since the Retroactive Volume Rebate is usually a big amount, applying the Retroactive Volume Rebate would have a very big impact on the cost of the product.

Setting up a Volume Rebate for a Specific Product

To add a new Volume Agreement for a Specific Product, the user need to press the Add Bottom of the second part of the Maintenance.

Product: From this field, the user will select from the item that is eligible to a Volume Rebates. By pressing F1 with the cursor positioned in this field, the system will open the Search Window of the Inventory Maintenance.

The other settings of a Volume Rebate for a Specific Product done exactly the same way as Setting up a Volume Rebate for a Group of Product. The only difference is where the Volume Rebate needs to be set up in this maintenance. Please refer to the section above for more detail regarding each individual field of this Maintenance.

Set up in the Vendor Maintenance

From the vendor Maintenance - the user is able to customize how the Volume Rebate Agreements as well as the Periodic Rebate Agreement will be calculate.

From the left side of the Main tab in the Vendor Maintenance - the user will see the following options:

As per the vendor Agreement - the use will have the ability to calculate each individual rebate in 4 different ways. To understand the impact of each individual option, we will use the following example:

          Company X has an invoice payable to vendor Y. The total of the invoice payable is 100$. Company X has the following agreement with his vendor Y:

                    - Discount Agreement of 10%;

                    - Periodic Rebate Agreement of 5%;

                    - Volume Rebate Agreement of 3%.

1) If none of these boxes are check by the user, all rebates mentioned above will calculate at 100%. Therefore, Company X will have a total of 18% Rebates. When these boxes are not check, the user will gain his rebates to the maximum level;

2) If the user selects Degressive Periodical Rebate, without selecting Degressive Volume Rebate, the Rebates will be calculated as follow:

                    - The Periodic Rebate Agreement will be calculated net from the Discount Agreement. Therefore, following the example above, the Periodic rebate will be 4.50$ {(Total Invoice (-) (Total                     Invoice * Discount Agreement)) * Periodic Rebate Agreement} or {(100 $ (-) (100 $ * 10%)) * 5%} = 4.50$.

                    - The Volume Rebate Agreement will be calculated regardless of the Periodic Rebate Agreement already calculated degressively. Therefore, the total of the Volume Rebate should be                     2.70$ which is calculated as follow: {(Total Invoice (-) (Total Invoice * Discount Agreement)) * Volume Rebate Agreement} r {(100$ (-) (100$ * 10%) * 3%)} = 2.70$.

3) If the user does not select Degressive Periodical Rebate, but select the Degressive Volume Rebate, the Rebates will be calculated as follow:

                    - The Periodic Rebate Agreement will be calculate regardless of the Discount Agreement. Therefore, following the example above, the Periodic Rebate will be 5$ because it will not be 

                    calculated  net from the Discount Agreement. The Periodic Rebate Agreement will be calculated as follow: Total Invoice * Periodic Rebate Agreement or 100$ * 5% = 5$.

                    - The Volume Rebate Agreement will be calculated net from the Periodic Rebate Agreement. Therefore, following the example above, since the Periodic Rebate was calculated                               regardless of the Discount Rebate, the Volume Rebate should be 2.85$ {(Total Invoice - Total Periodic Rebate Agreement) * Volume Rebate Agreement)} or {(100$ - 5$) * 3%} = 2.85$.

4) If the user select both options at the same time (Degressive Periodical Rebate and Degressive Volume Rebate are checked from the Main Tab) - each level of rebate will be calculated as follow:

                    - The Periodic Rebate Agreement will be calculated net from the Discount Agreement. Therefore, following the example above, the Periodic rebate will be 4.50$ {(Total Invoice (-) (Total                     Invoice * Discount Agreement)) * Periodic Rebate Agreement} or {(100 $ (-) (100 $ * 10%)) * 5%} = 4.50$.

                    - The Volume Rebate Agreement will be calculated net from the Discount Agreement and net from the Periodic Rebate Agreement as well. Therefore, following the example above, the                     Volume rebate will be 2.865$ {(Total Invoice (-) (Total Invoice (-) ((Total Invoice* Discount Agreement) * Periodic Rebate Agreement))) * Volume Rebate)} or {(100 $ (-) (100 $ (-) ((100$                     * 10%)) * 5%) * 3%} = 2.865$.

With both Degressive options checked - the rebates will be gain to the lowest level.

As explained above, whenever there is a Periodic Rebate Agreement and a Volume Rebate Agreement signed with the same vendor - the system will always apply and calculate the Periodic Rebate Agreement first then the Volume Rebate Agreement based on everything that was set up in their respective Maintenance and in the Vendor Maintenance as well.