Concept explainers
LIFO Perpetual Inventory
The beginning inventory for Dunne Co. and data on purchases and sales for a three-month period are as follows:
Date | Transaction | Number of Units |
Per Unit | Total | ||||
Apr. 3 | Inventory | 54 | 525 | $28350 | ||||
8 | Purchase | 108 | 630 | 68040 | ||||
11 | Sale | 72 | 1750 | 126000 | ||||
30 | Sale | 45 | 1750 | 78750 | ||||
May 8 | Purchase | 90 | 700 | 63000 | ||||
10 | Sale | 54 | 1750 | 94500 | ||||
19 | Sale | 27 | 1750 | 47250 | ||||
28 | Purchase | 90 | 770 | 69300 | ||||
June 5 | Sale | 54 | 1840 | 99360 | ||||
16 | Sale | 72 | 1840 | 132480 | ||||
21 | Purchase | 162 | 840 | 136080 | ||||
28 | Sale | 81 | 1840 | 149040 |
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 unit cost first in the Inventory Unit Cost column.
Dunne Co. Schedule of Cost of Merchandise Sold LIFO Method For the three-months ended June 30 |
|||||||||
Purchases | Cost of Merchandise Sold | Inventory | |||||||
Date | Quantity | Unit Cost | Total Cost | Quantity | Unit Cost | Total Cost | Quantity | Unit Cost | Total Cost |
Apr. 3 | $ | $ | |||||||
Apr. 8 | $ | $ | |||||||
Apr. 11 | $ | $ | |||||||
Apr. 30 | |||||||||
May 8 | |||||||||
May 10 | |||||||||
May 19 | |||||||||
May 28 | |||||||||
June 5 | |||||||||
June 16 | |||||||||
June 21 | |||||||||
June 28 | |||||||||
June 30 | Balances | $ | $ |
2. Determine the total sales, the total cost of merchandise sold, and the gross profit from sales for the period.
Total sales | $ |
Total cost of merchandise sold | |
Gross profit | $ |
3. Determine the ending inventory cost on June 30.
$
Trending nowThis is a popular solution!
Step by stepSolved in 4 steps
- Current Attempt in Progress Bramble Furniture Ltd. uses a perpetual inventory system and has a beginning inventory, as at June 1, of 490 bookcases at a cost of $131 each. During June, the company had the following purchases and sales of bookcases: Purchases Sales Date Units Unit Cost Units Unit Price June 6 1,200 $133 10 10 1,050 $197 14 1,740 134 16 1,630 202 96 26 1,030 135 (a) Determine the cost of goods sold and the cost of the ending inventory using the average cost formula. (Use unrounded numbers for average cost calculations. Round answers to 2 decimal places. e.g 5.52.) Cost of goods sold $arrow_forwardPlease don't give image formatarrow_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 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_forward
- LIFO perpetual inventory The beginning inventory at Funky Party Supplies and data on purchases and sales for a three-month period are shown in Problem 7-1A. Date Transaction Number of Units Per Unit Total 1-Jan Inventory 2,500 $60 150,000 10 Purchase 7,500 68 510,000 28 Sale 3,750 120 450,000 30 Sale 1,250 120 150,000 5-Feb Sale 500 120 60,000 10 Purchase 18,000 70 1,260,000 16 Sale 9,000 125 1,125,000 28 Sale 8,500 125 1,062,500 5-Mar Purchase 15,000 71.6 1,074,000 14 Sale 10,000 125 1,250,000 25 Purchase 2,500 72 180,000 30 Sale 8,750 125 1,093,750 Instructions 1. Record the inventory, purchases, and cost of merchandise sold data in a perpetual inventory record, using the last-in, first-out…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 of Units Date Apr. 3 8 11 30 May 8. 10 19 28 June 5 16 2 29 Transaction Inventory Purchase Sale Sale Purchase Sale Sale Purchase Sale Sale Purchase 28 Sale 42 84 56 35 70 42 21 70 42 56 126 63 Per Unit $450 540 1,500 1,500 600 1,500 1,500 660 1,575 1,575 720 1,575 Total $18,900 45,360 84,000 52,500 42,000 63,000 31,500 46,200 66,150 88,200 90,720 99,225arrow_forwardFIFO Perpetual Inventory The beginning inventory of merchandise at Rhodes 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 $375 $15,750 8 Purchase 84 450 37,800 11 Sale 56 1,250 70,000 30 Sale 35 1,250 43,750 May 8 Purchase 70 500 35,000 10 Sale 42 1,250 52,500 19 Sale 21 1,250 26,250 28 Purchase 70 550 38,500 June 5 Sale 42 1,315 55,230 16 Sale 56 1,315 73,640 21 Purchase 126 600 75,600 28 Sale 63 1,315 82,845 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 Cost…arrow_forward
- Perpetual inventory using LIFO The following units of a particular item were available for sale during the calendar year: Jan. 1 Inventory 4,000 units at $41 Apr. 19 Sale 2,400 units June 30 Purchase 4,300 units at $44 Sale 5,100 units Purchase 1,800 units at $46 Sept. 2 Nov. 15 The firm maintains a perpetual inventory system. Determine the cost of goods sold for each sale and the inventory balance after each sale, assuming the last-in, first-out method. Present the data in the form illustrated in Exhibit 4. Under LIFO, if units are in inventory at two or more different costs, enter the units with the LOWER unit cost first in the Inventory Unit Cost column. Date Jan. 1 Apr. 19 June 30 June 30 Sept. 2 Sept. 2 Nov. 15 Nov. 15 Dec. 31 Purchases Quantity Balances Purchases Unit Cost Purchases Total Cost Cost of Goods Sold Quantity LIFO Method Cost of Goods Sold Unit Cost Cost of Goods Sold Total Cost Inventory Quantity 00 Inventory Unit Cost Inventory Total Cost $ 000arrow_forwardSd Subject: acountingarrow_forwardLIFO 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: Number Date Transaction Per Unit Total of Units Apr. 3 Inventory 42 $225 $9,450 Purchase 84 270 22,680 11 Sale 56 750 42,000 30 Sale 35 750 26,250 May 8 Purchase 70 300 21,000 10 Sale 42 750 31,500 19 Sale 21 750 15.750 28 Purchase 70 330 23,100 June 5 Sale 42 790 33.180 16 Sale 56 790 44,240 21 Purchase 126 360 45,360 28 Sale 63 790 49,770 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 unit cost first in the Inventory Unit Cost column. Dunne Co. Schedule of Cost of Merchandise Sold LIFO Method For the…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