5 ? X X2 H FILE Basic variance analysis for direct materials, direct labor and variable overhead - Excel INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW - Sign In HOME Os do Calibri Paste B I -11-AA = U- B - A Alignment Number Conditional Format as Cell Cells Editing Formatting Table Styles - Font X fc The standard cost card for a single unit of Robinson, Inc.'s products is shown Clipboard Styles The standard cost card for a single unit of Robinson, Inc.'s products is shown below. Standard Unit Cost 4 Direct materials: 5 Direct labor: 6 Variable overhead (based on labor hours): Standard Quantity 2.5 yards @ 0.5 hours @ 0.5 hours @ Standard Price/Rate $8.00 per yard $18.00 per hour $10.00 per hour $20.00 9.00 5.00 8 Budgeted production for the month Actual production for the month 14,000 units 13,500 units 11 Actual Costs incurred to Produce 13,500 units: 12 Direct Materials Purchased and Used 13 Direct Labor Paid 14 Variable Overhead Incurred 35,100 yards @ 7,425 hours @ 7,425 hours @ $7.00 per yard $17.50 per hour $12.00 per hour Total Actual Cost $245,700 $ 129,938 $89,100 Complete the following table comparing actual costs to the flexible budget and master budget. Use formulas for the spending and volume variances so that variance will appear as a negative number if unfavorable and a positive number if favorable. Spending Variances Flexible Budget Volume Variances Master Budget 19 Direct materials: 20 Direct labor: Actual Costs $245,700 $129,938 ... Sheet1 ... + 19 Direct materials: 20 Direct labor: 21 Variable overhead: $245,700 $129,938 $89,100 24 Using the formulas provided, compute the following variances. 25 Write if statements to enter an For U to indicate whether the variance is favorable or unfavorable. Variance For U 27 Direct materials: 28 Price Variance = AQ * (SP-AP) 29 Quantity Variance = SP * (SQ-AQ) 30 Total Spending Variance 31 Direct Labor 32 Rate Variance = AH * (SR - AR) 33 Efficiency Variance = SR* (SH - AH) 34 Total Spending Variance 35 Variable Overhead Rate Variance = AH * (SR - AR) Efficiency Variance = SR * (SH - AH) Total Spending Variance 36 ... Sheet1 ... 4 5 ? X X2 H FILE Basic variance analysis for direct materials, direct labor and variable overhead - Excel INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW - Sign In HOME Os do Calibri Paste B I -11-AA = U- B - A Alignment Number Conditional Format as Cell Cells Editing Formatting Table Styles - Font X fc The standard cost card for a single unit of Robinson, Inc.'s products is shown Clipboard Styles The standard cost card for a single unit of Robinson, Inc.'s products is shown below. Standard Unit Cost 4 Direct materials: 5 Direct labor: 6 Variable overhead (based on labor hours): Standard Quantity 2.5 yards @ 0.5 hours @ 0.5 hours @ Standard Price/Rate $8.00 per yard $18.00 per hour $10.00 per hour $20.00 9.00 5.00 8 Budgeted production for the month Actual production for the month 14,000 units 13,500 units 11 Actual Costs incurred to Produce 13,500 units: 12 Direct Materials Purchased and Used 13 Direct Labor Paid 14 Variable Overhead Incurred 35,100 yards @ 7,425 hours @ 7,425 hours @ $7.00 per yard $17.50 per hour $12.00 per hour Total Actual Cost $245,700 $ 129,938 $89,100 Complete the following table comparing actual costs to the flexible budget and master budget. Use formulas for the spending and volume variances so that variance will appear as a negative number if unfavorable and a positive number if favorable. Spending Variances Flexible Budget Volume Variances Master Budget 19 Direct materials: 20 Direct labor: Actual Costs $245,700 $129,938 ... Sheet1 ... + 19 Direct materials: 20 Direct labor: 21 Variable overhead: $245,700 $129,938 $89,100 24 Using the formulas provided, compute the following variances. 25 Write if statements to enter an For U to indicate whether the variance is favorable or unfavorable. Variance For U 27 Direct materials: 28 Price Variance = AQ * (SP-AP) 29 Quantity Variance = SP * (SQ-AQ) 30 Total Spending Variance 31 Direct Labor 32 Rate Variance = AH * (SR - AR) 33 Efficiency Variance = SR* (SH - AH) 34 Total Spending Variance 35 Variable Overhead Rate Variance = AH * (SR - AR) Efficiency Variance = SR * (SH - AH) Total Spending Variance 36 ... Sheet1 ... 4