Concept explainers
LIFO Perpetual Inventory
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 |
Required:
1. Record the inventory, purchases, and cost of goods 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 Goods Sold Unit Cost column and LOWER unit cost first in the Inventory Unit Cost column. Round unit cost to two decimal places, if necessary.
Midnight Supplies Schedule of Cost of Goods Sold LIFO Method For the Three Months Ended March 31 |
|||||||||
---|---|---|---|---|---|---|---|---|---|
Purchases | Cost of Goods Sold | Inventory | |||||||
Date | Quantity | Unit Cost | Total Cost | Quantity | Unit Cost | Total Cost | Quantity | Unit Cost | Total Cost |
Jan. 1 | $ | $ | |||||||
Jan. 10 | $ | $ | |||||||
Jan. 28 | $ | $ | |||||||
Jan. 30 | |||||||||
Feb. 5 | |||||||||
Feb. 10 | |||||||||
Feb. 16 | |||||||||
Feb. 28 | |||||||||
Mar. 5 | |||||||||
Mar. 14 | |||||||||
Mar. 25 | |||||||||
Mar. 30 | |||||||||
Mar. 31 | Balances | $ | $ |
2. Determine the total sales, the total cost of goods sold, and the gross profit from sales for the period.
Total sales | $ |
Total cost of goods sold | $ |
Gross profit | $ |
3. Determine the ending inventory cost as of March 31.
$
Trending nowThis is a popular solution!
Step by stepSolved in 3 steps with 2 images
- LIFO inventoryarrow_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 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…arrow_forwardPeriodic Inventory by Three Methods Dymac Appliances uses the periodic inventory system. Details regarding the inventory of appliances at January 1, purchases invoices during the next 12 months, and the inventory count at December 31 are summarized as follows: Purchases Invoices Model Inventory,January 1 1st 2nd 3rd Inventory Dec 31 A10 4 at $ 41 4 at $ 44 4 at $ 47 5 B15 8 at $ 94 4 at 85 3 at 91 6 at 98 7 E60 3 at 66 3 at 56 15 at 59 9 at 61 5 G83 7 at 245 6 at 253 5 at 263 10 at 262 9 J34 12 at 77 10 at 79 16 at 86 16 at 87 13 M90 2 at 123 2 at 125 3 at 143 3 at 145 5 Q70 5 at 164 4 at 174 4 at 179 7 at 184 8 Required: Determine the cost of the inventory on December 31 by the first-in, first-out method. If the inventory of a particular model comprises one entire purchase plus a portion…arrow_forward
- 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 2,700 $50.00 $135,000 10 Purchase 7,300 58.00 423,400 28 Sale 4,050 100.00 405,000 30 Sale 1,200 100.00 120,000 Feb. 5 Sale 500 100.00 50,000 10 Purchase 17,000 60.00 1,020,000 16 Sale 9,200 105.00 966,000 28 Sale 8,000 105.00 840,000 Mar. 5 Purchase 14,300 61.60 880,880 14 Sale 10,300 105.00 1,081,500 25 Purchase 3,200 62.00 198,400 30 Sale 8,000 105.00 840,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…arrow_forwardFIFO Perpetual Inventory The beginning inventory 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 42 $150 $6,300 8 Purchase 84 180 15,120 11 Sale 56 500 28,000 30 Sale 35 500 17,500 May 8 Purchase 70 200 14,000 10 Sale 42 500 21,000 19 Sale 21 500 10,500 28 Purchase 70 220 15,400 June 5 Sale 42 525 22,050 16 Sale 56 525 29,400 21 Purchase 126 240 30,240 28 Sale 63 525 33,075 Required: 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. Under FIFO, if units are in inventory at two different costs, enter the units with the LOWER unit cost first in the Cost of Goods Sold Unit Cost column and in the Inventory Unit…arrow_forwardPleas help solve and explain this equationarrow_forward
- Beginning inventory, purchases, and sales for an inventory item are as follows: Sep. 1 Beginning Inventory 24 units @ $10 5 Sale 17 units 17 Purchase 10 units @ $15 30 Sale 8 units Assuming a perpetual inventory system and the last-in, first-out method: a. Determine the cost of the goods sold for the September 30 sale.$fill in the blank 1arrow_forwardPeriodic inventory by three methods The units of an item available for sale during the year were as follows: Jan. 1 Inventory 2,200 units at $4 Feb. 17 Purchase 3,700 units at $5 Jul. 21 Purchase 2,600 units at $6 Nov. 23 Purchase 1,500 units at $7 There are 1,800 units of the item in the physical inventory at December 31. The periodic inventory system is used. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. Determine the inventory cost by the first-in, first-out method. Round your answer to the nearest dollar. $ fill in the blank 2 Determine the inventory cost by the last-in, first-out method. Round your answer to the nearest dollar. $ Determine the inventory cost by the weighted average cost method. Round your answer to the nearest dollar. $arrow_forwardQuestion Content Area Based on the following data for the current year, what is the number of days' sales in inventory? Assume 365 days a year. Sales on account during year $575,757 Cost of merchandise sold during year 193,428 Accounts receivable, beginning of year 43,481 Accounts receivable, end of year 51,054 Merchandise inventory, beginning of year 32,544 Merchandise inventory, end of year 43,018 Round your intermediate calculations to the nearest dollar. When required, round your answer to the whole number.arrow_forward
- FIFO Perpetual Inventory 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 48 $450 $21,600 8 Purchase 96 540 51,840 11 Sale 64 1,500 96,000 30 Sale 40 1,500 60,000 May 8 Purchase 80 600 48,000 10 Sale 48 1,500 72,000 19 Sale 24 1,500 36,000 28 Purchase 80 660 52,800 June 5 Sale 48 1,575 75,600 16 Sale 64 1,575 100,800 21 Purchase 144 720 103,680 28 Sale 72 1,575 113,400 Required: 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. Under FIFO, if units are in inventory at two different costs, enter the units with the LOWER unit cost first in the Cost of Merchandise Sold Unit…arrow_forwardFIFO Perpetual Inventory The beginning inventory at Dunne Co. and data on purchases and sales for a three-month period ending June 30 are as follows: Number Date Transaction of Units Per Unit Total Apr. 3 Inventory 90 $450 $40,500 8 Purchase 180 540 97,200 11 Sale 120 1,500 180,000 30 Sale 75 1,500 112,500 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 3, using the first-in, first-out method. Under FIFO, if units are in inventory at two different costs, enter the units with the LOWER unit cost first in the Cost of Goods Sold Unit Cost column and in the Inventory Unit Cost column.arrow_forwardLIFO Perpetual Inventory The beginning inventory for Dunne Co. and data on purchases and sales for a three-month period are as follows: Date Transaction Numberof Units Per Unit Total Apr. 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 75,600 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 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 LOWER…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