In: Accounting
To more efficiently manage its inventory, Treynor Corporation
maintains its internal inventory records using first-in, first-out
(FIFO) under a perpetual inventory system. The following
information relates to its merchandise inventory during the
year:
| Jan. | 1 | Inventory on hand—28,000 units; cost $13.90 each. | ||
| Feb. | 12 | Purchased 78,000 units for $14.20 each. | ||
| Apr. | 30 | Sold 50,000 units for $21.70 each. | ||
| Jul. | 22 | Purchased 58,000 units for $14.50 each. | ||
| Sep. | 9 | Sold 78,000 units for $21.70 each. | ||
| Nov. | 17 | Purchased 48,000 units for $14.90 each. | ||
| Dec. | 31 | Inventory on hand—84,000 units. |
Required:
1. Determine the amount Treynor would calculate internally
for ending inventory and cost of goods sold using first-in,
first-out (FIFO) under a perpetual inventory system.
2. Determine the amount Treynor would report
externally for ending inventory and cost of goods sold using
last-in, first-out (LIFO) under a periodic inventory system.
3. Determine the amount Treynor would report for
its LIFO reserve at the end of the year.
4. Record the year-end adjusting entry for the
LIFO reserve, assuming the balance at the beginning of the year was
$18,000.
Determine the amount Treynor would calculate internally for ending inventory and cost of goods sold using first-in, first-out (FIFO) under a perpetual inventory system. (Round "Cost per Unit" to 2 decimal places.)
| Perpetual FIFO: | Cost of Goods Available for Sale | Cost of Goods Sold - April 30 | Cost of Goods Sold - September 9 | Inventory Balance | |||||||||
| # of units | Cost per unit | Cost of Goods Available for Sale | # of units sold | Cost per unit | Cost of Goods Sold | # of units sold | Cost per unit | Cost of Goods Sold | Total Cost of Goods Sold | # of units in ending inventory | Cost per unit | Ending Inventory | |
| Beg. Inventory | $0.00 | $0.00 | $0 | $0.00 | $0 | ||||||||
| Purchases: | |||||||||||||
| February 12 | 0.00 | 0.00 | 0.00 | 0 | |||||||||
| July 22 | 0.00 | 0 | 0.00 | 0.00 | |||||||||
| November 17 | 0.00 | 0.00 | 0.00 | ||||||||||
| Total | 0 | $0 | 0 | $0 | 0 | $0 | $0 | 0 | $0 | ||||
Determine the amount Treynor would report externally for ending inventory and cost of goods sold using last-in, first-out (LIFO) under a periodic inventory system.
| LIFO | Cost of Goods Available for Sale | Cost of Goods Sold - Periodic LIFO | Ending Inventory - Periodic LIFO | ||||||
| # of units | Cost per unit | Cost of Goods Available for Sale | # of units sold | Cost per unit | Cost of Goods Sold | # of units in ending inventory | Cost per unit | Ending Inventory | |
| Beginning Inventory | $0.00 | $0 | $0.00 | ||||||
| Purchases: | |||||||||
| Feb 12 | $0.00 | $0.00 | |||||||
| Jul 22 | $0.00 | $0.00 | |||||||
| Nov 17 | $0.00 | $0.00 | |||||||
| Total | 0 | $0 | 0 | $0 | 0 | $0 | |||
| Treynor Corporation | |||||||||
| Perpetual FIFO | |||||||||
| Date | Cost of Goods available for sale | Cost of Goods sold | Inventory Balance | ||||||
| No. of Units | Cost per unit | Amount | No. of Units | Cost per unit | Cost of Goods sold | No. of Units | Cost per unit | Inventory Balance | |
| Opening | 28,000.00 | 13.90 | 389,200.00 | 28,000.00 | 13.90 | 389,200.00 | |||
| Feb. 12 | 78,000.00 | 14.20 | 1,107,600.00 | 28,000.00 | 13.90 | 389,200.00 | |||
| 78,000.00 | 14.20 | 1,107,600.00 | |||||||
| Apr. 30 | 28,000.00 | 13.90 | 389,200.00 | 56,000.00 | 14.20 | 795,200.00 | |||
| 22,000.00 | 14.20 | 312,400.00 | |||||||
| Jul.22 | 58,000.00 | 14.50 | 841,000.00 | 56,000.00 | 14.20 | 795,200.00 | |||
| 58,000.00 | 14.50 | 841,000.00 | |||||||
| Sep.9 | 56,000.00 | 14.20 | 795,200.00 | 36,000.00 | 14.50 | 522,000.00 | |||
| 22,000.00 | 14.50 | 319,000.00 | |||||||
| Nov.17 | 48,000.00 | 14.90 | 715,200.00 | 36,000.00 | 14.50 | 522,000.00 | |||
| 48,000.00 | 14.90 | 715,200.00 | |||||||
| Balance | 128,000.00 | 1,815,800.00 | 84,000.00 | 1,237,200.00 | |||||
| Periodic System | |||||||||
| LIFO | Unit | Rate | Amount $ | ||||||
| Units sold | |||||||||
| Apr. 30 | 50,000.00 | ||||||||
| Sep.9 | 78,000.00 | ||||||||
| Total sales | 128,000.00 | ||||||||
| Less: | |||||||||
| Purchase Nov.17 | 48,000.00 | 14.90 | 715,200.00 | ||||||
| Purchase Jul.22 | 58,000.00 | 14.50 | 841,000.00 | ||||||
| Purchase Feb.12 | 22,000.00 | 14.20 | 312,400.00 | ||||||
| Cost of goods sold | 128,000.00 | 1,868,600.00 | |||||||
| Ending Inventory | |||||||||
| Purchase Feb.12 | 56,000.00 | 14.20 | 795,200.00 | ||||||
| Opening | 28,000.00 | 13.90 | 389,200.00 | ||||||
| Ending Inventory | 84,000.00 | 1,184,400.00 | |||||||