In: Accounting
Concord Company follows the practice of pricing its inventory at
the lower-of-cost-or-market, on an individual-item basis.
Item No. |
Quantity |
Cost per Unit |
Cost to Replace |
Estimated Selling Price |
Cost of Completion and Disposal |
Normal Profit |
||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1320 |
1,500 | $3.36 | $3.15 | $4.73 | $0.37 | $1.31 | ||||||||||||
1333 |
1,200 | 2.84 | 2.42 | 3.68 | 0.53 | 0.53 | ||||||||||||
1426 |
1,100 | 4.73 | 3.89 | 5.25 | 0.42 | 1.05 | ||||||||||||
1437 |
1,300 | 3.78 | 3.26 | 3.36 | 0.26 | 0.95 | ||||||||||||
1510 |
1,000 | 2.36 | 2.10 | 3.41 | 0.84 | 0.63 | ||||||||||||
1522 |
800 | 3.15 | 2.84 | 3.99 | 0.42 | 0.53 | ||||||||||||
1573 |
3,300 | 1.89 | 1.68 | 2.63 | 0.79 | 0.53 | ||||||||||||
1626 |
1,300 | 4.94 | 5.46 | 6.30 | 0.53 | 1.05 |
From the information above, determine the amount of Concord Company
inventory.
The amount of Concord Company’s inventory |
$enter the dollar amount of Concord Company's inventory |
Solution
The amount of Concord Company’s inventory | $ 32,676.00 |
Working
Product | Cost | Replacement cost | NRV | NRV-NP | Market | Per unit Inventory Value | Units | Lower of cost or realizable value |
1320 | $ 3.36 | $ 3.15 | $ 4.36 | $ 3.05 | $ 3.15 | $ 3.15 | 1,500 | $ 4,725.00 |
1333 | $ 2.84 | $ 2.42 | $ 3.15 | $ 2.62 | $ 2.62 | $ 2.62 | 1,200 | $ 3,144.00 |
1426 | $ 4.73 | $ 3.89 | $ 4.83 | $ 3.78 | $ 3.89 | $ 3.89 | 1,100 | $ 4,279.00 |
1437 | $ 3.78 | $ 3.26 | $ 3.10 | $ 2.15 | $ 3.10 | $ 3.10 | 1,300 | $ 4,030.00 |
1510 | $ 2.36 | $ 2.10 | $ 2.57 | $ 1.94 | $ 2.10 | $ 2.10 | 1,000 | $ 2,100.00 |
1522 | $ 3.15 | $ 2.84 | $ 3.57 | $ 3.04 | $ 3.04 | $ 3.04 | 800 | $ 2,432.00 |
1573 | $ 1.89 | $ 1.68 | $ 1.84 | $ 1.31 | $ 1.68 | $ 1.68 | 3,300 | $ 5,544.00 |
1626 | $ 4.94 | $ 5.46 | $ 5.77 | $ 4.72 | $ 5.46 | $ 4.94 | 1,300 | $ 6,422.00 |
$ 32,676.00 |
.
.
Product | Estimated selling price (A) | Cost to complete and sell (B) | NRV (A-B) |
1320 | $ 4.73 | $ 0.37 | $ 4.36 |
1333 | $ 3.68 | $ 0.53 | $ 3.15 |
1426 | $ 5.25 | $ 0.42 | $ 4.83 |
1437 | $ 3.36 | $ 0.26 | $ 3.10 |
1510 | $ 3.41 | $ 0.84 | $ 2.57 |
1522 | $ 3.99 | $ 0.42 | $ 3.57 |
1573 | $ 2.63 | $ 0.79 | $ 1.84 |
1626 | $ 6.30 | $ 0.53 | $ 5.77 |
.
.
If we want to value inventory on the basis of lower of cost or market value then we have to first calculate market value. |
To calculate market value an easy method is used in this question. We will take the middle value of the given below values to ascertain market value. |
.
Replacement value | NRV | NRV minus Normal Profits |