Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Merchanter
English (UK)
US English (US)
GB English (UK)
  • Home
  • How to use Merchanter
  • Products

Average vs. Last vs. Standard Cost Prices

Understanding the different product cost prices and how they can be used.

Written by Ian Oldrey

Updated at August 30th, 2023

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Getting Started
    Training Sessions
  • How to use Merchanter
    Sales Invoicing & Credits Products Purchasing Stock Control OData System Settings & Administration Milling & Value Added Processing Sales Order Processing Customers System Release Updates Pricing & Costs Certification Order Picking Agency Sales
  • API Documentation
  • Integrations
    Sage 50 Woo Commerce ECS Webshop Link NearSt QuickBooks Xero ShopWired
  • FAQs
  • Industry Articles
+ More

Within a product on Merchanter there are three main cost prices that are recorded and can be used for different purposes.

Average Cost Price (ACP)

This is a weighted average of the cost of the stock that has been brought into the depot. This is often the most accurate position of the cost of the product, relative to the stock that has been brought in or made. It is maintained automatically by purchasing, adjusting and milling in stock.

 

When viewing a product record under the costs tab (see screenshot) in additional to the product average cost prices you can also see listed the average cost prices at all depots (quays) in the left hand column.

 

 

Last Cost Price (LCP)

As the name would suggest this is the last price that this product was ordered at. In the settings of the system you can select whether the Average and Last cost prices are updated at the point of receipt or completion of a purchase.

 

 

Standard Cost Price (SCP)

This is a management cost price that you have control over how it can best work for each product. The Standard Cost Price can be either manually maintained, so set by a senior user, or be an automatic calculation, based on another figure. Below are the different calculation types:

 
  • Average Cost Price Adjustment - setting a percentage difference from the ACP
  • Last Cost Price Adjustment - setting a percentage difference from the LCP
  • Base Price Adjustment - setting a percentage markdown from the base selling price
  • Best Supplier Price Adjustment - setting a percentage difference from the lowest live supplier price
  • Highest Cost Price Adjustment - setting a percentage difference from the highest cost out of the ACP, LCP and any live supplier prices

The Stock valuation for each depot (and location) is calculated by the ACP, LCP and SCP, though the ACP valuation is often the one to use in the financials

 

When making sales the operator can be shown the cost and margin against any of the ACP, LCP or SCP, but the margin figures for the company will always be against the ACP cost.

average last cost prices

Was this article helpful?

Yes
No
Give feedback about this article

Related Articles

  • Manually removing empty Lots
  • How to create a special offer for a product
  • Product dashboard KPIs
  • Adding product alert notes to products
Solution Vendor Color.png

sales@ten-25.co.uk

01202 861606

Peartree Business Centre, Cobham Road, Ferndown, BH21 7PT, United Kingdom

BMF Service Member logo.jpg
  • linkedin
  • twitter
  • facebook
Privacy Policy

©2020 by Ten-25 Software Ltd.. Proudly created with Wix.com

Expand