ACCESS IN BB-ACC202
ACCESS IN BB-ACC202
null Edition
ISBN: 9780135375587
Author: Pearson
Publisher: PEARSON
bartleby

Videos

Textbook Question
Book Icon
Chapter 6, Problem 6.67BP

Analyze cost behavior at a hospital using various cost estimation methods (Learning Objectives 1, 2, 3, 4 & 5)

Louis Becker is the Chief Operating Officer at Union Hospital in Newark, New Jersey. She is analyzing the hospital’s overhead costs but is not sure whether nursing hours or the number of patient days would be the best cost driver to use for predicting the hospital’s overhead. She has gathered the following information for the last six months of the most recent year:

Chapter 6, Problem 6.67BP, Analyze cost behavior at a hospital using various cost estimation methods (Learning Objectives 1, 2, , example  1

Requirements

  1. 1. Are the hospital’s overhead costs fixed, variable, or mixed? Explain.
  2. 2. Graph the hospital’s overhead costs against nursing hours. Use Excel or graph by hand.
  3. 3. Graph the hospital’s overhead costs against the number of patient days. Use Excel or graph by hand.
  4. 4. Do the data appear to be sound, or do you see any potential data problems? Explain.
  5. 5. Use the high-low method to determine the hospital’s cost equation using nursing hours as the cost driver. Predict total overhead costs if 25,500 nursing hours are predicted for the month.
  6. 6. Becker runs a regression analysis using nursing hours as the cost driver to predict total hospital overhead costs. The Excel output from the regression analysis is as follows:

Chapter 6, Problem 6.67BP, Analyze cost behavior at a hospital using various cost estimation methods (Learning Objectives 1, 2, , example  2

If 25,500 nursing hours are predicted for the month, what is the total predicted hospital overhead?

  1. 7. Becker then ran the regression analysis using number of patient days as the cost driver. The Excel output from the regression is as follows:

Chapter 6, Problem 6.67BP, Analyze cost behavior at a hospital using various cost estimation methods (Learning Objectives 1, 2, , example  3

  1. 1. If 3,680 patient days are predicted for the month, what is the total predicted hospital overhead?
  2. 2. Which regression analysis (using nursing hours or using number of patient days as the cost driver) produces the best cost equation? Explain your answer.
Blurred answer
Students have asked these similar questions
Classify costs and make a quality-initiative decision (Learning Objective 5) Sinclair Corp. manufactures radiation-shielding glass panels . Suppose Sinclair is consider-ing spending the following amounts on a new TOM program :Strength-testing one item from each batch of panels ......................... . Training employees in TOM ................................................................. . Training suppliers in TOM .................................................................... . Identifying preferred suppliers that commit to on-time delivery ofperfect quality materials ................................................................... .Sinclair expects the new program to save costs through the following:Avoid lost profits from lost sales due to disappointed customers ....... Avoid rework and spoilage ................................................................. .. Avoid inspection of raw materials ........................................................ . Avoid…
You wish to take an Excel course. You may enroll at one within your school or you may take a community class at the local library. You've gathered the following information to aid in your decision-making process:  Costs/Benefits College Course Community Course Cost $4,300 $1,190 Distance to course 0.20 miles (walking distance) 18 miles (driving distance) Timing of course Weekday Weekend Number of meetings 16 8 Qualitative considerations Convenience, quality of instruction Flexibility, brief duration   Pretend transportation (gas, mileage, and parking) cost $220 per class session at the library. If you consider solely the cost - including transportation - of each alternative, which would you choose?   Multiple Choice   College course   Community course   Both alternatives   Neither alternative
The Vest School of Vocational Technology has organized the school training programs into three departments. Each department provides training in a different area as follows: nursing assistant, dental hygiene, and office technology. The school's owner, Candice Vest, wants to know how much it cost to operate each of the three departments. To accumulate the total cost for each department, the accountant has identified several indirect costs that must be allocated to each. These costs are $10,080 of telephone expense, $2,016 of supplies expense, $720,000 of office rent, $144,000 of janitorial services, and $150,000 of salary paid to the dean of students. To provide a reasonably accurate allocation of costs, the accountant has identified several possible cost drivers. These drivers and their association with each department follow.   Cost Driver Department 1 Department 2 Department 3 Number of telephone 28 16 19 Number of faculty members 20 16 12 Square footage of office space 28,000 16,800…

Chapter 6 Solutions

ACCESS IN BB-ACC202

Ch. 6 - Identify cost behavior (Learning Objectives 1 2)...Ch. 6 - Prob. 6.2SECh. 6 - Compute fixed costs per unit (Learning Objective...Ch. 6 - Prob. 6.4SECh. 6 - Predict and graph total mixed costs (Learning...Ch. 6 - Prob. 6.6SECh. 6 - Prepare and analyze a scatterplot (Learning...Ch. 6 - Prob. 6.8SECh. 6 - Use the high-low method (Learning Objective 4)...Ch. 6 - Prob. 6.10SECh. 6 - Prob. 6.11SECh. 6 - Prob. 6.12SECh. 6 - Write a cost equation given regression output...Ch. 6 - Prepare a contribution margin income statement...Ch. 6 - Prepare income statements using variable costing...Ch. 6 - Prepare income statements using variable costing...Ch. 6 - Identify cost behavior graph (Learning Objectives...Ch. 6 - Prob. 6.18SECh. 6 - Prob. 6.19SECh. 6 - Prob. 6.20AECh. 6 - Prepare income statement in two formats (Learning...Ch. 6 - Prob. 6.22AECh. 6 - Prob. 6.23AECh. 6 - Sustainability and cost estimation (Learning...Ch. 6 - Create a scatterplot (Learning Objective 3) Melody...Ch. 6 - Continuation of E6-25A: High-low method (Learning...Ch. 6 - Continuation of E6-25A: Regression analysis...Ch. 6 - Regression analysis using Excel output (Learning...Ch. 6 - Prob. 6.29AECh. 6 - Using the high-low method to predict overhead for...Ch. 6 - Using regression analysis output to predict...Ch. 6 - Performing a regression analysis to predict...Ch. 6 - Prob. 6.33AECh. 6 - Prob. 6.34AECh. 6 - Compare absorption and variable costing (Learning...Ch. 6 - Prepare a contribution margin income statement...Ch. 6 - Prepare a contribution margin income statement...Ch. 6 - Prepare income statements using variable costing...Ch. 6 - Prepare a variable costing income statement given...Ch. 6 - Prob. 6.40AECh. 6 - Prob. 6.41BECh. 6 - Prepare income statement in two formats (Learning...Ch. 6 - Use unit cost data to forecast total costs...Ch. 6 - Prob. 6.44BECh. 6 - Sustainability and cost estimation (Learning...Ch. 6 - Create a scatter plot (Learning Objective 3) Tammy...Ch. 6 - Continuation of E6-46B: High-low method (Learning...Ch. 6 - Prob. 6.48BECh. 6 - Prob. 6.49BECh. 6 - Prob. 6.50BECh. 6 - Using the high-low method to predict overhead for...Ch. 6 - Using regression analysis output to predict...Ch. 6 - Prob. 6.53BECh. 6 - Prob. 6.54BECh. 6 - Prob. 6.55BECh. 6 - Prob. 6.56BECh. 6 - Prob. 6.57BECh. 6 - Prob. 6.58BECh. 6 - Prob. 6.59BECh. 6 - Prepare a variable costing income statement given...Ch. 6 - Prob. 6.61BECh. 6 - Analyze cost behavior at a hospital using various...Ch. 6 - Analyze cost behavior (Learning Objectives 1, 2,...Ch. 6 - Prob. 6.64APCh. 6 - Prob. 6.65APCh. 6 - Prob. 6.66APCh. 6 - Analyze cost behavior at a hospital using various...Ch. 6 - Analyze cost behavior (Learning Objectives 1, 2,...Ch. 6 - Prepare traditional and contribution margin income...Ch. 6 - Prob. 6.70BPCh. 6 - Prob. 6.71BPCh. 6 - Prob. 6.72SCCh. 6 - Cost Behavior in Real Companies Choose a company...Ch. 6 - Ethics of building inventory (Learning Objective...Ch. 6 - Prob. 6.76ACT
Knowledge Booster
Background pattern image
Accounting
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
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
Text book image
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Text book image
Financial And Managerial Accounting
Accounting
ISBN:9781337902663
Author:WARREN, Carl S.
Publisher:Cengage Learning,
Text book image
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
Text book image
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
Text book image
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
What is Business Analysis?; Author: WolvesAndFinance;https://www.youtube.com/watch?v=gG2WpW3sr6k;License: Standard Youtube License