I need to fill in the FIFO, LIFO, and Weighted Average tables out using this inf
ID: 2386220 • Letter: I
Question
I need to fill in the FIFO, LIFO, and Weighted Average tables out using this information:
During this year, Bristol Sales sold 775 DVDs for $60 each.
Date Units Purchased Cost Total
1/20 75 $17 $1,275
4/21 450 $19 $8,550
7/25 200 $23 $4,600
9/19 100 $29 $2,900
Units Available for Sale: 825 $17,325
Using the FIFO Method, fill in table:
Units Cost Per Unit
Ending Inventory:
From 9/19 Purchase:
Total Ending Inventory:
Using the LIFO Method, fill in table:
Units Cost Per Unit
Ending Inventory:
From 1/20 Purchase:
Total Ending Inventory:
Using Weighted Average, find:
Total Cost ÷ Total Units = Cost Per Unit
Ending Inventory:
Explanation / Answer
Using the FIFO Method, fill in table: Units Cost Per Unit Ending Inventory: 50 @ $29 From 9/19 Purchase: 50 @ $29 Total Ending Inventory: 50 @ $29 = 1,450 Using the LIFO Method, fill in table: Units Cost Per Unit Ending Inventory: 50 @ $17 From 1/20 Purchase: 50 @ $17 Total Ending Inventory: 50 @ $17 = $850 Using Weighted Average, find: Total Cost ÷ Total Units = Cost Per Unit $21 Ending Inventory: $1,050