A

B

C

D

E

F

G

H

$1q,$

$2$ The standard cost card for a single unit of Robinson, Incorporated's products is shown below.

$3$

$\backslash$table$[[,,,]]$

$8$

$\backslash$table$[[$Budgeted production for the month,$14,000,$units$],[$Actual production for the month,$13,500,$nits$]]$

$10$ Actual production for the month

$\backslash$table$[[$Actual Costs Incurred to Produce $13,500$ units:,Standard Quantity,Standard Price$/$Rate$],[$Direct Materials Purchased and Used,$35,100,$yards @$,$$$7\mathrm{.}00,$per yard$],[$Direct Labor Paied,$7,425,$hours @$,$$$17\mathrm{.}50,$per hour$],[$Variable Overhead Incurred,$7,425,$hours @$,$$$245,700,]]$

$171.$ Compute the direct material, direct labor and variable overhead variances.

$18$

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 appear as a negative number if unfavorable and a positive number if favorable.

$19$ Note: Use cell A$2$ to A$15$ from the given information to complete this question.

$20$

$21$

$22$

$\backslash$table$[[,$Actual Costs,$\backslash$table$[[$Spending$],[$Variances$]],\backslash$table$[[$Flexible$],[$Budget$]],\backslash$table$[[$Volume$],[$Variances$]]],[$Direct materials:,$$245,700,,$$$10,800,],[$Direct labor:,$$129,938,,-,],[$Variable overhead:,$$89,100,,,]]$

Using the formulas provided, compute the following variances.

Write if statements to enter an F or $U$ to indicate whether the variance is favorable or unfavorable.

Note: Use cell A$2$ to A$15$ from the given information to complete this question.

Direct materials:

$\backslash$table$[[$Variance$,$For U$],[$F$,$F$]]$

Graded Worksheet