FINANCIAL ACCOUNTING
10th Edition
ISBN: 9781259964947
Author: Libby
Publisher: MCG
expand_more
expand_more
format_list_bulleted
Concept explainers
Topic Video
Question
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 | 7,500 | $75.00 | $562,500 |
10 | Purchase | 22,500 | 85.00 | 1,912,500 | |
28 | Sale | 11,250 | 150.00 | 1,687,500 | |
30 | Sale | 3,750 | 150.00 | 562,500 | |
Feb. | 5 | Sale | 1,500 | 150.00 | 225,000 |
10 | Purchase | 54,000 | 87.50 | 4,725,000 | |
16 | Sale | 27,000 | 160.00 | 4,320,000 | |
28 | Sale | 25,500 | 160.00 | 4,080,000 | |
Mar. | 5 | Purchase | 45,000 | 89.50 | 4,027,500 |
14 | Sale | 30,000 | 160.00 | 4,800,000 | |
25 | Purchase | 7,500 | 90.00 | 675,000 | |
30 | Sale | 26,250 | 160.00 | 4,200,000 |
Instructions | |
1. | Record the inventory, purchases, and cost of merchandise 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 merchandise sold for the period. Journalize the entries in the sales and cost of merchandise sold accounts. Assume that all sales were on account and date your |
3. | Determine the gross profit from sales for the period. |
4. | Determine the ending inventory cost as of March 31. |
5. | Based upon the preceding data, would you expect the inventory using the last-in, first-out method to be higher or lower? |
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution
Trending nowThis is a popular solution!
Step by stepSolved in 4 steps with 4 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- 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_forwardOahu Kiki tracks the number of units purchased and sold throughout each accounting period but applies its inventory costing method at the end of each month, as if it uses a periodic inventory system. Assume Oahu Kiki's records show the following for the month of January. Sales totaled 330 units. Unit Cost $ 90 Date Units Total Cost $ 27,000 Beginning Inventory Purchase January 1 January 15 January 24 300 400 100 40, 000 36,000 Purchase 300 120 Required: 1. Calculate the number and cost of goods available for sale. 2. Calculate the number of units in ending inventory. 3. Calculate the cost of ending inventory and cost of goods sold using the (a) FIFO, (b) LIFO, and (C) weighted average cost methods. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Calculate the number and cost of goods available for sale. Number of Goods Available for Sale units Cost of Goods Available for Salearrow_forwardDate April 1 April 7 A company's inventory records indicate the following data for the month of April: Activities Beginning inventory Purchase Units Acquired at Cost 880 units @ $36 = $31,680 760 units @ $40 Units Sold at Retail = $30,400 April 11 Sale 1,360 units @ $110 April 16. April 22 Purchase Sale 680 units @ $44 = : $29,920 400 units @ $110 The company uses a periodic inventory system. Determine the cost assigned to ending inventory using the specific identification method. Ending inventory consists of 380 units from the April 16 purchase, 80 units from the April 7 purchase, and 100 units from beginning inventory. Multiple Choicearrow_forward
- Periodic inventory by three methods The beginning inventory at Midnight Supplies and data on purchases and sales for a three-month period ending March 31 are as follows: Number Date Transaction of Units Per Unit Total Jan. 1 Inventory Jan. 10 Purchase Jan. 28 Sale Jan. 30 Sale Feb. 5 Sale Feb. 10 Purchase Feb. 16 Sale Feb. 28 Sale Mar. 5 Purchase Mar. 14 Sale Mar. 25 Purchase Mar. 30 Sale 9,000 $60.00 $540,000 21,000 70.00 1,470,000 10,250 140.00 1,435,000 5,750 140.00 805,000 3,500 140.00 490,000 39,500 75.00 2,962,500 15,000 150.00 2,250,000 10,000 150.00 1,500,000 25,000 82.00 2,050,000 30,000 150.00 4,500,000 10,000 88.40 884,000 19,000 150.00 2,850,000 1. 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. Inventory, March 31 $ 966,000 ✓ Cost of goods sold $ 6,940,500 2. Determine the inventory on March 31 and the cost of goods sold for the three-month period, using the…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_forwardPeriodic Inventory by Three Methods The units of an item available for sale during the year were as follows: Jan. 1 Inventory 1,045 units @ $130 Feb. 17 Purchase 1,380 units @ $132 July 21 Purchase 1,660 units @ $135 Nov. 23 Purchase 1,130 units @ $137 There are 1,205 units of the item in the physical inventory at December 31. The periodic inventory system is used. a. Determine the inventory cost by the first-in, first-out method. b. Determine the inventory cost by the last-in, first-out method. C. Determine the inventory cost by the weighted average cost method. Do not round intermediate calculation and round final answer to the nearest whole dollar. 11:52 PM 5/20/2021 DI %24 %24 %24arrow_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_forwardDomesticarrow_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
- The 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_forwardPeriodic inventory by three methods The beginning inventory at Midnight Supplies and data on purchases and sales for a three-month period ending March 31 are as follows: Number Date Transaction of Units Per Unit Total Jan. 1 Inventory Jan. 10 Purchase Jan. 28 Sale Jan. 30 Sale Feb. 5 Sale Feb. 10 Purchase Feb. 16 Sale Feb. 28 Sale Mar. 5 Purchase Mar. 14 Sale Mar. 25 Purchase Mar. 30 Sale 1. 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. Inventory, March 31 $ Cost of goods sold $ 2,850,000 X 2. Determine the inventory on March 31 and the cost of goods sold for the three-month period, using the last-in, first-out method and the periodic inventory system. Inventory, March 31 $ Cost of goods sold $ 9,000 $60.00 $540,000 21,000 70.00 1,470,000 10,250 140.00 1,435,000 5,750 140.00 805,000 3,500 140.00 490,000 39,500 75.00 2,962,500 15,000 150.00 2,250,000 10,000 150.00…arrow_forwardBins Incorporated uses the periodic inventory system. The following table shows beginning inventory and inventory purchases for 2020: Month Beginning Inventory January February March Totals Sales Units Units 2,240 2,880 1,960 3,000 2,080 2,800 2,720 8,680 9,000 Purchases Cost per unit $5.00 $7.00 $5.00 $7.00 Totals $11,200 $13,720 $10,400 $19,040 $54,360 Relative to March, the company projects a 5 percent increase in cost of goods sold during April. The desired ending inventory balance for April is $2,400. Romaguera Inc pays cash to settle 60 percent of its purchases on account during the month of purchase and pays the remaining 40 percent in the month following the purchase. The accounts payable balance as of March 31 was $6,800. Required: Based on the FIFO inventory valuation methods answer the following questions. You may round your final answer to the nearest dollar. What is the ending inventory balance at the end of March? $ What is the total cost of goods sold at the end of…arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- 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
Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis...
Accounting
ISBN:9780134475585
Author:Srikant M. Datar, Madhav V. Rajan
Publisher:PEARSON
Intermediate Accounting
Accounting
ISBN:9781259722660
Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:9781259726705
Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:McGraw-Hill Education