Please use and show cell references and formulas!! Thank You?

4 The Tracey Company produces a karate robe. The company has established the following standards 5 for the production of one robe 6 7 Direct material cost per robe 8 Direc labor cost per robe 9 Variable overhead cost per robe 10 11 During May, the company had the following actual results: 12 13 14 15 Direct materials puchased and used 16 Direct labor costs 17 Variable overhead costs 18 19 Required 20 Compute the following variances, indicating whether the variance is Unfavorable (type in U) or Favorable 21 (type in F). Variances should be shown as a positive number so use ABS() in your formulas for columnD 22 For example, the formula for cell D31 should be ABS(E26-E27) 23 You may type in U or F in column G 24 25 DIRECT MATERIALS 26 Actual quantity @ actual price (AQ x AP) 27 Actual quantity @standard price (AQx SP) 28 Standard quantiy @standard price (SQ x SP) 29 30 31 Direct Materials Price Variance 32 Direct Materials Quantity Variance 33 Direct Materials Spending Variance 34 35 DIRECT LABOR 36 Actual hours@ actual rate (AH x AR) 37 Actual hours @ standard rate (AH xSR) 38 Standard hours @ standard rate (SH x SR) 39 40 41 Direct Labor Rate Variance 42 Direct Labor Efficiency Variance 43 Direct Labor Spending Variance $18.20 3.60 1.20 2.8 yards @ 0.4 hours @ 0.4 hours @ 6.50 per yard $9.00 per hour $3.00 per hour Actual number of robes produce 2,000 robes 36000.00 ,600.00 $3,800.00 6,000 yards @ 760 hours @ 760 hours @ $6.00 per yar 10.00 per hour $5.00 per hour Variance Variance U/F 45 46 VARIABLE OVERHEAD 47 Actual hours actual rate (AH x AR) 48 Actual hours@ standard rate (AH x SR) 49 Standard hours @ standard rate (SH x SR) 50 51 52 Variable Overhead Rate Variance 53 Variable Overhead Efficiency Variance 54 Variable Overhead Spending Variance Variance