# ch10 workbk.xlsx - Chapter 10 Applying Excel Data Exhibit...

• 10
• 100% (2) 2 out of 2 people found this document helpful

This preview shows page 1 - 2 out of 10 pages.

0a76339c758b5f0057e86139a4631e2f910659ba.xlsx 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 Actual Quantity of Input, at Actual Price 6,000 \$4.00 per pound = Actual Quantity of Input, at Standard Price 6,500 \$4.00 per pound = Standard Quantity Allowed for the Actual Output, at Standard Price 6,500 \$3.80 per pound = Direct materials variances: Materials price variance \$2,000 F Materials quantity variance \$1,300 U Materials spending variance \$700 F Actual Hours of Input, at Actual Rate 1,000 hours × \$22.00 per hour = Actual Hours of Input, at Standard Rate 1,050 hours × \$22.00 per hour =
Page 1