All very interesting. Just to be sure I think the OP should explain.
If a show happens every few years the show rate cannot be changed for previous periods. It must have a new rate applied for this current period. Also a rate must be applied to every other transaction. Example, could be a Car...