How to solve this question below?
Sunland Company’s record of transactions concerning part X for
the month of April was as follows.
Purchases |
Sales |
||||||||
April 1 | (balance on hand) | 320 | @ | $6.30 | April 5 | 520 | |||
4 | 620 | @ | 6.40 | 12 | 420 | ||||
11 | 520 | @ | 6.70 | 27 | 1,240 | ||||
18 | 420 | @ | 6.70 | 28 | 150 | ||||
26 | 820 | @ | 7.10 | ||||||
30 | 420 | @ | 7.30 |
If the perpetual inventory record is kept in dollars, and costs
are computed at the time of each withdrawal, what amount would be
shown as ending inventory under (1) FIFO, (2) LIFO and (3)
Average-cost? (Round average cost per unit to 4 decimal
places, e.g. 2.7621 and final answers to 0 decimal places, e.g.
6,548.)
(1) |
(2) |
(3) |
||||
Ending Inventory |
$ |
$ |
$ |
Caluclation of Ending inventory = Opening + Purchase - Sale | ||||
=320 + (620+520+420+820+420) - (520+420+1240+150) | ||||
790 | ||||
Cost of Ending Inventory(FIFO) = $5693 | ||||
Date | Units | Rate | Amount | |
April-.30 | 420 | 7.3 | 3066 | |
April-.26 | 370 | 7.1 | 2627 | |
790 | 5693 | |||
Cost of Ending Inventory(LIFO) = $5297 | ||||
Date | Units | Rate | Amount | |
April-.1 | 320 | 6.3 | 2016 | |
April-.4 | 100 | 6.4 | 640 | |
April-.11 | 100 | 6.7 | 670 | |
April-.30 | 270 | 7.3 | 1971 | |
790 | 5297 | |||
Cost of Ending Inventory(Weighted Average) = $5360 | ||||
Date | Units | Rate | Amount | |
April-.30 | 790 | 6.79 | 5360 | |
790 | 5360 | |||
Date | Units | Rate | Amount | |
April-.1 | 320 | 6.3 | 2016 | |
April-.4 | 620 | 6.4 | 3968 | |
April-.11 | 520 | 6.7 | 3484 | |
April-.18 | 420 | 6.7 | 2814 | |
April-.26 | 820 | 7.1 | 5822 | |
April-.30 | 420 | 7.3 | 3066 | |
3120 | 21170 | |||
Weighted average cost = 21170/3120 | ||||
=6.79 | ||||
Get Answers For Free
Most questions answered within 1 hours.