In: Accounting
During the year, Trombley Incorporated has the following inventory transactions.
Date | Transaction | Number of Units |
Unit Cost |
Total Cost |
Jan. 1 | Beginning inventory | 11 | $ 13 | $ 143 |
Mar. 4 | Purchase | 16 | 12 | 192 |
Jun. 9 | Purchase | 21 | 11 | 231 |
Nov. 11 | Purchase | 21 | 9 | 189 |
69 | $ 755 | |||
For the entire year, the company sells 51 units of inventory for $21 each.
A: Using FIFO, calculate ending inventory, cost of goods sold, sales revenue, and gross profit.
B:Using LIFO, calculate ending inventory, cost of goods sold, sales revenue, and gross profit
C:Using weighted-average cost, calculate ending inventory, cost of goods sold, sales revenue, and gross profit. (Round "Weighted-Average Cost per unit" to 2 decimal places.)
D: Which method will result in higher profitability when inventory costs are declining?
Part A | FIFO | ||||
Cost of goods sold | |||||
FIFO | Units | Unit cost | Cost of goods sold | ||
From beginning inventory | 11 | 13 | 143 | ||
From first purchase | 16 | 12 | 192 | ||
From second purchase | 21 | 11 | 231 | ||
From third purchase | 3 | 9 | 27 | ||
Total | 51 | 593 | |||
Ending inventory | |||||
From third purchase | 18 | 9 | 162 | ||
Ending inventory units = (11+16+21+21-51) = 18 units | |||||
Sales value = (51*21) = 1,071 | |||||
Gross profit = (Sales value-Cost of goods sold) = (1,071-593) = 478 | |||||
Part B | LIFO | ||||
Cost of goods sold | |||||
FIFO | Units | Unit cost | Cost of goods sold | ||
From third purchase | 21 | 9 | 189 | ||
From second purchase | 21 | 11 | 231 | ||
From first purchase | 9 | 12 | 108 | ||
Total | 51 | 528 | |||
Ending inventory | |||||
From first purchase | 7 | 12 | 84 | ||
From beginning inventory | 11 | 13 | 143 | ||
18 | 227 | ||||
Sales value = (51*21) = 1,071 | |||||
Gross profit = (Sales value-Cost of goods sold) = (1,071-528) = 543 | |||||
Part C | Weighted average | ||||
Units | Average cost | Total | |||
Cost of goods sold | 51 | 10.94 | 558 | ||
Ending inventory | 18 | 10.94 | 197 | ||
Sales value = (51*21) = 1,071 | |||||
Gross profit = (Sales value-Cost of goods sold) = (1,071-558) = 513 | |||||
Average cost | |||||
11 | 13 | 143 | |||
16 | 12 | 192 | |||
21 | 11 | 231 | |||
21 | 9 | 189 | |||
69 | 755 | ||||
Average cost = (755 / 69) = 10.94 | |||||
Part D | LIFO will result in higher profitability of $543 when inventory costs are declining. |