In: Accounting
Lower-of-Cost-or-Market Inventory
On the basis of the following data:
Commodity |
Inventory |
Unit |
Unit |
|
AL65 | 42 | $179 | $174 | |
CA22 | 46 | 89 | 89 | |
LA98 | 30 | 276 | 295 | |
SC16 | 11 | 116 | 134 | |
UT28 | 21 | 213 | 222 |
Determine the value of the inventory at the lower of cost or market. Assemble the data in the form illustrated in Exhibit 10.
Inventory at the Lower of Cost or Market |
|||
Commodity |
Total Cost |
Total Market |
Total Lower of C or M |
AL65 |
|||
CA22 |
|||
LA98 |
|||
SC16 |
|||
UT28 |
|||
TOTAL |
Inventory value |
|||||
Items |
Cost per unit |
Market value per unit |
Per Unit as per Lower of cost or market value |
Number of units |
Total Value |
AL65 |
$ 179.00 |
$ 174.00 |
$ 174.00 |
42 |
$ 7,308.00 |
CA22 |
$ 89.00 |
$ 89.00 |
$ 89.00 |
46 |
$ 4,094.00 |
LA98 |
$ 276.00 |
$ 295.00 |
$ 276.00 |
30 |
$ 8,280.00 |
SC16 |
$ 116.00 |
$ 134.00 |
$ 116.00 |
11 |
$ 1,276.00 |
UT28 |
$ 213.00 |
$ 222.00 |
$ 213.00 |
21 |
$ 4,473.00 |
Total ending inventory |
$ 25,431.00 |
Inventory at the Lower of Cost or Market |
|||
Commodity |
Total Cost |
Total Market |
Total Lower of C or M |
AL65 |
$7,518 |
$7,308 |
$7,308 |
CA22 |
$4,094 |
$4,094 |
$4,094 |
LA98 |
$8,280 |
$8,850 |
$8,280 |
SC16 |
$1,276 |
$1,474 |
$1,276 |
UT28 |
$4,473 |
$4,662 |
$4,473 |
TOTAL |
$25,641 |
$26,388 |
$25,431 |