Calculating cost prices and margins to achieve your required margins while allowing your customers the best possible discounts.
Max Of Branch Average Or Replacement
Introduction
Costs are calculated by different methods, as set out below. You need to know the cost of an item that you are selling, in order to ensure that you can achieve an acceptable margin on the sale price when you sell the item.
Managing your margins efficiently allows you to provide the best prices to your customers, while still retaining the desired profit margin on your sales.
Refer also to Set Automatic Margin Approval limits for Sales Orders.
Cost Margin Calculation
Lentune uses the cost price on an item, and the applicable discount, to calculate the margin on sales.
Cost price can be obtained from a hierarchy of levels, depending on the settings in your Receivables Manager.
You can select one of two possible methods to calculate the cost margin.
This setting is located in the Receivables Manager > Cost margin settings section. The options are:
-
- Branch Average Cost.
- Replacement Cost.
- Max Of Branch Average Or Replacement
Branch Average Cost
Branch Average Cost uses the priorities below to determine the cost price of an item. Therefore, if there is no value in the higher priority, the system falls back to the next level on the list.
-
-
Branch Average Cost; (rebated for Product rebate). Refer to How Stock Rebates work.
-
Contract Buy Price. (This comes from the Payable Contracts, and selects the best price if there are multiple Payable contracts). This is then rebate adjusted for the Product rebate.
-
Last Purchase Price database-wide.
-
Negotiated Cost.
-
Standard Cost.
-
Replacement Cost
Replacement Cost uses the priorities below to determine the cost price of an item. Therefore, if there is no value in the higher priority, the system falls back to the next level on the list.
-
-
Contract Buy Price; (this comes from the Payable Contracts, and selects the best price if there are multiple Payable contracts). This is rebated for Product rebate.
-
Branch Average Cost; (rebated for Product rebate). Refer to How Stock Rebates work.
-
Last Purchase Price database-wide.
-
Negotiated Cost.
-
Standard Cost.
-
Max Of Branch Average Or Replacement
Max of Branch Average or Replacement takes whichever is the higher value of:
-
-
The Branch Average Cost, or
-
The Payable Contracts Cost.
-
Example to check / edit price and margin in a Sales Order
If you wish to check or edit the price and check the margin for a specific line item in a Sales Order:
- Go to Sales > Sales orders.
- Select a Sales order.
- Check the field Show cost price and margin.
If you wish to change the price for a line item in this Sales order, you can do so.
- Click on the line to open the details screen.
In the Edit sales order line:
- Click Update customer price details.
In the Update Customer Price Details screen, you can either:
- Edit the price for this line in the Cost (margin report) field, or:
- Enter the Margin required, and the new price will be calculated.
- Click Confirm.
-
Click Save and Close.
Receivable Invoice Analysis Report
The Receivable Invoice Analysis Report allows you to select different options to report cost margins.
- Go to Receivables > Receivable Invoice Analysis Report.
- Invoice - start date: Select the Invoice start date to report.
- Invoice - end date: Select the Invoice end date to report.
- Cost selection: Select from Cost Price Margin, Replacement Cost or Branch Average Cost.
- Click View report.
Was this helpful? If you need more information or would like to contact us about this article, please email us at support@lentune.com.
Thank you. We value your feedback.
Last updated: 16 February 2023