Eurotrace Hands-On Case Studies Modules

1
Eurotrace Hands-OnCase Studies Modules
2
Module Unit Value Check
Example Importation HS 010599 Live ducks,
geese, turkeys and guinea fowls weighting gt185g
3 sets of Indicators Value (in ) Mass (Net
Mass) Quantity (Supplementary Unit)
3 ratios to test Value/Mass Unit Value to be
tested Value/Quantity Other Unit value
Calculation Mass/Quantity Unit Mass test (in
this case gt 0.185 kg)
Outlier Detection Definition of the range for
these 3 Ratios and correction of Mass (with
manual post-verification) and Quantity ex
CorrectedQuantity Value / Ratio(Value/Quantity)
3
Range Range Calculation
Sample 24 Month
V a l u e
Mass
Product Flow 010599 Import
4
Range Mass Correction
Current Month
V a l u e
Mass
Product Flow MinUV1 AvgUV1 MaxUV1 Closeness
NbItem NbSel 010599 Import 0.651 1.542 2.585 0.6
5 47 41
5
Range Unit Value Check
Automatic Algorithm
1. Test on Value/Mass Ratio ? UV Outlier ? Net
Mass Correction 2. Test on Value/Quantity Ratio
? UV Outlier ? Quantity Correction 3. Test on
Mass/Quantity Ratio ? Unit Mass Outlier ?
Quantity Correction
6
Range Unit Value Check
But Manual Control for
Value greater than 500.000 OR Mass greater
than 100.000 Kilo OR Specific list of
Product OR Specific list of Trader OR Range with
Closeness less than 40 OR Range with Number of
Items less than 24 (Less than 1 transaction per
month) OR etc
Transaction to be controlled are flagged by
program. Another flag have to be checked
manually to validate the correction (and/or
manual changement of value, mass, quantity)
7
Range Technical Considerations
1 . UV Range (Value/Mass) table could be complete
by Price Survey (for Raw Material, Farming, )
2 . UM Unit Mass must be conform to Product
definition (Live ducks, geese weighting gt185g)
3 . A Control Table generated automatically by
Eurotrace have to be consulted - This table
contains the number and the percentage of
replaced Mass/Value on each Product/Flow within
the current processed month. - If for some
product, there is too many correction (i.e. more
than 80 with more than 5 Values), the current
range and the related value have to be
controlled, and, if necessary modified