PWS_Attachment_13-YCP-Assessment_Overall_Health_Calculator_V5.xlsx
XLSX spreadsheet 23 KB Posted
- Attached to
- YCP INSPECTION Services ONLY
- 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
Show all 47
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Overall Health Calculator
FOR GOVERNMENT USE ONLY
Instructions: Fill in the green shaded boxes by inputing the Program Code,Visit Date, and scores (including two decimal places) for all compliance and individual performance metrics.
| Program Code |
| Visit Date |
| Assign based on score ranges | Compute decile for pointer placement | Lower bounds of each range | ||||||
| Score | Rating | ExSum (out of 10) | Outstanding | Excellent | Satisfactory | Marginal | Unsatisfactory | |
| OE Compliance | 100.00 | Outstanding | 10 | 95 | 90 | 85 | 80 | 0 |
| RM Compliance | 100.00 | Outstanding | 10 | 95 | 90 | 85 | 80 | 0 |
| Graduation Target | 101.00 | Outstanding | 10 | 98 | 95 | 93 | 90 | 0 | 15 |
| Month 6 Placement | 57.00 | Satisfactory | 0 | 85 | 71 | 57 | 43 | 0 | |
| Month 12 Placement | 73.00 | Excellent | 0 | 86 | 73 | 59 | 46 | 0 | |
| Month 6 Contact | 53.00 | Marginal | 0 | 95 | 81 | 67 | 53 | 0 | |
| Month 12 Contact | 66.00 | Satisfactory | 0 | 94 | 80 | 66 | 52 | 0 | |
| OE Performance (sum standard scores) | 162.25 | Satisfactory | 5 | 188 | 171 | 155 | 139 | 0 |
| Cost per Cadet | 102.90 | Satisfactory | 7 | 102 | 102.7 | 103.3 | 104 | inf | 7 |
| Budget Execution | 100.00 | Outstanding | 10 | 99 | 98.3 | 97.7 | 97 | 0 | |
| Financial Performance (sum standard scores) | 197.18 | Outstanding | 1 | 197 | 196 | 195 | 193 | 0 |
| Overall Health (sum component scores) | 559.43 | Excellent | 4 | 575 | 547 | 520 | 492 |
| Notes: There is no rounding for ratings. Performance scores are sum of each Performance metric. Dollar cost per Cadet floored at 100% and converted to ascending measure for Financial Performance total score; Graduation Target is capped at 100% for OE Performance total score. Overall health score is the sum of the four component scores. |
Overall Health Outbrief Slide Assessment Results
| Overall Health Score: | 559.43 | This sheet provides the information in the format needed for the Outbrief slides. Copy the required cells from this page. Highlight those cells in PowerPoint and paste. |
| Overall Health Rating: | EXCELLENT |
| Component | Rating |
| Operational Compliance | Outstanding |
| Resource Management Compliance | Outstanding |
| Operational Performance | Satisfactory |
| Financial Performance | Outstanding |
File details come from the government source that posted it. Updated .