Horngren's Cost Accounting: A Managerial Emphasis (16th Edition)
16th Edition
ISBN: 9780134475585
Author: Srikant M. Datar, Madhav V. Rajan
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 10, Problem 10.43P
Multiple regression (continuation of 10-42). After further discussion, Julie and Rhett wonder if they should view both the number of procedures and number of patient-hours as cost drivers in a multiple regression estimation in order to best understand Apollo’s medical supplies costs.
- 1. Conduct a multiple regression to estimate the regression equation for medical supplies costs using both number of procedures and number of patient-hours as independent variables. You should obtain the following result:
Required
Regression 3
Medical supplies costs = a + (b1 × No. of procedures) + (b2 × No. of patient-hours)
- 2. Evaluate the multiple regression output using the criteria of economic plausibility goodness of fit, significance of independent variables, and specification of estimation assumptions.
- 3. What potential issues could arise in multiple regression analysis that are not present in simple regression models? Is there evidence of such difficulties in the multiple regression presented in this problem? Explain.
- 4. Which of the regression models from Problems 10-42 and 10-43 would you recommend Julie Chen use? Explain.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Recent research into the cost of various medical procedures has shown the impact of certain complications encountered in surgery on the total cost of a patient’s stay in the hospital. The researchers used regression analysis and found the following results:
Total cost for patient = Constant, plus
a × Length of stay (measured in days), plus
b × Presence of one or more complications (= 1 if true, 0 if false), plus
c × Use of a laparoscope (= 1 if true, 0 if false)
where a, b, c are coefficients of the regression model. The laparoscope is an instrument somewhat like a miniature telescope with a fiber-optic system that brings light into the abdomen. It is about as big around as a fountain pen and twice as long.
The research, based on 63 patients, showed the following regression results:
R-squared: 56%
Constant term: $3,158
Coefficients and t-values for independent variables:
Length of Stay
Complications
Laparoscope
Coefficient
$ 887
$ 1,912
$ 928
t-value
7.51
5.30…
Use the information below or using Exhibit 12.14 on page 577 in Zelman to answer the following questions.
Calculate the per unit cost of an initial visit using both the conventional and ABC approaches.
Calculate the per unit cost of a regular visit using both the conventional and ABC approaches.
Calculate the per unit cost of an intensive visit using both the conventional and ABC approaches.
Exhibit 12-14
Basic data and calculation of unit costs using a conventional approach
Total Cost by Visit Type
Basic Data
A
B
C
D
Initial
Regular
Intensive
Total
(Given)
(Given)
(Given)
(A + B + C)
1
Number of visits
8,000
26,000
8,600
42,600
2
Direct materials (etc.)
$40,000
$50,000
$65,000
$155,000
3
Direct labor
$100,000
$120,000
$280,000
$500,000…
Tom 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.
Chapter 10 Solutions
Horngren's Cost Accounting: A Managerial Emphasis (16th Edition)
Ch. 10 - What two assumptions are frequently made when...Ch. 10 - Describe three alternative linear cost functions.Ch. 10 - What is the difference between a linear and a...Ch. 10 - High correlation between two variables means that...Ch. 10 - Name four approaches to estimating a cost...Ch. 10 - Describe the conference method for estimating a...Ch. 10 - Describe the account analysis method for...Ch. 10 - List the six steps in estimating a cost function...Ch. 10 - When using the high-low method, should you base...Ch. 10 - Describe three criteria for evaluating cost...
Ch. 10 - Define learning curve. Outline two models that can...Ch. 10 - Discuss four frequently encountered problems when...Ch. 10 - Prob. 10.13QCh. 10 - All the independent variables in a cost function...Ch. 10 - Multicollinearity exists when the dependent...Ch. 10 - HL Co. uses the high-low method to derive a total...Ch. 10 - A firm uses simple linear regression to forecast...Ch. 10 - In regression analysis, the coefficient of...Ch. 10 - A regression equation is set up, where the...Ch. 10 - What would be the approximate value of the...Ch. 10 - Estimating a cost function. The controller of the...Ch. 10 - Identifying variable-, fixed-, and mixed-cost...Ch. 10 - Various cost-behavior patterns. (CPA, adapted)....Ch. 10 - Matching graphs with descriptions of cost and...Ch. 10 - Account analysis, high-low. Stein Corporation...Ch. 10 - Account analysis method. Gower, Inc., a...Ch. 10 - Prob. 10.27ECh. 10 - Estimating a cost function, high-low method. Lacy...Ch. 10 - Linear cost approximation. Dr. Young, of Young and...Ch. 10 - Cost-volume-profit and regression analysis....Ch. 10 - Regression analysis, service company. (CMA,...Ch. 10 - High-low, regression. May Blackwell is the new...Ch. 10 - Learning curve, cumulative average-time learning...Ch. 10 - Learning curve, incremental unit-time learning...Ch. 10 - High-low method. Wayne Mueller financial analyst...Ch. 10 - High-low method and regression analysis. Market...Ch. 10 - High-low method; regression analysis. (CIMA,...Ch. 10 - Regression, activity-based costing, choosing cost...Ch. 10 - Interpreting regression results. Spirit...Ch. 10 - Cost estimation, cumulative average-time learning...Ch. 10 - Cost estimation, incremental unit-time learning...Ch. 10 - Regression; choosing among models. Apollo Hospital...Ch. 10 - Multiple regression (continuation of 10-42). After...Ch. 10 - Cost estimation. Hankuk Electronics started...Ch. 10 - Prob. 10.45PCh. 10 - Interpreting regression results, matching time...Ch. 10 - Purchasing department cost drivers, activity-based...Ch. 10 - Purchasing department cost drivers, multiple...
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
- Weber Valley Regional Hospital has collected data on all of its activities for the past 16 months. Data for cardiac nursing care follow: Required: 1. Using the high-low method, calculate the variable rate per hour and the fixed cost for the nursing care activity. 2. Run a regression on the data, using hours of nursing care as the independent variable. Predict cost for the cardiac nursing care for September Year 2 if 1,400 hours of nursing care are forecast. Evaluate the regression equation. How comfortable are you with the predicted cost for September Year 2? 3. Upon looking into the events that happened at the end of Year 1, you find that the cardiology ward bought a cardiac-monitoring machine for the nursing station. Administrators also decided to add a new supervisory position for the evening shift. Monthly depreciation on the monitor and the salary of the new supervisor together total 10,000. Now, run two regression equations, one for the observations from Year 1 and the second using only the observations for the eight months in Year 2. Discuss your findings. What is your predicted cost of the cardiac nursing care activity for September Year 2?arrow_forwardIn the cost formula, the term 128,000,000 a. is the total variable cost. b. is the dependent variable. c. is the variable rate. d. is the total fixed cost. e. cannot be determined from the above formula. Use the following information for Multiple-Choice Questions 3-4 through 3-7: The following cost formula was developed by using monthly data for a hospital. Total Cost = 128,000,000 + (12,000 Number of Patient Days)arrow_forwardMethod of Least Squares Refer to the information for Luisa Crimini on the previous page. Required: 1. Using a computer spreadsheet program such as Excel, run a regression on these data. Based on the regression output, write the cost formula for tanning. (Note: Round the fixed cost to the nearest dollar and the variable rate to the nearest cent.) 2. Using the formula computed in Requirement 1, what is the predicted cost of tanning services for September for 2,500 appointments? Use the following information for Exercises 3-44 through 3-46: Luisa Crimini has been operating a beauty shop in a college town for the past 10 years. Recently, Luisa rented space next to her shop and opened a tanning salon. She anticipated that the costs for the tanning service would primarily be fixed, but found that tanning salon costs increased with the number of appointments. Costs for this service over the past 8 months are as follows:arrow_forward
- In the cost formula, the term 12,000 a. is the variable rate. b. is the dependent variable. c. is the independent variable. d. is the intercept. e. cannot be determined from the above formula. Use the following information for Multiple-Choice Questions 3-4 through 3-7: The following cost formula was developed by using monthly data for a hospital. Total Cost = 128,000,000 + (12,000 Number of Patient Days)arrow_forwardUsing (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.arrow_forwardam. 130.arrow_forward
- The following table contains selected data concerning the operation of the MHA Medical Center. Use the break-even formula and fill the missing information.arrow_forwardUsing the data in E4-2 and spreadsheet software, determine: The variable cost per unit, the total fixed cost, and R2. The plotted data points using the graphing function. Compare the results to your solutions in E4-2 and E4-3 and explain the reasons for the results.arrow_forwardIllustrate the effects of Dr. Jones’s pricing on the number of visits using a demand curve. The cost of Dr. Jones’s prenatal care determines the number of visits per year. At a cost of $200 per visit, patients visited 2 times; at $150, 3 visits; at $100, 4 visits; at $80, 5 visits; and at $50, 6 visits. Show the correlation between price and number of visits on the demand curve grapharrow_forward
- Quest. Simulation) The mai..gement of Brinkley Corporation is interested in using simulation to estimate the profit per unit for a new product. Probability distributions for the purchase cost, the labor cost, and the transportation cost are as follows: Labour Purchase Transportation Cost ($) Cost Cost ($) Probability ($) Probability Probability 10 0.25 20 0.1 3 0.75 11 0.45 22 0.25 0.25 12 0.3 24 0.35 25 0.3 Assume that these are the only costs and that the selling price for the product will be $45 per unit. a. Provide the base (most likely)-case, worst-case, and best-case calculations for the profit per unit. b. Set up intervals of random numbers that can be used to randomly generate the three cost components, and find the average profit based on 10 simulation trials. Show your simulation model (including the formulas sed) as developed with Excel. c. Using the random numbers 0.3726, 0.5839, and 0.8275, calculate the profit per unit. ( d. Management believes the project may not be…arrow_forwardThe regional transit authority for a major metropolitan area wants to determine whether there is a relationship between the age of a bus and the annual maintenance cost. A sample of 10 buses resulted in the following data: Develop a scatter chart for these data. What does the scatter chart indicate about the relationship between age of a bus and the annual maintenance cost? Use the data to develop an estimated regression equation that could be used to predict the annual maintenance cost given the age of the bus. What is the estimated regression model? 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? How much of the variation in the sample values of annual maintenance cost does the model you estimated in part (b) explain? What do you predict the annual maintenance cost to be for a 3.5-year-old bus?arrow_forwardPlease do not give solution in image format thankuarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
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
Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
Principles of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher:Cengage Learning
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher: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
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
Principles of Cost Accounting
Accounting
ISBN:9781305087408
Author:Edward J. Vanderbeck, Maria R. Mitchell
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