a-1. What is the materials quantity variance? Note: Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). The amount of the materials quantity variance a-2. What is the materials price variance? Note: Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). The amount of the materials price variance B34 1 Chapter 10: Applying Excel 3 Data 4 Exhibit 10-1: Standard Cost Card 6 Direct materials 7 Direct labor fx ? Variable manufacturing overhead 8 9 10 Actual results: 11 Actual output 12 Actual variable manufacturing overhead cost 13 14 Actual direct materials cost 15 Actual direct labor cost 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 22 Actual Quantity of Input, at Standard Price 23 Actual Quantity of Input, at Actual Price 24 Direct materials variances: 25 Materials quantity variance 26 27 28 29 Exhibit 10-6: Standard Cost Variance Analysis-Direct Labor 30 Standard Hours Allowed for the Actual Output, at Standard Rate Materials price variance Materials spending variance 35 Labor rate variance 46 47 48 49 A Inputs 31 Actual Hours of Input, at Standard Rate 32 Actual Hours of Input, at Actual Rate 33 Direct labor variances: 34 Labor efficiency variance Labor spending variance B Variable overhead spending variance Standard Quantity 3.0 pounds 0.50 hours 0.50 hours 2,030 units $6,975 Actual Quantity 5,855 pounds 1,125 hours 36 37 38 Exhibit 10-8: Standard Cost Variance Analysis-Variable Manufacturing Overhead 39 Standard Hours Allowed for the Actual Output, at Standard Rate 40 Actual Hours of Input, at Standard Rate 41 Actual Hours of Input, at Actual Rate 42 Variable overhead variances: 43 Variable overhead efficiency variance 44 Variable overhead rate variance 45 с ? pounds x 5,855 pounds x 5,855 pounds x $23,420 F ? U ? F ? hours * 1,125 hours * 1,125 hours ? F ? U ? F ? hours * 1,125 hours 1,125 hours ? F ? U ? D E Standard Price $4.00 per pound $22.00 per hour $6.00 per hour Actual price $4.20 per pound $22.10 per hour $4.00 per pound= $4.00 per pound= $4.20 per pound $22.00 per hour = $22.00 per hour $22.10 per hour = $6.00 per hour = $6.00 per hour = ? per hour F ? $23,420 $24,591 ? $24,750 $24,863 ? $6,750 ? G H I J K
a-1. What is the materials quantity variance? Note: Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). The amount of the materials quantity variance a-2. What is the materials price variance? Note: Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). The amount of the materials price variance B34 1 Chapter 10: Applying Excel 3 Data 4 Exhibit 10-1: Standard Cost Card 6 Direct materials 7 Direct labor fx ? Variable manufacturing overhead 8 9 10 Actual results: 11 Actual output 12 Actual variable manufacturing overhead cost 13 14 Actual direct materials cost 15 Actual direct labor cost 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 22 Actual Quantity of Input, at Standard Price 23 Actual Quantity of Input, at Actual Price 24 Direct materials variances: 25 Materials quantity variance 26 27 28 29 Exhibit 10-6: Standard Cost Variance Analysis-Direct Labor 30 Standard Hours Allowed for the Actual Output, at Standard Rate Materials price variance Materials spending variance 35 Labor rate variance 46 47 48 49 A Inputs 31 Actual Hours of Input, at Standard Rate 32 Actual Hours of Input, at Actual Rate 33 Direct labor variances: 34 Labor efficiency variance Labor spending variance B Variable overhead spending variance Standard Quantity 3.0 pounds 0.50 hours 0.50 hours 2,030 units $6,975 Actual Quantity 5,855 pounds 1,125 hours 36 37 38 Exhibit 10-8: Standard Cost Variance Analysis-Variable Manufacturing Overhead 39 Standard Hours Allowed for the Actual Output, at Standard Rate 40 Actual Hours of Input, at Standard Rate 41 Actual Hours of Input, at Actual Rate 42 Variable overhead variances: 43 Variable overhead efficiency variance 44 Variable overhead rate variance 45 с ? pounds x 5,855 pounds x 5,855 pounds x $23,420 F ? U ? F ? hours * 1,125 hours * 1,125 hours ? F ? U ? F ? hours * 1,125 hours 1,125 hours ? F ? U ? D E Standard Price $4.00 per pound $22.00 per hour $6.00 per hour Actual price $4.20 per pound $22.10 per hour $4.00 per pound= $4.00 per pound= $4.20 per pound $22.00 per hour = $22.00 per hour $22.10 per hour = $6.00 per hour = $6.00 per hour = ? per hour F ? $23,420 $24,591 ? $24,750 $24,863 ? $6,750 ? G H I J K
Cornerstones of Cost Management (Cornerstones Series)
4th Edition
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Don R. Hansen, Maryanne M. Mowen
Chapter9: Standard Costing: A Functional-based Control Approach
Section: Chapter Questions
Problem 16E: Refer to the data in Exercise 9.15. Required: 1. Compute overhead variances using a two-variance...
Related questions
Concept explainers
Variance Analysis
In layman's terms, variance analysis is an analysis of a difference between planned and actual behavior. Variance analysis is mainly used by the companies to maintain a control over a business. After analyzing differences, companies find the reasons for the variance so that the necessary steps should be taken to correct that variance.
Standard Costing
The standard cost system is the expected cost per unit product manufactured and it helps in estimating the deviations and controlling them as well as fixing the selling price of the product. For example, it helps to plan the cost for the coming year on the various expenses.
Topic Video
Question
Please correctly complete the worksheet and answer those two questions fully!.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Recommended textbooks for you
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Principles of Cost Accounting
Accounting
ISBN:
9781305087408
Author:
Edward J. Vanderbeck, Maria R. Mitchell
Publisher:
Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Principles of Cost Accounting
Accounting
ISBN:
9781305087408
Author:
Edward J. Vanderbeck, Maria R. Mitchell
Publisher:
Cengage Learning
Accounting (Text Only)
Accounting
ISBN:
9781285743615
Author:
Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:
Cengage Learning
Financial & Managerial Accounting
Accounting
ISBN:
9781285866307
Author:
Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:
Cengage Learning
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,