You brought your work home one evening, and your nephew spilled his chocolate milk shake on the variance report you were preparing. Fortunately, knowing that overhead was applied based on machine hours, you were able to reconstruct the obliterated information from the remaining data. Fill in the missing numbers below. Note: Round your per machine hour and per unit answers to two decimal places. Indicate the effect of the variance by selecting "Positive" or "Negative". Select "None" and enter "O" for no effect (i.e., zero variance). Standard machine hours per unit of output Standard variable-overhead rate per machine hour Actual variable-overhead rate per machine hour Actual machine hours per unit of output Budgeted fix overhead Actual fixed overhead Budgeted production in units Actual production in units Variable-overhead spending variance Variable-overhead efficiency variance Fixed-overhead budget variance Fixed-overhead volume variance Total actual overhead Total budgeted overhead (flexible budget) Total budgeted overhead (static budget) Total applied overhead $ $ $ $ $ $ $ $ . 3 hours 10.00 30,450 38,950 14,500 32,000 Unfavorable 100,000 Favorable 8,500 Unfavorable 390,950 449,400
You brought your work home one evening, and your nephew spilled his chocolate milk shake on the variance report you were preparing. Fortunately, knowing that overhead was applied based on machine hours, you were able to reconstruct the obliterated information from the remaining data. Fill in the missing numbers below. Note: Round your per machine hour and per unit answers to two decimal places. Indicate the effect of the variance by selecting "Positive" or "Negative". Select "None" and enter "O" for no effect (i.e., zero variance). Standard machine hours per unit of output Standard variable-overhead rate per machine hour Actual variable-overhead rate per machine hour Actual machine hours per unit of output Budgeted fix overhead Actual fixed overhead Budgeted production in units Actual production in units Variable-overhead spending variance Variable-overhead efficiency variance Fixed-overhead budget variance Fixed-overhead volume variance Total actual overhead Total budgeted overhead (flexible budget) Total budgeted overhead (static budget) Total applied overhead $ $ $ $ $ $ $ $ . 3 hours 10.00 30,450 38,950 14,500 32,000 Unfavorable 100,000 Favorable 8,500 Unfavorable 390,950 449,400
Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
Chapter24: Material And Labor Variances (primevar)
Section: Chapter Questions
Problem 5R: Close the PRIMEVAR4 file and open PRIMEVAR3. Click the Chart sheet tab. On the screen is a graphical...
Related questions
Question
Do not give image format
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!
Step 1: Introduction to the variance and standard cost
VIEWStep 2: Computation of the variances and standard cost
VIEWStep 3: Computation of the variances and standard cost
VIEWStep 4: Computation of the variances and standard cost
VIEWStep 5: Computation of the variances and standard cost
VIEWStep 6: Computation of the variances and standard cost
VIEWSolution
VIEWTrending now
This is a popular solution!
Step by step
Solved in 7 steps
Recommended textbooks for you
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Essentials of Business Analytics (MindTap Course …
Statistics
ISBN:
9781305627734
Author:
Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:
Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Essentials of Business Analytics (MindTap Course …
Statistics
ISBN:
9781305627734
Author:
Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:
Cengage Learning