Ask Experts Questions for FREE Help!
Answer   ||    Advanced Search

Ask your question or search...
International Sites: Nederlandse experts vragen
User Name 
Password 
Join   Forgot password? 

Home > Business & Careers > Accounting   »   Inventory

Question
 
 
#1  
Old Jan 10, 2007, 01:34 PM
kendu2006
New Member
kendu2006 is offline
 
Join Date: Dec 2006
Posts: 4
kendu2006 See this member's comment history on his/her Profile page.
I started a T shirt Business (merchandising business just this Dec 1, 06.
I need to enter three inventory purchases.

Dec 7 10 units @ $6.00 = $60
Dec 14 20 units @ $12.00= $240
Dec 21 21 units @ $14.00= $210

I sold 15 units for $25 each on Dec 15th. $375
8 of the units sold are from Dec 7th purchase and 7 are from Dec 14th purchase.
I need to use the perpetual inventory system.
I need help to determine the cost assigned to the Dec 31 ending inventory with


(a) FIFO

(b) LIFO

(c) weighted average

(d) specific identification

Please help me with these accounting methods, Thank You.

A)
Date Goods Purchased Cost of Goods Sold Inventory Balance

7-Dec beginning balance 10 units @ $6.00 = $ 60.00

14-Dec 20 units@ $12.00= 240.00 10 units @ $6.00 +
20 units @ $12.00 = 300.00
15 units @ $25.00 = 375.00
15-Dec 8 units @ $ 6.00 = 48 15 units @ $12.00 = 180.00
7 units @ $12.00 = 84+48=132

21-Dec 15 units @ $14.00 = $210.00 15 units @ $12.00= 180.00
15 units @ $14.00= 210.00 390

31-Dec 8 units @ $ 6.00 = 48 15 units @ $12.00= 180.00 + 15 units @ $14.00= 210.00=
7 units @ $12.00 = 84+48=132 390

FIFO 375+132+390= 897

B)

7-Dec beginning balance 10 units @ $6.00 = $ 60.00

14-Dec 20 units @ $12.00=240.00 10 units @ $6.00 +
20 units @ $12.00 = 300.00

15-Dec 15 units @ $25.00 = 375.00
10 units @ $12.00=120 15 units @ $6.00= $90.00
5 units @ $6.00= 30+120 =150

21-Dec 15 units @ $14.00=$210.00 15 units @ $6.00 = $90.00
20units @ $14.00 = $280.00 370

31-Dec 10 units @ $12.00= 120 10 units @ $12.00=120 + 20 units @ $14.00= 280
5 units @ $6.00=30+120= 150

LIFO 340+240 + 370 =950
C) $360.00
D) $344.00

Reply With Quote
 
     


Your Answer
Email me when someone replies to my answer
Join Login



Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Ask your question or search...



Similar Threads
Inventory
(0 replies)
Inventory
(0 replies)
Inventory turnover
(1 replies)
Inventory cost
(2 replies)
Inventory Question
(1 replies)

Thread Tools
Show Printable Version Show Printable Version
Email this Page Email this Page
Search this Thread

Advanced Search

Bookmarks





Copyright ©2003 - 2009, Ask Me Help Desk.
All times are GMT -8. The time now is 09:47 AM.