fianancial analyst

profilekekizzy
DataAnalyticsIn-BasketExercise_.xlsx

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

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

Fiscal Risk Matrix

DSHS FMU Fiscal Risks for Recipient and Sub-recipient Awards - FY 2017 / 2018
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 2017 FY 2016 FY 2015 FY 2014 or before
Factor Risk Impact Likelihood Mitigating factors/ controls Risk Level Measure: MSS Risk Category for Measure 1 (Low) 2 3 4 5 (Highest) HHSC Weight DSHS Weight Notes:
1 Weak internal controls over financial operations; Findings impacting programs; If no audit, entity lacks oversight. High Medium Review audit reports; follow up on findings and Corrective Actions Plans; Management decision letters. High Single Audit Results* Internal Controls See Audit Risk Score Matrix See Audit Risk Score Matrix See Audit Risk Score Matrix See Audit Risk Score Matrix See Audit Risk Score Matrix 30% Audit Risk Score is calculated using 7 weighted sub-factors (based on review of single audit report, if available). See 'Audit Risk Score' tab.
2 Repeat non-compliance, errors or fraud. Improper payments; misuse of funds. High High Fiscal Follow up reviews; technical assistance; special reviews; accelerated monitoring High 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
3 Insufficient monitoring may fail to detect problems. Medium Low Fiscal review cycle; follow up reviews; accelerated monitoring Medium Latest Fiscal Review Length of time since last Fiscal Monitoring <12 months 12 - 24 months 25 - 35 months 36+ months No Review History 25% Based on Fiscal Year of Most Recent DSHS or HHSC Review
4 Insufficient funding for program operations; Going concern considerations. High Low Add risk points for high percentage of funding Medium HHS Percentage of total Grant Funding <20% 20-30% >30-50% >50-70% > 70% or cannot be determined 20% Percentage = HHS Awards / Total Awards. May be found in audit reports or financial statements. High risk if cannot be determined.
5 Insufficient funding for the program(s); Loss of Core Funding; Unable to fund program expansion. High Low Contract Manager has knowledge of funding changes Medium Change in funding (from prior year) < 10% 10-30% >30-50% >50-70% > 70% or cannot be determined 0% May be found in audit reports, Project folders or HCATS. High risk if cannot be determined.
Total: 100%