1) Using Perpetual Inventory- FIFO
Date | Cost of goods available for sale | Cost of goods sold-April 30 | Cost of goods sold-Sep 09 | Inventory | ||||||||
# of units | Cost per unit | Cost of goods available for sale | # of unit | Cost per unit | Cost of goods sold | # of unit | Cost per unit | Cost of goods sold | # of unit in ending inventory | Cost per unit | Ending inventory value | |
Beg. Inventory | 20,000 | 12.20 | 2,44,000 | 20,000 | 12.20 | 2,44,000 | ||||||
Purchases: | ||||||||||||
Feb-12 | 70,000 | 12.50 | 8,75,000 | 30,000 | 12.50 | 3,75,000 | 40,000 | 12.50 | 5,00,000 | |||
Jul-22 | 50,000 | 12.80 | 6,40,000 | 30,000 | 12.80 | 3,84,000 | 20,000 | 12.80 | $ 2,56,000 | |||
Nov-17 | 40,000 | 13.20 | 5,28,000 | 40,000 | 13.20 | $ 5,28,000 | ||||||
Total | 1,80,000 | 22,87,000 | 50,000 | 6,19,000 | 70,000 | 8,84,000 | 60,000 | 7,84,000 |
2) Using Periodic Inventory -LIFO
Date | Cost of goods available for sale | Cost of goodss sold-Periodic LIFO | Ending Inventory Periodic LIFO | ||||||
# of units | Cost per unit | Cost of goods available for sale | # of unit | Cost per unit | Cost of goods sold | # of unit in ending inventory | Cost per unit | Ending inventory value | |
Beg. Inventory | 20,000 | 12.20 | 2,44,000 | 20,000 | 12.20 | 2,44,000 | |||
Purchases: | |||||||||
Feb-12 | 70,000 | 12.50 | 8,75,000 | 30,000 | 12.50 | 3,75,000 | 40,000 | 12.50 | $ 5,00,000 |
Jul-22 | 50,000 | 12.80 | 6,40,000 | 50,000 | 12.80 | 6,40,000 | |||
Nov-17 | 40,000 | 13.20 | 5,28,000 | 40,000 | 13.20 | 5,28,000 | |||
Total | 1,80,000 | 22,87,000 | 1,20,000 | 15,43,000 | 60,000 | 7,44,000 |
3)
LIFO Reserve | = | FIFO Inventory balance- LIFO Inventory balance |
$784,000 - $744,0000 | ||
LIFO reserve | $ 40,000 |
4)
LIFO effect | |
Closing balance in LIFO Resereve | $ 40,000 |
Opening balance in LIFO Resereve | $ 10,000 |
LIFO effect | $ 30,000 |
Cost of goods sold | (40,000-10000) $ 30,000 | |
LIFO allowance | $ 30,000 |
PLEASE CORRECT WRONG ANSWERS. Check my work mode : This shows what is correct or incorrect...
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 Feb. 12 Jul. 22 Sep. 9 Nov. 17 Dec. 31 Inventory on hand-20,000 units; cost $12.20 each. Purchased 70,000 units for $12.50 each. Sold 50,000 units for $20.00 each. Purchased 50,000 units for $12.80 each. Sold 70,000 units for $20.00 each. Purchased 40,000 units for...
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...
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 22,000 units with a cost of $12.80). 3. Determine the amount Treynor would report for its LIFO reserve at the end of the...
PLEASE GIVE SOLUTION IN THE SAME FORMAT AS THE IMAGE
THANK YOU!
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, 800 units for $20.99 each. Jul. 22 Purchased 5e,eee units for $13.70 each. Sep....
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-21,800 units; cost $13.20 each. Feb. 12 Purchased 71,eee units for $13.50 each. Apr. 30 Sold 50,eee units for $21.ee each. Jul. 22 Purchased 51,000 units for $13.8e each. Sep. 9 Sold 71,089 units for $21.ee each. Nov. 17 Purchased 41,eee units for...
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—30,000 units; cost $14.10 each. Feb. 12 Purchased 80,000 units for $14.40 each. Apr. 30 Sold 50,000 units for $21.90 each. Jul. 22 Purchased 60,000 units for $14.70 each. Sep. 9 Sold 80,000 units for $21.90 each. Nov. 17 Purchased 50,000 units for...
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 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-25,000 units; cost $13.60 each. Feb. 12 Purchased 75,000 units for $13.90 each. Apr. 30 Sold 50,000 units for $21.40 each. Jul. 22 Purchased 55,000 units for $14.20 each. Sep. 9 Sold 75,000 units for $21.40 each. Nov. 17 Purchased 45,000 units for...
Check my work mode: This shows what is correct or incorrect for the work you have completed so far. It does not indicate completion. Part 2 of 3 Required information Exercise 8-14 Inventory cost flow methods; perpetual system [LO8-1, 8-4] Altira Corporation uses a perpetual inventory system. The following transactions affected its merchandise inventory during the month of August 2018: 1.53 points Aug.1 Inventory on hand–3,000 units; cost $7.10 each. Purchased 15,000 units for $6.50 each. 14 Sold 12,000 units...
PLEASE GIVE SOLUTION IN THE SAME FORMAT AS THE IMAGE
THANK YOU!
Tipton Processing maintains its Internal Inventory records using average cost under a perpetual Inventory system. The following Information relates to Its Inventory during the year: Jan. 1 Inventory on hand-84, eee units; cost $4.00 each. Feb. 14 Purchased 116,000 units for $5.00 each. Mar. 5 Sold 154,000 units for $14.00 each. Aug. 27 Purchased 54,200 units for $6.00 each. Sep. 12 Sold 64,800 units for $14.00 each. Dec....