Problem

Calculate the value of inventory sold, if 7,600 units were sold during the month using FIFO, LIFO, and Average. \begin{tabular}{|c|c|c|} \hline Date & Units Purchased & Cost \\ \hline $8 / 2 / 2022$ & 2,000 & $\$ 1.50$ \\ \hline $8 / 8 / 2022$ & 3,000 & $\$ 2.00$ \\ \hline $8 / 21 / 2022$ & 4,000 & $\$ 2.50$ \\ \hline \end{tabular} FIFO: LIFO: A A Average: A

Solution

Step 1 :Understand the problem: We are given the number of units sold and the cost of units purchased on different dates. We are asked to calculate the value of inventory sold using three different methods: FIFO (First-In, First-Out), LIFO (Last-In, First-Out), and Average Cost.

Step 2 :FIFO (First-In, First-Out) Method: In this method, the first units purchased are the first ones to be sold. So, the cost of the units sold will be calculated based on the cost of the first units purchased.

Step 3 :Calculate the total cost of units sold using FIFO: \((2,000 * $1.50) + (3,000 * $2.00) + (2,600 * $2.50) = $3,000 + $6,000 + $6,500 = $15,500\)

Step 4 :\(\boxed{FIFO = $15,500}\)

Step 5 :LIFO (Last-In, First-Out) Method: In this method, the last units purchased are the first ones to be sold. So, the cost of the units sold will be calculated based on the cost of the last units purchased.

Step 6 :Calculate the total cost of units sold using LIFO: \((4,000 * $2.50) + (3,000 * $2.00) + (600 * $1.50) = $10,000 + $6,000 + $900 = $16,900\)

Step 7 :\(\boxed{LIFO = $16,900}\)

Step 8 :Average Cost Method: In this method, the cost of the units sold will be calculated based on the average cost of all units purchased.

Step 9 :Calculate the average cost per unit: \(\frac{($3,000 + $6,000 + $10,000)}{(2,000 + 3,000 + 4,000)} = \frac{$19,000}{9,000} = $2.11\)

Step 10 :Calculate the total cost of units sold using Average Cost: \(7,600 units * $2.11 = $16,036\)

Step 11 :\(\boxed{Average Cost = $16,036}\)

From Solvely APP
Source: https://solvelyapp.com/problems/oPmzqv1kIu/

Get free Solvely APP to solve your own problems!

solvely Solvely
Download