Seminole Co. began the year with 23,000 units of product in its January 1 inventory costing $15 each. It
made four purchases of its product during the year as follows. The company uses a periodic inventory
system. On December 31, a physical count reveals that 40,000 units of its product remain in inventory. Mar. 7 . 30,000 units @ $18.00 each
May 25 . 39,000 units @ $20.00 each
Aug. 1 . 23,000 units @ $25.00 each
Nov. 10 . 35,000 units @ $26.00 each Required
1. Compute the number and total cost of the units available for sale during the year.
2. Compute the amounts assigned to ending inventory and the cost of goods sold using (a) FIFO,
(b) LIFO, and (c) weighted average. (Round all amounts to cents.)
Trending nowThis is a popular solution!
Step by stepSolved in 2 steps with 1 images
- The 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_forwardThe units of Manganese Plus available for sale during the year were as follows: Mar. 1 Inventory 25 units @ $29 $725 June 16 Purchase 32 units @ $34 1,088 Nov. 28 Purchase 40 units @ $37 1,480 97 units $3,293 There are 17 units of the product in the physical inventory at November 30. The periodic inventory system is used. Round answers to the nearest whole dollar. a. Determine the inventory cost by the FIFO method. $4 b. Determine the inventory cost by the LIFO method. $4 c. Determine the inventory cost by the average cost methods.arrow_forwardA company had the following purchases and sales during its first year of operations: Purchases January: 10 units at $120 20 units at $125 February: May: September: 15 units at $130 12 units at $135 November: 10 units at $140 On December 31, there were 26 units remaining in ending inventory. Using the periodic FIFO inventory costing method, what is the cost of the ending inventory? (Assume all sales were made on the last day of the month.) Multiple Choice $3,540 Sales 6 units 5 units 9 units 8 units 13 units $3,445arrow_forward
- ABC Company employs a periodic inventory system and sells its inventory to customers for $20 per unit. ABC Company had the following inventory information available for May: May 1 May 3 May 8 May 13 May 18 May 20 May 24 May 30 Beginning inventory 1,900 units @ $10.20 cost per unit Purchased 2,100 units @ $11.60 cost per unit Sold 1,400 units Purchased 3,700 units @ $8.10 cost per unit Sold 2,600 units Purchase 4,100 units @ $14.70 cost per unit Sold 2,900 units Purchased 2,200 units @ $12.60 cost per unit During May, ABC Company reported operating expenses of $14,000 and had an income tax rate of 36%. Calculate the amount of net income shown on ABC Company's income statement for May using the LIFO method.arrow_forwardJoe's company began the year with 10,000 units of inventory on hand. The cost of each unit was $5.00. During the year, the following transactions took place: An additional 30,000 units were purchased at $6 each 20,000 units were sold at $10 each. 20,000 units remained on hand at the end of the year. The company uses a periodic inventory system. Prepare the journal entries for the year using FIFO (including the sales entry and the adjusting entry). Prepare the journal entries using LIFOarrow_forward[The following information applies to the questions displayed below.] A company began January with 4,000 units of its principal product. The cost of each unit is $7. Inventory transactions for the month of January are as follows: Date of Purchase January 10 January 18 Totals * Includes purchase price and cost of freight. Date of Sale January 5 January 12 January 20 Total Average Cost Total Sales Beginning Inventory Purchases: January 10 January 18 Units 3,000 4,000 7,000 Units 5,000 units were on hand at the end of the month. 4. Calculate January's ending inventory and cost of goods sold for the month using Average cost, periodic system. 2,000 1,000 3,000 6,000 Number of units Purchases Unit Cost* $8 9 Cost of Goods Available for Sale Unit Cost 4,000 $7.00 3,000 $8.00 4,000 $9.00 11,000 Cost of Goods Available for Sale $ 28,000 Total Cost $ 24,000 36,000 $ 60,000 24,000 36,000 $ 88,000 Answer is not complete. Cost of Goods Sold - Average Cost Number of units sold 77,000 X Average Cost…arrow_forward
- 2. Calculate January's ending inventory and cost of goods sold for the month using LIFO, periodic system.arrow_forwardA company began January with 4,000 units of its principal product. The cost of each unit is $7. Inventory transactions the month of January are as follows: Date of Purchase January 10 January 18 Totals * Includes purchase price and cost of freight. Date of Sale January 5 January 12 January 20 Total Perpetual Average Sales Beginning Inventory Sale - January 5 Subtotal Average Cost Purchase - January 10 Subtotal Average Cost 5,000 units were on hand at the end of the month. Sale - January 12 Subtotal Average Cost Units 3,000 4,000 7,000 Units 2,000 1,000 3,000 6,000 5. Calculate January's ending inventory and cost of goods sold for the month using Average cost, perpetual system. Note: Round average cost per unit to 4 decimal places. Enter sales with a negative sign. Number of units Purchases Unit Cost* $8 9 10,000 4,000 2,000 X 6,000 3,000 9,000 1,000 X Inventory on hand Cost per unit 7.0000 $ 28,000 0 8.0000 Answer is not complete. Inventory Value 28,000 24,000 52,000 Total Cost $…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_forwardA company reports the following beginning inventory and two purchases for the month of January. On January 26, the company sells 350 units. Ending inventory at January 31 totals 150 units. Beginning inventory on January 1 Purchase on January 9 Purchase on January 25 Units 320 80 100 Unit Cost $ 4.50 4.70 4.84arrow_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