Need in Cell format

GH ! Name 1 Tracey Excel 2 Standard Costs and Variances 4 The Tracey Company produces a karate robe. The company has established the following standards 5 for the production of one robe: 7 8 9 Direct material cost per robe Direc labor cost per robe Variable overhead cost per robe $18.20 $3.60 $1.20 = = 2.8 0.4 0.4 yards @ hours @ hours @ $6.50 per yard $9.00 per hour $3.00 per hour 11 During May, the company had the following actual results: 13 Actual number of robes produced 2,000 robes = 15 Direct materials puchased and used 16 Direct labor costs 17 Variable overhead costs $36,000.00 $7,600.00 $3,800.00 6,000 760 760 yards @ hours @ hours @ $6.00 per yard $10.00 per hour $5.00 per hour 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 column D. 22 For example, the formula for cell D31 should be =ABS(E26-E27) 23 You may type in U or F in column G. 25 DIRECT MATERIALS 26 Actual quantity @ actual price (AQ XAP) 27 Actual quantity @standard price (AQ XSP) 28 Standard quantiy @ standard price (SQ XSP) Variance 31 Direct Materials Price Variance 32 Direct Materials Quantity Variance 33 Direct Materials Spending Variance 35 DIRECT LABOR 36 Actual hours @ actual rate (AH XAR) 37 Actual hours @ standard rate (AH X SR) 38 Standard hours @ standard rate (SHX SR) 39 40 41 Direct Labor Rate Variance 42 Direct Labor Efficiency Variance 43 Direct Labor Spending Variance Variance 44 45 46 VARIABLE OVERHEAD 47 Actual hours @ actual rate (AH XAR) 48 Actual hours @ standard rate (AH X SR) 49 Standard hours @ standard rate (SHX SR) 50 51 Variance U/F 52 Variable Overhead Rate Variance 53 Variable Overhead Efficiency Variance 54 Variable Overhead Spending Variance