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 |