Question

In: Accounting

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 $8 and a sale of 600 units on June 27 for $9. (Note: For the average-cost method, round unit cost to three decimal places.)

Solutions

Expert Solution

Given case we are required to calculate cost of goods sold and value of ending inventory using LIFO and FIFO methods :-

Calculation of ending inventory and cost of goods sold using LIFO :-

Date Particulars units (A) cost per unit (B) total amount (A×B)
June 1 opening inventory 225 5 1125
June 12 purchase 525 6 3150
June 15 sale (525) 6 (3150)
Sale (45) 5 (225)
June 23 purchase 750 7 5250
June 27 sale (600) 7 (4200)
June 30 closing inventory (330 units) 150 7 1050
180 5 900

Closing balance as per LIFO = 1050 + 900 = $1950

Cost of goods sold as per LIFO = 3150 + 225 + 4200 = $7575.

Calculation of closing inventory and cost of goods sold as per FIFO :-

Date Particulars units (A) cost per unit (B) amount (A×B)
June 1 opening inventory 225 5 1125
June 12 purchase 525 6 3150
June 15 sale (225) 5 (1125)
Sale (345) 6 (2070)
June 23 purchase 750 7 5250
June 27 sale (180) 6 (1080)
(420) 7 (2940)
June 30 closing inventory 330 7 2310

The value of closing inventory as per FIFO = $2310

cost of goods sold as per FIFO = $1125 + $2070 + $1080 + 2940 = $7215

there is no information in the question that asking the value of closing inventory and cost of goods sold as per weighted average method hence, we ignore it.

These are all the information required to solve the above given question.

if there is any clarifications required regarding the above provided answer, please mention them in comment box.

I hope, all the above mentioned information and explanations are useful and helpful to you.

Thank you.


Related Solutions

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...
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...
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.
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...
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...
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...
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....
Headlands Industries reports the following for the month of June. Date Explanation Units Unit Cost Total...
Headlands Industries reports the following for the month of June. Date Explanation Units Unit Cost Total Cost June 1 Inventory 132 $5 $ 660 12 Purchases 392 6 2,352 23 Purchases 190 7 1,330 30 Inventory 235 Calculate weighted-average unit cost. (Round answer to 3 decimal places, e.g. 5.125.) Weighted-average unit cost $enter a weighted-average unit cost in dollars eTextbook and Media       Compute the cost of the ending inventory and the cost of goods sold under FIFO, LIFO,...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT