Tiered pricing equation issue with excel and google sheets.

Good Evening Experts,

I am having an issue building out a spreadsheet to solve a tiered mileage equation. I have tried using IF statements, SUMPRODUCT and vlookup statements but not having much luck. I tried "JE McGimpsey's" variable rate equation, but didn't have success.
The pricing structure is tired so that the first mile is billed at a higher rate, than the next ten miles are at a different rate, continuing so-on and so-on. I have included a mockup of what I am trying to accomplish with a few manually solved routes. I need to figure out a way to automate the calculations for A,B,C,D,E,F

Thanks for any help or insights you might have.