Complete five columns on the Data worksheet: Materials price variance, Materials quantity variance, Labor rate variance, Labor time variance, and Overall variance.

For those boxes in which you must enter subtracted or negative numbers use a minus sign. If an amount is zero, enter $"0".$

R$1.$ Cell M$2$: Enter a formula that results in the materials price variance using the data in row $2.$

$

R$2.$ Cell N$2$: Enter a formula that results in the materials quantity variance using the data in row $2.$

R$3.$ Cell O$2$: Enter a formula that results in the labor rate variance using the data in row $2.$

$

R$4.$ Cell P$2$: Enter a formula that results in the labor time variance using the data in row $2.$

$

R$5.$ Cell Q$2$: Enter a formula that results in the overall variance using the data in row $2.$

$

R$6.$ Copy down the entries in cells $M2,N2,O2,P2,$ and $Q2$ to all other rows with data.