How to calculate the weighted average cost?
The weighted average cost price is calculated
when parts enter into stock.
To enter a part stock, you must access the
warehouse tab "Inventory parts | Warehouses", select the warehouse
you want to enter stock.
The calculation follows this formula:
[(Current Stock x Current WACP) + (Stock Entry
x Price Entry)] / (Current Stock + Stock Entry)
Current stock: Existing stock in the warehouse before the entry of parts stock;
WACP: Weighted
average cost price;
Price entry: Price of the part at the stock entry;
Stock entry: Stock of the part at the stock entry;
Related Articles
How to report consumptions at the average cost?
To record material consumptions at the average cost, you must create a Work Order type "Settings | Work | Work Order Types" and select the "Use Average Cost Price" option available on the "Costs" tab. When a work order is in a state that allows costs ...What is the meter average calculation?
The meter average is calculated every time a meter value record is performed as long as the average window field is different than zero. The field "Window Size of Moving Average" is considered as the maximum number of readings/days to be included in ...How is the average of condition controls calculated?
When inserting monitoring values, the moving average is calculated for that value considering the average window defined in the monitoring and the average window value used on the calculation is also saved. It is performed for the next N-1 values (in ...How to calculate the expected end date of a request?
The expected end date of a request is calculated considering the priority level assigned and the start expected date. The response time defined in the priority level is always converted to minutes, regardless of the selected time unit, so it is the ...How do I insert a replacement meter?
To insert a replacement meter, follow these steps: Go to Assets | Measurements | Meters; Select a meter; Click on the Operations button to access the meter readings list; Click on Create and then on Replace Meter; Fill in the replacement meter ...