FIFO |
|||
Date |
Purchases |
Cost of Goods Sold |
Balance |
May-07 |
$765 |
$765 |
|
Jun-01 |
$396 |
$369 |
|
Jul-28 |
$765 |
$1,134 |
|
Aug-27 |
$774 |
$360 |
|
LIFO |
|||
Date |
Purchases |
Cost of Goods Sold |
Balance |
May-07 |
$765 |
$765 |
|
Jun-01 |
$396 |
$369 |
|
Jul-28 |
$765 |
$1,134 |
|
Aug-27 |
$918 |
$216 |
|
Moving Average |
|||
Date |
Purchases |
Cost of Goods Sold |
Balance |
May-07 |
$765 |
$765 |
|
Jun-01 |
$396 |
$369 |
|
Jul-28 |
$765 |
$1,134 |
|
Aug-27 |
$838 |
$296 |
--Calculation
FIFO |
|||
Date |
Purchases |
Cost of Goods Sold |
Balance |
39203 |
=85*9 |
=85*9 |
|
37043 |
=44*9 |
=+(85-44)*9 |
|
46935 |
=51*15 |
=((85-44)*9)+(51*15) |
|
46600 |
=((85-44)*9)+(27*15) |
=(51-27)*15 |
|
LIFO |
|||
Date |
Purchases |
Cost of Goods Sold |
Balance |
39203 |
=85*9 |
=85*9 |
|
37043 |
=44*9 |
=+(85-44)*9 |
|
46935 |
=51*15 |
=((85-44)*9)+(51*15) |
|
46600 |
=+(51*15)+(17*9) |
=((85-44-17)*9) |
|
Moving Average |
|||
Date |
Purchases |
Cost of Goods Sold |
Balance |
39203 |
=85*9 |
=85*9 |
|
37043 |
=44*9 |
=+(85-44)*9 |
|
46935 |
=51*15 |
=((85-44)*9)+(51*15) |
|
46600 |
=+(68*12.33) |
=+(85+51-44-68)*12.33 |
Sunland Company uses a perpetual inventory system. Data for product E2-D2 include the following purchases. Date...
Brief Exercise 6-10 Marigold Corp. uses a perpetual inventory system. Data for product E2-D2 include the following purchases. Date Number of Units Unit Price $8 May 7 July 28 15 On June 1, Marigold sold 39 units, and on August 27, 60 more units. Your answer is partially correct. Try again. Prepare the perpetual inventory schedule for the above transactions using FIFO. (Round answers to o decimal places, e.g. 1,250.) Product E2-D2 Purchases Cost of Goods Sold Date Balance May...
|Buffalo Industries uses a perpetual inventory system. Data for product E2-D2 includes the following purchases. Date Number of Units Unit Price $14 40 May 7 30 19 July 28 On June 1, Buffalo 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: tA Compute the cost of goods sold using FIFO, LIFO, and...
Sandhill Co. uses a perpetual inventory system. Data for
product E2-D2 includes the following purchases.
Date
Number of Units
Unit Price
May 7
48
$14
July 28
36
19
On June 1, Sandhill sold 24 units, and on August 27, 36 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:
$enter a dollar amount
Aug. 27 sale:
$enter a dollar amount
Compute the cost of...
Sandhill Co. uses a perpetual inventory system. Data for product E2-D2 includes the following purchases. Date Number of Units Unit Price May 7 48 $14 July 28 36 19 On June 1, Sandhill sold 24 units, and on August 27, 36 more units. X Your answer is incorrect. Calculate the average cost of the goods sold in the sale. (Round answers to 3 decimal places, e.g. 5.125.) June 1 sale: $ 336 Aug. 27 sale: $ 23.720 Compute the cost...
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...
Bramble Department Store uses a perpetual inventory system. Data for product E2-D2 include the following purchases. Number of Units 50 30 Unit Price Date May 7 July 28 On June 1, Bramble sold 20 units, and on August 27, 40 more units. $12 15 We were unable to transcribe this image
Brief Exercise 6A-4 The following is a record of Windsor Company's transactions for the month of May 2017 May 1 12 Balance 410 units @ $22 Purchase 570 units @ $25 May 10 20 Sale 300 units @ $39 Sale 510 units @ $39 Compute the cost of ending inventory using the moving-average method. (Round average cost per unit to 3 decimal places, Ending inventory $ LINK TO TEXT Brief Exercise 6A-3 The following is a record of Teal Company's...
.....................
LIFO Perpetual Inventory The beginning inventory at Dunne Co. and data on purchases and sales for a three-month period are as follows: Number Total of Units Date Transaction Per Unit 375 24,750 Apr. 3 Inventory 66 Purchase 8 132 450 59,400 11 Sale 88 1,250 110,000 30 Sale 55 1,250 68,750 Purchase 55,000 May 8 110 500 Sale 10 66 1,250 82,500 Sale 19 33 1,250 41,250 550 Purchase 28 110 60,500 Sale June 5 66 1,315 86,790 Sale...
Sunland Co. began operations on July 1. It uses a perpetual inventory system. During July, the company had the following purchases and sales. Purchases Unit Cost Units Sales Units $150 Date July 1 July 6 July 11 July 14 July 21 July 27 $164 $175 Calculate the average cost per unit at July 1, 6, 11, 14, 21 & 27. (Round answers to 2 decimal places, e.g. $105.50.) Average cost for each unit July 1 July 6 July 11 July...
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...