Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribed

image text in transcribed

image text in transcribed

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 Variance

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions

Question

=+8.4. Show that B 8 [W] k-0 n=1m=1 A-1

Answered: 1 week ago