A Xfx Cost information about Masic Incorporated is provided in cells A6 to D7. Actual cost information is provided in cells A11 to B14. A statement of re B C D E F G H Masik, Incorporated is analyzing its most current direct materials results against the budget. Here is the standard cost information: Standard Cost per Direct Material Standard Quantity per Unit Standard Cost per Unit Direct Materials $ 9.50 2 $ 19.00 3 9 Actual cost information is below: 0 1 Units Produced 4,000 2 Materials Purchased 3 Material Used 8,500 7,800 4 Cost of Direct Materials $ 85,000 5 6 Required: 7 Fill in the cells below with required data for variance calculations and favorability. 8 Hint: Use the ABS() function to calculate amounts and use an IF() condition to determine the favorability of the variances. 9 20 21 Actual x Actual (used) 22 AQ AP 23 Direct Materials Variances Actual x Standard (used) AQ SP
A Xfx Cost information about Masic Incorporated is provided in cells A6 to D7. Actual cost information is provided in cells A11 to B14. A statement of re B C D E F G H Masik, Incorporated is analyzing its most current direct materials results against the budget. Here is the standard cost information: Standard Cost per Direct Material Standard Quantity per Unit Standard Cost per Unit Direct Materials $ 9.50 2 $ 19.00 3 9 Actual cost information is below: 0 1 Units Produced 4,000 2 Materials Purchased 3 Material Used 8,500 7,800 4 Cost of Direct Materials $ 85,000 5 6 Required: 7 Fill in the cells below with required data for variance calculations and favorability. 8 Hint: Use the ABS() function to calculate amounts and use an IF() condition to determine the favorability of the variances. 9 20 21 Actual x Actual (used) 22 AQ AP 23 Direct Materials Variances Actual x Standard (used) AQ SP
Cornerstones of Cost Management (Cornerstones Series)
4th Edition
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Don R. Hansen, Maryanne M. Mowen
Chapter12: Activity-based Management
Section: Chapter Questions
Problem 14E: Sanford, Inc., has developed value-added standards for four activities: purchasing parts, receiving...
Related questions
Question
am. 159.
AI-Generated Solution
AI-generated content may present inaccurate or offensive content that does not represent bartleby’s views.
Unlock instant AI solutions
Tap the button
to generate a solution
Recommended textbooks for you
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Principles of Cost Accounting
Accounting
ISBN:
9781305087408
Author:
Edward J. Vanderbeck, Maria R. Mitchell
Publisher:
Cengage Learning
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Principles of Cost Accounting
Accounting
ISBN:
9781305087408
Author:
Edward J. Vanderbeck, Maria R. Mitchell
Publisher:
Cengage Learning
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College