Revenue Projection Opdipd1
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 Revenue Projection Opdipd1 as PDF for free.
More details
- Words: 4,929
- Pages: 27
January 2007 Volume
January 2007 Actual
Target
Diff target
% Diff Target
Volume
1
General medicine
6,520,886
5,190,542
1,330,345
0.26
1
2
Dental
6,310,247
6,281,278
28,969
0.00
2
3
MSK
4,765,763
3,850,306
915,457
0.24
3
4
Cardiology
3,926,594
5,337,072
(1,410,477)
(0.26)
4
5
GI System
3,973,182
3,768,227
204,955
0.05
5
6
Pulmonary Disease
2,440,062
2,940,838
(500,776)
(0.17)
6
7
Endocrine & Metabolism
2,573,927
2,847,262
(273,334)
(0.10)
7
8
Pediatrics
2,152,957
2,190,258
(37,301)
(0.02)
8
9
ER
2,013,327
1,982,839
30,488
0.02
9
10
Women Center
2,197,660
1,771,972
425,688
0.24
10
11
Neurology
4,476,238
5,189,297
(713,059)
(0.14)
11
12
Surgery
2,051,782
1,918,446
133,335
0.07
12
13
CHECK UP
3,928,461
3,823,011
105,450
0.03
13
14
Eye
988,728
1,005,283
(16,555)
(0.02)
14
15
ENT
1,128,765
1,214,680
(85,915)
(0.07)
15
16
Skin
1,055,420
867,352
188,068
0.22
17
Psychiatry
704,617
614,602
90,015
0.15
18
HD
2,352,544
2,000,075
352,469
0.18
19
PT
335,813
315,404
20,410
0.06
20
PCC
879,871
1,387,833
(507,962)
(0.37)
21
Other Total
3,823,373
2,861,190
962,183
0.34
58,600,219
57,357,767
1,242,452
0.02
February 2007 Volume
General medicine MSK Cardiology GI System Pulmonary Disease Endocrine & Metabolism Pediatrics Women Center Neurology Surgery Eye ENT Skin Psychiatry Total
Actual
11,998,521 5,908,252 5,492,093 5,970,482 3,477,329 2,906,974 3,493,020 3,338,217 6,404,779 8,216,594 355,153 326,415 879,415 43,964 58,811,208
Target
Diff target
% Diff Target
4,680,501
7,318,020
1.56
6,711,231
(802,979)
(0.12)
3,877,096
1,614,997
0.42
4,247,365
1,723,117
0.41
4,219,384
(742,055)
(0.18)
2,479,712
427,262
0.17
2,455,023
1,037,997
0.42
1,852,453
1,485,764
0.80
1,763,377
4,641,402
2.63
1,966,043
6,250,551
3.18
5,527,928
(5,172,775)
(0.94)
1,781,931
(1,455,516)
(0.82)
4,650,785
(3,771,370)
(0.81)
968,632
(924,668)
(0.95)
1,163,690
57,647,518
49.54
February 2007 Actual
1
General medicine
5,372,862
2
Dental
3
MSK
4
Cardiology
3,490,227
Target
Diff target
% Diff Target
Volume
Actual
Target
Diff target
% Diff Target
4,680,501
692,361
0.15
1
Dental
#REF!
#REF!
#REF!
#REF!
5,817,556
6,711,231
(893,675)
(0.13)
2
MSK
#REF!
#REF!
#REF!
#REF!
4,036,753
3,877,096
159,657
0.04
3
General medicine
#REF!
#REF!
#REF!
#REF!
4,247,365
(757,138)
(0.18)
4
Cardiology
#REF!
#REF!
#REF!
#REF!
5
GI System
3,794,243
4,219,384
(425,141)
(0.10)
5
GI System
#REF!
#REF!
#REF!
#REF!
6
Pulmonary Disease
2,209,844
2,479,712
(269,868)
(0.11)
6
Pulmonary Disease
#REF!
#REF!
#REF!
#REF!
7
Endocrine & Metabolism
1,847,383
2,455,023
(607,640)
(0.25)
7
Endocrine & Metabolism
#REF!
#REF!
#REF!
#REF!
8
Pediatrics
1,644,405
1,852,453
(208,048)
(0.11)
8
Pediatrics
#REF!
#REF!
#REF!
#REF!
9
ER
1,693,070
1,763,377
(70,307)
(0.04)
9
ER
#REF!
#REF!
#REF!
#REF!
10
Women Center
2,574,019
1,966,043
607,977
0.31
10 Women Center
#REF!
#REF!
#REF!
#REF!
11
Neurology
4,070,239
5,527,928
(1,457,689)
(0.26)
11 Neurology
#REF!
#REF!
#REF!
#REF!
12
Surgery
1,908,377
1,781,931
126,446
0.07
12 Surgery
#REF!
#REF!
#REF!
#REF!
13
CHECK UP
3,614,321
4,650,785
(1,036,464)
(0.22)
13 CHECK UP
#REF!
#REF!
#REF!
#REF!
14
Eye
882,636
968,632
(85,996)
(0.09)
14 Eye
#REF!
#REF!
#REF!
#REF!
15
ENT
1,099,576
1,163,690
(64,114)
(0.06)
15 ENT
#REF!
#REF!
#REF!
#REF!
16
Skin
879,415
879,711
(296)
(0.00)
16 Skin
#REF!
#REF!
#REF!
#REF!
17
Psychiatry
639,204
533,949
105,255
0.20
17 Psychiatry
#REF!
#REF!
#REF!
#REF!
18
HD
1,969,187
1,939,236
29,951
0.02
18 HD
#REF!
#REF!
#REF!
#REF!
19
PT
205,852
268,365
(62,514)
(0.23)
19 PT
#REF!
#REF!
#REF!
#REF!
20
PCC
2,120,406
4,105,837
(1,985,432)
(0.48)
20 PCC
#REF!
#REF!
#REF!
#REF!
21
Other
3,543,982
2,760,652
783,330
0.28
#REF!
#REF!
#REF!
#REF!
48,040,695
54,152,400
(6,895,035)
(0.11)
#REF!
#REF!
#REF!
#REF!
Total
21
Total
March 2007 Volume
Other
March 2007 Actual
Target
Diff target
% Diff Target
Volume
Actual
Target
Diff target
% Diff Target
3
General medicine
8,913,578
4,157,992
4,755,586
1.14
3
General medicine
8,913,578
4,157,992
4,755,586
1.14
1
Dental
7,568,029
7,926,813
(358,784)
(0.05)
1
Dental
7,568,029
7,926,813
(358,784)
(0.05)
2
MSK
5,228,283
4,069,996
1,158,287
0.28
2
MSK
5,228,283
4,069,996
1,158,287
0.28
4
Cardiology
4,531,775
4,708,123
(176,348)
(0.04)
4
Cardiology
4,531,775
4,708,123
(176,348)
(0.04)
5
GI System
3,509,376
3,336,477
172,900
0.05
5
GI System
3,509,376
3,336,477
172,900
0.05
6
Pulmonary Disease
2,471,807
2,392,791
79,016
0.03
6
Pulmonary Disease
2,471,807
2,392,791
79,016
0.03
7
Endocrine & Metabolism
2,537,889
2,617,920
(80,031)
(0.03)
7
Endocrine & Metabolism
2,537,889
2,617,920
(80,031)
(0.03)
8
Pediatrics
1,589,183
1,794,573
(205,390)
(0.11)
8
Pediatrics
1,589,183
1,794,573
(205,390)
(0.11)
9
ER
2,018,068
1,971,465
46,603
0.02
9
ER
2,018,068
1,971,465
46,603
0.02
10 Women Center
2,801,509
1,966,395
835,114
0.42
10 Women Center
2,801,509
1,966,395
835,114
0.42
11 Neurology
4,991,305
5,640,152
(648,847)
(0.12)
11 Neurology
4,991,305
5,640,152
(648,847)
(0.12)
12 Surgery
2,326,174
1,916,939
409,235
0.21
12 Surgery
2,326,174
1,916,939
409,235
0.21
13 CHECK UP
4,620,402
5,656,540
(1,036,138)
(0.18)
13 CHECK UP
4,620,402
5,656,540
(1,036,138)
(0.18)
14 Eye
1,197,895
1,022,270
175,625
0.17
14 Eye
1,197,895
1,022,270
175,625
0.17
15 ENT
1,119,111
1,082,993
36,118
0.03
15 ENT
1,119,111
1,082,993
36,118
0.03
16 Skin
927,849
962,955
(35,106)
(0.04)
16 Skin
927,849
962,955
(35,106)
(0.04)
17 Psychiatry
730,618
719,377
11,241
0.02
17 Psychiatry
730,618
719,377
11,241
18 HD
2,307,621
2,182,721
124,900
0.06
18 HD
2,307,621
2,182,721
124,900
0.06
19 PT
283,705
285,817
(2,112)
(0.01)
19 PT
283,705
285,817
(2,112)
(0.01)
20 PCC
1,348,438
4,645,960
(3,297,522)
(0.71)
20 PCC
1,348,438
4,645,960
(3,297,522)
(0.71)
21 Other
3,837,431
3,106,027
731,403
0.24
21 Other
3,837,431
3,106,027
731,403
0.24
64,860,045
62,164,296
(2,791,240)
0.04
64,860,045
62,164,296
(2,791,240)
0.04
Actual
Target
Total
Total
April 2007 Volume
0.02
April 2007 Actual
Diff target
Target
% Diff Target
Volume
Diff target
% Diff Target
3
General medicine
8,913,578
4,157,992
4,755,586
1.14
3
General medicine
8,913,578
4,157,992
4,755,586
1.14
1
Dental
7,568,029
7,926,813
(358,784)
(0.05)
1
Dental
7,568,029
7,926,813
(358,784)
(0.05)
2
MSK
5,228,283
4,069,996
1,158,287
0.28
2
MSK
5,228,283
4,069,996
1,158,287
0.28
4
Cardiology
4,531,775
4,708,123
(176,348)
(0.04)
4
Cardiology
4,531,775
4,708,123
(176,348)
(0.04)
5
GI System
3,509,376
3,336,477
172,900
0.05
5
GI System
3,509,376
3,336,477
172,900
0.05
6
Pulmonary Disease
2,471,807
2,392,791
79,016
0.03
6
Pulmonary Disease
2,471,807
2,392,791
79,016
0.03
7
Endocrine & Metabolism
2,537,889
2,617,920
(80,031)
(0.03)
7
Endocrine & Metabolism
2,537,889
2,617,920
(80,031)
(0.03)
8
Pediatrics
1,589,183
1,794,573
(205,390)
(0.11)
8
Pediatrics
1,589,183
1,794,573
(205,390)
(0.11)
9
ER
2,018,068
1,971,465
46,603
0.02
9
ER
2,018,068
1,971,465
46,603
0.02
10 Women Center
2,801,509
1,966,395
835,114
0.42
10 Women Center
2,801,509
1,966,395
835,114
0.42
11 Neurology
4,991,305
5,640,152
(648,847)
(0.12)
11 Neurology
4,991,305
5,640,152
(648,847)
(0.12)
12 Surgery
2,326,174
1,916,939
409,235
0.21
12 Surgery
2,326,174
1,916,939
409,235
0.21
13 CHECK UP
4,620,402
5,656,540
(1,036,138)
(0.18)
13 CHECK UP
4,620,402
5,656,540
(1,036,138)
(0.18)
14 Eye
1,197,895
1,022,270
175,625
0.17
14 Eye
1,197,895
1,022,270
175,625
0.17
15 ENT
1,119,111
1,082,993
36,118
0.03
15 ENT
1,119,111
1,082,993
36,118
0.03
16 Skin
927,849
962,955
(35,106)
(0.04)
16 Skin
927,849
962,955
(35,106)
(0.04) 0.02
17 Psychiatry
730,618
719,377
11,241
0.02
17 Psychiatry
730,618
719,377
11,241
18 HD
2,307,621
2,182,721
124,900
0.06
18 HD
2,307,621
2,182,721
124,900
0.06
19 PT
283,705
285,817
(2,112)
(0.01)
19 PT
283,705
285,817
(2,112)
(0.01)
20 PCC
1,348,438
4,645,960
(3,297,522)
(0.71)
20 PCC
1,348,438
4,645,960
(3,297,522)
(0.71)
21 Other
3,837,431
3,106,027
731,403
0.24
21 Other
3,837,431
3,106,027
731,403
0.24
64,860,045
62,164,296
(2,791,240)
0.04
64,860,045
62,164,296
(2,791,240)
0.04
Actual
Target
Total
Total
Cumulative Volume projection Jan - April 2007 Volume 1
Dental
Actual #REF!
Diff target
Target #REF!
#REF!
March 2007
% Diff Target #REF!
Volume 3
General medicine
8,913,578
4,157,992
Diff target 4,755,586
% Diff Target 1.14
2
MSK
#REF!
#REF!
#REF!
#REF!
1
Dental
7,568,029
7,926,813
(358,784)
3
General medicine
#REF!
#REF!
#REF!
#REF!
2
MSK
5,228,283
4,069,996
1,158,287
0.28
4
Cardiology
#REF!
#REF!
#REF!
#REF!
4
Cardiology
4,531,775
4,708,123
(176,348)
(0.04)
5
GI System
#REF!
#REF!
#REF!
#REF!
5
GI System
3,509,376
3,336,477
172,900
0.05
6
Pulmonary Disease
#REF!
#REF!
#REF!
#REF!
6
Pulmonary Disease
2,471,807
2,392,791
79,016
0.03
7
Endocrine & Metabolism
#REF!
#REF!
#REF!
#REF!
7
Endocrine & Metabolism
2,537,889
2,617,920
(80,031)
(0.03)
8
Pediatrics
#REF!
#REF!
#REF!
#REF!
8
Pediatrics
1,589,183
1,794,573
(205,390)
(0.11)
9
ER
#REF!
#REF!
#REF!
#REF!
9
ER
2,018,068
1,971,465
46,603
0.02
10
Women Center
#REF!
#REF!
#REF!
#REF!
10 Women Center
2,801,509
1,966,395
835,114
0.42
11
Neurology
#REF!
#REF!
#REF!
#REF!
11 Neurology
4,991,305
5,640,152
(648,847)
(0.12)
12
Surgery
#REF!
#REF!
#REF!
#REF!
12 Surgery
2,326,174
1,916,939
409,235
0.21
13
CHECK UP
#REF!
#REF!
#REF!
#REF!
13 CHECK UP
4,620,402
5,656,540
(1,036,138)
(0.18)
14
Eye
#REF!
#REF!
#REF!
#REF!
14 Eye
1,197,895
1,022,270
175,625
0.17
15
ENT
#REF!
#REF!
#REF!
#REF!
15 ENT
1,119,111
1,082,993
36,118
0.03
16
Skin
#REF!
#REF!
#REF!
#REF!
16 Skin
927,849
962,955
(35,106)
(0.04)
17
Psychiatry
#REF!
#REF!
#REF!
#REF!
17 Psychiatry
730,618
719,377
11,241
0.02
18
HD
#REF!
#REF!
#REF!
#REF!
18 HD
2,307,621
2,182,721
124,900
0.06
19
PT
#REF!
#REF!
#REF!
#REF!
19 PT
283,705
285,817
(2,112)
(0.01)
20
PCC
#REF!
#REF!
#REF!
#REF!
20 PCC
1,348,438
4,645,960
(3,297,522)
(0.71)
21
Other
#REF!
#REF!
#REF!
#REF!
21 Other
3,837,431
3,106,027
731,403
0.24
#REF!
#REF!
#REF!
#REF!
64,860,045
62,164,296
(2,791,240)
0.04
Total
Total
(0.05)
January 2007 Volume
IPPD January 2007 Actual
1
General medicine
2
Dental
6,310,247
3
MSK
4,765,763
4
Cardiology
3,926,594
5
GI System
6
Target 5,190,542
Diff target
% Diff Target % Within OPD
Volume
1,330,345
0.26
2.90
1
6,281,278
28,969
0.00
215.82
2
3,850,306
915,457
0.24
3.21
3
5,337,072
(1,410,477)
(0.26)
(4.78)
4
3,973,182
3,768,227
204,955
0.05
17.39
5
Pulmonary Disease
2,440,062
2,940,838
(500,776)
(0.17)
(6.87)
6
7
Endocrine & Metabolism
2,573,927
2,847,262
(273,334)
(0.10)
(11.42)
7
8
Pediatrics
2,152,957
2,190,258
(37,301)
(0.02)
(59.72)
8
9
ER
2,013,327
1,982,839
30,488
0.02
64.04
9
10
Women Center
2,197,660
1,771,972
425,688
0.24
3.16
10
11
Neurology
4,476,238
5,189,297
(713,059)
(0.14)
(8.28)
11
12
Surgery
2,051,782
1,918,446
133,335
0.07
13.39
12
13
CHECK UP
3,928,461
3,823,011
105,450
0.03
35.25
13
14
Eye
988,728
1,005,283
(16,555)
(0.02)
(61.72)
14
15
ENT
1,128,765
1,214,680
(85,915)
(0.07)
(15.14)
15
16
Skin
1,055,420
867,352
188,068
0.22
3.61
17
Psychiatry
704,617
614,602
90,015
0.15
5.83
18
HD
2,352,544
2,000,075
352,469
0.18
4.67
19
PT
335,813
315,404
20,410
0.06
14.45
20
PCC
21
Other Total
6,520,886
Actual 587 300 228 386 300 152 373 155 121 383 46 26 3 10 3,070
Target 587 300 228 386 300 152 373 155 121 383 46 26 3 10 3,070
4,217 1.37
879,871
1,387,833
(507,962)
(0.37)
(3.73)
59,617,947
3,823,373
2,861,190
962,183
0.34
1.97
50,492,503
52,079,333
52,167,225
(1,050,075)
(0.00)
(50.68)
55,139,965
February 2007 Volume
General medicine MSK Cardiology GI System Pulmonary Disease Endocrine & Metabolism Pediatrics Women Center Neurology Surgery Eye ENT Skin Psychiatry Total
February 2007 Actual
1
General medicine
5,372,862
2
Dental
3
MSK
4
Cardiology
3,490,227
Target
Diff target
% Diff Target % Diff Target
Volume
Actual
Target
4,680,501
692,361
0.15
5.76
1
Dental
#REF!
#REF!
5,817,556
6,711,231
(893,675)
(0.13)
(8.51)
2
MSK
#REF!
#REF!
4,036,753
3,877,096
159,657
0.04
23.28
3
General medicine
#REF!
#REF!
4,247,365
(757,138)
(0.18)
(6.61)
4
Cardiology
#REF!
#REF!
5
GI System
3,794,243
4,219,384
(425,141)
(0.10)
(10.92)
5
GI System
#REF!
#REF!
6
Pulmonary Disease
2,209,844
2,479,712
(269,868)
(0.11)
(10.19)
6
Pulmonary Disease
#REF!
#REF!
7
Endocrine & Metabolism
1,847,383
2,455,023
(607,640)
(0.25)
(5.04)
7
Endocrine & Metabolism
#REF!
#REF!
8
Pediatrics
1,644,405
1,852,453
(208,048)
(0.11)
(9.90)
8
Pediatrics
#REF!
#REF!
9
ER
1,693,070
1,763,377
(70,307)
(0.04)
(26.08)
9
ER
#REF!
#REF!
10
Women Center
2,574,019
1,966,043
607,977
0.31
2.23
10 Women Center
#REF!
#REF!
11
Neurology
4,070,239
5,527,928
(1,457,689)
(0.26)
(4.79)
11 Neurology
#REF!
#REF!
12
Surgery
1,908,377
1,781,931
126,446
0.07
13.09
12 Surgery
#REF!
#REF!
13
CHECK UP
3,614,321
4,650,785
(1,036,464)
(0.22)
(5.49)
13 CHECK UP
#REF!
#REF!
14
Eye
882,636
968,632
(85,996)
(0.09)
(12.26)
14 Eye
#REF!
#REF!
15
ENT
1,099,576
1,163,690
(64,114)
(0.06)
(19.15)
15 ENT
#REF!
#REF!
16
Skin
879,415
879,711
(296)
(0.00)
(2,973.00)
16 Skin
#REF!
#REF!
17
Psychiatry
639,204
533,949
105,255
0.20
4.07
17 Psychiatry
#REF!
#REF!
18
HD
1,969,187
1,939,236
29,951
0.02
63.75
18 HD
#REF!
#REF!
19
PT
205,852
268,365
(62,514)
(0.23)
(5.29)
19 PT
#REF!
#REF!
20
PCC
2,120,406
4,105,837
(1,985,432)
(0.48)
(3.07)
20 PCC
#REF!
#REF!
21
Other
3,543,982
2,760,652
783,330
0.28
2.52
#REF!
#REF!
48,040,695
54,152,400
(6,895,035)
(0.11)
(8.85)
#REF!
#REF!
Total
21
Total
March 2007 Volume
Other
March 2007 Actual
Target
Diff target
% Diff Target % Diff Target
Volume
Actual
Target
3
General medicine
8,913,578
4,157,992
4,755,586
1.14
(0.13)
3
General medicine
8,913,578
1
Dental
7,568,029
7,926,813
(358,784)
(0.05)
(23.09)
1
Dental
7,568,029
4,157,992 7,926,813
2
MSK
5,228,283
4,069,996
1,158,287
0.28
2.51
2
MSK
5,228,283
4,069,996
4
Cardiology
4,531,775
4,708,123
(176,348)
(0.04)
(27.70)
4
Cardiology
4,531,775
4,708,123
5
GI System
3,509,376
3,336,477
172,900
0.05
18.30
5
GI System
3,509,376
3,336,477
6
Pulmonary Disease
2,471,807
2,392,791
79,016
0.03
29.28
6
Pulmonary Disease
2,471,807
2,392,791
7
Endocrine & Metabolism
2,537,889
2,617,920
(80,031)
(0.03)
(33.71)
7
Endocrine & Metabolism
2,537,889
2,617,920
8
Pediatrics
1,589,183
1,794,573
(205,390)
(0.11)
(9.74)
8
Pediatrics
1,589,183
1,794,573
9
ER
2,018,068
1,971,465
46,603
0.02
41.30
9
ER
2,018,068
1,971,465
10 Women Center
2,801,509
1,966,395
835,114
0.42
1.35
10 Women Center
2,801,509
1,966,395
11 Neurology
4,991,305
5,640,152
(648,847)
(0.12)
(9.69)
11 Neurology
4,991,305
5,640,152
12 Surgery
2,326,174
1,916,939
409,235
0.21
3.68
12 Surgery
2,326,174
1,916,939
13 CHECK UP
4,620,402
5,656,540
(1,036,138)
(0.18)
(6.46)
13 CHECK UP
4,620,402
5,656,540
14 Eye
1,197,895
1,022,270
175,625
0.17
4.82
14 Eye
1,197,895
1,022,270
15 ENT
1,119,111
1,082,993
36,118
0.03
28.98
15 ENT
1,119,111
1,082,993
16 Skin
927,849
962,955
(35,106)
(0.04)
(28.43)
16 Skin
927,849
962,955
17 Psychiatry 18 HD 19 PT 20 PCC 21 Other Total
730,618
719,377
11,241
0.02
63.00
17 Psychiatry
2,307,621
2,182,721
124,900
0.06
16.48
18 HD 19 PT
283,705
285,817
(2,112)
(0.01)
(136.33)
1,348,438
4,645,960
(3,297,522)
(0.71)
(2.41)
3,837,431
3,106,027
731,403
0.24
3.25
64,860,045
62,164,296
(2,791,240)
0.04
(23.27)
20 PCC 21 Other Total
April 2007 Volume
730,618
719,377
2,307,621
2,182,721
283,705
285,817
1,348,438
4,645,960
3,837,431
3,106,027
64,860,045
62,164,296
April 2007 Actual
Diff target
Target
% Diff Target % Diff Target
Volume
Actual
Target
3
General medicine
8,913,578
4,157,992
4,755,586
1.14
(0.13)
3
General medicine
8,913,578
1
Dental
7,568,029
7,926,813
(358,784)
(0.05)
(23.09)
1
Dental
7,568,029
7,926,813
2
MSK
5,228,283
4,069,996
1,158,287
0.28
2.51
2
MSK
5,228,283
4,069,996
4
Cardiology
4,531,775
4,708,123
(176,348)
(0.04)
(27.70)
4
Cardiology
4,531,775
4,708,123
5
GI System
3,509,376
3,336,477
172,900
0.05
18.30
5
GI System
3,509,376
3,336,477
6
Pulmonary Disease
2,471,807
2,392,791
79,016
0.03
29.28
6
Pulmonary Disease
2,471,807
2,392,791
7
Endocrine & Metabolism
2,537,889
2,617,920
(80,031)
(0.03)
(33.71)
7
Endocrine & Metabolism
2,537,889
2,617,920
8
Pediatrics
1,589,183
1,794,573
(205,390)
(0.11)
(9.74)
8
Pediatrics
1,589,183
1,794,573
9
ER
2,018,068
1,971,465
46,603
0.02
41.30
9
ER
2,018,068
1,971,465
10 Women Center
2,801,509
1,966,395
835,114
0.42
1.35
10 Women Center
2,801,509
1,966,395
11 Neurology
4,991,305
5,640,152
(648,847)
(0.12)
(9.69)
11 Neurology
4,991,305
5,640,152
12 Surgery
2,326,174
1,916,939
409,235
0.21
3.68
12 Surgery
2,326,174
1,916,939
13 CHECK UP
4,620,402
5,656,540
(1,036,138)
(0.18)
(6.46)
13 CHECK UP
4,620,402
5,656,540
14 Eye
1,197,895
1,022,270
175,625
0.17
4.82
14 Eye
1,197,895
1,022,270
15 ENT
1,119,111
1,082,993
36,118
0.03
28.98
15 ENT
1,119,111
1,082,993
16 Skin
927,849
962,955
(35,106)
(0.04)
(28.43)
16 Skin
927,849
962,955
17 Psychiatry 18 HD 19 PT 20 PCC 21 Other Total
730,618
719,377
11,241
0.02
63.00
17 Psychiatry
2,307,621
2,182,721
124,900
0.06
16.48
18 HD 19 PT
283,705
285,817
(2,112)
(0.01)
(136.33)
1,348,438
4,645,960
(3,297,522)
(0.71)
(2.41)
3,837,431
3,106,027
731,403
0.24
3.25
64,860,045
62,164,296
(2,791,240)
0.04
(23.27)
20 PCC 21 Other Total
Cumulative Volume projection Jan - April 2007 Volume 1
Dental
Actual #REF!
Diff target
Target #REF!
#REF!
4,157,992
730,618
719,377
2,307,621
2,182,721
283,705
285,817
1,348,438
4,645,960
3,837,431
3,106,027
64,860,045
62,164,296
March 2007
% Diff Target % Diff Target #REF!
#REF!
Volume 3
General medicine
Actual 8,913,578
Target 4,157,992
2
MSK
#REF!
#REF!
#REF!
#REF!
#REF!
1
Dental
7,568,029
7,926,813
3
General medicine
#REF!
#REF!
#REF!
#REF!
#REF!
2
MSK
5,228,283
4,069,996
4
Cardiology
#REF!
#REF!
#REF!
#REF!
#REF!
4
Cardiology
4,531,775
4,708,123
5
GI System
#REF!
#REF!
#REF!
#REF!
#REF!
5
GI System
3,509,376
3,336,477
6
Pulmonary Disease
#REF!
#REF!
#REF!
#REF!
#REF!
6
Pulmonary Disease
2,471,807
2,392,791
7
Endocrine & Metabolism
#REF!
#REF!
#REF!
#REF!
#REF!
7
Endocrine & Metabolism
2,537,889
2,617,920
8
Pediatrics
#REF!
#REF!
#REF!
#REF!
#REF!
8
Pediatrics
1,589,183
1,794,573
9
ER
#REF!
#REF!
#REF!
#REF!
#REF!
9
ER
2,018,068
1,971,465
10
Women Center
#REF!
#REF!
#REF!
#REF!
#REF!
10 Women Center
2,801,509
1,966,395
11
Neurology
#REF!
#REF!
#REF!
#REF!
#REF!
11 Neurology
4,991,305
5,640,152
12
Surgery
#REF!
#REF!
#REF!
#REF!
#REF!
12 Surgery
2,326,174
1,916,939
13
CHECK UP
#REF!
#REF!
#REF!
#REF!
#REF!
13 CHECK UP
4,620,402
5,656,540
14
Eye
#REF!
#REF!
#REF!
#REF!
#REF!
14 Eye
1,197,895
1,022,270
15
ENT
#REF!
#REF!
#REF!
#REF!
#REF!
15 ENT
1,119,111
1,082,993
16
Skin
#REF!
#REF!
#REF!
#REF!
#REF!
16 Skin
927,849
962,955
17
Psychiatry
#REF!
#REF!
#REF!
#REF!
#REF!
17 Psychiatry
730,618
719,377
18
HD
#REF!
#REF!
#REF!
#REF!
#REF!
18 HD
2,307,621
2,182,721
19
PT
#REF!
#REF!
#REF!
#REF!
#REF!
19 PT
20
PCC
#REF!
#REF!
#REF!
#REF!
#REF!
20 PCC
21
Other
#REF!
#REF!
#REF!
#REF!
#REF!
21 Other
#REF!
#REF!
#REF!
#REF!
#REF!
Total
Total
283,705
285,817
1,348,438
4,645,960
3,837,431
3,106,027
64,860,045
62,164,296
Diff target 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
% Diff Target % Within OPD 0.00 19.1% 0.00 9.8% 0.00 7.4% 0.00 12.6% 0.00 9.8% 0.00 5.0% 0.00 12.1% 0.00 5.0% 0.00 3.9% 0.00 12.5% 0.00 1.5% 0.00 0.8% 0.00 0.1% 0.00 0.3% 0.00 100.0% General medicine 806 412 MSK 313 Cardiology 530 GI System Pulmonary Disease412 209 Endocrine & Metabolism 512 Pediatrics 213 Women Center 166 Neurology 526 Surgery 63 Eye 36 ENT 4 Skin Psychiatry Total
Diff target
% Diff Target
% Diff Target
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
14 4,217
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
Diff target
% Diff Target
% Diff Target
4,755,586
1.14
(0.13)
(358,784)
(0.05)
(23.09)
1,158,287
0.28
2.51
(176,348)
(0.04)
(27.70)
172,900
0.05
18.30
79,016
0.03
29.28
(80,031)
(0.03)
(33.71)
(205,390)
(0.11)
(9.74)
46,603
0.02
41.30
835,114
0.42
1.35
(648,847)
(0.12)
(9.69)
409,235
0.21
3.68
(1,036,138)
(0.18)
(6.46)
175,625
0.17
4.82
36,118
0.03
28.98
(35,106)
(0.04)
(28.43)
11,241
0.02
124,900
0.06
16.48
(2,112)
(0.01)
(136.33)
(3,297,522)
(0.71)
(2.41)
731,403
0.24
3.25
(2,791,240)
0.04
(23.27)
Diff target
% Diff Target
63.00
% Diff Target
4,755,586
1.14
(0.13)
(358,784)
(0.05)
(23.09)
1,158,287
0.28
2.51
(176,348)
(0.04)
(27.70)
172,900
0.05
18.30
79,016
0.03
29.28
(80,031)
(0.03)
(33.71)
(205,390)
(0.11)
(9.74)
46,603
0.02
41.30
835,114
0.42
1.35
(648,847)
(0.12)
(9.69)
409,235
0.21
3.68
(1,036,138)
(0.18)
(6.46)
175,625
0.17
4.82
36,118
0.03
28.98
(35,106)
(0.04)
(28.43) 63.00
11,241
0.02
124,900
0.06
16.48
(2,112)
(0.01)
(136.33)
(3,297,522)
(0.71)
(2.41)
731,403
0.24
3.25
(2,791,240)
0.04
(23.27)
Diff target 4,755,586
% Diff Target 1.14
% Diff Target (0.13)
(358,784)
(0.05)
1,158,287
0.28
(23.09) 2.51
(176,348)
(0.04)
(27.70)
172,900
0.05
18.30
79,016
0.03
29.28
(80,031)
(0.03)
(33.71)
(205,390)
(0.11)
(9.74)
46,603
0.02
41.30
835,114
0.42
1.35
(648,847)
(0.12)
(9.69)
409,235
0.21
3.68
(1,036,138)
(0.18)
(6.46)
175,625
0.17
4.82
36,118
0.03
28.98
(35,106)
(0.04)
(28.43)
11,241
0.02
63.00
124,900
0.06
16.48
(2,112)
(0.01)
(136.33)
(3,297,522)
(0.71)
(2.41)
731,403
0.24
3.25
(2,791,240)
0.04
(23.27)
General medicine
8,454,539
MSK
5,908,252
Cardiology
5,492,093
GI System
5,970,482
Pulmonary Disease
3,477,329
Endocrine & Metabolism
2,906,974
Pediatrics
3,493,020
Women Center
3,338,217
Neurology
6,404,779
Surgery
8,216,594
Eye
355,153
ENT
326,415
Skin
879,415
Psychiatry Other
43,964 3,543,982
January 2007 OPD Volume
January 2007 IPD Actual
Target
Diff target
% Diff Target
% Within OPD
Volume
Actual
1
General medicine
6,309,891
5,190,542
1,119,350
0.22
10.8%
1
General medicine
2
Dental
6,310,247
6,281,278
28,969
0.00
10.8%
2
3
MSK
4,765,763
3,850,306
915,457
0.24
8.2%
4
Cardiology
3,926,594
5,337,072
(1,410,477)
(0.26)
5
GI System
3,973,182
3,768,227
204,955
6
Pulmonary Disease
2,440,062
2,940,838
7
Endocrine & Metabolism
2,573,927
8
Pediatrics
9
Target
11,998,521
11,998,521
MSK
5,908,252
5,908,252
3
Cardiology
5,492,093
5,492,093
6.7%
4
GI System
5,970,482
5,970,482
0.05
6.8%
5
Pulmonary Disease
3,477,329
3,477,329
(500,776)
(0.17)
4.2%
6
Endocrine & Metabolism
2,906,974
2,906,974
2,847,262
(273,334)
(0.10)
4.4%
7
Pediatrics
3,493,020
3,493,020
2,152,957
2,190,258
(37,301)
(0.02)
3.7%
8
Women Center
3,338,217
3,338,217
ER
2,013,327
1,982,839
30,488
0.02
3.4%
9
Neurology
6,404,779
6,404,779
10
Women Center
2,197,660
1,771,972
425,688
0.24
3.8%
10 Surgery
8,216,594
8,216,594
11
Neurology
4,476,238
5,189,297
(713,059)
(0.14)
7.7%
11 Eye
355,153
355,153
12
Surgery
2,051,782
1,918,446
133,335
0.07
3.5%
12 ENT
326,415
326,415
13
CHECK UP
3,928,461
3,823,011
105,450
0.03
6.7%
13 Skin
879,415
879,415
14
Eye
988,728
1,005,283
(16,555)
(0.02)
1.7%
14 Psychiatry
43,964
43,964
15
ENT
1,128,765
1,214,680
(85,915)
(0.07)
1.9%
15 Total
58,811,208
Err:522
16
Skin
1,055,420
867,352
188,068
0.22
1.8%
17
Psychiatry
704,617
614,602
90,015
0.15
1.2%
18
HD
2,352,544
2,000,075
352,469
0.18
4.0%
19
PT
335,813
315,404
20,410
0.06
0.6%
50,492,503
20
PCC
879,871
1,387,833
(507,962)
(0.37)
1.5%
55,139,965
21
Other
3,823,373
643,388
3,179,985
4.94
6.5%
58,389,224
55,139,965
3,249,259
0.06
100.0%
Total
61,059,420
59,617,947
59,617,947
February 2007 Volume
February 2007 Actual
Target
Diff target
% Diff Target
Volume
% Diff Target
1
General medicine
5,372,862
4,680,501
692,361
0.15
5.76
1
General medicine
2
Dental
5,817,556
6,711,231
(893,675)
(0.13)
(8.51)
2
3
MSK
4,036,753
3,877,096
159,657
0.04
23.28
4
Cardiology
3,490,227
4,247,365
(757,138)
(0.18)
5
GI System
3,794,243
4,219,384
(425,141)
6
Pulmonary Disease
2,209,844
2,479,712
7
Endocrine & Metabolism
1,847,383
8
Pediatrics
9
Actual
Target
11,998,521
11,998,521
MSK
5,908,252
5,908,252
3
Cardiology
5,492,093
5,492,093
(6.61)
4
GI System
5,970,482
5,970,482
(0.10)
(10.92)
5
Pulmonary Disease
3,477,329
3,477,329
(269,868)
(0.11)
(10.19)
6
Endocrine & Metabolism
2,906,974
2,906,974
2,455,023
(607,640)
(0.25)
(5.04)
7
Pediatrics
3,493,020
3,493,020
1,644,405
1,852,453
(208,048)
(0.11)
(9.90)
8
Women Center
3,338,217
3,338,217
ER
1,693,070
1,763,377
(70,307)
(0.04)
(26.08)
9
Neurology
6,404,779
6,404,779
10
Women Center
2,574,019
1,966,043
607,977
0.31
2.23
8,216,594
8,216,594
11
Neurology
4,070,239
5,527,928
(1,457,689)
(0.26)
(4.79)
11 Eye
355,153
355,153
12
Surgery
1,908,377
1,781,931
126,446
0.07
13.09
12 ENT
326,415
326,415
13
CHECK UP
3,614,321
4,650,785
(1,036,464)
(0.22)
(5.49)
13 Skin
879,415
879,415
14
Eye
882,636
968,632
(85,996)
(0.09)
(12.26)
14 Psychiatry
43,964
43,964
15
ENT
1,099,576
1,163,690
(64,114)
(0.06)
(19.15)
15 Total
Err:522
Err:522
16
Skin
879,415
879,711
(296)
(0.00)
(2,973.00)
17
Psychiatry
639,204
533,949
105,255
0.20
4.07
18
HD
1,969,187
1,939,236
29,951
0.02
63.75
19
PT
205,852
268,365
(62,514)
(0.23)
(5.29)
20
PCC
2,120,406
4,105,837
(1,985,432)
(0.48)
(3.07)
10 Surgery
51,335,389
21
Other Total
3,543,982
2,760,652
783,330
0.28
2.52
53,413,558
58,832,901
(5,419,344)
(0.09)
(11.86)
52,754,123
March 2007 Volume
March 2007 Actual
Target
Diff target
% Diff Target
Volume
% Diff Target
Actual
Target
1
General medicine
8,913,578
4,157,992
4,755,586
1.14
(0.13)
1
General medicine
9,681,253
9,681,253
2
Dental
7,568,029
7,926,813
(358,784)
(0.05)
(23.09)
2
MSK
7,154,348
7,154,348
3
MSK
5,228,283
4,069,996
1,158,287
0.28
2.51
3
Cardiology
4,167,600
4,167,600
4
Cardiology
4,531,775
4,708,123
(176,348)
(0.04)
(27.70)
4
GI System
5,498,533
5,498,533
5
GI System
3,509,376
3,336,477
172,900
0.05
18.30
5
Pulmonary Disease
4,491,306
4,491,306
6
Pulmonary Disease
2,471,807
2,392,791
79,016
0.03
29.28
6
Endocrine & Metabolism
1,421,269
1,421,269
7
Endocrine & Metabolism
2,537,889
2,617,920
(80,031)
(0.03)
(33.71)
7
Pediatrics
1,939,151
1,939,151
8
Pediatrics
1,589,183
1,794,573
(205,390)
(0.11)
(9.74)
8
Women Center
3,125,877
3,125,877
9
ER
2,018,068
1,971,465
46,603
0.02
41.30
9
Neurology
10,218,026
10,218,026
10
Women Center
2,801,509
1,966,395
835,114
0.42
1.35
11,052,341
11,052,341
11
Neurology
4,991,305
5,640,152
(648,847)
(0.12)
(9.69)
11 Eye
3,614,321
3,614,321
12
Surgery
2,326,174
1,916,939
409,235
0.21
3.68
12 ENT
588,485
588,485
13
CHECK UP
4,620,402
5,656,540
(1,036,138)
(0.18)
(6.46)
13 Skin
584,907
584,907
14
Eye
1,197,895
1,022,270
175,625
0.17
4.82
14 Psychiatry
21,229
21,229
15
ENT
1,119,111
1,082,993
36,118
0.03
28.98
Others
182,489
182,489
16
Skin
927,849
962,955
(35,106)
(0.04)
(28.43)
63,741,135
63,741,135
17
Psychiatry
730,618
719,377
11,241
0.02
63.00
18
HD
2,307,621
2,182,721
124,900
0.06
16.48
19
PT
283,705
285,817
(2,112)
(0.01)
(136.33)
10 Surgery
Total
60,330,477
20
PCC
1,348,438
4,645,960
(3,297,522)
(0.71)
(2.41)
21
Other
3,837,431
3,106,027
731,403
0.24
3.25
64,860,045
62,164,296
2,695,749
0.04
22.06
Total
65,189,898
Cumulative Revenue OPD Jan - March 2007 Volume
Actual
Target
Cumulative Revenue OPD Jan - March 2007
Diff target
% Diff Target
% Diff Target
Volume
Actual
Target
1
General medicine
20,596,331
14,029,035
6,567,297
0.47
1.14
1
General medicine
5,372,862
4,680,501
2
Dental
19,695,832
20,919,322
(1,223,490)
(0.06)
(18.10)
2
Dental
5,817,556
6,711,231
3
MSK
14,030,799
11,797,397
2,233,402
0.19
4.28
3
MSK
4,036,753
3,877,096
4
Cardiology
11,948,596
14,292,560
(2,343,964)
(0.16)
(7.10)
4
Cardiology
3,490,227
4,247,365
5
GI System
11,276,802
11,324,088
(47,286)
(0.00)
(240.48)
5
GI System
3,794,243
4,219,384
6
Pulmonary Disease
7,121,713
7,813,341
(691,628)
(0.09)
(12.30)
6
Pulmonary Disease
2,209,844
2,479,712
7
Endocrine & Metabolism
6,959,200
7,920,205
(961,005)
(0.12)
(9.24)
7
Endocrine & Metabolism
1,847,383
2,455,023
8
Pediatrics
5,386,545
5,837,284
(450,739)
(0.08)
(13.95)
8
Pediatrics
1,644,405
1,852,453
9
ER
5,724,465
5,717,682
6,783
0.00
841.90
9
ER
1,693,070
1,763,377
10
Women Center
7,573,188
5,704,410
1,868,778
0.33
2.05
10 Women Center
2,574,019
1,966,043
11
Neurology
13,537,782
16,357,377
(2,819,595)
(0.17)
(6.80)
11 Neurology
4,070,239
5,527,928
12
Surgery
6,286,333
5,617,317
669,016
0.12
7.40
12 Surgery
1,908,377
1,781,931
13
CHECK UP
12,163,184
14,130,335
(1,967,151)
(0.14)
(8.18)
13 CHECK UP
3,614,321
4,650,785
14
Eye
3,069,259
2,996,185
73,074
0.02
40.00
14 Eye
882,636
968,632
15
ENT
3,347,452
3,461,363
(113,911)
(0.03)
(31.39)
15 ENT
1,099,576
1,163,690
16
Skin
2,862,684
2,710,018
152,666
0.06
16.75
16 Skin
879,415
879,711
17
Psychiatry
2,074,439
1,867,928
206,511
0.11
8.05
17 Psychiatry
639,204
533,949
18
HD
6,629,352
6,122,032
507,320
0.08
11.07
18 HD
1,969,187
1,939,236
19
PT
825,370
869,585
(44,216)
(0.05)
(20.67)
19 PT
205,852
268,365
20
PCC
4,348,715
10,139,631
(5,790,916)
(0.57)
(2.75)
21
Other
11,204,786
6,510,067
4,694,718
0.72
0.39
176,662,827
176,137,162
525,665
0.00
334.07
Total
20 PCC
2,120,406
4,105,837
21 Other
3,543,982
2,760,652
53,413,558
58,832,901
Total
January 2007 OPD + IPD Diff target
% Diff Target
% Within IPD
Volume
Actual
Target
Diff target
% Diff Target
18,308,412
17,189,063
1,119,350
0.07
6,310,247
6,281,278
28,969
0.00
10,674,015
3,850,306
6,823,709
1.77
0
0.00
20.4%
1
General medicine
0
0.00
10.0%
2
Dental
0
0.00
9.3%
3
MSK
0
0.00
10.2%
4
Cardiology
9,418,687
5,337,072
4,081,615
0.76
0
0.00
5.9%
5
GI System
9,943,664
3,768,227
6,175,437
1.64
0
0.00
4.9%
6
Pulmonary Disease
5,917,391
2,940,838
2,976,553
1.01
0
0.00
5.9%
7
Endocrine & Metabolism
5,480,901
2,847,262
2,633,639
0.92
0
0.00
5.7%
8
Pediatrics
5,645,977
2,190,258
3,455,719
1.58
0
0.00
10.9%
9
ER
2,013,327
1,982,839
30,488
0.02
0
0.00
14.0%
10
Women Center
5,535,877
1,771,972
3,763,905
2.12
0
0.00
0.6%
11
Neurology
10,881,017
5,189,297
5,691,720
1.10
0
0.00
0.6%
12
Surgery
10,268,376
1,918,446
8,349,929
4.35
0
0.00
1.5%
13
CHECK UP
3,928,461
3,823,011
105,450
0.03
0
0.00
0.1%
14
Eye
1,343,881
1,005,283
338,598
0.34
Err:522
Err:522
100.0%
15
ENT
1,455,180
1,214,680
240,500
0.20
16
Skin
1,934,835
867,352
1,067,483
1.23
17
Psychiatry
748,581
614,602
133,979
0.22
18
HD
2,352,544
2,000,075
352,469
0.18
19
PT
335,813
315,404
20,410
0.06
20
PCC
879,871
1,387,833
(507,962)
(0.37)
21
Other
3,823,373
2,861,190
962,183
0.34
117,200,432
69,356,288
47,844,144
0.69
Net Revenue
February 2007 OPD + IPD Diff target
% Diff Target
% Within IPD
Volume
Actual
Target
Diff target
% Diff Target
17,371,383
16,679,022
692,361
0.04
0
0.00
20.4%
1
General medicine
0
0.00
10.0%
2
Dental
6,310,247
6,281,278
28,969
0.00
0
0.00
9.3%
3
MSK
9,945,005
3,850,306
6,094,699
1.58
0
0.00
10.2%
4
Cardiology
8,982,320
5,337,072
3,645,248
0.68
0
0.00
5.9%
5
GI System
9,764,725
3,768,227
5,996,498
1.59
0
0.00
4.9%
6
Pulmonary Disease
5,687,173
2,940,838
2,746,335
0.93
0
0.00
5.9%
7
Endocrine & Metabolism
4,754,357
2,847,262
1,907,095
0.67
0
0.00
5.7%
8
Pediatrics
5,137,425
2,190,258
2,947,167
1.35
0
0.00
10.9%
9
ER
2,013,327
1,982,839
30,488
0.02
0
0.00
14.0%
10
Women Center
5,912,237
1,771,972
4,140,264
2.34
0
0.00
0.6%
11
Neurology
10,475,019
5,189,297
5,285,722
1.02
0
0.00
0.6%
12
Surgery
10,124,971
1,918,446
8,206,525
4.28
0
0.00
1.5%
13
CHECK UP
3,928,461
3,823,011
105,450
0.03
0
0.00
0.1%
14
Eye
1,237,789
1,005,283
232,506
0.23
Err:522
Err:522
Err:522
15
ENT
1,425,991
1,214,680
211,311
0.17
16
Skin
1,758,830
867,352
891,478
1.03
17
Psychiatry
683,168
614,602
68,566
0.11
18
HD
2,352,544
2,000,075
352,469
0.18
19
PT
335,813
315,404
20,410
0.06
20
PCC
879,871
1,387,833
(507,962)
(0.37)
21
Other Total
3,823,373
2,861,190
962,183
0.34
112,904,030
68,846,247
44,057,782
0.64
March 2007 Diff target
% Diff Target
% Within IPD
Volume
Actual
Diff target
% Diff Target
% Diff Target
9,681,253
#REF!
#REF!
#REF!
5,817,556
#REF!
#REF!
#REF!
MSK
7,154,348
#REF!
#REF!
#REF!
4
Cardiology
4,167,600
#REF!
#REF!
#REF!
7.0%
5
GI System
5,498,533
#REF!
#REF!
#REF!
0
2.2%
6
Pulmonary Disease
4,491,306
#REF!
#REF!
#REF!
0
0
3.0%
7
Endocrine & Metabolism
1,421,269
#REF!
#REF!
#REF!
0
0
4.9%
8
Pediatrics
1,939,151
#REF!
#REF!
#REF!
0
0
16.0%
9
ER
1,693,070
#REF!
#REF!
#REF!
0
0
17.3%
10
Women Center
3,125,877
#REF!
#REF!
#REF!
0
0
5.7%
11
Neurology
10,218,026
#REF!
#REF!
#REF!
0
0
0.9%
12
Surgery
11,052,341
#REF!
#REF!
#REF!
0
0
0.9%
13
CHECK UP
3,614,321
#REF!
#REF!
#REF!
0
0
0.0%
14
Eye
588,485
#REF!
#REF!
#REF!
0
0
0.3%
15
ENT
584,907
#REF!
#REF!
#REF!
0
0
100.0%
16
Skin
21,229
#REF!
#REF!
#REF!
17
Psychiatry
18 19
0
0
15.2%
1
General medicine
0
0
11.2%
2
Dental
0
0
6.5%
3
0
0
8.6%
0
0
0
251,872
533,949
(282,077)
(0.53)
(2.89)
HD
1,969,187
1,939,236
29,951
0.02
63.75
PT
205,852
268,365
(62,514)
(0.23)
(5.29)
20
PCC
2,120,406
4,105,837
(1,985,432)
(0.48)
(3.07)
21
Other
182,489
2,760,652
(2,578,163)
(0.93)
(2.07)
75,799,077
9,608,039
66,191,038
6.89
(0.85)
Total
2007 Diff target
% Diff Target
% Diff Target
692,361
0.15
5.76
(893,675)
(0.13)
(8.51)
159,657
0.04
23.28
(757,138)
(0.18)
(6.61)
(425,141)
(0.10)
(10.92)
(269,868)
(0.11)
(10.19)
(607,640)
(0.25)
(5.04)
(208,048)
(0.11)
(9.90)
(70,307)
(0.04)
(26.08)
607,977
0.31
2.23
(1,457,689)
(0.26)
(4.79)
126,446
0.07
13.09
(1,036,464)
(0.22)
(5.49)
(85,996)
(0.09)
(12.26)
(64,114)
(0.06)
(19.15)
(296)
(0.00)
(2,973.00)
105,255
0.20
4.07
29,951
0.02
63.75
(62,514)
(0.23)
(5.29)
(1,985,432)
(0.48)
(3.07)
783,330
0.28
2.52
(5,419,344)
(0.09)
(11.86)
January 2007 Actual
Target
Diff target
% Diff Target
Volume
1
General medicine
6,520,886
5,190,542
1,330,345
0.26
1
2
Dental
6,310,247
6,281,278
28,969
0.00
2
3
MSK
4,765,763
3,850,306
915,457
0.24
3
4
Cardiology
3,926,594
5,337,072
(1,410,477)
(0.26)
4
5
GI System
3,973,182
3,768,227
204,955
0.05
5
6
Pulmonary Disease
2,440,062
2,940,838
(500,776)
(0.17)
6
7
Endocrine & Metabolism
2,573,927
2,847,262
(273,334)
(0.10)
7
8
Pediatrics
2,152,957
2,190,258
(37,301)
(0.02)
8
9
ER
2,013,327
1,982,839
30,488
0.02
9
10
Women Center
2,197,660
1,771,972
425,688
0.24
10
11
Neurology
4,476,238
5,189,297
(713,059)
(0.14)
11
12
Surgery
2,051,782
1,918,446
133,335
0.07
12
13
CHECK UP
3,928,461
3,823,011
105,450
0.03
13
14
Eye
988,728
1,005,283
(16,555)
(0.02)
14
15
ENT
1,128,765
1,214,680
(85,915)
(0.07)
15
16
Skin
1,055,420
867,352
188,068
0.22
17
Psychiatry
704,617
614,602
90,015
0.15
18
HD
2,352,544
2,000,075
352,469
0.18
19
PT
335,813
315,404
20,410
0.06
20
PCC
879,871
1,387,833
(507,962)
(0.37)
21
Other Total
3,823,373
2,861,190
962,183
0.34
58,600,219
57,357,767
1,242,452
0.02
February 2007 Volume
General medicine MSK Cardiology GI System Pulmonary Disease Endocrine & Metabolism Pediatrics Women Center Neurology Surgery Eye ENT Skin Psychiatry Total
Actual
11,998,521 5,908,252 5,492,093 5,970,482 3,477,329 2,906,974 3,493,020 3,338,217 6,404,779 8,216,594 355,153 326,415 879,415 43,964 58,811,208
Target
Diff target
% Diff Target
4,680,501
7,318,020
1.56
6,711,231
(802,979)
(0.12)
3,877,096
1,614,997
0.42
4,247,365
1,723,117
0.41
4,219,384
(742,055)
(0.18)
2,479,712
427,262
0.17
2,455,023
1,037,997
0.42
1,852,453
1,485,764
0.80
1,763,377
4,641,402
2.63
1,966,043
6,250,551
3.18
5,527,928
(5,172,775)
(0.94)
1,781,931
(1,455,516)
(0.82)
4,650,785
(3,771,370)
(0.81)
968,632
(924,668)
(0.95)
1,163,690
57,647,518
49.54
February 2007 Actual
1
General medicine
5,372,862
2
Dental
3
MSK
4
Cardiology
3,490,227
Target
Diff target
% Diff Target
Volume
Actual
Target
Diff target
% Diff Target
4,680,501
692,361
0.15
1
Dental
#REF!
#REF!
#REF!
#REF!
5,817,556
6,711,231
(893,675)
(0.13)
2
MSK
#REF!
#REF!
#REF!
#REF!
4,036,753
3,877,096
159,657
0.04
3
General medicine
#REF!
#REF!
#REF!
#REF!
4,247,365
(757,138)
(0.18)
4
Cardiology
#REF!
#REF!
#REF!
#REF!
5
GI System
3,794,243
4,219,384
(425,141)
(0.10)
5
GI System
#REF!
#REF!
#REF!
#REF!
6
Pulmonary Disease
2,209,844
2,479,712
(269,868)
(0.11)
6
Pulmonary Disease
#REF!
#REF!
#REF!
#REF!
7
Endocrine & Metabolism
1,847,383
2,455,023
(607,640)
(0.25)
7
Endocrine & Metabolism
#REF!
#REF!
#REF!
#REF!
8
Pediatrics
1,644,405
1,852,453
(208,048)
(0.11)
8
Pediatrics
#REF!
#REF!
#REF!
#REF!
9
ER
1,693,070
1,763,377
(70,307)
(0.04)
9
ER
#REF!
#REF!
#REF!
#REF!
10
Women Center
2,574,019
1,966,043
607,977
0.31
10 Women Center
#REF!
#REF!
#REF!
#REF!
11
Neurology
4,070,239
5,527,928
(1,457,689)
(0.26)
11 Neurology
#REF!
#REF!
#REF!
#REF!
12
Surgery
1,908,377
1,781,931
126,446
0.07
12 Surgery
#REF!
#REF!
#REF!
#REF!
13
CHECK UP
3,614,321
4,650,785
(1,036,464)
(0.22)
13 CHECK UP
#REF!
#REF!
#REF!
#REF!
14
Eye
882,636
968,632
(85,996)
(0.09)
14 Eye
#REF!
#REF!
#REF!
#REF!
15
ENT
1,099,576
1,163,690
(64,114)
(0.06)
15 ENT
#REF!
#REF!
#REF!
#REF!
16
Skin
879,415
879,711
(296)
(0.00)
16 Skin
#REF!
#REF!
#REF!
#REF!
17
Psychiatry
639,204
533,949
105,255
0.20
17 Psychiatry
#REF!
#REF!
#REF!
#REF!
18
HD
1,969,187
1,939,236
29,951
0.02
18 HD
#REF!
#REF!
#REF!
#REF!
19
PT
205,852
268,365
(62,514)
(0.23)
19 PT
#REF!
#REF!
#REF!
#REF!
20
PCC
2,120,406
4,105,837
(1,985,432)
(0.48)
20 PCC
#REF!
#REF!
#REF!
#REF!
21
Other
3,543,982
2,760,652
783,330
0.28
#REF!
#REF!
#REF!
#REF!
48,040,695
54,152,400
(6,895,035)
(0.11)
#REF!
#REF!
#REF!
#REF!
Total
21
Total
March 2007 Volume
Other
March 2007 Actual
Target
Diff target
% Diff Target
Volume
Actual
Target
Diff target
% Diff Target
3
General medicine
8,913,578
4,157,992
4,755,586
1.14
3
General medicine
8,913,578
4,157,992
4,755,586
1.14
1
Dental
7,568,029
7,926,813
(358,784)
(0.05)
1
Dental
7,568,029
7,926,813
(358,784)
(0.05)
2
MSK
5,228,283
4,069,996
1,158,287
0.28
2
MSK
5,228,283
4,069,996
1,158,287
0.28
4
Cardiology
4,531,775
4,708,123
(176,348)
(0.04)
4
Cardiology
4,531,775
4,708,123
(176,348)
(0.04)
5
GI System
3,509,376
3,336,477
172,900
0.05
5
GI System
3,509,376
3,336,477
172,900
0.05
6
Pulmonary Disease
2,471,807
2,392,791
79,016
0.03
6
Pulmonary Disease
2,471,807
2,392,791
79,016
0.03
7
Endocrine & Metabolism
2,537,889
2,617,920
(80,031)
(0.03)
7
Endocrine & Metabolism
2,537,889
2,617,920
(80,031)
(0.03)
8
Pediatrics
1,589,183
1,794,573
(205,390)
(0.11)
8
Pediatrics
1,589,183
1,794,573
(205,390)
(0.11)
9
ER
2,018,068
1,971,465
46,603
0.02
9
ER
2,018,068
1,971,465
46,603
0.02
10 Women Center
2,801,509
1,966,395
835,114
0.42
10 Women Center
2,801,509
1,966,395
835,114
0.42
11 Neurology
4,991,305
5,640,152
(648,847)
(0.12)
11 Neurology
4,991,305
5,640,152
(648,847)
(0.12)
12 Surgery
2,326,174
1,916,939
409,235
0.21
12 Surgery
2,326,174
1,916,939
409,235
0.21
13 CHECK UP
4,620,402
5,656,540
(1,036,138)
(0.18)
13 CHECK UP
4,620,402
5,656,540
(1,036,138)
(0.18)
14 Eye
1,197,895
1,022,270
175,625
0.17
14 Eye
1,197,895
1,022,270
175,625
0.17
15 ENT
1,119,111
1,082,993
36,118
0.03
15 ENT
1,119,111
1,082,993
36,118
0.03
16 Skin
927,849
962,955
(35,106)
(0.04)
16 Skin
927,849
962,955
(35,106)
(0.04)
17 Psychiatry
730,618
719,377
11,241
0.02
17 Psychiatry
730,618
719,377
11,241
18 HD
2,307,621
2,182,721
124,900
0.06
18 HD
2,307,621
2,182,721
124,900
0.06
19 PT
283,705
285,817
(2,112)
(0.01)
19 PT
283,705
285,817
(2,112)
(0.01)
20 PCC
1,348,438
4,645,960
(3,297,522)
(0.71)
20 PCC
1,348,438
4,645,960
(3,297,522)
(0.71)
21 Other
3,837,431
3,106,027
731,403
0.24
21 Other
3,837,431
3,106,027
731,403
0.24
64,860,045
62,164,296
(2,791,240)
0.04
64,860,045
62,164,296
(2,791,240)
0.04
Actual
Target
Total
Total
April 2007 Volume
0.02
April 2007 Actual
Diff target
Target
% Diff Target
Volume
Diff target
% Diff Target
3
General medicine
8,913,578
4,157,992
4,755,586
1.14
3
General medicine
8,913,578
4,157,992
4,755,586
1.14
1
Dental
7,568,029
7,926,813
(358,784)
(0.05)
1
Dental
7,568,029
7,926,813
(358,784)
(0.05)
2
MSK
5,228,283
4,069,996
1,158,287
0.28
2
MSK
5,228,283
4,069,996
1,158,287
0.28
4
Cardiology
4,531,775
4,708,123
(176,348)
(0.04)
4
Cardiology
4,531,775
4,708,123
(176,348)
(0.04)
5
GI System
3,509,376
3,336,477
172,900
0.05
5
GI System
3,509,376
3,336,477
172,900
0.05
6
Pulmonary Disease
2,471,807
2,392,791
79,016
0.03
6
Pulmonary Disease
2,471,807
2,392,791
79,016
0.03
7
Endocrine & Metabolism
2,537,889
2,617,920
(80,031)
(0.03)
7
Endocrine & Metabolism
2,537,889
2,617,920
(80,031)
(0.03)
8
Pediatrics
1,589,183
1,794,573
(205,390)
(0.11)
8
Pediatrics
1,589,183
1,794,573
(205,390)
(0.11)
9
ER
2,018,068
1,971,465
46,603
0.02
9
ER
2,018,068
1,971,465
46,603
0.02
10 Women Center
2,801,509
1,966,395
835,114
0.42
10 Women Center
2,801,509
1,966,395
835,114
0.42
11 Neurology
4,991,305
5,640,152
(648,847)
(0.12)
11 Neurology
4,991,305
5,640,152
(648,847)
(0.12)
12 Surgery
2,326,174
1,916,939
409,235
0.21
12 Surgery
2,326,174
1,916,939
409,235
0.21
13 CHECK UP
4,620,402
5,656,540
(1,036,138)
(0.18)
13 CHECK UP
4,620,402
5,656,540
(1,036,138)
(0.18)
14 Eye
1,197,895
1,022,270
175,625
0.17
14 Eye
1,197,895
1,022,270
175,625
0.17
15 ENT
1,119,111
1,082,993
36,118
0.03
15 ENT
1,119,111
1,082,993
36,118
0.03
16 Skin
927,849
962,955
(35,106)
(0.04)
16 Skin
927,849
962,955
(35,106)
(0.04) 0.02
17 Psychiatry
730,618
719,377
11,241
0.02
17 Psychiatry
730,618
719,377
11,241
18 HD
2,307,621
2,182,721
124,900
0.06
18 HD
2,307,621
2,182,721
124,900
0.06
19 PT
283,705
285,817
(2,112)
(0.01)
19 PT
283,705
285,817
(2,112)
(0.01)
20 PCC
1,348,438
4,645,960
(3,297,522)
(0.71)
20 PCC
1,348,438
4,645,960
(3,297,522)
(0.71)
21 Other
3,837,431
3,106,027
731,403
0.24
21 Other
3,837,431
3,106,027
731,403
0.24
64,860,045
62,164,296
(2,791,240)
0.04
64,860,045
62,164,296
(2,791,240)
0.04
Actual
Target
Total
Total
Cumulative Volume projection Jan - April 2007 Volume 1
Dental
Actual #REF!
Diff target
Target #REF!
#REF!
March 2007
% Diff Target #REF!
Volume 3
General medicine
8,913,578
4,157,992
Diff target 4,755,586
% Diff Target 1.14
2
MSK
#REF!
#REF!
#REF!
#REF!
1
Dental
7,568,029
7,926,813
(358,784)
3
General medicine
#REF!
#REF!
#REF!
#REF!
2
MSK
5,228,283
4,069,996
1,158,287
0.28
4
Cardiology
#REF!
#REF!
#REF!
#REF!
4
Cardiology
4,531,775
4,708,123
(176,348)
(0.04)
5
GI System
#REF!
#REF!
#REF!
#REF!
5
GI System
3,509,376
3,336,477
172,900
0.05
6
Pulmonary Disease
#REF!
#REF!
#REF!
#REF!
6
Pulmonary Disease
2,471,807
2,392,791
79,016
0.03
7
Endocrine & Metabolism
#REF!
#REF!
#REF!
#REF!
7
Endocrine & Metabolism
2,537,889
2,617,920
(80,031)
(0.03)
8
Pediatrics
#REF!
#REF!
#REF!
#REF!
8
Pediatrics
1,589,183
1,794,573
(205,390)
(0.11)
9
ER
#REF!
#REF!
#REF!
#REF!
9
ER
2,018,068
1,971,465
46,603
0.02
10
Women Center
#REF!
#REF!
#REF!
#REF!
10 Women Center
2,801,509
1,966,395
835,114
0.42
11
Neurology
#REF!
#REF!
#REF!
#REF!
11 Neurology
4,991,305
5,640,152
(648,847)
(0.12)
12
Surgery
#REF!
#REF!
#REF!
#REF!
12 Surgery
2,326,174
1,916,939
409,235
0.21
13
CHECK UP
#REF!
#REF!
#REF!
#REF!
13 CHECK UP
4,620,402
5,656,540
(1,036,138)
(0.18)
14
Eye
#REF!
#REF!
#REF!
#REF!
14 Eye
1,197,895
1,022,270
175,625
0.17
15
ENT
#REF!
#REF!
#REF!
#REF!
15 ENT
1,119,111
1,082,993
36,118
0.03
16
Skin
#REF!
#REF!
#REF!
#REF!
16 Skin
927,849
962,955
(35,106)
(0.04)
17
Psychiatry
#REF!
#REF!
#REF!
#REF!
17 Psychiatry
730,618
719,377
11,241
0.02
18
HD
#REF!
#REF!
#REF!
#REF!
18 HD
2,307,621
2,182,721
124,900
0.06
19
PT
#REF!
#REF!
#REF!
#REF!
19 PT
283,705
285,817
(2,112)
(0.01)
20
PCC
#REF!
#REF!
#REF!
#REF!
20 PCC
1,348,438
4,645,960
(3,297,522)
(0.71)
21
Other
#REF!
#REF!
#REF!
#REF!
21 Other
3,837,431
3,106,027
731,403
0.24
#REF!
#REF!
#REF!
#REF!
64,860,045
62,164,296
(2,791,240)
0.04
Total
Total
(0.05)
January 2007 Volume
IPPD January 2007 Actual
1
General medicine
2
Dental
6,310,247
3
MSK
4,765,763
4
Cardiology
3,926,594
5
GI System
6
Target 5,190,542
Diff target
% Diff Target % Within OPD
Volume
1,330,345
0.26
2.90
1
6,281,278
28,969
0.00
215.82
2
3,850,306
915,457
0.24
3.21
3
5,337,072
(1,410,477)
(0.26)
(4.78)
4
3,973,182
3,768,227
204,955
0.05
17.39
5
Pulmonary Disease
2,440,062
2,940,838
(500,776)
(0.17)
(6.87)
6
7
Endocrine & Metabolism
2,573,927
2,847,262
(273,334)
(0.10)
(11.42)
7
8
Pediatrics
2,152,957
2,190,258
(37,301)
(0.02)
(59.72)
8
9
ER
2,013,327
1,982,839
30,488
0.02
64.04
9
10
Women Center
2,197,660
1,771,972
425,688
0.24
3.16
10
11
Neurology
4,476,238
5,189,297
(713,059)
(0.14)
(8.28)
11
12
Surgery
2,051,782
1,918,446
133,335
0.07
13.39
12
13
CHECK UP
3,928,461
3,823,011
105,450
0.03
35.25
13
14
Eye
988,728
1,005,283
(16,555)
(0.02)
(61.72)
14
15
ENT
1,128,765
1,214,680
(85,915)
(0.07)
(15.14)
15
16
Skin
1,055,420
867,352
188,068
0.22
3.61
17
Psychiatry
704,617
614,602
90,015
0.15
5.83
18
HD
2,352,544
2,000,075
352,469
0.18
4.67
19
PT
335,813
315,404
20,410
0.06
14.45
20
PCC
21
Other Total
6,520,886
Actual 587 300 228 386 300 152 373 155 121 383 46 26 3 10 3,070
Target 587 300 228 386 300 152 373 155 121 383 46 26 3 10 3,070
4,217 1.37
879,871
1,387,833
(507,962)
(0.37)
(3.73)
59,617,947
3,823,373
2,861,190
962,183
0.34
1.97
50,492,503
52,079,333
52,167,225
(1,050,075)
(0.00)
(50.68)
55,139,965
February 2007 Volume
General medicine MSK Cardiology GI System Pulmonary Disease Endocrine & Metabolism Pediatrics Women Center Neurology Surgery Eye ENT Skin Psychiatry Total
February 2007 Actual
1
General medicine
5,372,862
2
Dental
3
MSK
4
Cardiology
3,490,227
Target
Diff target
% Diff Target % Diff Target
Volume
Actual
Target
4,680,501
692,361
0.15
5.76
1
Dental
#REF!
#REF!
5,817,556
6,711,231
(893,675)
(0.13)
(8.51)
2
MSK
#REF!
#REF!
4,036,753
3,877,096
159,657
0.04
23.28
3
General medicine
#REF!
#REF!
4,247,365
(757,138)
(0.18)
(6.61)
4
Cardiology
#REF!
#REF!
5
GI System
3,794,243
4,219,384
(425,141)
(0.10)
(10.92)
5
GI System
#REF!
#REF!
6
Pulmonary Disease
2,209,844
2,479,712
(269,868)
(0.11)
(10.19)
6
Pulmonary Disease
#REF!
#REF!
7
Endocrine & Metabolism
1,847,383
2,455,023
(607,640)
(0.25)
(5.04)
7
Endocrine & Metabolism
#REF!
#REF!
8
Pediatrics
1,644,405
1,852,453
(208,048)
(0.11)
(9.90)
8
Pediatrics
#REF!
#REF!
9
ER
1,693,070
1,763,377
(70,307)
(0.04)
(26.08)
9
ER
#REF!
#REF!
10
Women Center
2,574,019
1,966,043
607,977
0.31
2.23
10 Women Center
#REF!
#REF!
11
Neurology
4,070,239
5,527,928
(1,457,689)
(0.26)
(4.79)
11 Neurology
#REF!
#REF!
12
Surgery
1,908,377
1,781,931
126,446
0.07
13.09
12 Surgery
#REF!
#REF!
13
CHECK UP
3,614,321
4,650,785
(1,036,464)
(0.22)
(5.49)
13 CHECK UP
#REF!
#REF!
14
Eye
882,636
968,632
(85,996)
(0.09)
(12.26)
14 Eye
#REF!
#REF!
15
ENT
1,099,576
1,163,690
(64,114)
(0.06)
(19.15)
15 ENT
#REF!
#REF!
16
Skin
879,415
879,711
(296)
(0.00)
(2,973.00)
16 Skin
#REF!
#REF!
17
Psychiatry
639,204
533,949
105,255
0.20
4.07
17 Psychiatry
#REF!
#REF!
18
HD
1,969,187
1,939,236
29,951
0.02
63.75
18 HD
#REF!
#REF!
19
PT
205,852
268,365
(62,514)
(0.23)
(5.29)
19 PT
#REF!
#REF!
20
PCC
2,120,406
4,105,837
(1,985,432)
(0.48)
(3.07)
20 PCC
#REF!
#REF!
21
Other
3,543,982
2,760,652
783,330
0.28
2.52
#REF!
#REF!
48,040,695
54,152,400
(6,895,035)
(0.11)
(8.85)
#REF!
#REF!
Total
21
Total
March 2007 Volume
Other
March 2007 Actual
Target
Diff target
% Diff Target % Diff Target
Volume
Actual
Target
3
General medicine
8,913,578
4,157,992
4,755,586
1.14
(0.13)
3
General medicine
8,913,578
1
Dental
7,568,029
7,926,813
(358,784)
(0.05)
(23.09)
1
Dental
7,568,029
4,157,992 7,926,813
2
MSK
5,228,283
4,069,996
1,158,287
0.28
2.51
2
MSK
5,228,283
4,069,996
4
Cardiology
4,531,775
4,708,123
(176,348)
(0.04)
(27.70)
4
Cardiology
4,531,775
4,708,123
5
GI System
3,509,376
3,336,477
172,900
0.05
18.30
5
GI System
3,509,376
3,336,477
6
Pulmonary Disease
2,471,807
2,392,791
79,016
0.03
29.28
6
Pulmonary Disease
2,471,807
2,392,791
7
Endocrine & Metabolism
2,537,889
2,617,920
(80,031)
(0.03)
(33.71)
7
Endocrine & Metabolism
2,537,889
2,617,920
8
Pediatrics
1,589,183
1,794,573
(205,390)
(0.11)
(9.74)
8
Pediatrics
1,589,183
1,794,573
9
ER
2,018,068
1,971,465
46,603
0.02
41.30
9
ER
2,018,068
1,971,465
10 Women Center
2,801,509
1,966,395
835,114
0.42
1.35
10 Women Center
2,801,509
1,966,395
11 Neurology
4,991,305
5,640,152
(648,847)
(0.12)
(9.69)
11 Neurology
4,991,305
5,640,152
12 Surgery
2,326,174
1,916,939
409,235
0.21
3.68
12 Surgery
2,326,174
1,916,939
13 CHECK UP
4,620,402
5,656,540
(1,036,138)
(0.18)
(6.46)
13 CHECK UP
4,620,402
5,656,540
14 Eye
1,197,895
1,022,270
175,625
0.17
4.82
14 Eye
1,197,895
1,022,270
15 ENT
1,119,111
1,082,993
36,118
0.03
28.98
15 ENT
1,119,111
1,082,993
16 Skin
927,849
962,955
(35,106)
(0.04)
(28.43)
16 Skin
927,849
962,955
17 Psychiatry 18 HD 19 PT 20 PCC 21 Other Total
730,618
719,377
11,241
0.02
63.00
17 Psychiatry
2,307,621
2,182,721
124,900
0.06
16.48
18 HD 19 PT
283,705
285,817
(2,112)
(0.01)
(136.33)
1,348,438
4,645,960
(3,297,522)
(0.71)
(2.41)
3,837,431
3,106,027
731,403
0.24
3.25
64,860,045
62,164,296
(2,791,240)
0.04
(23.27)
20 PCC 21 Other Total
April 2007 Volume
730,618
719,377
2,307,621
2,182,721
283,705
285,817
1,348,438
4,645,960
3,837,431
3,106,027
64,860,045
62,164,296
April 2007 Actual
Diff target
Target
% Diff Target % Diff Target
Volume
Actual
Target
3
General medicine
8,913,578
4,157,992
4,755,586
1.14
(0.13)
3
General medicine
8,913,578
1
Dental
7,568,029
7,926,813
(358,784)
(0.05)
(23.09)
1
Dental
7,568,029
7,926,813
2
MSK
5,228,283
4,069,996
1,158,287
0.28
2.51
2
MSK
5,228,283
4,069,996
4
Cardiology
4,531,775
4,708,123
(176,348)
(0.04)
(27.70)
4
Cardiology
4,531,775
4,708,123
5
GI System
3,509,376
3,336,477
172,900
0.05
18.30
5
GI System
3,509,376
3,336,477
6
Pulmonary Disease
2,471,807
2,392,791
79,016
0.03
29.28
6
Pulmonary Disease
2,471,807
2,392,791
7
Endocrine & Metabolism
2,537,889
2,617,920
(80,031)
(0.03)
(33.71)
7
Endocrine & Metabolism
2,537,889
2,617,920
8
Pediatrics
1,589,183
1,794,573
(205,390)
(0.11)
(9.74)
8
Pediatrics
1,589,183
1,794,573
9
ER
2,018,068
1,971,465
46,603
0.02
41.30
9
ER
2,018,068
1,971,465
10 Women Center
2,801,509
1,966,395
835,114
0.42
1.35
10 Women Center
2,801,509
1,966,395
11 Neurology
4,991,305
5,640,152
(648,847)
(0.12)
(9.69)
11 Neurology
4,991,305
5,640,152
12 Surgery
2,326,174
1,916,939
409,235
0.21
3.68
12 Surgery
2,326,174
1,916,939
13 CHECK UP
4,620,402
5,656,540
(1,036,138)
(0.18)
(6.46)
13 CHECK UP
4,620,402
5,656,540
14 Eye
1,197,895
1,022,270
175,625
0.17
4.82
14 Eye
1,197,895
1,022,270
15 ENT
1,119,111
1,082,993
36,118
0.03
28.98
15 ENT
1,119,111
1,082,993
16 Skin
927,849
962,955
(35,106)
(0.04)
(28.43)
16 Skin
927,849
962,955
17 Psychiatry 18 HD 19 PT 20 PCC 21 Other Total
730,618
719,377
11,241
0.02
63.00
17 Psychiatry
2,307,621
2,182,721
124,900
0.06
16.48
18 HD 19 PT
283,705
285,817
(2,112)
(0.01)
(136.33)
1,348,438
4,645,960
(3,297,522)
(0.71)
(2.41)
3,837,431
3,106,027
731,403
0.24
3.25
64,860,045
62,164,296
(2,791,240)
0.04
(23.27)
20 PCC 21 Other Total
Cumulative Volume projection Jan - April 2007 Volume 1
Dental
Actual #REF!
Diff target
Target #REF!
#REF!
4,157,992
730,618
719,377
2,307,621
2,182,721
283,705
285,817
1,348,438
4,645,960
3,837,431
3,106,027
64,860,045
62,164,296
March 2007
% Diff Target % Diff Target #REF!
#REF!
Volume 3
General medicine
Actual 8,913,578
Target 4,157,992
2
MSK
#REF!
#REF!
#REF!
#REF!
#REF!
1
Dental
7,568,029
7,926,813
3
General medicine
#REF!
#REF!
#REF!
#REF!
#REF!
2
MSK
5,228,283
4,069,996
4
Cardiology
#REF!
#REF!
#REF!
#REF!
#REF!
4
Cardiology
4,531,775
4,708,123
5
GI System
#REF!
#REF!
#REF!
#REF!
#REF!
5
GI System
3,509,376
3,336,477
6
Pulmonary Disease
#REF!
#REF!
#REF!
#REF!
#REF!
6
Pulmonary Disease
2,471,807
2,392,791
7
Endocrine & Metabolism
#REF!
#REF!
#REF!
#REF!
#REF!
7
Endocrine & Metabolism
2,537,889
2,617,920
8
Pediatrics
#REF!
#REF!
#REF!
#REF!
#REF!
8
Pediatrics
1,589,183
1,794,573
9
ER
#REF!
#REF!
#REF!
#REF!
#REF!
9
ER
2,018,068
1,971,465
10
Women Center
#REF!
#REF!
#REF!
#REF!
#REF!
10 Women Center
2,801,509
1,966,395
11
Neurology
#REF!
#REF!
#REF!
#REF!
#REF!
11 Neurology
4,991,305
5,640,152
12
Surgery
#REF!
#REF!
#REF!
#REF!
#REF!
12 Surgery
2,326,174
1,916,939
13
CHECK UP
#REF!
#REF!
#REF!
#REF!
#REF!
13 CHECK UP
4,620,402
5,656,540
14
Eye
#REF!
#REF!
#REF!
#REF!
#REF!
14 Eye
1,197,895
1,022,270
15
ENT
#REF!
#REF!
#REF!
#REF!
#REF!
15 ENT
1,119,111
1,082,993
16
Skin
#REF!
#REF!
#REF!
#REF!
#REF!
16 Skin
927,849
962,955
17
Psychiatry
#REF!
#REF!
#REF!
#REF!
#REF!
17 Psychiatry
730,618
719,377
18
HD
#REF!
#REF!
#REF!
#REF!
#REF!
18 HD
2,307,621
2,182,721
19
PT
#REF!
#REF!
#REF!
#REF!
#REF!
19 PT
20
PCC
#REF!
#REF!
#REF!
#REF!
#REF!
20 PCC
21
Other
#REF!
#REF!
#REF!
#REF!
#REF!
21 Other
#REF!
#REF!
#REF!
#REF!
#REF!
Total
Total
283,705
285,817
1,348,438
4,645,960
3,837,431
3,106,027
64,860,045
62,164,296
Diff target 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
% Diff Target % Within OPD 0.00 19.1% 0.00 9.8% 0.00 7.4% 0.00 12.6% 0.00 9.8% 0.00 5.0% 0.00 12.1% 0.00 5.0% 0.00 3.9% 0.00 12.5% 0.00 1.5% 0.00 0.8% 0.00 0.1% 0.00 0.3% 0.00 100.0% General medicine 806 412 MSK 313 Cardiology 530 GI System Pulmonary Disease412 209 Endocrine & Metabolism 512 Pediatrics 213 Women Center 166 Neurology 526 Surgery 63 Eye 36 ENT 4 Skin Psychiatry Total
Diff target
% Diff Target
% Diff Target
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
14 4,217
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
Diff target
% Diff Target
% Diff Target
4,755,586
1.14
(0.13)
(358,784)
(0.05)
(23.09)
1,158,287
0.28
2.51
(176,348)
(0.04)
(27.70)
172,900
0.05
18.30
79,016
0.03
29.28
(80,031)
(0.03)
(33.71)
(205,390)
(0.11)
(9.74)
46,603
0.02
41.30
835,114
0.42
1.35
(648,847)
(0.12)
(9.69)
409,235
0.21
3.68
(1,036,138)
(0.18)
(6.46)
175,625
0.17
4.82
36,118
0.03
28.98
(35,106)
(0.04)
(28.43)
11,241
0.02
124,900
0.06
16.48
(2,112)
(0.01)
(136.33)
(3,297,522)
(0.71)
(2.41)
731,403
0.24
3.25
(2,791,240)
0.04
(23.27)
Diff target
% Diff Target
63.00
% Diff Target
4,755,586
1.14
(0.13)
(358,784)
(0.05)
(23.09)
1,158,287
0.28
2.51
(176,348)
(0.04)
(27.70)
172,900
0.05
18.30
79,016
0.03
29.28
(80,031)
(0.03)
(33.71)
(205,390)
(0.11)
(9.74)
46,603
0.02
41.30
835,114
0.42
1.35
(648,847)
(0.12)
(9.69)
409,235
0.21
3.68
(1,036,138)
(0.18)
(6.46)
175,625
0.17
4.82
36,118
0.03
28.98
(35,106)
(0.04)
(28.43) 63.00
11,241
0.02
124,900
0.06
16.48
(2,112)
(0.01)
(136.33)
(3,297,522)
(0.71)
(2.41)
731,403
0.24
3.25
(2,791,240)
0.04
(23.27)
Diff target 4,755,586
% Diff Target 1.14
% Diff Target (0.13)
(358,784)
(0.05)
1,158,287
0.28
(23.09) 2.51
(176,348)
(0.04)
(27.70)
172,900
0.05
18.30
79,016
0.03
29.28
(80,031)
(0.03)
(33.71)
(205,390)
(0.11)
(9.74)
46,603
0.02
41.30
835,114
0.42
1.35
(648,847)
(0.12)
(9.69)
409,235
0.21
3.68
(1,036,138)
(0.18)
(6.46)
175,625
0.17
4.82
36,118
0.03
28.98
(35,106)
(0.04)
(28.43)
11,241
0.02
63.00
124,900
0.06
16.48
(2,112)
(0.01)
(136.33)
(3,297,522)
(0.71)
(2.41)
731,403
0.24
3.25
(2,791,240)
0.04
(23.27)
General medicine
8,454,539
MSK
5,908,252
Cardiology
5,492,093
GI System
5,970,482
Pulmonary Disease
3,477,329
Endocrine & Metabolism
2,906,974
Pediatrics
3,493,020
Women Center
3,338,217
Neurology
6,404,779
Surgery
8,216,594
Eye
355,153
ENT
326,415
Skin
879,415
Psychiatry Other
43,964 3,543,982
January 2007 OPD Volume
January 2007 IPD Actual
Target
Diff target
% Diff Target
% Within OPD
Volume
Actual
1
General medicine
6,309,891
5,190,542
1,119,350
0.22
10.8%
1
General medicine
2
Dental
6,310,247
6,281,278
28,969
0.00
10.8%
2
3
MSK
4,765,763
3,850,306
915,457
0.24
8.2%
4
Cardiology
3,926,594
5,337,072
(1,410,477)
(0.26)
5
GI System
3,973,182
3,768,227
204,955
6
Pulmonary Disease
2,440,062
2,940,838
7
Endocrine & Metabolism
2,573,927
8
Pediatrics
9
Target
11,998,521
11,998,521
MSK
5,908,252
5,908,252
3
Cardiology
5,492,093
5,492,093
6.7%
4
GI System
5,970,482
5,970,482
0.05
6.8%
5
Pulmonary Disease
3,477,329
3,477,329
(500,776)
(0.17)
4.2%
6
Endocrine & Metabolism
2,906,974
2,906,974
2,847,262
(273,334)
(0.10)
4.4%
7
Pediatrics
3,493,020
3,493,020
2,152,957
2,190,258
(37,301)
(0.02)
3.7%
8
Women Center
3,338,217
3,338,217
ER
2,013,327
1,982,839
30,488
0.02
3.4%
9
Neurology
6,404,779
6,404,779
10
Women Center
2,197,660
1,771,972
425,688
0.24
3.8%
10 Surgery
8,216,594
8,216,594
11
Neurology
4,476,238
5,189,297
(713,059)
(0.14)
7.7%
11 Eye
355,153
355,153
12
Surgery
2,051,782
1,918,446
133,335
0.07
3.5%
12 ENT
326,415
326,415
13
CHECK UP
3,928,461
3,823,011
105,450
0.03
6.7%
13 Skin
879,415
879,415
14
Eye
988,728
1,005,283
(16,555)
(0.02)
1.7%
14 Psychiatry
43,964
43,964
15
ENT
1,128,765
1,214,680
(85,915)
(0.07)
1.9%
15 Total
58,811,208
Err:522
16
Skin
1,055,420
867,352
188,068
0.22
1.8%
17
Psychiatry
704,617
614,602
90,015
0.15
1.2%
18
HD
2,352,544
2,000,075
352,469
0.18
4.0%
19
PT
335,813
315,404
20,410
0.06
0.6%
50,492,503
20
PCC
879,871
1,387,833
(507,962)
(0.37)
1.5%
55,139,965
21
Other
3,823,373
643,388
3,179,985
4.94
6.5%
58,389,224
55,139,965
3,249,259
0.06
100.0%
Total
61,059,420
59,617,947
59,617,947
February 2007 Volume
February 2007 Actual
Target
Diff target
% Diff Target
Volume
% Diff Target
1
General medicine
5,372,862
4,680,501
692,361
0.15
5.76
1
General medicine
2
Dental
5,817,556
6,711,231
(893,675)
(0.13)
(8.51)
2
3
MSK
4,036,753
3,877,096
159,657
0.04
23.28
4
Cardiology
3,490,227
4,247,365
(757,138)
(0.18)
5
GI System
3,794,243
4,219,384
(425,141)
6
Pulmonary Disease
2,209,844
2,479,712
7
Endocrine & Metabolism
1,847,383
8
Pediatrics
9
Actual
Target
11,998,521
11,998,521
MSK
5,908,252
5,908,252
3
Cardiology
5,492,093
5,492,093
(6.61)
4
GI System
5,970,482
5,970,482
(0.10)
(10.92)
5
Pulmonary Disease
3,477,329
3,477,329
(269,868)
(0.11)
(10.19)
6
Endocrine & Metabolism
2,906,974
2,906,974
2,455,023
(607,640)
(0.25)
(5.04)
7
Pediatrics
3,493,020
3,493,020
1,644,405
1,852,453
(208,048)
(0.11)
(9.90)
8
Women Center
3,338,217
3,338,217
ER
1,693,070
1,763,377
(70,307)
(0.04)
(26.08)
9
Neurology
6,404,779
6,404,779
10
Women Center
2,574,019
1,966,043
607,977
0.31
2.23
8,216,594
8,216,594
11
Neurology
4,070,239
5,527,928
(1,457,689)
(0.26)
(4.79)
11 Eye
355,153
355,153
12
Surgery
1,908,377
1,781,931
126,446
0.07
13.09
12 ENT
326,415
326,415
13
CHECK UP
3,614,321
4,650,785
(1,036,464)
(0.22)
(5.49)
13 Skin
879,415
879,415
14
Eye
882,636
968,632
(85,996)
(0.09)
(12.26)
14 Psychiatry
43,964
43,964
15
ENT
1,099,576
1,163,690
(64,114)
(0.06)
(19.15)
15 Total
Err:522
Err:522
16
Skin
879,415
879,711
(296)
(0.00)
(2,973.00)
17
Psychiatry
639,204
533,949
105,255
0.20
4.07
18
HD
1,969,187
1,939,236
29,951
0.02
63.75
19
PT
205,852
268,365
(62,514)
(0.23)
(5.29)
20
PCC
2,120,406
4,105,837
(1,985,432)
(0.48)
(3.07)
10 Surgery
51,335,389
21
Other Total
3,543,982
2,760,652
783,330
0.28
2.52
53,413,558
58,832,901
(5,419,344)
(0.09)
(11.86)
52,754,123
March 2007 Volume
March 2007 Actual
Target
Diff target
% Diff Target
Volume
% Diff Target
Actual
Target
1
General medicine
8,913,578
4,157,992
4,755,586
1.14
(0.13)
1
General medicine
9,681,253
9,681,253
2
Dental
7,568,029
7,926,813
(358,784)
(0.05)
(23.09)
2
MSK
7,154,348
7,154,348
3
MSK
5,228,283
4,069,996
1,158,287
0.28
2.51
3
Cardiology
4,167,600
4,167,600
4
Cardiology
4,531,775
4,708,123
(176,348)
(0.04)
(27.70)
4
GI System
5,498,533
5,498,533
5
GI System
3,509,376
3,336,477
172,900
0.05
18.30
5
Pulmonary Disease
4,491,306
4,491,306
6
Pulmonary Disease
2,471,807
2,392,791
79,016
0.03
29.28
6
Endocrine & Metabolism
1,421,269
1,421,269
7
Endocrine & Metabolism
2,537,889
2,617,920
(80,031)
(0.03)
(33.71)
7
Pediatrics
1,939,151
1,939,151
8
Pediatrics
1,589,183
1,794,573
(205,390)
(0.11)
(9.74)
8
Women Center
3,125,877
3,125,877
9
ER
2,018,068
1,971,465
46,603
0.02
41.30
9
Neurology
10,218,026
10,218,026
10
Women Center
2,801,509
1,966,395
835,114
0.42
1.35
11,052,341
11,052,341
11
Neurology
4,991,305
5,640,152
(648,847)
(0.12)
(9.69)
11 Eye
3,614,321
3,614,321
12
Surgery
2,326,174
1,916,939
409,235
0.21
3.68
12 ENT
588,485
588,485
13
CHECK UP
4,620,402
5,656,540
(1,036,138)
(0.18)
(6.46)
13 Skin
584,907
584,907
14
Eye
1,197,895
1,022,270
175,625
0.17
4.82
14 Psychiatry
21,229
21,229
15
ENT
1,119,111
1,082,993
36,118
0.03
28.98
Others
182,489
182,489
16
Skin
927,849
962,955
(35,106)
(0.04)
(28.43)
63,741,135
63,741,135
17
Psychiatry
730,618
719,377
11,241
0.02
63.00
18
HD
2,307,621
2,182,721
124,900
0.06
16.48
19
PT
283,705
285,817
(2,112)
(0.01)
(136.33)
10 Surgery
Total
60,330,477
20
PCC
1,348,438
4,645,960
(3,297,522)
(0.71)
(2.41)
21
Other
3,837,431
3,106,027
731,403
0.24
3.25
64,860,045
62,164,296
2,695,749
0.04
22.06
Total
65,189,898
Cumulative Revenue OPD Jan - March 2007 Volume
Actual
Target
Cumulative Revenue OPD Jan - March 2007
Diff target
% Diff Target
% Diff Target
Volume
Actual
Target
1
General medicine
20,596,331
14,029,035
6,567,297
0.47
1.14
1
General medicine
5,372,862
4,680,501
2
Dental
19,695,832
20,919,322
(1,223,490)
(0.06)
(18.10)
2
Dental
5,817,556
6,711,231
3
MSK
14,030,799
11,797,397
2,233,402
0.19
4.28
3
MSK
4,036,753
3,877,096
4
Cardiology
11,948,596
14,292,560
(2,343,964)
(0.16)
(7.10)
4
Cardiology
3,490,227
4,247,365
5
GI System
11,276,802
11,324,088
(47,286)
(0.00)
(240.48)
5
GI System
3,794,243
4,219,384
6
Pulmonary Disease
7,121,713
7,813,341
(691,628)
(0.09)
(12.30)
6
Pulmonary Disease
2,209,844
2,479,712
7
Endocrine & Metabolism
6,959,200
7,920,205
(961,005)
(0.12)
(9.24)
7
Endocrine & Metabolism
1,847,383
2,455,023
8
Pediatrics
5,386,545
5,837,284
(450,739)
(0.08)
(13.95)
8
Pediatrics
1,644,405
1,852,453
9
ER
5,724,465
5,717,682
6,783
0.00
841.90
9
ER
1,693,070
1,763,377
10
Women Center
7,573,188
5,704,410
1,868,778
0.33
2.05
10 Women Center
2,574,019
1,966,043
11
Neurology
13,537,782
16,357,377
(2,819,595)
(0.17)
(6.80)
11 Neurology
4,070,239
5,527,928
12
Surgery
6,286,333
5,617,317
669,016
0.12
7.40
12 Surgery
1,908,377
1,781,931
13
CHECK UP
12,163,184
14,130,335
(1,967,151)
(0.14)
(8.18)
13 CHECK UP
3,614,321
4,650,785
14
Eye
3,069,259
2,996,185
73,074
0.02
40.00
14 Eye
882,636
968,632
15
ENT
3,347,452
3,461,363
(113,911)
(0.03)
(31.39)
15 ENT
1,099,576
1,163,690
16
Skin
2,862,684
2,710,018
152,666
0.06
16.75
16 Skin
879,415
879,711
17
Psychiatry
2,074,439
1,867,928
206,511
0.11
8.05
17 Psychiatry
639,204
533,949
18
HD
6,629,352
6,122,032
507,320
0.08
11.07
18 HD
1,969,187
1,939,236
19
PT
825,370
869,585
(44,216)
(0.05)
(20.67)
19 PT
205,852
268,365
20
PCC
4,348,715
10,139,631
(5,790,916)
(0.57)
(2.75)
21
Other
11,204,786
6,510,067
4,694,718
0.72
0.39
176,662,827
176,137,162
525,665
0.00
334.07
Total
20 PCC
2,120,406
4,105,837
21 Other
3,543,982
2,760,652
53,413,558
58,832,901
Total
January 2007 OPD + IPD Diff target
% Diff Target
% Within IPD
Volume
Actual
Target
Diff target
% Diff Target
18,308,412
17,189,063
1,119,350
0.07
6,310,247
6,281,278
28,969
0.00
10,674,015
3,850,306
6,823,709
1.77
0
0.00
20.4%
1
General medicine
0
0.00
10.0%
2
Dental
0
0.00
9.3%
3
MSK
0
0.00
10.2%
4
Cardiology
9,418,687
5,337,072
4,081,615
0.76
0
0.00
5.9%
5
GI System
9,943,664
3,768,227
6,175,437
1.64
0
0.00
4.9%
6
Pulmonary Disease
5,917,391
2,940,838
2,976,553
1.01
0
0.00
5.9%
7
Endocrine & Metabolism
5,480,901
2,847,262
2,633,639
0.92
0
0.00
5.7%
8
Pediatrics
5,645,977
2,190,258
3,455,719
1.58
0
0.00
10.9%
9
ER
2,013,327
1,982,839
30,488
0.02
0
0.00
14.0%
10
Women Center
5,535,877
1,771,972
3,763,905
2.12
0
0.00
0.6%
11
Neurology
10,881,017
5,189,297
5,691,720
1.10
0
0.00
0.6%
12
Surgery
10,268,376
1,918,446
8,349,929
4.35
0
0.00
1.5%
13
CHECK UP
3,928,461
3,823,011
105,450
0.03
0
0.00
0.1%
14
Eye
1,343,881
1,005,283
338,598
0.34
Err:522
Err:522
100.0%
15
ENT
1,455,180
1,214,680
240,500
0.20
16
Skin
1,934,835
867,352
1,067,483
1.23
17
Psychiatry
748,581
614,602
133,979
0.22
18
HD
2,352,544
2,000,075
352,469
0.18
19
PT
335,813
315,404
20,410
0.06
20
PCC
879,871
1,387,833
(507,962)
(0.37)
21
Other
3,823,373
2,861,190
962,183
0.34
117,200,432
69,356,288
47,844,144
0.69
Net Revenue
February 2007 OPD + IPD Diff target
% Diff Target
% Within IPD
Volume
Actual
Target
Diff target
% Diff Target
17,371,383
16,679,022
692,361
0.04
0
0.00
20.4%
1
General medicine
0
0.00
10.0%
2
Dental
6,310,247
6,281,278
28,969
0.00
0
0.00
9.3%
3
MSK
9,945,005
3,850,306
6,094,699
1.58
0
0.00
10.2%
4
Cardiology
8,982,320
5,337,072
3,645,248
0.68
0
0.00
5.9%
5
GI System
9,764,725
3,768,227
5,996,498
1.59
0
0.00
4.9%
6
Pulmonary Disease
5,687,173
2,940,838
2,746,335
0.93
0
0.00
5.9%
7
Endocrine & Metabolism
4,754,357
2,847,262
1,907,095
0.67
0
0.00
5.7%
8
Pediatrics
5,137,425
2,190,258
2,947,167
1.35
0
0.00
10.9%
9
ER
2,013,327
1,982,839
30,488
0.02
0
0.00
14.0%
10
Women Center
5,912,237
1,771,972
4,140,264
2.34
0
0.00
0.6%
11
Neurology
10,475,019
5,189,297
5,285,722
1.02
0
0.00
0.6%
12
Surgery
10,124,971
1,918,446
8,206,525
4.28
0
0.00
1.5%
13
CHECK UP
3,928,461
3,823,011
105,450
0.03
0
0.00
0.1%
14
Eye
1,237,789
1,005,283
232,506
0.23
Err:522
Err:522
Err:522
15
ENT
1,425,991
1,214,680
211,311
0.17
16
Skin
1,758,830
867,352
891,478
1.03
17
Psychiatry
683,168
614,602
68,566
0.11
18
HD
2,352,544
2,000,075
352,469
0.18
19
PT
335,813
315,404
20,410
0.06
20
PCC
879,871
1,387,833
(507,962)
(0.37)
21
Other Total
3,823,373
2,861,190
962,183
0.34
112,904,030
68,846,247
44,057,782
0.64
March 2007 Diff target
% Diff Target
% Within IPD
Volume
Actual
Diff target
% Diff Target
% Diff Target
9,681,253
#REF!
#REF!
#REF!
5,817,556
#REF!
#REF!
#REF!
MSK
7,154,348
#REF!
#REF!
#REF!
4
Cardiology
4,167,600
#REF!
#REF!
#REF!
7.0%
5
GI System
5,498,533
#REF!
#REF!
#REF!
0
2.2%
6
Pulmonary Disease
4,491,306
#REF!
#REF!
#REF!
0
0
3.0%
7
Endocrine & Metabolism
1,421,269
#REF!
#REF!
#REF!
0
0
4.9%
8
Pediatrics
1,939,151
#REF!
#REF!
#REF!
0
0
16.0%
9
ER
1,693,070
#REF!
#REF!
#REF!
0
0
17.3%
10
Women Center
3,125,877
#REF!
#REF!
#REF!
0
0
5.7%
11
Neurology
10,218,026
#REF!
#REF!
#REF!
0
0
0.9%
12
Surgery
11,052,341
#REF!
#REF!
#REF!
0
0
0.9%
13
CHECK UP
3,614,321
#REF!
#REF!
#REF!
0
0
0.0%
14
Eye
588,485
#REF!
#REF!
#REF!
0
0
0.3%
15
ENT
584,907
#REF!
#REF!
#REF!
0
0
100.0%
16
Skin
21,229
#REF!
#REF!
#REF!
17
Psychiatry
18 19
0
0
15.2%
1
General medicine
0
0
11.2%
2
Dental
0
0
6.5%
3
0
0
8.6%
0
0
0
251,872
533,949
(282,077)
(0.53)
(2.89)
HD
1,969,187
1,939,236
29,951
0.02
63.75
PT
205,852
268,365
(62,514)
(0.23)
(5.29)
20
PCC
2,120,406
4,105,837
(1,985,432)
(0.48)
(3.07)
21
Other
182,489
2,760,652
(2,578,163)
(0.93)
(2.07)
75,799,077
9,608,039
66,191,038
6.89
(0.85)
Total
2007 Diff target
% Diff Target
% Diff Target
692,361
0.15
5.76
(893,675)
(0.13)
(8.51)
159,657
0.04
23.28
(757,138)
(0.18)
(6.61)
(425,141)
(0.10)
(10.92)
(269,868)
(0.11)
(10.19)
(607,640)
(0.25)
(5.04)
(208,048)
(0.11)
(9.90)
(70,307)
(0.04)
(26.08)
607,977
0.31
2.23
(1,457,689)
(0.26)
(4.79)
126,446
0.07
13.09
(1,036,464)
(0.22)
(5.49)
(85,996)
(0.09)
(12.26)
(64,114)
(0.06)
(19.15)
(296)
(0.00)
(2,973.00)
105,255
0.20
4.07
29,951
0.02
63.75
(62,514)
(0.23)
(5.29)
(1,985,432)
(0.48)
(3.07)
783,330
0.28
2.52
(5,419,344)
(0.09)
(11.86)
Related Documents
Revenue Projection Opdipd1
November 2019 3
Revenue Projection For Directv
May 2020 5
Projection
December 2019 51
Revenue
November 2019 33
Revenue
December 2019 47