I just try to identify if there is a method only probabilist here or if the evolution of these ratios follows a reality.
I put in red my prediction, I don't know what to do with this 1,45M "in transit" between FY2017 tracked and shipped.
Would this massive 1,45M explain the poor following shipments at Q1 2018 ?