Start a conversation

Tracking your product cost and inventory valuation


Purchase price and Cost are two different numbers. The Purchase price (PP) is the default price being used when creating a Purchase Order. The product Cost refers to the cost to acquire or create a product and can vary each time you add products to your inventory. 

erplain uses the Moving Average Cost (MAC) method to calculate the product cost and inventory valuation.  The MAC of each product is calculated after every Purchase Order, Stock Entry or when creating a new product (Initial cost). 

For example, if you create a Purchase Order for 100 Product A at $20,  (or do a Stock Entry) and 2 weeks later, buy 100 more at $10, your MAC will be $15.

You can find more details on the Moving Average Cost method on this page.


Purchase Order and Purchase Delivery

When adding products to your inventory with a Purchase Order, erplain will use the price saved in the 'Purchase Delivery' (created from the PO) to calculate the MAC.  erplain calculates the valuation only as your products come in. 

Shipping Costs

Shipping costs are added to the cost calculation. For example, if the Shipping Costs are $500 and the Purchase Delivery contains 100 products then $5 (500/100) will be added to the product cost for this transaction.


The Initial Cost

The Initial cost (when creating a new product) is the starting point of this cost calculation. If you have not entered the Initial cost in your products, it will be 0 but you can update this field by editing your products. In many cases, at the time of setup, the initial cost can be the same as the purchase price.

 



  • If you create stock entries, make sure to enter the cost of your products, it is being used for the calculation of the MAC. It will show by default the current MAC for the products added to the stock entry:



Once your costs are tracked in erplain, you can check you inventory valuation in these 2 reports from the Intelligence menu. Note the your margin in the sales reports is also calculated from your product costs.


Please note that the Moving Average Cost for each product is calculated ONLY when your On-hand inventory is above zero. For example, if your On-hand inventory is -6 and you purchase 10 items, then the Cost will be calculated only on 4 items (10 - 6).

If your Available inventory is below zero, the MAC will be calculated normally as it is only based on the On-Hand inventory.


Inventory Valuation Details

If you need to see all the transactions that went into the MAC calculation for one of your products, you can go to menu Intelligence, and open the 'Inventory Valuation' report.  For each product, you will be able to open the Inventory valuation details by clicking on the 'Details' button:


You will then see all the transactions that led to the MAC of your product:



The Cost or MAC of a Bundle

The Moving Average Cost (MAC) of a bundle is the sum of the MAC of its components.

Let's take an example:

'Bundle AB' is made of 1 Component A, 2 Component B and 1 Assembly charge (non-inventory product)
The MAC of Component A is $5
The MAC of Component B is $7
The Cost of Assembly Charge is $10
Then the MAC of 'Bundle AB' is 5 + (2x7) + 10 = 29

The MAC of Component A and Component B might vary over time as explained in this page but the MAC of 'Bundle AB' will always be the sum of the MAC of its components.

Choose files or drag and drop files