Explore BrainMass
Share

FIFO, LIFO Average Cost

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

Calculate the requested amounts:
Inventory:
May 1 100 units @ $5.00
Purchases:
May 5 200 units @ $5.00
May 16 200 units @ $6.00
May 24 300 units @ $7.00

Sales: May 14 150 units
May 20 300 units

1. Using the periodic inventory system determine ending inventory under FIFO.
2. Using the periodic inventory system determine cost of goods sold under FIFO.
3. Using the periodic inventory system determine ending inventory under LIFO.
4. Using the periodic inventory system determine cost of goods sold under LIFO.
5. Using the periodic inventory system determine ending inventory under average cost.
6. Using the periodic inventory system determine cost of goods sold under average cost.
7. Using the perpetual inventory system determine ending inventory under FIFO.
8. Using the perpetual inventory system determine cost of goods sold under FIFO.
9. Using the perpetual inventory system determine ending inventory under LIFO.
10. Using the perpetual inventory system determine cost of goods sold under LIFO.

© BrainMass Inc. brainmass.com October 17, 2018, 11:34 am ad1c9bdddf
https://brainmass.com/business/inventory/fifo-lifo-average-cost-544671

Solution Summary

Your tutorial is in excel attached with instructional notes. Click in cells to see computations. This is now a template for similar problems.

$2.19
Similar Posting

Calculate inventory cost using FIFO, LIFO, average cost

Problem 1.

Jan 1 Inventory 27 units at $120
Feb 17 Purchase 54 units at $138
July 21 Purchase 63 units at $156
Nov 23 Purchase 36 unit at $165

50 units of the item in the physical inventory at Dec 31. The periodic inventory system should be used to determine the inventory cost by:
1. The first in, first out
2. last in, first out method, and
3 .the average cost method.

Problem 2.

Jan 1 Inventory 42 units at $60
Mar 10 Purchase 58 units at $65
Aug 30 Purchase 20 units at $68
Dec 12 Purchase 30 units at $70

There are 36 units of the item in the physical inventory at Dec 31. The periodic inventory system is used. Determine the inventory cost and the cost of merchandise sold by three methods, presenting your answers in the following form:

Merch inventory Merch Sold
a. first in, first out $ $
b. last in, first out $ $
c. Average cost $ $

View Full Posting Details