Attachment 2a_Workload.xlsx
XLSX spreadsheet 30 KB Posted
- Attached to
- AFPSL Recompete Federal contract opportunity
- Solicitation number
- FA2263-20-R-0002
About this file
This document contains a workload estimate spreadsheet and information about a related federal contract opportunity. The workload estimate spreadsheet provides historical and projected workload data in quantity of hours by laboratory area and test type for an organization from fiscal years 2015 through 2025. The related federal contract opportunity is solicitation number FA2263-20-R-0002 for the AFPSL Recompete to provide support services to the Air Force Materiel Command Lifecycle Management Center at Wright Patterson Air Force Base. The final RFP for this opportunity is anticipated to be posted on January 31, 2020. Questions and responses from the first draft solicitation posting are also included.
View the file
Other files for this federal contract opportunity
Show all 50
AFPSL Recompete has more files on GovTribe.
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
TE2A new
| TECHNICAL EXHIBIT 2a WORKLOAD ESTIMATE | |
| 30-Dec-19 |
| Laboratory Area | Cost Center | FY2015 | FY 2016 | FY 2017 | FY 2018 | FY2019 | AVE | AVE | FY 2020 | FY 2021 | FY 2022 | FY 2023 | FY 2024 | FY 2025 | |||||||||||
| Qty | Hours | Qty | Hours | Qty | Hours | Qty | Hours | Qty | Hours | Qty | Hours | Qty | Hours | Qty | Hours | Qty | Hours | Qty | Hours | Qty | Hours | Qty | Hours | ||
| Section 1 | |||||||||||||||||||||||||
| ARMY STDS LAB | 5 | 10 | 4 | 10 | 3 | 8 | 2 | 8 | 0 | 0 | 3 | 9 | 3 | 9 | 3 | 9 | 3 | 9 | 3 | 9 | 3 | 9 | 3 | 9 | |
| DC & LO | 2078 | 8427 | 1987 | 7876 | 1867 | 7906 | 1895 | 9021 | 2202 | 7628 | 2006 | 8268 | 1916 | 8268 | 1916 | 8268 | 1916 | 8268 | 1916 | 8268 | 1916 | 8268 | 1916 | 8268 | |
| DIMENSIONAL | 1724 | 3582 | 1772 | 4481 | 1772 | 3599 | 1385 | 3425 | 1546 | 3960 | 1640 | 3835 | 1643 | 3835 | 1643 | 3835 | 1643 | 3835 | 1643 | 3835 | 1643 | 3835 | 1643 | 3835 | |
| FIBER OPTICS | 24 | 100 | 9 | 29 | 22 | 85 | 18 | 41 | 44 | 162 | 23 | 52 | 16 | 52 | 16 | 52 | 16 | 52 | 16 | 52 | 16 | 52 | 16 | 52 | |
| FLOW | 965 | 2797 | 752 | 2078 | 724 | 2569 | 776 | 2626 | 596 | 2201 | 763 | 2424 | 751 | 2424 | 751 | 2424 | 751 | 2424 | 751 | 2424 | 751 | 2424 | 751 | 2424 | |
| FMS items sent out | 241 | 34 | 316 | 43 | 423 | 54 | 427 | 74 | 376 | 60 | 357 | 57 | 389 | 57 | 389 | 57 | 389 | 57 | 389 | 57 | 389 | 57 | 389 | 57 | |
| FORCE | 782 | 1110 | 511 | 1014 | 504 | 1412 | 615 | 2239 | 561 | 2169 | 595 | 1555 | 543 | 1555 | 543 | 1555 | 543 | 1555 | 543 | 1555 | 543 | 1555 | 543 | 1555 | |
| GAGE BLOCKS | 138 | 5172 | 125 | 3937 | 133 | 4161 | 140 | 4854 | 137 | 4365 | 135 | 4317 | 133 | 4317 | 133 | 4317 | 133 | 4317 | 133 | 4317 | 133 | 4317 | 133 | 4317 | |
| INFRARED | 257 | 1730 | 373 | 2406 | 377 | 2753 | 368 | 2589 | 469 | 2864 | 369 | 2583 | 373 | 2583 | 373 | 2583 | 373 | 2583 | 373 | 2583 | 373 | 2583 | 373 | 2583 | |
| LASER | 452 | 2588 | 324 | 2117 | 359 | 2773 | 281 | 2632 | 280 | 2506 | 339 | 2507 | 321 | 2507 | 321 | 2507 | 321 | 2507 | 321 | 2507 | 321 | 2507 | 321 | 2507 | |
| MASS | 259 | 2312 | 206 | 1940 | 207 | 2236 | 193 | 1938 | 197 | 1830 | 212 | 2038 | 202 | 2038 | 202 | 2038 | 202 | 2038 | 202 | 2038 | 202 | 2038 | 202 | 2038 | |
| NIST | 52 | 199 | 58 | 236 | 74 | 251 | 72 | 338 | 43 | 257 | 60 | 275 | 68 | 275 | 68 | 275 | 68 | 275 | 68 | 275 | 68 | 275 | 68 | 275 | |
| NOTE 64 | 2686 | 428 | 2677 | 5046 |
1133140693C: 1133140693C:
hours taken from A010 2610 5211 1133140693C: 1133140693C:
hours from A010 2473 6088 1133140693C: 1133140693C:
| hours from A010 include N64 DMAG | 2654 | 555 | 2620 | 5448 | 2587 | 5448 | 2587 | 5448 | 2587 | 5448 | 2587 | 5448 | 2587 | 5448 | 2587 | 5448 | ||||||||||
| OPTICS | 832 | 5489 | 719 | 4609 | 775 | 4566 | 816 | 4837 | 839 | 4882 | 796 | 4671 | 770 | 4671 | 770 | 4671 | 770 | 4671 | 770 | 4671 | 770 | 4671 | 770 | 4671 | ||
| PHOTOMETRIC | 299 | 1260 | 341 | 1408 | 293 | 1201 | 290 | 1163 | 288 | 1224 | 302 | 1257 | 308 | 1257 | 308 | 1257 | 308 | 1257 | 308 | 1257 | 308 | 1257 | 308 | 1257 | ||
| PRESSURE | 353 | 1669 | 321 | 1422 | 333 | 1464 | 314 | 1604 | 296 | 1152 | 323 | 1496 | 323 | 1496 | 323 | 1496 | 323 | 1496 | 323 | 1496 | 323 | 1496 | 323 | 1496 | ||
| RADIAC | 12349 | 6940 | 11917 | 6539 | 11089 | 6471 | 10608 | 6072 | 10224 | 6320 | 11237 | 6361 | 11205 | 6361 | 11205 | 6361 | 11205 | 6361 | 11205 | 6361 | 11205 | 6361 | 11205 | 6361 | ||
| RF & MICROWAVE | 2285 | 5836 | 2591 | 6046 | 2331 | 6376 | 2082 | 6042 | 2078 | 6473 | 2273 | 6155 | 2335 | 6155 | 2335 | 6155 | 2335 | 6155 | 2335 | 6155 | 2335 | 6155 | 2335 | 6155 | ||
| SOUND | 92 | 507 | 68 | 318 | 73 | 285 | 49 | 201 | 79 | 280 | 72 | 268 | 63 | 268 | 63 | 268 | 63 | 268 | 63 | 268 | 63 | 268 | 63 | 268 | ||
| TEMP | 282 | 1556 | 270 | 1552 | 300 | 1659 | 287 | 1595 | 255 | 1723 | 279 | 1602 | 286 | 1602 | 286 | 1602 | 286 | 1602 | 286 | 1602 | 286 | 1602 | 286 | 1602 | ||
| VACUUM | 320 | 1506 | 376 | 1682 | 310 | 1414 | 394 | 1866 | 291 | 1233 | 338 | 1654 | 360 | 1654 | 360 | 1654 | 360 | 1654 | 360 | 1654 | 360 | 1654 | 360 | 1654 | ||
| VIBRATION | 114 | 199 | 341 | 683 | 245 | 749 | 252 | 681 | 258 | 729 | 242 | 704 | 279 | 704 | 279 | 704 | 279 | 704 | 279 | 704 | 279 | 704 | 279 | 704 | ||
| Total Laboratory | 26589 | 53451 | 26058 | 55469 | 24824 | 57203 | 23737 | 59933 | 23713 | 52573 | 24984 | 57535 | 24873 | 57535 | 24873 | 57535 | 24873 | 57535 | 24873 | 57535 | 24873 | 57535 | 24873 | 57535 |
| Section 2 | |||||||||||||||||||||||||
| FMS | 1355 | 3175 | 1270 | 2552 | 1361 | 2452 | 1332 | 2778 | 1558 | 3346 | 1375 | 4767 | 1321 | 2594 | 1321 | 2594 | 1321 | 2594 | 1321 | 2594 | 1321 | 2594 | 1321 | 2594 | |
| SPECIAL - NIST/ARMY | NIST | 52 | 199 | 58 | 236.2 | 74 | 251 | 72 | 338 | 43 | 257 | 60 | 427 | 68 | 275 | 68 | 275 | 68 | 275 | 68 | 275 | 68 | 275 | 68 | 275 |
| SPECIAL - AFMETCAL | Note 64 | 2686 | 428 | 2677 | 5046 | 2610 | 5211 | 2473 | 6088 | 2654 | 555 | 2620 | 5776 | 2587 | 5448 | 2587 | 5448 | 2587 | 5448 | 2587 | 5448 | 2587 | 5448 | 2587 | 5448 |
| SPECIAL - ACCEPTANCE | ACCEPT | 575 | 1991 | 342 | 1249 | 171 | 1749 | 161 | 1765 | 348 | 1740 | 319 | 2831 | 225 | 1588 | 225 | 1588 | 225 | 1588 | 225 | 1588 | 225 | 1588 | 225 | 1588 |
| SPECIAL - PROJECT PLAN | MISC | 16 | 2609 | 5 | 520 | 10 | 1060 | 6 | 1396 | 10 | 1396 | 10 | 1396 | 10 | 1396 | 10 | 1396 | 10 | 1396 | 10 | 1396 |
| Section 3 | |||||||||||||||||||||||||
| New Technical Order | NEW | 75 | 6750 | 58 | 5220 | 56 | 5040 | 72 | 6480 | 75 | 6750 | 67 | 6048 | 67 | 6750 | 67 | 6750 | 67 | 6750 | 67 | 6750 | 67 | 6750 | 67 | 6750 |
| Rewrite Tech Order | REWRITE | 13 | 780 | 7 | 420 | 4 | 240 | 2 | 120 | 0 | 0 | 5 | 312 | 5 | 312 | 5 | 312 | 5 | 312 | 5 | 312 | 5 | 312 | 5 | 312 |
| Revise Tech Order | REVISE | 1155 | 17325 | 1011 | 15165 | 1048 | 15720 | 1060 | 15900 | 773 | 11595 | 1009 | 15141 | 1009 | 15141 | 1009 | 15141 | 1009 | 15141 | 1009 | 15141 | 1009 | 15141 | 1009 | 15141 |
| IOS / ISS | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Total Tech Order | 1243 | 24855 | 1076 | 20805 | 1108 | 21000 | 1134 | 22500 | 848 | 18345 | 1082 | 21501 | 1082 | 21501 | 1082 | 21501 | 1082 | 21501 | 1082 | 21501 | 1082 | 21501 | 1082 | 21501 |
* All "SPECIAL" categories in Section 2 are already distributed in the appropriate laboratory areas in Section 1.
&"Arial,Bold"&14Official Government use only
File details come from the government source that posted it. Updated .