Fundamentals of Cost Accounting
5th Edition
ISBN: 9781259565403
Author: William N. Lanen Professor, Shannon Anderson Associate Professor, Michael W Maher
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 5, Problem 59P
Cost Estimation: Simple Regression
The following information on maintenance and repair costs and revenues for the last two years is available from the accounting records at Arnie’s Arcade & Video Palace. Arnie has asked you to help him understand the relation between business volume and maintenance and repair cost.
Required
- a. Ignoring the data, would you predict that, in general, there is a positive relation between revenues and maintenance and repair costs? Why?
- b. Estimate a linear regression with maintenance and repair cost as the dependent variable and revenue as the independent variable. Does the result support your prediction in requirement (a)? What are some factors that may explain the result?
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
1. Compare the costs of Version 1 POS and Version 2 POS. Consider the cumulative resultsfor the three years together, ignoring the time value of money and income taxes.
2. Advise Mr. Williams on the factors that determine whether a revenue or cost item is relevantfor management at Carib Systems and indicate whether he should accept the proposal.
Carter Dry Cleaning has developed two regression analyses for cost estimation. The accounting manager has presented statistical measures for both of these regressions. Regression A has an R-squaredvalue of .53 and a t-value of 1.08. Regression B has an R-squared of .89 and a t-value of 2.17. Whatdo these statistical measures indicate about the regressions? Which regression should Carter DryCleaning use for cost estimation?
Using (a) the regression equation and (b) the high-low equation, what is the increase in revenues for each $10,000 spent on promotional costs within the relevant range? Which method should Catherine use to predict the effect of promotional costs on ticket revenues? Explain briefly.
Chapter 5 Solutions
Fundamentals of Cost Accounting
Ch. 5 - What are the common methods of cost estimation?Ch. 5 - Prob. 2RQCh. 5 - Under what conditions is the engineering estimates...Ch. 5 - If one wishes simply to prepare a cost estimate...Ch. 5 - When using cost estimation methods based on past...Ch. 5 - Prob. 6RQCh. 5 - What is the difference between R2 and adjusted R2?Ch. 5 - Why are accurate cost estimates important?Ch. 5 - What are three practical implementation problems...Ch. 5 - Why is it important to incorporate learning into...
Ch. 5 - What are some complications that can arise when...Ch. 5 - The following costs are labeled fixed or variable...Ch. 5 - Prob. 13CADQCh. 5 - When preparing cost estimates for account analysis...Ch. 5 - How can one compensate for the effects of price...Ch. 5 - Prob. 16CADQCh. 5 - Prob. 17CADQCh. 5 - A decision maker is interested in obtaining a cost...Ch. 5 - Consider the Business Application item Using...Ch. 5 - A friend comes to you with the following problem....Ch. 5 - After doing an account analysis and giving the...Ch. 5 - In doing cost analysis, you realize that there...Ch. 5 - Prob. 23CADQCh. 5 - Are learning curves likely to affect materials...Ch. 5 - McDonalds, the fast-food restaurant, is known for...Ch. 5 - Prob. 26CADQCh. 5 - A manager asks you for a cost estimate to open a...Ch. 5 - Methods of Estimating Costs: Engineering Estimates...Ch. 5 - Methods of Estimating Costs: Engineering Estimates...Ch. 5 - Methods of Estimating Costs: Account Analysis The...Ch. 5 - Methods of Estimating Costs: Account Analysis...Ch. 5 - Methods of Estimating Costs: High-Low, Ethical...Ch. 5 - Methods of Estimating Costs: High-Low Adriana...Ch. 5 - Prob. 34ECh. 5 - Methods of Estimating Costs: Scattergraph Prepare...Ch. 5 - Methods of Estimating Costs: Simple Regression...Ch. 5 - Prob. 37ECh. 5 - Methods of Estimating Costs: Multiple Regression...Ch. 5 - Methods of Estimating Costs: High-Low Davis Stores...Ch. 5 - Methods of Estimating Costs: Scattergraph Prepare...Ch. 5 - Prob. 41ECh. 5 - Interpretation of Regression Results: Multiple...Ch. 5 - Interpretation of Regression Results Brodie...Ch. 5 - Prob. 44ECh. 5 - Interpretation of Regression Results: Simple...Ch. 5 - Learning Curves Assume that General Dynamics,...Ch. 5 - Learning Curves Assume that Whee, Cheatham, and...Ch. 5 - Learning Curves (Appendix B) Refer to the example...Ch. 5 - Prob. 49PCh. 5 - Regressions from Published Data Obtain 13 years of...Ch. 5 - Prob. 51PCh. 5 - High-Low Method, Scattcrgraph Cubicle Solutions...Ch. 5 - High-Low Method, Scattcrgraph Academy Products...Ch. 5 - Interpretation of Regression Results: Simple...Ch. 5 - Interpretation of Regression Results: Simple...Ch. 5 - Interpretation of Regression Results: Multiple...Ch. 5 - Interpretation of Regression Results: Simple...Ch. 5 - Interpretation of Regression Results Brews 4 U is...Ch. 5 - Cost Estimation: Simple Regression The following...Ch. 5 - Cost Estimation: Simple and Multiple Regression...Ch. 5 - Methods of Cost Analysis: Account Analysis, Simple...Ch. 5 - Learning Curves (Appendix B) Refer to the example...Ch. 5 - Learning Curves (Appendix B) Krylon Company...
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
- Jensen Tire Auto is deciding whether to purchase a maintenance contract for its new computer wheel alignment and balancing machine. Managers feel that maintenance expense should be related to usage, and they collected the following information on weekly usage (hours) and annual maintenance expense (in hundreds of dollars). a. Develop a scatter chart with weekly usage hours as the independent variable. What does the scatter chart indicate about the relationship between weekly usage and annual maintenance expense? b. Use the data to develop an estimated regression equation that could be used to predict the annual maintenance expense for a given number of hours of weekly usage. What is the estimated regression model? c. Test whether each of the regression parameters 0 and 1 is equal to zero at a 0.05 level of significance. What are the correct interpretations of the estimated regression parameters? Are these interpretations reasonable? d. How much of the variation in the sample values of annual maintenance expense does the model you estimated in part (b) explain? e. If the maintenance contract costs 3,000 per year, would you recommend purchasing it? Why or why not?arrow_forwardTom uses his computer to calculate the following regression formula:Weekly total costs = $18,791 + ($19.97 * Number of orders per week) Draw the regression line on your graph. Use your graph to evaluate the regression line using the criteria of economic plausibility, goodness of fit, and significance of the independent variable. Is the cost function estimated using the high-low method a close approximation of the cost function estimated using the regression method? Explain briefly.arrow_forwardAfter a few hours May’s computer is fixed. May uses the first 9 months of data and regression analysis to estimate the relationship between the quantity purchased and purchase costs of part #696. The regression line May obtains is as follows: y = $2,582.6 + 3.54X Evaluate the regression line using the criteria of economic plausibility, goodness of fit, and significance of the independent variable. Compare the regression equation to the equation based on the high-low method. Which is a better fit? Why?arrow_forward
- A marketing professor at Givens College is interested in the relationship between hours spent studying and total points earned in a course. Data collected on 156 students who took the course last semester are provided in the tile MktHrsPts. Develop a scatter chart for these data. What does the scatter chart indicate about the relationship between total points earned and hours spent studying? Develop an estimated regression equation showing how total points earned is related to hours spent studying. 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 sample values of total point earned does the model you estimated in part (b) explain? Mark Sweeney spent 95 hours studying. Use the regression model you estimated in part (b) to predict the total points Mark earned.arrow_forwardUse the following information to answer the questions that follow. A. Calculate the operating income percentage for each of the stores. Comment on how your analysis has changed for each store. B. Perform a vertical analysis for each store. Based on your analysis, what accounts would you want to investigate further? How might management utilize this information? C. Which method of analysis (using a dollar value or percentage) is most relevant and/or useful? Explain.arrow_forwardSouth Shore Construction builds permanent docks and seawalls along the southern shore of Long Island, New York. Although the firm has been in business only five years, revenue has increased from $308,000 in the first year of operation to $1,084,000 in the most recent year. The following data show the quarterly sales revenue in thousands of dollars: Construct a time series plot. What type of pattern exists in the data? Use a multiple regression model with dummy variables as follows to develop an equation to account for seasonal effects in the data: Qtr1 = 1 if quarter I, 0 otherwise; Qtr2 = 1 if quarter 2, 0 otherwise; Qtr3 = 1 if quarter 3, 0 otherwise. Based on the model you developed in part (b), compute estimates of quarterly sales for year 6. Let Period = 1 refer to the observation in quarter 1 of year 1; Period = 2 refer to the observation in quarter 2 of year 1; … and Period = 20 refer to the observation in quarter 4 of year 5. Using the dummy variables defined in part (b) and the variable Period, develop an equation to account for seasonal effects and any linear trend in the time series. Based on the seasonal effects in the data and linear trend estimated in part (c), compute estimates of quarterly sales for year 6. Is the model you developed in part (b) or the model you developed in part (d) more effective? Justify your answer.arrow_forward
- See questions 6A-6C in image Question 6D: Using the residual income approach, if you were in Dell Havasi’s position, would you accept or reject the new product line?arrow_forwardPlease tell me what type of the analysis is if the analysis wants to know which customer purchased over $5000 last year but bought nothing this year. Descriptive analytics. B. Diagnostic analytics. Predictive analytics. D. Prescriptive analyticsarrow_forwardAnswer full question.arrow_forward
- Curry Rubber manufactures rubber bands for retail companies. The accounting manager has performed a regression analysis of past data. You notice that the formula has an R-squared of 0.68, a t-value of 2.2, and a standard error of the estimate of $218,200. The estimate for next quarter costs is $2,597,623. Calculate Standard Error as a % of predicted total cost which represents a measure of precision of his regression analysis? (Round your answer to one decimal place, i.e., 0.052 = 5.2%.)arrow_forwardCustomers as a Cost Object Morrisom National Bank has requested an analysis of checking account profitability by customer type. Customers are categorized according to the size of their account: low balances, medium balances, and high balances. The activities associated with the three different customer categories and their associated annual costs are as follows: Additional data concerning the usage of the activities by the various customers are also provided: Required: (Note: Round answers to two decimal places.) 1. Calculate a cost per account per year by dividing the total cost of processing and maintaining checking accounts by the total number of accounts. What is the average fee per month that the bank should charge to cover the costs incurred because of checking accounts? 2. Calculate a cost per account by customer category by using activity rates. 3. Currently, the bank offers free checking to all of its customers. The interest revenues average 90 per account; however, the interest revenues earned per account by category are 80, 100, and 165 for the low-, medium-, and high-balance accounts, respectively. Calculate the average profit per account (average revenue minus average cost from Requirement 1). Then calculate the profit per account by using the revenue per customer type and the unit cost per customer type calculated in Requirement 2. 4. CONCEPTUAL CONNECTION After the analysis in Requirement 3, a vice president recommended eliminating the free checking feature for low-balance customers. The bank president expressed reluctance to do so, arguing that the low-balance customers more than made up for the loss through cross-sales. He presented a survey that showed that 50% of the customers would switch banks if a checking fee were imposed. Explain how you could verify the presidents argument by using ABC.arrow_forwardThe president of a small manufacturing firm is concerned about the continual increase in manufacturing costs over the past several years. The following figures provide a time series of the cost per unit for the firms leading product over the past eight years: a. Construct a time series plot. What type of pattern exists in the data? b. Use simple linear regression analysis to find the parameters for the line that minimizes MSE for this time series. c. What is the average cost increase that the firm has been realizing per year? d. Compute an estimate of the cost/unit for next year.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
Essentials of Business Analytics (MindTap Course ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage Learning
Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College- Century 21 Accounting Multicolumn JournalAccountingISBN:9781337679503Author:GilbertsonPublisher:Cengage
Cornerstones 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
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
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:9781337679503
Author:Gilbertson
Publisher:Cengage
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
How to Estimate Project Costs: A Method for Cost Estimation; Author: Online PM Courses - Mike Clayton;https://www.youtube.com/watch?v=YQ2Wi3Jh3X0;License: Standard Youtube License