Question

In: Accounting

Exercise 6-9 Monty Corp. uses the periodic inventory system and reports the following for the month...

Exercise 6-9 Monty Corp. uses the periodic inventory system and reports the following for the month of June. Units Unit Cost Total Cost June 1 Inventory 310 $6 $ 1,860 12 Purchase 620 7 4,340 23 Purchase 465 11 5,115 30 Inventory 155

Compute the cost of the ending inventory and the cost of goods sold using the average-cost method.

Will the results in (a) be higher or lower than the results under FIFO and LIFO?

(Poster request: Please show steps)

Solutions

Expert Solution

WEIGHTED AVERAGE METHOD

DATE RECEIPTS ISSUE BALANCE
UNITS UNIT COST TOTAL COST UNITS UNIT COST TOTAL COST UNITS TOTAL COST
1 JUNE 310 $1860
12 JUNE 620 $7 $4340 930 $6200
20 JUNE 465 $11 $5115 1395 $11315
30 JUNE 1240 $8.1 $10044 155 $1271

Note : As Sales aren't mentioned, I assumed the sales on 30 June

WORKING NOTE:

CALCULATION OF PRICE FOR ISSUE ISSUE PRICE =

COST OF GOOD SOLD = $10044

INVENTORY IN END = 155= $1271

2 FIFO METHOD

DATE PURCHASES SALES BALANCE
UNITS UNIT COST TOTAL COST UNITS UNIT COST TOTAL COST UNITS UNIT COST TOTAL COST
1 JUNE 310 $6 $1860
12 JUNE 620 $7 $4340 310 $6 $1860
620 $7 $4340
23 JUNE 465 $11 $5115 310 $6 $1860
620 $7 $4340
465 $11 $5115
30 JUNE 310 $6 $1860 155 $11 $1705
620 $7 $4340
310 $11 $3410

Note : As Sales aren't mentioned, I assumed the sales on 30 June

COST OF GOOD SOLD = $1860 + $4340 + $3410 = $9610

INVENTORY IN END = 155*$11=$1705

3 LIFO METHOD

DATE PURCHASES SALES BALANCE
UNITS UNIT COST TOTAL COST UNITS UNIT COST TOTAL COST UNITS UNIT COST TOTAL COST
1 JUNE 310 $6 $1860
12 JUNE 620 $7 $4340 310 $6 $1860
620 $7 $4340
23 JUNE 465 $11 $5115 310 $6 $1860
620 $7 $4340
465 $11 $5115
30 JUNE 465 $11 $5115 155 $6 $930
620 $7 $4340
155 $6 $930

Note : As Sales aren't mentioned, I assumed the sales on 30 June

COST OF GOOD SOLD = $5115 + $4340 + $930 = $10385

INVENTORY IN END = 155* $6 = $930

Conclusion:

  • COGS under LIFO method is higher than the COGS under Average Cost Method.
  • COGS under FIFO method is lower than the COGS under Average Cost Method.
  • Ending Inventory under LIFO method is lower than the Ending Inventory under Average Cost Method.
  • Ending Inventory under FIFO method is higher than the Ending Inventory under Average Cost Method

.

We were unable to transcribe this image

We were unable to transcribe this image


Related Solutions

Exercise 6-7 Bramble Corp. uses the periodic inventory system and reports the following for the month...
Exercise 6-7 Bramble Corp. uses the periodic inventory system and reports the following for the month of June. Units Unit Cost Total Cost June 1 Inventory 264 $5 $ 1,320 12 Purchase 528 7 3,696 23 Purchase 396 11 4,356 30 Inventory 132 a. Compute the cost of the ending inventory and the cost of goods sold under FIFO and LIFO. b. Which costing method gives the higher ending inventory? c. Which method results in the higher cost of goods...
Grouper Corp. uses a periodic inventory system and reports the following for the month of June....
Grouper Corp. uses a periodic inventory system and reports the following for the month of June. Date Explanation Units Unit Cost Total Cost June 1 Inventory 130 $5 $ 650 12 Purchases 400 6 2,400 23 Purchases 220 7 1,540 30 Inventory 250 Calculate weighted-average unit cost. (Round answer to 3 decimal places, e.g. 5.125.) Weighted-average unit cost $ 6.120 Compute the cost of the ending inventory and the cost of goods sold under FIFO, LIFO, and average-cost. (Round answers...
Bridgeport Corp. uses a periodic inventory system reports the following for the month of June. Date...
Bridgeport Corp. uses a periodic inventory system reports the following for the month of June. Date Explanation Units Unit Cost Total Cost June 1 Inventory 112 $5 $560 12 Purchases 336 6 2016 23 Purchases 190 7 1330 30 Inventory 200 A sale of 388 units occurred on June 15 for a selling price of $8 and a sale of 50 units on June 27 for $9. Calculate the average cost per unit, using a perpetual inventory system. (Round answers...
Exercise 6-14 a-b1 (Part Level Submission) Cheyenne Corp. uses a periodic inventory system reports the following...
Exercise 6-14 a-b1 (Part Level Submission) Cheyenne Corp. uses a periodic inventory system reports the following for the month of June. Date Explanation Units Unit Cost Total Cost June 1 Inventory 130 $5 $650 12 Purchases 390 6 2,340 23 Purchases 240 7 1,680 30 Inventory 354 A sale of 360 units occurred on June 15 for a selling price of $9 and a sale of 46 units on June 27 for $10. (a) Your answer is correct. Calculate the...
Monty Corp. uses the periodic inventory system and had 150 units in beginning inventory at a...
Monty Corp. uses the periodic inventory system and had 150 units in beginning inventory at a total cost of $15,000. The company purchased 300 units at a total cost of $39,000. At the end of the year, Monty had 80 units in ending inventory. Compute the cost of the ending inventory and the cost of goods sold under FIFO, LIFO, and average-cost. (Round average-cost per unit and final answers to 0 decimal places, e.g. 1,250.) FIFO LIFO Average-cost The cost...
1. Jeters Company uses a periodic inventory system and reports the following for the month of...
1. Jeters Company uses a periodic inventory system and reports the following for the month of September. Date Explanation Units Unit Cost Total Cost 9/1 Inventory 120    $5 $ 600 9/12 Purchases 370      6 2.220 9/23 Purchases 200    7 1,400 9/30 Inventory 230 Instructions Compute the cost of ending inventory and the cost of goods sold using the FIFO, LIFO, and average-cost methods. (Round average unit cost to three decimal places) Which costing method gives the highest ending...
AP Jeters Company uses a periodic inventory system and reports the following for the month of...
AP Jeters Company uses a periodic inventory system and reports the following for the month of June. Date Explanation Units Unit cost Total cost June 1 Inventory 120 $5 $600 June 12 Purchase 370 $6 $2200 June 23 Purchase 200 $7 $1400 June 30 Inventory 230 Instructions a. Compute the cost of the ending inventory and the cost of goods sold under (1) FIFO, (2) LIFO, and (3) average-cost. (Round average unit cost to three decimal places.) b. Which costing...
Swifty Corporation uses a periodic inventory system and reports the following for the month of June....
Swifty Corporation uses a periodic inventory system and reports the following for the month of June. Date Explanation Units Unit Cost Total Cost June 1 Inventory 140 $5 $ 700 12 Purchase 390 6 2,340 23 Purchase 190 7 1,330 30 Inventory 193 a) Compute the cost of the ending inventory and the cost of goods sold under FIFO, LIFO, and average-cost. (Round per unit cost to 3 decimal places, e.g. 15.647 and final answers to 0 decimal places, e.g....
Jeters Company uses a periodic inventory system and reports the following for the month of June....
Jeters Company uses a periodic inventory system and reports the following for the month of June. Date Explanation Units Unit Cost Total Cost June 1 Inventory 120 $5 $600 12 Purchase 370 6 2,220 23 Purchase 200 7 1,400 30 Inventory 230 Instructions a. Compute the cost of the ending inventory and the cost of goods sold under (1) FIFO, (2) LIFO, and (3) average-cost. (Round average unit cost to three decimal places.) b. Which costing method gives the highest...
Kaleta Company uses the periodic inventory system and reports the following for the month of June....
Kaleta Company uses the periodic inventory system and reports the following for the month of June. Units Unit Cost Total Cost Units Unit Cost Total Cost June 1 Inventory   200    $5 $1,000 June 12 Purchase 400     6 2,400 June 23 Purchase 300    7 2,100 June 30th Inventory 100 Compute the cost of ending inventory and the cost of goods sold using the average-cost method. (Round answers to 0 decimal places) The ending inventory $________ The Cost of...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT