Cornerstones of Cost Management (Cornerstones Series)
4th Edition
ISBN: 9781305970663
Author: Don R. Hansen, Maryanne M. Mowen
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Textbook Question
Chapter 3, Problem 37P
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?
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
To estimate the monthly maintenance cost for the maintenance department in a hospital, the following monthly costs are
available:
Monthly Expense
Supervisor Salary Expense
Depreciation Expense-Maintenance Equipment
Repairs Expense-Maintenance Equipment
Supplies Expense
Wages Expense-Maintenance Workers
$10,000
The Supervisor Salary Expense and the Depreciation Expense are fixed costs. The remaining expenses are variable costs. There are
1,000 patient days in a month, which is the cost driver for maintenance costs. Estimate the cost function where Y is the monthly
maintenance cost and X is the variable cost per patient day.
OY-58+$22X
OY $30,000 $22.000x
OY-$8,000-$22,000x
OY-$8,000 $22X
$5,000
Costs
$3,000
$5,000
$7,000
Falls Creek Community Health Clinic uses the high-low method to analyze cost behavior and has determined that
number of patients treated predict the clinic's total treatment costs. Determine the cost function (formula) for
total treatment costs. What will the estimated treatment cost be if Falls Creek treats 1,402 patients in a month?
Total
Number
Treatment of
Patients
Costs
January $3,410
February $3,790
$3,574
$3,730
$4,500
1060
1180
March
1030
April
1260
May
1310
$4,294
June
1430
(Round your final answer to two decimal places)
Refer to the information for Luisa Crimini above.Required:1. Which month represents the high point? The low point?2. Using the high-low method, compute the variable rate for tanning. Compute the fixedcost per month.3. Using your answers to Requirement 2, write the cost formula for tanning services.4. Calculate the total predicted cost of tanning services for September for 2,500 appointments using the formula found in Requirement 3. Of that total cost, how much is thetotal fixed cost for September? How much is the total predicted variable cost forSeptember?5. CONCEPTUAL CONNECTION Identify and briefly explain any additional issues thatLuisa might be wise to consider when using the high-low method to estimate the costs ofher tanning salon.
Chapter 3 Solutions
Cornerstones of Cost Management (Cornerstones Series)
Ch. 3 - Why is knowledge of cost behavior important for...Ch. 3 - How does the length of the time horizon affect the...Ch. 3 - Prob. 3DQCh. 3 - What is the relationship between flexible...Ch. 3 - What is the relationship between committed...Ch. 3 - Describe the difference between a variable cost...Ch. 3 - Why do mixed costs pose a problem when it comes to...Ch. 3 - Why is a scattergraph a good first step in...Ch. 3 - What are the advantages of the scatterplot method...Ch. 3 - Prob. 10DQ
Ch. 3 - What is meant by the best-fitting line? Is the...Ch. 3 - When is multiple regression required to explain...Ch. 3 - Explain the meaning of the learning curve. How do...Ch. 3 - Assume you are the manager responsible for...Ch. 3 - Some firms assign mixed costs to either the fixed...Ch. 3 - Callies Gym is a complete fitness center. Owner...Ch. 3 - Corazon Manufacturing Company has a purchasing...Ch. 3 - Darnell Poston, owner of Poston Manufacturing,...Ch. 3 - Dohini Manufacturing Company had the following 12...Ch. 3 - Refer to Cornerstone Exercise 3.4 for data on...Ch. 3 - The controller for Dohini Manufacturing Company...Ch. 3 - Prob. 7CECh. 3 - State Universitys football team just received a...Ch. 3 - Classify the following costs of activity inputs as...Ch. 3 - SmokeCity, Inc., manufactures barbeque smokers....Ch. 3 - Cashion Company produces chemical mixtures for...Ch. 3 - For the following activities and their associated...Ch. 3 - Prob. 13ECh. 3 - Vargas, Inc., produces industrial machinery....Ch. 3 - Penny Davis runs the Shear Beauty Salon near a...Ch. 3 - Shirrell Blackthorn is the accountant for several...Ch. 3 - Deepa Dalal opened a free-standing radiology...Ch. 3 - Prob. 18ECh. 3 - The controller of the South Charleston plant of...Ch. 3 - Lassiter Company used the method of least squares...Ch. 3 - Sweet Dreams Bakery was started five years ago by...Ch. 3 - Ginnian and Fitch, a regional accounting firm,...Ch. 3 - Bordner Company manufactures HVAC (heating,...Ch. 3 - Sharon Glessing, controller for Janson Company,...Ch. 3 - The graphs below represent cost behavior patterns...Ch. 3 - Starling Co. manufactures one product with a...Ch. 3 - Alard Manufacturing Company has a billing...Ch. 3 - Prob. 28ECh. 3 - Prob. 29ECh. 3 - Natur-Gro, Inc., manufactures composters. Based on...Ch. 3 - Rolertyme Company manufactures roller skates. With...Ch. 3 - St. Teresas Medical Center (STMC) offers a number...Ch. 3 - Big Mikes, a large hardware store, has gathered...Ch. 3 - Kimball Company has developed the following cost...Ch. 3 - The management of Wheeler Company has decided to...Ch. 3 - DeMarco Company is developing a cost formula for...Ch. 3 - Weber Valley Regional Hospital has collected data...Ch. 3 - Friendly Bank is attempting to determine the cost...Ch. 3 - Randy Harris, controller, has been given the...Ch. 3 - The Lockit Company manufactures door knobs for...Ch. 3 - Harriman Industries manufactures engines for the...Ch. 3 - Thames Assurance Company sells a variety of life...
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
- Method 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_forwardJensen 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_forwardIn 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_forward
- 2. The administrator of ABC Hospital would like to know the relationship between the costs of admitting in relation to the number of patients being admitted and determine the cost formula. The following are the related data for the past five months that will be used determine such cost formula.Month | # of Patients Admitted |Admitting CostsJanuary 1,800 P 14,700February 1,900 P 15,200March 1,700 P 13,700April 1,600 P 14,000May 1,500 P 14,300The controller suggested to use the high-low method approach to derive for the cost formula. If the controller’s suggestion is to be followed:How much would be the total fixed costs?arrow_forward4. The administrator of ABC Hospital would like to know the relationship between the costs of admitting in relation to the number of patients being admitted and determine the cost formula. The following are the related data for the past five months that will be used determine such cost formula.Month |# of Patients Admitted |Admitting CostsJanuary 1,800 P 14,700February 1,900 P 15,200March 1,700 P 13,700April 1,600 P 14,000May 1,500 P 14,300The controller suggested to use the high-low method approach to derive for the cost formula. If the controller’s suggestion is to be followed:What would be the prediction formula/cost formula?arrow_forwardDeepa Dalal opened a free-standing radiology clinic. She had anticipated that the costs for the radiological tests would be primarily fixed, but she found that costs increased with the number of tests performed. Costs for this service over the past nine months are as follows: Required: 1. Prepare a scattergraph based on the preceding data. Use cost for the vertical axis and number of radiology tests for the horizontal axis. Based on an examination of the scattergraph, does there appear to be a linear relationship between the cost of radiology service and the number of tests? 2. Compute the cost formula for radiology services using the high-low method. 3. Calculate the predicted cost of radiology services for October for 3,500 tests using the formula found in Requirement 2.arrow_forward
- Lising Therapy has a physical therapist who performs electro-mechanical treatments for its patients. During April, Lising had the following cost and output information: Required: 1. Calculate the cost per treatment for April. 2. Calculate the cost of services sold for April. 3. What if Lising found a way to reduce overhead costs by 20 percent? How would this affect the profit per treatment?arrow_forwardTo compute a daily rate that reflected the difference in demands, patients were placed in three categories according to illness severity, and the following annual data were collected: Cost of Activity Activity Driver $ 546,780 2,132,200 441,630 4,185,700 $7,306,310 Activity Lodging Monitoring Feeding Nursing care Total The demands associated with patient severity are also provided: Severity Patient Days Monitoring Hours Nursing Hours High Medium Low 7,170 10,180 3,680 $ Patient days Monitoring hours used Patient days Nursing hours High severity Medium severity Low severity 15,170 12,030 3,260 133,100 72,900 14,300 Required: 1. Suppose that the costs of daily care are assigned using only patient days as the activity driver (which is also the measure of output). Compute the daily rate using this unit-based approach of cost assignment. If required, round your answer to the nearest cent. per day 2. Compute activity rates using the given activity drivers (combine activities with the same…arrow_forwardUsing the least-squares method of analyzing costs, answer the following questions and show computations to support your answers. a. What is the estimated variable portion of maintenance costs per labor hour? B.What is the estimated fixed maintenance cost each month? C.Formulate the regression equation D.If it is estimated that 600 labor hours will be used in July, what is the expected total power cost for July?arrow_forward
- A manufacturing plant wishes to buy a new equipment so the purchasing department did some research different types of this equipment. In the monthly meeting, the purchasing department presented a report about the two types of equipment that they have found. Pertinent data follows: If the minimum required rate of return is 19%,arrow_forward1. The administrator of ABC Hospital would like to know the relationship between the costs of admitting in relation to the number of patients being admitted and determine the cost formula. The following are the related data for the past five months that will be used determine such cost formula. Month |# of Patients Admitted |Admitting Costs January 1,800 P 14,700 February 1,900 P 15,200 March 1,700 P 13,700 April 1,600 P 14,000 May 1,500 P 14,300 The controller suggested to use the high-low method approach to derive for the cost formula. If the controller’s suggestion is to be followed: How much would be the variable cost per unit? 2. The administrator of ABC Hospital would like to know the relationship between the costs of admitting in relation to the number of patients…arrow_forwardNursing home costs are on the rise as consumeraffairs.com reports in its quarterly newsletter. The average cost is around $194 a day with an average length of stay of 2.7 years. Calculate the cost of the average nursing home stay.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher: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 LearningExcel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning
- Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
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
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
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