I understand why there is a need for the variable rates, but the administration of it all sounds horrible.
There should be a single source of truth for the rates data, and there should be an api instead of having to rely on a third party for that information.