Question

In: Accounting

To more efficiently manage its inventory, Treynor Corporation maintains its internal inventory records using first-in, first-out...

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—20,000 units; cost $12.20 each.
Feb. 12 Purchased 70,000 units for $12.50 each.
Apr. 30 Sold 50,000 units for $20.00 each.
Jul. 22 Purchased 50,000 units for $12.80 each.
Sep. 9 Sold 70,000 units for $20.00 each.
Nov. 17 Purchased 40,000 units for $13.20 each.
Dec. 31 Inventory on hand—60,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. (Assume beginning inventory under LIFO was 20,000 units with a cost of $11.70).
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 $10,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 20,000 $12.20 $244,000 0 $12.20 $12.20 $0 0 $12.20 $0
Purchases:
February 12 70,000 12.50 875,000 0 12.50 0 12.50 0 12.50 0
July 22 50,000 12.80 640,000 0 12.80 0 0 12.80 0 12.80
November 17 40,000 13.20 528,000 0 13.20 0 13.20 13.20
Total 180,000 $2,287,000 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. (Assume beginning inventory under LIFO was 20,000 units with a cost of $11.70).

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 20,000 $11.70 $234,000 $11.70 $0 $11.70
Purchases:
Feb 12 70,000 $12.50 875,000 $12.50 $12.50
Jul 22 50,000 $12.80 640,000 $12.80 $12.80
Nov 17 40,000 $13.20 528,000 $13.20 $13.20
Total 180,000 $2,277,000 0 $0 0 $0

Determine the amount Treynor would report for its LIFO reserve at the end of the year.

LIFO Reserve

Record the year-end adjusting entry for the LIFO reserve, assuming the balance at the beginning of the year was $10,000. (If no entry is required for a transaction/event, select "No journal entry required" in the first account field.)

Journal entry worksheet

  • Record the year-end adjusting entry for the LIFO reserve.

Note: Enter debits before credits.

Transaction General Journal Debit Credit
1

Solutions

Expert Solution

1.

FIFO Cost of Goods Available for Sale Cost of Goods Sold-Apr. 30 Cost of Goods Sold-Sep. 9 Inventory on hand
Activity Units Unit Price Amount Units Unit Price Amount Units Unit Price Amount Units Unit Price Amount
Beginning Inventory 20000 $             12.20 $     244,000 20000 $            12.20 $        244,000
Purchases
Feb. 12 70000 $             12.50 $     875,000 30000 $            12.50 $        375,000 40000 $            12.50 $        500,000
Jul. 22 50000 $             12.80 $     640,000 30000 $            12.80 $        384,000 20000 $            12.80 $      256,000
Nov. 17 40000 $             13.20 $     528,000 40000 $            13.20 $      528,000
Total 180000 $ 2,287,000 50000 $       619,000 70000 $       884,000 60000 $     784,000

2.

LIFO Cost of Goods Available for Sale Cost of Goods Sold Ending Inventory
Activity Units Unit Price Amount Units Unit Price Amount Units Unit Price Amount
Beginning Inventory 20000 $             11.70 $     234,000 20000 $            11.70 $        234,000
Purchases
Feb. 12 70000 $             12.50 $     875,000 30000 $            12.50 $        375,000 40000 $            12.50 $        500,000
Jul. 22 50000 $             12.80 $     640,000 50000 $            12.80 $        640,000
Nov. 17 40000 $             13.20 $     528,000 40000 $            13.20 $        528,000
Total 180000 $ 2,277,000 120000 $    1,543,000 60000 $       734,000

3.
LIFO Reserve at end of year = $784000-734000 = $50000

4.

Account Titles Debit Credit
LIFO Reserve $          40,000
       Cost of Goods Sold $          40,000

Related Solutions

To more efficiently manage its inventory, Treynor Corporation maintains its internal inventory records using first-in, first-out...
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—20,000 units; cost $12.20 each. Feb. 12 Purchased 70,000 units for $12.50 each. Apr. 30 Sold 50,000 units for $20.00 each. Jul. 22 Purchased 50,000 units for $12.80 each. Sep. 9 Sold 70,000 units for $20.00 each. Nov. 17 Purchased 40,000 units for...
To more efficiently manage its inventory, Treynor Corporation maintains its internal inventory records using first-in, first-out...
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—20,000 units; cost $13.10 each. Feb. 12 Purchased 70,000 units for $13.40 each. Apr. 30 Sold 50,000 units for $20.90 each. Jul. 22 Purchased 50,000 units for $13.70 each. Sep. 9 Sold 70,000 units for $20.90 each. Nov. 17 Purchased 40,000 units for...
To more efficiently manage its inventory, Treynor Corporationmaintains its internal inventory records using first-in, first-out...
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.1Inventory on hand—28,000 units; cost $13.90 each.Feb.12Purchased 78,000 units for $14.20 each.Apr.30Sold 50,000 units for $21.70 each.Jul.22Purchased 58,000 units for $14.50 each.Sep.9Sold 78,000 units for $21.70 each.Nov.17Purchased 48,000 units for $14.90 each.Dec.31Inventory on hand—84,000 units.Required:1. Determine the amount Treynor would calculate internally for ending inventory and cost of...
Hopewell Electronics maintains its LED television inventory using the perpetual method. The inventory records for April...
Hopewell Electronics maintains its LED television inventory using the perpetual method. The inventory records for April follow: Beginning inventory 20 units @ $525 each April 12 purchase 30 units @ $550 each April 20 sale 40 units @ $830 each April 25 purchase 15 units @ $575 each Using the weighted-average cost method, how much is the April 30 ending inventory on the Hopewell Electronics' Balance Sheet? Select one: A. $21,600 B. $13,750 C. $14,025 D. $14,175
Robinson Corporation maintains a perpetual inventory system.
  *Robinson Corporation maintains a perpetual inventory system.       *All sales on account are subject to terms of 2/10, n/30. Discounts are taken and granted only when the terms are met. *The cost of all inventory sold in December was 80% of the sales price.       3 Received a check from Swanson Brothers Construction in full payment of invoice dated November 26. The invoice amount was $24,050. 3 Sold sewer and drainage pipe to Beverly’s Building...
Assuming a perpetual inventory system and using the first-in, first-out (FIFO) method
Perpetual Inventory Using FIFO Beginning inventory, purchases, and sales for Item Zeta9 are as follows: Oct. 1 Inventory 200 units at $30 7 Sale 160 units 15 Purchase 180 units at $33 24 Sale 150 units Assuming a perpetual inventory system and using the first-in, first-out (FIFO) method, determine (a) the cost of goods sold on October 24 and (b) the inventory on October 31. a. Cost of goods sold on October 24b. Inventory on October 31
- Analyze inventory costs using an example? - Generally, how does a firm manage its inventory...
- Analyze inventory costs using an example? - Generally, how does a firm manage its inventory efficiently?
3 Fraley Chemical Company accounts for its production activities using first-in, first-out (FIFO) process costing. Inventory...
3 Fraley Chemical Company accounts for its production activities using first-in, first-out (FIFO) process costing. Inventory records for the process show a January 1 work-in-process inventory of 10,000 gallons, 80 percent complete as to materials and 40 percent complete as to conversion. The January 31 inventory consisted of 15,000 gallons, 60 percent complete as to materials and 20 percent complete as to conversion. In January, 40,000 gallons were completed and transferred to the finished goods inventory. Costs in the Work-in-Process...
Stockholm Co. accounts for its inventory using the last-in, first-out (LIFO) method. The data below concern...
Stockholm Co. accounts for its inventory using the last-in, first-out (LIFO) method. The data below concern items in Stockholm Co.’s inventory. Per Unit Gear Stuff Wickets Historical cost $190.00 $106.00 $53.00 Selling price 217.00 145.00 73.75 Cost to complete and sell 19.00 8.00 2.50 Current replacement cost 203.00 105.00 51.00 Normal profit margin 32.00 29.00 21.25 The cost amount that Stockholm Co. should use in the lower-of-cost-or-market (LCM) comparison of stuff is Group of answer choices $105 $108 $106 $137
Facts Burger King is a cash-basis taxpayer but maintains its financial accounting records using full accrual...
Facts Burger King is a cash-basis taxpayer but maintains its financial accounting records using full accrual accounting. In the current year, the company sold a parcel of land resulting in a gain of $10,000. However, the receivable will not be collected until next year at which time the gain will be taxed. Federal income tax law specifies a ‘graduated’ tax structure as follows: The first $20,000 of income is taxed at a rate of 10%. All income above $20,000 is...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT