Cost Accounting (15th Edition)
15th Edition
ISBN: 9780133428704
Author: Charles T. Horngren, Srikant M. Datar, Madhav V. Rajan
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Textbook Question
Chapter 10, Problem 10.38P
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 solutionStudents 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…
Could you outline the difference between a fixed cost and a variable cost?Could you identify which expense is a fixed cost and which is a variable cost from the information in the scenario (storage unit vs. hospital gowns)?Develop a plan to reduce both costs within the next fiscal year.
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…
Chapter 10 Solutions
Cost Accounting (15th 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 - Prob. 10.16ECh. 10 - Prob. 10.17ECh. 10 - Various cost-behavior patterns. (CPA, adapted)....Ch. 10 - Matching graphs with descriptions of cost and...Ch. 10 - Prob. 10.20ECh. 10 - Prob. 10.21ECh. 10 - Prob. 10.22ECh. 10 - Prob. 10.23ECh. 10 - Prob. 10.24ECh. 10 - Prob. 10.25ECh. 10 - Prob. 10.26ECh. 10 - Prob. 10.27ECh. 10 - Learning curve, cumulative average-time learning...Ch. 10 - Learning curve, incremental unit-time learning...Ch. 10 - Prob. 10.30ECh. 10 - Prob. 10.31PCh. 10 - Prob. 10.32PCh. 10 - Prob. 10.33PCh. 10 - Interpreting regression results. Spirit...Ch. 10 - Prob. 10.35PCh. 10 - Prob. 10.36PCh. 10 - Regression; choosing among models. Apollo Hospital...Ch. 10 - Multiple regression (continuation of 10-42). After...Ch. 10 - Prob. 10.39PCh. 10 - Prob. 10.40PCh. 10 - Interpreting regression results, matching time...Ch. 10 - Prob. 10.42PCh. 10 - Prob. 10.43P
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
- As production increases, the fixed cost per unit a. decreases b. remains the same c. increases d. either increases or decreases, depending on the variable costs Standard costs are divided into which of the following components? a. price standard and quantity standard b. quality standard and quantity standard c. variance standard and quantity standard d. materials standard and labor standard Which of the following activity bases would be the most appropriate for food costs of a hospital? a. how many MRI's are taken b. number of patients who stay in the hospital c. quantity of prescriptions filled d. number of nurses scheduled to workarrow_forwardWeber 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_forwardRegression; choosing among models. Apollo Hospital specializes in outpatient surgeries for relatively minor procedures. Apollo is a nonprofit institution and places great emphasis on controlling costs in order to provide services to the community in an efficient manner. Apollo’s CFO, Julie Chen, has been concerned of late about the hospital’s consumption of medical supplies. To better understand the behavior of this cost, Julie consults with Rhett Bratt, the person responsible for Apollo’s cost system. After some discussion, Julie and Rhett conclude that there are two potential cost drivers for the hospital’s medical supplies costs. The first driver is the total number of procedures performed. The second is the number of patient-hours generated by Apollo. Julie and Rhett view the latter as a potentially better cost driver because the hospital does perform a variety of procedures, some more complex than others. Rhett provides the following data relating to the past year to Julie.…arrow_forward
- Least-Squares Regression Method; Scattergraph; Cost Behavior Professor John Morton has just been appointed chairperson of the Finance Department at Westland University. In reviewing the department’s cost records. Professor Morton has found the following total cost associated with Finance 101 over the last five terms: Professor Morton knows that there are some variable costs, such as amounts paid to graduate assistants, associated with the course. He would like to have the variable and fixed costs separated for planning purposes. Required: 1. Prepare a scattergraph plot. (Plot total cost on the vertical axis and number of sections offered on the horizontal axis.) 2. Using the least-squares regression method, estimate the variable cost per section and the total fixed cost per term for Finance 101. Express these estimates in the form Y = a + bX. 3. Assume that because of the small number of sections offered during the Winter Term this year. Professor Morton will have to offer eight…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_forwardam. 130.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_forward
- Which of the following will give you the most accurate allocation between a cost's fixed component and variable component? a. Examination of a students’ registration forms for miscellaneous fees and tuition fees b. Use of the least squares method to allocate the cost of electricity c. Dividing the total cost on the water bill among the different departments based on direct labor hours d. Dividing the total cost of the postpaid plan using the high-low methodarrow_forwardQuest. 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_forwarda Requirements g an S 1. Prepare a scatter plot of Flower Petal's volume (miles driven) and van operating costs. 2. Does the data appear to contain any outliers? Explain. 3. How strong of a relationship is there between miles driven and van operating costs? Print Done - ☑arrow_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 LearningEssentials 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
- 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
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