For US Fuel calculation, we have fuel surcharge calculated based on regions. We need to maintain multiple index tables (PADD1, 1A, 1B,1C,2,3,4,5). Is it possible to have rate table determination rule to determine Fuel Index rate table based on regions/districts?
I can't able to find a place in Calculation sheet to maintain Rate table determination rule for Fuel Index. Kindly provide your insights on this.
Also suggest alternate option if any. If we have Fuel Index Rate table with Region and Calculation date, we have 2 things to consider - many regions/cities will follow same rate value(need to have multiple entries in table as well) and it needs to be maintained on weekly basis.
Thank you for your valuable time.