Question

In: Accounting

Kaleta Company reports the following for the month of June. Date Explanation Units Unit Cost Total...

Kaleta Company reports the following for the month of June.

Date

Explanation

Units

Unit Cost

Total Cost

June 1 Inventory 332 $7 $2,324
12 Purchase 664 8 5,312
23 Purchase 498 9 4,482
30 Inventory 166


Assume a sale of 730 units occurred on June 15 for a selling price of $10 and a sale of 598 units on June 27 for $11.

Calculate cost of goods available for sale.  

The cost of goods available for sale

$12,118

Calculate Moving-Average unit cost for June 1, 12, 15, 23 & 27. (Round answers to 3 decimal places, e.g. 2.525.)

June 1 $

  

June 12 $
June 15 $
June 23 $
June 27 $

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 730 units occurred on June 15 for a selling price of $10 and a sale of 598 units on June 27 for $11. (Round answers to 0 decimal places, e.g. 1,250.)

FIFO

LIFO

Moving-Average Cost

The cost ending inventory $ $ $
The cost of goods sold $ $ $

Solutions

Expert Solution

Solution : 1
FIFO METHOD PURHASES COST OF GOODS SOLD INVENTORY ON HAND
Date Particulars Units Rate Total Cost Units Rate Total Cost Units Rate Total Cost
June,01 Beginning inventory 332 $           7.00 $         2,324
June,12 Purchases 664 $                       8.00 $                   5,312 332 $           7.00 $         2,324
664 $           8.00 $         5,312
June,15 Sales 332 $               7.00 $           2,324
398 $               8.00 $           3,184 266 $           8.00 $         2,128
June,23 Purchases 498 $                       9.00 $                   4,482 266 $           8.00 $         2,128
498 $           9.00 $         4,482
June,27 Sales 266 $               8.00 $           2,128
332 $               9.00 $           2,988 166 $           9.00 $         1,494
Total 1162 $9,794 1328 $10,624 166 $         1,494
LIFO METHOD PURHASES COST OF GOODS SOLD CLOSING BALANCE
June,01 Beginning inventory 332 $           7.00 $         2,324
June,12 Purchases 664 $                       8.00 $                   5,312 332 $           7.00 $         2,324
664 $           8.00 $         5,312
June,15 Sales 664 $               8.00 $           5,312
66 $               7.00 $               462 266 $           7.00 $         1,862
June,23 Purchases 498 $                       9.00 $                   4,482 266 $           7.00 $         1,862
498 $           9.00 $         4,482
June,27 Sales 498 $               9.00 $           4,482
100 $               7.00 $               700 166 $           7.00 $         1,162
Total 1162 $9,794 1328 $10,956 166 $         1,162
Solution : 3
Moving Average Cost Method PURHASES COST OF GOODS SOLD CLOSING BALANCE
Date Particulars Units Rate Total Cost Units Rate Total Cost Units Rate Total Cost
June,01 Beginning inventory 332 $         7.000 $         2,324
June,12 Purchases 664 $                       8.00 $                   5,312 996 $         7.667 $         7,636
June,15 Sales 730 $             7.667 $           5,597 266 $         7.667 $         2,039
June,23 Purchases 498 $                       9.00 $                   4,482 764 $         8.536 $         6,522
June,27 Sales 598 $             8.536 $           5,105 166 $         8.536 $         1,417
Total 1162 $9,794 1328 $10,701 166 $         1,417
Answer = 1, 2 & 3 FIFO LIFO Weighted Avg. Method

Related Solutions

Kaleta Company reports the following for the month of June. Date Explanation Units Unit Cost Total...
Kaleta Company reports the following for the month of June. Date Explanation Units Unit Cost Total Cost June 1 Inventory 332 $7 $2,324 12 Purchase 664 8 5,312 23 Purchase 498 9 4,482 30 Inventory 166 Assume a sale of 730 units occurred on June 15 for a selling price of $10 and a sale of 598 units on June 27 for $11. Calculate cost of goods available for sale.   The cost of goods available for sale $12,118 Calculate Moving-Average...
Exercise 6-16 Kaleta Company reports the following for the month of June. Date Explanation Units Unit...
Exercise 6-16 Kaleta Company reports the following for the month of June. Date Explanation Units Unit Cost Total Cost June1 Inventory 358 $6 $2,148 12 Purchase 716 7 5,012 23 Purchase 537 8 4,296 30 Inventory 179 Assume a sale of 788 units occured on June 15 for selling of price $9 and a sale of 644 units on June 27 for $10. Calculate cost of goods available for sale The Cost of goods available for sale $_______________ Calculate Moving-Average...
Humphries Company reports the following for the month of June. Date Explanation Units Unit Cost Total...
Humphries Company reports the following for the month of June. Date Explanation Units Unit Cost Total Cost June 1 Inventory 200 $5 $1 000 12 Purchase 300 6 1 800 23 Purchase 500 7 3 500 30 Inventory 160 Instructions Assume a sale of 400 units occurred on 15 June for a selling price of $8 and a sale of 440 units on 27 June for $9. Assume that a perpetual inventory system is used. Using FIFO, calculate: (a) the...
Plato Company reports the following for the month of June. Date Explanation Units Unit Cost Total...
Plato Company reports the following for the month of June. Date Explanation Units Unit Cost Total Cost June 1 Inventory 225 $5 $1,125 12 Purchase 375 6 2,250 23 Purchase 500 7 3,500 30 Inventory 180 A) Compute the cost of the ending inventory and the cost of good sold under (1) FIFO, (2) LIFO, (3) average cost B) Which costing method gives the highest ending inventory? the highset cost of goods sold? why? C) How do the average cost...
Plato Company reports the following for the month of June. Date Explanation Units Unit Cost Total...
Plato Company reports the following for the month of June. Date Explanation Units Unit Cost Total Cost June   1 Inventory 225 $5 $1,125         12 Purchase 525 6 3,150         23 Purchase 750 7 5,250         30 Inventory 330 Instructions (a)    Calculate the cost of the ending inventory and the cost of goods sold for each cost flow assumption [LIFO,FIFO], using a perpetual inventory system. Assume a sale of 570 units occurred on June 15 for a selling price of...
Johnson Company reports the following for the month of June. Date Explanation Units Unit Cost Total...
Johnson Company reports the following for the month of June. Date Explanation Units Unit Cost Total Cost June 1 Inventory 225 $5 $1,125 12 Purchase 525 6 3,150 23 Purchase 750 7 5,250 30 Inventory 280 Compute the cost of the ending inventory and the cost of goods sold under FIFO, LIFO, and average cost. (Round average cost per unit to 2 decimal places, e.g. 5.25 and final answers to 0 decimal places, e.g. 2,520.) FIFO LIFO AVERAGE COST Ending...
Eastland Company reports the following for the month of June. Date Explanation Units Unit cost Total...
Eastland Company reports the following for the month of June. Date Explanation Units Unit cost Total cost Jun-01 Inventory 252 4 1,008 12 Purchase 378 9 3,402 23 Purchase 630 12 7,560 30 Inventory 202 Compute the cost of the ending inventory and the cost of goods sold under FIFO and LIFO. Do not copy from Chegg, otherwise, I have to report the answer.
Swifty Company reports the following for the month of June. Date Explanation Units Unit Cost Total...
Swifty Company reports the following for the month of June. Date Explanation Units Unit Cost Total Cost June 1 Inventory 315 $7 $2,205 12 Purchase 735 8 5,880 23 Purchase 1,050 9 9,450 30 Inventory 392 Compute the cost of the ending inventory and the cost of goods sold under FIFO, LIFO, and average cost. (Round average cost per unit to 2 decimal places, e.g. 5.25 and final answers to 0 decimal places, e.g. 2,520.) FIFO LIFO AVERAGE COST Ending...
Jennifer Company reports the following for the month of June. Date Explanation Units Unit Cost Total...
Jennifer Company reports the following for the month of June. Date Explanation Units Unit Cost Total Cost June 1 Inventory 500 $5 $2,500 12 Purchase 800 6 4,800 23 Purchase 1,000 7 7,000 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 870 units occurred on June 15 for a selling price of $8 and a sale of 900 units on June...
Pronghorn Corp reports the following for the month of June. Date Explanation Units Unit Cost Total...
Pronghorn Corp reports the following for the month of June. Date Explanation Units Unit Cost Total Cost June 1 Inventory 120 $5 $600 12 Purchases 346 6 2,076 23 Purchases 189 7 1,323 30 Inventory 229 A sale of 375 units occurred on June 15 for a selling price of $8 and a sale of 51 units on June 27 for $9. Calculate the average cost per unit, using a perpetual inventory system. (Round answers to 3 decimal places, e.g....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT