Help with a logical formula

Hello,

I have a team of 38 members, I need to allot the amount hence need the formula to calculate it

Criteria to consider is Slab and Rank

Sharing an example with 11 members data

Firstly need to check the Slab and then the rank

Eg: If I have 7 people in slab 1, the amount allotment should be based on the top 40% in slab 1 to get 10k and remain 60% in slab 1 should get 8000
And in slab 4 I have 4 people
top 40 percent in slab 3 should get 6000
The remaining 20 percent in slab 3 should get 5000
rest 20 percent in slab 2 should get 4000

This should be checked on a monthly basis.

Attaching a reference file

How does this differ from your previous thread with the same/similar title?

No help to be offered until it is CLEAR that this is not aduplicate thread.