Part of your company's accounting database was destroyed during a ransomware attack. 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. Note: Indicate the effect of each variance by selecting "Favorable" or "Unfavorable". Select "None" and enter "O" for no effect (i.e., zero variance). Round "Standard Quantity per Unit of Output" 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 Direct Material per hour $ 14.00 per pound hours per unit pounds per unit 2.50 hours pounds per unit $ 18.00 per hour $ 13.00 per pound 8,500 units 8,500 units $ 60,500 F $ 39,500 F Direct-labor efficiency variance Total direct-labor variance SASA $ 72,250 F $ 51,000 F
Part of your company's accounting database was destroyed during a ransomware attack. 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. Note: Indicate the effect of each variance by selecting "Favorable" or "Unfavorable". Select "None" and enter "O" for no effect (i.e., zero variance). Round "Standard Quantity per Unit of Output" 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 Direct Material per hour $ 14.00 per pound hours per unit pounds per unit 2.50 hours pounds per unit $ 18.00 per hour $ 13.00 per pound 8,500 units 8,500 units $ 60,500 F $ 39,500 F Direct-labor efficiency variance Total direct-labor variance SASA $ 72,250 F $ 51,000 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
None
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 1 images
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
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
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
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College