Lifo
valentino46
Registered Posts: 124 Dedicated contributor 🦉
HI all,
Has anyone attempted task 2.5 in the tutorial questions section of the unit 6 osborne book. I have to prepare a ledger record for product x using FIFO but am finding it a bit confusing. The info is as follows:
JAN RECEIVED 100 UNITS @ 4.00
FEB ISSUED 80 UNTIS
MAR RECEIVED 140 UNITS @ 4.20
APR RECEIVED 100 UNITS @ 3.80
MAY ISSUED 140 UNITS
JUN RECEIVED 80 UNITS @ 4.50
as it is fifo do i have to use the remaining 20 units at 4.00 after the issue of the first 80 units as the answer in the ack of the book hasnt used these up. Hope someone can help as little confused here!!
cheers
rob
Has anyone attempted task 2.5 in the tutorial questions section of the unit 6 osborne book. I have to prepare a ledger record for product x using FIFO but am finding it a bit confusing. The info is as follows:
JAN RECEIVED 100 UNITS @ 4.00
FEB ISSUED 80 UNTIS
MAR RECEIVED 140 UNITS @ 4.20
APR RECEIVED 100 UNITS @ 3.80
MAY ISSUED 140 UNITS
JUN RECEIVED 80 UNITS @ 4.50
as it is fifo do i have to use the remaining 20 units at 4.00 after the issue of the first 80 units as the answer in the ack of the book hasnt used these up. Hope someone can help as little confused here!!
cheers
rob
0
Comments
-
Lifo
Help if i was using the right calc method!!0 -
Fifo
JAN RECEIVED 100 UNITS @ 4.00 so balance 100 @ £4 = £400
FEB ISSUED 80 UNTIS all at £4 = £320 leaving balance of 20 @£4 = £80
MAR RECEIVED 140 UNITS @ 4.20 leaving a balance of 20 @ £4 = £80
mmmmmmmmmmmimmmmmmmmmmmmmvalueplus 140 @ £4.20 = £588
mmmmmmmmmmmmmmmmmmmmmmmmvaluea total of 160 worth £668
APR RECEIVED 100 UNITS @ 3.80 leaving a balance of 20 @ £4 = £80
mmmmmmmmmmmimmmmmmmmmmmmmvalueplus140 @ £4.20 = £588
mmmmmmmmmmmimmmmmmmmmmmmmvalueplus 100 @ £3.80 = £380
mmmmmmmmmmmmmmmmmmmmmmmmvaluea total of 260 worth £1,048
MAY ISSUED 140 UNITS So 20 @ £4 = £80
mmmmmmmmmmvalue120 @ £4.20 = £504
mmmmmmvaluetotal 140 worth £584
Leaving a stock balance of mmmmmmmmmmmimmmmmmmmmmmmmvalue20 @ £4.20 = £84
mmmmmmmmmmmimmmmmmmmmmmmmmmmmmmmmmmmmmvalueplus 100 @ £3.80 = £380
mmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmvaluea total of 120 worth £464
Hopefully that makes sufficient sense for you to add JUN RECEIVED 80 UNITS @ 4.50 and complete it
For a better layout look at
Stock Blog One on FIFO
Stock Blog Two on LIFO and AVCO
Stock Blog Three with practice questionSandy
sandy@sandyhood.com
www.sandyhood.com0 -
Lifo/fifo/avco
thats fantastic, always seems to fall into place when i see someone else working it out!!!
blogs are excellent also sandy, theyve been a good help already to me.
keep up the great blogging
rob0
Categories
- All Categories
- 1.2K Books to buy and sell
- 2.3K General discussion
- 12.5K For AAT students
- 325 NEW! Qualifications 2022
- 160 General Qualifications 2022 discussion
- 11 AAT Level 2 Certificate in Accounting
- 56 AAT Level 3 Diploma in Accounting
- 95 AAT Level 4 Diploma in Professional Accounting
- 8.9K For accounting professionals
- 23 coronavirus (Covid-19)
- 273 VAT
- 92 Software
- 275 Tax
- 138 Bookkeeping
- 7.2K General accounting discussion
- 202 AAT member discussion
- 3.8K For everyone
- 38 AAT news and announcements
- 345 Feedback for AAT
- 2.8K Chat and off-topic discussion
- 583 Job postings
- 16 Who can benefit from AAT?
- 36 Where can AAT take me?
- 42 Getting started with AAT
- 26 Finding an AAT training provider
- 48 Distance learning and other ways to study AAT
- 25 Apprenticeships
- 66 AAT membership