Standards for one of Patterson, Inc.$\text{'}$s products is shown below, along with actual cost data for the month:

Variable overhead is assigned to products based on direct labor hours. There was no beginning or ending inventory of materlals for the month.

Required:

Using formulas, compute the following. Input all numbers as positive amounts.

$($Hint: This con be done using the ABS function$).$

$($Use cells AS to G$16$ from the given information to complete this question. All formulas must return positive values. For each variance, select either "Favorable" or "Unfavorable".

Standord Cost Variance Analysis $-$ Direct Materiols

Standard Quantity Allowed for Actual Output at Standard Price

Actual Quantity of Input, at Standard Price

Actual Quantity of Input, at Actual Price

Materials quantity variance

Materials price variance

Standard Cost Variance Analysis $-$ Direct Labor

Standard Hours Allowed for Actual Output at Standard Rate

Actual Hours of Input, at Standard Rate

Actual Hours of Input, at Actual Rate

Labor efficiency variance

Labor rate variance

Using formulas, compute the amount of the unit cost difference that is traceable to each of the variances computed above.

Materials:

Quantity variance

Price variance

Labor:

Efficiency variance

Rate variance

Variable overhead:

Efficiency variance

Rate variance

Excess of actual over standard cost per unit

Required: Please show formulas