Chapter 10: applying excel data exhibit 10-1: standard cost card inputs standard quantity standard price direct materials 3.0 pounds $4.00 per pound direct labor 0.50 hours $22.00 per hour variable manufacturing overhead 0.50 hours $6.00 per hour actual results: actual output 2,000 units actual variable manufacturing overhead cost $7,140 actual quantity actual price actual direct materials cost 6,500 pounds $3.80 per pound actual direct labor cost 1,050 hours $21.60 per hour enter a formula into each of the cells marked with a ? below main example: chapter 10 exhibit 10-4: standard cost variance analysis–direct materials actual quantity of input, at actual price ? pounds × ? per pound = ? actual quantity of input, at standard price ? pounds × ? per pound = ? standard quantity allowed for the actual output, at standard price ? pounds × ? per pound = ? direct materials variances: materials price variance ? materials quantity variance ? materials spending variance ? exhibit 10-6: standard cost variance analysis–direct labor actual hours of input, at actual rate ? hours × ? per hour = ? actual hours of input, at standard rate ? hours × ? per hour = ? standard hours allowed for the actual output, at standard rate ? hours × ? per hour = ? direct labor variances: labor rate variance ? labor efficiency variance ? labor spending variance ? exhibit 10-8: standard cost variance analysis–variable manufacturing overhead actual hours of input, at actual rate ? hours × ? per hour = ? actual hours of input, at standard rate ? hours × ? per hour = ? standard hours allowed for the actual output, at standard rate ? hours × ? per hour = ? variable overhead variances: variable overhead rate variance ? variable overhead efficiency variance ? variable overhead spending variance ?