Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.

Get a Professional Answer

Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.

100% Satisfaction Guarantee

Rate the answer you receive.

Ask R.R. Jha Your Own Question

R.R. Jha, Tutor

Category: Homework

Satisfied Customers: 5471

Experience: B.Tech

20870358

Type Your Homework Question Here...

R.R. Jha is online now

1. Use the high-low method to estimate the cost behavior for

This answer was rated:

★★★★★

1. Use the high-low method to estimate the cost behavior for the clinic’s administrative costs. Express the cost behavior in formula form (Y=a + bX). What is the variable cost per patient? 2. Build spreadsheet: Construct an Excel spreadsheet and use the Excel commands to perform a least-squares regression and estimate the administrative cost behavior. Express the cost behavior in formula form. What is the variable cost per patient? Compute and interpret the R2 value for the regression. 3. Write a memo to the hospital administrator comparing the cost estimates using (a) least squares regression, (b) the high-low method, and (c) the scatter diagram and visually fit semi variable-cost line from the preceding case (requirement (4)). Make a recommendation as to which estimate should be used, and support your recommendation. Make any other suggestions you feel are appropriate.