Finance for Healthcare

profileVLayne

!0 question worksheet...

 

David Jones, the new administrator for a surgical clinic, was trying to determine how to allocate his indirect expenses. His staff was complaining that the current method of taking a percentage of revenues was unfair. He decided to try to allocate utilities based on square footage of each department, administration based on direct costs, and laboratory based on tests. Use the information in the chart below to answer problems 22, 23 and 24.

 

 

 

 

Square Footage

Direct

Expenses

Lab Tests

Utilities

 

$200,000

 

Administration

2,000

500,000

 

Laboratory

2,000

625,000

 

Day-op Suite

3,000

1,400,000

4,000

Cystoscopy

1,500

300,000

500

Endoscopy

1,500

600,000

500

Total

10,000

$3,375,000

5,000

 

 

 

1.     What are the Day Op Suite’s total expenses?

 

 

 

2.     What are the Cystoscopy Department’s total expenses?

 

 

 

3.     What are the Endoscopy Department’s total expenses?

 

 

 

 

 

 

 

Use the following information for questions 4, 5, and 6.

 

 

 

Your hospital has been approached by a major HMO to perform all their MS-DRG 470 cases (major joint procedures). They have offered a flat price of $10,000 per case. You have reviewed your charges for MS-DRG 470 during the last year and found the following profile:

 

 

 

Average Charge      $15,000

 

Average LOS          5 Days

 

                                                            Cost/ChargeVariable Cost %

 

Routine Charge         $3,600              0.80                60

 

 


             Operating Room       2,657              0.80                80

 

             Anesthesiology            293              0.80                80

 

             Lab                          1,035              0.70                30

 

             Radiology                    345              0.75                50

 

             Medical Supplies      4,524              0.50                90

 

             Pharmacy                1,230              0.50                90

 

             Other Ancillary         1,316              0.80                60

 

          Total Ancillary          $11,400              0.75                50

 

 

 

4.     In the above data set, assume that the hospital’s cost to charge ratio is 0.80 for routine services and 0.75 for all other ancillary services. Using this information, what would the average cost of MS-DRG 470 be?

 

 

 

5.     Estimate the variable cost per MS-DRG 470 using the departmental cost/charge ratios and variable cost percentages.

 

 

 

6.     The HMO in the above example has indicated that their doctors use less expensive joint implants. If this less expensive implant is used, your medical supply charges would be reduced by $2,000. What is the estimated reduction in variable cost?                

 

 

 

 

 

 

 

Use the following information for problems 7, 8, and 9.

 

 

 

You have been asked to establish a pricing structure for radiology on a per-procedure basis. Present budgetary data is presented below:

 

 

 

Budgeted Procedures   10,000

 

Budgeted Cost         $400,000

 

Desired Profit             $80,000

 

 

 

It is estimated that Medicare patients comprise 40 percent of total radiology volume and will pay on average $38.00 per procedure. Approximately 10 percent of the patients are cost payers. The remaining charge payers are summarized below:

 

 

 

                  Payer         Volume %     Discount %

 

                         Blue Cross          20                  4

 

                         Unity PPO           15                10

 

                         Kaiser                 10                10

 

                         Self Pay                5                40

 

                                                   50%

 

 

 

7.     What rate must be set to generate the required $80,000 in profit in the preceding example?

 

 

 

 

 

8.     If the forecasted volume increased to 12,000 procedures and budgeted costs increased to $440,000, while all other variables remained constant, what price should be established?

 

 

 

 

 

9.     Assume that the only change in the original example data is that Blue Cross raises their discount to 20 percent. What price should be set?

 

 

 

 

 

10.Calculate the breakeven price from the following information.

 

quantity of services = 3,000

 

fixed costs = $45,000

 

average cost per unit = $150.00

 

required profit = $30,000

 

 

 

 

 

  • 6 years ago
  • 5
Answer(2)

Purchase the answer to view it

NOT RATED
  • attachment
    david_jones_the_new_administrator_for_a_surgical_clinic_was_trying_to_determine_how_to_allocate_his_indirect_expenses..xls
  • attachment
    hs440_finance_for_healthcare_unit_7_assignment_-david_jones_the_new_administrator_for_a_surgical_clinic_was_trying_to_determine_how_to_allocate_his_indirect_expenses.doc

Purchase the answer to view it

NOT RATED
  • attachment
    part1.xlsx
  • attachment
    part2.xlsx
  • attachment
    part3.xlsx
Bids(0)