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 | 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 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 with 3 images
- Weighted Average Cost Method with Perpetual Inventory The beginning inventory for Midnight Supplies and data on purchases and sales for a three-month period are as follows: Date Transaction Numberof Units Per Unit Total Jan. 1 Inventory 7,500 $79.00 $592,500 10 Purchase 22,500 89.00 2,002,500 28 Sale 11,250 158.00 1,777,500 30 Sale 3,750 158.00 592,500 Feb. 5 Sale 1,500 158.00 237,000 10 Purchase 54,000 91.50 4,941,000 16 Sale 27,000 168.00 4,536,000 28 Sale 25,500 168.00 4,284,000 Mar. 5 Purchase 45,000 93.50 4,207,500 14 Sale 30,000 168.00 5,040,000 25 Purchase 7,500 94.00 705,000 30 Sale 26,250 168.00 4,410,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 5, using the weighted average cost method. Round unit cost to two decimal places, if necessary. Round…arrow_forwardPerpetual inventory using FIFO The following units of a particular item were available for sale during the calendar year: Jan. 1 Inventory 3,800 units at $39 Apr. 19 Sale 2,000 units June 30 Purchase 4,300 units at $42 Sept. 2 Sale 5,300 units Nov. 15 Purchase 2,000 units at $43 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 first-in, first-out method. Present the data in the form illustrated in Exhibit 3. 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. Round your answers for quantity values to the nearest whole number, for unit cost values to the nearest cent, and for total cost values to the nearest dollar. Schedule of Cost of Goods SoldFIFO Method Purchases Cost of Goods Sold Inventory…arrow_forwardPeriodic Inventory Using FIFO, LIFO, and Weighted Average Cost Methods The units of an item available for sale during the year were as follows: Jan. 1 Inventory 13 units at $3,800 $49,400 Aug. 7 Purchase 19 units at $3,900 74,100 Dec. 11 Purchase 13 units at $4,100 53,300 45 units $176,800 There are 18 units of the item in the physical inventory at December 31. The periodic inventory system is used. Determine the inventory cost using (a) the first-in, first-out (FIFO) method; (b) the last-in, first-out (LIFO) method; and (c) the weighted average cost method (Round per unit cost to two decimal places and your final answer to the nearest whole dollar).arrow_forward
- Specific 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_forwardInventory turnover and number of days’ sales in inventory Financial statement data for years ending December 31 for Tango Company follow: 20Y7 20Y6 Cost of goods sold $3,791,255 $4,079,970 Inventories: Beginning of year 773,800 737,300 End of year 839,500 773,800 Required a. Determine the inventory turnover for 20Y7 and 20Y6. Round to one decimal place. 20Y7 20Y6 Inventory turnover b. Determine the number of days’ sales in inventory for 20Y7 and 20Y6. Use 365 days and round to one decimal place. 20Y7 20Y6 Number of days’ sales in inventory days days c. Are the changes in inventory turnover and the number of days’ sales in inventory from 20Y6 to 20Y7 favorable or unfavorable?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 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
- FIFO 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_forwardPeriodic Inventory Using FIFO, LIFO, and Weighted Average Cost Methods The units of an item available for sale during the year were as follows: Jan. 1 Inventory 15 units at $5,000 $75,000 Aug. 7 Purchase 16 units at $5,100 81,600 Dec. 11 Purchase 11 units at $5,300 58,300 42 units $214,900 There are 17 units of the item in the physical inventory at December 31. The periodic inventory system is used. Determine the inventory cost using (a) the first-in, first-out (FIFO) method; (b) the last-in, first-out (LIFO) method; and (c) the weighted average cost method (Round per unit cost to two decimal places and your final answer to the nearest whole dollar). а. First-in, first-out (FIFO) $4 b. Last-in, first-out (LIFO) С. Weighted average costarrow_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