In: Accounting
Product | Original Cost |
Replacement Cost |
Estimated Disposal Cost |
Expected Selling Price |
Normal Profit on Sales |
||||||||||
A | $30.00 | $28.00 | $8.00 | $44.00 | 25.00% | ||||||||||
B | $44.00 | $42.00 | $10.00 | $54.00 | 20.00% | ||||||||||
C | $124.00 | $119.00 | $29.00 | $210.00 | 30.00% | ||||||||||
D | $18.00 | $15.40 | $6.00 | $30.00 | 20.00% |
Using the lower-of-cost-or-market approach applied on an
individual-item basis, compute the inventory valuation that should
be reported for each product on December 31, 2017
Solution:
Product | |
A | $ 28.00 |
B | $ 42.00 |
C | $ 119.00 |
D | $ 18.00 |
Working:
1) Calculation of Ceiling And Floor:
Product | Selling Price (a) | Estimated cost to complete and sell (b) | Net Realizable Value (a-b) [Ceiling | Normal Profit | NRV-Profit [Floor] |
A | $ 44.00 | $ 8.00 | $ 36.00 | $ 11.00 | $ 25.00 |
B | $ 54.00 | $ 10.00 | $ 44.00 | $ 10.80 | $ 33.20 |
C | $ 210.00 | $ 29.00 | $ 181.00 | $ 63.00 | $ 118.00 |
D | $ 30.00 | $ 6.00 | $ 24.00 | $ 6.00 | $ 18.00 |
2) Calculation of Lower of cost or market:
Product | Replacement Cost | Net Realizable Value (a-b) [Ceiling | NRV-Profit [Floor] | Market Value | Original Cost | Lower of Cost or Market |
A | $ 28.00 | $ 36.00 | $ 25.00 | $ 28.00 | $ 30.00 | $ 28.00 |
B | $ 42.00 | $ 44.00 | $ 33.20 | $ 42.00 | $ 44.00 | $ 42.00 |
C | $ 119.00 | $ 181.00 | $ 118.00 | $ 119.00 | $ 124.00 | $ 119.00 |
D | $ 15.40 | $ 24.00 | $ 18.00 | $ 18.00 | $ 18.00 | $ 18.00 |