Need to fill in empty yellow cells with FORUMLAS ONLY.

H A C E G Standards for one of Patterson, Inc.'s products is shown below, along with actual cost data for the month 1 2 3 Direct materials: $2.75 per yard 4 Standard 2.4 yards 3 yards $6.60 5 Actual $2.70 per yard $8.10 6 Direct labor: 7 Standard $18.00 per hour $22.00 per hour 10.80 0.6 hours 0.5 hours 8 Actual 11.00 9 Variable overhead: 10 Standard 0.6 hours@ $7.00 per hour 4.20 11 Actual 0.5 hours @ $7.10 per hour 3.55 12 $21.60 $22.65 13 Total cost per unit 14 $1.05 15 Excess of actual cost over standard cost per unit 16 13,500 units 17 Actual production for the month 18 Variable overhead is assigned to products based on direct labor hours. There 19 was no beginning or ending inventory of materials for the month 20 21 Using formulas, compute the following. Input all numbers as positive amounts Indicate whether the variances are F or U. Write if statements for variance cells F30 to F47. Use 22 cell references (formulas) for cells D53 - D60. Enter an F or U to indicate the correct variance in cells F54 to F62. A D G Indicate whether the variances are F or U. Write if statements for variance cells F30 to F47. Use 22 cell references (formulas) for cells D53 cells F54 to F62 D60. Enter an F or U to indicate the correct variance in 23 24 25 Standard Cost Variance Analysis - Direct Materials 89,100 Standard Quantity Allowed for Actual Output at Standard Price 26 111,375 Actual Quantity of Input, at Standard Price 27 109,350 Actual Quantity of Input, at Actual Price 28 29 S 22,275 U Materials quantity variance 30 2,025 F Materials price variance 31 32 33 Standard Cost Variance Analysis - Direct Labor 145,800 Standard Hours Allowed for Actual Output at Standard Rate 34 121,500 Actual Hours of Input, at Standard Rate 35 148,500 Actual Hours of Input, at Actual Rate 36 37 24,300 F Labor efficiency variance 38 Labor rate variance 27,000 U 39 40 41 Standard Cost Variance Analysis - Variable Manufacturing Overhead 56,700 Standard Hours Allowed for Actual Output at Standard Rate 42 47,250 Actual Hours of Input. at Standard Rate 43 Sheet1 READY 100% 41 Standard Cost Variance Analysis - Variable Manufacturing Overhead 56,700 Standard Hours Allowed for Actual Output at Standard Rate 42 47,250 Actual Hours of Input, at Standard Rate 43 47,925 Actual Hours of Input, at Actual Rate 44 45 9,450 F Variable overhead efficiency variance 46 675 U Variable overhead rate variance 47 48 49 Using formulas, compute the amount of the unit cost difference 50 that is traceable to each of the variances computed above 51 52 Materials: $1.65 U 53 Quantity variance $0.15 F $1.50 Price variance 54 55 Labor $1.80 F 56 Efficiency variance 57 Rate variance $2.00 U 0.20 58 Variable overhead: $0.70 F Efficiency variance 59 $0.05 U 0.65 Rate variance 60 61 62 Excess of actual over standard cost per unit $1.05 63 Sheet 45 9,450 F Variable overhead efficiency variance 46 675 U Variable overhead rate variance 47 48 49 Using formulas, compute the amount of the unit cost difference 50 that is traceable to each of the variances computed above 51 52 Materials 53 Quantity variance $1.65 U $0.15 F $1.50 54 Price variance 55 Labor 56 Efficiency variance $1.80 F $2.00 U 0.20 57 Rate variance 58 Variable overhead $0.70 F 59 Efficiency variance 60 Rate variance $0.05 U 0.65 61 $1.05 62 Excess of actual over standard cost per unit 63 64 65 66