FIFO method , perpetual inventory system : | |||||||||
Date | Purchase | Sale ( at cost ) | Balance | ||||||
Units | Unit cost | Total cost | Units | Unit cost | Total cost | Units | Unit cost | Total cost | |
June 1 | 117 | 5 | 585 | ||||||
June 12 | 333 | 6 | 1998 | 117 | 5 | 585 | |||
333 | 6 | 1998 | |||||||
June 15 | 117 | 5 | 585 | 100 | 6 | 600 | |||
233 | 6 | 1398 | |||||||
June 23 | 200 | 7 | 1400 | 100 | 6 | 600 | |||
200 | 7 | 1400 | |||||||
June 27 | 50 | 6 | 300 | 50 | 6 | 300 | |||
200 | 7 | 1400 | |||||||
The cost of ending inventory = 300 + 1400 | 1700 | ||||||||
The cost of goods sold = 585 + 1398 + 300 | 2283 |
LIFO method , perpetual inventory system : | |||||||||
Date | Purchase | Sale ( at cost ) | Balance | ||||||
Units | Unit cost | Total cost | Units | Unit cost | Total cost | Units | Unit cost | Total cost | |
June 1 | 117 | 5 | 585 | ||||||
June 12 | 333 | 6 | 1998 | 117 | 5 | 585 | |||
333 | 6 | 1998 | |||||||
June 15 | 333 | 6 | 1998 | 100 | 5 | 500 | |||
17 | 5 | 85 | |||||||
June 23 | 200 | 7 | 1400 | 100 | 5 | 500 | |||
200 | 7 | 1400 | |||||||
June 27 | 50 | 7 | 350 | 100 | 5 | 500 | |||
150 | 7 | 1050 | |||||||
The cost of the ending inventory = 500 + 1050 | 1550 | ||||||||
The cost of goods sold = 1998 + 85 + 350 | 2433 |
Moving-average method , perpetual inventory system : | |||||||||
Date | Purchase | Sale ( at cost ) | Balance | ||||||
Units | Unit cost | Total cost | Units | Unit cost | Total cost | Units | Unit cost | Total cost | |
June 1 | 117 | 5 | 585 | ||||||
June 12 | 333 | 6 | 1998 | 450 | 5.74 | 2583 | |||
June 15 | 350 | 5.74 | 2009 | 100 | 5.74 | 574 | |||
June 23 | 200 | 7 | 1400 | 300 | 6.58 | 1974 | |||
June 27 | 50 | 6.58 | 329 | 250 | 6.58 | 1645 | |||
The cost of the ending inventory | 1645 | ||||||||
The cost of goods sold = 2009 + 329 | 2338 |
Final answer presentation : | |||
FIFO | LIFO | Moving-Average | |
The cost of the ending inventory | 1700 | 1550 | 1645 |
The cost of goods sold | 2283 | 2433 | 2338 |
Question 13 Carla Vista Co. uses a periodic inventory system reports the following for the month...
Carla Vista Co. uses a periodic inventory system and reports the following for the month of June. Date Explanation Units Unit Cost Total Cost $5 $625 June 1 Inventory 125 12 Purchases 380 6 2,280 Purchases 23 220 1,540 30 Inventory 250 Calculate weighted-average unit cost. (Round answer to 3 decimal places, e.g. 5.125.) $ Weighted-average unit cost 7 Compute the cost of the ending inventory and the cost of goods sold under FIFO, LIFO, and average-cost. (Round answers to...
Carla Vista Co. uses a perpetual inventory system. Data for product E2-D2 includes the following purchases. Date Number of Units Unit Price May 7 40 $13 July 28 30 18 On June 1, Carla Vista sold 20 units, and on August 27, 30 more units. Calculate the average cost of the goods sold in the sale. (Round answers to 3 decimal places, e.g. 5.125.) June 1 sale: Aug. 27 sale: Compute the cost of goods sold using FIFO, LIFO, and...
Show your calculations.
Riverbed Corp uses a perpetual inventory system reports the following for the month of June. Date Explanation Units Unit Cost Total Cost June 1 Inventory 150 $750 12 Purchases 2,100 350 240 Purchases 1,680 Inventory 260 - Your answer is partially correct. Calculate the average cost per unit, using a perpetual inventory system. Assume a sale of 420 units occurred on June 15 for a selling price of $8 and a sale of 60 units on June...
Sandhill Co. uses a perpetual inventory system reports the following for the month of June. Unit Cost Date Explanation Units Total Cost $5 $575 June 1 Inventory 115 12 Purchases 345 2,070 6 Purchases 23 190 1,330 7 30 200 Inventory LLIE! Calculate the average cost per unit, using a perpetual inventory system. (Round answers to 3 decimal places, e.g. 5.125.) $ June 1 $ June 12 $ June 15 $ June 23 $ June 27 eTextbook and Media Calculate...
headlands industries uses a periodic inventory system reports
the following for the month of June.
calculate the average cost per unit, using a perpetual
inventory system.
Units Unit Cost Date June 1 12 23 Explanation Inventory Purchases Purchases Inventory 370 200 Total Cost $650 2,220 1,400 30 300 A sale of 350 units occurred on June 15 for a selling price of $7 and a sale of 50 units on June 27 for $8. (a) your answer is partially correct....
Kaleta Company uses the perpetual inventory system and reports
the following for the month of June.
Date
Explanation
Units
Unit Cost
Total Cost
June 1
Inventory
200
$5
$1,000
12
Purchase
400
6
2,400
23
Purchase
300
7
2,100
30
Inventory
100
Assume a sale of 440 units occurred on June 15 for a selling price
of $8 and a sale of 360 units on June 27 for $9.
Calculate the cost of the ending inventory and the cost of...
Exercise 6-14 a-b1 Teal Mountain Inc. uses a perpetual inventory system reports the following for the month of June. Date Explanation Units Unit Cost Total Cost June 1 Inventory 130 $4 $520 12 Purchases 390 5 1,950 23 Purchases 230 6 1,380 30 Inventory 250 Partially correct answer. Your answer is partially correct. Try again. Calculate the average cost per unit, using a perpetual inventory system. Assume a sale of 450 units occurred on June 15 for a selling price...
Sandhill Co, uses a periodic inventory system and reports the following for the month of June. Date Explanation Units Unit Cost $5 June 1 Inventory 140 Total Cost $ 700 2,100 1,610 Purchases Purchases Inventory Calculate weighted average unit cost. (Round answer to 3 decimal places, e.. 5.125.) Weighted average unit cost $ Compute the cost of the ending inventory and the cost of goods sold under FIFO, LIFO, and average cost. (Round answers to decimal places, es. 125) FIFO...
Windsor, Inc. uses a periodic inventory system. Its records show the following for the month of May, in which 88 units were sold. Unit Cost $14 May 1 Inventory 15 Purchases 24 Purchases Totals Units 41 34 47 Total Cost $574 578 846 $1,998 122 Compute the ending inventory at May 31 and cost of goods sold using the FIFO and LIFO methods. FIFO LIFO Ending inventory at May 31 $ Cost of goods sold
Ballas Co. uses a periodic inventory system. Its records show
the following for the month of May, in which 148 units were
sold.
Unit Units Cost Total Cost May 1 Inventory65 15 Purchases55 24 Purchases 76 196 $9 12 13 $585 660 988 $2,233 Totals Compute the ending inventory at May 31 and cost of goods sold using the FIFO and LIFO methods. FIFO LIFO Ending inventory at May 31 Cost of goods sold