Attachment 6A - Draft Workload Framework Examples (Track 1).xlsx
XLSX spreadsheet 33 KB Posted
- Solicitation number
- RFIPVField2027
About this file
This is a draft workload framework examples spreadsheet for the DCSA Personnel Vetting Fieldwork Services requirement, demonstrating evaluation methodologies for two and three vendor models.
The document presents example scoring scenarios across four evaluation criteria: pricing, timeliness, quality, and average case age. Each criterion has a maximum point value (pricing 50 points, timeliness 25 points, quality 25 points, average case age 25 points) for a total of 125 possible points. The framework uses three workload tiers—Low Tier (LT), Medium Tier (MT), and High Tier (HT)—to categorize fieldwork by complexity or volume. For the two-vendor model, example scenarios show Vendor A and B competing for tier allocations ranging from 40% to 60%, with final rankings and point totals. For the three-vendor model, allocations are distributed across three vendors at 20%, 30%, and 50% per tier based on scoring performance. Pricing examples show unit prices ranging from $110 to $710 depending on tier and vendor. Timeliness is evaluated using percentage scores with categorical ratings from "Exceptional" (25 points) to "Unsatisfactory" (5 points), and quality scores similarly range from 98.99% to 92.99% across vendors. Average case age is ranked based on days, with lower ages receiving higher point values. The framework demonstrates how different vendor performance levels would result in varying workload allocations and contract awards under both competitive models.
View the file
Other files
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
Summary
2 VENDOR MODEL
| TOTAL | Price | Timeliness | Quality | Average Age | Total Points | Final Points | Vendor A | Vendor B | Final Rank | Vendor A | Vendor B | Allocation | Vendor A | Vendor B |
| POINTS POSSIBLE | 50 | 25 | 25 | 25 | 125 | LT | 95 | 75 | LT | 1 | 2 | LT | 60% | 40% |
| MT | 105 | 100 | MT | 1 | 2 | MT | 60% | 40% | ||||||
| Vendor A | Price | Timeliness | Quality | Average Age | Total Points | HT | 85 | 115 | HT | 2 | 1 | HT | 40% | 60% |
| LT | 25 | 20 | 25 | 25 | 95 | |||||||||
| MT | 50 | 15 | 25 | 15 | 105 | |||||||||
| HT | 25 | 25 | 20 | 15 | 85 |
| Vendor B | Price | Timeliness | Quality | Average Age | Total Points |
| LT | 50 | 5 | 5 | 15 | 75 |
| MT | 25 | 25 | 25 | 25 | 100 |
| HT | 50 | 20 | 20 | 25 | 115 |
3 VENDOR MODEL
| TOTAL | Price | Timeliness | Quality | Average Age | Total Points | Final Points | Vendor A | Vendor B | Vendor C | Final Rank | Vendor A | Vendor B | Vendor C | Allocation | Vendor A | Vendor B | Vendor C |
| POINTS POSSIBLE | 50 | 25 | 25 | 25 | 125 | LT | 80 | 55 | 95 | LT | 2 | 3 | 1 | LT | 30% | 20% | 50% |
| MT | 95 | 105 | 55 | MT | 2 | 1 | 3 | MT | 30% | 50% | 20% | ||||||
| Vendor A | Price | Timeliness | Quality | Average Age | Total Points | HT | 80 | 115 | 70 | HT | 2 | 1 | 3 | HT | 30% | 50% | 20% |
| LT | 10 | 20 | 25 | 25 | 80 | ||||||||||||
| MT | 50 | 15 | 25 | 5 | 95 | ||||||||||||
| HT | 30 | 25 | 20 | 5 | 80 |
| Vendor B | Price | Timeliness | Quality | Average Age | Total Points |
| LT | 30 | 5 | 5 | 15 | 55 |
| MT | 30 | 25 | 25 | 25 | 105 |
| HT | 50 | 20 | 20 | 25 | 115 |
| Vendor C | Price | Timeliness | Quality | Average Age | Total Points |
| LT | 50 | 15 | 25 | 5 | 95 |
| MT | 10 | 5 | 25 | 15 | 55 |
| HT | 10 | 25 | 20 | 15 | 70 |
Pricing
| 2 VENDOR MODEL | |||||||||||
| Pricing Table | Rank | Points | Valuation | ||||||||
| Vendor A | Vendor B | Vendor A | Vendor B | Vendor A | Vendor B | ||||||
| LT | $ 140.00 | $ 130.00 | T1 | 2 | 1 | T1 | 25 | 50 | 1st | 50 | |
| MT | $ 305.00 | $ 320.00 | T2 | 1 | 2 | T2 | 50 | 25 | 2nd | 25 | |
| HT | $ 650.00 | $ 645.00 | T3 | 2 | 1 | T3 | 25 | 50 |
| 3 VENDOR MODEL | ||||||||||||||
| Pricing Table | Rank | Points | Valuation | |||||||||||
| Vendor A | Vendor B | Vendor C | Vendor A | Vendor B | Vendor C | Vendor A | Vendor B | Vendor C | ||||||
| LT | $ 140.00 | $ 130.00 | $ 110.00 | T1 | 3 | 2 | 1 | T1 | 10 | 30 | 50 | 1st | 50 | |
| MT | $ 305.00 | $ 320.00 | $ 325.00 | T2 | 1 | 2 | 3 | T2 | 50 | 30 | 10 | 2nd | 30 | |
| HT | $ 650.00 | $ 645.00 | $ 710.00 | T3 | 2 | 1 | 3 | T3 | 30 | 50 | 10 | 3rd | 10 | |
| The unit prices above are for the example models only and do not reflect Government estimates. |
Timeliness
| 2 VENDOR MODEL | ||||||||||
| Timeliness Score | Categorical Rating | Points | Valuation | |||||||
| Vendor A | Vendor B | Vendor A | Vendor B | Vendor A | Vendor B | |||||
| LT | 97.23% | 92.00% | Very Good | Unsatisfactory | T1 | 20 | 5 | Exceptional | 25 | |
| MT | 96.54% | 98.21% | Satisfactory | Exceptional | T2 | 15 | 25 | Very Good | 20 | |
| HT | 99.12% | 96.51% | Exceptional | Very Good | T3 | 25 | 20 | Satsifactory | 15 | |
| Marginal | 10 | |||||||||
| Unsatisfactory | 5 |
3 VENDOR MODEL
| Timeliness Score | Categorical Rating | Points | Valuation | |||||||||
| Vendor A | Vendor B | Vendor C | Vendor A | Vendor B | Vendor C | Vendor A | Vendor B | Vendor C | ||||
| LT | 97.23% | 92.00% | 96.12% | Very Good | Unsatisfactory | Satisfactory | T1 | 20 | 5 | 15 | Exceptional | 25 |
| MT | 96.54% | 98.21% | 92.22% | Satisfactory | Exceptional | Unsatisfactory | T2 | 15 | 25 | 5 | Very Good | 20 |
| HT | 99.12% | 96.51% | 98.55% | Exceptional | Very Good | Exceptional | T3 | 25 | 20 | 25 | Satsifactory | 15 |
| Marginal | 10 | |||||||||||
| Unsatisfactory | 5 |
Quality
| 2 VENDOR MODEL | |||||||||||||
| Quality Score | Categorical Rating | Points | Valuation | ||||||||||
| Vendor A | Vendor B | Vendor C | Vendor A | Vendor B | Vendor C | Vendor A | Vendor B | Vendor C | |||||
| LT | 98.99% | 92.99% | 94.67% | Exceptional | Unsatisfactory | Marginal | T1 | 25 | 5 | 10 | Exceptional | 25 | |
| MT | 98.64% | 99.98% | 99.84% | Exceptional | Exceptional | Exceptional | T2 | 25 | 25 | 25 | Very Good | 20 | |
| HT | 97.77% | 97.62% | 96.76% | Very Good | Very Good | Very Good | T3 | 20 | 20 | 20 | Satsifactory | 15 | |
| Marginal | 10 | ||||||||||||
| Unsatisfactory | 5 |
| 3 VENDOR MODEL | |||||||||||||
| Quality Score | Categorical Rating | Points | Valuation | ||||||||||
| Vendor A | Vendor B | Vendor C | Vendor A | Vendor B | Vendor C | Vendor A | Vendor B | Vendor C | |||||
| LT | 98.99% | 92.99% | 94.67% | Exceptional | Unsatisfactory | Exceptional | T1 | 25 | 5 | 25 | Exceptional | 25 | |
| MT | 98.64% | 99.98% | 99.84% | Exceptional | Exceptional | Exceptional | T2 | 25 | 25 | 25 | Very Good | 20 | |
| HT | 97.77% | 97.62% | 96.76% | Very Good | Very Good | Very Good | T3 | 20 | 20 | 20 | Satsifactory | 15 | |
| Marginal | 10 | ||||||||||||
| Unsatisfactory | 5 |
Age
| 2 VENDOR MODEL | |||||||||||
| Average Case Age | Rank | Points | Valuation | ||||||||
| Vendor A | Vendor B | Vendor A | Vendor B | Vendor A | Vendor B | ||||||
| LT | 23.45 | 23.68 | T1 | 1 | 2 | T1 | 25 | 15 | 1st | 25 | |
| MT | 21.06 | 19.35 | T2 | 2 | 1 | T2 | 15 | 25 | 2nd | 15 | |
| HT | 24.43 | 22.51 | T3 | 2 | 1 | T3 | 15 | 25 | 3rd | 5 |
| 3 VENDOR MODEL | ||||||||||||||
| Average Case Age | Rank | Points | Valuation | |||||||||||
| Vendor A | Vendor B | Vendor C | Vendor A | Vendor B | Vendor C | Vendor A | Vendor B | Vendor C | ||||||
| LT | 23.45 | 23.68 | 26.12 | T1 | 1 | 2 | 3 | T1 | 25 | 15 | 5 | 1st | 25 | |
| MT | 21.06 | 19.35 | 19.5 | T2 | 3 | 1 | 2 | T2 | 5 | 25 | 15 | 2nd | 15 | |
| HT | 24.43 | 22.51 | 23.58 | T3 | 3 | 1 | 2 | T3 | 5 | 25 | 15 | 3rd | 5 |
Snapshot
2 VENDOR MODEL
| Vendor A | Price | Timeliness | Quality | Average Age | Total Points | Rank | Allocation |
| LT | 25 | 20 | 25 | 25 | 100 | 1 | 60% |
| MT | 50 | 15 | 25 | 15 | 105 | 1 | 60% |
| HT | 25 | 25 | 20 | 15 | 110 | 2 | 40% |
3 VENDOR MODEL
| Vendor A | Price | Timeliness | Quality | Average Age | Total Points | Rank | Allocation |
| LT | 40 | 20 | 25 | 15 | 80 | 2 | 30% |
| MT | 60 | 15 | 25 | 5 | 95 | 2 | 30% |
| HT | 60 | 25 | 20 | 5 | 80 | 2 | 30% |
File details come from the government source that posted it. Updated .