Using the high-low method to predict
Refer to the laboratory overhead cost and activity data for Elmhurst Health Center in E6-29A. Use the high-low method to determine the laboratory’s cost equation for total laboratory overhead. Use your results to predict total laboratory overhead if 3,100 lab tests are performed next month.
The manager of the main laboratory facility at Elmhurst Health Center is interested in being able to predict the overhead costs each month for the lab. The manager believes that total overhead varies with the number of lab tests performed but that some costs remain the same each month regardless of the number of lab tests performed.
The lab manager collected the following data for the first seven months of the year:
Month | Number of Lab Tests Performed | Total Laboratory Overhead Costs |
January | 3,000 | $21,900 |
February | 2,850 | $20,600 |
March | 3,400 | $28,900 |
April | 3,700 | $31,000 |
May | 3,900 | $28,000 |
June | 1,900 | $20,200 |
July | 2,050 | $14,000 |
Trending nowThis is a popular solution!
Chapter 6 Solutions
Managerial Accounting (5th Edition)
- 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_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_forwardSara has just taken a job as the middle school assistant principal for an area school district. Prior to Chis, she was a teacher. She has received the following performance measurements for her first administrative job. Her first order of business is to determine if these performance measurements are short-term goals or long-term goals based on her individual situation. She has completed her administrative degree but has not yet worked as an administrator. Identify each of the following goals as short term or long term. A. Conduct teacher walk-throughs/observations/evaluations for teachers of grades 6 and 7. B. Assist the districts mission in seeking to educate all youth in the school district. C. Train to become a building instructional leader. Act as building administrator in the absence of the principal. D. Attend meetings with building principals and the administrative team when called to do so. E. Engage all students in a meaningful way, and support teachers and staff in providing rigor and relevance. Success of school-wide discipline and attendance policies and enforcement depends on a combination of creativity and sound pedagogy while adhering to district, state, and federal law, guidelines, and regulations. F. Facilitate and supervise all federal- and state-mandated drills (fire, lockdowns, tornado, others). G. Dress professionally. H. Assist the building principal in all job duties and responsibilities.arrow_forward
- The 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_forwardexample paper for this weeks individual project This list contains costs that various organizations incur; they fall into three categories: direct materials (DM), direct labor (DL), or overhead (OH). Classify each of these items as direct materials, direct labor, or overhead, and provide the rationale for your classification decision. Glue used to attach labels to bottles containing a patented medicine. Compressed air used in operating paint sprayers for Student Painters, a company that paints houses and apartments. Insurance on a factory building and equipment. A production department supervisor’s salary. Rent on factory machinery. Iron ore in a steel mill. Oil, gasoline, and grease for forklift trucks in a manufacturing company’s warehouse. Services of painters in building construction. Cutting oils used in machining operations. Cost of paper towels in a factory employees’ washroom. Payroll taxes and fringe benefits related to direct labor. The plant electricians’ salaries. Crude…arrow_forwardPlease 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.…arrow_forward
- Burgess Business School has two degree programs, BBA and MBA. The school uses an ABC system to cost the three support services it provides to students from both programs: Career Center, Events, and Library. Following are the costs of these three activities and the cost drivers used in the system: Activity Cost Activity Career Center Event planning and hosting. Library For the most recent year, data collected from the central IT systems indicate the following: MBA 5,600 4,500 30,300 BBA 10,400 5,500 70,700 $ 448,000 440,000 606,000 Cost Driver Interview-hours Event attendance Number of visits Interview-hours Event attendance Library visits Required: a. Compute the cost-driver rates for the three activities at the school. b. Suppose that in a future period, no students from the MBA program visited the Library. What amount of the Library cost would be assigned to the MBA program?arrow_forwardWhich of the following will give you the most accurate allocation between a cost's fixed component and variable component? a. Examination of a students’ registration forms for miscellaneous fees and tuition fees b. Use of the least squares method to allocate the cost of electricity c. Dividing the total cost on the water bill among the different departments based on direct labor hours d. Dividing the total cost of the postpaid plan using the high-low methodarrow_forward4. The administrator of ABC Hospital would like to know the relationship between the costs of admitting in relation to the number of patients being admitted and determine the cost formula. The following are the related data for the past five months that will be used determine such cost formula.Month |# of Patients Admitted |Admitting CostsJanuary 1,800 P 14,700February 1,900 P 15,200March 1,700 P 13,700April 1,600 P 14,000May 1,500 P 14,300The controller suggested to use the high-low method approach to derive for the cost formula. If the controller’s suggestion is to be followed:What would be the prediction formula/cost formula?arrow_forward
- 2. The administrator of ABC Hospital would like to know the relationship between the costs of admitting in relation to the number of patients being admitted and determine the cost formula. The following are the related data for the past five months that will be used determine such cost formula.Month | # of Patients Admitted |Admitting CostsJanuary 1,800 P 14,700February 1,900 P 15,200March 1,700 P 13,700April 1,600 P 14,000May 1,500 P 14,300The controller suggested to use the high-low method approach to derive for the cost formula. If the controller’s suggestion is to be followed:How much would be the total fixed costs?arrow_forwardFriendly Bank is attempting to determine the cost behavior of its small business lending operations. One of the major activities is the application activity. Two possible activity drivers have been mentioned: application hours (number of hours to complete the application) and number of applications. The bank controller has accumulated the following data for the setup activity: Required: 1. Estimate a regression equation with application hours as the activity driver and the only independent variable. If the bank forecasts 2,600 application hours for the next month, what will be the budgeted application cost? 2. Estimate a regression equation with number of applications as the activity driver and the only independent variable. If the bank forecasts 80 applications for the next month, what will be the budgeted application cost? 3. Which of the two regression equations do you think does a better job of predicting application costs? Explain. 4. Run a multiple regression to determine the cost equation using both activity drivers. What are the budgeted application costs for 2,600 application hours and 80 applications?arrow_forwardLearning curve, cumulative average-time learning model. Northern Defense manufactures radar systems. It has just completed the manufacture of its first newly designed system, RS-32. Manufacturing data for the RS-32 follow: Calculate the total variable costs of producing 2, 4, and 8 units.arrow_forward
- 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 CollegeEssentials of Business Analytics (MindTap Course ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage Learning