contestada

Rogers Products uses a periodic inventory system. The company’s records show the beginning inventory of PH4 oil filters on January 1 and the purchases of this item during the current year to be as follows. Jan. 1 Beginning inventory 11 units @ $ 3.00 $ 33.00 Feb. 23 Purchase 18 units @ $ 3.50 63.00 Apr. 20 Purchase 28 units @ $ 3.80 106.40 May 4 Purchase 37 units @ $ 4.00 148.00 Nov. 30 Purchase 20 units @ $ 5.00 100.00 Totals 114 units $ 450.40 A physical count indicates 25 units in inventory at year-end. Determine the cost of the ending inventory on the basis of each of the following methods of inventory valuation. a. Average cost. b. FIFO. c. LIFO.

Respuesta :

Answer:

a. Ending inventory value by average method is $ 98.77

b. Ending inventory value by FIFO method is $ 120

c. Ending inventory value by LIFO method is $ 82

Explanation:

Following are three types of Inventory valuation method.

1 ) Average Method : It is calculated by dividing total cost of inventory purchased divided by total units purchased.

In Periodic Inventory system,

Weighted average unit cost = Total cost of materials purchased / Total no.of units purchased.

Given data

Beginning inventory = 11 units

Date                                units             Unit Cost             Total Cost

Beginning inventory         11                      3                         33

Feb-23                               18                    3.5                       63

Apr-20                               28                    3.8                      106.40

May -04                              37                     4                         148

Nov-30                               20                     5                         100        

Total                                   114                                               450.4

Weighted average unit cost = 450.4 / 114 = 3.95

Ending inventory contains 25 units = 25 x 3.95 = 98.77

2) FIFO: FIFO means First in First out. In this type of inventory valuation method, ending inventory is composed of most recently purchased items.

Ending inventory by FIFO method is = (20 x 5) + (5 x 4) = 120.

3) LIFO: LIFO means Last in First out. In this type of inventory valuation method, most recently purchased items or units are issued to the production.

Ending inventory by LIFO method is = (11 x 3) + (14 x 3.5) = 82.

During inflation, FIFO results higher income as the lowest cost items are issued to the production and results higher inventory.    

The cost of the ending inventory using the LIFO method is $78.50.

The cost of the ending inventory using the FIFO method is $120.

The cost of the ending inventory using the average cost method is $98.54.

What is the cost of the ending inventory using the LIFO method?

LIFO means last in first out. It means that it is the last purchased inventory that is the first to be sold. Ending inventory consists of inventory purchased first.

Ending inventory = (11 x $3) + (13 x $3.50) = $78.50

What is the cost of the ending inventory using the FIFO method?

FIFO means first in, first out. It means that it is the first purchased inventory that is the first to be sold. Ending inventory consists of inventory purchased last.

Ending inventory = (20 x $5) + (5 x $4) = $120

What is the cost of the ending inventory using the average cost method?

Average cost = $453.30 / 115 = $3.94

Ending inventory = $3.94 x 25 = $98.54

To learn more about LIFO, please check: https://brainly.com/question/13779572

Otras preguntas