X Insert X Direct Materials Direct Labor Variable Overhead Planned production (units) Actual cost information is...

Transcribed Image Text:

X Insert X Direct Materials Direct Labor Variable Overhead Planned production (units) Actual cost information is below: Units Produced Materials Purchased and Used Cost of Direct Materials Direct Labor Hours Direct Labor Cost Variable Overhead Cost Fixed Overhead Cost PART #2: Direct Labor Variances Standard Standard Cost per Qty/Hrs per Standard Cost per DM/Hour $7.50 $19.00 Unit 2.5 2 Unit $18.75 $6.50 22 $38.00 2 $13.00 10,000 9,500 27,500 $181,000 18,500 $406,000 $115,000 $325,000 Comm P Add-ins Analyze Data K rd x Standard SP Calculate the Direct Labor Rate, Efficiency, and Spending Variance. Use the ABS function to calculate the absolute value of variance amounts in the green cells and use an IF function in the orange cells to determine the favorability ("U" or "F") of the variances, Remember to cell reference everything! Actual Actual AH AR Labor Rate Variance Direct Labor Variances Actual AH Standard SR Labor Spending Variance Labor Efficiency Variance Standard Standard SH SR X Insert X Direct Materials Direct Labor Variable Overhead Planned production (units) Actual cost information is below: Units Produced Materials Purchased and Used Cost of Direct Materials Direct Labor Hours Direct Labor Cost Variable Overhead Cost Fixed Overhead Cost PART #2: Direct Labor Variances Standard Standard Cost per Qty/Hrs per Standard Cost per DM/Hour $7.50 $19.00 Unit 2.5 2 Unit $18.75 $6.50 22 $38.00 2 $13.00 10,000 9,500 27,500 $181,000 18,500 $406,000 $115,000 $325,000 Comm P Add-ins Analyze Data K rd x Standard SP Calculate the Direct Labor Rate, Efficiency, and Spending Variance. Use the ABS function to calculate the absolute value of variance amounts in the green cells and use an IF function in the orange cells to determine the favorability ("U" or "F") of the variances, Remember to cell reference everything! Actual Actual AH AR Labor Rate Variance Direct Labor Variances Actual AH Standard SR Labor Spending Variance Labor Efficiency Variance Standard Standard SH SR