Coop Discount Agreements

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

The set up of the Coop Advertising Agreement is most likely the same as the Volume Rebate Agreement. However, the purpose of this agreement is different.

Just like the Volume Rebate Agreement, the percentage (%) of the rebate will be directly influenced by the volume of purchases. However, the goal reaches by the Vendor by signing a Coop Advertising Agreement, will be to give to the Company an additional revenue to promote his products.

Once a Coop Advertising 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.

The journal entry done when a Coop Advertising rebate is earn will not hit the same GL account as the one from the Volume Rebate Agreement or Periodic Rebate Agreement.

When a rebate is earned from a Volume Rebate Agreement or Periodic Rebate Agreement - if the rebate is not applied 100% against the cost of the product, the revenue will usually be posted against an account such as Rebate Earned.

When a rebate is earned from a Coop Advertising Agreement - if the rebate is not applied 100% against the cost of the product, the revenue will usually be posted against an account such as  Publicity/ Advertising.

If any modifications are made to an existing Coop Advertising 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 Coop Advertising Agreement.

Creation of a Coop Advertising Agreement

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

The Coop Advertising 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 Coop Advertising 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 Coop 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 Coop rebate applied on this product will be 2.5%.

To set up a Coop Advertising 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 Coop Advertising 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 Coop Rebate, the system will always take in consideration the most precise level in term of Product Category. Therefore, if a Coop 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 Coop Rebate for a Group of Products.

If a Coop 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 Coop Advertising 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 Coop 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 Coop 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 Coop 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 Coop Rebate can be given by purchases level. i.e: If the purchases are between 0$ and 30K$ - the Coop rebate will be 2%. If the purchases are between 30,001$ and 50K$ - the Coop rebate will be 3%. If the purchases are 50,001$ and over - the Coop rebate will be 3.5%.

This is from this field that we define the maximum amount of purchases that is eligible to each specific Coop 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 Coop Advertising 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 Coop Advertising Agreement. The system will calculate a Coop 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 Coop Rebate on each transaction.

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

•          SC: If selected - the Agreement specified that the Coop 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 Coop Rebate;

•CD: If selected - the Agreement specified that the Company should automatically deducted the amount of the cumulated Coop 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 Coop Rebate will be a summed of all level of rebates.

i.e: Company X has signed a Coop Advertising Agreement with Vendor Y. If the Company buys over 40K$ product (all categories included) from this Vendor, the Coop 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 Coop 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 Coop Rebates will be 4.913%.

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

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

Retro: The Coop Rebate Agreement includes a notion of retroactive payment. A retroactive Coop 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 Coop Advertising Agreement signed with his vendor Y. The Coop Advertising 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 coop rebate of 2% will be given by the vendor;

          - If the Company buys between 100,001$ and above, a coop rebate 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 Coop rebate will be calculated by the system as follow:

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

-Once, the total volume of purchases in respect with the specifications of this agreement reaches 50,001$, the system will start calculating a Coop 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 Coop Rebate will never be applied against the cost of the product. Since the Retroactive Coop Rebate is usually a big amount, the impact would be too important on the cost of the product.

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

Rebate receivable (DR) @ Advertising (CR)

Result: The field will populate automatically by the System and should represent the total Coop 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 Coop 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 Coop 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 Coop 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;

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

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 Coop 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 Coop Rebate on the cost of the Product. Since the Retroactive Coop Rebate is usually a big amount, applying the Retroactive Volume Rebate would have a very big impact on the cost of the product.