There are two criteria where I am unable to write a formula and
need help. I want to update the Payout column with a formula
based on number of hours worked by the employee and also based
on their role/designation. Need formulas in range E11:E20

My attempt and posted it at
http://zvkmpw.home.comcast.net/Payment_calculation.xls

The worksheet includes an explanation of how the calculation works.

Check that it gets the results you expect.

Hope this helps getting started.