1 / 7

Eurotrace Hands-On Case Studies Modules

Eurotrace Hands-On Case Studies Modules. Module : Unit Value Check. Example : Importation HS 010599 : Live ducks, geese, turkeys and guinea fowls weighting >185g. 3 sets of Indicators : Value (in €) Mass (Net Mass) Quantity (Supplementary Unit). 3 ratios to test :

devona
Download Presentation

Eurotrace Hands-On Case Studies Modules

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Eurotrace Hands-OnCase Studies Modules

  2. Module : Unit Value Check Example : Importation HS 010599 : Live ducks, geese, turkeys and guinea fowls weighting >185g 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 > 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. Closeness : (Means-StDev)/Means*100 +/-30% of Min Max Means 10% of value Excluded Product Flow MinUV1 MaxUV1 010599 Import 0.651 2.585 Product Flow MinUV1 AvgUV1 MaxUV1 010599 Import 0.651 1.542 2.585 Product Flow MinUV1 AvgUV1 MaxUV1 Closeness NbItem NbSel 010599 Import 0.651 1.542 2.585 0.65 47 41 Range : Range Calculation Sample 24 Month V a l u e Mass Product Flow 010599 Import

  4. Detection Automatic Correction Manual Control 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.65 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 >185g) 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

More Related