calculate amount charged based on various rates

Hello,
I am seeking assistance with attached file to best apply formula to calculate amount to be charged using a basic and per kg rate structure. Basic and Per Kg is based on certain criteria in col A-D in order of first match application. To illustrate, i have used iferror/vlookup (can this be enhanced). I am also wondering if index match/sum product would be a better way to go about this and how to apply this?

Hello imran999 & Welcome to the Forum,

Administrative Note:

• We would love to continue to help you with your query, but first, before we can proceed…
• Please see Forum Rule #1 about proper thread titles and adjust accordingly...

Also, why post an Excel file that is zipped? Please post the Excel file instead.

Something like that?
You already had the verbiage in your question