c$.$ Provide formulas for regular pay $($D$10),$ overtime pay $($E$10),$ gross pay $($F$10),$ tax withholding $($G$10),$ net pay $(H10),$ and benefit amount $($I$10)$ as indicated. In each formula, use an absolute reference for pay rate $($B$3),$ overtime limit $($B$4),$ overtime extra $($B$5),$ tax rate $($B$6),$ and benefit rate $($B$7)$ as needed.

Compute regular pay $($D$10)$ as the minimum $($MIN$)$ of $($hours $($C$10),$ overtime limit $($B$4))$ times pay rate $($B$3).$ Use absolute references as indicated in $($c$).$

Compute overtime pay $($E$10)$ as the maximum $($MAX$)$ of $($hours $($C$10)$ minus overtime limit $($B$4),0)$ times pay rate $($B$3)$ times overtime extra $($B$5).$ Use absolute references as indicated in $($c$).$

Compute gross pay $($F$10)$ as regular pay $($D$10)$ plus overtime pay $($E$10).$

Compute tax withholding $($G$10)$ as gross pay $($F$10)$ times tax rate $($B$6).$ Use absolute references as indicated in $($c$).$

Compute net pay $($H$10)$ as gross pay $($F$10)$ minus tax withholding $($G$10).$

Compute benefit amount $($I$10)$ as gross pay $($F$10)$ times benefit rate $($B$7).$ Use absolute references as indicated in $($c$).$

Assignment$02$

$\backslash$table$[[40,630],[45,708\mathrm{.}75],[35,551\mathrm{.}25],[50,787\mathrm{.}5],[38,598\mathrm{.}5],[40,630],[42,661\mathrm{.}5],[25,393\mathrm{.}75],[40,630],[40,630]]$

Totals for

$23$

$24$