Excel Applications for Accounting Principles
4th Edition
ISBN: 9781111581565
Author: Gaylord N. Smith
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 24, Problem 2R
The president of McGrade Industries wants an analysis prepared to help explain why the variances computed in requirement 1 occurred. Using the worksheet called PRIMEVAR that follows these requirements, calculate the material and labor variances for McGrade Industries. The problem requires you to enter the input in the Data Section as well as formulas in the Answer Section.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Chapter 24 Solutions
Excel Applications for Accounting Principles
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.Similar questions
- Acme Inc. has the following information available: A. Compute the material price and quantity, and the labor rate and efficiency variances. B. Describe the possible causes for this combination of favorable and unfavorable variances.arrow_forwardRecompute the variances from the second Acme Inc. exercise using $0.0725 as the standard cost of the material and $14 as the standard labor cost per hour. How has your explanation of the variances changed?arrow_forwardRefer to the information for Cinturon Corporation on the previous page. Required: 1. Break down the total variance for materials into a price variance and a usage variance using the columnar and formula approaches. 2. CONCEPTUAL CONNECTION Suppose the Boise plant manager investigates the materials variances and is told by the purchasing manager that a cheaper source of leather strips had been discovered and that this is the reason for the favorable materials price variance. Quite pleased, the purchasing manager suggests that the materials price standard be updated to reflect this new, less expensive source of leather strips. Should the plant manager update the materials price standard as suggested? Why or why not?arrow_forward
- The worksheet you have developed will handle most simple variance analysis problems. Try the problem below for Pscheidl, Inc.: Actual production for October was 11,500 units. Compute the direct materials and direct labor variances for Pscheidl, Inc. Be careful when entering your input because this problem presents the information in a different format from the McGrade Industries data. Save the file as PRIMEVAR4. Print the worksheet when done.arrow_forwardRefer to the information for Cinturon Corporation on the previous page. Required: 1. Break down the total variance for labor into a rate variance and an efficiency variance using the columnar and formula approaches. 2. CONCEPTUAL CONNECTION As part of the investigation of the unfavorable variances, the plant manager interviews the production manager. The production manager complains strongly about the quality of the leather strips. He indicates that the strips are of lower quality than usual and that workers have to be more careful to avoid a belt with cracks and more time is required. Also, even with extra care, many belts have to be discarded and new ones produced to replace the rejects. This replacement work has also produced some overtime demands. What corrective action should the plant manager take?arrow_forwardThe management of Golding Company has determined that the cost to investigate a variance produced by its standard cost system ranges from 2,000 to 3,000. If a problem is discovered, the average benefit from taking corrective action usually outweighs the cost of investigation. Past experience from the investigation of variances has revealed that corrective action is rarely needed for deviations within 8% of the standard cost. Golding produces a single product, which has the following standards for materials and labor: Actual production for the past 3 months follows, with the associated actual usage and costs for materials and labor. There were no beginning or ending raw materials inventories. Required: 1. What upper and lower control limits would you use for materials variances? For labor variances? 2. Compute the materials and labor variances for April, May, and June. Identify those that would require investigation by comparing each variance to the amount of the limit computed in Requirement 1. Compute the actual percentage deviation from standard. Round all unit costs to four decimal places. Round variances to the nearest dollar. Round variance rates to three decimal places so that percentages will show to one decimal place. 3. CONCEPTUAL CONNECTION Let the horizontal axis be time and the vertical axis be variances measured as a percentage deviation from standard. Draw horizontal lines that identify upper and lower control limits. Plot the labor and material variances for April, May, and June. Prepare a separate graph for each type of variance. Explain how you would use these graphs (called control charts) to assist your analysis of variances.arrow_forward
- Which of the following is true concerning labor variances that are not material in amount? a. They are closed to Cost of Goods Sold. b. They are prorated among Work in Process, Finished Goods, and Cost of Goods Sold. c. They are prorated among Materials, Work in Process, Finished Goods, and Cost of Goods Sold. d. They are reported as part of Overall Variance on the balance sheet at the end of the year.arrow_forwardSommers Company uses the following rule to determine whether materials usage variances should be investigated: A materials usage variance will be investigated anytime the amount exceeds the lesser of 12,000 or 10% of the standard cost. Reports for the past 5 weeks provided the following information: Required: 1. Using the rule provided, identify the cases that will be investigated. 2. CONCEPTUAL CONNECTION Suppose investigation reveals that the cause of an unfavorable materials usage variance is the use of lower-quality materials than are normally used. Who is responsible? What corrective action would likely be taken? 3. CONCEPTUAL CONNECTION Suppose investigation reveals that the cause of a significant unfavorable materials usage variance is attributable to a new approach to manufacturing that takes less labor time but causes more material waste. Examination of the labor efficiency variance reveals that it is favorable and larger than the unfavorable materials usage variance. Who is responsible? What action should be taken?arrow_forwardWarner Company has the following data for the past year: Warner uses the overhead control account to accumulate both actual and applied overhead. Required: 1. Calculate the overhead variance for the year and close it to cost of goods sold. 2. Assume the variance calculated is material. After prorating, close the variances to the appropriate accounts and provide the final ending balances of these accounts. 3. What if the variance is of the opposite sign calculated in Requirement 1? Provide the appropriate adjusting journal entries for Requirements 1 and 2.arrow_forward
- Performance Report for Variable Variances Humo Company provided the following information: Required: Prepare a performance report that shows the variances for each variable overhead item (inspection and power).arrow_forwardFixed Overhead Spending and Volume Variances, Columnar and Formula Approaches Branch Company provided the following information: Required: 1. Using the columnar approach, calculate the fixed overhead spending and volume variances. 2. Using the formula approach, calculate the fixed overhead spending variance. 3. Using the formula approach, calculate the fixed overhead volume variance. 4. Calculate the total fixed overhead variance.arrow_forwardMadison Company uses the following rule to determine whether direct labor efficiency variances ought to be investigated. A direct labor efficiency variance will be investigated anytime the amount exceeds the lesser of 12,000 or 10 percent of the standard labor cost. Reports for the past five weeks provided the following information: Required: 1. Using the rule provided, identify the cases that will be investigated. 2. Suppose that investigation reveals that the cause of an unfavorable direct labor efficiency variance is the use of lower quality direct materials than are usually used. Who is responsible? What corrective action would likely be taken? 3. Suppose that investigation reveals that the cause of a significant favorable direct labor efficiency variance is attributable to a new approach to manufacturing that takes less labor time but causes more direct materials waste. Upon examining the direct materials usage variance, it is discovered to be unfavorable, and it is larger than the favorable direct labor efficiency variance. Who is responsible? What action should be taken? How would your answer change if the unfavorable variance were smaller than the favorable?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning
Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
Financial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,
Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Financial And Managerial Accounting
Accounting
ISBN:9781337902663
Author:WARREN, Carl S.
Publisher:Cengage Learning,
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
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
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
What is variance analysis?; Author: Corporate finance institute;https://www.youtube.com/watch?v=SMTa1lZu7Qw;License: Standard YouTube License, CC-BY