and (b) above? SERIES A PROBLEMS SPECIFIC IDENTIFICATION, FIFO, LIFO, AND WEIGHT
ID: 2577921 • Letter: A
Question
and (b) above? SERIES A PROBLEMS SPECIFIC IDENTIFICATION, FIFO, LIFO, AND WEIGHTED-AVERAGE Swing ompany's Ieginning inventory and purchases during the fiscal year ended September 3-6A (L03) st of goods sold, FIFO: 61,500 FO:68,450 eighted-avg:64,530 eafic I.D.: 63,200 30, 20-2, were as follows: Unit Price Total Cost Units $20.00 S 8,000 10,250 4,300 6,900 22,050 20,000 5,200 Beginning inventory400 October 1, 20-1 October 18 November 25 January 12, 20-2 rd March 17 June 2 August 21 September 27 Ist purchase 2nd purchase 500 200 300 20.50 21.50 23.00 24.50 ith purchase 5th purchase 6th purchase 7th purchase 800 200 700 4,000 27.00 18,900 Use the following information for the specific identification method. There are 1,300 units of inventory on hand on September 30, 20-2. Of these 1.300 units: 1st purchase 3rd purchase 4th purchase 5th purchase 6th purchase 7th purchase 100 are from October 18, 20-1 200 are from January 12, 20-2 100 are from March 17 400 are from June 2 200 are from August 21 300 are from September 27 (continued)Explanation / Answer
Answer: Periodic Inventory record 1 FIFO method Under FIFO method goods bought first are sold first. Therefore ending inventory of 1,300 units would include as follows: Particulars Units Unit price Total cost 27-Sep 700 $ 27 $ 18,900 (700*27) 21-Aug 200 $ 26 $ 5,200 (200*26) 2-Jun 400 $ 25 $ 10,000 (400*25) (1300-200-700) Total ending inventory 1300 $ 34,100 Cost of goods sold = Total inventory-Ending inventory 95,600-34,100 $ 61,500 2 LIFO method Under LIFO method goods bought last are sold first. Therefore ending inventory of 1,300 units would include as follows: Particulars Units Unit price Total cost 1-Oct 400 20 8000 (400*20) 18-Oct 500 20.5 10250 (500*20.5) 25-Nov 200 21.5 4300 (200*21.5) 12-Jan 200 23 4600 (200*23) (1,300-400-500-200) Total ending inventory 1300 $ 27,150 Cost of goods sold = Total inventory-Ending inventory 95,600-27,150 $ 68,450 3 Weighted-average method Weighted average cost is calculated as follows: Weighted average cost Total cost/Total units =$95,600/4,000 $ 23.90 Value of ending inventory Number of units in ending inventory*Weighted average cost =1,300*$23.90 $ 31,070.00 Cost of goods sold = Total inventory-Ending inventory 95,600-31,070 $ 64,530 4 Specific identification Particulars Units Unit price Total cost 18-Oct 100 $ 20.50 $ 2,050.00 (100*20.5) 12-Jan 200 $ 23.00 $ 4,600.00 (200*23.0) 17-Mar 100 $ 24.50 $ 2,450.00 (100*24.5) 2-Jun 400 $ 25.00 $ 10,000.00 (400*25.0) 21-Aug 200 $ 26.00 $ 5,200.00 (200*26.0) 27-Sep 300 $ 27.00 $ 8,100.00 (300*27.0) Total ending inventory 1300 $ 32,400.00 Cost of goods sold = Total inventory-Ending inventory 95,600-32,400 $ 63,200
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.