Question

Consider the following information for Maynor Company, which uses a periodic inventory system:

Transaction Units Unit Cost Total Cost
January 1 Beginning
Inventory 29 $ 79 $ 2,291
March 28 Purchase 39 85 3,315
August 22 Purchase 58 89 5,162
October 14 Purchase 63 95 5,985
Goods Available for Sale 189 $ 16,753
The company sold 63 units on May 1 and 58 units on October 28.
Required:
Calculate the company's ending inventory and cost of goods sold using the each of following inventory costing methods. (Round the per unit cost to two decimal places and then round your answer to the nearest whole dollar.)
a. FIFO:
b. LIFO:
c. Weighted Average

Answer 1

Instructions are below.

Step-by-step explanation:

Giving the following information:

January 1 Beginning Inventory 29 $79 $2,291

March 28 Purchase 39 $85 3,315

August 22 Purchase 58 $89 5,162

October 14 Purchase 63 $95 5,985

The company sold 63 units on May 1 and 58 units on October 28.

First, we need to calculate the units in ending inventory:

Ending inventory in units= 189 - 121= 68

To calculate the ending inventory under the FIFO (first-in, first-out) method, we need to use the cost of the last units incorporated into inventory.

Ending inventory= 63*95 + 5*89= $6,430

COGS= 29*79 + 39*85 + 53*89= $10,323

To calculate the ending inventory under the LIFO (last-in, first-out) method, we need to use the cost of the first units incorporated into the inventory

Ending inventory= 29*79 + 39*85= $5,606

COGS= 63*95 + 58*89= $11,147

Finally, to calculate the ending inventory using the weighted-average, we need to calculate the weighted average price:

weighted average price= 16,753/189= $88.64

Ending inventory= 68*88.64= $6,027.52

COGS= 121*88.64= $10,725.44