Question

ABC Company had the following purchases and sales in June. What is the ending June inventory...

ABC Company had the following purchases and sales in June. What is the ending June inventory balance using the periodic FIFO and perpetual LIFO methods? Date Action Units Cost June 1 Beg. Inventory 100 $2 June 6 Sale 50 June 9 Purchase 200 $4 June 15 Sale 175 June 20 Purchase 100 $5 June 25 Sale 125

Homework Answers

Answer #1
FIFO METHDO - PERIODICAL METHOD
COST OF GOODS AVAILABLE FOR SALE COST OF GOODS SOLD CLOSING STOCK
Date Particulars Units Cost Per unit Total Units Cost Per unit Cost of Goods Sold Units Cost Per unit Ending inventory
June.01 Beginning inventory                            100 $                2.00 $                     200                       100 $           2.00 $                 200
June.09 Purchases                            200 $                4.00 $                     800                       200 $           4.00 $                 800
June.20 Purchases                            100 $                5.00 $                     500                          50 $           5.00 $                 250                      50 $           5.00 $                 250
Total Goods Available For sale                            400 $                  1,500                       350 $             1,250                      50 $                 250
LIFO METHDO - PERPETUAL METHOD
COST OF GOODS AVAILABLE FOR SALE COST OF GOODS SOLD CLOSING STOCK
Date Particulars Units Cost Per unit Total Units Cost Per unit Cost of Goods Sold Units Cost Per unit Ending inventory
June.01 Beginning inventory                    100 $           2.00 $                 200
June.06 Sales                          50 $           2.00 $                 100                      50 $           2.00 $                 100
June.09 Purchases                            200 $                4.00 $                     800                      50 $           2.00 $                 100
                   200 $           4.00 $                 800
June.15 Sales                       175 $           4.00 $                 700                      50 $           2.00 $                 100
                     25 $           4.00 $                 100
June.20 Purchases                            100 $                5.00 $                     500                      50 $           2.00 $                 100
                     25 $           4.00 $                 100
                   100 $           5.00 $                 500
June .25 Sales                       100 $           5.00 $                 500
                         25 $           4.00 $                 100                      50 $           2.00 $                 100
Total Goods Available For sale                            300 $                  1,300                       350 $             1,400                      50 $                 100
Answer = FIFO - Periodical LIFO - Perpetual
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
ABC Company had the following purchases and sales in June. What is the ending June inventory...
ABC Company had the following purchases and sales in June. What is the ending June inventory balance using the periodic FIFO and perpetual LIFO methods? Date                   Action                      Units          Cost June 1             Beg. Inventory           100               $2 June 6             Sale                                50 June 9             Purchase                      200              $4 June 15           Sale                               175 June 20           Purchase                      100              $5 June 25           Sale                               125 ABC Company had the following purchases and sales in June. What is the ending June inventory balance using the periodic FIFO and perpetual...
Inventory Costing Methods: Periodic LIFO (Appendix 6B) Filimonov Inc. has the following information related to purchases...
Inventory Costing Methods: Periodic LIFO (Appendix 6B) Filimonov Inc. has the following information related to purchases and sales of one of its inventory items: Date Description Units Purchased at Cost Units Sold at Retail June 1 Beginning Inventory 200 units @ $10 = $2,000 9 Purchase 1 300 units @ $12 = $3,600 14 Sale 1 400 units @ $25 22 Purchase 2 250 units @ $14 = $3,500 29 Sale 2 225 units @ $25 Assume that the company...
Use the information below to determine the number of units in ending inventory and the ending...
Use the information below to determine the number of units in ending inventory and the ending inventory value using the perpetual inventory system for FIFO. ($) Number Per Date Transaction of units unit Apr. 3 Inventory 30 800 8 Purchase 60 820 11 Sale 40 - 30 Sale 30 - May 8 Purchase 60 850 10 Sale 20 - 19 Sale 15 - 28 Purchase 80 900 Part 2 There are 10 units in ending inventory compute the value of...
Date Transaction # of Units Unit Cost Total Cost 1/1 Beg Balance 150 $30 $4,500 1/24...
Date Transaction # of Units Unit Cost Total Cost 1/1 Beg Balance 150 $30 $4,500 1/24 Purchase 70 33 2,310 2/22 Sale (100) - - 3/7 Purchase 90 35 3,150 4/10 Purchase 140 36 5,040 6/11 Sale (100) - - 9/28 Purchase 50 38 1,900 12/4 Sale (100) - - What is the cost of goods sold under a FIFO periodic inventory system? $10,500 $9,610 $7,290 $6,150 What is the ending inventory under a LIFO periodic inventory system? $10,500 $9,610...
The following data regarding purchases and sales of a commodity were taken from the related perpetual...
The following data regarding purchases and sales of a commodity were taken from the related perpetual inventory account: June 1 Balance 25 units at $60 6 Sale 20 units 8 Purchase 20 units at $61 16 Sale 10 units 20 Purchase 20 units at $62 23 Sale 25 units 30 Purchase 15 units at $63 Calculate the cost of the ending inventory at June 30, using (a) the first-in, first-out (FIFO) method and (b) the last-in, first-out (LIFO) method. Identify...
A company just starting business made the following four inventory purchases in June: June      1                      &
A company just starting business made the following four inventory purchases in June: June      1                           150 units                      $   490 June    10                           200 units                           785 June    15                           200 units                           830 June    28                           150 units                           810                                                                                $2,915 A physical count of merchandise inventory on June 30 reveals that there are 220 units on hand. Using the Periodic Inventory System. a. Using the LIFO inventory method, the value of the ending inventory on June 30 is? b. Using the Average Cost Inventory Method...
Warnerwoods Company uses a perpetual inventory system. It entered into the following purchases and sales transactions...
Warnerwoods Company uses a perpetual inventory system. It entered into the following purchases and sales transactions for March. Date Activities Units Acquired at Cost Units Sold at Retail Mar. 1 Beginning inventory 240 units @ $53.80 per unit Mar. 5 Purchase 295 units @ $58.80 per unit Mar. 9 Sales 400 units @ $88.80 per unit Mar. 18 Purchase 155 units @ $63.80 per unit Mar. 25 Purchase 290 units @ $65.80 per unit Mar. 29 Sales 270 units @...
Perpetual Inventory Using FIFO Beginning inventory, purchases, and sales data for portable DVD players are as...
Perpetual Inventory Using FIFO Beginning inventory, purchases, and sales data for portable DVD players are as follows: June 1 Inventory 74 units @ $78 6 Sale 55 units 14 Purchase 30 units @ $81 19 Sale 27 units 25 Sale 14 units 30 Purchase 25 units @ $86 The business maintains a perpetual inventory system, costing by the first-in, first-out method. Determine the cost of the merchandise sold for each sale and the inventory balance after each sale, presenting the...
During January, a company that uses a perpetual inventory system had beginning inventory, purchases, and sales...
During January, a company that uses a perpetual inventory system had beginning inventory, purchases, and sales as follows : Units Cost per unit Begin Inventory 100 12 Jan 5 Sale 50 10 Purchase 70 16 15 Sale 25 25 Sale 35 Required: Prepare a schedule showing cost of goods sold and ending inventory using weighted average. Prepare a schedule showing cost of goods sold and ending inventory using First In First Out. Compute gross profit under for a and b....
The following relates to ABC Company’s inventory for April: Date Description 4/1 Beginning Inventory 4/5 Purchases...
The following relates to ABC Company’s inventory for April: Date Description 4/1 Beginning Inventory 4/5 Purchases 4/18 Purchases 4/30 Ending inventory Units 1,500 2,500 1,000 1,800 Unit cost $10 $11 $12 Batch cost $15,000 $27,500 $12,000 Calculate cost of goods available for sale for April _____________________ Calculate the cost of goods sold under the following methods: ________________ FIFO ________________ Average Calculate cost of ending inventory under the following methods: ________________ LIFO ________________ Average