Enter as cells

C22 1 23 4 55 6 Direct materials: Direct labor: 7 Variable overhead (based on labor hours): 8 9 Budgeted production for the month 10 Actual production for the month 11 fx 18 A 12 Actual Costs Incurred to Produce 13,500 units: 13 Direct Materials Purchased and Used 14 Direct Labor Paid 15 Variable Overhead Incurred 16 17 21 The standard cost card for a single unit of Robinson, Incorporated's products is shown below. 22 Direct materials: 23 Direct labor: 24 Variable overhead: B C Standard Quantity 2.5 yards @ 0.5 hours @ 0.5 hours @ 14,000 units 13,500 units Standard Quantity 35,100 yards @ 7,425 hours @ 7,425 hours @ Actual Costs $245,700 $129,938 $89,100 D E Standard Price/Rate $8.00 per yard $18.00 per hour $10.00 per hour Standard Price/Rate $7.00 per yard $17.50 per hour $12.00 per hour Spending Flexible Variances Budget F 1. Compute the direct material, direct labor and variable overhead variances. 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. 19 Note: Use cell A2 to A15 from the given information to complete this question. 20 Standard Unit Cost $20.00 9.00 5.00 Total Actual Cost $245,700 $129,938 $89,100 G Volume Variances Master Budget H

The standard cost card for a single unit of Robinson, incorporated's products is shown below. \begin{tabular}{|c|c|c|c|c|} \hline & Standard Quantity & \multicolumn{2}{|c|}{ Standard Price/Rate } & Standard Unit Cost \\ \hline Direct materials: & 2.5 yards & $800 & per yard & $20.00 \\ \hline Direct labor: & 0.5 hours 9 & $18.00 & per hour & 9.00 \\ \hline Variable overhead (based on labor hours). & 0.5 hours 8 & $10.00 & per hour & 5.00 \\ \hline \end{tabular} \begin{tabular}{|l|r|l|} \hline Budgeted production for the month & 14,000 & units \\ \hline Actual production for the month & 13,500 & units \\ \hline \end{tabular} 1. Compute the direct material, direct labor and variable overhead variances. 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 wi appear as a negative number if unfavorable and a positwe number if favorable. Note: Use cell A2 to A15 from the given information to completthis question. Note: Use cell A2 to A15 from the given information to complete this question. Using the formulas provided, compute the following variances. Write if statements to enter an f or U to indicate whether the variance is favoratile or unfavorable. Note: Uie cell A2 to A15 from the given information to complete this question. Question Ti Integrated Exci Variance Analy Labor and Vari Check Ansv Legend Graded cell needed. Scretchpad: workspoce