PDA

View Full Version : Calculating Inventory


wdwj06
Apr 3, 2009, 08:36 PM
Here's my situation. I need to know how the ending inventory is calculated on these numbers"

Beginning inventory = 20776
purchases of goods in 2008 = 156611
Other expenses in 2008 = 67803
Sales in 2008 = 215940

Your help appreciated.

ROLCAM
Apr 4, 2009, 01:01 AM
You can approximately do it by having the
statistics to help you.
The statistic you need is the average GROSS MARGIN of your business over a few previous years.

The better way of course is to take a physical count and costing the inventory.

The assumption is that the gross margin of your business over the last previous five years was 40%.

You can now work backwards from the figures given to get the CLOSING INVENTORY.

A) Beginning inventory = 20776
B) purchases of goods in 2008 = 156611
C) Other expenses in 2008 = 67803
D) Sales in 2008 = 215940

1) The other expenses is no help at all
although it gives you some gauge as to whether it can be covered by the gross margin.

2) 40% of 215,940 = 86,376 GROSS MARGIN

3) Trading Account:-

D) Sales in 2008********** = 215,940
****************=====
A) Beginning inventory****** = 20,776
ADD.
B)purchases of goods in 2008 = 156,611
__________________________________
SUB-TOTAL****************= 177,387
LESS
X) Closing inventory *********= 47,823
___________________________________
Y) Cost of goods sold ********= 129,564

Z) GROSS MARGIN ********=86,376.
___________________________________

Based on the assumption the Closing Inventory would have been $47,823.