Win Accounting
Stock / Inventory Control User Guide
×
Menu
Index

5.2.2. Recalculate Weighted Average Costs

 
Win Accounting makes use of the following costing modules: Actual Costs and Weighted Average Costs
 
The Weighted Average method divides the cost of goods available for sale by the number of units available for sale, yielding the weighted average cost per unit
 
The Recalculate Weighted Average Costs utility is useful when updating your stock prices based on your cost prices
 
Use this feature to easily view the variances between your actual costs and weighted average costs - this can be done by adding "N" to the "Update Weighted Average Cost" section (or by leaving that section blank)
 
Once "Y" is entered into the "Update Weighted Average Cost" section, the "New Weighted Costs" will be committed to the Stock Control Module
 
To help you recalculate weighted average costs for specific stores, stock items or suppliers, comprehensive filter criteria options are provided
 
If no filter criteria are entered, weighted average costs will be recalculated for all stock items
 
NOTE: The Recalculate Weighted Average Costs feature should only be run when there are NO other user/s currently accessing the Stock File
 
 

Using the Recalculate Weighted Average Costs Utility:

 
Recalculating Your Weighted Average Costs
 
Pinpoint and recalculate specific inventory quickly and easily using the filter criteria options:
Filter by Store, Category, Stock, Group, Supplier and/or Supplier Stock Code
 
Enter "Y" into the Update Weighted Average Cost Section to commit and alter the weighted average costs
 
If the Update Weighted Average Cost Section is left blank (or "N" is entered) and the "Print" button is pressed, a report representing the variances between the Actual Costs and Weighted Average Costs for each inventory item will be presented
 
This report can be viewed as many times as necessary until "Y" is entered into the Update Weighted Average Cost Section - at which point, the "New Weighted Costs", as seen in the report, will be committed to the Stock Control Module