Question

In: Accounting

There are 10 units in ending inventory compute the value of the ending inventory using the...

There are 10 units in ending inventory compute the value of the ending inventory
using the periodic inventory method. Compute the answer using FIFO, LIFO and the average
cost methods. (round your answer to the nearest whole number)
Price Cost
Number Per Per
Date Transaction of units unit Purchase
Apr. 3 Inventory 2 10 20
8 Purchase 2 15 30
11 Purchase 3 20 60
30 Purchase 2 25 50
May 8 Purchase 3 25 75
10 Purchase 3 30 90
19 Purchase 3 30 90
28 Purchase 3 35 105
June 5 Purchase 3 40 120
16 Purchase 4 40 160
21 Purchase 4 45 180
28 Purchase 3 50 150

Solutions

Expert Solution

Date Particulars Units   Cost Amount
Apr03 Beginning Inventory                         2.00                       10.00                       20.00
Apr08 Purchase                         2.00                       15.00                       30.00
Apr 11 Purchase                         3.00                       20.00                       60.00
Apr 30 Purchase                         2.00                       25.00                       50.00
May 08 Purchase                         3.00                       25.00                       75.00
May 10 Purchase                         3.00                       30.00                       90.00
May 19 Purchase                         3.00                       30.00                       90.00
May 28 Purchase                         3.00                       35.00                    105.00
June 05 Purchase                         3.00                       40.00                    120.00
June 16 Purchase                         4.00                       40.00                    160.00
June 21 Purchase                         4.00                       45.00                    180.00
June 28 Purchase                         3.00                       50.00                    150.00
Total                       35.00                       32.29                 1,130.00
Ending Inventory using FIFO = 3*50 + 4*45 + 3*40                                             450.00
Ending Inventory using LIFO = 2*10+2*15+3*20+2*25+1*25                                             185.00
Ending Inventory using Average cost =10*32.29                                                   323

Related Solutions

Ending inventory is 350 units. Compute the ending inventory and the cost of goods sold for the current period using (a) first-in, first out, (b) average cost, and (c) last-in, first out.
Computing Cost of Sales and Ending InventoryStocken Company has the following financial records for the current period.UnitsUnit CostBeginning Inventory100$ 46Purchases: #165042#255038#320036Ending inventory is 350 units. Compute the ending inventory and the cost of goods sold for the current period using (a) first-in, first out, (b) average cost, and (c) last-in, first out.(a) First-in, first-outEnding inventory$AnswerCost of goods sold$Answer(b) Average costEnding inventory$AnswerCost of goods sold$Answer(c) Last-in, first-outEnding inventory$AnswerCost of goods sold$Answer
*Complete the journals for buying and selling inventory and put in the ending inventory value (using...
*Complete the journals for buying and selling inventory and put in the ending inventory value (using a T-account for inventory) Bill's Music sells CDs. They have the following transactions for May. 5/1 Purchase 1000 CDs on account (2/10 n30 FOB Shipping) at $3 each and put into inventory 5/2 Freight on the 5/1 purchase was $250. Pay in cash 5/5 Sell 100 CDs for $1,200 - on account. CDs sold cost $300. Terms are 1/10 n30 5/7 Return 50 of...
Calculating the Value of Ending Inventory and Cost of Goods Sold: Perpetual Method Total Units Unit...
Calculating the Value of Ending Inventory and Cost of Goods Sold: Perpetual Method Total Units Unit Cost Total Cost Beginning inventory on hand 1-Jan 60,000 $2.00 $120,000 Purchases during month 5-Jan 103,600 $2.00 $207,200 20-Jan 293,900 $2.10 $617,190 Sales of inventory 25-Jan 383,900 Beginning inventory at 1-Feb 73,600 Purchases during month 8-Feb 282,200 $2.20 $620,840 23-Feb 153,500 $2.60 $399,100 Sales of inventory 27-Feb 407,600 Ending Inventory 101,700 LIFO Jan Feb Cost of goods sold Cost of goods sold Ending inventory...
Calculating the Value of Ending Inventory and Cost of Goods Sold: Perpetual Method Total Units Unit...
Calculating the Value of Ending Inventory and Cost of Goods Sold: Perpetual Method Total Units Unit Cost Total Cost Beginning inventory on hand 1-Jan 60,000 $2.00 $120,000 Purchases during month 5-Jan 103,600 $2.00 $207,200 20-Jan 293,900 $2.10 $617,190 Sales of inventory 25-Jan 383,900 Beginning inventory at 1-Feb 73,600 Purchases during month 8-Feb 282,200 $2.20 $620,840 23-Feb 153,500 $2.60 $399,100 Sales of inventory 27-Feb 407,600 Ending Inventory 101,700 FIFO Jan Feb Cost of goods sold Cost of goods sold Ending inventory...
Calculating the Value of Ending Inventory and Cost of Goods Sold: Perpetual Method Total Units Unit...
Calculating the Value of Ending Inventory and Cost of Goods Sold: Perpetual Method Total Units Unit Cost Total Cost Beginning inventory on hand 1-Jan 60,000 $2.00 $120,000 Purchases during month 5-Jan 103,600 $2.00 $207,200 20-Jan 293,900 $2.10 $617,190 Sales of inventory 25-Jan 383,900 Beginning inventory at 1-Feb 73,600 Purchases during month 8-Feb 282,200 $2.20 $620,840 23-Feb 153,500 $2.60 $399,100 Sales of inventory 27-Feb 407,600 Ending Inventory 101,700 LIFO Jan Feb Cost of goods sold Cost of goods sold Ending inventory...
Compute ending inventory, cost of goods sold, and gross profit.
My question: Assume the company uses three inventory pools instead of one. Compute ending inventory, cost of goods sold, and gross profit. (Round price index to 2 decimal places, e.g. 1.45 and final answers to 0 decimal places, e.g. 6,548.)   William’s Televisions produces television sets in three categories: portable, midsize, and flat-screen. On January 1, 2020, William adopted dollar-value LIFO and decided to use a single inventory pool. The company’s January 1 inventory consists of: Category   Quantity  ...
In comparing the ending inventory balances of FIFO andLIFO, the ending inventory value under FIFO...
Fulbright Corp. uses the periodic inventory system. During its first year of operations, Fulbright made the following purchases (listed in chronological order of acquisition): 40 units at $100 per unit 70 units at $80 per unit 170 units at $60 per unit Sales for the year totaled 270 units, leaving 10 units on hand at the end of the year. In comparing the ending inventory balances of FIFO and LIFO, the ending inventory value under FIFO less the ending inventory balance under LIFO results in...
BE6-3 Compute ending inventory using FIFO and LIFO. In its first month of operations, Bethke Company...
BE6-3 Compute ending inventory using FIFO and LIFO. In its first month of operations, Bethke Company made three purchases of merchandise in the following sequence: (1) 300 units at $6, (2) 400 units at $7, and (3) 200 units at $8. Assuming there are 360 units on hand, compute the cost of the ending inventory under the (a) FIFO method and (b) LIFO method. Bethke uses a periodic inventory system. BE6-4 Compute the ending inventory using average-cost. Data for Bethke...
Compute the net income, using FIFO and LIFO and the following information: Beginning Inventory 26,000 units...
Compute the net income, using FIFO and LIFO and the following information: Beginning Inventory 26,000 units @ $25.00 Purchases (new inventory) 26,000 units @ $30.00 Sales: 26,000 units @ $65.00 Tax Rate: 33% Total Income before taxes: $51,500 Total Income after taxes: $34,505
Calculate the total Ending Inventory value for 2016, 2017, 2018 and 2019 using dollar-value LIFO. (Show...
Calculate the total Ending Inventory value for 2016, 2017, 2018 and 2019 using dollar-value LIFO. (Show all calculations and the ending inventory amount for each of the years) Year    Current year inventory            Index   2016                $50,000                       1.00 2017                $72,000                       1.20 2018                $117,000                     1.30 2019                $119,000                     1.40
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT