Calculating cost prices and margins to achieve your required margins while allowing your customers the best possible discounts.
Max Of Branch Average Or Replacement
Overview
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 these 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
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.
-
Branch Average Cost Calculation
Lentune calculates branch average cost by factoring in both existing stock and new purchases. Here’s how it works:
- We take the existing price of an item and multiply that by the existing quantity on hand (A) which gives us a value (X).
- If a purchase is made we take the price of that purchase and multiply it by the quantity purchased (B) to get another value (Y).
- We then sum (A) and (B) together to get (C) and we sum (X) and (Y) together to get (Z).
- We then divide (Z) by (C) and that's the branch average 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:
- Start at Sales > Sales orders and select a Sales order.
- Check the field Show cost price and margin.
This displays columns for the Cost price and Margin% for items in the Sales order on the right hand side for each detail line.
If you wish to change the price for a line item in this Sales order, you can do so.
- Double click on the line to open the details screen.
In the Edit sales order line window:
- 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, and the margin will be updated, or:
- Enter the Margin required, and the new price will be calculated.
- Click Confirm, then 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 and end date: Select the Invoice start and end dates to report.
- Cost selection: Select from Cost Price Margin, Replacement Cost or Branch Average Cost.
- Click View report.
|
Need more help? We’re here! We hope our article was helpful! If you need more info or want to connect, drop us an email at support@lentune.com. Thank you. We love to hear from you! |