Question
need help with this badly i just cant figure it out,mark in red for incorrect . i have given all information needed. i need adjusted
need help with this badly i just cant figure it out,mark in red for incorrect . i have given all information needed. i need adjusted values for the ones marked incorrect, fifo ending inventoru, and moving average for cost of goofs sold
this is the work
Sales under each of the three cash flow assumptions:
January 8 : 109 units @ $29 each = 3,161
January 10: Sales return (10 units * 29) = (290)
January 20: 95 units @ 33 each = 3,135
Therefore, Total sales = $ 3,161 - 290 - 3,135 = $ 6,005
LIFO
Method:
Total sales (as above) = $ 6,005
Cost of goods sold:
January 8: Sales (109 units * $20) = 2,180
January 10: Sales return (10 units * 20) = (200)
January 20: Sales: 95 units : 50 units * $22 + 45 units * 20 =
2,000
Cost of goods sold = 2,180 - 200 + 2,000 = $3,980
Gross Profit = 6,005 - 3,980 = $2,025
Ending Inventory:
Balance Number of units = 100 + 144 - 109 + 10 +55 - 5 -95 + 22
= 122 units
January 1: 100 units @ 17 = 1,700
January 25: 22 units @24= 528
Therefore, Ending Inventory under LIFO = 1700+528 = $
2,228
FIFO
Method:
Total sales (as above) = $ 6,005
Cost of goods sold:
January 8: Sales: 109 units: 100 units @ 17 + 9 units * $20 =
1,880
January 10: Sales return (10 units * 20) = (200)
January 20: Sales: 95 units : 95 units * $20 = 1,900
Cost of goods sold = 1,880 - 200 + 1,900 = $3,580
Gross Profit = 6,005 - 3,580 = $2,425
Ending Inventory:
January 1: 45 units @ 20 = 900
January 15: 55 units @ 22 = 1,210
January 25: 22 units @24= 528
Therefore, Ending Inventory under FIFO = 900 + 1,210+528 = $
2,638
Moving
Average Cost:
Total sales (as above) = $ 6,005
Cost of goods sold: (see
requirement 1 for moving average cost)
January 8: Sales: 109 units: 109 units * $18.770 = 2,046
January 10: Sales return (10 units * 20) = (200)
January 20: Sales: 95 units : 95 units * $19.599 = 1,862
Cost of goods sold = 2,046 - 200 + 1,862 = $3,708
Gross Profit = 6,005 - 3,708 = $2,297
Ending Inventory:
Ending Inventory under Moving average = 122 units * $ 20.393 = $2,488
Moving average cost = 22 units * 24 + 100 * 19.599 = 528+1960 =
2488/122 units = $ 20.393
Summary:
1.Cost
of goods sold:
$LIFO : $3,980
$FIFO: $3,580
$Moving average: $3,708
2.Ending inventory
$LIFO : $ 2,228
$FIFO: $ 2,638
$moving average: $2,488
3.Gross profit
$LIFO : $2,025
$FIFO: $2,425
$Moving average: $2,297
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started