VBA code required for coming Brandwise Slabwise Discount Coulmn in front of Sales Qty

Dear Sir,

I have a workbook, in a sheet named output-sheet I get the party wise lifting result, in front of that I want the slab wise discount of each brand.

We give discounts to the customers who come in the slab according to the slab from brand-scheme sheet

for example =
If a customer does 3 box lifting of abw brand then we pay him a discount of Rs. 60/- per box & if that customer does 10 box lifting then we pay him Rs. 80/- per box

i enclosed herewith xlsx. sheet & i report in the sheet(output required sheet), what i want.

slabwise discount.png

Thank you Very Very Much JohnTopley this is most important report for me..made it very easy for me .
You are Genius Sir, Thank you once again.

Thank you Very Much for fast reply kvsrinivasamurthy formula is worked perfect
I also tried this formula but it was missing the $ sign on f2 cell

Thank you once again..