Question

Cullumber Company had a beginning inventory on January 1 of 75 units of Product 4-18-15 at a cost of $18 per unit. During the year, the following purchases were made. Mar. 15 200 units at $21 Sept. 4 175 units at $24 July 20 125 units at $22 Dec. 2 50 units at $27 500 units were sold. Cullumber Company uses a periodic inventory system. Determine (1) the ending inventory and (2) the cost of goods sold under each of the assumed cost flow methods (FIFO, LIFO, and average-cost). Prove the accuracy of the cost of goods sold under the FIFO and LIFO methods. (Round answers to 0 decimal places, e.g. 1,250. Use weighted-average unit cost rounded to 2 decimal places for computations.)

Answer 1

Answer:

Weighted average:

EI:            2,290

COGS:     9, 160

LIFO

EI:            2,400

COGS:     9,050

FIFO

EI:            3,000

COGS:     8,450

Explanation:

beginning 75 units at $ 18 = $  1,350

Mar. 15    200 units at $21 =  $ 4,200

Sept. 4    175 units at $24 =  $ 1,800

July 20   125 units at $22 =  $ 2,750

Dec. 2      50 units at $27 =  $ 1,350

total units:  625 units cost of goods available: 11,450

average cost: 11,450/625  =  $ 18.32 per unit

inventory units: 625 - 500 = 125 units

Weighted average:

EI:          125 x $18.32 = 2,290

COGS: 500 x $18.32 = 9, 160

500 units were sold

LIFO:

last units are sold while frist are inventory

ending inventory

beginning 75 units at $ 18 = $  1,350

Mar. 15      50 units at $21 =  $  1,050  

                                  Total      2,400

COGS: available - ending inventory

11,450 - 2,400 = 9,050

FIFO

first units are sold while last are inventory

Dec. 2      50 units at $27 =  $ 1,350

July 20     75 units at $22 =  $ 1,650  

                                  Total      3,000

COGS: available - ending inventory

11,450 - 3,000 = 8,450