Applying a Tiered tariff to calculation

Hi Everyone,

My first post here and i hope this is done right. PLease note i have an issue where i have varioud vedors having different tariff based on day range. I have inserted sample Data avaiable and the tariff.

in the file i also included expected result . Hope someone can help me understnd how to write a formula to look at all the parameters.
1) Carrier Name
2) Container Type
3) Free time
4) Tariff to be selected
5) calculated total USD

so

PLEASE HELPW