In: Accounting
|
|
|
|
|
1 | The cost of goods available for sale | $28,305 | ||
2 | Average cost per unit | $25.16 | ||
3 | FIFO | LIFO | Average cost | |
Ending Inventory | $6,345 | $4,995 | $5,661 | |
Cost of Goods Sold | $21,960 | $23,310 | $22,644 | |
4 | The highest inventory amount for the balance sheet | FIFO | ||
The highest cost of goods sold for the income statement | LIFO | |||
Working | ||||
FIFO | ||||
Units | Unit Cost | |||
135 | $27 | $3,645 | ||
90 | $30 | $2,700 | ||
Ending Inventory | $6,345 | |||
COGS = Beginning inventory + purchases - ending inventory | ||||
= | $2,835 + $25,470 - $6,345 | |||
= | $21,960 | |||
LIFO | ||||
Units | Unit Cost | |||
135 | $21 | $2,835 | ||
90 | $24 | $2,160 | ||
Ending Inventory | $4,995 | |||
COGS = Beginning inventory + purchases - ending inventory | ||||
= | $2,835 + $25,470 - $4,955 | |||
= | $23,310 | |||
Average cost | ||||
Units | Unit Cost | |||
135 | $21 | $2,835 | ||
360 | $24 | $8,640 | ||
225 | $25 | $5,625 | ||
315 | $27 | $8,505 | ||
90 | $30 | $2,700 | ||
1,125 | $28,305 | |||
Average cost per unit ($28,305/1,125) | $25.16 | |||
Ending Inventory = 225 x $25.16 | $5,661 | |||
COGS = Beginning inventory + purchases - ending inventory | ||||
= | $2,835 + $25,470 - $5,661 | |||
= | $22,644 | |||