complete this lab and answer it in formulas like this for EXAMPLE (=B14-C7) and so on, do it in formulas version and follow the correct numbers and letters on the pages I will upload

write the column number, and the answer next to it in FORMULA

1. Compute the direct material, direct labor and variable overhead variances. KE - ? - Basic variance analysis for direct materials, direct labor and variable overhead - Excel INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW FILE sign HOME Calberi A - 11 -A A A Paste B I U - Alignment Number Conditional Format as Cell Formatting Table Styles Cells Editing Clipboard A28 Price Variance - AQ (SP 1 The standard cost card for a single unit of Robinson, Inc.'s products is shown below Standard Price/Rate Standard Unit Cost Standard Quantity 2.5 yards @ 0.5 hourse 0.5 hours e 4 Direct materials 5 Direct labor Variable overhead (based on labor hours): $20.00 58.00 per yard $18.00 per hour $10.00 per hour 5.00 & Budgeted production for the month Actual production for the month 13.500 units 11 Actual Costs incurred to Produce 13.500 units 12 Direct Materials Purchased and Used 13 Direct Labor Paid 14 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 Clipboard BIU. SARU Formatting Table Styles Font Styles fax Price Variance - AQ* (SP-AP) A28 Complete the following table comparing actual costs to the flexible budget and master budget. Use formulas for 10 the spending and volume variances so that variance will appear as a negative number if unfavorable and a positive number if favorable. Spending Variances Flexible Budget Volume Variances Master Budget 19 Direct materials: 20 Direct labor: 21 Variable overhead: Actual Costs $245,700 $129,938 $89.100 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. Variance For U 27 Direct materials: 28 Price Variance - AQ (SP-AP) 29 Quantity Variance - SP (SQ-AQ) 30 Total Spending Variance 31 Direct Labor Rate Variance - AH (SR-AR) Efficiency Variance SR (SHAH) 34 Total Spending Variance 33 36 37 38 Rate Variance-AH(SR-AR) Efficiency Variance ESR (SH - AH) Total Spending Variance Score ans