Answered step by step
Verified Expert Solution
Question
00
1 Approved Answer
Compute the direct material, direct labor and variable overhead variances. Please solve Yellow with excel formulas and Please show the formulas clearly. Thanks The standard
Compute the direct material, direct labor and variable overhead variances.
Please solve Yellow with excel formulas and Please show the formulas clearly.
Thanks
The standard cost card for a single unit of Robinson, Inc.'s products is shown below. Direct materials: Direct labor: 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 Standard Unit Cost $20.00 9.00 5.00 Budgeted production for the month Actual production for the month 14,000 units 13,500 units Actual Costs Incurred to Produce 13,500 units: Direct Materials Purchased and Used Direct Labor Paid 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. 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 Flexible Volume Master Actual Costs Variances Budget Variances Budget Direct materials: $245,700 Direct labor: $129,938 Variable overhead: $89,100 Ilcine the formular orasided somuto the following wariance Using the formulas provided, compute the following variances. Write if statements to enter an For U to indicate whether the variance is favorable or unfavorable. Variance For U Direct materials: Price Variance = AQ * (SP-AP) Quantity Variance = SP * (SQ-AQ) Total Spending Variance Direct Labor Rate Variance = AH * (SR - AR) Efficiency Variance = SR* (SH-AH) Total Spending Variance Variable Overhead Rate Variance = AH * (SR - AR) Efficiency Variance = SR* (SH - AH) Total Spending VarianceStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started