A few days ago
Anonymous

Accounting Homework?

Purchases

June 1 (balance) 1,200 @ 3.20

June 3 3,300 @ 3.10

June 7 1,800 @ 3.30

June 15 2,700 @ 3.40

June 22 750 @ 3.50

Sales

June 2 900 @ $5.50

June 6 2,400 @ 5.50

June 9 1,500 @ 5.50

June 10 600 @ 6.00

June 18 2,100 @ 6.00

June 25 450 @ 6.00

Assuming that perpetual inventory records are kept in dollars, the ending inventory on a LIFO basis is?

Top 2 Answers
A few days ago
Anonymous

Favorite Answer

Okay, first off… LIFO stands for Last In, First Out… which means that the last items purchased will be the first ones sold. What you want to do here is measure the number of items sold against the latest purchases. This problem is a little tricky, because you’ll need to compare the sales dates with the purchase dates and be sure you’re not recording sales on items which haven’t been purchased yet.

June 2 sale of 900 items….. 3.20 each because those are the only ones in inventory at the time of sale.

June 6 sale of 2400 items…. 3.10 each because the purchase on June 3 was sufficient to handle this sale (LIFO)

June 9 sale of 1500 items… 3.30 from June 7 purchase

June 10 sale of 600 items… aha! tricky one…

Let’s figure this one out… we have on hand by this time…

300 @ 3.20 from June 1

900 @ 3.10 from June 3

300 @ 3.30 from June 7…. SO… we sell 600 on June 10 from existing inventory… 300 @ 3.30 (LIFO) and 300 @ 3.10, leaving the 300 from June 1 and 600 from June 3 purchases…

Then we have June 18 sale of 2100 items from the June 15th purchase @ 3.40, leaving 600 @ 3.40.

And the final sale of 450 items from the June 22nd purchase, which leaves 300 @ 3.50.

Okay, so, now where does that leave us?

300 from the June 1 existing inventory @ 3.20

600 from the June 3 purchase @ 3.10

600 from the June 15th purchase @ 3.40

300 from the June 22 purchase @ 3.50

Just multiply that out, and that’s your ending inventory.

What, you thought I was going to do it all?? 😉

0

A few days ago
rb_cubed
Phew! I guess you are just going to sit down and do all of those calculations. Make a couple of T accounts, or use Excel to make it easy. Then just copy everything over to your work papers. I would use excel. Set up your first column as dates, your second column as qty purchased etc, etc etc, you know how to do it —
0