In: Accounting
Transactions for a company during January 2016 include the following:
Date | Event | Transactions |
---|---|---|
1-Jan | Beginning Inventory | 8 Snowmobiles at $2,000 each |
5-Jan | Purchases+Freight | 5 Snowmobiles at $2,500 each |
13-Jan | Sold | 9 Snowmobiles at $3,000 each |
18-Jan | Sold | 3 Snowmobiles at $3,000 each |
23-Jan | Purchases+Freight | 7 Snowmobiles at $2,600 each |
25-Jan | Sold | 3 Snowmobiles at $3,200 each |
Prepare the income statements to Gross Profit - using FIFO, LIFO, and Average Cost Methods
FIFO | LIFO | Average Cost | |
---|---|---|---|
Sales | |||
Beginning Inventory | |||
Cost of Goods Purchased | |||
Cost of Goods Available for Sale | |||
(Ending Inventory) | |||
Cost of Goods Sold | |||
Gross Profit |
Prepare the income statements to Gross Profit - using FIFO, LIFO, and Average Cost Methods | |||||||||||
FIFO | LIFO | Average Method | |||||||||
Sales | $45,600 | $45,600 | $45,600 | ||||||||
Beginning Inventory | $16,000 | $16,000 | $16,000 | ||||||||
Cost of goods Purchased | $30,700 | $30,700 | $30,700 | ||||||||
Cost of goods available for sale | $46,700 | $46,700 | $46,700 | ||||||||
(Ending Inventory) | -$13,000 | -$12,400 | -$12,745 | ||||||||
Cost of goods sold | $33,700 | $34,300 | $33,955 | ||||||||
Gross Profit (Sales - COGS) | $11,900 | $11,300 | $11,645 | ||||||||
Units in ending inventory = 8+5+7 - 9 -3 -3 = 5 units | |||||||||||
Under FIFO , units in ending inventory will be from latest purchases.Hence Ending inventory value = 5 units * $2600 = $13,000 | |||||||||||
Under LIFO , units in ending inventory will be from oldest purchases.Hence Ending inventory value = (1 unit * $2000) + (4 units * $2600) = $12,400 | |||||||||||
Under Average method , value of ending inventory = 5 units * $2549.04 = $12745 |