Calculation guide
Limit the inventory charge to its book cost.
Inputs
Units on hand
Example entry 150.
Book cost per unit
Example entry 10 (in the selected currency).
Expected unit sale price
Example entry 11 (in the selected currency).
Completion cost per unit
Example entry 2 (in the selected currency).
Selling cost per unit
Example entry 1 (in the selected currency).
Worked example
| Input | Value |
|---|---|
| Units on hand | 150 |
| Book cost per unit | 10 |
| Expected unit sale price | 11 |
| Completion cost per unit | 2 |
| Selling cost per unit | 1 |
| Result | Value |
|---|---|
| Total write-down | 300 |
| Net realizable value per unit | 8 |
| Closing inventory value | 1,200 |
Calculation steps
Total write-down = (Units on hand × max(0, (Book cost per unit − max(0, ((Expected unit sale price − Completion cost per unit) − Selling cost per unit)))))
(150 × max(0, (10 − max(0, ((11 − 2) − 1))))) = 300
Net realizable value per unit = ((Expected unit sale price − Completion cost per unit) − Selling cost per unit)
((11 − 2) − 1) = 8
Closing inventory value = ((Units on hand × Book cost per unit) − Total write-down)
((150 × 10) − 300) = 1,200
How each input affects this example
Each row starts from the worked example and changes one input.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Units on hand | 150 | 165 | Total write-down | 300 | 330 |
| Book cost per unit | 10 | 11 | Total write-down | 300 | 450 |
| Expected unit sale price | 11 | 12 | Total write-down | 300 | 150 |
| Completion cost per unit | 2 | 3 | Total write-down | 300 | 450 |
| Selling cost per unit | 1 | 2 | Total write-down | 300 | 450 |
