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

    Dec 4, 2007, 09:01 AM
    Cost of inventory fifo
    Good morning,
    The following data regarding purchases and sales of a commodity were taken from the related perpetual inventory account:
    6/1 balance... 25 units at $50
    6/6 sale... 20 units
    6/8 purchase... 20 units at $51
    6/16 sale... 10 units
    6/20 purchase... 20 units at $52
    6/23 sale... 25 units
    6/30 purchase... 15 units at $53
    A) determine the cost of inventory balance at 6/30, using (1) the first in , first out method and (2) the last in, first out method. Identify the quantity, unit price, and total cost of each lot in the inventory.
    B) Present the journal entry to record a shortage (shrinkage) of $53 discovered by the physical count on 6/30.


    Wow I do not know where to even begin I have checked the text and still have no clue! Thanks to anyone that can help.
    qcmar24's Avatar
    qcmar24 Posts: 65, Reputation: 3
    Junior Member
     
    #2

    Dec 4, 2007, 08:18 PM
    Quote Originally Posted by socialight
    Good morning,
    the following data regarding purchases and sales of a commodity were taken from teh related perpetual inventory account:
    6/1 balance............................25 units at $50
    6/6 sale.................................20 units
    6/8 purchase..........................20 units at $51
    6/16 sale..................................10 units
    6/20 purchase...........................20 units at $52
    6/23 sale..................................25 units
    6/30 purchase...........................15 units at $53
    A) determine the cost of inventory balance at 6/30, using (1) the first in , first out method and (2) the last in, first out method. identify the quantity, unit price, and total cost of each lot in the inventory.
    B) Present the journal entry to record a shortage (shrinkage) of $53 discovered by the physical count on 6/30.


    Wow i do not know where to even begin i have checked the text and still have no clue! thanks to anyone that can help.
    FIFO
    Date... Goods purchased... cost of goods sold... inventory balance
    6/1... begining balance... 25@50=$1,250
    6/6... 20@50= $1,000... 5@50= $250
    6/8... 20@51= $1,020... 5@50= $250
    ... 20@51=$1,020
    6/16... 5@50= 250... 15@51= 765
    ... 5@51= 255...
    6/20... 20@52= 1,040... 15@51= 765
    ... 20@52= 1,040
    6/23... 15@51= 765... 10@52= 520
    ... 10@52= 520...
    6/30... 15@53= 795... 10@52= 520
    ... 15@53= 795
    Cost of goods sold $2,790 ending merchandise inventory balance $1,315
    LIFO
    6/1... begining balance... 25@50= 1,250
    6/6... 20@50= 1,000... 5@50= 250
    6/8... 20@51= 1,020... 5@50=250
    ... 20@51= 1,020
    6/16... 10@51=510... 5@50=250
    ... 10@51= 510
    6/20... 20@52= 1,040... 5@50=250
    ... 10@51=510
    ... 20@52=1,040
    6/23... 20@52= 1,040... 5@50=250
    ... 5@51= 255... 5@51=255
    ...
    6/30... 15@53= 795... 5@50=250
    ... 5@51=255
    ... 15@53=795
    Cost of goods sold $2,805 ending merchandise inventory balance $1,300
    To record the shrinkage
    Dr. Cost of goods sold... 53
    Cr. Merchandise inventory... 53
    hope this help you

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!

FIFO and LIFO inventory method [ 2 Answers ]

9/1 On Hand, 300 Units@ 1.50 Each $450.00 9/6 Purchased 1000 Units @ 1.65 Each $1650.00 9/18 Purchased 800 Units @1.75 Each $1400.00 Total Cost Of Goods Ava. $3500.00 9/30 On Hand Inventory 425 Units I Get A Little Confused With The Fifo/lifo...

FIFO Perpetual Inventory [ 7 Answers ]

Please help! I am trying to figure out the cost of merchandise sold, but don't know what the entries should be for the Inventory. I ended up getting stuck on the entry for Aug. 11 Inventory. Thank you for your time Nance Date Transaction Number of Units ...

FIFO and Perpetual Inventory [ 8 Answers ]

I have a question about a FIFO Perpetual Inventory. A company's transactions of cases for March. I have to make an Inventory Account Card. I don't get it; how much would be in the final inventory? For example if on March 7 he sold 15 of the 20 that he had so there would be 5 left right? And at...


View more questions Search