did Tracy company produces a karate robe for the month of May the company had the following information for the flexible budget. please give formulas for all yellow cells and use =ABS() in formulas for column D. please and thank you!

L M A B C D F G H K 5 The Tracey Company produces a karate robe. For the month of May, the company had the following 5 information for their flexible budget: 7 3 Actual number of robes produced 2,000 robes = O Direct material cost per robe $18.20 2.8 yards @ $6.50 per yard 1 2 Direc labor cost per robe $3.60 0.4 hours @ $9 per hour 3 4 Variable overhead cost per robe $1.20 0.4 hours @ $3 per hour 5 6 Required: 7 (1) Complete the flexible budget in column J below. All yellow cells must be a formula or cell reference 8 9 (2) Complete the report below, indicating the spending yariances and whether the variance is O Unfavorable (type in U) or Favorable (type in F). Variances should be shown as a postive number so 1 use the =ABS() in your formulas for column D. 2 3 4 5 You may type in U or Fin column G. did these formulas for you so use them as a guide. 6 Actual Spending Flexible 27 Results Variance U/F Budget 28 29 Direct materials $36,000.00 $400.00 $36,400.00 30 Sheet1 3 M o N wm P B D F G H 12 Direc labor cost per robe $3.60 0.4 hours @ $9 per hour 13 14 Variable overhead cost per robe $1.20 0.4 hours @ $3 per hour 15 16 Required: 17 (1) Complete the flexible budget in column) below. All yellow cells must be a formula or cell reference. 18 19 (2) Complete the report below, indicating the spending variances and whether the variance is 20 Unfavorable (type in U) or Favorable (type in F). Variances should be shown as a postive number so 21 use the =ABS() in your formulas for column D. 22 23 24 25 You may type in U or F in column G. did these formulas for you so use them as a guide. 26 Actual Spending Flexible 27 Results Variance Budget 28 29 Direct materials $36,000.00 $400.00 F. $36,400.00 30 31 Direct labor $7,600.00 U 32 U 33 Variable overhead $3,800.00 34 35 36 Rubric Each yellow cell is worth 2 points. 37 Each green cell is worth 1 point. UJF