ACCESS IN BB-ACC202
null Edition
ISBN: 9780135375587
Author: Pearson
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Textbook Question
Chapter 6, Problem 6.62AP
Analyze cost behavior at a hospital using various cost estimation methods (Learning Objectives 1, 2, 3, 4, & 5)
Sandy Dawson is the Chief Operating Officer at Mercy Hospital in Atlanta, Georgia. She is analyzing the hospital’s
Requirements
- 1. Are the hospital’s overhead costs fixed, variable, or mixed? Explain.
- 2. Graph the hospital’s overhead costs against nursing hours. Use Excel or graph by hand.
- 3. Graph the hospital’s overhead costs against the number of patient days. Use Excel or graph by hand.
- 4. Do the data appear to be sound, or do you see any potential data problems? Explain.
- 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. Dawson 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:
If 25,500 nursing hours are predicted for the month, what is the total predicted hospital overhead?
- 7. Dawson then ran the regression analysis using number of patient days as the cost driver. The Excel output from the regression is shown here:
If 3,680 patient days are predicted for the month, what is the total predicted hospital overhead?
- 8. Which regression analysis (using nursing hours or using number of patient days as the cost driver) produces the best cost equation? Explain your answer.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
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
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…
Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion.You are required to submit this assignment to LopesWrite. Please refer to the directions in the Student Success Center.Paul Duncan, financial manager of EduSoft Inc., is facing a dilemma. The firm was founded 5 years ago to provide educational software for the rapidly expanding primary and secondary school markets. Although EduSoft has done well, the firm's founder believes an industry shakeout is imminent. To survive, EduSoft must grab market share now, and this will require a large infusion of new capital.Because he expects earnings to continue rising sharply and looks for the stock price to follow suit, Mr. Duncan does not think it would be wise to issue new common stock at this time. On the other hand, interest rates are currently high by historical standards, and the firm's B rating means that interest payments on a new debt issue would be prohibitive.…
Chapter 6 Solutions
ACCESS IN BB-ACC202
Ch. 6 - (Learning Objective 1) A graph of a variable cost...Ch. 6 - (Learning Objective 2) Which of the following is...Ch. 6 - (Learning Objective 2) In the cost equation...Ch. 6 - Prob. 4QCCh. 6 - Prob. 5QCCh. 6 - (Learning Objective 3) Which of the following is...Ch. 6 - Prob. 7QCCh. 6 - (Learning Objective 5) Which of the following is...Ch. 6 - Prob. 9QCCh. 6 - Prob. 10QC
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
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
- Cost Identification Following is a list of cost terms described in the chapter as well as a list of brief descriptive settings for each item. Cost terms: a. Opportunity cost b. Period cost c. Product cost d. Direct labor cost e. Selling cost f. Conversion cost g. Prime cost h. Direct materials cost i. Manufacturing overhead cost j. Administrative cost Settings: 1. Marcus Armstrong, manager of Timmins Optical, estimated that the cost of plastic, wages of the technician producing the lenses, and overhead totaled 30 per pair of single-vision lenses. 2. Linda was having a hard time deciding whether to return to school. She was concerned about the salary she would have to give up for the next 4 years. 3. Randy Harris is the finished goods warehouse manager for a medium-sized manufacturing firm. He is paid a salary of 90,000 per year. As he studied the financial statements prepared by the local certified public accounting firm, he wondered how his salary was treated. 4. Jamie Young is in charge of the legal department at company headquarters. Her salary is 95,000 per year. She reports to the chief executive officer. 5. All factory costs that are not classified as direct materials or direct labor. 6. The new product required machining, assembly, and painting. The design engineer asked the accounting department to estimate the labor cost of each of the three operations. The engineer supplied the estimated labor hours for each operation. 7. After obtaining the estimate of direct labor cost, the design engineer estimated the cost of the materials that would be used for the new product. 8. The design engineer totaled the costs of materials and direct labor for the new product. 9. The design engineer also estimated the cost of converting the raw materials into their final form. 10. The auditor for a soft drink bottling plant pointed out that the depreciation on the delivery trucks had been incorrectly assigned to product cost (through overhead). Accordingly, the depreciation charge was reallocated on the income statement. Required: Match the cost terms with the settings. More than one cost classification may be associated with each setting; however, select the setting that seems to fit the item best. When you are done, each cost term will be used just once.arrow_forwardTriad Children's Center(TCC), a non-profit organization, uses relevant cost analysis to determine whether new services are desirable. TCC is looking at adding a new education program for grade school children who are having difficulty with the reading and math skills. The following relevant cost are expected if the program is accepted:arrow_forwardThe 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…arrow_forward
- In an effort to raise the demand for reading tests, managers are planning to lower the price from $36 per test to $20 per test, the current price of the math test. They believe that doing so will increase the demand for reading tests to 60,000. Prepare a contribution format income statement reflecting Abado’s new pricing and demand structure. Abado Profiles provides testing services to school districts that wish to assess students’ reading and mathematical abilities. Last year Abado evaluated 60,000 math tests and 20,000 reading tests. An income statement for last year follows. Math Testing Reading Testing Total Per Unit Total Per Unit Total Company Sales revenue $1,200,000 $20 $720,000 $36 $1,920,000 Variable expenses 840,000 14 360,000 18 1,200,000 Contribution margin $360,000 $6 $360,000 $18 720,000 Fixed expenses 360,000 Operating income $360,000arrow_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_forwardhe Shining Stars primary school was the recent recipient of a technology grant to source and implement a school management system. The school administrator is not technology savvy and therefore sought advice from three of the board members who were knowledgeable in the information systems and technology field. One director advised the administrator to purchase an off-the-shelf solution which would allow the school to get the system configured and up and running in a short period with reasonable costs. The second advised the administrator to invest in the development of a unique system to meet the custom requirements of the school’s administration. He suggested that this would create a closer fit to the school’s needs compared to purchasing software, but will cost more. The third director suggested using an open source solution which would have little if any upfront costs but may take some time to set up. i) Identify the…arrow_forward
- Professional University teaches a large range of undergraduate courses. It is interested in determining the cost equation for the facilities cost as a function of student credit hours so that it an more accurately budget its facilities costs as enrollment grows. Information for the high and low cost semesters and volumes for last 5 years appears below Semester Student Cresit Hours Facilities Cost Spring 2007 250,000 $500,000 Fall 2004 300,000 $530,000 Using the high low method, with student credit hours as the activity driver, wht is the equation for facilities cost (FC) as a function of student credit hours?arrow_forwardThe Allegheny School of Music has hired you as a consultant to help in analyzing the behavior of the school’s costs. Use the account-classification method of cost estimation to classify each of the following costs as variable, fixed, or semivariable. Before classifying the costs, choose an appropriate measure for the school’s activity. 1.Salaries and fringe benefits of the school’s full-time teachers. 2.Salaries and fringe benefits of the school’s full-time administrative staff. 3.Cost of buying books, sheet music, and other academic materials that are supplied to the students by the school. 4.Repairs on musical instruments. The school employs a full-time repair technician. Repair jobs that are beyond the technician’s capability are taken to a local musical-instrument dealer for repairs. 5.Fee charged by a local public accounting firm to audit the school’s accounting records. 6.Wages of the school’s part-time assistant recital instructors. These employees are hired on a tem-porary…arrow_forwardThe Shining Stars primary school was the recent recipient of a technology grant to source and implement a school management system. The school administrator is not technology savvy and therefore sought advice from three of the board members who were knowledgeable in the information systems and technology field. One director advised the administrator to purchase an off-the-shelf solution that would allow the school to get the system configured and up and running in a short period with reasonable costs. The second advised the administrator to invest in the development of a unique system to meet the custom requirements of the school’s administration. He suggested that this would create a closer fit to the school’s needs compared to purchasing software, but will cost more. The third director suggested using an open-source solution which would have little if any upfront costs but may require some customization. The school administrator must decide about which solution to go with.…arrow_forward
- The actual and planned data for Underwater University for the Fall term were as follows: Actual Planned Enrollment 4,500 4,125 Tuition per credit hour $120 $135 Credit hours 60,450 43,200 Registration, records, and marketing costs per enrolled student $275 $275 Instructional costs per credit hour $64 $60 Depreciation on classrooms and equipment $825,600 $825,600 Registration, records, and marketing costs vary by the number of enrolled students, while instructional costs vary by the number of credit hours. Depreciation is a fixed cost. Prepare a variable costing income statement showing the contribution margin and operating income for the Fall term. Underwater University Variable Costing Income Statement For the Fall Term Revenue $ Variable costs: Registration, records, and marketing costs $ Instructional costs Total variable costs $ Contribution margin $ Depreciation on classrooms and equipment Operating income…arrow_forwardTo complete the first setup on a new machine took an employee 100 minutes. Using an 80% incremental unit-time learning model indicates that the second setup on the new machine is expected to take ________. Select one: a. 70 minutes b. 80 minutes c. 120 minutes d. 60 minutesarrow_forwardA marketing professor at Givens College is interested in the relationship between hours spent studying and total points earned in a course. Data collected on 156 students who took the course last semester are provided in the tile MktHrsPts. Develop a scatter chart for these data. What does the scatter chart indicate about the relationship between total points earned and hours spent studying? Develop an estimated regression equation showing how total points earned is related to hours spent studying. What is the estimated regression model? Test whether each of the regression parameters β0 and β1 is equal to zero at a 0.01 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 total point earned does the model you estimated in part (b) explain? Mark Sweeney spent 95 hours studying. Use the regression model you estimated in part (b) to predict the total points Mark earned.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 LearningManagerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubFinancial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,
- Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax CollegeManagerial 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 Learning
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Financial And Managerial Accounting
Accounting
ISBN:9781337902663
Author:WARREN, Carl S.
Publisher:Cengage Learning,
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
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
What is Business Analysis?; Author: WolvesAndFinance;https://www.youtube.com/watch?v=gG2WpW3sr6k;License: Standard Youtube License