Price variance notes for trading houses
When the same SKU arrives under three invoice descriptions, variance reports go sideways. Notes from recent Wan Chai engagements on coding and comparison windows.
Trading houses in Hong Kong often buy the same SKU under several invoice descriptions across seasons. Price variance reports then compare apples to slightly different apples. Procurement analytics only helps when the comparison window and the matching rules are explicit.
Matching before measuring
We ask category owners to nominate a preferred key: internal SKU, manufacturer part number, or a cleaned description string. Mixed keys in one file produce false variance. In one Wan Chai engagement, three descriptions for the same fastener kit inflated the apparent price spread until we mapped them to a single internal code.
Choose the window
Twelve months is common for annual renewals; eighteen months catches seasonal swings for soft goods. Shorter windows suit commodities that reset monthly. Write the window on the first page of the briefing so finance and buying read the same chart.
What belongs in the narrative
List the top movers by absolute dollar impact, not only by percentage. A 2% move on a high-volume resin grade may matter more than a 15% move on a seldom-ordered accessory. That ranking is usually what buyers take into a renewal conversation.