Assuming the following:
- Three items are selected for stock take
- They all have the same standard cost = 75
- They will be counted in several locations
- All lines will be counted before the calculation is done = 100 %
This is how the total estimated cost difference in % is calculated for a stock take list:
| Location | Item | Stock on hand | Counted | Difference | Estimated cost diff | Estimated cost diff in % |
|---|---|---|---|---|---|---|
| OS100 | A | 48 | 48 | 0 | ||
| PA200 | A | 127 | 122 | -5 | -375 | |
| Total for: | A | 175 | 170 | -5 | -375 | 2,22 % |
| AB300 | B | 20 | 21 | 1 | 75 | |
| Total for: | B | 20 | 21 | 1 | 75 | 0,44 % |
| OS102 | C | 30 | 2 | -28 | -2100 | |
| Total for: | C | 30 | 2 | -28 | -2100 | 12,44 % |
- Total stock take list value (175 + 20 + 30) x 75 = 16875
- Total counted difference (375 + 75 + 2100) = 2550
- Total estimated cost value difference of the stock take list (-375 + 75 + (-2100)) = -2400
This is how the estimated difference in % is calculated for one line, in this example, Item C:
| (-2100/16875) x 100 = 12,44% |
The total estimated difference % is calculated against the total stock take list value:
| (2550/16875) x 100 = 15,11% |
This percentage is displayed in the Work with stock takes program when the complete list (100%) has been counted.
Related topics
- About working with stock count
- Create and print a stock take list
- Report counted quantities
- Report counted quantities for serial number controlled items
- Print a stock take control list
- Recount stock take transactions
- Add count instructions to an existing list
- Update and close the stock take transactions