Ask Experts Questions for FREE Help !
Ask
    wdwj06's Avatar
    wdwj06 Posts: 1, Reputation: 1
    New Member
     
    #1

    Apr 3, 2009, 08:36 PM
    Calculating Inventory
    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's Avatar
    ROLCAM Posts: 1,420, Reputation: 23
    Ultra Member
     
    #2

    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.

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Calculating Finished Goods Inventory [ 9 Answers ]

Data from Smallwood Company for the year ended December 31 follows: Sales $800,000 Cost of goods Manufactured $550,000 Finished Goods, Dec 31 $100,000 Gross Profit $300,000 What hat is the beginning balance of...

Determine the ending inventory under a perpetual inventory system [ 1 Answers ]

Hi ! I've honestly spent a long time trying to figure this out, but I keep getting the answer wrong and I'm not sure how I should go about this question. I'm not asking for you to just give me the answer, if you have time to give a little explanation that would be nice so I could understand what...

Cannot Find COGS on this particular one (Calculating Beg. Manuf. Inventory) [ 1 Answers ]

The following data pertain to Graham Company's operations in May: May 1 May 31 Work in process inventory $7,800 $12,200 Raw materials inventory $15,500 ? Finished goods inventory ? $20,800 Other data: Raw materials used $42,500...


View more questions Search