|
Company has the following items
as inventory as of December 31, 2010. What is the value of inventory
by applying Lower of Cost of Market?
| Item |
Units |
Cost |
Current
Replacement Cost |
Estimated
Selling Price |
Completion
& Disposal Cost |
| 1 |
500 |
$65 |
$68 |
$80 |
$3 |
| 2 |
300 |
$80 |
$72 |
$102 |
$8 |
| 3 |
400 |
$90 |
$105 |
$112 |
$10 |
| 4 |
700 |
$38 |
$42 |
$40 |
$4 |
| 5 |
900 |
$20 |
$21 |
$30 |
$2 |
| 6 |
600 |
$55 |
$45 |
$67 |
$2 |
For all inventory items,
Normal Profit Margin is 30% of cost.
Determine the Market
| |
Points
Market = Current Replacement Cost
If Current Replacement Cost > Net Realizable
Value (NRV),
then NRV is Market.
If Current Replacement Cost < (NRV - Normal
Profit Margin),
then (NRV - Normal Profit
Margin) is Market.
Rank the following three values, then the
one in the middle is Market.
NRV
Current Replacement Cost
NRV - Normal Profit
Margin
Net Realizable Value (NRV)
= Estimated
Selling Price - Cost of Completion and Disposal
In this example, normal profit margin = 30% of
cost. |
| |
(A) |
(B) |
(C) |
Middle
value among (A), (B) and (C) |
| Item |
Current
Replacement Cost |
NRV |
Normal -
Normal Profit Margin |
Market |
| 1 |
$68 |
$77 |
$57.5 |
$68 |
| 2 |
$72 |
$94 |
$70 |
$72 |
| 3 |
$105 |
$102 |
$75 |
$102 |
| 4 |
$42 |
$36 |
$24.6 |
$36 |
| 5 |
$21 |
$28 |
$22 |
$22 |
| 6 |
$45 |
$65 |
$48.5 |
$48.5 |
Compare the Cost and Market
|
Item |
Cost |
Market |
Lower of Cost or Market (LCM) |
Units |
LCM Inventory |
|
1 |
$65 |
$68 |
$65 |
500 |
$32,500 |
|
2 |
$80 |
$72 |
$72 |
300 |
$21,600 |
|
3 |
$90 |
$102 |
$90 |
400 |
$36,000 |
|
4 |
$38 |
$36 |
$36 |
700 |
$25,200 |
|
5 |
$20 |
$22 |
$20 |
900 |
$18,000 |
|
6 |
$55 |
$48.5 |
$48.5 |
600 |
$29,100 |
|
Total |
|
|
|
|
$162,400 |
Inventory valuation at Cost, Market and LCM
|
Item |
Units |
Inventory at Cost |
|
Inventory at Market |
|
Inventory at LCM |
|
1 |
500 |
$32,500 |
< |
$34,000 |
|
$32,500 |
|
2 |
300 |
$24,000 |
> |
$21,600 |
|
$21,600 |
|
3 |
400 |
$36,000 |
< |
$40,800 |
|
$36,000 |
|
4 |
700 |
$26,600 |
> |
$25,200 |
|
$25,200 |
|
5 |
900 |
$18,000 |
< |
$19,800 |
|
$18,000 |
|
6 |
600 |
$33,000 |
> |
$29,100 |
|
$29,100 |
|
Total |
|
$170,100 |
< |
$170,500 |
|
$162,400 |
LCM applied to each inventory
item
--> Inventory at LCM =
$162,400
LCM applied to all inventories
as one pool
--> Total inventory at cost < Total inventory at market
--> Inventory at LCM = $170,100 |