Please try to help me the responce to our Customer
...
We going to start using Inventory Turnover Rate per Period analysis.
But we recieve different values of Issued Value from this place and summarize values from Inventory Transaction History.
We need to be sure how does it work, before we send this analysis to managers.
Here is the example on TEST db:
part_no = 1000001
contract = PLGDY
periods from 2021 01 to 2021 12
and we receive Issued Value = 33036,68 and Average Inventory Value = 2635,91
while from Transaction History
part_no = 1000001
contract = PLGDY
created 2021-01-01..2021-12-31 (Applied Date also)
we receive such values of transactions:
ARRIVAL 31 534,80
INTSHIP 28 321,68
INTUNISS 66,94
and from Inventory Value per Period avg. value = 2 303,31
end of period total value
2021-01 1 802,66
2021-02 1 110,66
2021-03 1 058,76
2021-04 692,00
2021-05 1 664,30
2021-06 2 636,70
2021-07 3 216,38
2021-08 -0,01
2021-09 3 781,18
2021-10 1 280,04
2021-11 5 425,14
2021-12 4 971,94
2 303,31 = Avg. Value
Is there a bug in analisys procedure? How does it work?
….
It seems to me that depends on statistics are generated. Am I right?