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

 

Zero Cost

Watch all videos:

Realtimme Training Portal

https://api.realtimme.io/premium/index.html?Weigted_Average_How_to_cal.htm