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.
[TABLE="width: 392"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]Casting Operator[/TD]
[TD="align: right"]$16.00[/TD]
[TD="align: right"]2[/TD]
[TD]Technical 3[/TD]
[/TR]
[TR]
[TD]Casting Operator[/TD]
[TD="align: right"]$16.00[/TD]
[TD="align: right"]2[/TD]
[TD]Technical 3[/TD]
[/TR]
[TR]
[TD]Draw Bench Operator[/TD]
[TD="align: right"]$16.00[/TD]
[TD="align: right"]2[/TD]
[TD]Technical 3[/TD]
[/TR]
[TR]
[TD]Storeroom Attendant[/TD]
[TD="align: right"]$16.00[/TD]
[TD="align: right"]2[/TD]
[TD]Technical 3[/TD]
[/TR]
[TR]
[TD]Quality Assurance[/TD]
[TD="align: right"]$16.00[/TD]
[TD="align: right"]2[/TD]
[TD]Technical 3[/TD]
[/TR]
[TR]
[TD]Material Handler[/TD]
[TD="align: right"]$13.00[/TD]
[TD="align: right"]2[/TD]
[TD]General 1[/TD]
[/TR]
[TR]
[TD]Material Handler[/TD]
[TD="align: right"]$14.50[/TD]
[TD="align: right"]2[/TD]
[TD]General 2[/TD]
[/TR]
[TR]
[TD]Maintenance Mechanic[/TD]
[TD="align: right"]$24.00[/TD]
[TD="align: right"]2[/TD]
[TD]Technical 5[/TD]
[/TR]
[TR]
[TD]Maintenance Electrician[/TD]
[TD="align: right"]$27.00[/TD]
[TD="align: right"]2[/TD]
[TD]Technical 7[/TD]
[/TR]
[TR]
[TD]FL1 Operator[/TD]
[TD="align: right"]$16.00[/TD]
[TD="align: right"]2[/TD]
[TD]Technical 3[/TD]
[/TR]
[TR]
[TD]Casting Operator[/TD]
[TD="align: right"]$16.00[/TD]
[TD="align: right"]2[/TD]
[TD]Technical 3[/TD]
[/TR]
[TR]
[TD]Casting Operator[/TD]
[TD="align: right"]$16.00[/TD]
[TD="align: right"]2[/TD]
[TD]Technical 3[/TD]
[/TR]
[TR]
[TD]Casting Operator[/TD]
[TD="align: right"]$16.00[/TD]
[TD="align: right"]2[/TD]
[TD]Technical 3[/TD]
[/TR]
[TR]
[TD]Casting Supervisor[/TD]
[TD="align: right"]$18.00[/TD]
[TD="align: right"]2[/TD]
[TD]Technical 4[/TD]
[/TR]
[TR]
[TD]Casting Operator[/TD]
[TD="align: right"]$16.00[/TD]
[TD="align: right"]2[/TD]
[TD]Technical 3[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 656"]
<colgroup><col><col><col span="7"></colgroup><tbody>[TR]
[TD="colspan: 2"]Production[/TD]
[TD]General 1[/TD]
[TD]General 2[/TD]
[TD]Technical 3[/TD]
[TD]Technical 4[/TD]
[TD]Technical 5[/TD]
[TD]Technical 6[/TD]
[TD]Technical 7[/TD]
[/TR]
[TR]
[TD]Level[/TD]
[TD]Pounds / Week[/TD]
[TD]G1[/TD]
[TD]G2[/TD]
[TD]T3[/TD]
[TD]T4[/TD]
[TD]T5[/TD]
[TD]T6[/TD]
[TD]T7[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]250,001 - ∞[/TD]
[TD]$15.00[/TD]
[TD]$16.50[/TD]
[TD]$20.50[/TD]
[TD]$23.00[/TD]
[TD]$30.50[/TD]
[TD]$32.00[/TD]
[TD]$34.00[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]240,001 - 250,000[/TD]
[TD]$15.25[/TD]
[TD]$16.25[/TD]
[TD]$19.00[/TD]
[TD]$21.50[/TD]
[TD]$28.50[/TD]
[TD]$30.00[/TD]
[TD]$32.00[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]230,001 - 240,000[/TD]
[TD]$14.50[/TD]
[TD]$16.00[/TD]
[TD]$18.25[/TD]
[TD]$20.25[/TD]
[TD]$27.00[/TD]
[TD]$28.75[/TD]
[TD]$30.50[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]220,001 - 230,000[/TD]
[TD]$14.00[/TD]
[TD]$15.50[/TD]
[TD]$17.50[/TD]
[TD]$19.50[/TD]
[TD]$26.00[/TD]
[TD]$27.50[/TD]
[TD]$29.50[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]215,001 - 220,000[/TD]
[TD]$13.50[/TD]
[TD]$15.00[/TD]
[TD]$16.75[/TD]
[TD]$18.75[/TD]
[TD]$25.00[/TD]
[TD]$26.50[/TD]
[TD]$28.00[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]210,001 - 215,000[/TD]
[TD]$13.00[/TD]
[TD]$14.50[/TD]
[TD]$16.00[/TD]
[TD]$18.00[/TD]
[TD]$24.00[/TD]
[TD]$25.50[/TD]
[TD]$27.00[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]200,001 - 210,000[/TD]
[TD]$12.25[/TD]
[TD]$13.75[/TD]
[TD]$15.25[/TD]
[TD]$17.00[/TD]
[TD]$23.00[/TD]
[TD]$24.25[/TD]
[TD]$25.50[/TD]
[/TR]
[TR]
[TD]Base [/TD]
[TD] 0 - 200,000[/TD]
[TD]$11.00[/TD]
[TD]$12.50[/TD]
[TD]$14.00[/TD]
[TD]$15.50[/TD]
[TD]$21.00[/TD]
[TD]$22.00[/TD]
[TD]$23.00[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 392"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]Casting Operator[/TD]
[TD="align: right"]$16.00[/TD]
[TD="align: right"]2[/TD]
[TD]Technical 3[/TD]
[/TR]
[TR]
[TD]Casting Operator[/TD]
[TD="align: right"]$16.00[/TD]
[TD="align: right"]2[/TD]
[TD]Technical 3[/TD]
[/TR]
[TR]
[TD]Draw Bench Operator[/TD]
[TD="align: right"]$16.00[/TD]
[TD="align: right"]2[/TD]
[TD]Technical 3[/TD]
[/TR]
[TR]
[TD]Storeroom Attendant[/TD]
[TD="align: right"]$16.00[/TD]
[TD="align: right"]2[/TD]
[TD]Technical 3[/TD]
[/TR]
[TR]
[TD]Quality Assurance[/TD]
[TD="align: right"]$16.00[/TD]
[TD="align: right"]2[/TD]
[TD]Technical 3[/TD]
[/TR]
[TR]
[TD]Material Handler[/TD]
[TD="align: right"]$13.00[/TD]
[TD="align: right"]2[/TD]
[TD]General 1[/TD]
[/TR]
[TR]
[TD]Material Handler[/TD]
[TD="align: right"]$14.50[/TD]
[TD="align: right"]2[/TD]
[TD]General 2[/TD]
[/TR]
[TR]
[TD]Maintenance Mechanic[/TD]
[TD="align: right"]$24.00[/TD]
[TD="align: right"]2[/TD]
[TD]Technical 5[/TD]
[/TR]
[TR]
[TD]Maintenance Electrician[/TD]
[TD="align: right"]$27.00[/TD]
[TD="align: right"]2[/TD]
[TD]Technical 7[/TD]
[/TR]
[TR]
[TD]FL1 Operator[/TD]
[TD="align: right"]$16.00[/TD]
[TD="align: right"]2[/TD]
[TD]Technical 3[/TD]
[/TR]
[TR]
[TD]Casting Operator[/TD]
[TD="align: right"]$16.00[/TD]
[TD="align: right"]2[/TD]
[TD]Technical 3[/TD]
[/TR]
[TR]
[TD]Casting Operator[/TD]
[TD="align: right"]$16.00[/TD]
[TD="align: right"]2[/TD]
[TD]Technical 3[/TD]
[/TR]
[TR]
[TD]Casting Operator[/TD]
[TD="align: right"]$16.00[/TD]
[TD="align: right"]2[/TD]
[TD]Technical 3[/TD]
[/TR]
[TR]
[TD]Casting Supervisor[/TD]
[TD="align: right"]$18.00[/TD]
[TD="align: right"]2[/TD]
[TD]Technical 4[/TD]
[/TR]
[TR]
[TD]Casting Operator[/TD]
[TD="align: right"]$16.00[/TD]
[TD="align: right"]2[/TD]
[TD]Technical 3[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 656"]
<colgroup><col><col><col span="7"></colgroup><tbody>[TR]
[TD="colspan: 2"]Production[/TD]
[TD]General 1[/TD]
[TD]General 2[/TD]
[TD]Technical 3[/TD]
[TD]Technical 4[/TD]
[TD]Technical 5[/TD]
[TD]Technical 6[/TD]
[TD]Technical 7[/TD]
[/TR]
[TR]
[TD]Level[/TD]
[TD]Pounds / Week[/TD]
[TD]G1[/TD]
[TD]G2[/TD]
[TD]T3[/TD]
[TD]T4[/TD]
[TD]T5[/TD]
[TD]T6[/TD]
[TD]T7[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]250,001 - ∞[/TD]
[TD]$15.00[/TD]
[TD]$16.50[/TD]
[TD]$20.50[/TD]
[TD]$23.00[/TD]
[TD]$30.50[/TD]
[TD]$32.00[/TD]
[TD]$34.00[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]240,001 - 250,000[/TD]
[TD]$15.25[/TD]
[TD]$16.25[/TD]
[TD]$19.00[/TD]
[TD]$21.50[/TD]
[TD]$28.50[/TD]
[TD]$30.00[/TD]
[TD]$32.00[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]230,001 - 240,000[/TD]
[TD]$14.50[/TD]
[TD]$16.00[/TD]
[TD]$18.25[/TD]
[TD]$20.25[/TD]
[TD]$27.00[/TD]
[TD]$28.75[/TD]
[TD]$30.50[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]220,001 - 230,000[/TD]
[TD]$14.00[/TD]
[TD]$15.50[/TD]
[TD]$17.50[/TD]
[TD]$19.50[/TD]
[TD]$26.00[/TD]
[TD]$27.50[/TD]
[TD]$29.50[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]215,001 - 220,000[/TD]
[TD]$13.50[/TD]
[TD]$15.00[/TD]
[TD]$16.75[/TD]
[TD]$18.75[/TD]
[TD]$25.00[/TD]
[TD]$26.50[/TD]
[TD]$28.00[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]210,001 - 215,000[/TD]
[TD]$13.00[/TD]
[TD]$14.50[/TD]
[TD]$16.00[/TD]
[TD]$18.00[/TD]
[TD]$24.00[/TD]
[TD]$25.50[/TD]
[TD]$27.00[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]200,001 - 210,000[/TD]
[TD]$12.25[/TD]
[TD]$13.75[/TD]
[TD]$15.25[/TD]
[TD]$17.00[/TD]
[TD]$23.00[/TD]
[TD]$24.25[/TD]
[TD]$25.50[/TD]
[/TR]
[TR]
[TD]Base [/TD]
[TD] 0 - 200,000[/TD]
[TD]$11.00[/TD]
[TD]$12.50[/TD]
[TD]$14.00[/TD]
[TD]$15.50[/TD]
[TD]$21.00[/TD]
[TD]$22.00[/TD]
[TD]$23.00[/TD]
[/TR]
</tbody>[/TABLE]