Period Average Cost Calculation

When Workbench is set to use the Period Average stock costing method, according to the Stock cost method Control Parameter, the Average Cost is calculated as below:

where:

[Value of Stock at the start of the period] - as recorded in the stock closeout for the previous period, being Average Cost * Quantity of SOH

[Value of Receipts] - the value of stock receipts (Inwards Goods) is determined by the unit cost recorded on the Purchase Order Lines being receipted, as the actual cost is unknown until the subsequent AP Invoice is processed some time later. If the PO is in foreign currency, the receipt value in local currency is calculated at the prevailing currency rate, unless the PO is flagged as Fixed Currency, in which the PO currency rate is used.

[Value of non-stocktake Adjustments] - the value any stock adjustments entered manually or imported, or generated from docket fuel receipts. Adjustments generated from the stocktake process are excluded. Adjustments with values, but zero quantities, can be used to include landed costs in stock Unit Cost Rates.

[Value of Inwards Transfers] - the value of transfers where stock has been transferred into a stock location. Note that the Unit Cost Rate used in stock transfers comes from the location the stock is being transferred out of.

[Quantity of Stock at the start of the period] - as recorded in stock closeout for the previous period.

[Quantity of Receipts] - the quantity recorded on Inwards Goods Lines for stock purchases

[Quantity of non-stocktake Adjustments] - these are quantities on any stock adjustments entered manually or imported, or generated from docket fuel receipts. Adjustments generated from the stocktake process are excluded.

[Quantity of Inwards Transfers] - the quantity of transfers where stock has been transferred into a stock location.