PWS_Attachment_1-YCP-Template_Trend_Analysis_Briefing.pptx
PPTX presentation 6 MB Posted
- Attached to
- YCP INSPECTION Services ONLY Federal contract opportunity
- Solicitation number
- W9133L-17-R-0030
- Issued by
- Department of the Army National Guard
About this file
This Document is being provided to help potential Offerors get an idea of what will be asked for in the forthcoming solicitation. This Document may change in the actual solicitation.
View the file
Other files for this federal contract opportunity
Show all 47
On GovTribe
Work with this file on GovTribe
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
This briefing is
UNCLASSIFIED
ChalleNGe Operational and Resource Effectiveness (CORE) Program
Trend Analysis and Program Update
UNCLASSIFIED / FOUO
| Program | Previous Inspection | Current Inspection | ||
| Date | Rating | Date | Rating |
Inspection Dates
| Program | Previous Inspection | Current Inspection | ||
| Date | Rating | Date | Rating |
Inspection Dates
Inspection Dates
| Program | Previous Inspection | Current Inspection | ||
| Date | Rating | Date | Rating |
Trends Individual Program Results
Outstanding Excellent Satisfactory Marginal Unsatisfactory
Overall Health Scores
Slide depicts the rank order of programs by overall health score – highest on the left to lowest on the right and their associated rating (red, amber, green)
The number in black is the count for each rating. Please note amber is broken out into three areas (excellent, satisfactory and marginal).
New Score PR CA-LA LA-CM WA CA-SL LA-GL GA-FS LA-CB ID WI HI-BP WV OR GA-FG MS *MT *AK NC *MD SC *AR NM *OK TX-W IL MI KY-FK IN VA KY-HN *FL NJ WY HI-HI DC 587.36 586.44000000000005 584.04 579.67999999999995 579.26 577.16999999999996 575.66999999999996 575.54999999999995 568.41 564.70000000000005 563.11 561.61 561.16999999999996 558.91 555.9 554.22 549.54999999999995 548.82000000000005 542.45000000000005 533.85 532.37 531.91999999999996 531.53 522.64 520.48 520.12 517.69000000000005 505.61 503.12 491.54 490.25 468.76 453.15 413.26 402.9
Overall Health Scores Comparison
Slide depicts the number of programs in each rating area (red, amber, green) and the number of programs in each rating area during last year’s TA briefing.
| Oustanding | Excellent | Satisfactory | Marginal | Unsatisfactory | 3 | 7 | 9 | 4 | 9 | 2015 |
| Oustanding | Excellent | Satisfactory | Marginal | Unsatisfactory | 5 | 10 | 8 | 6 | 6 | 2016 |
| Oustanding | Excellent | Satisfactory | Marginal | Unsatisfactory | 8 | 9 | 6 | 6 | 6 |
Operational Compliance
Slide depicts the programs arranged highest to lowest, left to right by overall health rating. This convention is retained throughout the bar graph slides
Programs can and do prepare for the compliance portion of the inspection. The true test is how well they do on operational performance. Op performance shows if their systems and processes are being followed and if they are enduring.
Operational Compliance Comparison
Programs not inspected when the TA briefing was presented in Aug 14 include ID (Green), DC (Amber), NM (Amber).
Programs that went from amber to green are: WA, GA-FS, ID, HI-BP, WV, NC, SC, TX, IL
Oustanding
| 2014 | 2015 | 2016 | 0 | 9 | 18 | Excellent Satisfactory Marginal |
| 2014 | 2015 | 2016 | 31 | 25 | 16 | Unsatisfactory |
| 2014 | 2015 | 2016 | 1 | 1 | 1 |
Resource Mgmt. Compliance
Issues include missing documentation (substantial) mandatory GOR training not completed, joint reviews not being conducted, improper close –outs of CAs
RM Compliance Comparison
Changes from 2014 to 2015 include:
ID entered as amber NM entered as amber DC entered as red HIHI went from amber to green VA went from amber to green IN went from amber to green GAFG went from amber to green HIBP went from amber to green WA went from amber to green SC went from amber to green
Oustanding
| 2014 | 2015 | 2016 | 12 | 19 | 19 | Excellent Satisfactory Marginal |
| 2014 | 2015 | 2016 | 23 | 15 | 16 | Unsatisfactory |
| 2014 | 2015 | 2016 | 0 | 1 | 0 |
Budget Execution
Budget Execution Comparison
Oustanding
| 2014 | 2015 | 2016 | 16 | 19 | 20 | Excellent Satisfactory Marginal |
| 2014 | 2015 | 2016 | 6 | 9 | 8 | Unsatisfactory |
| 2014 | 2015 | 2016 | 10 | 5 | 6 |
Federal Cost per Cadet
Cost per Cadet asc PR CA-LA LA-CM WA CA-SL LA-GL GA-FS LA-CB ID WI HI-BP WV OR GA-FG MS MT AK NC MD SC AR NM OK TX-W IL MI KY-FK IN VA KY-HN FL NJ WY HI-HI DC 142.00511218403861 110.88933244621866 101.6053647632595 102.79605263157895 105.99957600169598 97.257342929391172 98.405825624876982 106.73497705197994 0 106.28122010840684 96.450617283950606 101.64667615368978 108.63661053775122 106.7463706233988 108.26025765941323 94.696969696969703 101.81225819588678 93.040565686639368 94.903672772136275 109.84182776801406 95.301629657867139 96.339113680154142 90.735867888576365 76.109292944668553 100.28078620136382 85.149863760217983 91.082976591675006 80.256821829855539 95.702938080199061 69.237693000069228 109.4331363536879 96.487842531840982 48.8328938372888 60.631783180743341 54.929964295523206
Cost Per Cadet Comparison
Oustanding
| 2014 | 2015 | 2016 | 16 | 18 | 16 | Excellent Satisfactory Marginal |
| 2014 | 2015 | 2016 | 2 | 4 | 4 | Unsatisfactory |
| 2014 | 2015 | 2016 | 13 | 11 | 14 |
Graduation Target
Graduation Target Comparison
Oustanding
| 2014 | 2015 | 2016 | 16 | 15 | 14 | Excellent Satisfactory Marginal |
| 2014 | 2015 | 2016 | 6 | 8 | 10 | Unsatisfactory |
| 2014 | 2015 | 2016 | 10 | 11 | 10 |
Contact Rate at 6 Months
Contact Rate at 6 Months Comparison
Oustanding
| 2014 | 2015 | 2016 | 2 | 3 | 2 | Excellent Satisfactory Marginal |
| 2014 | 2015 | 2016 | 21 | 23 | 26 | Unsatisfactory |
| 2014 | 2015 | 2016 | 9 | 8 | 6 |
Placement Rate at 6 Months
Placement at 6 Months Comparison
Oustanding
| 2014 | 2015 | 2016 | 6 | 7 | 8 | Excellent Satisfactory Marginal |
| 2014 | 2015 | 2016 | 15 | 16 | 12 | Unsatisfactory |
| 2014 | 2015 | 2016 | 11 | 11 | 14 |
Contact Rate at 12 Months
Contact Rate at 12 Months Comparison
Oustanding
| 2014 | 2015 | 2016 | 2 | 2 | 3 | Excellent Satisfactory Marginal |
| 2014 | 2015 | 2016 | 19 | 21 | 20 | Unsatisfactory |
| 2014 | 2015 | 2016 | 11 | 11 | 11 |
Placement Rate at 12 Months
Placement at 12 Months Comparison
Oustanding
| 2014 | 2015 | 2016 | 4 | 5 | 1 | Excellent Satisfactory Marginal |
| 2014 | 2015 | 2016 | 17 | 17 | 20 | Unsatisfactory |
| 2014 | 2015 | 2016 | 11 | 12 | 13 |
Growback Program Fiscal Year 2010 Fiscal Year 2011 Fiscal Year 2012 Fiscal Year 2013 Fiscal Year 2014 Total
VA MD HI-HI DC NC NJ NM GA-FG CA-LA MS CA-SL TX-W MT PR OR KY-FK WY LA-CB HI-BP GA-FS WV FL MI AR IL IN SC WI OK WA AK LA-GL ID LA-CM KY-HN 1159746.95 973039.72999999986 740953.01 574137.26 529628.46 420960.76 258590.05 217858.46 205447.81999999998 202810.51 195913.53 165981.88 161905.26999999999 134382.6 117410.74000000002 104781.98000000001 100602.8 98489.49 70077.469999999987 65727.790000000008 61690.41 58785.979999999996 30574.36 19156 18793.280000000002 18464.300000000003 14793.490000000002 10994.07 10160.24 9104.1999999999989 6656.0700000000006 0.65 0 0 0
VA MD HI-HI DC NC NJ NM GA-FG CA-LA MS CA-SL TX-W MT 1159746.95 973039.72999999986 740953.01 574137.26 529628.46 420960.76 258590.05 217858.46 205447.81999999998 202810.51 195913.53 165981.88 161905.26999999999
Growback Significant reduction in growback since inception of CORE Program Decreased growback figures are attributable to the following reasons:
Comprehensive triannual joint reviews with improved dialog between all financial staff throughout the program year Emphasis by the CORE Team during inspections Improved working environment between Program Budget Officers, Federal Program Managers, GORs, and State Finance staff
Reduction
Fiscal Year 2009 Fiscal Year 2010 Fiscal Year 2011 Fiscal Year 2012 2957955.9999999995 2635914.8600000003 1814233.4500000002 1333671.3499999999 Total Dollars
Training Data
| National Training Required | ||||
| Course | Total Reported | Completed | Not Completed | |
| Employed More than 6 months | Employed Less than 6 months | |||
| Basic Course | ||||
| Cadre Course | ||||
| Counselor Course | ||||
| Educators Course | ||||
| Recruiters Course | ||||
| Post Residential Course |
Training Data
| In-House Training Required | |||
| Course | Total Reported | Completed | Not Completed |
| Confidential Information Training | |||
| Conflict Resolution/Non-Violent Crisis Intervention Training | |||
| Ethics Training | |||
| First Aid, CPR and AED Training | |||
| Gang Awareness Training | |||
| Hands Off Leadership Training | |||
| Mandated Reporter Training | |||
| Sexual Assault/Harrassment Training | |||
| Supervisor Course |
This briefing is
UNCLASSIFIED
ChalleNGe Operational and Resource Effectiveness (CORE) Program
Trend Analysis and Program Update image2.jpeg image3.jpeg image4.jpeg image5.jpeg image6.tiff image7.jpg
Microsoft_Excel_Worksheet1.xlsx Evaluation Results
1 2 3 4 5 9 11 13 10 12 8 7 6 16 15 14
Program Code Visit Date OE Compliance Initial New Score OE Compliance Final RM Compliance Final Graduation Target Graduation target capped Month 6 Placement Month 12 Placement Month 6 Contact Month 12 Contact Cost per Cadet Cost per Cadet asc Cost per Cadet floored Budget Execution OE Compliance Rating OE Compliance Rating_old OE Visit Number RM Compliance Initial RM Compliance Rating RM Compliance Rating_old RM Visit Number OPS Performance Rating OPS Performance OPS Performance Rating_old Graduation Target Rating Month 6 Placement Rating Month 12 Placement Rating Month 6 Contact Rating Month 12 Contact Rating Training RM Performance Rating RM Performance RM Performance Rating_old Cost per Cadet Rating Budget Execution Rating Overall Health Rating_old New Stoplight New Rating Cost per Graduate in $ (2014 Annual Report) 140810 Growback Totals
PR 1/14/16 587.36 587.36 98.54 98.28 150.17 100 84.81 86.77 97.35 97.70 70.42 142.0 100 98.88 Outstanding Amber 2 94.01 Outstanding Green 2 Outstanding 466.59 Green Outstanding Outstanding Excellent Outstanding Outstanding T4 Outstanding 199.4 Green Outstanding Outstanding Amber Green Outstanding 9009.01 $39,742.78
CA-LA 11/20/15 586.44 586.44 98.79 97.81 107.22 100 89.90 82.81 98.56 95.93 90.18 110.9 100 99.30 Excellent Amber 1 93.77 Outstanding Green 2 Green Green Outstanding Outstanding Excellent Outstanding Outstanding T2 Amber Amber Outstanding Satisfactory Amber Green Outstanding 17869.42 $281,313.20
LA-CM 12/4/15 584.04 584.04 97.11 100.00 105.88 100 81.10 84.05 92.64 89.94 98.42 101.6 100 100.00 Excellent Amber 1 97.41 Outstanding Green 2 Amber 180.46 Amber Outstanding Outstanding Excellent Excellent Excellent T4 Green 198.04 Green Outstanding Outstanding Amber Amber Outstanding 16796.88 $104,834.64
WA 4/23/15 579.68 579.68 98.81 100.00 105.92 100 88.59 71.57 77.76 85.88 97.28 102.8 100 99.92 Outstanding Amber 1 91.45 Outstanding Amber 2 Green Green Outstanding Outstanding Satisfactory Satisfactory Excellent T4 Green Green Outstanding Outstanding Amber Green Outstanding 16434.26 $0.00
CA-SL 11/20/15 579.26 579.26 98.20 96.67 108.61 100 90.81 87.27 86.22 75.20 94.34 106.0 99.51 Satisfactory Green 1 Excellent Amber Outstanding Outstanding Excellent Excellent Marginal Outstanding Amber Amber Excellent $0.00
LA-GL 12/4/15 577.17 577.17 97.26 98.08 101.90 100 83.01 82.18 86.82 86.30 102.82 97.3 102.82 100.00 Outstanding Amber 1 95.99 Excellent Green 2 Amber Amber Outstanding Outstanding Excellent Excellent Excellent T4 Green Green Satisfactory Outstanding Amber Amber Excellent 16898.61 $109,340.29
GA-FS 2/20/15 575.67 575.67 96.70 98.88 93.65 93.65 83.68 89.89 84.17 89.52 101.62 98.4 101.62 99.63 Excellent Amber 1 94.71 Outstanding Green 2 Green Green Satisfactory Outstanding Outstanding Excellent Excellent T4 Green Green Outstanding Outstanding Amber Amber Excellent 12962.96 $2,992.64
LA-CB 12/4/15 575.55 575.55 97.04 97.98 103.70 100 78.88 78.78 84.18 82.02 93.69 106.7 100 99.56 Excellent Amber 1 96.24 Outstanding Green 2 Amber Amber Outstanding Excellent Satisfactory Excellent Satisfactory T4 Green Green Outstanding Outstanding Amber Amber Excellent 16079.60 $0.00
ID 8/28/14 568.41 568.41 95.23 90.99 0 ERROR:#DIV/0! 100 Excellent Green 1 97.06 Outstanding Green 2 Satisfactory 168.39 Amber T4 Red Red Outstanding Red Amber Marginal 14440.43 $111,583.71
WI 10/16/15 564.70 564.70 97.26 96.21 111.25 100 51.73 52.19 88.45 92.85 94.09 106.3 100 99.92 Outstanding Amber 1 98.32 Outstanding Green 2 Green Green Outstanding Unsatisfactory Unsatisfactory Excellent Excellent T4 Green Green Outstanding Outstanding Amber Amber Excellent 18604.65 $139.30
HI-BP 5/8/15 563.11 563.11 97.62 97.95 93.50 93.5 60.05 66.67 94.18 92.33 103.68 96.5 103.68 99.28 Outstanding Amber 1 87.91 Outstanding Amber 2 Green 170.65 Green Satisfactory Marginal Marginal Excellent Excellent T4 Amber 198.85 Amber Marginal Satisfactory Amber Amber Satisfactory 16538.00 $469,842.62
WV 2/5/15 561.61 561.61 98.29 95.64 121.00 100 49.05 69.52 62.38 92.62 98.38 101.6 100 99.29 Excellent Amber 1 93.55 Outstanding Green 2 Green Green Outstanding Unsatisfactory Marginal Marginal Excellent T4 Green Green Outstanding Outstanding Green Green Excellent 17801.00 $284,626.79
OR 2/11/16 561.17 561.17 96.41 93.92 108.54 100 64.02 70.99 71.18 80.46 92.05 108.6 100 99.18 Excellent Amber 2 95.69 Outstanding Green 2 Amber Amber Outstanding Satisfactory Satisfactory Satisfactory Satisfactory T3 Red Red Outstanding Outstanding Red Amber Excellent 21333.33 $41,590.31
GA-FG 2/20/15 558.91 558.91 93.24 96.21 91.88 91.88 69.40 71.29 88.73 85.65 93.68 106.7 100 98.85 Excellent Amber 2 84.02 Outstanding Green 2 Amber Amber Marginal Satisfactory Satisfactory Excellent Excellent T4 Green Green Outstanding Outstanding Amber Amber Satisfactory 14643.55 $70,449.25
MS 9/11/15 555.90 555.90 93.77 91.01 95.50 95.5 79.68 73.02 83.47 71.18 92.37 108.3 100 98.78 Excellent Amber 1 91.64 Outstanding Amber 2 Red Red Excellent Excellent Satisfactory Excellent Marginal T4 Green Green Outstanding Outstanding Red Amber Satisfactory 13489.96 $12,211.58
*MT 3/17/16 554.22 554.22 96.98 100.00 83.29 83.29 69.27 69.54 92.18 90.03 105.60 94.7 105.6 99.00 Marginal Amber 1 89.45 Outstanding Amber 2 Green Green Unsatisfactory Satisfactory Satisfactory Excellent Excellent T2 Green Green Unsatisfactory Outstanding Amber Amber Satisfactory 19404.26 $38,185.95
*AK 6/23/16 549.55 549.55 92.01 90.48 93.75 93.75 80.53 76.49 69.47 66.84 98.22 101.8 100 99.98 Excellent Green 2 89.8 Excellent Green 2 Satisfactory 168.92 Amber Satisfactory Excellent Excellent Satisfactory Satisfactory T4 Unsatisfactory 188.05 Red Outstanding Unsatisfactory Red Red Satisfactory 13737.37 $682,560.46
NC 12/4/14 548.82 548.82 96.49 95.36 96.20 96.2 67.33 61.78 83.56 78.22 107.48 93.0 107.48 95.01 Satisfactory Amber 2 77.28 Excellent Amber 2 Satisfactory 404.29 Amber Excellent Satisfactory Marginal Excellent Satisfactory T4 Marginal 194.24 Amber Unsatisfactory Marginal Amber Amber Satisfactory 16000.00 $250,033.38
*MD 5/26/16 542.45 542.45 91.77 93.81 93.75 93.75 51.34 63.08 87.78 96.82 105.37 94.9 105.37 93.46 Outstanding Amber 2 76.24 Outstanding Amber 2 Red Red Satisfactory Marginal Satisfactory Excellent Outstanding T4 Red Red Unsatisfactory Marginal Red Amber Satisfactory 29100.67 $259,015.57
SC 11/20/14 533.85 533.85 96.53 97.26 86.93 86.93 44.82 44.15 64.88 59.87 91.04 109.8 100 99.74 Marginal Amber 2 90.9 Excellent Amber 2 Red Red Unsatisfactory Unsatisfactory Unsatisfactory Marginal Unsatisfactory T4 Red Red Outstanding Outstanding Red Amber Satisfactory 19977.01 $0.00
*AR 4/28/16 532.37 532.37 81.74 86.29 94.00 94 64.55 68.59 84.15 81.27 104.93 95.3 104.93 99.91 Satisfactory Amber 2 83.49 Excellent Amber 2 Red Red Satisfactory Satisfactory Satisfactory Excellent Excellent T4 Red Red Unsatisfactory Outstanding Red Amber Satisfactory 19684.21 $212,076.00
NM 5/21/15 531.92 531.92 93.67 88.24 82.54 82.54 74.71 72.94 83.53 80.59 103.80 96.3 103.8 93.19 Outstanding Green 3 81.99 Outstanding Green 2 Unsatisfactory 140.36 Red Unsatisfactory Excellent Satisfactory Excellent Satisfactory T4 Outstanding 199.74 Green Marginal Outstanding Red Amber Satisfactory 22764.23 $15,981.43
*OK 6/9/16 531.53 531.53 92.08 84.87 99.09 99.09 70.42 74.87 60.99 53.14 110.21 90.7 110.21 99.90 Excellent Amber 2 Satisfactory Amber Satisfactory 377.61 Amber Outstanding Satisfactory Excellent Marginal Marginal T4 Unsatisfactory 188.97 Red Unsatisfactory Unsatisfactory Red Amber Satisfactory 23188.41 $360,341.19
TX-W 10/9/14 522.64 522.64 95.96 90.17 98.25 98.25 54.22 44.88 79.22 78.31 131.39 76.1 131.39 97.99 Satisfactory Amber 2 83.46 Satisfactory Amber 2 Red Red Outstanding Unsatisfactory Unsatisfactory Satisfactory Satisfactory T4 Green Green Unsatisfactory Outstanding Red Amber Satisfactory 19672.13 $14,384.06
IL 10/23/14 520.48 520.48 95.05 94.72 91.90 91.9 37.15 28.62 50.36 39.37 99.72 100.3 100 99.93 Excellent Amber 1 87.97 Outstanding Amber 2 Red Red Marginal Unsatisfactory Unsatisfactory Unsatisfactory Unsatisfactory T4 Red Red Outstanding Satisfactory Red Amber Marginal 15189.87 $411,077.87
MI 1/28/16 520.12 520.12 89.47 86.51 100.00 100 61.97 59.66 65.13 49.79 117.44 85.1 117.44 99.85 Outstanding Amber 1 90.77 Excellent Green 2 Red Red Outstanding Marginal Unsatisfactory Marginal Unsatisfactory T4 Green Green Unsatisfactory Outstanding Red Amber Marginal 16401.77 $6,102.44
KY-FK 8/13/15 517.69 517.69 89.14 93.75 98.50 98.5 44.90 37.50 57.40 45.41 109.79 91.1 109.79 98.91 Outstanding Green 3 84.3 Excellent Amber 2 Marginal 162.41 Red Outstanding Unsatisfactory Unsatisfactory Marginal Unsatisfactory T4 Unsatisfactory 174.1 Red Unsatisfactory Satisfactory Red Amber Marginal 16080.40 $182,596.54
IN 4/9/15 505.61 505.61 92.21 99.14 77.25 77.25 51.12 42.98 66.29 78.37 124.60 80.3 124.6 97.06 Excellent Green 2 93.79 Outstanding Amber 2 Unsatisfactory 130.78 Red Unsatisfactory Unsatisfactory Unsatisfactory Marginal Satisfactory T4 Outstanding 199.93 Green Unsatisfactory Outstanding Red Amber Marginal 15884.48 $29,974.30
VA 11/6/14 503.12 503.12 89.57 98.74 85.56 85.56 59.25 56.34 26.82 22.25 104.49 95.7 104.49 92.38 Satisfactory Amber 2 84.04 Outstanding Green 2 Unsatisfactory 126.72 Red Unsatisfactory Marginal Unsatisfactory Unsatisfactory Unsatisfactory T4 Unsatisfactory 188.09 Red Unsatisfactory Unsatisfactory Red Red Marginal $1,527,961.02
KY-HN 8/13/15 491.54 491.54 89.75 97.22 87.75 87.75 49.13 43.60 57.79 39.79 144.43 69.2 144.43 100.00 Marginal Amber Excellent Amber Unsatisfactory 259.5 Red Unsatisfactory Unsatisfactory Unsatisfactory Marginal Unsatisfactory Unsatisfactory 187.19 Red Unsatisfactory Unsatisfactory Unsatisfactory Red Unsatisfactory 14723.54 $959,472.08
*FL 3/31/16 490.25 490.25 94.37 94.95 111.67 100 0.30 0.30 2.27 2.27 91.38 109.4 100 99.64 Excellent Amber Marginal Amber Unsatisfactory 278.54 Red Outstanding Unsatisfactory Unsatisfactory Unsatisfactory Unsatisfactory Unsatisfactory 147.18 Red Outstanding Excellent Unsatisfactory Red Unsatisfactory 14285.71 $117,377.58
NJ 3/12/15 468.76 468.76 84.63 94.92 86.00 86 8.54 9.37 8.82 9.37 103.64 96.5 103.64 97.70 Excellent Red 2 86.16 Excellent Amber 2 Red Red Unsatisfactory Unsatisfactory Unsatisfactory Unsatisfactory Unsatisfactory T4 Red Red Marginal Excellent Red Red Unsatisfactory 16240.13 $102,460.46
WY 8/14/14 453.15 453.15 91.12 94.92 77.59 77.59 51.92 52.88 43.27 52.88 204.78 48.8 204.78 98.35 Unsatisfactory Amber 2 87.43 Satisfactory Amber 2 Unsatisfactory 136.31 Red Unsatisfactory Unsatisfactory Unsatisfactory Unsatisfactory Unsatisfactory T4 Unsatisfactory 192.3 Red Unsatisfactory Unsatisfactory Red Red Unsatisfactory 18652.85 $911,843.78
HI-HI 5/5/15 413.26 413.26 89.61 97.92 41.75 41.75 31.41 23.04 44.50 32.46 164.93 60.6 90.50 Satisfactory Amber 2 78.84 Outstanding Amber 2 Unsatisfactory 120.59 Red Unsatisfactory Unsatisfactory Unsatisfactory Unsatisfactory Unsatisfactory T4 0 0 Unsatisfactory 0 Red Red Unsatisfactory 47058.82 $0.00
DC 9/24/15 402.90 402.90 77.63 88.14 45.00 45.00 24.44 43.70 59.26 53.33 182.05 54.9 92.02 Marginal Amber 2 Unsatisfactory Red Unsatisfactory 240.59 Red Unsatisfactory Unsatisfactory Unsatisfactory Marginal Unsatisfactory T4 Unsatisfactory Red Unsatisfactory Unsatisfactory Red Red Unsatisfactory 36000.00 $0.00
534.66 93.54 94.77 94.99 88.39 60.35 60.04 70.11 68.47 109.66 98.14
Correlations
New Score OE Compliance Final RM Compliance Final Graduation Target Graduation target capped Month 6 Placement Month 12 Placement Month 6 Contact Month 12 Contact Cost per Cadet Cost per Cadet asc Cost per Cadet floored Budget Execution
New Score 1
OE Compliance Final 0.3786890361 1
RM Compliance Final 0.4836105558 0.3405579198 1
Graduation Target 0.5896091404 0.3859149155 0.433420864 1
Graduation target capped 0.5407081671 0.4098030999 0.3912259827 0.8469138166 1
Month 6 Placement 0.9208489081 0.2405122286 0.4893600568 0.4318430732 0.3459053226 1
Month 12 Placement 0.9308971704 0.2543796898 0.46898559 0.43565324 0.3718254555 0.9379886786 1
Month 6 Contact 0.7820690505 0.2313652576 0.245892434 0.2758550471 0.1734783806 0.7313916235 0.7224806907 1
Month 12 Contact 0.8037621873 0.2489073807 0.2599935277 0.3139730492 0.2581601205 0.7291222605 0.8146581953 0.9276167506 1
Cost per Cadet -0.3695377192 -0.2333752469 -0.1029651081 -0.6900037359 -0.8198270818 -0.1325019728 -0.0764444323 -0.1022909651 -0.0464791843 1
Cost per Cadet asc 0.4210278498 0.2785088431 0.2047583724 0.7564264054 0.8308819991 0.2121626574 0.1370015962 0.1212172684 0.0542784755 -0.961630731 1
Cost per Cadet floored -0.3086831371 -0.2033215951 -0.0221349322 -0.6274603143 -0.7979770495 -0.0639242102 -0.0165923873 -0.0642648048 -0.018304917 0.9858894866 -0.9099583929 1
Budget Execution 0.4998603932 0.0288139698 0.6404802247 0.2190982096 0.1546685772 0.58743237 0.4844721353 0.3019239064 0.2442225112 -0.0025221604 0.0416487058 0.0411431046 1
Desc Stats
New Score OE Compliance Final RM Compliance Final Graduation Target Graduation target capped Month 6 Placement Month 12 Placement Month 6 Contact Month 12 Contact Cost per Cadet Cost per Cadet asc Cost per Cadet floored Budget Execution
Mean 735.38 89.90 92.24 97.12 92.38 62.95 63.70 69.39 70.55 109.11 95.16 112.32 98.38
Standard Error 16.99 0.76 0.81 3.15 2.12 3.89 3.96 4.27 4.29 4.57 2.90 4.19 0.42
Median 765.19 91.16 93.10 98.00 98.00 67.00 66.50 79.30 81.26 99.70 100.30 100.00 99.40
Mode 781.07 90.43 96.24 105.00 100.00 86.00 75.00 91.00 84.00 91.80 108.93 100.00 100.00
Standard Deviation 96.10 4.31 4.60 17.84 12.00 22.02 22.40 24.16 24.26 25.45 16.17 23.34 2.33
Sample Variance 9234.56 18.59 21.19 318.27 144.12 485.03 501.81 583.90 588.53 647.56 261.36 544.64 5.41
Kurtosis 0.49 6.44 -0.01 3.80 5.85 0.13 0.31 -0.25 0.24 6.76 1.42 8.81 6.80
Skewness -1.02 -2.21 -0.75 0.13 -2.28 -0.90 -0.91 -0.85 -1.08 2.40 -1.13 2.85 -2.36
Range 365.45 20.76 17.27 106.24 52.25 78.86 84.31 85.27 84.79 122.48 72.67 104.78 10.62
Minimum 489.54 73.21 81.74 47.75 47.75 11.14 7.69 11.14 11.14 82.30 48.83 100.00 89.38
Maximum 854.99 93.97 99.01 153.99 100.00 90.00 92.00 96.41 95.93 204.78 121.51 204.78 100.00
Sum 23532.21 2876.84 2951.69 3107.73 2956.14 2014.53 2038.29 2220.43 2257.75 3382.38 2949.97 3481.88 3049.91
Count 32.00 32.00 32.00 32.00 32.00 32.00 32.00 32.00 32.00 31.00 31.00 31.00 31.00
Minimum Maximum Range Mean Median Standard Deviation Correlation
New Score 489.54 854.99 365.45 735.38 765.19 96.10 1.00
OE Compliance Final 73.21 93.97 20.76 89.90 91.16 4.31 0.38
RM Compliance Final 81.74 99.01 17.27 92.24 93.10 4.60 0.48
Graduation target capped 47.75 100.00 52.25 92.38 98.00 12.00 0.54
Month 6 Placement 11.14 90.00 78.86 62.95 67.00 22.02 0.92
Month 12 Placement 7.69 92.00 84.31 63.70 66.50 22.40 0.93
Month 6 Contact 11.14 96.41 85.27 69.39 79.30 24.16 0.78
Month 12 Contact 11.14 95.93 84.79 70.55 81.26 24.26 0.80
Cost per Cadet floored 100.00 204.78 104.78 112.32 100.00 23.34 -0.31
Budget Execution 89.38 100.00 10.62 98.38 99.40 2.33 0.50
Unsatisfactory Ranges
OE Compliance Final 7 Graduation Target 12 Month 6 Placement 17 Month 12 Placement 27 Month 6 Contact 21 Month 12 Contact 25 Cost per Cadet 19 Budget Execution 2
73.21 6.79 47.75 42.25 11.14 43.86 7.69 53.31 11.14 44.86 11.14 54.86 104.19 0.19 93.8 3.2
63 27 11.76 43.24 11.14 49.86 17.5 38.5 17.5 48.5 106.1 2.1 94.9 2.1
79 11 33 22 30 31 33.03 22.97 20.36 45.64 107.8 3.8 96.32 0.68
83 7 38 17 36 25 38 18 40.3 25.7 112.6 8.6 96.7 0.3
83 7 46.7 8.3 37.6 23.4 46 10 42 24 115.1 11.1
87.6 2.4 47.7 7.3 46.7 14.3 49 7 46 20 118.4 14.4
87.7 2.3 48 7 47 14 51.1 4.9 53 13 122.6 18.6
89 1 51 4 52 9 54 12 123.5 19.5
54 1 64.6 1.4 124.1 20.1
65 1 124.6 20.6
138.7 34.7
173.9 69.9
Ranges and Colors
Overall Health Compliance Grad Target Contact6 Contact12 Placement6 Placement12 CostperCadet BudgetExecution
681 80 90 56 66 55 61 96.1538461538 97
737 85 93 69 76 64 70 96.8054211036 97.7
790 90 95 83 85 72 79 97.3709834469 98.3
845 95 98 96 95 81 88 98.0392156863 99
10000 10000 10000 10000 10000 10000 10000 10000 10000
Overall Health
New Score PR CA-LA LA-CM WA CA-SL LA-GL GA-FS LA-CB ID WI HI-BP WV OR GA-FG MS *MT *AK NC *MD SC *AR NM *OK TX-W IL MI KY-FK IN VA KY-HN *FL NJ WY HI-HI DC 587.36 586.44000000000005 584.04 579.67999999999995 579.26 577.16999999999996 575.66999999999996 575.54999999999995 568.41 564.70000000000005 563.11 561.61 561.16999999999996 558.91 555.9 554.22 549.54999999999995 548.82000000000005 542.45000000000005 533.85 532.37 531.91999999999996 531.53 522.64 520.48 520.12 517.69000000000005 505.61 503.12 491.54 490.25 468.76 453.15 413.26 402.9
OPS Compliance
Operational Compliance
OE Compliance Final PR CA-LA LA-CM WA CA-SL LA-GL GA-FS LA-CB ID WI HI-BP WV OR GA-FG MS *MT *AK NC *MD SC *AR NM *OK TX-W IL MI KY-FK IN VA KY-HN *FL NJ WY HI-HI DC 98.54 98.79 97.11 98.81 98.2 97.26 96.7 97.04 95.23 97.26 97.62 98.29 96.41 93.24 93.77 96.98 92.01 96.49 91.77 96.53 81.739999999999995 93.67 92.08 95.96 95.05 89.47 89.14 92.21 89.57 89.75 94.37 84.63 91.12 89.61 77.63
RM Compliance
Resource Management Compliance
RM Compliance Final PR CA-LA LA-CM WA CA-SL LA-GL GA-FS LA-CB ID WI HI-BP WV OR GA-FG MS *MT *AK NC *MD SC *AR NM *OK TX-W IL MI KY-FK IN VA KY-HN *FL NJ WY HI-HI DC 98.28 97.81 100 100 96.67 98.08 98.88 97.98 90.99 96.21 97.95 95.64 93.92 96.21 91.01 100 90.48 95.36 93.81 97.26 86.29 88.24 84.87 90.17 94.72 86.51 93.75 99.14 98.74 97.22 94.95 94.92 94.92 97.92 88.14
Graduation Target PR CA-LA LA-CM WA CA-SL LA-GL GA-FS LA-CB ID WI HI-BP WV OR GA-FG MS *MT *AK NC *MD SC *AR NM *OK TX-W IL MI KY-FK IN VA KY-HN *FL NJ WY HI-HI DC 150.16999999999999 107.22 105.88 105.92 108.61 101.9 93.65 103.7 111.25 93.5 121 108.54 91.88 95.5 83.29 93.75 96.2 93.75 86.93 94 82.54 99.09 98.25 91.9 100 98.5 77.25 85.56 87.75 111.67 86 77.59 41.75 45
Placement 6
Month 6 Placement PR CA-LA LA-CM WA CA-SL LA-GL GA-FS LA-CB ID WI HI-BP WV OR GA-FG MS *MT *AK NC *MD SC *AR NM *OK TX-W IL MI KY-FK IN VA KY-HN *FL NJ WY HI-HI DC 84.81 89.9 81.099999999999994 88.59 90.81 83.01 83.68 78.88 51.73 60.05 49.05 64.02 69.400000000000006 79.680000000000007 69.27 80.53 67.33 51.34 44.82 64.55 74.709999999999994 70.42 54.22 37.15 61.97 44.9 51.12 59.25 49.13 0.3 8.5399999999999991 51.92 31.41 24.44
Placement 12
Month 12 Placement PR CA-LA LA-CM WA CA-SL LA-GL GA-FS LA-CB ID WI HI-BP WV OR GA-FG MS *MT *AK NC *MD SC *AR NM *OK TX-W IL MI KY-FK IN VA KY-HN *FL NJ WY HI-HI DC 86.77 82.81 84.05 71.569999999999993 87.27 82.18 89.89 78.78 52.19 66.67 69.52 70.989999999999995 71.290000000000006 73.02 69.540000000000006 76.489999999999995 61.78 63.08 44.15 68.59 72.94 74.87 44.88 28.62 59.66 37.5 42.98 56.34 43.6 0.3 9.3699999999999992 52.88 23.04 43.7
Contact 6
Month 6 Contact PR CA-LA LA-CM WA CA-SL LA-GL GA-FS LA-CB ID WI HI-BP WV OR GA-FG MS *MT *AK NC *MD SC *AR NM *OK TX-W IL MI KY-FK IN VA KY-HN *FL NJ WY HI-HI DC 97.35 98.56 92.64 77.760000000000005 86.22 86.82 84.17 84.18 88.45 94.18 62.38 71.180000000000007 88.73 83.47 92.18 69.47 83.56 87.78 64.88 84.15 83.53 60.99 79.22 50.36 65.13 57.4 66.290000000000006 26.82 57.79 2.27 8.82 43.27 44.5 59.26
Contact 12
Month 12 Contact PR CA-LA LA-CM WA CA-SL LA-GL GA-FS LA-CB ID WI HI-BP WV OR GA-FG MS *MT *AK NC *MD SC *AR NM *OK TX-W IL MI KY-FK IN VA KY-HN *FL NJ WY HI-HI DC 97.7 95.93 89.94 85.88 75.2 86.3 89.52 82.02 92.85 92.33 92.62 80.459999999999994 85.65 71.180000000000007 90.03 66.84 78.22 96.82 59.87 81.27 80.59 53.14 78.31 39.369999999999997 49.79 45.41 78.37 22.25 39.79 2.27 9.3699999999999992 52.88 32.46 53.33
Cost per Cadet
Cost per Cadet (ascending)
Cost per Cadet asc PR CA-LA LA-CM WA CA-SL LA-GL GA-FS LA-CB ID WI HI-BP WV OR GA-FG MS *MT *AK NC *MD SC *AR NM *OK TX-W IL MI KY-FK IN VA KY-HN *FL NJ WY HI-HI DC 142.00511218403861 110.88933244621866 101.6053647632595 102.79605263157895 105.99957600169598 97.257342929391172 98.405825624876982 106.73497705197994 0 106.28122010840684 96.450617283950606 101.64667615368978 108.63661053775122 106.7463706233988 108.26025765941323 94.696969696969703 101.81225819588678 93.040565686639368 94.903672772136275 109.84182776801406 95.301629657867139 96.339113680154142 90.735867888576365 76.109292944668553 100.28078620136382 85.149863760217983 91.082976591675006 80.256821829855539 95.702938080199061 69.237693000069228 109.4331363536879 96.487842531840982 48.8328938372888 60.631783180743341 54.929964295523206
Budget Execution PR CA-LA LA-CM WA CA-SL LA-GL GA-FS LA-CB ID WI HI-BP WV OR GA-FG MS *MT *AK NC *MD SC *AR NM *OK TX-W IL MI KY-FK IN VA KY-HN *FL NJ WY HI-HI DC 98.88 99.3 100 99.92 99.51 100 99.63 99.56 99.92 99.28 99.29 99.18 98.85 98.78 99 99.98 95.01 93.46 99.74 99.91 93.19 99.9 97.99 99.93 99.85 98.91 97.06 92.38 100 99.64 97.7 98.35 90.5 92.02
Cost per Cadet $
Cost per Graduate in $
Cost per Graduate in $ (2014 Annual Report) PR CA-LA LA-CM WA CA-SL LA-GL GA-FS LA-CB ID WI HI-BP WV OR GA-FG MS *MT *AK NC *MD SC *AR NM *OK TX-W IL MI KY-FK IN VA KY-HN *FL NJ WY HI-HI DC 9009.0090090090089 17869.415807560137 16796.875 16434.262948207172 16898.608349900598 12962.962962962964 16079.60199004975 14440.43321299639 18604.651162790698 16538 17801 21333.333333333336 14643.54527938343 13489.959839357431 19404.255319148935 13737.373737373737 16000 29100.671140939598 19977.011494252874 19684.21052631579 22764.227642276423 23188.405797101448 19672.131147540982 15189.873417721519 16401.766004415011 16080.402010050251 15884.476534296029 14723.538704581359 14285.714285714286 16240.126382306476 18652.849740932641 47058.823529411762 36000
Thousands
Growback Sorted
Total Growback ordered by Overall Health Score
140810 Growback Totals 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 39742.78 281313.2 104834.64 0 0 109340.29 2992.64 0 111583.71 139.30000000000001 469842.62 284626.78999999998 41590.31 70449.25 12211.58 38185.949999999997 682560.46 250033.38 259015.57 0 212076 15981.43 360341.19 14384.06 411077.87 6102.44 182596.54 29974.3 1527961.02 959472.08 117377.58 102460.46 911843.78 0 0
Attrition vs Graduation Target
Program Code Graduation Target Attrition Rate
PR 153.99
CA-SL 105
LA-GL 102
ID
LA-CB 109
MS 104.9
LA-CM 104
GA-FS 99
WV 121
OR 108.3
CA-LA 112
MT 90
AR 116
WI 105
FL 107
NC 96.2
GA-FG 108.4
HI-BP 94.75
IN 89
KY-HN 63
OK 83
SC 86.93
NM 85.20
WA 108
MI 79
AK 108
TX 98.25
IL 91.9
VA 85.56
MD 97
WY 77.59
KY-FK 93
NJ 91.75
HI-KU 47.75
DC 56.15
2015 Pie Chart
Operational Compliance Resource Management Compliance Budget Execution
Oustanding 9 Oustanding 19 Oustanding 19
Excellent Satisfactory Marginal 25 Excellent Satisfactory Marginal 15 Excellent Satisfactory Marginal 9
Unsatisfactory 1 Unsatisfactory 1 Unsatisfactory 5
Cost Per Cadet (ascending) Graduation Target Contact Rate Month 6
Oustanding 18 Oustanding 15 Oustanding 3
Excellent Satisfactory Marginal 4 Excellent Satisfactory Marginal 8 Excellent Satisfactory Marginal 23
Unsatisfactory 11 Unsatisfactory 11 Unsatisfactory 8
Placement Rate Month 6 Contact Rate Month 12 Placement Rate Month 12
Oustanding 7 Oustanding 2 Oustanding 5
Excellent Satisfactory Marginal 16 Excellent Satisfactory Marginal 21 Excellent Satisfactory Marginal 17
Unsatisfactory 11 Unsatisfactory 11 Unsatisfactory 12
9 25 1 19 15 1 19 9 5 18 4 11 15 8 11 3 23 8 7 16 11 2 21 11 5 17 12
2014 Pie Chart
Operational Compliance Resource Management Compliance Budget Execution
Oustanding 0 Oustanding 12 Oustanding 16
Excellent Satisfactory Marginal 34 Excellent Satisfactory Marginal 23 Excellent Satisfactory Marginal 6
Unsatisfactory 1 Unsatisfactory 0 Unsatisfactory 10
Cost Per Cadet (ascending) Graduation Target Contact Rate Month 6
Oustanding 16 Oustanding 16 Oustanding 2
Excellent Satisfactory Marginal 2 Excellent Satisfactory Marginal 6 Excellent Satisfactory Marginal 21
Unsatisfactory 13 Unsatisfactory 10 Unsatisfactory 9
Placement Rate Month 6 Contact Rate Month 12 Placement Rate Month 12
Oustanding 6 Oustanding 2 Oustanding 4
Excellent Satisfactory Marginal 15 Excellent Satisfactory Marginal 19 Excellent Satisfactory Marginal 17
Unsatisfactory 11 Unsatisfactory 11 Unsatisfactory 11
0 34 1 12 23 0 16 6 10 16 2 13 16 6 10 2 21 9 6 15 11 2 19 11 4 17 11
Sheet1
Sheet2 image1.jpeg
Microsoft_Excel_Worksheet2.xlsx Stoplight Scores Curr Stnds
Previous Rating Scheme Assessment Rating Scheme
Program Code Visit Date OPS Compliance RM Compliance OPS Performance Finan. Performance Overall Stoplight Equivalent Overall Health Rating Overall Health Score Old New OPS Compliance RM Compliance OPS Performance Finan. Performance Overall Health
PR 5/22/14 2 3 3 3 2 3 Outstanding 854.4 1.7 Amber Green Green Green Amber
CA-SL 2/7/13 2 3 2 2 2 3 Outstanding 853.7 1.6 Amber Green Amber Amber Amber
LA-GL 3/6/13 2 2 3 3 2 3 Outstanding 847.0 0.4 Amber Amber Green Green Amber
ID 8/28/14 3 2 N/A N/A 2 2 Excellent 841.3 9.3 Green Amber Amber
LA-CB 3/14/13 2 3 2 3 2 2 Excellent 829.4 7.2 Amber Green Amber Green Amber
MS 2/22/13 2 3 2 3 2 2 Excellent 822.6 5.9 Amber Green Amber Green Amber
LA-CM 4/11/13 2 3 2 3 2 2 Excellent 820.7 5.6 Amber Green Amber Green Amber
GA-FS 3/7/13 2 3 2 3 2 2 Excellent 818.1 5.1 Amber Green Amber Green Amber
OR 11/1/12 2 3 2 3 2 2 Excellent 812.0 4.0 Amber Green Amber Green Amber
CA-LA 2/7/13 2 3 2 2 2 2 Excellent 808.6 3.4 Amber Green Amber Amber Amber
MT 4/24/14 2 3 2 1 1 2 Excellent 798.0 1.5 Amber Green Amber Red Red
AR 10/24/13 2 3 2 3 2 2 Satisfactory 785.8 9.2 Amber Green Amber Green Amber
NC 12/4/14 3 3 2 1 1 1 Satisfactory 548.8 9.0 Green Green Amber Red Red
FL 4/18/13 2 2 2 3 2 2 Satisfactory 781.1 8.3 Amber Amber Amber Green Amber
WI 10/11/12 2 2 2 3 2 2 Satisfactory 781.1 8.3 Amber Amber Amber Green Amber
GA-FG 11/29/12 2 2 2 2 2 2 Satisfactory 774.2 7.0 Amber Amber Amber Amber Amber
HI-BP 6/5/14 2 2 2 2 2 2 Satisfactory 773.6 6.9 Amber Amber Amber Amber Amber
IN 3/20/14 2 2 1 1 1 2 Satisfactory 768.3 5.9 Amber Amber Red Red Red
KY-HN 3/6/14 2 2 1 1 1 2 Satisfactory 762.1 4.7 Amber Amber Red Red Red
OK 12/5/13 2 2 1 1 1 2 Satisfactory 758.8 4.1 Amber Amber Red Red Red
SC 11/20/14 3 3 1 3 1 2 Satisfactory 533.9 2.6 Green Green Red Green Red
NM 9/18/14 2 2 2 1 1 2 Satisfactory 745.1 1.5 Amber Amber Amber Red Red
WA 4/3/14 2 2 1 3 1 2 Satisfactory 737.9 0.2 Amber Amber Red Green Red
MI 4/25/13 2 2 1 1 1 2 Marginal 734.3 9.5 Amber Amber Red Red Red
TX 10/9/14 3 2 2 1 1 2 Marginal 522.6 7.8 Green Amber Amber Red Red
AK 5/23/13 2 3 1 3 1 2 Marginal 722.1 7.3 Amber Green Red Green Red
IL 10/23/14 3 2 1 3 1 2 Marginal 520.5 7.0 Green Amber Red Green Red
WV 5/31/13 2 3 1 1 1 2 Marginal 719.2 6.8 Amber Green Red Red Red
VA 11/6/14 2 3 1 1 1 1 Marginal 503.1 0.0 Amber Green Red Red Red
MD 7/31/14 2 2 1 1 1 1 Unsatisfactory 620.7 9.1 Excellent Marginal Unsatisfactory Unsatisfactory Unsatisfactory
WY 8/14/14 2 2 1 1 1 1 Unsatisfactory 611.8 9.0 Excellent Excellent Unsatisfactory Unsatisfactory Unsatisfactory
KY-FK 3/6/14 1 2 1 1 1 1 Unsatisfactory 595.2 8.7 Red Amber Red Red Red
NJ 5/30/14 2 2 1 1 1 1 Unsatisfactory 506.5 7.4 Amber Amber Red Red Red
HI-KU 6/5/14 2 2 1 N/A 1 1 Unsatisfactory 489.5 7.2 Amber Amber Red N/A Red
DC 9/11/14 2 1 1 1 1 1 Unsatisfactory 390.4 5.7 Amber Red Red Red Red
Note: All stoplight ratings above shown under current performance standards.
Oustanding 3 2015 2014
Excellent 7 Oustanding 5 3 14%
Satisfactory 9 Excellent 10 7 29%
Marginal 4 Satisfactory 8 9 23%
Unsatisfactory 9 Marginal 6 4 17%
Unsatisfactory 6 9 17%
35 100.00%
4 3
25 26
6 6
&"Corbel,Bold"&14&K03-021Youth Challege Program Overall Health
Oustanding Excellent Satisfactory Marginal Unsatisfactory 5 10 8 6 6 Oustanding Excellent Satisfactory Marginal Unsatisfactory 0.14285714285714285 0.2857142857142857 0.22857142857142856 0.17142857142857143 0.17142857142857143 4 25 6 3 26 6 0 3 26 6 0 Oustanding Excellent Satisfactory Marginal Unsatisfactory 3 7 9 4 9
Ranking
Lower bounds of each range
Outstanding Excellent Satisfactory Marginal Unsatisfactory
New Scoring Overall Health (sum component scores) 548.82 Satisfactory 9 575 551 528 503
Old Scoring Overall Health (sum component scores) 781.10 Satisfactory 8 845 790 737 681
2014 2015 2016
Oustanding 3 5 8
Excellent 7 10 9
Satisfactory 9 8 6
Marginal 4 6 6
Unsatisfactory 9 6 6
2014 Oustanding Excellent Satisfactory Marginal Unsatisfactory 3 7 9 4 9 2015 Oustanding Excellent Satisfactory Marginal Unsatisfactory 5 10 8 6 6 2016 Oustanding Excellent Satisfactory Marginal Unsatisfactory 8 9 6 6 6 image8.png
Microsoft_Excel_Worksheet3.xlsx Evaluation Results
1 2 3 4 5 9 11 13 10 12 8 7 6 16 15 14
Program Code Visit Date OE Compliance Initial New Score OE Compliance Final RM Compliance Final Graduation Target Graduation target capped Month 6 Placement Month 12 Placement Month 6 Contact Month 12 Contact Cost per Cadet Cost per Cadet asc Cost per Cadet floored Budget Execution OE Compliance Rating OE Compliance Rating_old OE Visit Number RM Compliance Initial RM Compliance Rating RM Compliance Rating_old RM Visit Number OPS Performance Rating OPS Performance OPS Performance Rating_old Graduation Target Rating Month 6 Placement Rating Month 12 Placement Rating Month 6 Contact Rating Month 12 Contact Rating Training RM Performance Rating RM Performance RM Performance Rating_old Cost per Cadet Rating Budget Execution Rating Overall Health Rating_old New Stoplight New Rating Cost per Graduate in $ (2014 Annual Report) 140810 Growback Totals
PR 1/14/16 587.36 587.36 98.54 98.28 150.17 100 84.81 86.77 97.35 97.70 70.42 142.0 100 98.88 Outstanding Amber 2 94.01 Outstanding Green 2 Outstanding 466.59 Green Outstanding Outstanding Excellent Outstanding Outstanding T4 Outstanding 199.4 Green Outstanding Outstanding Amber Green Outstanding 9009.01 $39,742.78
CA-LA 11/20/15 586.44 586.44 98.79 97.81 107.22 100 89.90 82.81 98.56 95.93 90.18 110.9 100 99.30 Excellent Amber 1 93.77 Outstanding Green 2 Green Green Outstanding Outstanding Excellent Outstanding Outstanding T2 Amber Amber Outstanding Satisfactory Amber Green Outstanding 17869.42 $281,313.20
LA-CM 12/4/15 584.04 584.04 97.11 100.00 105.88 100 81.10 84.05 92.64 89.94 98.42 101.6 100 100.00 Excellent Amber 1 97.41 Outstanding Green 2 Amber 180.46 Amber Outstanding Outstanding Excellent Excellent Excellent T4 Green 198.04 Green Outstanding Outstanding Amber Amber Outstanding 16796.88 $104,834.64
WA 4/23/15 579.68 579.68 98.81 100.00 105.92 100 88.59 71.57 77.76 85.88 97.28 102.8 100 99.92 Outstanding Amber 1 91.45 Outstanding Amber 2 Green Green Outstanding Outstanding Satisfactory Satisfactory Excellent T4 Green Green Outstanding Outstanding Amber Green Outstanding 16434.26 $0.00
CA-SL 11/20/15 579.26 579.26 98.20 96.67 108.61 100 90.81 87.27 86.22 75.20 94.34 106.0 99.51 Satisfactory Green 1 Excellent Amber Outstanding Outstanding Excellent Excellent Marginal Outstanding Amber Amber Excellent $0.00
LA-GL 12/4/15 577.17 577.17 97.26 98.08 101.90 100 83.01 82.18 86.82 86.30 102.82 97.3 102.82 100.00 Outstanding Amber 1 95.99 Excellent Green 2 Amber Amber Outstanding Outstanding Excellent Excellent Excellent T4 Green Green Satisfactory Outstanding Amber Amber Excellent 16898.61 $109,340.29
GA-FS 2/20/15 575.67 575.67 96.70 98.88 93.65 93.65 83.68 89.89 84.17 89.52 101.62 98.4 101.62 99.63 Excellent Amber 1 94.71 Outstanding Green 2 Green Green Satisfactory Outstanding Outstanding Excellent Excellent T4 Green Green Outstanding Outstanding Amber Amber Excellent 12962.96 $2,992.64
LA-CB 12/4/15 575.55 575.55 97.04 97.98 103.70 100 78.88 78.78 84.18 82.02 93.69 106.7 100 99.56 Excellent Amber 1 96.24 Outstanding Green 2 Amber Amber Outstanding Excellent Satisfactory Excellent Satisfactory T4 Green Green Outstanding Outstanding Amber Amber Excellent 16079.60 $0.00
ID 8/28/14 568.41 568.41 95.23 90.99 0 ERROR:#DIV/0! 100 Excellent Green 1 97.06 Outstanding Green 2 Satisfactory 168.39 Amber T4 Red Red Outstanding Red Amber Marginal 14440.43 $111,583.71
WI 10/16/15 564.70 564.70 97.26 96.21 111.25 100 51.73 52.19 88.45 92.85 94.09 106.3 100 99.92 Outstanding Amber 1 98.32 Outstanding Green 2 Green Green Outstanding Unsatisfactory Unsatisfactory Excellent Excellent T4 Green Green Outstanding Outstanding Amber Amber Excellent 18604.65 $139.30
HI-BP 5/8/15 563.11 563.11 97.62 97.95 93.50 93.5 60.05 66.67 94.18 92.33 103.68 96.5 103.68 99.28 Outstanding Amber 1 87.91 Outstanding Amber 2 Green 170.65 Green Satisfactory Marginal Marginal Excellent Excellent T4 Amber 198.85 Amber Marginal Satisfactory Amber Amber Satisfactory 16538.00 $469,842.62
WV 2/5/15 561.61 561.61 98.29 95.64 121.00 100 49.05 69.52 62.38 92.62 98.38 101.6 100 99.29 Excellent Amber 1 93.55 Outstanding Green 2 Green Green Outstanding Unsatisfactory Marginal Marginal Excellent T4 Green Green Outstanding Outstanding Green Green Excellent 17801.00 $284,626.79
OR 2/11/16 561.17 561.17 96.41 93.92 108.54 100 64.02 70.99 71.18 80.46 92.05 108.6 100 99.18 Excellent Amber 2 95.69 Outstanding Green 2 Amber Amber Outstanding Satisfactory Satisfactory Satisfactory Satisfactory T3 Red Red Outstanding Outstanding Red Amber Excellent 21333.33 $41,590.31
GA-FG 2/20/15 558.91 558.91 93.24 96.21 91.88 91.88 69.40 71.29 88.73 85.65 93.68 106.7 100 98.85 Excellent Amber 2 84.02 Outstanding Green 2 Amber Amber Marginal Satisfactory Satisfactory Excellent Excellent T4 Green Green Outstanding Outstanding Amber Amber Satisfactory 14643.55 $70,449.25
MS 9/11/15 555.90 555.90 93.77 91.01 95.50 95.5 79.68 73.02 83.47 71.18 92.37 108.3 100 98.78 Excellent Amber 1 91.64 Outstanding Amber 2 Red Red Excellent Excellent Satisfactory Excellent Marginal T4 Green Green Outstanding Outstanding Red Amber Satisfactory 13489.96 $12,211.58
*MT 3/17/16 554.22 554.22 96.98 100.00 83.29 83.29 69.27 69.54 92.18 90.03 105.60 94.7 105.6 99.00 Marginal Amber 1 89.45 Outstanding Amber 2 Green Green Unsatisfactory Satisfactory Satisfactory Excellent Excellent T2 Green Green Unsatisfactory Outstanding Amber Amber Satisfactory 19404.26 $38,185.95
*AK 6/23/16 549.55 549.55 92.01 90.48 93.75 93.75 80.53 76.49 69.47 66.84 98.22 101.8 100 99.98 Excellent Green 2 89.8 Excellent Green 2 Satisfactory 168.92 Amber Satisfactory Excellent Excellent Satisfactory Satisfactory T4 Unsatisfactory 188.05 Red Outstanding Unsatisfactory Red Red Satisfactory 13737.37 $682,560.46
NC 12/4/14 548.82 548.82 96.49 95.36 96.20 96.2 67.33 61.78 83.56 78.22 107.48 93.0 107.48 95.01 Satisfactory Amber 2 77.28 Excellent Amber 2 Satisfactory 404.29 Amber Excellent Satisfactory Marginal Excellent Satisfactory T4 Marginal 194.24 Amber Unsatisfactory Marginal Amber Amber Satisfactory 16000.00 $250,033.38
*MD 5/26/16 542.45 542.45 91.77 93.81 93.75 93.75 51.34 63.08 87.78 96.82 105.37 94.9 105.37 93.46 Outstanding Amber 2 76.24 Outstanding Amber 2 Red Red Satisfactory Marginal Satisfactory Excellent Outstanding T4 Red Red Unsatisfactory Marginal Red Amber Satisfactory 29100.67 $259,015.57
SC 11/20/14 533.85 533.85 96.53 97.26 86.93 86.93 44.82 44.15 64.88 59.87 91.04 109.8 100 99.74 Marginal Amber 2 90.9 Excellent Amber 2 Red Red Unsatisfactory Unsatisfactory Unsatisfactory Marginal Unsatisfactory T4 Red Red Outstanding Outstanding Red Amber Satisfactory 19977.01 $0.00
*AR 4/28/16 532.37 532.37 81.74 86.29 94.00 94 64.55 68.59 84.15 81.27 104.93 95.3 104.93 99.91 Satisfactory Amber 2 83.49 Excellent Amber 2 Red Red Satisfactory Satisfactory Satisfactory Excellent Excellent T4 Red Red Unsatisfactory Outstanding Red Amber Satisfactory 19684.21 $212,076.00
NM 5/21/15 531.92 531.92 93.67 88.24 82.54 82.54 74.71 72.94 83.53 80.59 103.80 96.3 103.8 93.19 Outstanding Green 3 81.99 Outstanding Green 2 Unsatisfactory 140.36 Red Unsatisfactory Excellent Satisfactory Excellent Satisfactory T4 Outstanding 199.74 Green Marginal Outstanding Red Amber Satisfactory 22764.23 $15,981.43
*OK 6/9/16 531.53 531.53 92.08 84.87 99.09 99.09 70.42 74.87 60.99 53.14 110.21 90.7 110.21 99.90 Excellent Amber 2 Satisfactory Amber Satisfactory 377.61 Amber Outstanding Satisfactory Excellent Marginal Marginal T4 Unsatisfactory 188.97 Red Unsatisfactory Unsatisfactory Red Amber Satisfactory 23188.41 $360,341.19
TX-W 10/9/14 522.64 522.64 95.96 90.17 98.25 98.25 54.22 44.88 79.22 78.31 131.39 76.1 131.39 97.99 Satisfactory Amber 2 83.46 Satisfactory Amber 2 Red Red Outstanding Unsatisfactory Unsatisfactory Satisfactory Satisfactory T4 Green Green Unsatisfactory Outstanding Red Amber Satisfactory 19672.13 $14,384.06
IL 10/23/14 520.48 520.48 95.05 94.72 91.90 91.9 37.15 28.62 50.36 39.37 99.72 100.3 100 99.93 Excellent Amber 1 87.97 Outstanding Amber 2 Red Red Marginal Unsatisfactory Unsatisfactory Unsatisfactory Unsatisfactory T4 Red Red Outstanding Satisfactory Red Amber Marginal 15189.87 $411,077.87
MI 1/28/16 520.12 520.12 89.47 86.51 100.00 100 61.97 59.66 65.13 49.79 117.44 85.1 117.44 99.85 Outstanding Amber 1 90.77 Excellent Green 2 Red Red Outstanding Marginal Unsatisfactory Marginal Unsatisfactory T4 Green Green Unsatisfactory Outstanding Red Amber Marginal 16401.77 $6,102.44
KY-FK 8/13/15 517.69 517.69 89.14 93.75 98.50 98.5 44.90 37.50 57.40 45.41 109.79 91.1 109.79 98.91 Outstanding Green 3 84.3 Excellent Amber 2 Marginal 162.41 Red Outstanding Unsatisfactory Unsatisfactory Marginal Unsatisfactory T4 Unsatisfactory 174.1 Red Unsatisfactory Satisfactory Red Amber Marginal 16080.40 $182,596.54
IN 4/9/15 505.61 505.61 92.21 99.14 77.25 77.25 51.12 42.98 66.29 78.37 124.60 80.3 124.6 97.06 Excellent Green 2 93.79 Outstanding Amber 2 Unsatisfactory 130.78 Red Unsatisfactory Unsatisfactory Unsatisfactory Marginal Satisfactory T4 Outstanding 199.93 Green Unsatisfactory Outstanding Red Amber Marginal 15884.48 $29,974.30
VA 11/6/14 503.12 503.12 89.57 98.74 85.56 85.56 59.25 56.34 26.82 22.25 104.49 95.7 104.49 92.38 Satisfactory Amber 2 84.04 Outstanding Green 2 Unsatisfactory 126.72 Red Unsatisfactory Marginal Unsatisfactory Unsatisfactory Unsatisfactory T4 Unsatisfactory 188.09 Red Unsatisfactory Unsatisfactory Red Red Marginal $1,527,961.02
KY-HN 8/13/15 491.54 491.54 89.75 97.22 87.75 87.75 49.13 43.60 57.79 39.79 144.43 69.2 144.43 100.00 Marginal Amber Excellent Amber Unsatisfactory 259.5 Red Unsatisfactory Unsatisfactory Unsatisfactory Marginal Unsatisfactory Unsatisfactory 187.19 Red Unsatisfactory Unsatisfactory Unsatisfactory Red Unsatisfactory 14723.54 $959,472.08
*FL 3/31/16 490.25 490.25 94.37 94.95 111.67 100 0.30 0.30 2.27 2.27 91.38 109.4 100 99.64 Excellent Amber Marginal Amber Unsatisfactory 278.54 Red Outstanding Unsatisfactory Unsatisfactory Unsatisfactory Unsatisfactory Unsatisfactory 147.18 Red Outstanding Excellent Unsatisfactory Red Unsatisfactory 14285.71 $117,377.58
NJ 3/12/15 468.76 468.76 84.63 94.92 86.00 86 8.54 9.37 8.82 9.37 103.64 96.5 103.64 97.70 Excellent Red 2 86.16 Excellent Amber 2 Red Red Unsatisfactory Unsatisfactory Unsatisfactory Unsatisfactory Unsatisfactory T4 Red Red Marginal Excellent Red Red Unsatisfactory 16240.13 $102,460.46
WY 8/14/14 453.15 453.15 91.12 94.92 77.59 77.59 51.92 52.88 43.27 52.88 204.78 48.8 204.78 98.35 Unsatisfactory Amber 2 87.43 Satisfactory Amber 2 Unsatisfactory 136.31 Red Unsatisfactory Unsatisfactory Unsatisfactory Unsatisfactory Unsatisfactory T4 Unsatisfactory 192.3 Red Unsatisfactory Unsatisfactory Red Red Unsatisfactory 18652.85 $911,843.78
HI-HI 5/5/15 413.26 413.26 89.61 97.92 41.75 41.75 31.41 23.04 44.50 32.46 164.93 60.6 90.50 Satisfactory Amber 2 78.84 Outstanding Amber 2 Unsatisfactory 120.59 Red Unsatisfactory Unsatisfactory Unsatisfactory Unsatisfactory Unsatisfactory T4 0 0 Unsatisfactory 0 Red Red Unsatisfactory 47058.82 $0.00
DC 9/24/15 402.90 402.90 77.63 88.14 45.00 45.00 24.44 43.70 59.26 53.33 182.05 54.9 92.02 Marginal Amber 2 Unsatisfactory Red Unsatisfactory 240.59 Red Unsatisfactory Unsatisfactory Unsatisfactory Marginal Unsatisfactory T4 Unsatisfactory Red Unsatisfactory Unsatisfactory Red Red Unsatisfactory 36000.00 $0.00
534.66 93.54 94.77 94.99 88.39 60.35 60.04 70.11 68.47 109.66 98.14
New Score OE Compliance Final RM Compliance Final Graduation Target Graduation target capped Month 6 Placement Month 12 Placement Month 6 Contact Month 12 Contact Cost per Cadet Cost per Cadet asc Cost per Cadet floored Budget Execution
New Score 1
OE Compliance Final 0.3786890361 1
RM Compliance Final 0.4836105558 0.3405579198 1
Graduation Target 0.5896091404 0.3859149155 0.433420864 1
Graduation target capped 0.5407081671 0.4098030999 0.3912259827 0.8469138166 1
Month 6 Placement 0.9208489081 0.2405122286 0.4893600568 0.4318430732 0.3459053226 1
Month 12 Placement 0.9308971704 0.2543796898 0.46898559 0.43565324 0.3718254555 0.9379886786 1
Month 6 Contact 0.7820690505 0.2313652576 0.245892434 0.2758550471 0.1734783806 0.7313916235 0.7224806907 1
Month 12 Contact 0.8037621873 0.2489073807 0.2599935277 0.3139730492 0.2581601205 0.7291222605 0.8146581953 0.9276167506 1
Cost per Cadet -0.3695377192 -0.2333752469 -0.1029651081 -0.6900037359 -0.8198270818 -0.1325019728 -0.0764444323 -0.1022909651 -0.0464791843 1
Cost per Cadet asc 0.4210278498 0.2785088431 0.2047583724 0.7564264054 0.8308819991 0.2121626574 0.1370015962 0.1212172684 0.0542784755 -0.961630731 1
Cost per Cadet floored -0.3086831371 -0.2033215951 -0.0221349322 -0.6274603143 -0.7979770495 -0.0639242102 -0.0165923873 -0.0642648048 -0.018304917 0.9858894866 -0.9099583929 1
Budget Execution 0.4998603932 0.0288139698 0.6404802247 0.2190982096 0.1546685772 0.58743237 0.4844721353 0.3019239064 0.2442225112 -0.0025221604 0.0416487058 0.0411431046 1
New Score OE Compliance Final RM Compliance Final Graduation Target Graduation target capped Month 6 Placement Month 12 Placement Month 6 Contact Month 12 Contact Cost per Cadet Cost per Cadet asc Cost per Cadet floored Budget Execution
Mean 735.38 89.90 92.24 97.12 92.38 62.95 63.70 69.39 70.55 109.11 95.16 112.32 98.38
Standard Error 16.99 0.76 0.81 3.15 2.12 3.89 3.96 4.27 4.29 4.57 2.90 4.19 0.42
Median 765.19 91.16 93.10 98.00 98.00 67.00 66.50 79.30 81.26 99.70 100.30 100.00 99.40
Mode 781.07 90.43 96.24 105.00 100.00 86.00 75.00 91.00 84.00 91.80 108.93 100.00 100.00
Standard Deviation 96.10 4.31 4.60 17.84 12.00 22.02 22.40 24.16 24.26 25.45 16.17 23.34 2.33
Sample Variance 9234.56 18.59 21.19 318.27 144.12 485.03 501.81 583.90 588.53 647.56 261.36 544.64 5.41
Kurtosis 0.49 6.44 -0.01 3.80 5.85 0.13 0.31 -0.25 0.24 6.76 1.42 8.81 6.80
Skewness -1.02 -2.21 -0.75 0.13 -2.28 -0.90 -0.91 -0.85 -1.08 2.40 -1.13 2.85 -2.36
Range 365.45 20.76 17.27 106.24 52.25 78.86 84.31 85.27 84.79 122.48 72.67 104.78 10.62
Minimum 489.54 73.21 81.74 47.75 47.75 11.14 7.69 11.14 11.14 82.30 48.83 100.00 89.38
Maximum 854.99 93.97 99.01 153.99 100.00 90.00 92.00 96.41 95.93 204.78 121.51 204.78 100.00
Sum 23532.21 2876.84 2951.69 3107.73 2956.14 2014.53 2038.29 2220.43…
This is the start of the file's text. The full file is on GovTribe.
File details come from the government source that posted it. Updated .