In: Accounting
Swifty Company reports the following for the month of June.
Date | Explanation | Units | Unit Cost | Total Cost | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
June |
1 |
Inventory |
315 | $7 | $2,205 | ||||||||
12 |
Purchase |
735 | 8 | 5,880 | |||||||||
23 |
Purchase |
1,050 | 9 | 9,450 | |||||||||
30 |
Inventory |
392 |
Compute the cost of the ending inventory and the cost of goods sold under FIFO, LIFO, and average cost. (Round average cost per unit to 2 decimal places, e.g. 5.25 and final answers to 0 decimal places, e.g. 2,520.)
FIFO | LIFO | AVERAGE COST | |||||
---|---|---|---|---|---|---|---|
Ending inventory |
enter a dollar amount | enter a dollar amount | enter a dollar amount | ||||
Cost of goods sold |
$enter a dollar amount | $enter a dollar amount | $enter a dollar amount |
Susan Inc. uses the lower-of-cost-or-net-realizable-value
(LCNRV) basis for its inventory. The following data are available
at December 31
Units | Cost/Unit | NRV/Unit | ||||||||
---|---|---|---|---|---|---|---|---|---|---|
Cameras |
||||||||||
Minolta |
5 | $171 | $156 | |||||||
Canon |
8 | 142 | 157 | |||||||
Light Meters |
||||||||||
Vivitar |
12 | 124 | 120 | |||||||
Kodak |
10 | 122 | 134 |
What amount should be reported on Susan's financial statements,
assuming the lower-of-cost-or-net-realizable-value rule is
applied?
Total | $enter a dollar amount |
FIFO | LIFO | Avg Cost | |
Ending Inventory | $ 3,528 | $ 2,821 | $ 3,273 |
Cost of Goods Sold | $ 14,007 | $ 14,714 | $ 14,262 |
Average Cost | Cost of Goods Available for sale | Cost of Goods Sold | Inventory on hand | ||||||
Activity | Units | Unit Price | Amount | Units | Unit Price | Amount | Units | Unit Price | Amount |
Beginning Inventory | 315 | $ 7.00 | $ 2,205 | ||||||
Purchase | 735 | $ 8.00 | $ 5,880 | ||||||
Purchase | 1050 | $ 9.00 | $ 9,450 | ||||||
Total | 2100 | $ 8.35 | $ 17,535 | 1708 | $ 8.35 | $ 14,262 | 392 | $ 8.35 | $ 3,273 |
FIFO | Cost of Goods Available for sale | Cost of Goods Sold | Inventory on hand | ||||||
Activity | Units | Unit Price | Amount | Units | Unit Price | Amount | Units | Unit Price | Amount |
Beginning Inventory | 315 | $ 7.00 | $ 2,205 | 315 | $ 7.00 | $ 2,205 | |||
Purchase | 735 | $ 8.00 | $ 5,880 | 735 | $ 8.00 | $ 5,880 | |||
Purchase | 1050 | $ 9.00 | $ 9,450 | 658 | $ 9.00 | $ 5,922 | 392 | $ 9.00 | $ 3,528 |
Total | 2100 | $ 17,535 | 1708 | $ 14,007 | 392 | $ 3,528 | |||
LIFO | Cost of Goods Available for sale | Cost of Goods Sold | Inventory on hand | ||||||
Activity | Units | Unit Price | Amount | Units | Unit Price | Amount | Units | Unit Price | Amount |
Beginning Inventory | 315 | $ 7.00 | $ 2,205 | 315 | $ 7.00 | $ 2,205 | |||
Purchase | 735 | $ 8.00 | $ 5,880 | 658 | $ 8.00 | $ 5,264 | 77 | $ 8.00 | $ 616 |
Purchase | 1050 | $ 9.00 | $ 9,450 | 1050 | $ 9.00 | $ 9,450 | |||
Total | 2100 | $ 17,535 | 1708 | $ 14,714 | 392 | $ 2,821 |
2.
Inventory = 5 x $156 + 8 x $142 + 12 x 120 + 10 x 122 = $4576