Managerial Accounting, Student Value Edition (5th Edition)
Managerial Accounting, Student Value Edition (5th Edition)
5th Edition
ISBN: 9780134067179
Author: Karen W. Braun, Wendy M. Tietz
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
Accounting Cycle Review 15 a-e Carla Vista Corporation's trial balance at December 31, 2020, is presented below. All 2020 transactions have been recorded except for the items described below. Debit Credit Cash Accounts Receivable Inventory $27,400 59,000 22,600 Land 62,900 Buildings 96,900 Equipment 42,000 Allowance for Doubtful Accounts $430 Accumulated Depreciation-Buildings 30,500 Accumulated Depreciation-Equipment 15,000 Accounts Payable 19,300 Interest Payable -0- Dividends Payable Unearned Rent Revenue -0- 8,800 Bonds Payable (10%) 54,000 Common Stock ($10 par) 34,000 Paid-in Capital in Excess of Par-Common Stock 6,800 Preferred Stock ($20 par) -0- Paid-in Capital in Excess of Par-Preferred -0- Stock Retained Earnings 72,970 Treasury Stock -0- Cash Dividends Sales Revenue Rent Revenue Bad Debt Expense Interest Expense Cost of Goods Sold Depreciation Expense Other Operating Expenses Salaries and Wages Expense -0- 576,000 -0- -0- -0- 404,000 -0- 39,900 63,100 Total Unrecorded…
Can you please give me correct answer this general accounting question?
Do fast answer of this general  accounting question

Chapter 6 Solutions

Managerial Accounting, Student Value Edition (5th Edition)

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.
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