Concept explainers
Specific Identification, FIFO, LIFO, and Weighted-Average
Swing Company's beginning inventory and purchases during the fiscal year ended September 30, 20-2, were as follows:
Units | Unit Price | Total Cost | |||
---|---|---|---|---|---|
October 1, 20-1 | Beginning inventory | 430 | $19.5 | $8,385 | |
October 18 | 1st purchase | 520 | 20 | 10,400 | |
November 25 | 2nd purchase | 220 | 21 | 4,620 | |
January 12, 20-2 | 3rd purchase | 310 | 22 | 6,820 | |
March 17 | 4th purchase | 910 | 23.5 | 21,385 | |
June 2 | 5th purchase | 820 | 24 | 19,680 | |
August 21 | 6th purchase | 200 | 24.5 | 4,900 | |
September 27 | 7th purchase | 690 | 25.5 | 17,595 | |
4,100 | $93,785 |
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:
100 are from October 18, 20-1 | 1st purchase |
200 are from January 12, 20-2 | 3rd purchase |
100 are from March 17 | 4th purchase |
400 are from June 2 | 5th purchase |
200 are from August 21 | 6th purchase |
300 are from September 27 | 7th purchase |
Required:
Calculate the total amount to be assigned to cost of goods sold for the fiscal year ended September 30, 20-2, and ending inventory on September 30, 20-2, under each of the following periodic inventory methods. For the weighted-average method, round the average unit cost to two decimal places. Round all final answers to the nearest dollar.
Cost of Goods Sold | Cost of Ending Inventory | |
1. FIFO | $ | $ |
2. LIFO | $ | $ |
3. Weighted-average | $ | $ |
4. Specific identification | $ |
Trending nowThis is a popular solution!
Step by stepSolved in 3 steps with 3 images
- Weighted Average Cost Method with Perpetual Inventory The beginning inventory for Midnight Supplies and data on purchases and sales for a three-month period are as follows: Date Transaction Numberof Units Per Unit Total Jan. 1 Inventory 7,500 $79.00 $592,500 10 Purchase 22,500 89.00 2,002,500 28 Sale 11,250 158.00 1,777,500 30 Sale 3,750 158.00 592,500 Feb. 5 Sale 1,500 158.00 237,000 10 Purchase 54,000 91.50 4,941,000 16 Sale 27,000 168.00 4,536,000 28 Sale 25,500 168.00 4,284,000 Mar. 5 Purchase 45,000 93.50 4,207,500 14 Sale 30,000 168.00 5,040,000 25 Purchase 7,500 94.00 705,000 30 Sale 26,250 168.00 4,410,000 Required: 1. Record the inventory, purchases, and cost of goods sold data in a perpetual inventory record similar to the one illustrated in Exhibit 5, using the weighted average cost method. Round unit cost to two decimal places, if necessary. Round…arrow_forwardPeriodic Inventory Using FIFO, LIFO, and Weighted Average Cost Methods The units of an item available for sale during the year were as follows: Jan. 1 Inventory 13 units at $3,800 $49,400 Aug. 7 Purchase 19 units at $3,900 74,100 Dec. 11 Purchase 13 units at $4,100 53,300 45 units $176,800 There are 18 units of the item in the physical inventory at December 31. The periodic inventory system is used. Determine the inventory cost using (a) the first-in, first-out (FIFO) method; (b) the last-in, first-out (LIFO) method; and (c) the weighted average cost method (Round per unit cost to two decimal places and your final answer to the nearest whole dollar).arrow_forwardSpecific Identification, FIFO, LIFO, and Weighted-Average Boyce Company's beginning inventory and purchases during the fiscal year ended September 30, 20-2, are shown. Units Unit Price Total Cost October 1, 20-1 Beginning inventory 400 $15.00 $6,000 October 18 1st purchase 300 16.50 4,950 November 25 2nd purchase 600 17.00 10,200 January 12, 20-2 3rd purchase 700 17.25 12,075 March 17 4th purchase 800 18.00 14,400 June 2 5th purchase 400 19.00 7,600 August 21 6th purchase 300 21.00 6,300 September 27 7th purchase 500 21.75 10,875 4,000 $72,400 Use the following information for the specific identification method. There are 900 units of inventory on hand on September 30, 20-2. Of these 900 units: 50 are from October 18, 20-1 1st purchase 300 are from January 12, 20-2 3rd purchase 100 are from March 17 4th purchase 200 are from June 2 5th purchase 50 are from August 21 6th purchase 200 are from September 27 7th purchasearrow_forward
- Inventory turnover and number of days’ sales in inventory Financial statement data for years ending December 31 for Tango Company follow: 20Y7 20Y6 Cost of goods sold $3,791,255 $4,079,970 Inventories: Beginning of year 773,800 737,300 End of year 839,500 773,800 Required a. Determine the inventory turnover for 20Y7 and 20Y6. Round to one decimal place. 20Y7 20Y6 Inventory turnover b. Determine the number of days’ sales in inventory for 20Y7 and 20Y6. Use 365 days and round to one decimal place. 20Y7 20Y6 Number of days’ sales in inventory days days c. Are the changes in inventory turnover and the number of days’ sales in inventory from 20Y6 to 20Y7 favorable or unfavorable?arrow_forwardPeriodic Inventory Using FIFO, LIFO, and Weighted Average Cost Methods The units of an item available for sale during the year were as follows: Jan. 1 Inventory 15 units at $5,000 $75,000 Aug. 7 Purchase 16 units at $5,100 81,600 Dec. 11 Purchase 11 units at $5,300 58,300 42 units $214,900 There are 17 units of the item in the physical inventory at December 31. The periodic inventory system is used. Determine the inventory cost using (a) the first-in, first-out (FIFO) method; (b) the last-in, first-out (LIFO) method; and (c) the weighted average cost method (Round per unit cost to two decimal places and your final answer to the nearest whole dollar). а. First-in, first-out (FIFO) $4 b. Last-in, first-out (LIFO) С. Weighted average costarrow_forwardLaker Company reported the following January purchases and sales data for its only product. For specific identification, ending inventory consists of 180 units from the January 30 purchase, 5 units from the January 20 purchase, and 15 units from beginning inventory. Date January 1 January 10 January 20 January 25 January 30 Activities Beginning inventory Sales Purchase Sales Purchase Totals Specific Id Weighted Average Units Acquired at Cost @ $6.00 = @ $5.00 = @ $ 4.50 = FIFO 140 units Complete this question by entering your answers in the tabs below. LIFO 60 units 180 units 380 units $ 840 300 810 $ 1,950 Units sold at Retail The Company uses a periodic inventory system. For specific identification, ending inventory consists of 180 units from the January 30 purchase, 5 units from the January 20 purchase, and 15 units from beginning inventory. Determine the cost assigned to ending inventory and to cost of goods sold using (a) specific identification, (b) weighted average, (c) FIFO,…arrow_forward
- The inventory records of TC show the following purchases:Month Units CostJanuary 15,000 190,500February 20,000 240,000March 12,500 165,00A physical count on March 31 shows 22,500 units on hand. What amount of inventory should be reported as of March 31, using FIFO method of costing?a. 120,000 b. 225,000 c. 280,500 d. 285,000arrow_forwardThe inventory records for Radford Company reflected the following Beginning inventory on May 1 First purchase on May 7 Second purchase on May 17 Third purchase on May 23 1,200 units @ $4.00 1,300 units @ $4.20 1,500 units @ $4.30 1,100 units@ $4.40 Sale on May 31 3,900 units @ $5.90 What is the amount of gross margin assuming the weighted average cost flow method is used? (Round your intermediate calculations to 2 dec Multiple Choice $10.920 $17160 $6,513 O $5.850arrow_forwardWeighted average cost flow method under perpetual inventory system The following units of a particular item were available for sale during the calendar year: Date Line Item Description Units and Cost Jan. 1 Inventory 9,000 units at $50.00 Mar. 18 Sale 7,000 units May 2 Purchase 8,000 units at $56.50 Aug. 9 Sale 8,000 units Oct. 20 Purchase 4,000 units at $60.00 The firm uses the weighted average cost method with a perpetual inventory system. Determine the cost of goods sold for each sale and the inventory balance after each sale. Present the data in the form illustrated in Exhibit 5. Round your "Unit Cost" answers to two decimal places. Weighted Average Cost Flow Method Date PurchasesQuantity PurchasesUnit Cost PurchasesTotal Cost Cost of Goods SoldQuantity Cost of Goods SoldUnit Cost Cost of Goods SoldTotal Cost InventoryQuantity InventoryUnit Cost InventoryTotal Cost Jan. 1 fill in the blank 1 fill in the blank 2 fill in the blank 3 Mar. 18…arrow_forward
- Inventory turnover and number of days’ sales in inventory Financial statement data for years ending December 31 for Tango Company follow: Line Item Description 20Y7 20Y6 Cost of goods sold $3,784,320 $3,852,940 Inventories: Beginning of year 751,900 730,000 End of year 824,900 751,900 a. Determine the inventory turnover for 20Y7 and 20Y6. Round your answers to one decimal place. Line Item Description 20Y7 20Y6 Inventory turnover fill in the blank 1 of 2 fill in the blank 2 of 2 b. Determine the days’ sales in inventory for 20Y7 and 20Y6. Use 365 days a year. Round your answers to one decimal place. Line Item Description 20Y7 20Y6 Number of days’ sales in inventory fill in the blank 1 of 2 days fill in the blank 2 of 2 daysarrow_forwardInventory - Perpetual Moving Weighted Average The following information was available from the inventory records of the Bean Company for January: Balance at January 1 Purchases: January 6 January 26 Sales (at $15/unit): January 7 January 31 Balance at January 31 Units 2,000 3,000 2,700 (2,500) (3,500) 1,700 Unit Cost $9.77 10.30 10.71 Total Cost $19,540 30,900 28,917 Assuming that Bean uses a perpetual moving weighted average system, record the entry/entries needed on January 31. Keep unit costs to 3 decimals.arrow_forwardThe beginning inventory for Dunne Co. and data on purchases and sales for a three-month period are shown in Problem 7-1B. Date Transaction Number of units Per unit ($) Total ($) April 3 Inventory 25 1.200 30.000 8 Purchase 75 1.240 93.000 11 Sale 40 2.000 80.000 30 Sale 30 2.000 60.000 May 8 Purchase 60 1.260 76.500 10 Sale 50 2.000 100.000 19 Sale 20 2.000 40.000 28 Purchase 80 1.260 100.800 June 5 Sale 40 2.250 90.000 16 Sale 25 2.250 56.250 21 Purchase 35 1.264 44.240 28 Sale 44 2.250 99.000 Instructions1. Determine the inventory on June 30, 2014, and the cost of goods sold for the threemonth period, using the first-in, first-out method and the periodic inventory system.2. Determine the inventory on June 30, 2014, and the cost of goods sold for the threemonth period, using the last-in, first-out method and the periodic inventory system.3. Determine the inventory on June 30, 2014, and the cost of goods sold for the threemonth period,…arrow_forward
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education