The file's text, extracted by GovTribe without its formatting.
Sheet1
| HPASS PRICING MODEL | | | | | | | | | | | | | | | | | | |
| Offeror Input | | | | | | | | | | OUT YEARS | | | | | | | |
| Provided NTE | | | A | B | C = A*B | D | E | F = D + E $ | G = (F*A) | H | I | J | K | (G,H,I,J,K) | | | |
| CLIN | Location | PWS Sub-Section | Hours Per Year | Base Year Rate (No Loads/No Profit) | Base Year Labor Amount (No Loads/No Profit) | Base Year Labor Rate Fully Burdened Less Profit | Proposed Profit % | Fully Burdened Base Year Rate Plus Profit Price | Total Proposed Base Year Price | Total Proposed Option Y1 $ Price | Total Proposed Option Y2 $ Price | Total Proposed Option Y3 $ Price | Total Proposed Option Y4 $ Price | Proposed Price (Base Year, Options 1-4) | Total FTE Hours - Base, Y1, Y2, Y3, Y4 | Total Proposed 6 Month Extension Option $ Price | Total Proposed Price All Years + 6 Month Extension |
| CENTERS | | | | | | | | | | | | | | | | | | |
| Business Analysis Support | 1 | Remote | 4.4.3 | 1,920 | $ - 0 | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 9,600 | $ - 0 | $ - 0 |
| Admin and Meeting Sppt | 2 | Lorton, VA | 4.7.1.2 | 1,920 | $ - 0 | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 9,600 | $ - 0 | $ - 0 |
| CENTERS Travel NTE | 3 | | | | | | | | | $ 8,817 | $ 9,082 | $ 9,354 | $ 9,635 | $ 9,924 | $ 46,812 | 0 | $ 4,962 | $ 51,774 |
| CENTERS Materials & ODC NTE | 4 | | | | | | | | | $ | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 0 | $ - 0 | $ - 0 |
| TOTAL CENTERS | | | | 3,840 | | $ - 0 | | | | $ 8,817 | $ 9,082 | $ 9,354 | $ 9,635 | $ 9,924 | $ 46,812 | 19,200 | $ 4,962 | $ 51,774 |
| CREATE | | | | | | | | | | | | | | | | | | |
| Program Analysis | 5 | Remote | 4.2.1.7 | 1,920 | $ - 0 | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 9,600 | $ - 0 | $ - 0 |
| Business Analysis Support | 5 | Carderock, MD | 4.4.7 | 1,920 | $ - 0 | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 9,600 | $ - 0 | $ - 0 |
| Business Analysis Support | 5 | Lorton, VA | 4.4.7 | 1,920 | $ - 0 | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 9,600 | $ - 0 | $ - 0 |
| Total CLIN 5 | | | | 5,760 | | $ - 0 | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 28,800 | $ - 0 | $ - 0 |
| Admin and Meeting Sppt | 6 | Lorton, VA | 4.7.1.6.1 | 1,920 | $ - 0 | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 9,600 | $ - 0 | $ - 0 |
| Admin and Meeting Sppt | 6 | Patuxent River, MD | 4.7.1.6.2 | 1,920 | $ - 0 | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 9,600 | $ - 0 | $ - 0 |
| Total CLIN 6 | | | | 3,840 | | $ - 0 | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 19,200 | $ - 0 | $ - 0 |
| CREATE Travel NTE | 7 | | | | | | | | | $ 21,945 | $ 22,603 | $ 23,281 | $ 23,980 | $ 24,699 | $ 116,508 | 0 | $ 12,350 | $ 128,858 |
| CREATE Materials & ODC NTE | 8 | | | | | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 0 | $ - 0 | $ - 0 |
| TOTAL CREATE | | | | 9,600 | | $ - 0 | | | | $ 21,945 | $ 22,603 | $ 23,281 | $ 23,980 | $ 24,699 | $ 116,508 | 48,000 | $ 12,350 | $ 128,858 |
| DREN | | | | | | | | | | | | | | | | | | |
| Program Analysis | 9 | Lorton, VA | 4.2.3.3 | 1,920 | $ - 0 | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 9,600 | $ - 0 | $ - 0 |
| Program Analysis | 9 | Remote | 4.2.3.1 | 1,920 | $ - 0 | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 9,600 | $ - 0 | $ - 0 |
| Program Analysis | 9 | Remote | 4.2.3.2 | 1,920 | $ - 0 | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 9,600 | $ - 0 | $ - 0 |
| Business Analysis Support | 9 | Lorton, VA | 4.4.5.1 | 1,920 | $ - 0 | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 9,600 | $ - 0 | $ - 0 |
| Business Analysis Support | 9 | Remote | 4.4.5.2 | 1,920 | $ - 0 | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 9,600 | $ - 0 | $ - 0 |
| Total CLIN 9 | | | | 9,600 | | $ - 0 | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 48,000 | $ - 0 | $ - 0 |
| Admin and Meeting Sppt | 10 | Lorton, VA | 4.7.1.3 | 1,920 | $ - 0 | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 9,600 | $ - 0 | $ - 0 |
| DREN Travel NTE | 11 | | | | | | | | | $ 13,508 | $ 13,913 | $ 14,330 | $ 14,760 | $ 15,203 | $ 71,714 | 0 | $ 7,602 | $ 79,316 |
| DREN Materials & ODC NTE | 12 | | | | | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 0 | $ - 0 | $ - 0 |
| TOTAL DREN | | | | 11,520 | | $ - 0 | | | | $ 13,508 | $ 13,913 | $ 14,330 | $ 14,760 | $ 15,203 | $ 71,714 | 57,600 | $ 7,602 | $ 79,316 |
| P&P | | | | | | | | | | | | | | | | | | |
| Program Analysis | 13 | Lorton, VA | 4.2.1 | 1,920 | $ - 0 | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 9,600 | $ - 0 | $ - 0 |
| Program Analysis | 13 | Remote | 4.2.2.8 | 960 | $ - 0 | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 4,800 | $ - 0 | $ - 0 |
| Marketing Team | 13 | Lorton, VA | 4.2.2.1 | 1,920 | $ - 0 | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 9,600 | $ - 0 | $ - 0 |
| Marketing Team | 13 | Lorton, VA | 4.2.2.2 | 1,920 | $ - 0 | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 9,600 | $ - 0 | $ - 0 |
| Marketing Team | 13 | Lorton, VA | 4.2.2.3 | 1,920 | $ - 0 | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 9,600 | $ - 0 | $ - 0 |
| Marketing Team | 13 | Lorton, VA | 4.2.2.4 | 1,920 | $ - 0 | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 9,600 | $ - 0 | $ - 0 |
| Business Analysis Support | 13 | Lorton, VA | 4.4.4 | 480 | $ - 0 | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 2,400 | $ - 0 | $ - 0 |
| Total CLIN 13 | | | | 11,040 | | $ - 0 | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 55,200 | $ - 0 | $ - 0 |
| Admin and Meeting Sppt | 14 | Lorton, VA | 4.7.1.5 | 640 | $ - 0 | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 3,200 | $ - 0 | $ - 0 |
| P&P Travel NTE | 15 | | | | | | | | | $ 22,971 | $ 23,660 | $ 24,370 | $ 25,101 | $ 25,854 | $ 121,956 | 0 | $ 12,927 | $ 134,883 |
| P&P Materials & ODC NTE | 16 | | | | | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 0 | $ - 0 | $ - 0 |
| TOTAL P&P | | | | 11,680 | | $ - 0 | | | | $ 22,971 | $ 23,660 | $ 24,370 | $ 25,101 | $ 25,854 | $ 121,956 | 58,400 | $ 12,927 | $ 134,883 |
| PM&A | | | | | | | | | | | | | | | | | | |
| Program and Project Mgmt. | 17 | Lorton, VA | 4.1 | 1,920 | $ - 0 | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 9,600 | $ - 0 | $ - 0 |
| Program and Project Mgmt. | 17 | Lorton, VA | 4.1 | 1,920 | $ - 0 | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 9,600 | $ - 0 | $ - 0 |
| Business Analysis Support | 17 | Remote | 4.4.2.2 | 960 | $ - 0 | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 4,800 | $ - 0 | $ - 0 |
| Business Analysis Support | 17 | Vicksburg, MS | 4.4.2.1 | 1,920 | $ - 0 | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 9,600 | $ - 0 | $ - 0 |
| Business Analysis Support | 17 | Vicksburg, MS | 4.2.2.3 | 1,920 | $ - 0 | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 9,600 | $ - 0 | $ - 0 |
| Total CLIN 17 | | | | 8,640 | | $ - 0 | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 43,200 | $ - 0 | $ - 0 |
| Admin and Meeting Sppt | 18 | Lorton, VA | 4.7.1.1 | 1,920 | $ - 0 | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 9,600 | $ - 0 | $ - 0 |
| Admin and Meeting Sppt | 18 | Lorton, VA | 4.7.3.1 | 1,920 | $ - 0 | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 9,600 | $ - 0 | $ - 0 |
| Admin and Meeting Sppt | 18 | Lorton, VA | 4.7.3.2 | 1,920 | $ - 0 | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 9,600 | $ - 0 | $ - 0 |
| Admin and Meeting Sppt | 18 | Lorton, VA | 4.7.4 | 1,920 | $ - 0 | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 9,600 | $ - 0 | $ - 0 |
| Total CLIN 18 | | | | 7,680 | | $ - 0 | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 38,400 | $ - 0 | $ - 0 |
| PM&A Travel NTE | 19 | | | | | | | | | $ 7,432 | $ 7,655 | $ 7,885 | $ 8,121 | $ 8,365 | $ 39,458 | 0 | $ 4,183 | $ 43,641 |
| PM&A Materials & ODC NTE | 20 | | | | | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 0 | $ - 0 | $ - 0 |
| TOTAL PM&A | | | | 16,320 | | $ - 0 | | | | $ 7,432 | $ 7,655 | $ 7,885 | $ 8,121 | $ 8,365 | $ 39,458 | 81,600 | $ 4,183 | $ 43,641 |
| RM | | | | | | | | | | | | | | | | | | |
| Requirements/Data Analysis | 21 | Lorton, VA | 4.3.1 | 1,920 | $ - 0 | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 9,600 | $ - 0 | $ - 0 |
| Requirements/Data Analysis | 21 | Lorton, VA | 4.3.3 | 1,920 | $ - 0 | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 9,600 | $ - 0 | $ - 0 |
| Requirements/Data Analysis | 21 | Remote | 4.3.2 | 1,920 | $ - 0 | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 9,600 | $ - 0 | $ - 0 |
| Total CLIN 21 | | | | 5,760 | | $ - 0 | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 28,800 | $ - 0 | $ - 0 |
| Admin and Meeting Sppt | 22 | Lorton, VA | 4.7.1.5 | 640 | $ - 0 | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 3,200 | $ - 0 | $ - 0 |
| RM Travel NTE | 23 | | | | | | | | | $ 10,363 | $ 10,674 | $ 10,994 | $ 11,324 | $ 11,664 | $ 55,019 | 0 | $ 5,832 | $ 60,851 |
| RM Materials & ODC NTE | 24 | | | | | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 0 | $ - 0 | $ - 0 |
| TOTAL PM&A | | | | 6,400 | | $ - 0 | | | | $ 10,363 | $ 10,674 | $ 10,994 | $ 11,324 | $ 11,664 | $ 55,019 | 32,000 | $ 5,832 | $ 60,851 |
| SAS | | | | | | | | | | | | | | | | | | |
| Business Analysis Support | 25 | Lorton, VA | 4.4.8 | 1,440 | $ - 0 | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 7,200 | $ - 0 | $ - 0 |
| Admin and Meeting Sppt | 26 | Lorton, VA | 4.7.1.5 | 640 | $ - 0 | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 3,200 | $ - 0 | $ - 0 |
| SAS Travel NTE | 27 | | | | | | | | | $ 3,398 | $ 3,500 | $ 3,605 | $ 3,713 | $ 3,825 | $ 18,041 | 0 | $ 1,913 | $ 19,954 |
| SAS Materials & ODC NTE | 28 | | | | | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 0 | $ - 0 | $ - 0 |
| TOTAL SAS | | | | 2,080 | | $ - 0 | | | | $ 3,398 | $ 3,500 | $ 3,605 | $ 3,713 | $ 3,825 | $ 18,041 | 10,400 | $ 1,913 | $ 19,954 |
| SECURITY | | | | | | | | | | | | | | | | | | |
| Business Analysis Support | 29 | Lorton, VA | 4.4.6 | 1,920 | $ - 0 | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 9,600 | $ - 0 | $ - 0 |
| Security Support | 29 | Lorton, VA | 4.6.2 | 1,920 | $ - 0 | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 9,600 | $ - 0 | $ - 0 |
| Security Support | 29 | Lorton, VA | 4.6.2 | 1,920 | $ - 0 | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 9,600 | $ - 0 | $ - 0 |
| Total CLIN 29 | | | | 5,760 | | $ - 0 | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 28,800 | $ - 0 | $ - 0 |
| Admin and Meeting Sppt | 30 | Lorton, VA | 4.7.1.4 | 1,920 | $ - 0 | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 9,600 | $ - 0 | $ - 0 |
| SECURITY Travel NTE | 31 | | | | | | | | | $ 5,526 | $ 5,692 | $ 5,863 | $ 6,038 | $ 6,220 | $ 29,339 | 0 | $ 3,110 | $ 32,449 |
| SECURITY Materials & ODC NTE | 32 | | | | | | | | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 0 | $ - 0 | $ - 0 |
| TOTAL SECURITY | | | | 7,680 | | $ - 0 | | | | $ 5,526 | $ 5,692 | $ 5,863 | $ 6,038 | $ 6,220 | $ 29,339 | 38,400 | $ 3,110 | $ 32,449 |
| CONTRACT COSTS | | | | | | | | | |
| CMRA | 33 | $ - 0 | | | | | $ - 0 | | $ - 0 |
| Phase In | 34 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| TOTAL CONTRACT COSTS | | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
TOTAL PROPOSED PRICE 69,120 - 0 $ 93,960 $ 96,779 $ 99,682 $ 102,672 $ 105,754 $ 498,847 345,600 $ 52,877 $ 551,724