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

Other files attached to YCP INSPECTION Services ONLY, newest first.
File Type Posted
PWS_Attachment_12-Budget_Data_Capture_Report_template.pdf PDF
PWS_Attachment_2-YCP-2015_Annual_Report_V10__Final.pdf PDF
PWS_Attachment_16-YCP-Hot_Wash_Overview_Template.docx DOCX document
PWS_Attachment_18-YCP-Template_Inspection_Executive_Summary.docx DOCX document
PWS_Attachment_19-YCP-Template_Report_of_Inspection_Package.pdf PDF
PWS_Attachment_17-YCP-_Formal_Out-Brief_PowerPoint_Overview.pptx PPTX presentation
PWS_Attachment_3-YCP-Biannual_Checklist_Analysis_Report.docx DOCX document
PWS_Attachment_11-YCP-RM_Compliance_Checklist_V2_(Oct_16-Sep_17)_.docx DOCX document
PWS_Attachment_8-YCP-Operations_Compliance_Checklist_(Oct_16-Sep_17).docx DOCX document
PWS_Attachment_5-YCP-DSAs.pdf PDF
PWS_Attachment_4-YCP-Quarterly_Assessment_Summary_Report.pdf PDF
PWS_Attachment_15-YCP-Operational_Checklist_Workbook_V16.xlsm XLSM spreadsheet
PWS_Attachment_1-YCP-Template_Trend_Analysis_Briefing.pptx PPTX presentation
PWS_Attachment_7-YCP-Inspection_Notification_Memo.docx DOCX document
PWS_Attachment_13-YCP-Assessment_Overall_Health_Calculator_V5.xlsx XLSX spreadsheet
PWS_Attachment_9-YCP-Operations_Performance_Checklist_(Oct_16-Sep_17).docx DOCX document
Price_Proposal_Matrix-YCP_INSPECTIONS-July_20_2017.xlsx XLSX spreadsheet
PWS_Attachment_6-YCP-Template_Stoplight_Chart.pdf PDF
PWS_Attachment_10-YCP-Financial_Performance_Checklist_(Oct_16-Sep_17).docx DOCX document
PWS_Attachment_14-YCP-RM_Checklist_Workbook_V16.xlsm XLSM spreadsheet
W9133L-17-R-0030-YCP-RELEASED-Aug_18,_2017.docx DOCX document
Synopsis-YCP-INSPECTIONS_IDIQ-July_19,_2017.docx DOCX document
PWS_Attachment_9-YCP-Operations_Performance_Checklist_(Oct_16-Sep_17).docx DOCX document
PWS_Attachment_16-YCP-Hot_Wash_Overview_Template.docx DOCX document
PWS_Attachment_14-YCP-RM_Checklist_Workbook_V16.xlsm XLSM spreadsheet
PWS_Attachment_5-YCP-DSAs.pdf PDF
PWS_Attachment_2-YCP-2015_Annual_Report_V10__Final.pdf PDF
PWS_Attachment_11-YCP-RM_Compliance_Checklist_V2_(Oct_16-Sep_17)_.docx DOCX document
PWS_Attachment_10-YCP-Financial_Performance_Checklist_(Oct_16-Sep_17).docx DOCX document
PWS_Attachment_7-YCP-Inspection_Notification_Memo.docx DOCX document
PWS_Attachment_17-YCP-_Formal_Out-Brief_PowerPoint_Overview.pptx PPTX presentation
PWS_Attachment_18-YCP-Template_Inspection_Executive_Summary.docx DOCX document
PWS_Attachment_15-YCP-Operational_Checklist_Workbook_V16.xlsm XLSM spreadsheet
Price_Proposal_Matrix-YCP_INSPECTIONS-July_20_2017.xlsx XLSX spreadsheet
PWS_Attachment_19-YCP-Template_Report_of_Inspection_Package.pdf PDF
PWS_Attachment_8-YCP-Operations_Compliance_Checklist_(Oct_16-Sep_17).docx DOCX document
PWS_Attachment_13-YCP-Assessment_Overall_Health_Calculator_V5.xlsx XLSX spreadsheet
PWS_Attachment_4-YCP-Quarterly_Assessment_Summary_Report.pdf PDF
Task_Order_1-_YCP_Inspections-July_21_2017-Patrick.docx DOCX document
PWS_Attachment_6-YCP-Template_Stoplight_Chart.pdf PDF
PWS-IDIQ-_YCP_Inspections-July_21_2017-Patrick_(1230).docx DOCX document
PWS_Attachment_3-YCP-Biannual_Checklist_Analysis_Report.docx DOCX document
PWS_Attachment_12-Budget_Data_Capture_Report_template.pdf PDF
Proposal_Instructions_and_Content-YCP_Inspection_IDIQ.docx DOCX document
RFI-Synopsis-YCP-IDIQ-Modification.docx DOCX document
COMBINED_Training_and_Inspection_Contract-Dec_20_2016_(1400)-Current.docx DOCX document
RFI-Synopsis-YCP-IDIQ.docx DOCX document
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

ProgramPrevious InspectionCurrent Inspection
DateRatingDateRating

Inspection Dates

ProgramPrevious InspectionCurrent Inspection
DateRatingDateRating

Inspection Dates

Inspection Dates

ProgramPrevious InspectionCurrent Inspection
DateRatingDateRating

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.

OustandingExcellentSatisfactoryMarginalUnsatisfactory379492015
OustandingExcellentSatisfactoryMarginalUnsatisfactory5108662016
OustandingExcellentSatisfactoryMarginalUnsatisfactory89666

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

2014201520160918Excellent Satisfactory Marginal
201420152016312516Unsatisfactory
201420152016111

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

201420152016121919Excellent Satisfactory Marginal
201420152016231516Unsatisfactory
201420152016010

Budget Execution

Budget Execution Comparison

Oustanding

201420152016161920Excellent Satisfactory Marginal
201420152016698Unsatisfactory
2014201520161056

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

201420152016161816Excellent Satisfactory Marginal
201420152016244Unsatisfactory
201420152016131114

Graduation Target

Graduation Target Comparison

Oustanding

201420152016161514Excellent Satisfactory Marginal
2014201520166810Unsatisfactory
201420152016101110

Contact Rate at 6 Months

Contact Rate at 6 Months Comparison

Oustanding

201420152016232Excellent Satisfactory Marginal
201420152016212326Unsatisfactory
201420152016986

Placement Rate at 6 Months

Placement at 6 Months Comparison

Oustanding

201420152016678Excellent Satisfactory Marginal
201420152016151612Unsatisfactory
201420152016111114

Contact Rate at 12 Months

Contact Rate at 12 Months Comparison

Oustanding

201420152016223Excellent Satisfactory Marginal
201420152016192120Unsatisfactory
201420152016111111

Placement Rate at 12 Months

Placement at 12 Months Comparison

Oustanding

201420152016451Excellent Satisfactory Marginal
201420152016171720Unsatisfactory
201420152016111213

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
CourseTotal ReportedCompletedNot Completed
Employed More than 6 monthsEmployed Less than 6 months
Basic Course
Cadre Course
Counselor Course
Educators Course
Recruiters Course
Post Residential Course

Training Data

In-House Training Required
CourseTotal ReportedCompletedNot 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 .