Productivity Metrics

carrifljinh23h3

_Seidel_Case3_Tables.PDF

Home >Business & Finance homework help >Operations Management homework help >Productivity Metrics

Case 3: Physician Care Services, Inc. 9 5

Alpha Alpha Beta Beta Alpha Gross

Total Private Occupational Private Occupational Charges Visits Visits Health Visits Visits Health Visits ($)

July 1,027 451 184 127 265 86,374 August 1,259 493 271 227 268 107,692

September 909 312 203 189 205 74,138 October 1,057 449 213 178 217 91,656

November 974 425 207 164 178 87,780 December 1,012 401 231 193 187 89,604

Total 11,995 4,886 2,294 2,208 2,6 07 992,864 2011 .. --' .: ,..

.. -

January 866 313 160 200 193 62,917 February 887 375 153 145 214 68,415

March 978 397 187 189 205 76,933 April 954 376 159 205 214 69,6o4 May 1,035 445 193 165 232 83,245 June 1,047 463 193 160 231 85,207 July 968 421 195 107 245 80,989

August 1,212 504 241 207 260 98,316 September 986 323 200 188 275 71,207

c"""''October 990 409 198 156 227 80,221 November 974 400 212 145 217 81,760 December 960 394 223 156 187 83,086

Total 11,857 4,820 2,314 2,023 2,700 941,900

(This table can also be found online at ache.org/books/Middleboro.)

Week Mon Tues Wed Thurs Fri

Alpha

1 20

2 52 34 27 23 27

3 53 37 29 24 25

4 52 33 33 22 21

5 51 27 24 25 22

Total 208 131- 113 94 115

Beta Gross

Charges ($)

81,998

95,148

74,686

76,322

64,836

70,682

925,542 Ir'

60,235

58,115

61,332

64,895

63,885

63,125

59,866

74,091

74,869

61,893

58,700

54,093

755,099

Sat

102

Total Gross

Charges ($)

168,372

202,840

148,824

167,978

152,616

160,286

1,918,4o6

123,152

126,530

138,265

134,499

147,130

148,332

140,855

172,407

146,076

142,114

140,46o

137,179

1,696,999

Total

189

190

181

165

763

(continued)

TABLE 3.1

PCS Utilization

Report

(continued)

TABLE 3.2

Detailed Utilization

(Visits-All Types)

for August 2014

96 The Middleboro Casebook

TABLE 3.2

Detailed Utilization

(Visits-All Types)

for August 2014

(continued)

TABLE 3.3

Alpha Center

Patient Records,

August 4-9, 2014

Week

Beta

Total

DAY

Mon

113

321

NUM

Tues-

105

236

ART AGE

815 23

817 64

819 34

820 45

822 17

822 56

830 19

833 7

855 56

905 32

910 34

915 23

Wed

178

TOWN

Thurs Fri Sat Total

19 9 28

16 26 12 122

14 19 9 118

19 21 13 122

21 23 9 123

70 108 52 513

164 223 154 1,276

SEX FIRST INS PHY CHGE

2 1 1 2 120

2 2 1 2 120

2 3 1 2 96

2 2 1 2 124

2 1 1 2 120

1 1 8 2 288

1 2 2 2 120

1 3 1 2 96

2 1 1 2 120

2 1 1 2 128

1 2 1 2 120

2 1 9 1 80

(continued)

DAY NUM ART AGE

1 13 925 21

1 14 1000 54

1 15 1012 51

1 16 1025 56

1 17 1105 49

1 18 1108 23

1 19 1203 45

1 20 1209 71

1 21 1215 71

1 22 1230 23

1 23 1245 28

1 24 1250 45

1 25 1255 47

1 26 1320 45

1 27 1345 22

1 28 1355 19

1 29 1420 34

1 '

30 1430 25

1 31 1435 68

1 32 1435 43

1 33 1512 3

1 34 1517 50

1 35 1537 63

1 36 1539 21

1 37 1545 56

1 38 1550 66

1 39 1555 19

1 40 1600 5-0

Case 3: Physician Care Services, Inc. 97

TOWN SEX FIRST INS

7 2 2 9

6 1 1 1

1 1 1 8

1 2 2 1

4 1 2 1

4 1 1 8

2 1 2 8

1 1 2 3

4 1 2 8

1 1 2 8

2 2 1 1

1 2 2 1

1 2 3 1

2 1 1 8

1 2 1 8

1 2 2 9

1 1 2 2

1 1 2 3

1 1 2 1

2 1 1 1

7 1 2 1

2 1 2 1

2 2 2 8

1 1 2 9

1 2 2 3

1 1 1 8

2 1 1 9

PHY

·.1

CHGE

120

276

120

126

279

243

120

140

212

230

145

120

201

212

201

120

209

201

250

270

201

(comi11ued)

TABLE 3.3

Alpha Center

Patient Records,

August 4-9, 2014

(continued)

98 The Middleboro Casebook

TABLE 3.3

Alpha Center

Patient Records,

August 4-9, 2014

(continued)

DAY

NUM

41.

lL:.

1 5

ART AGE

i6oo 43

1610 68

1625 50

1630 23

1645 18

17 05 27

1740 45

1750 61

1800 57

1830 42

1830 40

1850 34

812 45

824 23

833 35

845 23

905 55

910 19

925 21

1010 33

1030 33

1055 33

1120 68

1205 61

1215 35

1215 4

1309 29

1310 25

TOWN

SEX FIRST INS PHY CHGE

1 2 9 2 201

1 2 3 2 230

1 2 9 2 350

1 2 1 2 212

1 1 1 2 208

1 2 8 2 212

2 2 1 2 240

1 1 8 2 201

2 1 1 2 120

2 2 1 2 120

1 1 1 2 120

1 1 2 2 120'-�

1 2 9 1 400

2 1 1 2 120

1 1 9 2 201

2 2 2 2 120

1 2 1 2 120

2 2 1 2 120

1 1 8 2 201

2 2 2 2 130 ·-

1 1 9 1 275

1 2 3 2 96

2 2 8 2 201

'.!. : 9 2 130

1 1 J. 2 120

1 1 9 1 120

2 1 1 2 I 120

(continued)

DAY NUM ART AGE

2 17 1320 23

2 18 1400 55

2 19 1420 21

2 20 1421 21

2 21 1425 23

2 22 1507 50

2 23 1515 67

2 24 1555 4

2 25 1610 30

2 26 1620 24

2 27 1630 28

2 28 1650 37

2 29 1705 25

Ir.,..- 2 30 1720 22

2 31 1800 56

2 32 1810 77

2 33 1820 54

2 \

34 1825 32

3 1 801 24

3 2 810 45

3 3 825 2

3 4 835 34

3 5 845 66

3 6 915 44

3 7 920 26

3 8 950 23

3 9 1020 21

3 10 1040 25

Case 3: Physician Care Services, Inc. 99

TOWN SEX FIRST INS

2 2 1 1

8 1 1 2

7 2 1 1

1 2 1 8

2 2 1 1

2 2 2 2

2 1 1 3

1 1 3 2

1 2 1 9

2 1 1 1

2 1 1 9

1 1 2 8

2 2 2 1

1 2 1 1

1 2 1 8

1 1 2 9

1 1 1 1

1 1 2 1

2 1 1 1

1 1 2 8

4 1 1 1

1 1 1 1

1 2 2 3

1 1 1 9

4 1 1 9

1 2 1 1

6 2 2 1

1 1 1 1

PHY

·1

CHGE

120

130

143

240

156

138

120

145

400

120

201

120

201

300

120

201

120

150

300

120

135

120

(continued)

TABLE 3.3

Alpha Center

Patient Records,

August 4-9, 2014

(continued)

100 The Middleboro Casebook

TABLE 3.3

Alpha Center

Patient Records,

August 4-9, 2014

(continued)

DAY

NUM

ART AGE

1105 28

1130 69

1145 52

1200 50

1210 24

1245 21

1315 22

1315 21

1420 69

1450 23

1510 17

1520 14

1530 25

1600 31

1630 4 5

17151 55

1805 61

810 17

815 4

840 25

850 7

930 36

1000 44

1020 9

1050 44

1130 47

1205 34

1230 29

TOWN

SEX FIRST l INS PHY CHGE 2 1 I 8 2 201 2 2 3 2 120

l 1 1 2 120 ·-'---

2 2 8 2 156

2 2 2 2 130

2 3 1 2 135

1 2 8 2 201

2 2 8 2 250

1 3 1 1 150

1 2 8 2 201

2 2 9 1 250

1 1 8 2 20':t"',

l 1 2 2 120

2 3 1 2 96

2 2 1 2 120

1 2 1 2 120

1 1 1 2 120

2 l 8 2 201

l l 2 2 120

2 1 9 1 95

1 3 2 2 96

2 1 9 1 250

2 1 9 1 400

2 1 1 2 120

2 2 8 2 201

2 1 2 2 120

1 1 8 2 201

2 2 8 2 237

(continued)

DAY NUM ART AGE

4 14 1245 28

4 15 1400 44

4 16 1430 12

4 17 1530 50

4 18 1600 23

4 19 1610 26

4 20 1620 39

4 21 1630 69

4 22 1730 30

4 23 1845 3 8

5 1 800 13

5 2 815 22

5 3 825 23

5 4 915 19

5 940 36

5 6 1000 45

5 7 1000 23

5 8 1045 60

5 9 1130 59

5 10 1215 52

5 11 1230 35

5 12 1240 21

5 13 1250 66

5 14 1310 45

5 15 1320 23

5 16 1350 21

5 17 1440 37

5 18 1510 't.0

Case 3: Physician Care Services, Inc. 101

TOWN SEX FIRST

1 2 3

1 2 1

1 1 2

2 2 2

1 1 1

1 2 2

2 2 2

1 2 2

1 1 2

1 2 1

2 2 1

9 2 1

7 1 2

2 1 1

2 1 2

1 1 3

1 2 2

4 1 1

4 2 3

7 2 1

2 2 2

2 2 1

1 1 1

1 2 1

1 1 2

6 2 2

INS PHY

2 2

1 2

8 2

1 2

9 1

3 2

1 2

9 1

1 2

2 2

9 1

2 2

8 2

2 2

1 2

2 2

8 2

1 2

9 1

CHGE

140

150

120

201

120

300

160

145

160

120

300

120

300

201

120

201

130

150

400

(continu1uJ)

TABLE 3.3

Alpha Center

Patient Records,

August 4-9, 2014

(continued)

1.0:> ThP Mirtdleboro Casebook

TABLE 3.3

Alpha Center

Patient Records,

August 4-9, 2014

(continued)

DAY

NUM

ART AGE

1540 50

1620 66

1650 45

1715 54

1730 74

1730 3

1800 19

1820 47

1830 57

900 35

900 12

905 27

915 44

930 55

1000 23

1015 19

1015 7

1025 70

1040 24

1050 17

1100 19

1105 24

1115 16

1130 44

1145 48

1200 8

1215 76

1220 35

TOWN

SEX FIRST INS PHY CHGE

1 2 2 2 120

2 2 3 2 130

2 1 2 2 120

2 2 8 2 201

1 3 3 2 120

2 2 2 2 120

1 1 8 1 201

2 1 8 1 201

2 2 1 2 120

1 3 9 1 80

1 1 1 2 201

2 2 8 2 2oh

1 1 9 1 400

2 2 1 2 120

1 1 1 2 120

2 2 9 1 80

2 2 9 2 201

1 1 3 2 56

1 1 9 1 80 ·-

2 2 1 2 76

1 1 2 2 56

2 2 2 2 76

1 1 8 2 201

2 1 8 2 201

1 2 1 2 120

1 2 3 2 130

2 2 8 2 201

(continued)

---'�·��----------------------�----""'�-----

Case 3: Physician Care Services, Inc. 103

DAY NUM ART AGE TOWN SEX FIRST INS PHY CHGE

6 20 1230 so 1 1 1 9 1 80

6 21 1240 9 1 2 2 1 2 135

6 22 1240 23 2 1 3 1 2 120

6 23 1300 37 4 1 3 1 2 120 -

6 24 1315 61 5 2 2 1 2 120

6 25 1320 50 1 2 1 1 2 120

6 26 1340 72 2 1 2 3 2 120 -� Totals 189 '._.-:._ �".:,�- !. � � ... �_ �- " ,,"'-.i -� �\'{

- $30,300- �

DAY= 1=Monday, 2= Tuesday, 3= Wednesday, 4= Thursday, s= Friday, 6= Saturday NUM = Arrival order (1 = first person to arrive)

ART= Arrival time AGE = Age in years

TOWN: 1 Middleboro 6 Carterville 2 Mifflenville 7 Boalsburg 3 Jasper 8 Minortown

''"" 4 Harris City 9 Other 5 Statesville

SEX 1 = male, 2 = female

FIRST=: Is this your first ever visit to a PCS center? 1 Yes 2 No, and it is not a medically ordered return visit 3 No , it is a medically ordered return visit

!NS� insurance: coverage/payment 1 Commercial insurance 2 Cash, check, or credit card 3 N1edicare 8 Workers' compensation 9 Employer pays

!='i·:\ • Fh�'s,cat: ·1 Yes 2 No

CHGE = Gross billed charges ($)

(Thi::; tabl,;, r.:\n also o.::. founcl onlinP at ::irhP.org-/books/Middleboro.)

TABLE 3.3 Alpha Center

Patient Records,

August 4-9, 2014

(continued)