Question
Calculate the cost of ending inventory and the cost of goods sold under the (a) FIFO b) LIFO, and (c) weighted average cost methods. (Do not round your intermediate calculations. Round "Weighted Average Cost" to 2 decimal places.)

Spotter Corporation reporteu le IUIUWING TUI JUIC E Date Description Units Unit Cost June 1 Beginning 24 $11.20 11 Purchase 4
2. Which of the three methods will lead to reporting the highest net income? FIFO LIFO Weighted Average Cost
1 0
Add a comment Improve this question Transcribed image text
Answer #1
  • Requirement 1

Methods

Ending Inventory

Cost of Goods Sold

FIFO

$                  560.00

$                     708.00

LIFO

$                  464.00

$                     804.00

Weighted average cost

$                  507.20

$                     760.80

  • Requirement 2

Highest Net Income

FIFO

because prices are rising and ending inventory is inflated and cost of goods sold is less, which leads to higher gross profits and higher net income.

  • Working

FIFO

Cost of Goods available for sale

Cost of Goods Sold

Ending Inventory

Units

Cost/unit

COG for sale

Units sold

Cost/unit

COGS

Units

Cost/unit

Ending inventory

Beginning Inventory

24

$                11.20

$                            268.80

24

$               11.20

$                     268.80

0

$                 11.20

$                         -  

Purchases:

11-Jun

40

$                12.20

$                            488.00

36

$               12.20

$                     439.20

4

$                 12.20

$                  48.80

24-Jun

36

$                14.20

$                            511.20

0

$               14.20

$                              -  

36

$                 14.20

$                511.20

TOTAL

100

$                        1,268.00

60

$                     708.00

40

$                560.00

LIFO

Cost of Goods available for sale

Cost of Goods Sold

Ending Inventory

Units

Cost/unit

COG for sale

Units sold

Cost/unit

COGS

Units

Cost/unit

Ending inventory

Beginning Inventory

24

$                11.20

$                            268.80

0

$               11.20

$                              -  

24

$                 11.20

$                268.80

Purchases:

11-Jun

40

$                12.20

$                            488.00

24

$               12.20

$                     292.80

16

$                 12.20

$                195.20

24-Jun

36

$                14.20

$                            511.20

36

$               14.20

$                     511.20

0

$                 14.20

$                         -  

TOTAL

100

$                        1,268.00

60

$                     804.00

40

$                464.00

Average Method

Cost of Goods available for sale

Cost of Goods Sold

Ending Inventory

Units

Cost/unit

COG for sale

Units sold

Cost/unit

COGS

Units

Cost/unit

Ending inventory

Beginning Inventory

24

$                11.20

$                            268.80

Purchases:

11-Jun

40

$                12.20

$                            488.00

24-Jun

36

$                14.20

$                            511.20

TOTAL

100

$              12.680

$                        1,268.00

60

$          12.6800

$                     760.80

40

$            12.6800

$                507.20

Add a comment
Know the answer?
Add Answer to:
Calculate the cost of ending inventory and the cost of goods sold under the (a) FIFO...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Spotter Corporation reported the following for June in its periodic inventory records. Date Description Units Unit...

    Spotter Corporation reported the following for June in its periodic inventory records. Date Description Units Unit Cost Total Cost June 1 Beginning 24 $ 11.20 $ 268.80 11 Purchase 40 12.20 488.00 24 Purchase 36 14.20 511.20 30 Ending 40 Required: Calculate the cost of ending inventory and the cost of goods sold under the (a) FIFO, (b) LIFO, and (c) weighted average cost methods

  • Spotter Corporation reported the following for June in its periodic inventory records. Units 17 Date June...

    Spotter Corporation reported the following for June in its periodic inventory records. Units 17 Date June 1 11 24 30 Description Beginning Purchase Purchase Ending Unit Cost $10.20 11.20 13.20 Total Cost $173.40 302.40 409.20 27 31 35 Required: 1. Calculate the cost of ending inventory and the cost of goods sold under the (a) FIFO, (b) LIFO, and (c) weighted average cost methods. (Round your intermediate calculations and final answers to 2 decimal places.) Cost of Ending Cost of...

  • Spotter Corporation reported the following for June in its periodic inventory records, Units 15 Date Description...

    Spotter Corporation reported the following for June in its periodic inventory records, Units 15 Date Description June 1 Beginning 11 Purchase 24 Purchase 30 Ending Unit Cost $ 9.80 10.80 12.80 Total cost $147.00 604.80 371.29 Required: 1. Calculate the cost of ending inventory and the cost of goods sold under the (a) FIFO. (6) LIFO, and (c) weighted average cost methods. (Do not round your intermediate calculations. Round "Weighted Average Cost" to 2 decimal places.) Cost of Ending Cost...

  • Calculate ending inventory, cost of goods sold, gross profit under each of the following methods. (1)...

     Calculate ending inventory, cost of goods sold, gross profit under each of the following methods. (1) LIFO. (2) FIFO. (3) Average-cost. (Round answers to O decimal place, e.g. 125.) Calculate gross profit rate under each of the following methods. (1) LIFO. (2) FIFO. (3) Average-cost. (Round answers to 1 decimal place, e.g. 51.2%) You have the following information for Nash's Trading Post, LLC for the month ended October 31, 2022. Nash uses a periodic method for inventory. Calculate the weighted-average cost. (Round answer to 3 decimal places, e.g....

  • E7-6 (Algo) Calculating Ending Inventory and Cost of Goods Sold Under FIFO, LIFO, and Average Cost...

    E7-6 (Algo) Calculating Ending Inventory and Cost of Goods Sold Under FIFO, LIFO, and Average Cost LO7-2 Hamilton Company uses a periodic inventory system. At the end of the annual accounting period, December 31 of the current year, the accounting records provided the following information for product 1: Units Unit Cost $5 1,830 Inventory, December 31, prior year For the current year: Purchase, March 21 Purchase, August 1 Inventory, December 31, current year 6,130 4,130 2,810 2 Required: Compute ending...

  • M7-10 Calculating Cost of Goods Available for Sale, Cost of Goods Sold, and Ending Inventory under FIFO, LIFO, and Weig...

    M7-10 Calculating Cost of Goods Available for Sale, Cost of Goods Sold, and Ending Inventory under FIFO, LIFO, and Weighted Average Cost (Periodic Inventory) (LO 7-3] Aircard Corporation tracks the number of units purchased and sold throughout each accounting period but applies its inventory costing method at the end of each period as if it uses a periodic inventory system. The following are the transactions for the month of July. Unit Cost $20 July 1 July 5 July 13 July...

  • E7-6 (Algo) Calculating Ending Inventory and Cost of Goods Sold Under FIFO, LIFO, and Average Cost...

    E7-6 (Algo) Calculating Ending Inventory and Cost of Goods Sold Under FIFO, LIFO, and Average Cost LO7-2 Hamilton Company uses a periodic inventory system. At the end of the annual accounting period, December 31 of the current year, the accounting records provided the following information for product 1: Unit Units Cost Inventory, December 31, prior 1,980 $8 year For the current year: Purchase, March 21 Purchase, August 1 Inventory, December 31, current 6,090 4,150 7 2,840 year Required: Compute ending...

  • E7-5 (Algo) Calculating Ending Inventory and Cost of Goods Sold Under FIFO, LIFO, and Average Cost...

    E7-5 (Algo) Calculating Ending Inventory and Cost of Goods Sold Under FIFO, LIFO, and Average Cost LO7-2 Nittany Company uses a periodic inventory system. At the end of the annual accounting period, December 31 of the current year, the accounting records provided the following information for product 1: Units Unit Cost $5 1,930 Inventory, December 31, prior year For the current year: Purchase, March 21 Purchase, August 1 Inventory, December 31, current year 7 5,080 2,830 4,040 Required: Compute ending...

  • Spotter Corporation reported the following for June in its periodic inventory records. Date Description Units Unit...

    Spotter Corporation reported the following for June in its periodic inventory records. Date Description Units Unit Cost Total Cost June 1 Beginning 12 $ 8 $ 96 11 Purchase 38 9 342 24 Purchase 20 11 220 30 Ending 24 Required: Calculate the cost of ending inventory and the cost of goods sold under the (a) FIFO, (b) LIFO, and (c) weighted average cost methods. (Do not round your intermediate calculations. Round "Weighted Average Cost" to 2 decimal places.)

  • just answer requird 3 E7-5 Calculating Cost of Ending Inventory and Cost of Goods Sold under...

    just answer requird 3 E7-5 Calculating Cost of Ending Inventory and Cost of Goods Sold under Periodic FIFO, LIFO, and Weighted Average Cost [LO 7-3) Oahu Kiki tracks the number of units purchased and sold throughout each accounting period but applies its inventory costing method at the end of each month, as if it uses a periodic Inventory system. Assume Oahu Kiki's records show the following for the month of January, Sales totaled 240 units. Beginning Inventory Purchase Purchase Date...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT