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 goods
sold for each cost flow assumption, using a perpetual inventory
system. (Round average-cost per unit to 3 decimal
places, e.g. 2.525 and final answers to 0 decimal places, e.g.
1,250.)
FIFO |
LIFO |
Moving-Average Cost |
||||
The cost ending inventory | $ | $ | $ | |||
The cost of goods sold | $ | $ | $ |
If it is helpful, please rate the answer and if any doubt arises let me know
FIFO | LIFO | Moving Average | |||||||
The cost of ending inventory | $ 700 | $ 500 | $ 654 | ||||||
The cost of goods sold | $ 4,800 | $ 5,000 | $ 4,846 | ||||||
Workings: | |||||||||
FIFO | |||||||||
Date | Cost of goods available for sale | Cost of goods sold | Ending Inventory | ||||||
Jun-01 | 200 | $ 5.00 | $ 1,000 | ||||||
Jun-12 | 400 | $ 6.00 | $ 2,400 | 200 | $ 5.00 | $ 1,000 | |||
400 | $ 6.00 | $ 2,400 | |||||||
Jun-15 | 200 | $ 5.00 | $ 1,000 | 160 | $ 6.00 | $ 960 | |||
240 | $ 6.00 | $ 1,440 | |||||||
Jun-23 | 300 | $ 7.00 | $ 2,100 | 160 | $ 6.00 | $ 960 | |||
300 | $ 7.00 | $ 2,100 | |||||||
Jun-27 | 160 | $ 6.00 | $ 960 | 100 | $ 7.00 | $ 700 | |||
200 | $ 7.00 | $ 1,400 | |||||||
Totals | 700 | 4,500 | 800 | 4,800 | 100 | 700 | |||
LIFO | |||||||||
Date | Cost of goods available for sale | Cost of goods sold | Ending Inventory | ||||||
Jun-01 | 200 | $ 5.00 | $ 1,000 | ||||||
Jun-12 | 400 | $ 6.00 | $ 2,400 | 200 | $ 5.00 | $ 1,000 | |||
400 | $ 6.00 | $ 2,400 | |||||||
Jun-15 | 400 | $ 6.00 | $ 2,400 | 160 | $ 5.00 | $ 800 | |||
40 | $ 5.00 | $ 200 | |||||||
Jun-23 | 300 | $ 7.00 | $ 2,100 | 160 | $ 5.00 | $ 800 | |||
300 | $ 7.00 | $ 2,100 | |||||||
Jun-27 | 300 | $ 7.00 | $ 2,100 | 100 | $ 5.00 | $ 500 | |||
60 | $ 5.00 | $ 300 | |||||||
Totals | 700 | 4,500 | 800 | 5,000 | 100 | 500 | |||
Moving - Average | |||||||||
Date | Cost of goods available for sale | Cost of goods sold | Ending Inventory | ||||||
Jun-01 | 200 | $ 5.000 | $ 1,000 | ||||||
Jun-12 | 400 | $ 6.000 | $ 2,400 | 200 | $ 5.000 | $ 1,000 | |||
400 | $ 6.000 | $ 2,400 | |||||||
Net | 600 | $ 5.667 | $ 3,400 | ||||||
Jun-15 | 440 | $ 5.667 | $ 2,493 | 160 | $ 5.667 | $ 907 | |||
Jun-23 | 300 | $ 7.000 | $ 2,100 | 160 | $ 5.667 | $ 907 | |||
Net | 300 | $ 7.000 | $ 2,100 | ||||||
460 | $ 6.536 | $ 3,007 | |||||||
Jun-27 | 360 | $ 6.536 | $ 2,353 | 100 | $ 6.536 | $ 654 | |||
Totals | 700 | 4,500 | 800 | 4,846 | 100 | 654 |
Kaleta Company uses the perpetual inventory system and reports the following for the month of 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...
Bonita Company reports the following for the month of June. Date Explanation Units Unit Cost Total Cost June 1 Inventory 200 $3 $600 12 Purchase 400 6 2,400 23 Purchase 400 7 2,800 30 Inventory 50 Assume a sale of 500 units occurred on June 15 for a selling price of $8 and a sale of 450 units on June 27 for $9. Your answer is correct. Calculate cost of goods available for sale. The cost of goods available for...
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...
Novak Corp. uses the periodic inventory system and reports the following for the month of June. Units Unit Cost Total Cost June 1 Inventory 440 $4 $ 1,760 12 Purchase 880 8 7,040 23 Purchase 660 12 7,920 30 Inventory 220 Calculate Weighted Average Unit Cost. (Round answer to 2 decimal places, e.g. 15.25.) Weighted Average Unit Cost $8.44 Compute the cost of the ending inventory and the cost of goods sold using the average-cost method. (Round answers to 0...
Bonita Company reports the following for the month of June.DateExplanationUnitsUnit CostTotal CostJune 1Inventory200$3$60012Purchase40062,40023Purchase40072,80030Inventory50Assume a sale of 500 units occurred on June 15 for a selling price of $8 and a sale of 450 units on June 27 for $9.Calculate cost of goods available for sale.The cost of goods available for sale $5800Calculate Moving-Average unit cost for June 1, 12, 15, 23 & 27.(Round answers to 3 decimal places, e.g. 2.525.)Calculate the cost of the ending inventory and the cost of...
Exercise 6-17 (Part Level Submission) Kaleta Company uses the perpetual inventory system and reports the following for the month of June. Date Unit Cost June 1 12 Explanation Inventory Purchase Purchase Inventory Units 200 400 Total Cost $1,000 2,400 2,100 6 7 23 300 30 100 OLCA! O LOULOU O olluin - 0 C El O CLIC Assume a sale of 440 units occurred on June 15 for a selling price of $8 and a sale of 360 units on...
Patricia Company reports the following for the month of June. Date Explanation Units Unit Cost Total Cost June 1 Inventory 340 $5 $1,700 12 Purchase 640 6 3,840 23 Purchase 840 7 5,880 Calculate the cost of the ending inventory and the cost of goods sold for each cost flow assumption, using a perpetual inventory system. Assume a sale of 710 units occurred on June 15 for a selling price of $8 and a sale of 740 units on June...
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...
Can you Show the work please? Karen Company reports the following for the month of June. Unit Units Total Cost Date Explanation Cost $4 $2,160 June 1 Inventory 540 12 Purchase 840 5,040 6 23 Purchase 8,320 1,040 Calculate the cost of the ending inventory and the cost of goods sold for each cost flow assumption, using a perpetual inventory system. Assume a sale of 910 units occurred on June 15 for a selling price of $8 and a sale...
Skysong, Inc. reports the following for the month of June. Date Explanation Units Unit Cost Total Cost June 1 Inventory 250 $8 $2,000 12 Purchase 500 9 4,500 23 Purchase 375 10 3,750 30 Inventory 125 Assume a sale of 550 units occurred on June 15 for a selling price of $11 and a sale of 450 units on June 27 for $12. Calculate the cost of the ending inventory and the cost of goods sold for each cost flow...