FAQ - Weighted Average Costing (WAC)
|
<< Click to Display Table of Contents >> Navigation: »No topics above this level« FAQ - Weighted Average Costing (WAC) |
Stocks that are drawn out ( sales, transfer to other warehouse, returned to supplier, adjustments out) or added in (supplier invoice, transfer from other warehouse, returned from customer or adjustment in) will have an impact on the weighted average cost of the stock.
This is especially so when stocks entry were backdated, will result in different weighted average cost.
Recalculate balance will readjust the cost into the stock report to give the most accurate calculation of the average cost at the point in time.
It is important that user must avoid or minimise backdating any transactions so as not to affect the valuation of the stocks.
How does the system calculates weighted average cost (WAC) of a stock?
The purchases information of a particular stock is as follows
Date |
Qty(Pc) |
Unit Cost |
Total Cost |
Accum Cost |
Balance |
WAC |
01/02/2010 |
20 |
1.80 |
36.00 |
36.00 |
20 |
1.800 |
12/02/2010 |
5 |
2.10 |
10.50 |
46.50 |
25 |
1.820 |
03/03/2010 |
5 |
2.00 |
10.00 |
56.50 |
30 |
1.883 |
If 8 pcs were sold (or transferred out) on the 08/02/2010 , after the first lot but before the second lot of purchase
Date |
Qty(PC)t |
Unit Cost |
Total Cost |
Accum Cost |
Balance |
WAC |
01/02/2010 |
20 |
1.80 |
36.00 |
36.00 |
20 |
1.800 |
08/02/2010 |
-8 |
1.80 |
14.40 |
21.60 |
12 |
1.800 |
12/02/2010 |
5 |
2.10 |
10.50 |
32.10 |
17 |
1.888 |
03/03/2010 |
5 |
2.00 |
10.00 |
42.10 |
22 |
1.914 |
WAC would be on 03/03/2010 :
Total cost divided by total balance quantity
(12pc@ 1.80 + 5pc@ 2.10 + 5pc@ 2.00) divided by 22 pc = 1.9136
If 8 pcs were sold on the 14/02/2010, after the second lot
Date |
Qty(PC)t |
Unit Cost |
Total Cost |
Accum Cost |
Balance |
WAC |
01/02/2010 |
20 |
1.80 |
36.00 |
36.00 |
20 |
1.800 |
12/02/2010 |
5 |
2.10 |
10.50 |
46.50 |
25 |
1.860 |
14/02/2010 |
-8 |
1.860 |
14.88 |
31.62 |
17 |
1.860 |
03/03/2010 |
5 |
2.00 |
10.00 |
41.62 |
22 |
1.892 |
WAC would be
(20pc@ 1.80 + 5pc@ 2.10) divided by 25pc (total of 2 lots) multiply by 17 pc (balance of 25pc - 8pc) + .......
If 8 pcs were sold on 01/02/2010 before the first lot of 20pcs
WAC would be
Date |
Qty(PC)t |
Unit Cost |
Total Cost |
Accum Cost |
Balance |
WAC |
01/02/2010 |
-8 |
1.80 |
14.40 |
-14.40 |
-8 |
1.800 |
02/02/2010 |
20 |
1.80 |
36.00 |
21.60 |
12 |
1.800 |
If 8 pcs were sold on 01/02/2010 before the first 2 lots of cumulative 25pcs (5 + 20)
Date |
Qty(PC)t |
Unit Cost |
Total Cost |
Accum Cost |
Balance |
WAC |
01/02/2010 |
-8 |
? |
14.88 |
? |
? |
? |
02/02/2010 |
5 |
2.10 |
10.50 |
10.50 |
5 |
1.86 |
03/02/2010 |
20 |
1.80 |
36.00 |
46.50 |
25 |
1.86 |
01/02/2010 |
-8 |
1.86 |
14.88 |
31.62 |
17 |
1.86 |
WAC would be
(5pc@ 2.10 + 20pc@ 1.80) divided by 25pc (total of 2 lots)
System will sum up the 2 lots (1st lot is insufficient to calculate) of purchases to work out the WAC and
to plug in the cost into the 8pc sold.
If 8 (3 + 5) pcs were sold on 01/02/2010 before the first 2 lots of cumulative 25pcs (5 + 20)
Date |
Qty(PC) |
Unit Cost |
Total Cost |
Accum Cost |
Balance |
WAC |
01/02/2010 |
-3 |
2.10 |
-6.30 |
-6.30 |
-3 |
2.10 |
01/02/2010 |
-5 |
2.10 |
-10.50 |
-16.80 |
-8 |
2.10 |
02/02/2010 |
8 |
2.10 |
16.80 |
0.00 |
0 |
0.00 |
03/02/2010 |
20 |
1.80 |
36.00 |
36.00 |
20 |
1.80 |
Sample of Average unit cost seen on screen.

Related Topics |
FIFO costing FAQ |
|
Stock Closing value , by FIFO or Weight Average cost |
|
Recalculate Balance scheduled to run nightly |
|
|
Watch all videos: |
https://api.realtimme.io/premium/index.html?Weigted_Average_How_to_cal.htm
