File Home Insert Page Layout Formulas Data Review View Help Share Comments Arial 10 - AA === a Wrap Text General Currency 2 Normal_Proc. . X Cut L Copy & Format Painter 47 Currency [0] 2 Normal AutoSum Fill Clear Comma [O] 2 Conditional Format as Percent 2 Formatting Table Paste BIU A $ % 8 28 Merge & Center Bad Good Insert Delete Format Sort & Find & Filter Select Analyze Data Sensitivity Clipboard Font Alignment Number Styles Cells Editing Analysis Sensitivity A1 X Chapter 10: Applying Excel A B D E F G H L M N O 0 R S T V Chapter 10: Applying Excel Standard Price $4.00 per pound $22.00 per hour $6.00 per hour Actual price $3.80 per pound $21.60 per hour ? per pound = ? per pound = ? per pound = ? 2 ? 3 Data 4 Exhibit 10-1: 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 manufacturing overhead cost $7,140 13 Actual Quantity 14 Actual direct materials cost 6,500 pounds 15 Actual direct labor cost 1,050 hours 16 17 Enter a formula into each of the cells marked with a ? below 18 Main Example: Chapter 10 19 20 Exhibit 10-4: Standard Cost Variance Analysis-Direct Materials 21 Standard Quantity Allowed for the Actual Output, at Standard Price ? pounds x 22 Actual Quantity of Input, at Standard Price ? pounds x 23 Actual Quantity of Input, at Actual Price ? pounds x 24 Direct materials variances: 25 Materials quantity variance ? 26 Materials price variance ? 27 Materials spending variance ? 28 29 Exhibit 10-6: Standard Cost Variance Analysis-Direct Labor 30 Standard Hours Allowed for the Actual Output, at Standard Rate ? hours x 31 Actual Hours of Input, at Standard Rate ? hours x 32 Actual Hours of Input, at Actual Rate ? hours x 33 Direct labor variances: 34 Labor efficiency variance ? 35 Labor rate variance ? 2 36 Labor spending variance 37 38 Exhibit 10-8: Standard Cost Variance Analysis - Variable Manufacturing Overhead 39 Standard Hours Allowed for the Actual Output, at Standard Rate ? hours x 40 Actual Hours of Input, at Standard Rate ? hours x 41 Actual Hours of Input, at Actual Rate ? hours x 42 Variable overhead variances: 43 Variable overhead efficiency variance ? 44 Variable overhead rate variance ? 45 Variable overhead spending variance ? Chapter 10 Form + ? per hour = ? per hour = ? per hour = ? ? ? per hour = ? per hour = ? per hour = ? ? ? 1 + 100%