Outline

The AOL price list has two tabs, where it covers sell-thrus and sell-ins specific to AOL for F&P products on one tab and similar information for Haier products on the other tab.

The Winnings price list has two tabs, where it covers sell-thrus and sell-ins specific to Winnings for F&P products on one tab and similar information for Haier products on the other tab.

All of the tabs contain the purchase prices and RRPs for the products. Some of the products are under parts or commercial vendors on NAV - we handle these separately.

Often, F&P will also send pricing for their Agency models. This is handled like a normal pricelist from any proforma vendor.

Important things to watch out for

• Because sell-ins apply to all business units that fall under a vendor, sometimes we have to convert some sell-ins to sell-thrus to allow for this on NAV. This only affects F&P products (and hasn't been necessary since Q4 2024).

• Not all sell-thrus cover all items, nor do all sell-ins. This goes for the Haier page as well.

• Not all sell-thrus or sell-ins necessarily end at the same time or start at the same time, so this needs to always be checked before loading anything.

• F&P give different rebate amounts for AOL and Winning Appliances, even though they’re the same product under the same vendor card. This is the reason there is a “Winnings” Tab and an “AOL” tab. The Haier tabs are typically identical, but treat them as though they are different to ensure accuracy.

• Haier's pricing and rebates are loaded under their card.

• Never change the price of the F&P Parts or Commercial items based on the price list.

Layout and Rebate Composition

F&P

For all tabs, we’re only concerned with the rebates after “QTRL INVOICE PRICE (ex GST)”. This column also gives us the invoice price (purchase price) we will load into NAV.

Disregard the “INVOICE PRICE (ex GST)” column, it's not pertinent to us.

RRP (inc GST) is located before the “QTRL INVOICE PRICE (ex GST)”.

“REBATE” and “TARGET” are both Sell-In rebates. Both of these are comprised of 2 rebates each. 

“REBATE” is made up of the TDA rebate which is 2.2% and the Base Rebate which is 16.5%.

“TARGET is made up of the ROLLING TARGET which is 2.25% and FPTARGETINCENT which is 2%. 

Table below for visual reference:

Haier

Haier has basically the same layout with the same logic as above and also has two sell-ins comprised of two sell-ins each.

“REBATE” is comprised of Rebate which is 18% and TDA which is 2.2%. 

“TARGET” is comprised of FPTARGETINCENT which is 2% and ROLLING TARGET which is 2.25%. 

Table below for visual reference:

How to Action the Request

Creating the file - Naming

Create a new google sheet workbook.

Name it “Workbook for FnP MONTH YY” so for November it would be called “Workbook for FnP November 23”

Next, download Item Pricing Information from NAV for 000022 and import this to the same sheet as Insert New Sheet(s).

Then download Item Pricing Information from NAV for 000470 and import this to the same sheet as Insert New Sheet(s).

Name these accordingly so you have them for reference in your formulas. I would also recommend colour coding the tabs you add to the document to distinguish them from the 4 tabs sent by FnP:

Creating the file - Rebates

For the time being, this section can be skipped.

The deal numbers are standardised for easy reference. They’re composed accordingly: FNPMON2Y. So January 2024 deal number will be FNPJAN24 and December’s is FNPDEC23.

Sell-Thrus

Go to the sell-thrus page on NAV and search for the previous month’s deal number - in our example we’re doing November’s price list so the previous month will be FNPOCT23. 

For this part you can leave out the category rebates and focus only on the item rebates.

Add the filter for 000022 and subdivision 20 with Ending Date greater than 01/01/2024. Download and import this data to the sheet as Insert New Sheet(s) and name it FNP OCT WA NAV Rebates (or whatever month you’re dealing with). 

Add the filter for 000022 and subdivision 12 with Ending Date greater than 01/01/2024. Download and import this data to the sheet as Insert New Sheet(s) and name it FNP OCT AOL NAV Rebates (or whatever month you’re dealing with).

Add the filter for 000470 - no subdivision filter with Ending Date greater than 01/01/2024. Download and import this data to the sheet as Insert New Sheet(s) and name it Haier OCT NAV Rebates (or whatever month you’re dealing with).

IMPORTANT FOR SELL THRUS

1. Always double-check that the only time Subdivision 20 is ticked is for Winnings Exclusive Models.

2. Always double check that 12 is ticked when you upload sell thrus that cover AOL as these aren’t always automatically ticked.

Sell-Ins

For the time being, this section can be skipped.

Go to the Vendors tab and select Rebates:

Using the filters, look for the FNPOCT23 rebate where the Line Rebate % is 0 under 000022. Download and import this  as Insert New Sheet(s) and name it FnP Credit Note NAV Sell in.

Next, look for the FNPOCT23 rebate where the Line Rebate % is 0 under 000470. Download and import this as Insert New Sheet(s) and name it Haier Credit Note NAV Sell in. 

Creating the file - Action Sheet

Create a tab called Action Sheet.

This will be the main page you’ll be using to monitor your tasks and ensure each step is completed.

Paste the linked Action Sheet Template into your Action Sheet tab - this also contains important tips for each action. Note that there are columns hidden on it for ease of reading so make sure “Status” and “Comment” are visibile when you have the table pasted. 

Action List Completed

Email Richard, ensuring Jake, Freni and Manaia are on CC to confirm this has been loaded to NAV.

Add the details to the supplier maintenance sheet.