fianancial analyst

2

>Instructions Instructions: Save your work on the desktop. Use your last name and first initial for the file name.

Complete the tasks below using the data in the ‘

Fiscal

Risk

Score

‘ tab:

1

) Sort the data: First by Total Risk Score in descending order, then by

Grantee

Name 2) Compute risk level if Column H as follows: HIGH if Total Risk Score >=

5

; MEDIUM if Total Risk Score >=

4

and < 5; LOW if Total Risk Score <4 3

) Color cells RED for high risk grantees, YELLOW for medium risk and GREEN for low risk 4) Using a formula, how many grantees have a historical fiscal compliance score greater than 3? 5) Using filters or formulas, what percentage of grantees have a risk score greater than 3 for

Factor

4

? 6

) Using a formula, how many grantees have had a fiscal review within the last 24 months? 7

) Format the ‘Fiscal Risk Score’ tab as follows: a) Create a header that is repeated on every page when printed with the Title from cell A1. b) Create a footer to include page numbers and the date. 8

) Total risk scores in Column G should be formatted with two decimal points (#.##) 9

) Insert a new tab and summarize the data for at least one factor. 10

) Create a chart or graph summarizing the data on the tab created in the previous step.

Fiscal Risk Score

Factor 4

Grantee

756385438

5 3 5 5

388493

9 1 4 5

5

776587

5 1 4 5

5

7 2 4 1

7

5 3 5 5 4.5

37469955

5 4 4 5 4.5

553299

9 1 2 3

5 3 5 5 4.5

5 3 5 5 4.5

5 1 2 1

8 1 3 1

7 1 4 1

5

4

7 5 3 1

7 3 3 1 3.8

8 5 4 5

8 4 3 4 4.95

7 3 4 4

5

5 1 2 5

5 3 5 5 4.5

6 1 4 5 4.05

14 1 4 1 5.65

5 1 4 5

8 1 4 3

8 1 4 5

5 3 4 5 4.25

484753

8 3 5 1 4.6

8 5 3 4

5 1 3 5 3.5

8 5 2 5

5

6 4 3 5

7 1 1 5 3.6

537422

5 5 2 5 4.25

8 1 3 1 3.6

8 2 2 1 3.6

425574

7 4 4 5 5.1

11 3 5 3

7 1 4 1

8 3 2 1

11 2 2 1 4.5

5 5 4 5

5

7 2 4 5 4.6

8 5 3 2

8 1 2 1

5

5 1 4 5 3.75

16 3 4 4

5 1 2 5 3.25

5 3 5 5 4.5

8 1 4 1 3.85

11 4 2 5

7 4 4 1 4.3

5 3 2 5 3.75

5 3 5 5 4.5

7 1 2 3

5

6 4 3 3

5

5 3 5 5 4.5

5 4 3 5 4.25

5 1 3 5 3.5

5 3 5 5 4.5

5 3 5 5 4.5

6 1 2 1

5 3 5 5 4.5

17417243916 7 1 2 1

7 4 4 2 4.5

5 2 4 5 4

9 3 5 1 4.9

5 4 4 5 4.5

CORP

7 1 4 1 3.55

5 4 4 5 4.5

12 3 4 5

5

5 3 5 5 4.5

5 1 4 5 3.75

8 4 4 4 5.2

5 5 2 5 4.25

5 1 2 5 3.25

5 3 5 5 4.5

7 1 2 3

9 2 3 3 4.55

5 3 5 5 4.5

7 2 3 5

7 4 2 4

7 4 2 4 4.4

7 5 3 1 4.3

7 3 4 5

5 2 4 5 4

5 5 4 5

11 3 4 1

19 1 3 1

9 3 5 1 4.9

5 1 4 5 3.75

8 2 4 2 4.3

7 3 4 5 4.85

18 5 4 3

11 4 3 2

5

5 2 4 5 4

5 1 4 5 3.75

11 2 3 5

5

7 3 5 3 4.7

5 1 4 5 3.75

5 1 4 5 3.75

5 1 3 5 3.5

17565554454 7 4 4 1 4.3

15 5 3 1

14 4 4 2

9 1 4 1

5 1 2 5 3.25

17565554727 9 2 4 1 4.4

22 2 2 1

19 1 4 2 7.35

15 3 3 1

12 3 3 1

17465555445 25 4 2 1

5 4 2 5 4

8 1 3 1 3.6

9 4 3 1 4.65

9 1 3 1

18 2 1 1 6.35

5 3 5 5 4.5

5 3 5 5 4.5

5 2 1 5 3.25

5 2 2 5 3.5

18135366851 5 1 4 5 3.75

11 1 3 1 4.5

7 3 5 3 4.7

22 1 3 1 7.8

15 1 3 1

7 3 3 1 3.8

5 4 5 5 4.75

17426974568 9 2 3 1 4.15

8 3 5 1 4.6

5 2 3 5 3.75

5 4 5 5 4.75

5 3 3 5 4

7 4 1 4 4.15

7 3 5 5 5.1

7 1 3 4 3.9

12 5 1 1 5.3

5 5 1 5 4

5 1 5 5 4

5 2 5 5 4.25

5 2 4 5 4

9 2 3 1 4.15

5 4 1 5 3.75

5 3 4 5 4.25

17465554257 8 2 2 1 3.6

7 1 2 5 3.85

COMMUNITY HEALTH CLINIC

5 5 4 5 4.75

5 1 4 5 3.75

5 4 2 5 4

8 4 4 1 4.6

5 1 4 5 3.75

5 2 2 5 3.5

8 3 5 1 4.6

5 3 5 5 4.5

5 3 5 5 4.5

5 3 5 5 4.5

5 5 4 5 4.75

15 1 1 1 5.2

9 2 5 3

5 3 5 5 4.5

19 3 5 1

14 3 3 1 5.9

5 5 2 5 4.25

5 3 5 5 4.5

5 5 1 5 4

6 2 1 4

8 1 5 5 4.9

8 5 2 3 4.75

5 3 5 5 4.5

7 4 3 5 4.85

5 3 5 5 4.5

5 5 3 5 4.5

15 1 4 5

5 3 5 5 4.5

7 2 5 1 4.05

5 3 4 5 4.25

5 1 3 5 3.5

8 3 5 5 5.4

5 3 5 5 4.5

7 3 5 5 5.1

9 3 5 1 4.9

15 5 3 1 6.7

5 1 5 5 4

15 1 5 1 6.2

13 5 2 1

5 3 5 5 4.5

5 2 3 5 3.75

11 3 5 5 6.3

5 3 5 5 4.5

17415961592 5 4 3 5 4.25

5 1 5 5 4

5 1 2 5 3.25

5 3 5 5 4.5

5 3 5 5 4.5

5 3 5 5 4.5

5 3 5 5 4.5

5 5 3 5 4.5

16 3 5 1 7

7 4 3 5 4.85

5 1 5 5 4

5 1 3 5 3.5

5 1 2 5 3.25

5 1 4 5 3.75

5 2 4 5 4

5 1 4 5 3.75

7 5 3 3 4.7

9 2 4 1 4.4

7 3 5 1 4.3

5 2 2 5 3.5

5 3 5 5 4.5

7 4 1 1 3.55

17465552789 5 3 5 5 4.5

11 4 1 1 4.75

5 1 4 5 3.75

5 3 5 5 4.5

9 1 3 1 3.9

7 3 5 1 4.3

7 2 4 1 3.8

7 1 4 1 3.55

9 3 5 1 4.9

5 4 3 5 4.25

7 1 1 1

5 5 3 5 4.5

11 1 3 3 4.9

7 5 4 5

9 3 2 2 4.35

5 1 3 5 3.5

5 5 4 5 4.75

17465557499 7 2 1 1 3.05

5 3 4 5 4.25

5 3 5 5 4.5

5 4 4 5 4.5

15 1 1 2 5.4

5 3 3 5 4

7 1 4 1 3.55

5 3 5 5 4.5

7 3 4 1 4.05

12 3 5 5 6.6

7 5 2 5 4.85

8 3 3 5 4.9

5 3 5 5 4.5

9 1 1 1 3.4

8 1 2 5 4.15

5 3 5 5 4.5

7 5 4 2 4.75

5 5 2 5 4.25

5 4 2 5 4

9 3 2 1 4.15

5 1 4 5 3.75

8 2 4 1 4.1

5 1 2 5 3.25

5 3 5 5 4.5

TEXAS

5 3 5 5 4.5

5 3 5 5 4.5

5 1 1 5 3

13 5 3 5 6.9

7 2 4 5 4.6

5 2 4 5 4

5 5 3 5 4.5

5 3 4 5 4.25

5 3 5 5 4.5

7 3 5 1 4.3

5 3 5 5 4.5

14 3 5 1

8 1 2 5 4.15

5 4 4 5 4.5

8 1 4 1 3.85

5 3 5 5 4.5

5 3 5 5 4.5

5 3 5 5 4.5

5 2 1 5 3.25

5 1 4 5 3.75

8 1 1 2 3.3

11 3 5 1 5.5

7 4 4 4 4.9

15 2 1 1

5 4 4 5 4.5

8 2 4 1 4.1

11 1 2 5 5.05

5 1 4 5 3.75

5 5 1 5 4

7 3 5 5 5.1

9 5 4 1

5 3 5 5 4.5

7 4 2 5 4.6

5 3 2 5 3.75

5 3 5 5 4.5

7 1 4 5 4.35

11 4 3 5

7 1 4 5 4.35

11 1 3 4 5.1

5 3 4 5 4.25

7 3 4 4 4.65

7 2 3 3

9 2 4 1 4.4

5 5 2 5 4.25

13 1 1 3 5

5 1 1 5 3

15 2 4 4

15 3 3 3 6.6

5 3 5 5 4.5

8 1 4 1 3.85

5 5 3 5 4.5

9 2 4 1 4.4

5 3 4 5 4.25

5 1 3 5 3.5

7 5 1 5 4.6

5 3 4 5 4.25

8 3 4 1 4.35

5 2 1 5 3.25

9 1 2 2 3.85

5 2 3 5 3.75

5 3 5 5 4.5

5 3 5 5 4.5

5 5 2 5 4.25

8 1 1 4 3.7

5 1 4 5 3.75

9 2 4 1 4.4

8 1 4 5 4.65

5 3 1 5 3.5

11 2 4 1 5

7 3 4 1 4.05

5 3 4 5 4.25

7 3 5 5 5.1

5 5 4 5 4.75

5 2 2 5 3.5

5 2 4 5 4

5 2 4 5 4

7 3 2 4 4.15

7 1 2 5 3.85

8 4 1 1 3.85

7 1 4 5 4.35

5 5 3 5 4.5

5 5 2 5 4.25

12 5 3 1 5.8

5 5 3 5 4.5

5 5 2 5 4.25

5 5 2 5 4.25

15 3 4 1

5 3 5 5 4.5

12 4 1 1 5.05

5 5 4 5 4.75

5 1 2 5 3.25

5 3 5 5 4.5

5 3 5 5 4.5

7 5 4 4 5.15

15 4 1 1

8 1 4 1 3.85

9 2 4 1 4.4

8 4 4 1 4.6

9 1 2 1

5 3 5 5 4.5

8 3 3 2 4.3

5 2 4 5 4

5 3 1 5 3.5

5 3 5 5 4.5

5 1 4 5 3.75

5 2 1 5 3.25

13 2 2 5 5.9

7 3 1 5 4.1

12 4 4 1 5.8

7 3 4 5 4.85

5 3 5 5 4.5

7 4 3 4 4.65

17465555741 7 3 5 5 5.1

17465525758 7 3 5 5 5.1

15 2 1 3 5.85

7 2 2 4 3.9

9 2 4 1 4.4

15 5 4 4

7 1 3 5 4.1

8 2 3 4

5 5 1 5 4

5 1 3 5 3.5

8 2 4 1 4.1

5 5 3 5 4.5

5 2 4 5 4

11 2 4 1 5

5 5 1 5 4

7 2 4 2 4

7 2 1 3 3.45

7 2 3 3 3.95

8 1 2 1 3.35

8 3 2 5 4.65

7 2 1 5 3.85

5 1 5 5 4

7 3 1 5 4.1

5 3 5 5 4.5

22 5 3 1

5 3 5 5 4.5

7 1 3 5 4.1

13 1 2 1 4.85

18 1 2 5

14 4 4 1 6.4

14 2 1 1 5.15

5 4 4 5 4.5

TARRANT COUNTY

14 1 1 2 5.1

17521264551 5 1 2 5 3.25

9 5 3 3 5.3

11 1 2 5 5.05

8 3 5 1 4.6

17565542214 11 3 1 5 5.3

8 4 3 1 4.35

5 3 5 5 4.5

7 1 3 4 3.9

5 3 5 5 4.5

5 2 3 5 3.75

7 1 3 4 3.9

5 1 4 5 3.75

5 3 5 5 4.5

17514523658 7 1 2 4 3.65

5 1 3 5 3.5

5 3 5 5 4.5

17415956597 12 3 5 5 6.6

5 5 4 5 4.75

5 5 4 5 4.75

7 1 4 5 4.35

5 3 5 5 4.5

7 1 4 4 4.15

9 2 1 5 4.45

5 3 5 5 4.5

5 3 5 5 4.5

5 3 5 5 4.5

11 3 1 5 5.3

11 1 4 5

11 3 5 5 6.3

11 5 3 5 6.3

5 3 5 5 4.5

14 3 5 1 6.4

11 1 4 5 5.55

11 4 4 5 6.3

TOM GREEN COUNTY

9 1 1 1 3.4

5 3 5 5 4.5

8 3 4 5 5.15

8 3 5 5 5.4

11 3 5 1 5.5

5 3 5 5 4.5

11 1 3 5 5.3

5 1 4 5 3.75

14612678252 5 4 3 5 4.25

14 3 3 1 5.9

5 3 5 5 4.5

5 1 4 5 3.75

5 3 5 5 4.5

5 4 4 5 4.5

6 3 5 1 4

7 5 3 4 4.9

5 3 5 5 4.5

7 1 1 5 3.6

5 2 2 5 3.5

18 3 5 1

5 1 3 5 3.5

8 5 3 4 5.2

8 2 1 5 4.15

14 1 4 1 5.65

7 1 4 5 4.35

5 3 5 5 4.5

17565557142 8 3 2 5 4.65

15 1 1 5 6

5 3 5 5 4.5

14 3 5 5

16 3 5 5 7.8

10 2 2 5 5

5 3 5 5 4.5

5 2 4 5 4

8 1 4 5 4.65

12 1 4 5 5.85

9 2 4 5 5.2

11 4 2 5 5.8

12 5 3 5 6.6

8 3 3 5 4.9

6 4 4 5 4.8

Single Audit Risk Scoring Worksheet
Factor 1	Factor 2	Factor 3
Grantee ID (TIN)	Single Audit Results (total risk score)	Historical Fiscal Compliance		Latest Fiscal Review	% HHS Funds per SEFA	Total Fiscal Risk Score	Grantee	Risk Level
1 STOP RECOVERY INC											12																																																																																															4.5
ABILENE REGIONAL COUNCIL ON ALCOHOL AND	175																15												4.9
ABILENE REGIONAL M H M R CENTER	175					13																								3.7
Abilene-Taylor County Public Health District		17565554454				3.8
Able Center for Independent Living	17524856											14
ABOUNDING PROSPERITY INC	1	25
ACCESS ESPERANZA CLINICS INC	174			16					4.05
ADAPT PROGRAMS LLC	12645959842
AGGIELAND HUMANE SOCIETY	17421552885
AIDS ARMS INC	17523561459	2.45
AIDS Outreach Center	17521393367							3.6
AIDS SERVICES OF AUSTIN INC	17424458452																		3.5
ALAMO AREA RESOURCE CENTER INC	17425832																											11									4.3
ALCOHOL & DRUG ABUSE COUNCIL FOR THE	17516593287
ALCOHOL AND DRUG ABUSE COUNCIL OF DEEP E	17516683595			5.65
ALIVIANE INC	17416814857
ALPHA HOME INC	17416681447												4.6
AMARILLO COUNCIL ON ALCOHOLISM & DRUG AB	17511534975													3.25
AMBASSADORS FOR CHRIST YOUTH MINISTRIES	12558538733
ANDERSON/CHEROKEE COUNTIES ENRICHMENT SE	17524861254
ANDREWS CENTER	17512814158
ANDREWS COUNTY	17565558157						3.75
ANGELINA COUNTY CITIES HEALTH DISTRICT	17512443767																								4.25
ANY BABY CAN OF AUSTIN INC	17426843359							4.65
ANY BABY CAN OF SAN ANTONIO, INC	17426843334
Arcil Inc.	174			22
ASSOCIATION FOR THE ADVANCEMENT OF MEXIC	17416969615					5.2
ASSOCIATION OF PERSONS AFFECTED BY ADDIC	17522834513
ATASCOSA HEALTH CENTER INC	17425891532										5.1
AUSTIN RECOVERY INC	17416591584		4.55
AUSTIN/TRAVIS COUNTY MHMR	17415479595
AZLEWAY INC	175			19
BAPTIST HOSPITALS OF SOUTHEAST TEXAS	17413537255
BARRIO COMPREHENSIVE FAMILY HEALTH CARE		17417243916
BAY AREA COUNCIL ON DRUGS & ALCOHOL INC	174				18
Bay Area RehabilitationCenter	17413537213				5.9
BAYLOR COLLEGE OF MEDICINE	17416138786					3.55
BEE BUSY LEARNING ACADEMY INC	17656587586										3.85
BEE BUSY WELLNESS CENTER	12756535149
BEHAVIORAL HEALTH ALLIANCE OF TEXAS INC	16855559749					4.7
BEHAVIORAL HEALTH SOLUTIONS OF SOUTH TEX	17426488858
Bell County Public Health District	17465553485		4.8
BEXAR COUNTY	17465525393			3.3
BEXAR COUNTY BOARD OF TRUSTEES FOR MHMR		17415956597
BEXAR COUNTY HOSP DIST	17465521649		7.35
BIG COUNTRY REGIONAL ADVISORY COUNCIL IN	17525886825
BILLY T CATTAN RECOVERY OUTREACH INC	17429617982
BLUEBONNET TRAILS COMMUNITY MHMR CENTER	17427953322
BLUES MANAGEMENT INC	17654574558				5.8
BORDER REGION MHMR COMMUNITY CENTER	17429449311
BOYS & GIRLS CLUB OF MCALLEN INC	17415536469
BOYS & GIRLS CLUBS OF EDINBURG RGV INC	17425496522
BOYS & GIRLS CLUBS OF GREATER FORT WORTH	17558587859				3.4
BRAZORIA COUNTY	7465555445														4.1
Brazoria County Association for Citizens	12374418338
Brazoria County Health Department		17465555445
BRAZOS COUNTY	17465554335
BRAZOS MATERNAL & CHILD HEALTH CLINIC IN	17423976715
Brazos Valley Center for Independent	12726759319
BRAZOS VALLEY COMMUNITY ACTION AGENCY IN	17417151458	2.75
BRAZOS VALLEY COMMUNITY ACTION PROGRAMS		18135366851
Brazos Valley Council of Governments		3.05
BRAZOS VALLEY COUNCIL ON ALCOHOL & SUBSTANCE ABUSE	17423456846
BRAZOS VALLEY REGIONAL ADVISORY COUNCIL		17426974568
Brighton School Inc.	17423318264
BROWN COUNTY HUMANE SOCIETY	12374376973
BROWNSVILLE	COMMUNITY HEALTH CLINIC	17421768361
Brownwood-Brown County Health Department		17565554727
BURKE CENTER	17514423932						6.3
BURNET COUNTY	17465554546
CAMERON COUNTY DEPARTMENT OF HEALTH AND HUMAN SERVICES		17465554257
CAMINO REAL COMMUNITY MHMR CENTER	17429517547
CANCER AND CHRONIC DISEASE CONSORTIUM	17426861315
CAPITAL AREA TRAUMA RAC	17427478564
CAPSS CHILDREN AND PARENT SOCIAL SERVICE	13523995946
CARDEA SERVICES	19424519495	3.45
CAREER AND RECOVERY RESOURCES INC	17411619426
CCM FOUNDATION	12545655771
CENIKOR FOUNDATION	17655318616									4.35
CENTRAL COUNTIES CENTER FOR MHMR SERV	17418513326									4.4
CENTRAL PLAINS CENTER FOR MHMR	17512943555
CENTRAL TEXAS COMMUNITY HEALTH CENTERS	15558531181
CENTRAL TEXAS MHMR CENTER	17512944327							4.85
CENTRAL TEXAS NETWORK FOR CHILDREN WITH	17426457953
CENTRAL TEXAS REGIONAL TRAUMA ADVISORY C	17426618215												4.75
CENTRO DE SALUD FAMILIAR LA FE INC	17418421693	5.25
CENTRO SAN VICENTE	17425555617		6.9
CHAMBERS COUNTY	17465555361
CHAMBERS COUNTY PUBLIC HOSPITAL DISTRICT	17651536299
CHANGE HAPPENS!	17652975314
CHARLIE’S PLACE RECOVERY CENTER	17415958671
CHEROKEE COUNTY	17565558546	8.25
CHEYENNE CENTER INC	12633958153				5.4
CHILD STUDY CLINIC	17419776749
CHILDRENS MEDICAL CENTER OF DALLAS	17558556289
CHRISTIAN FARMS-TREEHOUSE INC	12371548988			5.5
CHRISTUS HEALTH ARK-LA-TEX	17527968154
CHRISTUS HEALTH SOUTHEAST TEXAS	17655915953
CHRISTUS SANTA ROSA HEALTH CARE CORPORAT	17411596658
CIS OF SOUTH CENTRAL TEXAS INC	17426534524
CITY OF ABILENE
CITY OF AMARILLO	17565554446		6.7
CITY OF AUSTIN	17465555858					6.6
CITY OF BEAUMONT		17465552789				4.15
CITY OF BOVINA	17565535812
CITY OF BROWNWOOD
CITY OF CORPUS CHRISTI		17465555741			7.8
CITY OF DALLAS	17565555588
CITY OF EL PASO		17465557499		6.2
CITY OF GARLAND	17565555344						5.3
CITY OF HOUSTON	9.2
City of Houston Department of Health and Human Services	17465511645
CITY OF LAREDO	17465515732
CITY OF LONGVIEW	17565555885
City of Lubbock	17565555956						3.9
CITY OF MIDLAND	17565556586
CITY OF PETERSBURG	17565556375
CITY OF PLAINS	17565537792
CITY OF PLAINVIEW	17565556391
City of Port Arthur	17465518855
CITY OF SAN ANGELO
CITY OF SAN ANTONIO		17465525758
CITY OF SAN MARCOS	17465522381
CITY OF TEXARKANA	17565556896
CITY OF WACO	17465524684	5.7
CITY OF WICHITA FALLS		17565557142
CLEAN INVESTMENTS INC	17428654155
Clear Creek Independent School District
Coalition for Barrier Free Living	17418559526
COALITION OF HEALTH SERVICES INC	17525591624
Coastal Bend Center for Independent	17428785758
COASTAL BEND REGIONAL ADVISORY COUNCIL	17426816389
COASTAL BEND WELLNESS FOUNDATION INC	17424295185
COASTAL PLAINS COMMUNITY MHMR CENTER	17429191785
COLLIN COUNTY	17565558736
COLLIN COUNTY MHMR CENTER	17517619114
COLLINS FAMILY PLANNING CLINIC	15558657598
COMAL COUNTY	17465517753
COMMUNITIES IN SCHOOLS OF THE COASTAL BEND	17424294456
COMMUNITIES IN SCHOOLS-EL PASO INC	17425247151
COMMUNITY ACTION CORPORATION OF SOUTH TE	17416798241
COMMUNITY ACTION INC OF CENTRAL TEXAS	17415417264
COMMUNITY FAMILY CENTERS	17416916322
Community Health Center of Lubbock
COMMUNITY HEALTH CENTERS OF SOUTH CENTRA	17415485895
17526592162
COMMUNITY HEALTH DEVELOPMENT INC	17422697395
CONCHO VALLEY REGIONAL ADVISORY COUNCIL	17526358378
CONNECTIONS INDIVIDUAL&FAMILY SERVICES	17421791694
COOK CHILDREN’S MEDICAL CENTER	17525516463
CORSICANA-NAVARRO HEALTH DEPT	17565558517
Crockett Resource Ctr for Indep Living	17519768752
DAILEY RECOVERY SERVICE	12635959559
DALLAM-HARTLEY COUNTIES HOSPITAL DISTRIC	17517521626
Dallas Center Inc.	17515831521
DALLAS CHALLENGE INC	17519642338
DALLAS COUNTY	17565559556
Dallas County Hospital District		17565542214				5.05
DALLAS INTER-TRIBAL CENTER INC	12371569455
DALLAS ISD	17565512787	7.9
DALLAS METROCARE SERVICES	17512856534
DEBORAH JUDITH INC	17428864312
DELTA COUNTY	17565559148
DENTAL HEALTH PROGRAMS INC	17518236653
DENTON COUNTY	17565559255	3.35
DENTON COUNTY MHMR CENTER	17513681514
DEPELCHIN CHILDREN’S CENTER	17653188677
Disability in Action Inc.	14615788532
DRISCOLL CHILDRENS HOSPITAL	17425777467
DRUG & ALCOHOL ABUSE RECOVERY CENTER	17414552281
DRUG PREVENTION RESOURCES INC	17559116715
EAST TEXAS BORDER HEALTH CLINIC	15355389123	6.75
East Texas Center for Independent Living	17523754546
East Texas Community Health Services, Inc	17521843692
EAST TEXAS COUNCIL ON ALCOHOLISM & DRUG	17565486296
EAST TEXAS GULF COAST REGIONAL TRAUMA	17656252856
EASTER SEAL REHABILITATION CENTER INC	17416531795
EASTER SEALS EAST TEXAS INC	17152591371
EASTER SEALS OF GREATER HOUSTON INC	17412384186
EASTER SEALS-CENTRAL TEXAS, INC.	17558588113
ECTOR COUNTY	17565559346
ECTOR COUNTY HOSPITAL DISTRICT	17523529282
Education Service Center Reg XV	17512542378
EL CENTRO DE CORAZON	17654427819			5.85
EL CENTRO DEL BARRIO INC	17417875312
EL PASO CHILDREN’S HOSPITAL CORPORATION	12635754294
EL PASO COMMUNITY MHMR		17415961592
EL PASO DIABETES ASSOCIATION INC	17417594152
EMERGENCE HEALTH NETWORK
EPILEPSY FOUNDATION OF CENTRAL & SOUTH T	17654153381
EPILEPSY FOUNDATION OF TEXAS	17421415845
EQUEST	17518237515
ETHOS FOUNDATION INC	14656624765
EXCELLENT TEEN CHOICE INC	12717153316
FAITH ALWAYS INSPIRES TRUE HEALING WORKS	12555341445
FAMILY AND CHILD GUIDANCE CENTERS	17558556355
FAMILY ENDEAVORS, INC.	12372235784
FAMILY SERVICE ASSOCIATION OF SAN ANTONI	17411173416
FAMILY SERVICE CENTER OF HOUSTON & HARRI	17411526134
FAMILY SERVICES OF SOUTHEAST TEXAS INC	17413827134
FAMILY SUPPORT SERVICES OF AMARILLO	17558556425
FAMILY VIOLENCE PREVENTION SERVICES INC	17419941517
FAR WEST TEXAS & SOUTHERN NEW MEXICO	17427419688
FISHER COUNTY HOSPITAL DISTRICT	17514334956
FORT BEND COUNTY	17465519692
FORT BEND FAMILY HEALTH CENTER INC	17419514769
FORT BEND REGIONAL COUNCIL ON SUBS/ABUSE	17418733337
FRIENDS OF GONZALES ANIMAL SHELTER INC	13315947456
FUTURE LEADERS OUTREACH NETWORK	14318624989
GALVESTON COUNTY HEALTH DISTRICT	17655214745
Garland Health Department
GATEWAY COMMUNITY HEALTH CENTER INC	17425534595
GIRLS INC OF GREATER HOUSTON	17654838122
GIRLS LIVING LIFE ON PURPOSE INC	12536542165
GOLDEN CRESCENT REGIONAL ADVISORY COUNCI	17429555175
GRAYSON COUNTY	17565559692
GREATER DALLAS COUNCIL ON ALCOHOL AND DR	17558587768
GREGG COUNTY	17565559718
GUADALUPE REGIONAL MEDICAL CENTER	17413865531
GULF BEND MHMR CENTER	17416595648
GULF COAST HEALTH CENTER INC	17652899274	2.8
HANDS TOGETHER FAMILY HEALTH CENTER INC	14732865432
HARDIN COUNTY	17465515369
HARRIS COUNTY	17654545149	5.35
HARRIS COUNTY HOSPITAL DISTRICT	17415369366
HAVEN FOR HOPE OF BEXAR COUNTY	12585754125
HAVEN HEALTH CLINICS	17512853486
Hays County
HAYS-CALDWELL COUNCIL ON ALCOHOL AND DRU	17423476468
HEADSTRONG PROJECT	14552619575
HEALING THE FAMILY INC	15355818514
HEALTH CENTER OF SOUTHEAST TEXAS	15625585512
HEALTH EDUCATION LEARNING PROJECT (HELP)	17525715255
HEALTH HORIZONS OF EAST TEXAS INC	17523358848
Heart of Central Texas Independent Living	17435598545
Heart of Texas Community Health Center, Inc.	17428675859
Heart of Texas Region MH & MR Center	17416229585
HEART OF TEXAS REGIONAL ADVISORY COUNCIL	17427576455
HELEN FARABEE CENTERS	17512419767
HERITAGE COMMUNITY SERVICES	15715373591
HIDALGO COUNTY	17465557176
HILL COUNTRY COMMUNITY MHMR CENTER	17428225176
HILL COUNTRY COUNCIL ON ALCOHOL & DRUG A	17426577375
HOMELESS NETWORK OF TEXAS	17426465864
HOMEWARD BOUND INC	17421278411
HOSPITAL PREPAREDNESS COUNCIL OF NORTH T	12589243588
HOUSTON AREA COMMUNITY SERVICES INC	17655492458
HOUSTON COUNCIL ON ALCOHOLISM AND DRUG A	17411732351
HOUSTON INDEPENDENT SCHOOL DISTRICT	17465512556
HOUSTON REGIONAL HIV/AIDS RESOURCE GROUP	17654142327
HUMANE SOCIETY OF HARLINGEN	17425167495
HUMANE SOCIETY OF	TOM GREEN COUNTY	17565354598
HUMANE SOCIETY OF WICHITA COUNTY	17511543633
HUNT COUNTY	17565515179
IBN SINA FOUNDATION INC	17656984643
JASPER-NEWTON BI-COUNTY HEALTH DEPT	17465514578
JOHNSON COUNTY	17565515352
JOVEN – JUVENILE OUTREACH AND VOCATIONAL	17427837822
KARNES COUNTY	17465514855
KARNES COUNTY HUMANE ORGANIZATION	15157683512
KATY ISD	17465514842
KAUFMAN COUNTY	17565515369
LA ESPERANZA CLINIC INC	17426997627			6.4
LAKES REGIONAL MHMR CENTER	17528338233
LAND MANOR	17416469793
LEGACY COMMUNITY HEALTH SERVICES INC	17655596378
LENA POPE HOME INC	17565535838
LIFESTEPS COUNCIL ON ALCOHOL AND DRUGS	17419979772
Lifetime Independence for Everyone Inc.	17522178353
LIMESTONE COUNTY	17465515175
LIVE OAK COUNTY	17465559751
LONE STAR CIRCLE OF CARE	17435516745
LONE STAR COMMUNITY HEALTH CENTER INC	13555388656
LONGVIEW WELLNESS CENTER INC	17527239937
LOS BARRIOS UNIDOS COMMUNITY CLINIC	17513786644	5.45
LOWER RIO GRANDE VALLEY REGIONAL	17427361245
Lubbock ISD	17565519899
Lubbock Regional MHMR Center DBA StarCare Specialty Health System	17512976915
MANAGED CARE CENTER FOR ADDICTIVE AND	17516574832
MARSHALL HARRISON COUNTY HEALTH DISTRICT	17424494255
MATAGORDA COUNTY HOSPITAL DISTRICT	17465255693
MATAGORDA EPISCOPAL HEALTH OUTREACH PROG	12555379487				5.15
MAVERICK COUNTY HOSPITAL DISTRICT	17465557551
MEDINA COUNTY	17465511561
MEDMARK TREATMENT CENTERS OF TEXAS INC	12742555329
MEMORIAL HEALTH SYSTEM OF EAST TEXAS	17557553679
MENTAL HEALTH AMERICA OF TEXAS	17413832852
MENTAL HEALTH RESOURCE OF TEXAS	14649316558	6.05
MHMR Authority of Brazos Valley	17417932658
MHMR OF	TARRANT COUNTY	17512494562
MHMR SERVICES FOR THE CONCHO VALLEY	17512515234
MHMR SERVICES OF TEXOMA		17514523658
MID-COAST FAMILY SERVICES INC	17426556697		3.95
MIDLAND COMMUNITY HEALTHCARE SERVICES	18353586855
MILAM COUNTY	17465554819
MONTGOMERY COUNTY	17465555584
MONTGOMERY COUNTY PUBLIC HEALTH DISTRICT	14656984186
Montrose Center	17425552456	6.8
MOSAIC FAMILY SERVICES INC	17524845652
Mounting Horizons	17535997695
MT ENTERPRISE COMMUNITY HEALTH CLINIC	14325162879
MY SECOND CHANCE INC	17528552747
NACOGDOCHES COUNTY	17565515885
NACOGDOCHES COUNTY HOSPITAL DISTRICT	17565556529
NEXT STEP COMMUNITY SOLUTIONS	17519896215
NEXUS RECOVERY CENTER INCORPORATED	12371693883
NOLAN COUNTY	17565515948
NORTH CENTRAL TEXAS COMMUNITY HEALTH CAR	17524296443
NORTH CENTRAL TEXAS TRAUMA RAC	17525344929
NORTH TEXAS AREA COMMUNITY HEALTH CENTER	15421179894
NORTH TEXAS BEHAVIORAL HEALTH AUTHORITY	17528112695
NORTH TEXAS REGIONAL ADVISORY COUNCIL	17528584936
NORTH TEXAS REHABILITATION CENTER INC	17515536315
NORTH TX ADDICTION COUNSELING & ED INC	17526983162
Northeast Texas Public Health District	17522545445
NORTHEAST TEXAS REGIONAL ADVISORY COUNCI	17525531574
NUECES COUNTY	17465555857
NUECES COUNTY MHMR COMMUNITY CENTER	17416237596
OPEN ARMS INC	17522175599
ORANGE COUNTY	17465518264
OXFORD HOUSE INC	15215822311
PALMER DRUG ABUSE PROGRAM-MIDLAND TEXAS	17518474337
Panhandle Independent Living Center Inc.	17526117464
PANHANDLE RAC TRAUMA SERVICE	17525689166
PARIS-LAMAR COUNTY HEALTH DEPT	17565522567
PARKER COUNTY	17565511594
PARKER COUNTY HOSPITAL DISTRICT	17512886841
Paso del Norte Children’s Development Center	17413123138
PECAN VALLEY MHMR REGION	17515321552
PEOPLES COMMUNITY CLINIC	12375876583
PERMIAN BASIN COMMUNITY CENTERS FOR MHMR	17514517767
PERMIAN BASIN REGIONAL COADA	17523558153
PHC GLOBAL	14629959455
PHOENIX HOUSES OF TEXAS INC	11338155735
PINEY WOODS REGIONAL ADVISORY COUNCIL	17415417744
PLAINVIEW FOUNDATION FOR RURAL HEALTH AD	17528789659
PLAINVIEW SERENITY CENTER INC	17519458446
POLK COUNTY	17465516219	6.45
POST ANIMAL REFUGE CENTER	12719257644
PROJECT VIDA HEALTH CENTER	16855416485
RAINBOW DAYS INC	17518449581
REACH-MIDLOTHIAN INC	17522448355
REAL LEADERSHIP OBEDIENCE VICTORY AND EX	14648797356
RECOVERY CENTER OF CAMERON COUNTY	13116521645
RECOVERY RESOURCE COUNCIL	17565555936
RED RIVER COUNTY	17565511243	5.95
Region I EducationService Center	17415881865
REGION III EDUCATION SERVICE CENTER	17415861495
REGION XIX EDUCATION SERVICE CENTER	17415888563
Region XVI Education Service Center	17512467655		3.65
Rehabilitation Education and Advocacy	17521829667
RESOURCE CENTER OF DALLAS, INC	17518925594
RESPITE CARE OF SAN ANTONIO INCORPORATED	17424677755
RISE RECOVERY	17422165415
Rise-Resource Information Support	17654628622
ROCKWALL COUNTY	17565511292
RUSK COUNTY	17565511334
SABINE VALLEY REGIONAL MHMR CENTER	17517245176
San Angelo-Tom Green County Health Department	17524853664
SAN ANTONIO AIDS FOUNDATION INC	17424278533
SAN ANTONIO COUNCIL ON ALCOHOL & DRUG AB	17413451885
San Antonio Independent Living Services	17423765838
SAN ANTONIO LIFETIME RECOVERY INC	17415455971
San Antonio Metropolitan Health District
SAN ANTONIO METROPOLITAN HEALTH DISTRICT WIC PROGRAM
SAN PATRICIO COUNTY	17465523574
SANTA MARIA HOSTEL	17416691313
SEARCH HOMELESS SERVICES	17652654539
Seasons of Change Inc	13312125395	7.55
SERENITY FOUNDATION OF TEXAS	17515712551
SERVING CHILDREN AND ADULTS IN NEED INC	17422459358		4.45
SETON FAMILY OF HOSPITALS	17411596435
SEVEN FLAGS REGIONAL ADVISORY COUNCIL ON	17429154937
SHACKELFORD COUNTY COMMUNITY RESOURCE	17525419755
SHARING HANDS A RESPITE EXPERIENCE INC	12627857563
SKILLFUL LIVING CENTER INC	17527529171
SOUTH PLAINS COMMUNITY ACTION ASSOCIATIO	17512352195
SOUTH PLAINS PUBLIC HEALTH DISTRICT	17565524717
SOUTH PLAINS RURAL HEALTH SERVICES INC	17521232524
SOUTH TEXAS DEVELOPMENT COUNCIL	17416669215
SOUTH TEXAS FAMILY PLANNING & HEALTH COR	17417286212
SOUTH TEXAS RURAL HEALTH SERVICES INC	17419551965
SOUTH TEXAS SUBSTANCE ABUSE RECOVERY SER	17416584659
SOUTHEAST TEXAS REGIONAL ADVISORY	17654191725
SOUTHWEST COMMUNITY ECONOMIC DEVELOPMENT	16114525338
SOUTHWEST TEXAS REGIONAL ADVISORY COUNCIL	17428964328
SPCA OF EAST TEXAS INC	12721889827
SPECIAL HEALTH RESOURCES FOR TEXAS	17524552536	8.8
SPECIALTY PHYSICIANS OF CENTRAL TEXAS IN	12588144589
SPINDLETOP MHMR CENTER	17656224875
ST HOPE PHARMACY	17518257927
STAR COUNCIL ON SUBSTANCE ABUSE	14122738257	7.15
STEPHEN F AUSTIN COMMUNITY HEALTH CENTER	17423579759
Su Clinica Familiar	12655811132
SUCCEEDING AT WORK	17565511756
	17521264551
TARRANT COUNTY CHALLENGE INC
Tarrant County Hospital District	17565554396
TEXANA CENTER	17652532875
Texarkana Special Education Center Inc.	17165651315
Texarkana-Bowie County Family Health Center
TEXAS ASSOCIATION OF COMMUNITY HEALTH	17423586952
Texas Children’s Health Plan	17654862643
TEXAS CHILDREN’S HOSPITAL	17411555555
TEXAS FUNERAL DIRECTORS ASSOCIATION INC	17412345196
TEXAS J REGIONAL ADVISORY COUNCIL	17527865111
TEXAS PANHANDLE MHMR	17561761218
TEXAS PARENT TO PARENT	16555515277
Texas State Independent Living Council	13115827977
TEXOMA COMMUNITY CENTER
THE ARC OF SAN ANTONIO INC	17412551153
THE CATTERY INC	12651782555
THE CENTER FOR HEALTH CARE SERVICES
THE COALITION INC	12585597792
THE COMMUNITY HEALTH SERVICE AGENCY INC	17515286148
THE COUNCIL ON ALCOHOL AND DRUG ABUSE	17416964918
THE ECUMENICAL CENTER FOR RELIGION AND	17415873888
THE GULF COAST CENTER	17416579873
THE HARRIS CENTER FOR MENTAL HEALTH AND	17416539555
THE HEIDI GROUP	17427579192
THE HENDERSON COUNTY HELP CENTER INC	17523627945
THE ROSE	17651938123
THE SOURCE FOR WOMEN OF HOUSTON INC	17655256618
THE SUBSTANCE ABUSE COUNCIL	17518388123		5.55
THE TEXAS INTERNATIONAL INSTITUTE OF HEA		14612678252
THE TURNING POINT INC	17651654162
The Valley Association for Independent	17425567455
The Warren Center Inc.	17512825452
THE WEST TEXAS REHABILITATION CENTER	17558683252
TITUS COUNTY MEMORIAL HOSPITAL	17565539355
17565511847
TOMORROW’S CHILDREN INC	12619779549
TRAUMA SERVICE AREA-H RAC	17525757224
TRI-COUNTY BEHAVIORAL HEALTHCARE	17655326627
TRINITY COUNTY	17465515246
TRINITY MOTHER FRANCES HEALTH SYSTEM FOU	17525282413
TROPICAL TEXAS BEHAVORIAL HEALTH	17415655153
TSA-B REGIONAL ADVISORY COUNCIL (BRAC) I	15256656898
TX INTERNATIONAL INSTITUTE OF HEALTH PRO
UNITED MEDICAL CENTERS	17419935759
UNITED WAY OF DENTON COUNTY INC	17512511282
UNITED WAY OF THE GREATER FORT HOOD AREA	17417555447
UNIVERSITY OF TEXAS MEDICAL BRANCH AT	37237237237
UNLIMITED VISIONS AFTERCARE INC	17655352152
UVALDE COUNTY	17465524221
VALLEY AIDS COUNCIL	17425125915
VETERANS COALITION OF NC TEXAS	14615348451
VIABLE OPTIONS IN COMMUNITY ENDEAVORS	17524916859
VICTORIA COUNTY PUBLIC HEALTH DEPARTMENT	17465524452
Volar Center for Independent Living	17424219768	7.6
VOLUNTEERS AT THE CREEK	12556257141
VOLUNTEERS OF AMERICA TEXAS INC	17558274697
Waco-McLennan County Public Health District (by and through City of Waco)	17465524866
WALKER COUNTY	17465514321
WEST TEXAS CENTERS FOR MHMR	17526561696
WEST TEXAS COUNSELING & GUIDANCE INC	17515615999
Wichita Falls – Wichita County Public Health District
Williamson County & Cities Health District	17428969561
WILSON COUNTY	17465558555
WISE COUNTY	17565512535	7.2
WOMEN IN POSITION EVERYWHERE MINISTRY	18138365351
WOMENS AND MENS HEALTH SERVICES OF THE	17414652549
WOMEN’S HEALTH CARE CENTER INC	19434328324
WOOD COUNTY	17565512592
WOODVILLE ANIMAL SHELTER	11343555297
WORKERS ASSISTANCE PROGRAM INC	17418479915
YOUNG WOMEN’S CHRISTIAN ASSOC	17559394275
YOUTH ADVOCATE PROGRAMS INC	12319775149
YOUTH AND FAMILY ALLIANCE	17421371893
YSLETA DEL SUR PUEBLO	17418513382
YWCA OF GREATER AUSTIN	17465534971

Fiscal Risk Matrix

/ 2018

FY 2017

Factor Risk

Risk Level

)

2 3 4

est)

1

High

High

See Audit Risk Score Matrix See Audit Risk Score Matrix See Audit Risk Score Matrix See Audit Risk Score Matrix

2

High High

High

3

Medium Low

Medium Latest Fiscal Review

No Review History 25%

4

High Low

Medium

20%

5

High Low

Medium

>30-50% >50-70% > 70% or cannot be determined 0%

DSHS FMU Fiscal Risks for Recipient and Sub-recipient Awards –

FY 2017

Risks Assessed by DSHS and HHSC FMU

9/1/16-8/31/17

9/1/15-8/31/16

9/1/14-8/31/15

FY 2016

FY 2015

FY 2014 or before

Impact

Likelihood

Mitigating factors/ controls

Measure:

MSS Risk Category for Measure

1 (

Low

5 (

High

HHSC Weight

DSHS Weight

Notes:

Weak internal controls over financial operations; Findings impacting programs; If no audit, entity lacks oversight.

Medium

Review audit reports; follow up on findings and Corrective Actions Plans; Management decision letters.

Single Audit Results*

Internal Controls

See Audit Risk Score Matrix

3

0%

Audit Risk Score is calculated using 7 weighted sub-factors (based on review of single audit report, if available). See ‘Audit Risk Score’ tab.

Repeat non-compliance, errors or fraud. Improper payments; misuse of funds.

Fiscal Follow up reviews; technical assistance; special reviews; accelerated monitoring

Historical fiscal compliance

No findings or questioned costs in last review

One Finding

Two Findings or

No Review History

3 Findings OR Questioned Costs < $10,000

>3 findings OR Repeat findings OR Questioned Costs >= $10,000

25%

Based on Most Recent DSHS or HHSC Fiscal Review; could expand to per contract score

Insufficient monitoring may fail to detect problems.

Fiscal review cycle; follow up reviews; accelerated monitoring

Length of time since last Fiscal Monitoring

<12 months

12 – 24 months

25 – 35 months

36+ months

Based on Fiscal Year of Most Recent DSHS or HHSC Review

Insufficient funding for program operations; Going concern considerations.

Add risk points for high percentage of funding

HHS Percentage of total Grant Funding

<

20%

20-30%

>30-50%

>50-70%

> 70% or cannot be determined

Percentage = HHS Awards / Total Awards. May be found in audit reports or financial statements. High risk if cannot be determined.

Insufficient funding for the program(s); Loss of Core Funding; Unable to fund program expansion.

Contract Manager has knowledge of funding changes

Change in funding (from prior year)

< 10%

10-30%

May be found in audit reports, Project folders or HCATS. High risk if cannot be determined.

Total:

100%

DSHS Fiscal Monitoring Unit – Internship In Basket

Please write 3 – 4 sentences in response to each of the following questions:

1. Describe a recent group or team effort. How did you help the team meet its goals?

1. What aspect of this internship appeals to you most, and why?