Description
1)write the answer for problem 9 and 12 in Excel doc but make sure to use the format for them (the answer is ready in the pictures but make sure if need to add something and their something blank please complete it)2) u need to read the question for problem 1 then do it by yourself and use the right format form prob 1.
Unformatted Attachment Preview
Chapter 5
Problem 2
FY: 7/1/X1 – 6/30/X2
OUTPUT REQUIRED
WORKERS REQUIRED
Patient days
Hours/patient day
Total hours required
Worker’s hours/year
Total hours required
PRODUCTIVE RATE
FTEs NEEDED
OR
SALARY BUDGET WORKSHEET
FY begins
NAME
King
Law
Rogers
Ruby
Russell
Vacant positions
TOTAL
FY ends
06/30/X0
06/30/X2
or 07/01/X0
05/01/X1
07/01/X1
05/01/X2 or 07/01/X2
|———————————\—————||———————————————————————————|
1ST
2ND
RATE
RATE
SALARY
FTE
RATES @ INCREASE RATES @
BASE
INCREASE INCREASE SALARY
VALUE
04/01/X1
05/01/X1
07/01/X1 SALARY 05/01/X2
05/01/X2 BUDGET
Chapter 5
Problem 9
Base Year
(6 months)
Budget
Year
Patient days
Outpatient visits
Inpatient tests
Patient days
= ?tests/patient day
Inpatient tests
Outpatient tests
Outpatient tests
Outpatient visits
= ? tests/outpatient visits
Chapter 5
Problem 12
MAXIMUM
MAXIMUM
CAPACITY/ TREATMENT
NUMBER OF
YEAR
/MONTH
MONTHS/YEAR
RVUs/
TREATMENT
RVUs/YEAR
% INCREASE
INCREASE
19X1
19X2
19X3
19×4
19×5
19×6
19×7
19×7
ANNUAL GROWTH
19×8
which is greater than the maximum capacity. What should this lab do?
MAXIMUM
MAXIMUM
CAPACITY/ TREATMENT
NUMBER OF
YEAR
/MONTH
MONTHS/YEAR
RVUs/
TREATMENT
Chapter 5
Problem 1
FY: 7/1/X1 – 6/30/X2
Patient days
Hours/patient day
Total hours required
OUTPUT REQUIRED
Total hours required Worker’s hours/year
WORKERS REQUIRED
PRODUCTIVE RATE
FTEs NEEDED
OR
SALARY BUDGET WORKSHEET
FY begins
NAME
Abelein
Brenchley
Brownstein
Colson
Cottingham
Cyr
Vacant positions
TOTAL
06/30/X0
or 07/01/X0
05/01/X1 07/01/X1
05/01/X2
|————– ————— \————- |————– ————— ————— \————1ST
2ND
RATE
RATE
BASE INCREASEINCREASE
FTE
RATES @ INCREASE RATES @
VALUE
11/04/X0 05/01/X1 07/01/X1 SALARY 05/01/X2 05/01/X2
FY ends
06/30/X2
or 07/01/X2
—————-|
SALARY
BUDGET
Your large urban hospital is considering the possibility of transferring the capacity for 30,000 ambulatory care visits from
the hospital’s outpatient department (OPD) to free-standing clinics.
Average costs of care in free-standing clinics are lower than in OPDs. But more important, evidence suggests that in urban
areas, in patient utilization and to tal visits decrease when ambulatory care is moved to a free-standing setting.
Conservative estimates are that inpatient utilization will drop by 10 percent and that ambulatory utilization will drop by 5
percent
Estimate the benefits (savings) and costs of this initiative. The following provide all of the information you need to know to
do the analysis. You should assess savings and costs in both the short run and long run. In the short run, only variable
costs of hospital and OPD care can be saved; fixed costs can be eliminated only in the long run.
Required information:
(1) Number of visits transferred: 30,000
(2) Number of people transferred: 6,000
(3) Current average inpatient days per person: 1.1
(4) Current average ambulatory visits per person: 5.0
(5) Average cost per day–inpatient: $500
(6) Percentage variable cost-inpatient: 30%
(7) Average revenue per day-in patient: $450
(8) Average cost per visit-OPD: $70
(9) Percentage variable cost-OPD: 40%
1 Chapter 5
2 Problem 9
3
Base Year
16 months
Budget
Year
Patient days
3 Outpatient visits
150,000
100,000
250,00
210,000
Inpatient tests
Patient days
10 Inpatient tests
11 Outpatient tests
450.000 – 3 tests/patient day
150,000
450,000
400,000
750,000
340,000
Outpatient tests
Outpatient visits
400,000 – tests/outpatient visits
100,000
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
Sheet
Sheet
Sheet2
Sheet
Sheet
Sheets Shorts Sheet
She
Condition
Chapter
2 Problem 12
um
MAXIMUM MAXIMUM
CAPACITY TREATMENT NUMBER OF
YEAR MONTI VONTINS YEAR
360.000
BON
REALMENT
SO
RVU YEAR
12
50
INCREASE
INCREASE
1019X1
1119X2
12 1973
1319
19
15 1926
15 19×7
150,000
209.000
229.10
252,090
278,180
306,000
335,000
19,000
20,900
22,990
25,20
21.120
30.000
0.1000
0.1000
0.1000
0.000
11100
0.107
1
1921
ANNUAL GROWTH
19
0.1
336,000
33.500
369,600 which is greater than the maximum capacity. What should this lob do?
MAXIMUM MAXIMUM
CAPACITY TREATMENT NUMBER OE
RVUS
YEAR MONTH MONTHS YEAR TREATMENT
Shet
360.000
Sheet
Set
500
She
12
50
Sheet Seeds Seeds Seed Sheet
dy
Purchase answer to see full
attachment
