Question
Need help solving Requirement 6 where "the total predicted hospital overhead, when $25000 nursing hours are predicted for the month is...?"
Regression analysis using nursing hours SUMMARY OUTPUT - Nursing hours as cost driver Regression Statistics Multiple R 098489
* Data Table - X Month July August September October November December Hospital Overhead Costs 476,000 512,000 424,000 448.00
Requirement 5. Use the high-low method to determine the hospitals cost equation using nursing hours as the cost driver Predi
0 0
Add a comment Improve this question Transcribed image text
Answer #1

6.
Total Cost as per regression analysis = $131004.69 + $14.26 x Nursing hours

Total cost for 25000 nursing hours = $131004.69 + $14.26 x 25000 = $487504.69

Add a comment
Know the answer?
Add Answer to:
Need help solving Requirement 6 where "the total predicted hospital overhead, when $25000 nursing hours are...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • A hospital is analyzing its overhead costs. It is not clear whether the number of patient...

    A hospital is analyzing its overhead costs. It is not clear whether the number of patient days or nursing hours would be the best cost driver to use in predicting the hospital’s overhead. The latest information on the hospital is as follows: Month              Hospital           Nursing                        No. of              Overhead         Overhead Cost                         Overhead         Hours               Patient              Cost Per           Per Patient                         Costs                                        Days                Nursing Hr.      Day July                  $950,000         50,000             7,900               $19.00             $120.25 August            $1,070,000       52,000             8,900               $20.58             $120.22...

  • A hospital is analyzing its overhead costs. It is not clear whether the number of patient...

    A hospital is analyzing its overhead costs. It is not clear whether the number of patient days or nursing hours would be the best cost driver to use in predicting the hospital’s overhead. The latest information on the hospital is as follows: Month              Hospital           Nursing                        No. of              Overhead         Overhead Cost                         Overhead         Hours               Patient              Cost Per           Per Patient                         Costs                                        Days                Nursing Hr.      Day July                  $950,000         50,000             7,900               $19.00             $120.25 August            $1,070,000       52,000             8,900               $20.58             $120.22...

  • Need help with 2a, 2b, 2c please. Always show your work when doing fun&exciting exercises! Box...

    Need help with 2a, 2b, 2c please. Always show your work when doing fun&exciting exercises! Box or circle final answers! Question 1) Apollo Hospital specializes in outpatient surgeries for relatively minor procedures. Apollo is a nonprofit institution and places great emphasis on controlling costs in order to provide services to the community in an efficient manner Apollo's CFO, Julie Chen, has been concerned of late about the hospital's consumption of medical supplies. To better understand the behavior of this cost,...

  • McKnight Industries is in the process of analyzing its manufacturing overhead costs. McKnight Industries is not...

    McKnight Industries is in the process of analyzing its manufacturing overhead costs. McKnight Industries is not sure if the number of units produced or number of direct labour hours is the best cost driver to use for predicting manufacturing overhead costs. 1. Use Excel regression analysis to determine Mcknight Industries' manufacturing overhead cost equation using DL hours as the cost driver. Comment on the R-square. Estimate MOH costs if Mcknight Industries incurs 26,100 DL hours in January 2. Use Excel...

  • my professor just wants part A answered Aridge Business Publishers Module 15 Cost Behavior, Activity Analysis,...

    my professor just wants part A answered Aridge Business Publishers Module 15 Cost Behavior, Activity Analysis, and Cost Estimation Month Total Costs January February March April May Sales (Dozens) 6,800 7,800 5,500 1,000 6,100 4,500 $30,650 35,336 29,700 25,000 30,600 28,670 June Required 4. Using the high-low method, develop a cost-estimating equation for total monthly costs. b. 1. Plot the equation developed in requirement (a). 2. Using the same graph, develop a scatter diagram of all observations for the cookie...

  • Need help with 1A 1B 1C BUS2102-Spring 2019-Chapter 3 Fun & Exciting Exercises Always show your...

    Need help with 1A 1B 1C BUS2102-Spring 2019-Chapter 3 Fun & Exciting Exercises Always show your work when doing fun &exciting exercises! Box or circle final answers! Question 1) Apollo Hospital specializes in outpatient surgeries for relatively minor procedures. Apollo is a nonprofit institution and places great emphasis on controlling costs in order to provide services to the community in an efficient manner Apollo's CFO, Julie Chen, has been concerned of late about the hospital's consumption of medical supplies. To...

  • Question 2 - Selecting a cost driver Iggy Hospital is a small animal hospital that specializes...

    Question 2 - Selecting a cost driver Iggy Hospital is a small animal hospital that specializes in minor surgeries. Timmy Snyder, Iggy's CEO, Is concerned about the hospital's consumption of medical supplies. Timmy asks Tommy Poon, Iggy's CFO, to better understand the behavior of this cost. Tommy believes that there are two potential cost drivers for the hospital's medical supplies costs - the total number of procedures performed and the number of patient-hours generated by Iggy. Tommy has collected the...

  • I need help finding the assigned overhead. Waterway Company uses a job order cost system and...

    I need help finding the assigned overhead. Waterway Company uses a job order cost system and applies overhead to production on the basis of direct labor costs. On January 1.2020. Job 50 was the only job in process. The costs incurred prior to January 1 on this job were as follows: direct materials $25.000, direct labor $15.000, and manufacturing overhead $20.000. As of January 1, Job 49 had been completed at a cost of $112.500 and was part of finished...

  • 1. Compute the total overhead allocated to each job under a simple costing​ system, where overhead...

    1. Compute the total overhead allocated to each job under a simple costing​ system, where overhead is allocated based on​ machine-hours. 2. Compute the total overhead allocated to each job under an​ activity-based costing system using the appropriate activity drivers. 3. Explain why Shirley's Custom Framing might favor the ABC​ job-costing system over the simple​ job-costing system, especially in its bidding process. *There should be 10 total parts to this problem. The job-costing system at Shirley's Custom Framing has five...

  • Question Help E6-34A (similar to) Meyer Company, which uses the high-low method to analyze cost behavior,...

    Question Help E6-34A (similar to) Meyer Company, which uses the high-low method to analyze cost behavior, has determined that machine hours best predict the company's totale s cost. The company's cost and machine hour usage data fort first six months of the year follow (Click the loon to view the data) Requirements Using the high-low method, answer the following questions 1. What is the variable its cost per machine hour? 2. What is the red cost of its each month?...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT