Monthly Average Method of Stock Valuation

In the monthly average costing method, the closing value of each month will be treated as opening for the next month.

For example :

In the above illustration, the rate (highlighted) is derived as below:

Formula:

Closing rate= Total inward value/total inward quantity.

April month: 47500/200= 237.50

Consumption is derived as below for April month:

Outward quantity * closing rate as on that date.

Example: On 4-4-2015: 50*100= 5000 (consumption)

Gross profit = Value- Consumption

i.e 125000-5000= 120000

Gross profit percentage = Gross profit/value*100

120000/125000*100= 96.00%.

The closing rate is derived as below for May:

Formula:

Closing rate= Total inward value/total inward quantity.

55750/290= 192.2414 or 192.24

55750 comprises of last month’s closing value (treated as opening) + this month inward.

55750= 332520+22500

Where rate = 55750/290 = 192.24

Consumption is derived as below for May:

Outward quantity * closing rate as on that date.

Example: 11-5-2015 : 90*192.2414= 17301.726 or 17301.72 (consumption)

Gross profit = Value- Consumption

243000-17301.72=225698.28

Gross profit percentage = Gross profit/value*100

225698.28/243000*100=92.88%.

When you see the report as a whole, the same will be shown as below:

The total Consumption is derived from the below formula:

Opening Value + Inward Value – Closing Value

i.e. 70000-38448.27= 31551.73.

Gross profit = Value-Consumption

394000-31551.73= 362448.27