Ask Experts Questions for FREE Help!
  Advanced
Register  |  Log in  
   Ask    
 Answer  
  Help  

Ask QuestionsprogressAnswer QuestionsprogressBuild ReputationprogressBecome an Expert
 
Free Answers in 3 Easy Steps

Register Now
3 Steps

At Ask Me Help Desk you can ask questions in any topic and have them answered for free by our experts. To ask questions or participate in answering them you must register for a free account. By registering you will be able to:
  • Get free answers from experts in any of our 300+ topics.
  • Accept money for answers that you provide.
  • Communicate privately with other members (PM).
  • See fewer ads.

Home > Business & Careers > Accounting   »   Inventory

 
Question Tools Search this Question Display Modes
Question
 
 
#1  
Old Jan 10, 2007, 12: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
 
     



Question Tools Search this Question
Search this Question:

Advanced Search
Display Modes

 
Similar Sponsors

Similar Questions
Question Asker Topic Answers Last Post
Inventory Mary_587 Accounting 0 Dec 11, 2006 11:33 AM
Inventory tori8283 Accounting 0 Nov 20, 2006 03:39 PM
Inventory turnover syl123 Accounting 1 Oct 1, 2006 05:26 PM
Inventory cost harshy Finance & Accounting 2 Aug 28, 2006 07:05 PM
Inventory Question CassyDee Accounting 1 Nov 19, 2005 01:00 PM




Copyright ©2003 - 2007, Ask Me Help Desk.
All times are GMT -8. The time now is 06:43 AM.

Content Relevant URLs by vBSEO 3.0.0 RC6 © 2006, Crawlability, Inc.