Ipd Projection P3
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Ipd Projection P3 as PDF for free.
More details
- Words: 1,801
- Pages: 18
PYT 3 : Revenue per IPD Day, 2007 All Admission Admission Number
B1Jan-07
B1Feb-07
B1Mar-07
B1Apr-07
B1May-07
B1Jun-07
Actual 2007
1,777
1,589
1,502
1,179
Actual 2006
1,678
1,371
1,465
1,313
1,477
1,646
Target 2007
1,876
1,533
1,638
1,468
1,652
1,841
99
218
37
(134)
Diff Last Year Diff Target
(99)
56
(136)
(289)
Percent Diff Target
(5.3)
3.7
(8.3)
(19.7)
IPPD
B1Jan-07
B1Feb-07
B1Mar-07
B1Apr-07
B1May-07
B1Jun-07
Actual 2007
4,481
4,130
4,074
3,202
Actual 2006
4,206
3,716
4,109
3,650
3,909
4,422
Target 2007
4,678
4,133
4,571
4,060
4,348
4,919
275
414
(35)
(448)
Diff Last Year Diff Target
(197)
(3)
(497)
(858)
Percent Diff Target
(4.2)
(0.1)
(10.9)
(21.1)
Gross IPD Revenue
B1Jan-07
B1Feb-07
B1Mar-07
B1Apr-07
B1May-07
B1Jun-07
Actual 2007
55,056,793
49,672,876
55,826,962
47,467,012
Actual 2006
45,595,276
44,006,763
51,463,726
44,691,331
48,289,774
50,798,899
Target 2007
62,642,788
58,391,018
68,060,136
59,437,481
62,377,793
65,742,175
9,461,517
5,666,112
4,363,236
2,775,681
(7,585,995)
(8,718,142)
(12,233,174)
(11,970,469)
(12.1)
(14.9)
(18.0)
(20.1)
Diff Last Year Diff Target Percent Diff Target
1. General Medicine IPD Days Actual 2007
B1Jan-07 1,199
B1Feb-07 1,083
B1Mar-07 1,224
B1Apr-07
B1May-07
B1Jun-07
B1May-07
B1Jun-07
B1May-07
B1Jun-07
B1May-07
B1Jun-07
1,191
Target 2007 Diff Target Percent Diff Target Revenue Actual 2007
B1Jan-07 13,779,934
B1Feb-07 11,584,993
B1Mar-07 17,367,816
B1Apr-07 15,080,169
Target 2007 Diff Target Percent Diff Target
2. Cardiology IPD Days Actual 2007
B1Jan-07 89
B1Feb-07 133
B1Mar-07 131
B1Apr-07 103
Target 2007 Diff Target Percent Diff Target Revenue Actual 2007 Target 2007 Diff Target Percent Diff Target
B1Jan-07 2,116,488
B1Feb-07 2,561,079
B1Mar-07 2,293,278
B1Apr-07 2,437,248
3 Cancer IPD Days Actual 2007
B1Jan-07 143
B1Feb-07
B1Mar-07
102
B1Apr-07
89
B1May-07
B1Jun-07
B1May-07
B1Jun-07
B1May-07
B1Jun-07
B1May-07
B1Jun-07
B1May-07
B1Jun-07
B1May-07
B1Jun-07
B1May-07
B1Jun-07
B1May-07
B1Jun-07
29
Target 2007 Diff Target Percent Diff Target Revenue Actual 2007
B1Jan-07 1,792,835
B1Feb-07
B1Mar-07
1,349,265
B1Apr-07
1,632,894
326,535
Target 2007 Diff Target Percent Diff Target
4. Brain & Spine IPD Days Actual 2007
B1Jan-07 391
B1Feb-07
B1Mar-07
184
B1Apr-07
295
215
Target 2007 Diff Target Percent Diff Target Revenue Actual 2007
B1Jan-07 6,121,560
B1Feb-07
B1Mar-07
2,530,743
B1Apr-07
4,182,180
2,682,654
Target 2007 Diff Target Percent Diff Target
5. Psychiatry IPD Days Actual 2007
B1Jan-07
B1Feb-07
15
B1Mar-07 7
B1Apr-07 9
7
Target 2007 Diff Target Percent Diff Target Revenue Actual 2007
B1Jan-07 129,388
B1Feb-07 61,842
B1Mar-07 130,061
B1Apr-07 87,430
Target 2007 Diff Target Percent Diff Target
6. General Surgery IPD Days Actual 2007
B1Jan-07 266
B1Feb-07 152
B1Mar-07 294
B1Apr-07 273
Target 2007 Diff Target Percent Diff Target Revenue Actual 2007 Target 2007 Diff Target Percent Diff Target
B1Jan-07 5,293,065
B1Feb-07 2,711,565
B1Mar-07 5,492,150
B1Apr-07 6,119,332
7. Head Neck Breast IPD Days
B1Jan-07
Actual 2007
B1Feb-07 7
B1Mar-07 9
B1Apr-07 8
B1May-07
B1Jun-07
B1May-07
B1Jun-07
B1May-07
B1Jun-07
B1May-07
B1Jun-07
B1May-07
B1Jun-07
B1May-07
B1Jun-07
B1May-07
B1Jun-07
B1May-07
B1Jun-07
11
Target 2007 Diff Target Percent Diff Target Revenue Actual 2007
B1Jan-07 147,033
B1Feb-07 181,786
B1Mar-07 249,573
B1Apr-07 361,262
Target 2007 Diff Target Percent Diff Target
8. Urology IPD Days Actual 2007
B1Jan-07 103
B1Feb-07 40
B1Mar-07 88
B1Apr-07 60
Target 2007 Diff Target Percent Diff Target Revenue Actual 2007
B1Jan-07 1,796,484
B1Feb-07 915,091
B1Mar-07 1,783,503
B1Apr-07 1,404,356
Target 2007 Diff Target Percent Diff Target
9. MSK IPD Days Actual 2007
B1Jan-07 293
B1Feb-07 240
B1Mar-07 303
B1Apr-07 235
Target 2007 Diff Target Percent Diff Target Revenue Actual 2007
B1Jan-07 4,987,578
B1Feb-07 4,406,039
B1Mar-07 6,375,125
B1Apr-07 5,292,779
Target 2007 Diff Target Percent Diff Target
10. Pediatrics IPD Days Actual 2007
B1Jan-07 1,024
B1Feb-07 1,096
B1Mar-07 722
B1Apr-07 360
Target 2007 Diff Target Percent Diff Target Revenue Actual 2007 Target 2007 Diff Target Percent Diff Target
B1Jan-07 8,733,208
B1Feb-07 8,848,696
B1Mar-07 5,819,396
B1Apr-07 2,975,362
11.Ob-Gyn IPD Days Actual 2007
B1Jan-07
B1Feb-07
405
448
B1Mar-07
B1Apr-07
452
B1May-07
B1Jun-07
B1May-07
B1Jun-07
B1May-07
B1Jun-07
B1May-07
B1Jun-07
B1May-07
B1Jun-07
B1May-07
B1Jun-07
B1May-07
B1Jun-07
B1May-07
B1Jun-07
358
Target 2007 Diff Target Percent Diff Target Revenue Actual 2007
B1Jan-07
B1Feb-07
5,482,015
6,178,116
B1Mar-07
B1Apr-07
7,164,687
6,111,598
Target 2007 Diff Target Percent Diff Target
12. Eye IPD Days Actual 2007
B1Jan-07
B1Feb-07
33
13
B1Mar-07
B1Apr-07
14
2
Target 2007 Diff Target Percent Diff Target Revenue Actual 2007
B1Jan-07
B1Feb-07
461,036
158,092
B1Mar-07
B1Apr-07
489,334
90,239
Target 2007 Diff Target Percent Diff Target
13.ENT IPD Days Actual 2007
B1Jan-07
B1Feb-07
43
80
B1Mar-07
B1Apr-07
52
43
Target 2007 Diff Target Percent Diff Target Revenue Actual 2007
B1Jan-07
B1Feb-07
748,974
1,047,118
B1Mar-07
B1Apr-07
768,813
965,043
Target 2007 Diff Target Percent Diff Target
14.Skin IPD Days
B1Jan-07
Actual 2007
B1Feb-07 3
B1Mar-07
14
B1Apr-07 7
15
Target 2007 Diff Target Percent Diff Target Revenue Actual 2007 Target 2007 Diff Target Percent Diff Target
B1Jan-07 33,082
B1Feb-07 175,568
B1Mar-07 63,974
B1Apr-07 147,603
15. Dental IPD Days
B1Jan-07
Actual 2007
B1Feb-07 0
B1Mar-07 0
B1Apr-07 0
B1May-07
B1Jun-07
B1May-07
B1Jun-07
B1May-07
B1Jun-07
B1May-07
B1Jun-07
B1May-07
B1Jun-07
B1May-07
B1Jun-07
B1May-07
B1Jun-07
2
Target 2007 Diff Target Percent Diff Target Revenue
B1Jan-07
Actual 2007
B1Feb-07 0
B1Mar-07 0
B1Apr-07 0
126,543
Target 2007 Diff Target Percent Diff Target
16. NSY IPD Days Actual 2007
B1Jan-07 354
B1Feb-07 339
B1Mar-07 356
B1Apr-07 273
Target 2007 Diff Target Percent Diff Target Revenue Actual 2007
B1Jan-07 1,375,443
B1Feb-07 1,452,769
B1Mar-07 1,256,198
B1Apr-07 1,139,849
Target 2007 Diff Target Percent Diff Target
17.Other IPD Revenue IPD Days Actual 2007
B1Jan-07 113
B1Feb-07 190
B1Mar-07 30
B1Apr-07 25
Target 2007 Diff Target Percent Diff Target Revenue Actual 2007
B1Jan-07 908,118
B1Feb-07 3,404,897
B1Mar-07 120,013
B1Apr-07 174,877
Target 2007 Diff Target Percent Diff Target
NET REVENUE FROM IPD Revenue
B1Jan-07
B1Feb-07
B1Mar-07
B1Apr-07
Actual 2007
53,906,241
47,567,659
55,188,995
45,522,879
Actual 2006
43,550,739
41,930,074
49,554,804
43,031,711
46,344,044
48,783,141
Target 2007
62,642,788
58,391,018
68,060,136
59,437,481
62,377,793
65,742,175
Diff Last Year
10,355,502
5,637,585
5,634,191
2,491,168
Diff Target
(8,736,547)
(10,823,359)
(12,871,141)
(13,914,602)
(13.9)
(18.5)
(18.9)
(23.4)
12,030
11,518
13,547
14,217
Percent Diff Target NET REVENUE PER IPD DAYS CONVERSION RATIO AVERAGE LENGTH OF STAY
4.42%
4.29%
3.84%
3.54%
2.52
2.60
2.71
2.72
OPD GROSS REVENUE
B1Jan-07
B1Feb-07
B1Mar-07
B1Apr-07
B1May-07
B1Jun-07
Actual 2007
54,039,946
49,341,024
56,468,064
52,394,072
Actual 2006
44,311,760
41,927,174
45,931,199
43,532,467
47,484,186
47,260,718
Target
51,807,474
51,001,551
55,922,093
52,870,046
59,540,972
59,086,197
Diff Last Year
9,728,186
7,413,850
10,536,865
8,861,605
Diff Target
2,232,472
(1,660,527)
545,971
(475,974)
22.0
17.7
22.9
20.4
4.3
(3.3)
1.0
(0.9)
Percent Diff Last year Percent Diff Target IPD GROSS REVENUE
B1Jan-07
B1Feb-07
B1Mar-07
B1Apr-07
B1May-07
B1Jun-07
Actual 2007
55,056,793
49,672,876
55,826,962
47,467,012
Actual 2006
45,595,276
44,006,763
51,463,726
44,691,331
48,289,774
50,798,899
Target
62,642,788
58,391,018
68,060,136
59,437,481
62,377,793
65,742,175
Diff Last Year Diff Target Percent Diff Last year Percent Diff Target
9,461,517
5,666,112
4,363,236
2,775,681
(7,585,995)
(8,718,142)
(12,233,174)
(11,970,469)
20.8
12.9
8.5
6.2
(12.1)
(14.9)
(18.0)
(20.1)
Total GROSS REVENUE
B1Jan-07
Actual 2007
109,096,739
Actual 2006 Target
B1Feb-07 99,013,899
B1Mar-07 112,295,026
B1Apr-07
89,907,036
85,933,937
97,394,925
88,223,798
95,773,959
98,059,617
109,392,569
123,982,229
112,307,527
121,918,765
124,828,372
B1May-07
B1Jun-07
19,189,703
13,079,962
14,900,101
11,637,286
Diff Target
(5,353,523)
(10,378,670)
(11,687,203)
(12,446,442)
Percent Diff Last year
21.3
15.2
15.3
13.2
Percent Diff Target
(4.7)
(9.5)
(9.4)
(11.1)
B1Jan-07
B1Feb-07
B1Mar-07
B1Apr-07
Actual 2007
20,971,617
12,578,997
16,683,994
13,138,701
Actual 2006
19,813,074
17,875,423
18,502,988
15,691,155
1,158,543
(5,296,426)
(1,818,994)
(2,552,454)
Diff Last Year
B1Jun-07
114,450,262
Diff Last Year
EBITDA
B1May-07
99,861,085
Percent Diff Last year
5.8
(29.6)
(9.8)
(16.3)
EBITDA to Gross Sale
19.22%
12.70%
14.86%
13.16%
13,925,627
13,971,827
D Day, 2007 B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
YTD.
Total
6,047
6,047
1,890
2,104
1,849
1,635
1,533
1,488
5,827
19,449
2,113
2,353
2,068
1,828
1,714
1,664
6,515
21,748
220 (468) (7.2) B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
YTD.
Total
15,887
15,887
5,001
5,544
4,755
4,348
4,229
4,145
15,681
52,034
5,563
6,167
5,289
4,836
4,704
4,611
17,442
57,879
206 (1,555) (8.9) B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
YTD.
Total
208,023,643
208,023,643
54,820,978
59,714,355
54,688,906
50,149,822
48,447,493
50,364,424
185,757,097
603,031,747
70,445,172
76,019,370
69,518,854
66,019,393
63,647,706
66,408,725
248,531,423
788,710,611
22,266,546 (40,507,780) (16.3)
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
YTD.
Total
4,697
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
YTD.
Total
57,812,912
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
4,697
YTD.
57,812,912
Total 456
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
YTD. 9,408,093
456
Total 9,408,093
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
YTD.
Total 363
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
YTD.
Total
5,101,529
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
363
YTD.
5,101,529
Total
1,085
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
YTD.
Total
15,517,137
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
1,085
YTD.
15,517,137
Total 38
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
YTD.
Total
408,721
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
38
YTD.
408,721
Total 985
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
YTD. 19,616,112
985
Total 19,616,112
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
YTD.
Total 35
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
YTD.
Total
939,654
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
35
YTD.
939,654
Total 291
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
YTD. 5,899,434
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
YTD.
291
Total 5,899,434
Total
1,071
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
YTD. 21,061,521
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
YTD.
1,071
Total 21,061,521
Total
3,202
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
YTD. 26,376,662
3,202
Total 26,376,662
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
YTD.
Total
1,663
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
YTD.
Total
24,936,416
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
1,663
YTD.
24,936,416
Total 62
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
YTD.
Total
1,198,701
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
62
YTD.
1,198,701
Total 218
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
YTD.
Total
3,529,948
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
218
YTD.
3,529,948
Total 39
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
YTD. 420,227
39
Total 420,227
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
YTD.
Total 2
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
YTD.
Total
126,543
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
2
YTD.
126,543
Total
1,322
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
YTD.
Total
5,224,259
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
1,322
YTD.
5,224,259
Total 358
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
YTD. 4,607,905
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
YTD.
358
Total 4,607,905
Total
202,185,774
202,185,774
52,460,218
57,108,349
52,445,931
48,181,782
46,240,739
48,211,764
178,067,328
577,843,296
70,445,172
76,019,370
69,518,854
66,019,393
63,647,706
66,408,725
248,531,423
788,710,611
24,118,446 (46,345,649) (18.6)
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
YTD.
Total
212,243,106
212,243,106
53,047,818
53,400,390
51,494,449
53,225,794
51,665,350
53,803,570
175,702,599
587,084,875
66,870,132
67,973,947
65,650,909
65,576,163
63,794,390
66,195,515
211,601,164
726,289,389
36,540,506 641,942 20.8 0.3 B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
YTD.
Total
208,023,643
208,023,643
54,820,978
59,714,355
54,688,906
50,149,822
48,447,493
50,364,424
185,757,097
603,031,747
70,445,172
76,019,370
69,518,854
66,019,393
63,647,706
66,408,725
248,531,423
788,710,611
22,266,546 (40,507,780) 12.0 (16.3) B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
YTD.
Total
420,266,749
420,266,749
107,868,795
113,114,746
106,183,354
103,375,616
100,112,843
104,167,994
361,459,696
1,190,116,621
137,315,304
143,993,317
135,169,763
131,595,556
127,442,096
132,604,240
460,132,587
1,515,000,000
58,807,052 (39,865,838) 16.3 (8.7) B1Jul-07 22,131,284
B1Aug-07 19,552,585
B1Sep-07 16,765,769
B1Oct-07 13,533,183
B1Nov-07 11,570,964
B1Dec-07 5,335,313
YTD.
Total
63,373,309
63,373,309
71,882,640
188,669,191
(8,509,331) (11.8) 15.08%
Growth%
Growth%
Growth%
Growth%
Growth%
Growth%
Growth%
Growth%
Growth%
Growth%
Growth%
Growth%
Growth%
Growth%
Growth%
Growth%
Growth%
Growth%
Growth%
Growth%
Growth%
Growth%
Growth%
Growth%
Growth%
Growth%
Growth%
Growth%
Growth%
Growth%
Growth%
Growth%
Growth%
Growth%
Growth%
Growth%
Growth%
Growth%
Growth%
Growth%
Growth%
Growth%
B1Jan-07
B1Feb-07
B1Mar-07
B1Apr-07
B1May-07
B1Jun-07
Actual 2007
1,777
1,589
1,502
1,179
Actual 2006
1,678
1,371
1,465
1,313
1,477
1,646
Target 2007
1,876
1,533
1,638
1,468
1,652
1,841
99
218
37
(134)
Diff Last Year Diff Target
(99)
56
(136)
(289)
Percent Diff Target
(5.3)
3.7
(8.3)
(19.7)
IPPD
B1Jan-07
B1Feb-07
B1Mar-07
B1Apr-07
B1May-07
B1Jun-07
Actual 2007
4,481
4,130
4,074
3,202
Actual 2006
4,206
3,716
4,109
3,650
3,909
4,422
Target 2007
4,678
4,133
4,571
4,060
4,348
4,919
275
414
(35)
(448)
Diff Last Year Diff Target
(197)
(3)
(497)
(858)
Percent Diff Target
(4.2)
(0.1)
(10.9)
(21.1)
Gross IPD Revenue
B1Jan-07
B1Feb-07
B1Mar-07
B1Apr-07
B1May-07
B1Jun-07
Actual 2007
55,056,793
49,672,876
55,826,962
47,467,012
Actual 2006
45,595,276
44,006,763
51,463,726
44,691,331
48,289,774
50,798,899
Target 2007
62,642,788
58,391,018
68,060,136
59,437,481
62,377,793
65,742,175
9,461,517
5,666,112
4,363,236
2,775,681
(7,585,995)
(8,718,142)
(12,233,174)
(11,970,469)
(12.1)
(14.9)
(18.0)
(20.1)
Diff Last Year Diff Target Percent Diff Target
1. General Medicine IPD Days Actual 2007
B1Jan-07 1,199
B1Feb-07 1,083
B1Mar-07 1,224
B1Apr-07
B1May-07
B1Jun-07
B1May-07
B1Jun-07
B1May-07
B1Jun-07
B1May-07
B1Jun-07
1,191
Target 2007 Diff Target Percent Diff Target Revenue Actual 2007
B1Jan-07 13,779,934
B1Feb-07 11,584,993
B1Mar-07 17,367,816
B1Apr-07 15,080,169
Target 2007 Diff Target Percent Diff Target
2. Cardiology IPD Days Actual 2007
B1Jan-07 89
B1Feb-07 133
B1Mar-07 131
B1Apr-07 103
Target 2007 Diff Target Percent Diff Target Revenue Actual 2007 Target 2007 Diff Target Percent Diff Target
B1Jan-07 2,116,488
B1Feb-07 2,561,079
B1Mar-07 2,293,278
B1Apr-07 2,437,248
3 Cancer IPD Days Actual 2007
B1Jan-07 143
B1Feb-07
B1Mar-07
102
B1Apr-07
89
B1May-07
B1Jun-07
B1May-07
B1Jun-07
B1May-07
B1Jun-07
B1May-07
B1Jun-07
B1May-07
B1Jun-07
B1May-07
B1Jun-07
B1May-07
B1Jun-07
B1May-07
B1Jun-07
29
Target 2007 Diff Target Percent Diff Target Revenue Actual 2007
B1Jan-07 1,792,835
B1Feb-07
B1Mar-07
1,349,265
B1Apr-07
1,632,894
326,535
Target 2007 Diff Target Percent Diff Target
4. Brain & Spine IPD Days Actual 2007
B1Jan-07 391
B1Feb-07
B1Mar-07
184
B1Apr-07
295
215
Target 2007 Diff Target Percent Diff Target Revenue Actual 2007
B1Jan-07 6,121,560
B1Feb-07
B1Mar-07
2,530,743
B1Apr-07
4,182,180
2,682,654
Target 2007 Diff Target Percent Diff Target
5. Psychiatry IPD Days Actual 2007
B1Jan-07
B1Feb-07
15
B1Mar-07 7
B1Apr-07 9
7
Target 2007 Diff Target Percent Diff Target Revenue Actual 2007
B1Jan-07 129,388
B1Feb-07 61,842
B1Mar-07 130,061
B1Apr-07 87,430
Target 2007 Diff Target Percent Diff Target
6. General Surgery IPD Days Actual 2007
B1Jan-07 266
B1Feb-07 152
B1Mar-07 294
B1Apr-07 273
Target 2007 Diff Target Percent Diff Target Revenue Actual 2007 Target 2007 Diff Target Percent Diff Target
B1Jan-07 5,293,065
B1Feb-07 2,711,565
B1Mar-07 5,492,150
B1Apr-07 6,119,332
7. Head Neck Breast IPD Days
B1Jan-07
Actual 2007
B1Feb-07 7
B1Mar-07 9
B1Apr-07 8
B1May-07
B1Jun-07
B1May-07
B1Jun-07
B1May-07
B1Jun-07
B1May-07
B1Jun-07
B1May-07
B1Jun-07
B1May-07
B1Jun-07
B1May-07
B1Jun-07
B1May-07
B1Jun-07
11
Target 2007 Diff Target Percent Diff Target Revenue Actual 2007
B1Jan-07 147,033
B1Feb-07 181,786
B1Mar-07 249,573
B1Apr-07 361,262
Target 2007 Diff Target Percent Diff Target
8. Urology IPD Days Actual 2007
B1Jan-07 103
B1Feb-07 40
B1Mar-07 88
B1Apr-07 60
Target 2007 Diff Target Percent Diff Target Revenue Actual 2007
B1Jan-07 1,796,484
B1Feb-07 915,091
B1Mar-07 1,783,503
B1Apr-07 1,404,356
Target 2007 Diff Target Percent Diff Target
9. MSK IPD Days Actual 2007
B1Jan-07 293
B1Feb-07 240
B1Mar-07 303
B1Apr-07 235
Target 2007 Diff Target Percent Diff Target Revenue Actual 2007
B1Jan-07 4,987,578
B1Feb-07 4,406,039
B1Mar-07 6,375,125
B1Apr-07 5,292,779
Target 2007 Diff Target Percent Diff Target
10. Pediatrics IPD Days Actual 2007
B1Jan-07 1,024
B1Feb-07 1,096
B1Mar-07 722
B1Apr-07 360
Target 2007 Diff Target Percent Diff Target Revenue Actual 2007 Target 2007 Diff Target Percent Diff Target
B1Jan-07 8,733,208
B1Feb-07 8,848,696
B1Mar-07 5,819,396
B1Apr-07 2,975,362
11.Ob-Gyn IPD Days Actual 2007
B1Jan-07
B1Feb-07
405
448
B1Mar-07
B1Apr-07
452
B1May-07
B1Jun-07
B1May-07
B1Jun-07
B1May-07
B1Jun-07
B1May-07
B1Jun-07
B1May-07
B1Jun-07
B1May-07
B1Jun-07
B1May-07
B1Jun-07
B1May-07
B1Jun-07
358
Target 2007 Diff Target Percent Diff Target Revenue Actual 2007
B1Jan-07
B1Feb-07
5,482,015
6,178,116
B1Mar-07
B1Apr-07
7,164,687
6,111,598
Target 2007 Diff Target Percent Diff Target
12. Eye IPD Days Actual 2007
B1Jan-07
B1Feb-07
33
13
B1Mar-07
B1Apr-07
14
2
Target 2007 Diff Target Percent Diff Target Revenue Actual 2007
B1Jan-07
B1Feb-07
461,036
158,092
B1Mar-07
B1Apr-07
489,334
90,239
Target 2007 Diff Target Percent Diff Target
13.ENT IPD Days Actual 2007
B1Jan-07
B1Feb-07
43
80
B1Mar-07
B1Apr-07
52
43
Target 2007 Diff Target Percent Diff Target Revenue Actual 2007
B1Jan-07
B1Feb-07
748,974
1,047,118
B1Mar-07
B1Apr-07
768,813
965,043
Target 2007 Diff Target Percent Diff Target
14.Skin IPD Days
B1Jan-07
Actual 2007
B1Feb-07 3
B1Mar-07
14
B1Apr-07 7
15
Target 2007 Diff Target Percent Diff Target Revenue Actual 2007 Target 2007 Diff Target Percent Diff Target
B1Jan-07 33,082
B1Feb-07 175,568
B1Mar-07 63,974
B1Apr-07 147,603
15. Dental IPD Days
B1Jan-07
Actual 2007
B1Feb-07 0
B1Mar-07 0
B1Apr-07 0
B1May-07
B1Jun-07
B1May-07
B1Jun-07
B1May-07
B1Jun-07
B1May-07
B1Jun-07
B1May-07
B1Jun-07
B1May-07
B1Jun-07
B1May-07
B1Jun-07
2
Target 2007 Diff Target Percent Diff Target Revenue
B1Jan-07
Actual 2007
B1Feb-07 0
B1Mar-07 0
B1Apr-07 0
126,543
Target 2007 Diff Target Percent Diff Target
16. NSY IPD Days Actual 2007
B1Jan-07 354
B1Feb-07 339
B1Mar-07 356
B1Apr-07 273
Target 2007 Diff Target Percent Diff Target Revenue Actual 2007
B1Jan-07 1,375,443
B1Feb-07 1,452,769
B1Mar-07 1,256,198
B1Apr-07 1,139,849
Target 2007 Diff Target Percent Diff Target
17.Other IPD Revenue IPD Days Actual 2007
B1Jan-07 113
B1Feb-07 190
B1Mar-07 30
B1Apr-07 25
Target 2007 Diff Target Percent Diff Target Revenue Actual 2007
B1Jan-07 908,118
B1Feb-07 3,404,897
B1Mar-07 120,013
B1Apr-07 174,877
Target 2007 Diff Target Percent Diff Target
NET REVENUE FROM IPD Revenue
B1Jan-07
B1Feb-07
B1Mar-07
B1Apr-07
Actual 2007
53,906,241
47,567,659
55,188,995
45,522,879
Actual 2006
43,550,739
41,930,074
49,554,804
43,031,711
46,344,044
48,783,141
Target 2007
62,642,788
58,391,018
68,060,136
59,437,481
62,377,793
65,742,175
Diff Last Year
10,355,502
5,637,585
5,634,191
2,491,168
Diff Target
(8,736,547)
(10,823,359)
(12,871,141)
(13,914,602)
(13.9)
(18.5)
(18.9)
(23.4)
12,030
11,518
13,547
14,217
Percent Diff Target NET REVENUE PER IPD DAYS CONVERSION RATIO AVERAGE LENGTH OF STAY
4.42%
4.29%
3.84%
3.54%
2.52
2.60
2.71
2.72
OPD GROSS REVENUE
B1Jan-07
B1Feb-07
B1Mar-07
B1Apr-07
B1May-07
B1Jun-07
Actual 2007
54,039,946
49,341,024
56,468,064
52,394,072
Actual 2006
44,311,760
41,927,174
45,931,199
43,532,467
47,484,186
47,260,718
Target
51,807,474
51,001,551
55,922,093
52,870,046
59,540,972
59,086,197
Diff Last Year
9,728,186
7,413,850
10,536,865
8,861,605
Diff Target
2,232,472
(1,660,527)
545,971
(475,974)
22.0
17.7
22.9
20.4
4.3
(3.3)
1.0
(0.9)
Percent Diff Last year Percent Diff Target IPD GROSS REVENUE
B1Jan-07
B1Feb-07
B1Mar-07
B1Apr-07
B1May-07
B1Jun-07
Actual 2007
55,056,793
49,672,876
55,826,962
47,467,012
Actual 2006
45,595,276
44,006,763
51,463,726
44,691,331
48,289,774
50,798,899
Target
62,642,788
58,391,018
68,060,136
59,437,481
62,377,793
65,742,175
Diff Last Year Diff Target Percent Diff Last year Percent Diff Target
9,461,517
5,666,112
4,363,236
2,775,681
(7,585,995)
(8,718,142)
(12,233,174)
(11,970,469)
20.8
12.9
8.5
6.2
(12.1)
(14.9)
(18.0)
(20.1)
Total GROSS REVENUE
B1Jan-07
Actual 2007
109,096,739
Actual 2006 Target
B1Feb-07 99,013,899
B1Mar-07 112,295,026
B1Apr-07
89,907,036
85,933,937
97,394,925
88,223,798
95,773,959
98,059,617
109,392,569
123,982,229
112,307,527
121,918,765
124,828,372
B1May-07
B1Jun-07
19,189,703
13,079,962
14,900,101
11,637,286
Diff Target
(5,353,523)
(10,378,670)
(11,687,203)
(12,446,442)
Percent Diff Last year
21.3
15.2
15.3
13.2
Percent Diff Target
(4.7)
(9.5)
(9.4)
(11.1)
B1Jan-07
B1Feb-07
B1Mar-07
B1Apr-07
Actual 2007
20,971,617
12,578,997
16,683,994
13,138,701
Actual 2006
19,813,074
17,875,423
18,502,988
15,691,155
1,158,543
(5,296,426)
(1,818,994)
(2,552,454)
Diff Last Year
B1Jun-07
114,450,262
Diff Last Year
EBITDA
B1May-07
99,861,085
Percent Diff Last year
5.8
(29.6)
(9.8)
(16.3)
EBITDA to Gross Sale
19.22%
12.70%
14.86%
13.16%
13,925,627
13,971,827
D Day, 2007 B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
YTD.
Total
6,047
6,047
1,890
2,104
1,849
1,635
1,533
1,488
5,827
19,449
2,113
2,353
2,068
1,828
1,714
1,664
6,515
21,748
220 (468) (7.2) B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
YTD.
Total
15,887
15,887
5,001
5,544
4,755
4,348
4,229
4,145
15,681
52,034
5,563
6,167
5,289
4,836
4,704
4,611
17,442
57,879
206 (1,555) (8.9) B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
YTD.
Total
208,023,643
208,023,643
54,820,978
59,714,355
54,688,906
50,149,822
48,447,493
50,364,424
185,757,097
603,031,747
70,445,172
76,019,370
69,518,854
66,019,393
63,647,706
66,408,725
248,531,423
788,710,611
22,266,546 (40,507,780) (16.3)
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
YTD.
Total
4,697
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
YTD.
Total
57,812,912
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
4,697
YTD.
57,812,912
Total 456
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
YTD. 9,408,093
456
Total 9,408,093
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
YTD.
Total 363
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
YTD.
Total
5,101,529
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
363
YTD.
5,101,529
Total
1,085
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
YTD.
Total
15,517,137
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
1,085
YTD.
15,517,137
Total 38
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
YTD.
Total
408,721
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
38
YTD.
408,721
Total 985
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
YTD. 19,616,112
985
Total 19,616,112
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
YTD.
Total 35
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
YTD.
Total
939,654
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
35
YTD.
939,654
Total 291
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
YTD. 5,899,434
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
YTD.
291
Total 5,899,434
Total
1,071
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
YTD. 21,061,521
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
YTD.
1,071
Total 21,061,521
Total
3,202
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
YTD. 26,376,662
3,202
Total 26,376,662
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
YTD.
Total
1,663
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
YTD.
Total
24,936,416
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
1,663
YTD.
24,936,416
Total 62
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
YTD.
Total
1,198,701
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
62
YTD.
1,198,701
Total 218
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
YTD.
Total
3,529,948
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
218
YTD.
3,529,948
Total 39
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
YTD. 420,227
39
Total 420,227
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
YTD.
Total 2
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
YTD.
Total
126,543
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
2
YTD.
126,543
Total
1,322
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
YTD.
Total
5,224,259
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
1,322
YTD.
5,224,259
Total 358
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
YTD. 4,607,905
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
YTD.
358
Total 4,607,905
Total
202,185,774
202,185,774
52,460,218
57,108,349
52,445,931
48,181,782
46,240,739
48,211,764
178,067,328
577,843,296
70,445,172
76,019,370
69,518,854
66,019,393
63,647,706
66,408,725
248,531,423
788,710,611
24,118,446 (46,345,649) (18.6)
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
YTD.
Total
212,243,106
212,243,106
53,047,818
53,400,390
51,494,449
53,225,794
51,665,350
53,803,570
175,702,599
587,084,875
66,870,132
67,973,947
65,650,909
65,576,163
63,794,390
66,195,515
211,601,164
726,289,389
36,540,506 641,942 20.8 0.3 B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
YTD.
Total
208,023,643
208,023,643
54,820,978
59,714,355
54,688,906
50,149,822
48,447,493
50,364,424
185,757,097
603,031,747
70,445,172
76,019,370
69,518,854
66,019,393
63,647,706
66,408,725
248,531,423
788,710,611
22,266,546 (40,507,780) 12.0 (16.3) B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
YTD.
Total
420,266,749
420,266,749
107,868,795
113,114,746
106,183,354
103,375,616
100,112,843
104,167,994
361,459,696
1,190,116,621
137,315,304
143,993,317
135,169,763
131,595,556
127,442,096
132,604,240
460,132,587
1,515,000,000
58,807,052 (39,865,838) 16.3 (8.7) B1Jul-07 22,131,284
B1Aug-07 19,552,585
B1Sep-07 16,765,769
B1Oct-07 13,533,183
B1Nov-07 11,570,964
B1Dec-07 5,335,313
YTD.
Total
63,373,309
63,373,309
71,882,640
188,669,191
(8,509,331) (11.8) 15.08%
Growth%
Growth%
Growth%
Growth%
Growth%
Growth%
Growth%
Growth%
Growth%
Growth%
Growth%
Growth%
Growth%
Growth%
Growth%
Growth%
Growth%
Growth%
Growth%
Growth%
Growth%
Growth%
Growth%
Growth%
Growth%
Growth%
Growth%
Growth%
Growth%
Growth%
Growth%
Growth%
Growth%
Growth%
Growth%
Growth%
Growth%
Growth%
Growth%
Growth%
Growth%
Growth%
Related Documents
Ipd Projection P3
November 2019 21
Projection
December 2019 51
P3
May 2020 43
P3
May 2020 22
P3
June 2020 17