Homework Help is Here – Start Your Trial Now!
Business
Accounting
You are provided with the following information. Direct materials Direct labor Variable manufacturing overhead Actual results: Actual output Actual variable manufacturing overhead cost $ Inputs Actual direct materials cost Actual direct labor cost Actual Quantity Required: Use the information above to calculate the variances. Note: Use ABS() formula for variances. Actual Hours Actual Hours X X X Actual Quantity 6,550 pounds 1,120 hours Actual Price Actual Rate Standard Quantity 2.9 pounds 0.65 hours 0.65 hours Actual Rate 2,120 units 7,260 $ $ $ $ $ Standard Price Actual Price 3.97 per pound 21.35 per hour 4.15 per pound 22.00 per hour 5.89 per hour Actual Quantity Actual Hours Direct Materials Actual Hours X Direct Labor Variable Overhead X Standard Price Standard Rate Standard Rate Standard Quantity Standard Hours Standard Hours X X X Standard Price Standard Rate Standard Rate

You are provided with the following information. Direct materials Direct labor Variable manufacturing overhead Actual results: Actual output Actual variable manufacturing overhead cost $ Inputs Actual direct materials cost Actual direct labor cost Actual Quantity Required: Use the information above to calculate the variances. Note: Use ABS() formula for variances. Actual Hours Actual Hours X X X Actual Quantity 6,550 pounds 1,120 hours Actual Price Actual Rate Standard Quantity 2.9 pounds 0.65 hours 0.65 hours Actual Rate 2,120 units 7,260 $ $ $ $ $ Standard Price Actual Price 3.97 per pound 21.35 per hour 4.15 per pound 22.00 per hour 5.89 per hour Actual Quantity Actual Hours Direct Materials Actual Hours X Direct Labor Variable Overhead X Standard Price Standard Rate Standard Rate Standard Quantity Standard Hours Standard Hours X X X Standard Price Standard Rate Standard Rate

Managerial Accounting: The Cornerstone of Business Decision-Making
Managerial Accounting: The Cornerstone of Business Decision-Making
7th Edition
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Chapter10: Standard Costing And Variance Analysis
Section: Chapter Questions
Problem 39BEB: Variable Overhead Spending and Efficiency Variances, Columnar and Formula Approaches Aretha Company...
See similar textbooks
icon
Related questions
Topic Video
Question

You are provided with the following information. Please give me the answers in an excel format.

You are provided with the following information. Direct materials Direct labor Variable manufacturing overhead Actual results: Actual output Actual variable manufacturing overhead cost $ Inputs Actual direct materials cost Actual direct labor cost Actual Quantity Required: Use the information above to calculate the variances. Note: Use ABS() formula for variances. Actual Hours Actual Hours X X X Actual Quantity 6,550 pounds 1,120 hours Actual Price Actual Rate Standard Quantity 2.9 pounds 0.65 hours 0.65 hours Actual Rate 2,120 units 7,260 $ $ $ $ $ Actual Price 3.97 per pound 21.35 per hour Standard Price 4.15 per pound 22.00 per hour 5.89 per hour Actual Quantity Actual Hours Direct Materials Actual Hours X Direct Labor X Variable Overhead X Standard Price Standard Rate Standard Rate Standard Quantity Standard Hours Standard Hours X X X Standard Price Standard Rate Standard Rate
Transcribed Image Text:You are provided with the following information. Direct materials Direct labor Variable manufacturing overhead Actual results: Actual output Actual variable manufacturing overhead cost $ Inputs Actual direct materials cost Actual direct labor cost Actual Quantity Required: Use the information above to calculate the variances. Note: Use ABS() formula for variances. Actual Hours Actual Hours X X X Actual Quantity 6,550 pounds 1,120 hours Actual Price Actual Rate Standard Quantity 2.9 pounds 0.65 hours 0.65 hours Actual Rate 2,120 units 7,260 $ $ $ $ $ Actual Price 3.97 per pound 21.35 per hour Standard Price 4.15 per pound 22.00 per hour 5.89 per hour Actual Quantity Actual Hours Direct Materials Actual Hours X Direct Labor X Variable Overhead X Standard Price Standard Rate Standard Rate Standard Quantity Standard Hours Standard Hours X X X Standard Price Standard Rate Standard Rate
Expert Solution
steps

Step by step

Solved in 4 steps with 2 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Performance measurements
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.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Managerial Accounting: The Cornerstone of Busines…
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
Principles of Cost Accounting
Accounting
ISBN:
9781305087408
Author:
Edward J. Vanderbeck, Maria R. Mitchell
Publisher:
Cengage Learning
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Accounting (Text Only)
Accounting (Text Only)
Accounting
ISBN:
9781285743615
Author:
Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:
Cengage Learning
Financial & Managerial Accounting
Financial & Managerial Accounting
Accounting
ISBN:
9781285866307
Author:
Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS