Attachment_6 _Sample__PCA_Transfer_Allocation_Calculator_and_QFactor.xlsx
XLSX spreadsheet 20 KB Posted
- Attached to
- Debt Collection Services Award Federal contract opportunity
- Solicitation number
- ED-FSA-16-R-0009
About this file
Attachment 6 Sample CPME Calculation
View the file
Other files for this federal contract opportunity
Show all 23
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
Allocation Rates
| Borrowers Resolved Score | Dollars Collected Score | Total Base Score | Base Allocation | Service Quality (SQ) | Final Allocation | ||||||||||
| Weight: | 50% | Weight: | 50% | Minimum Acceptable Ratio | 70% | Minimum Acceptable | 40 | ||||||||
| Agency | Borrowers Resolved | Total Inventory | Unweighted Score | Weighted Score | Dollars Collected | Total Inventory Balance | Unweighted Score | Weighted Score | Unadjusted | Adjusted | Score | SQ Score | Allocation Modifier | Adjusted Allocation Score | Final Allocation Percentage |
| Vendor 1 | 6,000 | 15,000 | 40.00 | 20.00 | $ 40,000.00 | $ 100,000.00 | 40.00 | 20.00 | 40.00 | 40.00 | 36.64 | 32.35 | -100.00% | 0.00 | 0% |
| Vendor 2 | 4,500 | 15,000 | 30.00 | 15.00 | $ 22,000.00 | $ 100,000.00 | 22.00 | 11.00 | 26.00 | 0.00 | 0.00 | 38.27 | -100.00% | 0.00 | 0% |
| Vendor 3 | 6,500 | 15,000 | 43.33 | 21.67 | $ 20,000.00 | $ 100,000.00 | 20.00 | 10.00 | 31.67 | 31.67 | 29.01 | 54.47 | 4.47% | 30.30 | 49% |
| Vendor 4 | 9,000 | 15,000 | 60.00 | 30.00 | $ 15,000.00 | $ 100,000.00 | 15.00 | 7.50 | 37.50 | 37.50 | 34.35 | 43.41 | -6.59% | 32.09 | 51% |
| Top Score: | 40.00 | Allocation Total: | 62.39 | ||||||||||||
| Minimum Acceptable Score: | 28.00 | ||||||||||||||
| Notes: | |||||||||||||||
| This information is being provided as a sample so that vendors may better understand how allocations will be handled. | |||||||||||||||
| White boxes allow data entry; colored boxes are calculated | |||||||||||||||
| Total score minimum (cell k2): establishes the minimum score the bottom collector must achieve, as a percent of the top collector's score, to qualify for any placements; as currently, we are grading on a curve | |||||||||||||||
| Minimum acceptable (cell j9): top score (cell j8) multiplied by total score minimum percentage (cell k2) | |||||||||||||||
| Adjusted score (column K): score is reduced to zero if below the minimum acceptable (cell j9) | |||||||||||||||
| SQ Minimum (cell n2): an absolute minimum that FSA establishes for SQ acceptability; PCAs below this score are ineligible for any placements, regardless of collection score | |||||||||||||||
| Allocation modifier (column n): base allocation is reduced in proportion to the SQ score (assumes maximum SQ score of 100 points); modifier becomes -100% if minimum SQ score is not met | |||||||||||||||
| Borrowers Resolved/Dollars collected will be equally weighted. | |||||||||||||||
| Total Base Score % and Minimum Service Quality % are still being determined and will be provided prior to the placement of any accounts. | |||||||||||||||
| ED reserves the right to modify any of these weights and will provide a minmum of 30 days notice in the event a change to weights is necessary. |
&F &A
Page &P of &N Date Printed: &D
SQ Score
| Call Counseling Compliance Score | Borrower Satisfaction Score | Service Quality (SQ) | ||||||||
| Weight: | 50% | Weight: | 50% | |||||||
| Agency | Calls With No Errors | Total Calls monitored | Unweighted Score | Weighted Score | Borrower Complaints | Share of Complaints | Share of Portfolio | Unweighted Score | Weighted Score | |
| Vendor 1 | 70 | 100 | 70.00 | 35.00 | 50 | 30% | 25% | -5.30 | -2.65 | 32.35 |
| Vendor 2 | 97 | 100 | 97.00 | 48.50 | 75 | 45% | 25% | -20.45 | -10.23 | 38.27 |
| Vendor 3 | 90 | 100 | 90.00 | 45.00 | 10 | 6% | 25% | 18.94 | 9.47 | 54.47 |
| Vendor 4 | 80 | 100 | 80.00 | 40.00 | 30 | 18% | 25% | 6.82 | 3.41 | 43.41 |
| Total Complaints: | 165 |
| Notes: |
| This information is being provided as a sample so that vendors may better understand how Quality will be handled. |
| White boxes allow data entry; colored boxes are calculated |
| The items listed above (Call Counesling/Complaints) are being used for purposes of conveying items ED MAY consider as part of the Quality Factor. |
| Any items finalized for inclusion in the quality factor will be shared at least 30 days in advance. |
&F &A
Page &P of &N Date Printed: &D
Evaluation Scores
| Comparative Performance Score | Comparative Service Quality | Total Score | |||||
| Weight | 40% | Weight | 60% | ||||
| Agency | Unadjusted Total Base Score | Unweighted | Weighted | SQ Score | Unweighted | Weighted | |
| Vendor 1 | 40.00 | 100.00 | 40.00 | 32.35 | 59.39 | 35.63 | 75.63 |
| Vendor 2 | 26.00 | 65.00 | 26.00 | 38.27 | 70.26 | 42.16 | 68.16 |
| Vendor 3 | 31.67 | 79.17 | 31.67 | 54.47 | 100.00 | 60.00 | 91.67 |
| Vendor 4 | 37.50 | 93.75 | 37.50 | 43.41 | 79.69 | 47.82 | 85.32 |
| Top Score | 40.00 | 54.47 |
File details come from the government source that posted it. Updated .