PLEASE SHOW EXCEL FORMULAS

D E G H 1 Standard Price $400 per pound $22.00 per hour 35.00 per hour C Actual price $3 80 per pound $21.60 per hour 2 per pound 2 per pound 2 per pound 3 Data 4 Exhibit 9-9. Standard Cost Card 5 Inputs Standard Quantity 6 Direct materials 3.0 pounds 7 Direct labor 0.50 hours 8 Variable manufacturing overhead 0.50 hours 9 10 Actual results 11 Actual output 2,000 units 12 Actual variable manufacture overhead cost $7140 13 Actual Quantity 14 Actual direct materials cost 5,500 pounds 15 Actual direct labor cost 1,050 hours 16 17 Enter a fomul into each of the cells marked with a ? below 18 Main Example: Chapter 9 19 20 Exhibit 9-12: Standard Cost Variance Analysis - Direct Materials 21 Actual Quantity of input, at Actual Price 2 pounds 22 Actual Quantity of Input, at Standard Price pounds 23 Standard Quantity Allowed for the Actual Output, at Standard Pro 2 pounds 24 Direct materials variances 25 Materials price variance ? 26 Materials quantity variance 7 27 Materials spending variance 2 28 29 Exhibit 9-13: Standard Cost Variance Analysis - Direct Labor 30 Actual Hours of Input at Actual Rate 2 hours 31 Actual Houn of Input, at Standard Rato 2 hours 32 Standard Hours Alowed for the Actual Output, at Standard Rate 7 hours 33 Direct labor variances 34 Laborrate variance 2 35 Labor efficiency variance ? 36 Labor spending variance ? 37 38 Exhibit 9-14: Standard Cost Variance Analysis -Variable Manufacturing Overhead 39 Actual Hours of Input at Actual Rate 2 hours 40 Actual Hours of Input, at Standard Rate 2 hours 41 Standard Hours Allowed for the Actual Output, at Standard Rate 2 hours 42 Varable overhead vanances 43 Variable overhead rate variance 2 44 Variable overhead officiency variance ? 45 Variable overhead spending variance 17 46 47 2 per hour 2 per hour 2 per hour ? 2 2 ? per hour 2 per hour 2 per hour 2 2 2