Home > Inventory > Stock Control > Screen Shots/Explanations > COGS Periodic Average Calculation

COGS Periodic Average Calculation

To support the costing method, Periodic Weighted Average Costing, this option is used to calculate the periodic average cost.

Figure: Example COGS Periodic Average Calculation

Ensure the period shown is correct and press the Calculate button. A confirmation window is displayed stating the periodic average calculations for the locations is complete is shown.

The task can be done automatically by adding the ‘COGS Periodic Average Calculation’ procedure in Schedule Jobs.

When Process Job is started for COGS Periodic Average Calculation, the average is calculated for all items of all locations having the same tax system and the same currency code as of ‘ALL’ location.

Formula :

Total Cost of SOH of all locations at the beginning of the period)+ (Cost of all Good Receiving of all locations for the current period)-(Cost of all Good Return of all locations for the current period)}÷ {(Total SOH QTY of all locations at the beginning of the Period)+( Total QTY of all Good of all locations Receiving for the current period)-(Total QTY of all Good Return of all locations for the current period)

Figure: Example Process Jobs

Converted from CHM to HTML with chm2web Pro 2.85 (unicode)