Concept explainers
The beginning inventory of merchandise at Alfredson Co. and data on purchases and sales for a three-month period ending June 30 are as follows:
Transaction QTY Per Unit Cost
Apr.3 Inventory 25 $1,200 $30,000
8 Purchase 75 1,240 93,000
11 Sale 40 2,000 80,000
30 " 30 2,000 60,000
May 8 Purchase 60 1,260 75,600
10 Sale 50 2,000 100,000
19 " 20 2,000 40,000
28 Purchase 80 1,260 100,800
June 5 Sale 40 2,250 90,000
16 " 25 2,250 56,250
21 Purchase 35 1,264 44,240
28 Sale 44 2,250 99,000
The company uses periodic inventory system.
1. Determine the inventory on June 30 and the cost of merchandise sold for the three-month period, using the FIFO method.
2. Determine the inventory on June 30 and the cost of merchandise sold for the three-month period, using the LIFO method.
3. Determine the inventory on June 30 and the cost of merchandise sold for the three-month period, using the weighted average cost method. Round the unit cost to the dollar.
Trending nowThis is a popular solution!
Step by stepSolved in 3 steps with 11 images
- The beginning inventory of merchandise at Dunne Co. and data on purchases and sales for a three-month period ending June 30 are as follows: Date Transaction Numberof Units Per Unit Total Apr. 3 Inventory 90 $450 $40,500 8 Purchase 180 540 97,200 11 Sale 121 1,500 181,500 30 Sale 76 1,500 114,000 May 8 Purchase 150 600 90,000 10 Sale 90 1,500 135,000 19 Sale 45 1,500 67,500 28 Purchase 150 660 99,000 June 5 Sale 90 1,575 141,750 16 Sale 120 1,575 189,000 21 Purchase 270 720 194,400 28 Sale 135 1,575 212,625 Required: 1. Record the inventory, purchases, and cost of merchandise sold data in a perpetual inventory record similar to the one illustrated in Exhibit 4, using the last-in, first-out method. Under LIFO, if units are in inventory at two different costs, enter the units with the HIGHER unit cost first in the Cost of Merchandise Sold Unit Cost column and…arrow_forwardThe beginning inventory at Midnight Supplies and data on purchases and sales for a three-month period ending March 31 are as follows: Date Transaction Number of Units Per Unit Total Jan. 1 Inventory 9,000 $ 60.00 $ 540,000 10 Purchase 21,000 70.00 1,470,000 28 Sale 10,250 140.00 1,435,000 30 Sale 5,750 140.00 805,000 Feb. 5 Sale 3,500 140.00 490,000 10 Purchase 39,500 75.00 2,962,500 16 Sale 15,000 150.00 2,250,000 28 Sale 10,000 150.00 1,500,000 Mar. 5 Purchase 25,000 82.00 2,050,000 14 Sale 30,000 150.00 4,500,000 25 Purchase 10,000 88.40 884,000 30 Sale 19,000 150.00 2,850,000 The beginning inventory for Midnight Supplies and data on purchases and sales for a three-month period are shown in Problem 6-1A. Instructions Determine the inventory on March 31 and the cost of goods sold for the three-month period, using the first-in, first-out method and the periodic inventory system. Determine the inventory on…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
- Bonita Company's record of transactions concerning part X for the month of April was as follows. Purchases April 1 (balance on hand) 4 (a1) 11 18 26 30 280 @ 580 Average-cost per unit $ fel 480 @ 380 $5.90 6.00 380 @ 6.30 fel 6.30 780 @ 6.60 6.80 Sales April 5 12 27 28 480 380 1,160 150 Calculate average-cost per unit. Assume that perpetual inventory records are kept in units only. (Round answer to 4 decimal places, e.g. 2.7682.)arrow_forwardBeginning Inventory at FIFO: 15 Units @ $16 = $240 Beginning Inventory at LIFO: 15 Units @ $12 = $1801. Compute the inventory turnover ratio for the month of January under the FIFO and LIFO inventory costing methods. 2. Which costing method is the more accurate indicator of the efficiency of inventory management?arrow_forwardThe beginning inventory at Midnight Supplies and data on purchases and sales for a three-month period ending March 31 are as follows: Date Jan. Feb. Mar. Transaction Number of Units 9,000 21,000 10,250 5,750 3,500 1 Inventory 10 Purchase 28 Sale 30 Sale 5 Sale 10 16 28 5 Purchase 14 25 30 Purchase Sale Sale Sale Purchase Sale 39,500 15,000 10,000 25,000 30,000 10,000 19,000 Per Unit $60.00 70.00 140.00 140.00 140.00 75.00 150.00 150.00 82.00 150.00 88.40 150.00 Total $540,000 1,470,000 1,435,000 805,000 490,000 2,962,500 2,250,000 1,500,000 2,050,000 4,500,000 884,000 2,850,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 3, using the first-in, first-out method. 2. Determine the total sales and the total cost of goods sold for the period. Journalize summary entries for the sales and corresponding cost of goods sold for the period. Assume that all sales were on account and date your…arrow_forward
- Waterway Company had a beginning inventory on January 1 of 180 units of Product 4-18-15 at a cost of $20 per unit. During the year, purchases were as follows. Mar. 15 July 20 450 units 320 units (a) at $23 at $25 Sept. 4 Dec. 2 Determine the cost of goods available for sale. The cost of goods available for sale Waterway Company uses a periodic inventory system. Sales totaled 1,180 units. $ 350 units $27 100 units at $29 atarrow_forwardThe 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 following information applies to the questions displayed below; Hemming Company reported the following current-year purchases and sales for its only product. Date Activities January 1 Beginning inventory January 10 Sales March 14 Purchase March 15 Sales- July 30 Purchase October S October 26 Sales Purchase Totals 275 units 450 units 475 units Units Acquired at Cost $13.00- $18.00 $23.00- Units Sold at Retail $3,575 230 units $43.00 8,100 10,925 408 units 455 units $43.00 $43.00 175 units 1,375 units @$28.90 4,900 $ 27,500 1,885 units Hemming uses a periodic inventory system. (a) Determine the costs assigned to ending inventory and to cost of goods sold using FIFO. (b) Determine the costs assigned to ending inventory and to cost of goods sold using LIFO. (c) Compute the gross profit for each method. a) Periodic FIFO Beginning inventory Purchases March 14 July 30 October 28 Total b) Periodio LIFO Beginning inventory Purchases: Cost of Goods Available for Sale Cost of Goods Sold…arrow_forward
- 3arrow_forwardLaker Company reported the following January purchases and sales data for its only product. For specific identification, ending inventory consists of 275 units from the January 30 purchase, 5 units from the January 20 purchase, and 25 units from beginning inventory. t 3 of 3 Date January 1 Activities January 10 January 20 kipped January 25 January 30 Beginning inventory Sales Purchase Sales Purchase Totals Units Acquired at Cost 175 units @ $ 10.00 = 130 units @ 275 units @ 580 units Units sold at Retail $ 1,750 135 units @ $ 19.00 $ 9.00 = 1,170 140 units $ 19.00 $ 7.00 = 1,925 $ 4,845 275 units eBook Record journal entries for Laker Company's sales and purchases transactions. Assume for this assignment that the company uses a perpetual inventory system and FIFO. All sales and purchases are made on account, and no discounts are offered. View transaction list View journal entry worksheet No 1 Date January 10 General Journal Accounts receivable Sales 2 January 10 Cost of goods sold…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