Determine fixed and variable components of admitting costs

Assignment Help Financial Management

Reference no: EM131891482

Budgeting & Finance - healthcare please provide formulas(s) as work needs to be transferred to excel.

Cost Behavior: Problem 5

The Cardiology Department has provided you with the following data in its annual report:

Month Number of EKGS Costs

January...................... 175 $3,000

February.................... 225 3,600

March......................... 275 4,300

April............................ 175 3,800

May............................ 200 2,700

June........................... 225 3,200

July............................ 300 4,250

August........................ 325 4,400

September................. 275 4,100

October...................... 200 3,150

November.................. 150 2,650

December.................. 175 2,750

1. Use the scattergraph method to determine the fixed and variable components of admitting costs. Use Excel or Sheets to show your work.

2. Use the sheet function to show the equation. Determine r2. Be sure to explain your findings in term of the fixed and variable cost. Interpret the r2.

Reference no: EM131891482

Questions Cloud

Effective must be paid at the end of each year : On a loan of $10,000 interest at 9% effective must be paid at the end of each year.

Valuation method that uses only terminal flow to investors : A valuation method that uses only a terminal flow to investors. Financing provided in sequences of rounds instead of all at once

What is the approximate duration of ten-year : What is the approximate duration of a 10-year, 7% coupon bond with annual coupons, a par value of $1,000 and a yield of 4%.

What is the bond price if the real inflation rate : What is the bond price if the real inflation rate is 2.863%?

Determine fixed and variable components of admitting costs : Use the scattergraph method to determine the fixed and variable components of admitting costs.

The risk free rate of return : The risk free rate of return is 4.87% and the market has a standard deviation of 10.8 percent (0.108) while a risky security has a standard deviation of 22.5%

Standard deviation and coefficient of variation : Compute each stock’s average return, standard deviation, and coefficient of variation.

Learning disabilities diagnostic work-ups : How much profit will the clinic make in the first year if they can schedule 10 patients per day (50 per week) for learning disabilities diagnostic work-ups?

Why are large portfolios less risky than individual stocks : Why are large portfolios less risky than individual stocks? What is the fund’s overall, or weighted average, beta? What is the expected return of AEP stock?

User Account

All Pages