In: Accounting
Determining Lower of Cost or Net Realizable Value (NRV)
Crane Company had the following inventory at December 31, 2017.
| Unit Price | |||
|---|---|---|---|
| Quantity | Cost | NRV | |
| Desks | |||
| Model 9001 | 70 | $190 | $210 | 
| Model 9002 | 45 | 280 | 268 | 
| Model 9003 | 20 | 350 | 360 | 
| Cabinets | |||
| Model 7001 | 120 | 60 | 64 | 
| Model 7002 | 80 | 95 | 88 | 
| Model 7003 | 50 | 130 | 126 | 
a. Determine the ending inventory amount by applying the net
realizable value rule to:
1. Each item of inventory.
$Answer
2. Each major category of inventory.
$Answer
3. Total inventory.
$Answer
| Solution : 1 | ||||||
| CALCULATION OF INVENTORY VALUE AS PER LOWER OF COST OR NET REALIZABLE VALUE | ||||||
| PRODUCT | Quantity (A) | Unit Cost | Net Realizable Value | Cost of Ivnentory lower of Cost or Net Realizable Value (B) | Inventory Cost (AXB) | |
| Desk: | ||||||
| Model 9001 | 70 | $ 190 | $ 210 | $ 190 | $ 13,300 | |
| Model 9002 | 45 | $ 280 | $ 268 | $ 268 | $ 12,060 | |
| Model 9003 | 20 | $ 350 | $ 360 | $ 350 | $ 7,000 | |
| Cabinet: | ||||||
| Model 7001 | 120 | $ 60 | $ 64 | $ 60 | $ 7,200 | |
| Model 7002 | 80 | $ 95 | $ 88 | $ 88 | $ 7,040 | |
| Model 7003 | 50 | $ 130 | $ 126 | $ 126 | $ 6,300 | |
| Total | $ 52,900 | |||||
| Answer = Inventory Value = 52,900 | ||||||
| Solution : 2 | ||||||
| CALCULATION OF INVENTORY VALUE AS PER LOWER OF COST OR NET REALIZABLE VALUE - MAJOR CATEGORY | ||||||
| PRODUCT | Quantity (A) | Unit Cost | Net Realizable Value | Cost of Ivnentory lower of Cost or Net Realizable Value (B) | Inventory Cost (AXB) | |
| Desk: | ||||||
| Model 9001 | 70 | $ 190 | $ 210 | $ 190 | $ 13,300 | |
| Model 9002 | 45 | $ 280 | $ 268 | $ 268 | $ 12,060 | |
| Model 9003 | 20 | $ 350 | $ 360 | $ 350 | $ 7,000 | |
| Total | $ 32,360 | |||||
| Cabinet: | ||||||
| Model 7001 | 120 | $ 60 | $ 64 | $ 60 | $ 7,200 | |
| Model 7002 | 80 | $ 95 | $ 88 | $ 88 | $ 7,040 | |
| Model 7003 | 50 | $ 130 | $ 126 | $ 126 | $ 6,300 | |
| Total | $ 20,540 | |||||
| Answer = Inventory Value = Desk = $ 32,360 | ||||||
| Answer = Inventory Value = Cabinet = $ 20,540 | ||||||
| Solution : 3 | ||||||
| CALCULATION OF INVENTORY VALUE AS PER LOWER OF COST OR NET REALIZABLE VALUE | ||||||
| PRODUCT | Quantity (A) | Unit Cost | Total Cost | Cost of Ivnentory lower of Cost or Net Realizable Value (B) | Inventory Cost at Realizable Value (AXB) | |
| Desk: | ||||||
| Model 9001 | 70 | $ 190 | $ 13,300 | $ 190 | $ 13,300 | |
| Model 9002 | 45 | $ 280 | $ 12,600 | $ 268 | $ 12,060 | |
| Model 9003 | 20 | $ 350 | $ 7,000 | $ 350 | $ 7,000 | |
| Cabinet: | ||||||
| Model 7001 | 120 | $ 60 | $ 7,200 | $ 60 | $ 7,200 | |
| Model 7002 | 80 | $ 95 | $ 7,600 | $ 88 | $ 7,040 | |
| Model 7003 | 50 | $ 130 | $ 6,500 | $ 126 | $ 6,300 | |
| Total | $ 54,200 | $ 52,900 | ||||
| Answer = Inventory Value = $ 52,900 | ||||||