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
Students have asked these similar questions
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?
pls answer the questions
Here are the questions from my study material.
Question included in the attached image.
_________________
What were the price and quantity variances for direct material, respectively?
What were the rate and efficiency variances for direct labour, respectively?
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_forwardClose 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_forward
- Your supervisor asks you to produce a budget variance report. Using the most common definition of “budget variance analysis,” what information is your supervisor looking for and why is this important in budget management?arrow_forwardNeed some help making a cheet sheet for an up coming test. please provide examples. The exam covers chapters 1 through 13. Here are some suggested study topics: Cost Classifications - variable, fixed and mixed, period and product, direct and indirect, opportunity, sunk, relevant, traceable, common, etc. Calculate the results of changes to cost assumptions (CVP) Calculate net income based on contribution margin values either dollars or % Application of Manufacturing Overhead - calculate predetermined overhead rate or activity rates applied to a product or job - job order using a predetermined overhead rate or rates and activity-based costing calculate over and underapplied overhead calculate adjusted cost of goods sold Job Costing What is the total cost of the job and average cost per unit. Cost of Goods Manufactured and cost of goods sold Calculate break even and target profit Create a contribution format income statement Gross margin calculations - absorption or variable costing…arrow_forwardExplain who is in the best position in the organization to influence each of these variances. a. Direct Materials Price Variance b. Direct Materials Quantity Variance c. Direct Labor Rate Variance d. Direct Labor Time Variancearrow_forward
- please answer allarrow_forwardComplete the following relating to the balanced scorecard manufacturing measurements: А. time is the only difference between delivery cycle time and throughput time in the manufacturing cycle. B) In your own work, Explain what information does the MCE provide to the production manager?arrow_forwardExplain how the two-, three-, and four-variance overhead analyses are related.arrow_forward
- List the fixed overhead variances, and briefly describe each.arrow_forwardQ. Provide your own numerical data with the calculation and analysis of Material Variances? Plz do it as soon as possible!!!! Must be plagirism freearrow_forwardTopic: Standard Costing and Variance Analysis Question: Create a concept map which discusses on the different types of variances and their formula.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 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
Principles of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher: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,
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
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
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
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