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.32AE
Performing a regression analysis to predict overhead for a hospital laboratory (Learning Objective 5)
The manager of the main laboratory facility at Elmhurst Health Center (from E6-29A) collects seven additional months of data after obtaining the regression results in E6-31A. The number of tests performed and the total monthly overhead costs for the lab follow:
Month | Number of Lab Tests Performed | Total Laboratory Overhead Costs |
August | 3,350 | $23,500 |
September | 3,700 | $27,550 |
October | 3,650 | $24,500 |
November | 3,450 | $26,400 |
December | 4,200 | $28,500 |
January | 2,500 | $22,800 |
February | 3,800 | $25,350 |
Use Excel to do the following:
Requirements
- 1. Run a regression analysis using data for August through February.
- 2. Determine the lab’s cost equation (use the output from the regression analysis you performed using Excel).
- 3. Determine the R-square using the Excel output you obtain. What does the lab’s R-square indicate?
- 4. Predict the lab’s total overhead costs for the month if 3,500 tests are performed.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
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…
To 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 minutes
Performance Aid, Inc. has two divisions: Test Preparation and Language Arts. Results (in millions) for the past three years are partially displayed here:
Q.Complete the table by filling in the blanks.
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
- Bordner Company manufactures HVAC (heating, ventilation, and air conditioning) systems for commercial buildings. For each new design, Bordner faces a 90 percent learning rate. On average, the first unit of a new design takes 600 hours. Direct labor is paid 25 per hour. Required: 1. Set up a table with columns showing: the cumulative number of units, cumulative average time per unit in hours, and cumulative total time in hours. Show results by row for total production of one unit, two units, four units, eight units, and sixteen units. (Round hour answers to two significant digits.) 2. What is the total labor cost if Bordner makes the following number of units: one, four, sixteen? What is the average cost per system for the following number of systems: one, four, or sixteen? (Round your answers to the nearest dollar.) 3. Using the logarithmic function, set up a table with columns showing: the cumulative number of units, cumulative average time per unit in hours, cumulative total time in hours, and the time for the last unit. Show results by row for each of units one through eight. (Round answers to two significant digits.)arrow_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_forwardLearning CurveBordner Company manufactures HVAC (heating, ventilation, and air conditioning) systems for commercial buildings. For each new design, Bordner faces a 90 percent learning rate. On aver-age, the first unit of a new design takes 600 hours. Direct labor is paid $25 per hour. Required:1. Set up a table with columns showing: the cumulative number of units, cumulative average time per unit in hours, and cumulative total time in hours. Show results by row for total pro-duction of one unit, two units, four units, eight units, and sixteen units. (Round hour answers to two significant digits.) 2. What is the total labor cost if Bordner makes the following number of units: one, four, sixteen? What is the average cost per system for the following number of systems: one, four, or sixteen? (Round your answers to the nearest dollar.) 3. Using the logarithmic function, set up a table with columns showing: the cumulative number of units, cumulative average time per unit in hours,…arrow_forward
- A professional division at a business school provides several development programs that have been tailored to the specific training needs of both the public and private sectors. The program director is planning to offer a one-full-day course in risk management to be sold at $2,250 plus orientation fee (5%) per participant. The division incurs a cost of $45,000 for promotion, classroom space, staff and instructor’s salary, as well as a cost of $240 per participant for refreshments, lunch, course material, a gift package, and a framed certificate of completion. How many participants need to register in the course for it to be worthwhile to offer it? Round to two decimal places. Group of answer choices 21.20 26.86 36.72arrow_forwardprofile-image Student question Time to preview question: 00 : 08 : 51 The Epsilon Co. have a building, which houses three production department, Alpha, Beta and Gamma, and one service department Delta. The service department, Delta is wholly involved in working for the three production departments and it is estimated that department Alpa uses 50%, department Beta uses 30% and department Gamma uses 20% of the services of department Delta. The budgeted overhead for the four departments for a period were: REQUIRED: a. Apportion the costs to the departments on the most equitable bases and calculate the overhead absorption rate, based on labour hours, for all the production department.arrow_forwardYour company has received an order for 20 units of aproduct. Th e labor cost to produce the item is $9.50 per hour. Th esetup cost for the item is $60 and material costs are $25 per unit. Th e item is sold for $92. Th e learning rate is 80 percent. Overheadis assessed at a rate of 55 percent of unit labor cost.(a) Determine the average unit cost for the 20 units if the fi rstunit takes four hours.(b) Determine the minimum number of units that need to bemade before the selling price meets or exceeds the averageunit cost.arrow_forward
- Thames Assurance Company sells a variety of life and health insurance products. Recently, Thames developed a long-term care policy for sale to members of university and college alumni associations. Thames estimated that the sale and service of this type of policy would be subject to a 90 percent cumulative average-time learning curve model. Each unit consists of 350 policies sold. The first unit is estimated to take 1,000 hours to sell and service. Required: 1. Set up a table with columns for cumulative number of units, cumulative average time per unit in hours, and the cumulative total time in hours. Complete the table for 1, 2, 4, 8, 16, and 32 units. 2. Suppose that Thames revises its assumption to an 80 percent learning curve. How will this affect the amount of time needed to sell and service eight units? How do you suppose that Thames estimates the percent learning rate?arrow_forwardThe Bienestar Cardiology Clinic has two major activities: diagnostic and treatment. The two activities use four resources: nursing, medical technicians, cardiologists, and equipment. Detailed interviews have provided the work distribution matrix shown below. The total time estimated corresponds to practical capacity (interviewers adjusted the total time to about 80 percent of the available time). The equipment time is measured in machine hours. Thus, the total time (at practical capacity) in the system is 20,000 hours. In considering the implementation of a TDABC model, the following unit times and transaction information are also provided: Required: 1. Calculate the cost of each activity using the indicated values of the resource drivers. 2. Calculate the capacity cost rate for TDABC. Using the capacity cost rate, calculate the cost of each activity under TDABC. Compare these values with those obtained in Requirement 1 and discuss possible reasons for any differences. 3. Suppose that the actual activity driver quantities are 3,500 and 9,000. Calculate the cost of unused capacity. 4. Suppose that the clinic acquires new equipment that reduces the total time required for the two activities from 6,000 to 4,000 hours. The equipment cost remains the same. Explain how the ABC system would be updated and then describe how TDABC would provide updates. 5. Suppose that diagnosing patients without any cardiac disease takes two hours while diagnosing patients with mildly diseased hearts takes an additional 1.5 hours and those with more severe problems takes an additional two hours. Prepare a time equation and, using the capacity cost rate from Requirement 2, calculate the activity rate for each of the three types of patients.arrow_forwardC7-73 Calculate breakeven and margin of safety after hotel renovation (Learning Objective 2) Cost-Volume-Profit Analysis 437 This case is a continuation of the Caesars Entertainment Corporation serial case that began in Chapter 1. Refer to the introductory story in chapter 1 (see page 43) for additional background. (The components of the Caesars serial case can be completed in any order.) Caesars Palace® Las Vegas made headlines when it undertook a $75 million renovation. In mid-September 2015, the hotel closed its then-named Roman Tower, which was last updated in 2001, and started a major renovation of the 567 rooms housed in that tower . On January 1, 2016, the newly renamed Julius Tower reopened, replacing the Roman Tower. In addition to renovating the existing rooms and suites in the former Roman Tower, 20 guest rooms were added to the Roman Tower. With the renovation completed, Caesars expects the Julius Tower room rate to average around $149 per night. This increase, a $25 or 20…arrow_forward
- Englert Hospital began using standards to evaluate its Admissions Department. The standard was broken into two types of admissions as follows: Type of Admission Standard Time to CompleteAdmission Record Unscheduled admission 30 min. Scheduled admission 15 min. The unscheduled admission took longer because name, address, and insurance information needed to be determined and verified at the time of admission. Information was collected on scheduled admissions prior to the admissions, which was less time-consuming. The Admissions Department employs four full-time people (40 productive hours per week, with no overtime) at $15 per hour. For the most recent week, the department handled 140 unscheduled and 350 scheduled admissions. a. How much was actually spent on labor for the week?$fill in the blank 1 b. What are the standard hours for the actual volume for the week (round to one decimal place)?fill in the blank 2 hours c. Calculate the time…arrow_forwardt. John's Medical Testing Center (SJMC), which provides services such as x-rays, CAT scans, MRIs, etc., has five medical technicians who are responsible for conducting cardiac catheterization testing in SJMC's Cath Lab. Each technician is paid a salary of $36,000 and is capable of conducting 1,000 procedures per year. The cardiac catheterization equipment is one year old and was purchased for $250,000. It is expected to last five years. The equipment's capacity is 25,000 procedures over its life. Depreciation is computed on a straight-line basis, with no salvage value expected. The reading of the catheterization results is conducted by an outside physician whose fee is $120 per test. The technician's report with the outside physician's note of results is sent to the referring physician. In addition to the salaries and equipment, SJMC spends $50,000 for supplies and other costs needed to operate the equipment (assuming 5,000 procedures are conducted). When SJMC purchased the…arrow_forwardAssume that Whee, Cheatham, and Howe is an auditing firm that has found that its summer interns are subject to a 90 percent learning curve for one of its important tasks, proofreading financial statements. For one of its interns, Kim Down, the firm has started to analyze the relation between time and financial statement proofreading. Financial StatementsProofread (X) Time Required to Proofreadthe Xth Financial Statement 1 2.0 hours 2 1.8 hours 4 ? 8 ? 16 ? Required: a. Compute the time required to proofread 4, 8, and 16 financial statements.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 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
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
GE McKinsey Matrix for SBU Strategies; Author: Wolters World;https://www.youtube.com/watch?v=FffD1Ze76JQ;License: Standard Youtube License