Health Services Resource Management Assignment
Question 1: A hospital is expecting to have $25,000 cash in hand on 1st April 2015 and it requires you to prepare an estimate of cash position in respect of three months from April to June 2015, from the information given below:
Patient services Purchases Wages Expenses
February 70,000 40,000 8,000 6,000
March 80,000 50,000 8,000 7,000
April 92,000 52,000 9,000 7,000
May 100,000 60,000 10,000 8,000
June 120,000 55,000 12,000 9,000
Additional Information:
(a) The hospital pays for purchases two months after the purchase.
(b) 25% of patients pay in cash in the month they receive their treatment and the others pay in the following month.
(c) Both wages and expenses are paid in the following month in which they are incurred.
(d) Income Tax of $25,000 is to be paid in June 2015.
Required:
1. Prepare a cash budget for April, May and June and also for the 3 months to 30 June.
2. Are there any changes you can suggest to improve this hospital's cash flow?
Question 2: The Dandenong Hospital is considering purchasing two independent pieces of medical equipment having the following cash flow streams:
Year Machine A Machine B
0 -$50,000 -$40,000
1 +20,000 +20,000
2 +20,000 +10,000
3 +10,000 +5,000
4 +5,000 +40,000
5 +5,000 +40,000
The Hospital uses a combination of the net present value approach and the payback approach to evaluate its equipment purchases. It requires that all equipment have a positive net present value when cash flows are discounted at 10 percent and that they have a payback period no longer than 3 years. Which machine or machines should the Hospital buy? Why?
Question3: A hospital has a choice between two mutually exclusive alternatives, each requiring an initial outlay of $25,000. Machine A promises cash flows of $2,000 the first year; $2,000 the second year; and $35,000 the third year. Machine B offers $21,000 the first year; $10,000 the second year; and $2,000 the third year. The required rate of return is 8%. Calculate the NPV and the IRR for each machine. Which of these two mutually exclusive alternatives should be accepted?
Question 4: The Prince Alfred Hospital's projected revenue and costs for the 2015 financial year - ending 30 June - are as follows:
Projected revenues and costs by patient services departments:
Revenues Costs (direct)
Routine care $30 million $15million
Laboratory $10 million $8 million
Radiology $6 million $3 million
Overhead costs from the support departments in the Hospital are:
Financial services $3 million
Maintenance $5 million
Housekeeping $2 million
Administration $4 million
Personnel $4 million
The agreed cost drivers for the support departments are:
Financial Services patient revenue
Maintenance space utilisation
Housekeeping labour hours
Administration salary dollars
Personnel salary dollars
The following information relates to the patient services departments:
|
Department
|
Space utilisation
|
Labour hours
|
Salary dollars
|
|
Routine care
|
199,800 sq.m.
|
76,000
|
$10 million
|
|
Laboratory
|
39,600 sq.m.
|
6,000
|
$3 million
|
|
Radiology
|
61,200 sq.m.
|
9,000
|
$2 million
|
|
Total
|
300,600
|
91,000
|
$15 million
|
1. What is the Hospital's projected profit or loss for the year?
2. Allocate indirect costs to the patient services departments on the basis of the cost drivers specified.
3. Do you think that the allocation method used was appropriate? Explain why or why not?
4. Are all the patient services departments profitable? If not, should they be closed down?
Question 5: It is now May and you have been asked to do a budget for The Flu Shot clinicas the flu season will soon begin. The clinic will operate for the months of June and July. As the hospital has no spare space it will rent a room in a nearby shopping centre for the clinic. The clinic will also employ a nurse to give the injections and a receptionist to assist with arranging interviews. Vaccines cost $10 per patient. In addition, the clinic will give each patient either regular or glow-in-the-dark band aids. A regular band aid is budgeted at $1, while aglow-in-the-dark band aid is budgeted at $2. Children always request glow-in-the-dark band aids. It is anticipated that the clinic will receive $40 for each child and $30 for each adult. During last year's flu season, the department saw 400 adults and 700 children each month and operated for 2 months.
The nurse is paid $5 per child and $3 per adult and the receptionist is paid $500 per month. Rent and utilities are $300 per month.
a. Using this information do a budget for the clinic for June and July.
b. The actual results for this clinic are shown below. Management want to know why the budgeted result and actual results for each month are different. Do a budget variance analysis for each month to identify what caused the actual and budgeted amounts to be different. You are told that in June the clinic actually saw 500 adults and 900 children, and in July the clinic saw 200 adults and 500 children.
c. Write a brief report to your manager summarising your findings and give recommendations for how to prepare the budget for next year.