Managerial Accounting (5th Edition)
5th Edition
ISBN: 9780134128528
Author: Karen W. Braun, Wendy M. Tietz
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Question
Chapter 6, Problem 6.53BE
1.
To determine
To provide: The regression analysis of the given data.
2.
To determine
The cost equation of the company RHC.
3.
To determine
The R-square (by using the output from the Excel regression) and the result indicated by the R-square.
4.
To determine
To find: The total laboratory overhead for the month if 2,800 lab tests are performed.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
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
TASK A. Problem Solving. Analyze the given problem and perform the required tasks in
the worksheet provided.
1. A hospital has P250,000 expected utility bill this year. The janitorial, accounting, and
orderlies departments are service departments servicing the operating, hospital rooms,
and laboratories departments. Floor spaces assigned to each department are as follows
Department
Square Footage
Janitorial
Accounting
Orderlies
1,000
2,000
7,000
Operating
Hospital rooms
Laboratories
4,000
30,000
6,000
How much of the P200,000 will eventually become the hospital rooms department's total
costs, assuming a direct allocation based in square footage is used?
2. The Laptop complex, which offers two main services: 1) time on a time-shared computer
and (2) propriety computer programs. Computer time is provided by the Operating
Department (OD), and programs are written by the programming Department(PD).
Usually, the Operating Department spends P 9,000 and the Programming Departmemnt
spends…
profile-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.
Chapter 6 Solutions
Managerial Accounting (5th Edition)
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
- 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?arrow_forward7/26/2021 Content The hospital where you are employed is continuing with their analysis with the goal of opening a walk- in clinic. After conducting additional research, the financial projections for the first year of operations are as follows: • Revenues (from 10,000 visits): $400,000 Wages and benefits: $220,000 • Rent: $5,000 Depreciation: $30,000 Utilities: $2,500 • Medical supplies: $50,000 Administrative supplies: $10,000 Assume that all costs are fixed except supply costs, which are variable. Assume that the clinic will be required to pay taxes at a 30% tax rate. Respond to the following questions. Be sure to show your work for all calculations. 1. Prepare the clinic's projected Profit and Loss (P&L) Statement. (8 points) 2. What number of visits is required to break even? (3 points) 3. What number of visits is required to provide you with an after-tax profit of $100,000? (4 points)arrow_forwardLackawanna Community College has three divisions: Liberal Arts, Sciences, and Business Administration. The college's comptroller is trying to decide how to allocate the costs of the Admissions Department, the Registrar's Department, and the Computer Services Department. The comptroller has compiled the following data for the year just ended. Department Admissions Registrar Computer Services Division Liberal Arts Sciences Business Administration Required 1 Annual Cost $119,000 199,000 424,000 Required 2 Budgeted Enrollment 1,200 900 800 Required: 1. Distribute the departmental costs to the college's three divisions based on the allocation base given. 2. Choose the better allocation base for distributing the cost to the following departments: Registrar Computer Services Complete this question by entering your answers in the tabs below. Budgeted Credit Hours 32,000 29,550 23,500 Planned Courses Requiring Computer Work 12 26 26 Choose the better allocation base for distributing the cost to…arrow_forward
- appear below: Instructor wages Classroom supplies Utilities Campus rent Insurance Administrative expenses Fixed Cost Cost per Cost per per Month Course $ 2,930 Student $ 270 $ 80 $ 1,220 $ 5,100 $ 2,400 $ 3,600 $ 40 $ 3 For example, administrative expenses should be $3,600 per month plus $40 per course plus $3 per student. The company's sales should average $890 per student. The company planned to run four courses with a total of 64 students; however, it actually ran four courses with a total of only 62 students. The actual operating results for September appear below: Revenue Instructor wages Classroom supplies Utilities Campus rent Insurance Administrative expenses Required: Actual $ 54,060 $ 11,000 $1,950, $ 17,130 $ 5,100 $ 2,540 $ 3,378 1. Prepare the company's planning budget for September. 2. Prepare the company's flexible budget for September. 3. Calculate the revenue and spending variances for September.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_forwardA company uses charging rates to allocate service department costs to the using departments. The accountant compiled the following information on one of the service departments: If Department K plans to use 1,350 hours of the service departments service in the coming year, how much of the service departments cost is allocated to Department K? a. 3,375 b. 27,300 c. 26,325 d. 23,950arrow_forward
- The actual and planned data for Broadwater Institute & Technical School for the Fall term were as follows: Enrollment Tuition per credit hour Credit hours cost. Line Item Description Revenue Variable costs: Registration, records, and marketing costs per enrolled student Instructional costs per credit hour Depreciation on classrooms and equipment $1,875,000 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 Registration, records, and marketing costs $ Instructional costs Total variable costs Amount Contribution margin Depreciation on classrooms and equipment Operating income Actual Prepare a variable costing income statement showing the contribution margin and operating income for the Fall term. Broadwater Institute & Technical School Variable Costing Income Statement For the Fall Term 5,000 $115 $ $ 80,000 $300 $45 Planned 4,500 $100 72,000 $300 $40 $1,875,000arrow_forwardThe Hospital La Salud forthe following data on electricity costs and the number of patients per month of the last year for you to develop a cost function. Electricity costs $5,500 5,800 Patients 1,836 2,100 2,914 1,258 1,025 1,416 2,965 2,692 1,038 Months January Feb 6,200 4,325 4,025 4,445 6,500 5,890 3,900 3,700 3,990 4,998 Sea April May Jun Jul Aug Setp Oct 950 Nov 1,100 Dec 1,564 Requirements: 1. Using the High Low Method determine the FIXED COST AND VARIABLE COST 2. EXPRESS THE COST FUNCTION SUPPOSE FOR THE FIRST TRIMESTRE OF THE ANUS, YOU HAVE PROJECTED THE FOLLOWING NUMBERS OF PATIENTS: January 2,985/ Feb 3,250/ March 4,950 Present the total cost for each projected month. 3. 4. Present the above using the DATA ANALYSIS TOOL in EXELarrow_forwardSt. Johns Medical Center (SJMC) has five medical technicians who are responsible for conducting cardiac catheterization testing in SJMCs 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 equipments 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 technicians report with the outside physicians 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 equipment, it fully expected to perform 5,000 procedures per year. In fact, during its first year of operation, 5,000 procedures were run. However, a larger hospital has established a clinic in the city and will siphon off some of SJMCs business. During the coming years, SJMC expects to run only 4,200 cath procedures yearly. SJMC has been charging 850 for the procedureenough to cover the direct costs of the procedure plus an assignment of general overhead (e.g., depreciation on the hospital building, lighting and heating, and janitorial services). At the beginning of the second year, an HMO from a neighboring community approached SJMC and offered to send its clients to SJMC for cardiac catheterization provided that the charge per procedure would be 550. The HMO estimates that it can provide about 500 patients per year. The HMO has indicated that the arrangement is temporaryfor one year only. The HMO expects to have its own testing capabilities within one year. Required: 1. Classify the resources associated with the cardiac catheterization activity into one of the following: (1) committed resources, or (2) flexible resources. 2. Calculate the activity rate for the cardiac catheterization activity. Break the activity rate into fixed and variable components. Now, classify each activity resource as relevant or irrelevant with respect to the following alternatives: (1) accept the HMO offer, or (2) reject the HMO offer. Explain your reasoning. 3. Assume that SJMC will accept the HMO offer if it reduces the hospitals operating costs. Should the HMO offer be accepted? 4. Jerold Bosserman, SJMCs hospital controller, argued against accepting the HMOs offer. Instead, he argued that the hospital should be increasing the charge per procedure rather than accepting business that doesnt even cover full costs. He also was concerned about local physician reaction if word got out that the HMO was receiving procedures for 550. Discuss the merits of Jerolds position. Include in your discussion an assessment of the price increase that would be needed if the objective is to maintain total revenues from cardiac catheterizations experienced in the first year of operation. 5. Chandra Denton, SJMCs administrator, has been informed that one of the Cath Lab technicians is leaving for an opportunity at a larger hospital. She met with the other technicians, and they agreed to increase their hours to pick up the slack so that SJMC wont need to hire another technician. By working a couple hours extra every week, each remaining technician can perform 1,050 procedures per year. They agreed to do this for an increase in salary of 2,000 per year. How does this outcome affect the analysis of the HMO offer? 6. Assuming that SJMC wants to bring in the same revenues earned in the cardiac catheterization activitys first year less the reduction in resource spending attributable to using only four technicians, how much must SJMC charge for a procedure?arrow_forward
- 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_forwardLackawanna Community College has three divisions: Liberal Arts, Sciences, and Business Administration. The college's comptroller is trying to decide how to allocate the costs of the Admissions Department, the Registrar's Department, and the Computer Services Department. The comptroller has compiled the following data for the year just ended. Annual Cost Department Admissions Registrar Computer Services $130, 000 221,000 468,000 Planned Courses Budgeted Budgeted Credit Hours Requiring Computer Work Division Enrollment Liberal Arts Sciences 2,300 43,000 37,750 31,750 25 1,450 37 Business Administration 1,350 37 Required: 1. Distribute the departmental costs to the college's three divisions based on the allocation base given. 2. Choose the better allocation base for distributing the cost to the following departments: Complete this question by entering your answers in the tabs below. Required 1 Required 2 Prev 1 of 7 Next > huluarrow_forwardLackawanna Community College has three divisions: Liberal Arts, Sciences, and Business Administration. The college's comptroller is trying to decide how to allocate the costs of the Admissions Department, the Registrar's Department, and the Computer Services Department. The comptroller has compiled the following data for the year just ended. Department Admissions Registrar Computer Services Division Liberal Arts Annual Cost $136,000 233,000 492,000 Sciences Business Administration Budgeted Budgeted Enrollment Credit Hours 2,900 1,750 1,650 49,000 42,250 36,250 Required: 1. Distribute the departmental costs to the college's three divisions based on the allocation base given. 2. Choose the better allocation base for distributing the cost to the following departments: Department and Allocation Base Planned Courses Requiring Computer Work Complete this question by entering your answers in the tabs below. Admissions (enrollment) Registrar (credit hours) Computer Services (courses requiring…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 LearningFinancial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
- 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
Financial And Managerial Accounting
Accounting
ISBN:9781337902663
Author:WARREN, Carl S.
Publisher:Cengage Learning,
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
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