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

Answer

Expert–verified
Hide Steps
Answer

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

Steps

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}\)

link_gpt