In: Accounting
Exercise 9-07
Windsor 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,600 | $3.46 | $3.24 | $4.86 | $0.38 | $1.35 | ||||||||||||
1333 |
1,300 | 2.92 | 2.48 | 3.78 | 0.54 | 0.54 | ||||||||||||
1426 |
1,200 | 4.86 | 4.00 | 5.40 | 0.43 | 1.08 | ||||||||||||
1437 |
1,400 | 3.89 | 3.35 | 3.46 | 0.27 | 0.97 | ||||||||||||
1510 |
1,100 | 2.43 | 2.16 | 3.51 | 0.86 | 0.65 | ||||||||||||
1522 |
900 | 3.24 | 2.92 | 4.10 | 0.43 | 0.54 | ||||||||||||
1573 |
3,400 | 1.94 | 1.73 | 2.70 | 0.81 | 0.54 | ||||||||||||
1626 |
1,400 | 5.08 | 5.62 | 6.48 | 0.54 | 1.08 |
From the information above, determine the amount of Windsor Company
inventory.
The amount of Windsor Company’s inventory | $enter the dollar amount of Windsor Company's inventory |
Solution
The amount of Windsor Company’s inventory | $ 36,147 |
.
Working
Product | Cost | Replacement cost | NRV | NRV-NP | Market | Per unit Inventory Value | Units | Lower of cost or realizable value |
1320 | $ 3.46 | $ 3.24 | $ 4.48 | $ 3.13 | $ 3.24 | $ 3.24 | 1,600 | $ 5,184.00 |
1333 | $ 2.92 | $ 2.48 | $ 3.24 | $ 2.70 | $ 2.70 | $ 2.70 | 1,300 | $ 3,510.00 |
1426 | $ 4.86 | $ 4.00 | $ 4.97 | $ 3.89 | $ 4.00 | $ 4.00 | 1,200 | $ 4,800.00 |
1437 | $ 3.89 | $ 3.35 | $ 3.19 | $ 2.22 | $ 3.19 | $ 3.19 | 1,400 | $ 4,466.00 |
1510 | $ 2.43 | $ 2.16 | $ 2.65 | $ 2.00 | $ 2.16 | $ 2.16 | 1,100 | $ 2,376.00 |
1522 | $ 3.24 | $ 2.92 | $ 3.67 | $ 3.13 | $ 3.13 | $ 3.13 | 900 | $ 2,817.00 |
1573 | $ 1.94 | $ 1.73 | $ 1.89 | $ 1.35 | $ 1.73 | $ 1.73 | 3,400 | $ 5,882.00 |
1626 | $ 5.08 | $ 5.62 | $ 5.94 | $ 4.86 | $ 5.62 | $ 5.08 | 1,400 | $ 7,112.00 |
$ 36,147.00 |
Market value is calculated as
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 |
.
Product | Estimated selling price (A) | Cost to complete and sell (B) | NRV (A-B) |
1320 | $ 4.86 | $ 0.38 | $ 4.48 |
1333 | $ 3.78 | $ 0.54 | $ 3.24 |
1426 | $ 5.40 | $ 0.43 | $ 4.97 |
1437 | $ 3.46 | $ 0.27 | $ 3.19 |
1510 | $ 3.51 | $ 0.86 | $ 2.65 |
1522 | $ 4.10 | $ 0.43 | $ 3.67 |
1573 | $ 2.70 | $ 0.81 | $ 1.89 |
1626 | $ 6.48 | $ 0.54 | $ 5.94 |