How do you stop old tariff assumptions spreading through spreadsheets?
If several teams maintain cost sheets, how would you keep a corrected classification or duty assumption from getting lost?
All questionsTariffs
7 replies
- Give the reviewed assumption a version and effective context, then link the cost sheets to it. Copying a rate into ten files creates ten future repair jobs.
- I'd name one owner for the product classification record. Other teams can request changes, but they shouldn't each create a separate official answer.
- Keep historical estimates with their original version. You need to explain what was approved then, even after the current assumption improves.
- When something changes, notify the people with open orders for that SKU. A generic email to the whole company is easy to miss.
- Use a visible 'review required' state for uncertain items. Zero is a number, not a sensible substitute for missing customs advice.
- I'd reconcile a sample of actual entries back to the model regularly. That is how you find the quiet mismatch between the spreadsheet and the way shipments are being filed. Pick some ordinary lines as well as the expensive exceptions. If you only inspect the dramatic cases, a small recurring error across the rest of the catalog can stay invisible for months.
- Make the source link and review date mandatory in the shared record. The next person should be able to understand the assumption without finding the original author.
Write a reply
Loading…