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
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 solutionStudents have asked these similar questions
Bill Wilson, the financial accountant at Robson Ltd is considering implementing a standard costing system. He has asked your advice on the following:
a) Setting standards
b) Investigating variances
c) Taking corrective action on large variances
Required:
Prepare a short report for Bill addressing these three areas.
The PERT is combined with cost data to produce a PERT cost analysis to a. calculate the total project cost inclusive of the additional slack time.b. evaluate and optimize trade-offs between time of an event’s completion and its cost to complete. c. implement computer-integrated manufacturing concepts. d. avoid the problem of time variance analysis. e. calculate expected activity times.
Analyze the variances that you computed in requirements 1 and 2.
Was the new service a success from an overall cost-control perspective? Briefly discuss.
What seems to have happened that would give rise to customer complaints?
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_forwardIn a manufacturing process the assembly line speed (feet per minute) was thought to affect the number of defective parts found during the inspection process. To test this theory, managers devised a situation in which the same batch of parts was inspected visually at a variety of line speeds. They collected the following data: Develop a scatter chart with line speed as the independent variable. What does the scatter chart indicate about the relationship between line speed and the number of defective parts found? Use the data to develop an estimated regression equation that could be used to predict the number of defective parts found, given the line speed. What is the estimated regression model? Test whether each of the regression parameters β0 and β1 is equal to zero at a 0.01 level of significance. What are the correct interpretations of the estimated regression parameters? Are these interpretations reasonable? How much of the variation in the number of defective parts found for the sample data does the model you estimated in part (b) explain?arrow_forwardThe management of Al Safa Production LLC requested you to identify from the following how direct labor variances may be analyzed into: a. Usage and price variances b. Efficiency and rate variances c. Usage and rate variances d. Efficiency and price variancesarrow_forward
- 1. Why are standard cost systems used? 2. How are standards set for material, labor, and overhead? 3. How is variance analysis used for control and performance evaluation?arrow_forwardM Question 6 - Ch 23: HOME ation.com/ext/map/index.html?_con=con&external_browser=0&launchUrl=https%253A%252F%252Fnewconnect.mheducation. Trini Company set the following standard costs per unit for its single product Direct materials (30 pounds @ $5.00 per pound) Direct labor (7 hours @ $14 per hour) Variable overhead (7 hours @ $7 per hour) Fixed overhead (7 hours @ $9 per hour) Standard cost per unit Production (in units) Standard direct labor hours (7 DLH per unit) Budgeted overhead (flexible budget) Fixed overhead Variable overhead Overhead is applied using direct labor hours. The standard overhead rate is based on a predicted activity level of 80% the company's capacity of 51,000 units per quarter. The following additional information is available. Direct materials (1,377,000 pounds @ $5.00 per pound) Direct labor (321,300 hours @ $14 per hour) Overhead (321,300 hours @ $16 per hour) Standard (budgeted) cost Variable overhead Actual cost Saved 80 F3 Actual costs incurred during…arrow_forwardplease answer in detailarrow_forward
- Close the PRIMEVAR4 file and open PRIMEVAR3. Click the Chart sheet tab. On the screen is a graphical representation of the variances computed in requirement 3. Review the chart and answer the following questions: a. Which variances does each bar represent? A __________ B __________ C __________ D __________ b. Which of the variances shown would be of most concern to management for immediate attention? (Consider groups of variances and materiality also.) Explain. When the assignment is complete, close the file without saving it again. Worksheet. McGrade Industries also has the following information regarding overhead for October: actual overhead 375,000, standard variable overhead of 3 per direct labor hour, and standard fixed overhead of 5 per direct labor hour (based on 47,000 hours budgeted). Modify the PRIMEVAR3 worksheet to compute all appropriate overhead variances. Preview the printout to make sure that the worksheet will print neatly on one page, and then print the worksheet. Save the completed file as PRIMEVART. Hint: Insert several new rows in the Data Section and in the Answer Section. Chart. Using the PRIMEVAR3 file, prepare a 3-D stacked bar chart to compare total standard cost per unit with actual cost per unit. Complete the Chart Tickler Data Table and use it as a basis for preparing the chart. You do not need to use cell references when completing the table. Enter all appropriate titles, legends, and formats. Enter your name somewhere on the chart. Save the file again as PRIMEVAR3. Print the chart.arrow_forwardDeluxe, Inc. produced 1,000 units of the company's product in 2018. The standard quantity of direct materials was three yards of cloth per unit at a standard cost of $1.05 per yard. The accounting records showed that 2,600 yards of cloth were used and the company paid $1.10 per yard. Standard time was two direct labor hours per unit at a standard rate of $10.75 per direct labor hour. Employees worked 1,400 hours and were paid $10.25 per hour. Read the requirements. Requirement 1. What are the benefits of setting cost standards? Standard costing helps managers do the following: Requirement 2. Calculate the direct materials cost variance and the direct materials efficiency variance as well as the direct labor cost and efficiency variances. Begin with the cost variances. Select the required formulas, compute the cost variances for direct materials and direct labor, and identify whether each variance is favorable (F) or unfavorable (U). (Abbreviations used: AC actual cost; AQ = actual…arrow_forward4. Compute the Material Price variance 5. Compute the Material Quantity variance 6. Compute the Total Labor variance 7. Compute the Labor Price variance 8. Compute the Labor Quantity variance 9. Compute the Total Manufacturing Overhead variance 10. Which variance(s) would be the responsibility of the Production Manager? 11. Which variance(s) would be the responsibility of the Purchasing Manager? Show all calculations for each item step-by-steparrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage LearningPrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax CollegePrinciples of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher:Cengage Learning
- Essentials of Business Analytics (MindTap Course ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage LearningCornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
Principles of Cost Accounting
Accounting
ISBN:9781305087408
Author:Edward J. Vanderbeck, Maria R. Mitchell
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
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
What is variance analysis?; Author: Corporate finance institute;https://www.youtube.com/watch?v=SMTa1lZu7Qw;License: Standard YouTube License, CC-BY