please solve and answer with excel formula as solution

Please solve and answer with Excel formulas as solutions! Please solve and answer with Excel formulas as solutions! l 16 _-__ 17 Actual production for the month 13,500 units 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. A B C D E F G H 21 Using formulas, compute the follovving. Input all numbers as positive amounts. Indicate whether the variances are F or U. Write if statements for variance cells F30 to F 47. Use cell references (formulas) for cells D53 - D60. Enter an F or U to indicate the correct variance in cells F54 to F62. 22 23 24 25 Standard Cost Variance Analysis - Direct Materthls 26 Standard Quantity Allowed for Actual Output at Standard Price 27 Actual Quantity of Input. at Standard Price 28 Actual Quantity of Input, at Actual Price 29 30 Materials quantity variance 31 Materials price variance 32 Act i vs :6 Wi I1 (1 -::-'-:-.-'s 33 Standard Cost Variance Analysis - Direct Labor 34 Standard Hours Allowed for Actual Output at Standard Rate 35 Actual Hours of Input, at Standard Rate 35 Actual Hours of Input, at Actual Rate 37 33 Labor efcienCy variance 39 Labor rate variance A B C D E 40 41 Standard Cast Variance Analysis - Variable Manufacturing Overhead 42 Standard Hours Allowed for Actual Output at Standard Rate