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 4R
The worksheet you have developed will handle most simple
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.
Expert Solution & Answer
Trending nowThis is a popular 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
- 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.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_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
- In all of the exercises involving variances, use F and U to designate favorable and unfavorable variances, respectively. E8-1 through E8-5 use the following data: The standard operating capacity of Tecate Manufacturing Co. is 1,000 units. A detailed study of the manufacturing data relating to the standard production cost of one product revealed the following: 1. Two pounds of materials are needed to produce one unit. 2. Standard unit cost of materials is 8 per pound. 3. It takes one hour of labor to produce one unit. 4. Standard labor rate is 10 per hour. 5. Standard overhead (all variable) for this volume is 4,000. Each case in E8-1 through E8-5 requires the following: a. Set up a standard cost summary showing the standard unit cost. b. Analyze the variances for materials and labor. c. Make journal entries to record the transfer to Work in Process of: 1. Materials costs 2. Labor costs 3. Overhead costs (When making these entries, include the variances.) d. Prepare the journal entry to record the transfer of costs to the finished goods account. Standard unit cost; variance analysis; journal entries 1,000 units were started and finished. Case 1: All prices and quantities for the cost elements are standard, except for materials cost, which is 8.50 per pound. Case 2: All prices and quantities for the cost elements are standard, except that 1,900 lb of materials were used.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_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
- Madison 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_forwardThe normal capacity of a manufacturing plant is 30,000 direct labor hours or 20,000 units per month. Standard fixed costs are 6,000, and variable costs are 12,000. Data for two months follow: For each month, make a single journal entry to charge overhead to Work in Process, to close Factory Overhead, and to record variances. Indicate the types of variances and state whether each is favorable or unfavorable. (Hint: You must first compute the flexible-budget and production-volume variances.)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_forward
- Marten Company has a cost-benefit policy to investigate any variance that is greater than 1,000 or 10% of budget, whichever is larger. Actual results for the previous month indicate the following: The company should investigate: a. neither the materials variance nor the labor variance. b. the materials variance only. c. the labor variance only. d. both the materials variance and the labor variance.arrow_forwardReddy Corporation has collected the following data for the month or June: What is the variable overhead efficiency variance?arrow_forwardAt the end of the period, the factory overhead account has a credit balance of 10,000. (a) Is the total factory cost variance favorable or unfavorable? (b) Are the controllable and volume variances favorable or unfavorable?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
Principles of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher:Cengage Learning
Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
Financial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Principles of Cost Accounting
Accounting
ISBN:9781305087408
Author:Edward J. Vanderbeck, Maria R. Mitchell
Publisher:Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
Financial And Managerial Accounting
Accounting
ISBN:9781337902663
Author:WARREN, Carl S.
Publisher:Cengage Learning,
What is variance analysis?; Author: Corporate finance institute;https://www.youtube.com/watch?v=SMTa1lZu7Qw;License: Standard YouTube License, CC-BY