we are going to a new pay system. Instead of just a standard hourly wage, employees will be able to make a higher wage based on the production of the plant they work at. I am looking for help with a formula that will assign the new wage per hour based on the level of the employee and the amount of production.
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
<colgroup><col><col><col span="7"></colgroup><tbody>
</tbody>
Casting Operator | $16.00 | 2 | Technical 3 |
Casting Operator | $16.00 | 2 | Technical 3 |
Draw Bench Operator | $16.00 | 2 | Technical 3 |
Storeroom Attendant | $16.00 | 2 | Technical 3 |
Quality Assurance | $16.00 | 2 | Technical 3 |
Material Handler | $13.00 | 2 | General 1 |
Material Handler | $14.50 | 2 | General 2 |
Maintenance Mechanic | $24.00 | 2 | Technical 5 |
Maintenance Electrician | $27.00 | 2 | Technical 7 |
FL1 Operator | $16.00 | 2 | Technical 3 |
Casting Operator | $16.00 | 2 | Technical 3 |
Casting Operator | $16.00 | 2 | Technical 3 |
Casting Operator | $16.00 | 2 | Technical 3 |
Casting Supervisor | $18.00 | 2 | Technical 4 |
Casting Operator | $16.00 | 2 | Technical 3 |
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
Production | General 1 | General 2 | Technical 3 | Technical 4 | Technical 5 | Technical 6 | Technical 7 | |
Level | Pounds / Week | G1 | G2 | T3 | T4 | T5 | T6 | T7 |
7 | 250,001 - ∞ | $15.00 | $16.50 | $20.50 | $23.00 | $30.50 | $32.00 | $34.00 |
6 | 240,001 - 250,000 | $15.25 | $16.25 | $19.00 | $21.50 | $28.50 | $30.00 | $32.00 |
5 | 230,001 - 240,000 | $14.50 | $16.00 | $18.25 | $20.25 | $27.00 | $28.75 | $30.50 |
4 | 220,001 - 230,000 | $14.00 | $15.50 | $17.50 | $19.50 | $26.00 | $27.50 | $29.50 |
3 | 215,001 - 220,000 | $13.50 | $15.00 | $16.75 | $18.75 | $25.00 | $26.50 | $28.00 |
2 | 210,001 - 215,000 | $13.00 | $14.50 | $16.00 | $18.00 | $24.00 | $25.50 | $27.00 |
1 | 200,001 - 210,000 | $12.25 | $13.75 | $15.25 | $17.00 | $23.00 | $24.25 | $25.50 |
Base | 0 - 200,000 | $11.00 | $12.50 | $14.00 | $15.50 | $21.00 | $22.00 | $23.00 |
<colgroup><col><col><col span="7"></colgroup><tbody>
</tbody>