Customer Special Pricing can save you Profit Points, Costly mistakes and Embarrassing errors. Once you have set your customer pricing, you can rest assure that every invoice goes out with the optimised profit and correct pricing. Pricing can be based on Product Groups, Subgroups, Qty, Start finish dates and more. Individual customers can be priced as a head office account and still have their very own special pricing overrides for those products unique to their buying patterns.
Customer Special Pricing – Overview
Peach Software has many ways to achieve the most flexible pricing for each customer or group of customers.
Notable methods include but lot limited too: Markup (% on Cost) Price Level (Discount off List) Net (Set price per product)
The various ways that these methods are applied can be attached to keys such as the Product Part, Group, Sub Group, Supplier, Category, Qty, Date Range and so on. Although there are so many systems out there with many variations there have not been many times where we have not been able to Mimic and simplify existing methods when converting other software systems to Peach Software.
Product Costs
Just like all accounting software Peach uses the average cost of products to calculate profit. However you will notice that there are 3 cost on each product. (Non Importers) Current Cost, Last Cost & Average Cost. (For importers the Current cost is replaced with the FOB Cost in the foreign Currency).
Current Cost..
Your Standard purchase price from your preferred supplier. This is a seperate cost which should only change if your normal supplier (Preffered Supplier) changes your buy price on this product. This is the most stable price and normally used when creating a selling price based on cost plus. Current Cost is expressed in the software as X. If I wanted to give a customer a 50% Markup on a particular product or product Group etc I would give X50.
Last Cost..
The Last Cost records the last price you purchased the product for regardless of the supplier and how many you already had in stock and at what price. This price fluctuates most and would only be used when creating a selling price based on cost plus for a trade client where your margins are very small as any fluctuation in cost could create a loss. Last Cost is expressed in the software as L. If I wanted to give a customer a 50% Markup on a particular product or product Group etc I would give L50.
Average Cost..
Average cost is what is used to calculate your profit. It's what you have paid in total for the current stock divided by the Qty. So if you Buy 10 for $10.00 and then purchase another 10 for $15.00. Now you have 20 in stock @ a total of $25.00. The average cost is now $25.00/20 = $1.25. Each time you purchase more stock, the Current Total Value is added to the new Total Value and then divided by the new Qty. Average Cost is expressed in the software as V. If I wanted to give a customer a 50% Markup on a particular product or product Group etc I would give V50.
FOB Cost..
FOB Stands for Freight On Board. This is a term used by importers. FOB is the cost of goods from overseas in the foreign currency before shipping, insurance and handling costs. There are possible variations, but this is the general understanding. This cost appears in the Goods Import Screen and used together with the exchange rate to calculated the Landed or FIS cost based on all other charges involved in the Shipping. This cost is not used to generate selling prices.
Customer Special Pricing starts with the Price Level setting. If all other rules don’t give a result then the price given relies on this Setting. IN the example below the Customer is set to Price Level C so if Acme Hardware should buy a Z9 Oil Filter they will be charged $6.05 unless there are further pricing rules for this Customers profile…
Quick Introduction
And Now for some New Features !!
This is the Heart of a Customer special pricing.
Most of our clients would use this section to achieve a highly customized, automated pricing solution. The example below would mean Customer 006 “ACME Hardware Supplies” get’s the following pricing outcome
Line 1 Product MT001 is sold for $1.80 all day every day.
Line 2 RAGS5KG is sold for for 12.00 from 1st to 20th March 2017
Line 3 Product Z9 is sold for $5.00 if they buy 20pcs, and the invoice will display the Part Number as W1200
Line 4 All Products in Group HM and Subgroup 002 are sold for Price C less 12%
Line 5 All Products in Group HM and Subgroup 001 are Marked up by 32% on Current cost (Standard buy price from Preferred Supplier)
Line 6 All Products in Group HM are sold for Price C less 8% unless they are in Subgroup 002 (see line 2 above)
Customer Special Pricing allows each customer to have their own price settings via the Price Level or the Matrix, you can also create a Fake Customer with pricing rules which may be suitable to all customers in a particular Category, Industry or even buying group and so on. Then you can refer customer to that matrix using the Price As field in customer control. This works together with the other price rules as follows…
Invoice a Z9 to Acme Hardware – The pricing logic does the following…
a. Check the PriceAs Customers matrix to search for a result based on the part number, group or subgroup. If found use that
b. Check this Customers Matrix to search for a result based on the part number, group or subgroup. If found override point A
c. If no result found so far check Customer PriceLevel and use that
d. If Price Level is Blank use Price A
GP% = (Sell – Cost) / Sell
MU% = (Sell – Cost) / Cost
Percentage Price Change can Save you Hours of Work
It can be used to adjust Costs, Selling Prices, Price Levels, Promo or Future Pricing in Bulk, saving you Hours of detailed work. A likely scenario for this would be where you would like to Make your Price Level for Trade Customers = Cost + 30% for Group “BRAKES” and Subgroup “PADS” from Supplier “ACME” Check out the video below…
Simplify Customer Pricing – A quick Refresher about Qty Pricing
One of the more common reasons companies look for new Software is Customer Pricing structures. It can be a very complex to set up, and so important to get right. Nothing annoys customers more than getting an invoice with the wrong pricing. From your end its important that it offers the flexibility to be able to price entire Product and Customers Groups but also be able to override these for special Deals. Another scenario we get is that you may have a group of customers who get a group price agreement but be able to still provide a customer unique override for special purchases or uses.
Importing price information is a Simple and Fast way to setup or maintain your price Automation
Importing information directly from an XLXS spreadsheet is versatile simple and fast. In Peach Software It is also interactive givong you a preview of your data prior to committing. The Xls Import feature can show matching lines where data has changed, Data which is too large for the destination cell and new data being appended. Once your happy you can update existing fields or just add the new ones. You can also choose to do both. Check it out