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

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

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture