Question: please answer the yellow cells with formulas. when i plug into homework i have to plug in formulas such as D1*E3. Thank you very much

Compute the direct material direct labor and varlable overhead Variances Basic variance analysis for direct materials direct lacor and vanable overhead - Excel ? 5 X FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In X Calibri 11 96 Paste BIU * Ceils Editing Alignment Number Conditional Format as Cell Formatting Table Styles Styles Clipboard Font C19 to 3 1 B D E The standard cost card for a single unit of Robinson, Inc.'s products is shown below. 2 Standard Standard Standard Quantity Price/Rate Unit Cost 4 Direct materials: 2.5 yards @ $8.00 per yard $20.00 5 Direct labor: 0.5 hours @ $18.00 per hour 9.00 5 Variable overhead (based on labor hours): 0.5 hours @ $10.00 per hour 5.00 7 Budgeted production for the month 14,000 units 9 Actual production for the month 13,500 units 10 11 Actual Costs incurred to Produce 13,500 units: Total Actual Cost 12 Direct Materials Purchased and Used 35,100 yards @ $7.00 per yard $245,700 15 Direct Labor Paid 7,425 hours $17.50 per hour 14 Variable Overhead Incurred $129,938 7,425 hours @ $12.00 per hour 15 $89,100 Complete the following table comparing actual costs to the flexible budget and master budget. Use formulas for 16 the spending and volume variances so that variance will appear as a negative number if unfavorable and a positive number if favorable. 27 18 Spending Variances 19 Direct materials: 20 Direct labor Sheet1 Flexible Budget Volume Variances Actual Costs $245,700 $129,938 Master Budget F 3 99. Basic vanance analysis for direct materials direct laborano vardue UV DATA VIEW REVIEW Sign in FILE HOME PAGE LAYOUT INSERT FORMULAS X6 Calion 11 AA 96 Ceils Paste Editing Alignment Number BIU Conditional format as Cell Formatting Table Styles Styles Clipboard Font C19 B D E F Master Budget 17 Spending Flexible Volume 18 Variances Actual Costs Budget Vanances 19 Direct materials: $245,700 20 Direct labor: $129,938 21 Variable overhead: $89.100 22 23 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. 25 27 Direct materials: Variance For U 28 Price Variance = AQ" (SP-AP) 29 Quantity Variance = SP (SQ-AQ) 30 Total Spending Variance 31 Direct Labor Rate Variance =AH (SR-AR) 33 Efficiency Variance SR (SHAH) 34 Total Spending Variance 35 Variable Overhead 35 Rate Variance AHSR-AR) 37 Emcency Variance SR SHAH 38 Total Spending Variance 19 Sheet1 READY Attemptis 3/3 100% Hint O
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
