Part of your company's accounting database was destroyed when Godzilla attacked the city. You have been able to gather the following data from your files. Reconstruct the remaining information using the available data. All of the raw material purchased during the period was used in production. (Indicate the effect of each variance by selecting "Favorable" or "Unfavorable". Select "None" and enter "O" for no effect (i.e., zero variance). Round "per unit" answer values to 2 decimal places.) Standard price or rate per unit of input Standard quantity per unit of output Actual quantity used per unit of output Actual price or rate per unit of input Actual output Direct-material price variance Direct-material quantity variance Total direct-material variance Direct-labor rate variance Direct-labor efficiency variance Total direct-labor variance $ $ 6A6A $ Direct Labor per hour hours per unit 3.50 hours 21.00 per hour 5,500 units 30,000 F 10,750 F $ $ $ $ Direct Material 8.00 per lb lbs per unit lbs per unit 7.00 per lb 5,500 units 36,300 F 25,900 F
Part of your company's accounting database was destroyed when Godzilla attacked the city. You have been able to gather the following data from your files. Reconstruct the remaining information using the available data. All of the raw material purchased during the period was used in production. (Indicate the effect of each variance by selecting "Favorable" or "Unfavorable". Select "None" and enter "O" for no effect (i.e., zero variance). Round "per unit" answer values to 2 decimal places.) Standard price or rate per unit of input Standard quantity per unit of output Actual quantity used per unit of output Actual price or rate per unit of input Actual output Direct-material price variance Direct-material quantity variance Total direct-material variance Direct-labor rate variance Direct-labor efficiency variance Total direct-labor variance $ $ 6A6A $ Direct Labor per hour hours per unit 3.50 hours 21.00 per hour 5,500 units 30,000 F 10,750 F $ $ $ $ Direct Material 8.00 per lb lbs per unit lbs per unit 7.00 per lb 5,500 units 36,300 F 25,900 F
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
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 2 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
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
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
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
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
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
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Principles of Cost Accounting
Accounting
ISBN:
9781305087408
Author:
Edward J. Vanderbeck, Maria R. Mitchell
Publisher:
Cengage Learning