Acquisition cost (without VAT) is calculated as a weighted average cost (CMP). The stock movements that can change the acquisition cost are: Invoice, Production or Transfer.
The formula for calculating the weighted average cost is as follows:
CMP = [(Initial Stock * Initial CMP) + (Increase * Unit Price)] / (Initial Stock + Increment)
On a Production movement, the unit price at which the produced item enters stock is not entered manually: Ebriza calculates it as the sum of (each ingredient's average purchase cost multiplied by its quantity in the recipe), divided by the produced stock item's unit quantity. The recipe total is the cost of one full batch, and dividing it by the unit quantity brings it down to a single produced unit. Details and examples are in the article “How I make production?”
The acquisition cost of a semi-finished item at a location where it is not produced
A raw material with a sub-recipe (a semi-finished item: sauce, dough, cream, sponge, base) can exist at several locations but be produced only at some of them — the ones ticked in the “Production locations” field. At a location where the semi-finished item is not produced, Ebriza determines the average acquisition cost in this order:
If the semi-finished item has entered stock at that location — by a transfer from the location that produces it, or by a supplier reception — its own average acquisition cost is shown, that is exactly the value you see in Stock Management – History on that entry movement.
If the semi-finished item has never entered stock at that location, the cost is estimated from the sub-recipe, using the same formula as for production: the sum of (each sub-recipe ingredient’s average acquisition cost at that location multiplied by its quantity in the sub-recipe), divided by the semi-finished item’s unit quantity.
If the semi-finished item has never entered stock there and its sub-recipe ingredients have no cost at that location either, the cost shown is 0.
The same order applies to the cost shown on the product’s recipe line in Configuration – Products for the selected location, as well as to the cost at which an item produced through production enters stock, and to the valuation of inventory differences.
The current CMP of a stock can be seen in:
Stock Management - Stocks
The Average purchase cost column indicates the RON value of a unit (PCS, KG, L, etc.) in the stock.
Configuration- Product recipe
Here you will see the CMP of each good/ raw material in the recipe, and if you click on it, you will be able to follow the evolution of the CMP on that stock:
For more details on tracking the CMP of a stock in Ebriza, click here.
The Unit Price in the formula is not the figure on the invoice as you see it, but the price converted to your unit of measure: the unit price on the invoice line, excluding VAT and after the line discount, divided by the stock item's Quantity per unit.
This is why the average purchase cost of goods bought by the case or by the bottle is normally a different number from the price shown on the invoice — a case of 24 pieces invoiced at 120 lei results in 5 lei per piece.
If you think the goods were added to inventory at the wrong price, first check the conversion: see the article “The goods were added to inventory at a different price than the invoice: why this happens and how to check it.”
I have a quantity in stock, but the average purchase cost or the value shows 0
The value of a stock item is its quantity multiplied by its average purchase cost. If the item's cost is 0, its value is 0, no matter how much quantity it has.
Only three movements bring a cost: Invoice (the reception from an NIR), Transfer (received from another location) and Production. A stock reset, an inventory and sales carry no price: a reset or an inventory can put a quantity on an item, but they never give it a cost.
So before correcting anything, check the item's movements: open Stock Management - History and search by the item's name (without narrowing the date range). There are two situations, with different fixes:
The item has no Invoice, Transfer or Production movement (only resets, inventories, sales). This means the item has never been received on an NIR, so there is no invoice to correct. Add the supplier invoice that contains the item in Costs - Invoices (manually, or by downloading it from S.P.V. if it is there), then generate the NIR on it and, on the item's line, choose the item in the Goods reception column (or Raw material reception). When you save, the item gets the cost from the invoice and its value is calculated. About the quantity: if the invoice is dated before the last inventory or reset, the counted quantity stays the same and the item only gets its cost; if the invoice is dated after it, its quantity is added to the stock. See the articles "Adding invoices in Costs" and "Create Reception Entry Note".
The item has an Invoice (NIR) movement at price 0. Only in this case is the wrong price on the invoice: correct the price on the invoice in Costs, then regenerate the NIR so the reception is recorded again with the correct price.
Do not try to set the cost through an inventory or a reset: they only correct the quantity.
[tags: average purchase cost, how to calculate, unit price, cmp, value 0, zero cost]