Attachment 5A Prime Pricing Model_15R0005_rev_amd1.xlsx
XLSX spreadsheet 104 KB Posted
- Solicitation number
- N65236-15-R-0005
View the file
Other files
Show all 29
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
Directions
| GENERAL INSTRUCTIONS AND INFORMATION | |
| RFP: N65236-15-R-0005 | |
| Title: Tagging, Tracking, and Locating Equipment and Services | |
| Prime Pricing Model Version 1.1 dated 07-13-16 | |
| Contract Specialist: Adam Solivan (843) 218-3556 |
| Assumptions: | |
| 1. | The Fringe Benefit allocation base is total labor dollars. |
| 2. | The Labor Overhead allocation base is total direct labor dollars PLUS associated fringe benefit. |
| 3. | The G&A allocation base is total cost input. |
| 4. | Facilities Capital Cost of Money is not incorporated. |
| 5. | Overtime for exempt personnel is based on a total time accounting concept. (Annual salary divided by total hours worked equals the hourly rate.) |
| 6. | The Service Contract Labor Standards categories are subject to the applicable Wage Determinations for that area. |
| 7. | In accordance with 29 C.F.R. 541, Computer IT labor category rates not identified on the Wage Determination shall be paid a minimum of $27.63. |
| 8. | Fixed Fee is applied at the same percentage each year. |
| 9. | Performance is anticipated to be at the Contractor Site in Tampa, FL. |
| 10. | Danger Pay and Post Hardship Differential are included in the estimated ODCs |
| 11. | Additional ODCs are subject to G&A. |
| 12 | Resumed individuals (key personnel) will have 50% of their time dedicated to this effort (960 hours based on the assumption that 1 FTE = 1920 hours) |
| Directions: | |
| 1. | If the assumptions are valid, fill in only those cells highlighted in yellow, beginning with the company name at the top of the Summary sheet. |
| 2. | If the assumptions are not valid, modify appropriate formulas throughout the spreadsheet. Identify changes by highlighting all cells with changed formulas in YELLOW, describing the changes as well as the reasons for those changes in the space provided at the bottom of the Summary sheet. |
| 3. | If direct labor rates are calculated by using other than 2,080 hours per year, list the number of hours per year used to calculate the hourly rate for each category on the Other Labor Data sheet. |
| 4. | If company job titles are different from those in the RFP, provide this information on the Other Labor Data sheet. |
| 5. | The Labor Cost and Burdened Rates tabs of the pricing model account for resumed individuals (key personnel), with 960 hours being assigned (50% of an FTE). If an offeror's FTE differs from the assumed 1920 hours, offerors shall insert hours equal to at least 50% of their proposed FTE for resumed individuals, and the delta shall be accounted for in the hours (same labor category) not specifically assigned to a proposed individual. |
| 6. | Offerors may propose resumed individuals with more than 50% of their time dedicated to this effort. The delta shall be accounted for by subtracting hours (same labor category) not specifically assigned to a proposed individual. |
| 7. | Offerors shall include the name of all proposed individuals on the applicable rows. In addition, offerors shall revise the pricing model in order to properly account for any additional proposed individuals. |
| 8. | Average unloaded direct labor rates may be submitted for all remaining labor categories/hours (not assigned to a proposed individual). |
| 9. | The estimated cost of the TTL equipment to be procured under this contract is provided as a plug number in the Summary Tab. Offerors shall not revise |
| this amount. | |
| 10 | For evaluation purposes, the profit rate shall equal the proposed fixed fee rate. |
| Helpful Hints and Reminders: | |
| 1. | Notify the contract negotiator if you have any questions or problems relating to this pricing model. |
| 2. | Use the checklist provided below to ensure your proposal is complete. |
| Pricing Model Checklist | |
| √ | Have the following been completed? |
| Your company name is entered on the Summary Sheet. | |
| Year 1 direct labor rates are entered on the Loaded Rates sheet. | |
| If your rates/categories differ from the model, the differences are explained on the Other Labor Data sheet. | |
| Indirect rates are provided on the Summary sheet for each year. | |
| Allocation base information is provided in the indirect rate section at the bottom of the Summary sheet. | |
| If the pricing model formulas for applying the indirect rates are not consistent with your company accounting practices, | |
| the appropriate formulas have been modified, | |
| the changed cells are highlighted in yellow, and | |
| the changes are explained at the bottom of the Summary sheet. | |
| Subcontractor names are provided on the Team Hours sheet. | |
| Hours assigned to each subcontractor are shown on the Team Hours sheet. | |
| Subcontractor names are on the Summary sheet, in the same order they appear on the Team Hours sheet. | |
| Subcontractor pricing models were prepared and sent to the proposed subcontractors for completion. | |
| The subcontractors' proposed costs for each year (based on the subs' responses) are entered on the Summary sheet. | |
| Proposed Additional ODCs for both the prime contractor and subcontractors are included on the Summary sheet. | |
| Benefits Summary and Salary sheets are completed if providing 18,800 hours or more of professional labor per year. |
&"Times New Roman,Regular"&F &"Times New Roman,Regular"&A &"Times New Roman,Regular"&P of &N
Summary
| RFP: N65236-15-R-0005 | |||||||
| Title: Tagging, Tracking, and Locating Equipment and Services | |||||||
| Contractor's Name: | |||||||
| Labor | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Total | % of Hours |
| Prime Labor Cost | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |
| Labor Hours | 173,309 | 173,309 | 173,309 | 173,309 | 173,309 | 866,545 | 100.00% |
Fringe Benefits 0.00 0.00 0.00 0.00 0.00 0.00
Overhead - Contractor Site - Tampa, FL 0.00 0.00 0.00 0.00 0.00 0.00
| Subcontractor Labor Costs | |||||||
| Subcontractor # 1 Name | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |
| Sub # 1 Labor Hours | 0 | 0 | 0 | 0 | 0 | 0 | 0.00% |
| Subcontractor # 2 Name | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |
| Sub # 2 Labor Hours | 0 | 0 | 0 | 0 | 0 | 0 | 0.00% |
| Subcontractor # 3 Name | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |
| Sub # 3 Labor Hours | 0 | 0 | 0 | 0 | 0 | 0 | 0.00% |
| Subcontractor # 4 Name | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |
| Sub # 4 Labor Hours | 0 | 0 | 0 | 0 | 0 | 0 | 0.00% |
| Total Subcontractor Labor | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |
| Total Combined Labor Costs (Less G&A) | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| ODCs | ||||||
| Travel | 709,904.00 | 731,201.12 | 753,137.15 | 775,731.26 | 799,003.20 | 3,768,976.73 |
| Material/Equip/Transportation | 202,686.00 | 208,766.58 | 215,029.58 | 221,480.47 | 228,124.88 | 1,076,087.51 |
| Miscellaneous Subcontractor | 125,024.00 | 128,774.72 | 132,637.96 | 136,617.10 | 140,715.61 | 663,769.39 |
| Additional ODCs (Prime) | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |
| Additional ODCs (Subs) | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |
| ODCs - Subtotal | 1,037,614.00 | 1,068,742.42 | 1,100,804.69 | 1,133,828.83 | 1,167,843.69 | 5,508,833.63 |
Total Costs (Less G&A) 1,037,614.00 1,068,742.42 1,100,804.69 1,133,828.83 1,167,843.69 5,508,833.63
G&A 0.00 0.00 0.00 0.00 0.00 0.00
| Proposed Cost, CPFF Support Services (80%) | 830,091.20 | 854,993.94 | 880,643.75 | 907,063.06 | 934,274.95 | 4,407,066.90 |
| Fixed Fee | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Total, CPFF | 830,091.20 | 854,993.94 | 880,643.75 | 907,063.06 | 934,274.95 | 4,407,066.90 |
| Proposed Cost, FFP Support Services (20%) | 207,522.80 | 213,748.48 | 220,160.94 | 226,765.77 | 233,568.74 | 1,101,766.73 |
| Profit | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Total, FFP | 207,522.80 | 213,748.48 | 220,160.94 | 226,765.77 | 233,568.74 | 1,101,766.73 |
Total Proposed Cost, Support Services 1,037,614.00 1,068,742.42 1,100,804.69 1,133,828.83 1,167,843.69 5,508,833.63
TTL Equipment Cost (FFP) 14,671,986.93 15,112,146.54 15,565,510.94 16,032,476.27 16,513,450.56 77,895,571.24
Total Cost 15,709,600.93 16,180,888.96 16,666,315.63 17,166,305.10 17,681,294.25 83,404,404.87
| Loading Factors | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Allocation Base |
| Please Fill In | ||||||
| Labor Escalation - Professional | 0.00% | 0.00% | 0.00% | 0.00% | Direct Labor - Professional | |
| Labor Escalation - SCLS | 2.00% | 2.00% | 2.00% | 2.00% | Direct Labor - SCLS | |
| Fringe Benefit | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | |
| Overhead - Contractor Site - Tampa, FL | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | |
| G&A | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | |
| Fixed Fee | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | |
| Profit | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% |
CONTRACTOR CHANGES TO THE PRICING MODEL
&"Times New Roman,Bold"&16&A&"Times New Roman,Regular"&10
| &"Times New Roman,Regular"&F &A | &"Times New Roman,Regular"Source Selection Information |
| See FAR 2.101 and 3.104 | &"Times New Roman,Regular"&P of &N |
Labor Cost
RFP: N65236-15-R-0005
| Tampa, FL | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | ||||||
| Contractor Site | Hours Per Year | Labor Rates | Labor Rates | Labor Rates | Labor Rates | Labor Rates | |||||
| Professional Categories | ST | ST | Total Cost | ST | Total Cost | ST | Total Cost | ST | Total Cost | ST | Total Cost |
| Program Manager (Resume) | 960 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Program Manager | 3,580 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Project Manager (Resume 1) | 960 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Project Manager (Resume 2) | 960 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Project Manager | 2,620 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Engineer/Scientist 3 - General | 2,785 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Engineer/Scientist 3 - Systems/Software Engineer | 2,785 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Engineer/Scientist 2 - Network Engineer | 5,570 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Management Analyst 3 (Resume 1) | 960 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Management Analyst 3 (Resume 2) | 960 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Management Analyst 3 | 11,658 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Technical Analyst 3 | 13,578 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Technical Writer/Editor 3 | 6,040 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Subject Matter Expert (SME) 5 (Resume 1) | 960 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Subject Matter Expert (SME) 5 (Resume 2) | 960 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Subject Matter Expert (SME) 5 | 17,624 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Subject Matter Expert (SME) 4 (Resume 1) | 960 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Subject Matter Expert (SME) 4 (Resume 2) | 960 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Subject Matter Expert (SME) 4 (Resume 3) | 960 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Subject Matter Expert (SME) 4 | 16,664 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Subject Matter Expert (SME) 3 (Resume 1) | 960 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Subject Matter Expert (SME) 3 (Resume 2) | 960 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Subject Matter Expert (SME) 3 (Resume 3) | 960 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Subject Matter Expert (SME) 3 | 16,664 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Management & Program Technician 3 | 19,544 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| SCA Categories | |||||||||||
| Administrative Assistant | 6,520 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Supply Technician | 640 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Computer Systems Analyst III | 11,092 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Technical Instructor | 11,092 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Technical Instructor/Course Developer (Resume 1) | 960 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Technical Instructor/Course Developer (Resume 2) | 960 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Technical Instructor/Course Developer | 9,172 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Shipping & Receiving Clerk | 640 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Warehouse Specialist | 641 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
Total Hours & Cost/YR 173,309 0.00 0.00 0.00 0.00 0.00
&"Times New Roman,Bold"&14&A
&"Times New Roman,Regular"&F
| &A | &"Times New Roman,Regular"Source Selection Information |
| See FAR 2.101 and 3.104 | &"Times New Roman,Regular"&P of &N |
Team Hours
RFP: N65236-15-R-0005
| Tampa, FL | CONTRACTOR SITE Labor Hours, Years 1 - 5 | |||||
| Total | Sub | Sub | Sub | Sub | Prime Contractor | |
| Professional Categories | ST Hours | ST | ST | ST | ST | ST |
| Program Manager (Resume) | 960 | 0 | 0 | 0 | 0 | 960 |
| Program Manager | 3,580 | 0 | 0 | 0 | 0 | 3,580 |
| Project Manager (Resume 1) | 960 | 0 | 0 | 0 | 0 | 960 |
| Project Manager (Resume 2) | 960 | 0 | 0 | 0 | 0 | 960 |
| Project Manager | 2,620 | 0 | 0 | 0 | 0 | 2,620 |
| Engineer/Scientist 3 - General | 2,785 | 0 | 0 | 0 | 0 | 2,785 |
| Engineer/Scientist 3 - Systems/Software Engineer | 2,785 | 0 | 0 | 0 | 0 | 2,785 |
| Engineer/Scientist 2 - Network Engineer | 5,570 | 0 | 0 | 0 | 0 | 5,570 |
| Management Analyst 3 (Resume 1) | 960 | 0 | 0 | 0 | 0 | 960 |
| Management Analyst 3 (Resume 2) | 960 | 0 | 0 | 0 | 0 | 960 |
| Management Analyst 3 | 11,658 | 0 | 0 | 0 | 0 | 11,658 |
| Technical Analyst 3 | 13,578 | 0 | 0 | 0 | 0 | 13,578 |
| Technical Writer/Editor 3 | 6,040 | 0 | 0 | 0 | 0 | 6,040 |
| Subject Matter Expert (SME) 5 (Resume 1) | 960 | 0 | 0 | 0 | 0 | 960 |
| Subject Matter Expert (SME) 5 (Resume 2) | 960 | 0 | 0 | 0 | 0 | 960 |
| Subject Matter Expert (SME) 5 | 17,624 | 0 | 0 | 0 | 0 | 17,624 |
| Subject Matter Expert (SME) 4 (Resume 1) | 960 | 0 | 0 | 0 | 0 | 960 |
| Subject Matter Expert (SME) 4 (Resume 2) | 960 | 0 | 0 | 0 | 0 | 960 |
| Subject Matter Expert (SME) 4 (Resume 3) | 960 | 0 | 0 | 0 | 0 | 960 |
| Subject Matter Expert (SME) 4 | 16,664 | 0 | 0 | 0 | 0 | 16,664 |
| Subject Matter Expert (SME) 3 (Resume 1) | 960 | 0 | 0 | 0 | 0 | 960 |
| Subject Matter Expert (SME) 3 (Resume 2) | 960 | 0 | 0 | 0 | 0 | 960 |
| Subject Matter Expert (SME) 3 (Resume 3) | 960 | 0 | 0 | 0 | 0 | 960 |
| Subject Matter Expert (SME) 3 | 16,664 | 0 | 0 | 0 | 0 | 16,664 |
| Management & Program Technician 3 | 19,544 | 0 | 0 | 0 | 0 | 19,544 |
| SCA Categories | ||||||
| Administrative Assistant | 6,520 | 0 | 0 | 0 | 0 | 6,520 |
| Supply Technician | 640 | 0 | 0 | 0 | 0 | 640 |
| Computer Systems Analyst III | 11,092 | 0 | 0 | 0 | 0 | 11,092 |
| Technical Instructor | 11,092 | 0 | 0 | 0 | 0 | 11,092 |
| Technical Instructor/Course Developer (Resume 1) | 960 | 0 | 0 | 0 | 0 | 960 |
| Technical Instructor/Course Developer (Resume 2) | 960 | 0 | 0 | 0 | 0 | 960 |
| Technical Instructor/Course Developer | 9,172 | 0 | 0 | 0 | 0 | 9,172 |
| Shipping & Receiving Clerk | 640 | 0 | 0 | 0 | 0 | 640 |
| Warehouse Specialist | 641 | 0 | 0 | 0 | 0 | 641 |
| Subtotal | 173,309 | 0 | 0 | 0 | 0 | 173,309 |
Total Hours per Year 173,309 0 0 0 0 173,309
Percentage of Participation 0.00% 0.00% 0.00% 0.00% 100.00%
&"Times New Roman,Bold"&14&A
&"Times New Roman,Regular"&F - &A &"Times New Roman,Regular"&P of &N &"Times New Roman,Regular"Source Selection Information - See FAR 2.101 && 3.104
Burdened Rates
| RFP: N65236-15-R-0005 | |
| Please do not delete any rows from this sheet |
| Tampa, FL | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | ||||||||||||||||||||
| Contractor Site | Labor | Fringe | OH | G&A | Total | Labor | Fringe | OH | G&A | Total | Labor | Fringe | OH | G&A | Total | Labor | Fringe | OH | G&A | Total | Labor | Fringe | OH | G&A | Total |
| Professional Categories | Rate | Cost | Cost | Cost | ST | Rate | Cost | Cost | Cost | ST | Rate | Cost | Cost | Cost | ST | Rate | Cost | Cost | Cost | ST | Rate | Cost | Cost | Cost | ST |
| Program Manager (Resume) | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Program Manager | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Project Manager (Resume 1) | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Project Manager (Resume 2) | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Project Manager | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Engineer/Scientist 3 - General | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Engineer/Scientist 3 - Systems/Software Engineer | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Engineer/Scientist 2 - Network Engineer | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Management Analyst 3 (Resume 1) | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Management Analyst 3 (Resume 2) | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Management Analyst 3 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Technical Analyst 3 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Technical Writer/Editor 3 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Subject Matter Expert (SME) 5 (Resume 1) | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Subject Matter Expert (SME) 5 (Resume 2) | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Subject Matter Expert (SME) 5 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Subject Matter Expert (SME) 4 (Resume 1) | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Subject Matter Expert (SME) 4 (Resume 2) | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Subject Matter Expert (SME) 4 (Resume 3) | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Subject Matter Expert (SME) 4 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Subject Matter Expert (SME) 3 (Resume 1) | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Subject Matter Expert (SME) 3 (Resume 2) | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Subject Matter Expert (SME) 3 (Resume 3) | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Subject Matter Expert (SME) 3 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Management & Program Technician 3 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| SCA Categories | |||||||||||||||||||||||||
| Administrative Assistant | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Supply Technician | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Computer Systems Analyst III | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Technical Instructor | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Technical Instructor/Course Developer (Resume 1) | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Technical Instructor/Course Developer (Resume 2) | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Technical Instructor/Course Developer | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Shipping & Receiving Clerk | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Warehouse Specialist | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
&"Times New Roman,Bold"&16&A
&A
| &"Times New Roman,Bold"Source Selection Information | |
| See FAR 2.101 and 3.104 | &"Times New Roman,Regular"&P of &N |
Other Labor Data
| RFP: N65236-15-R-0005 | ||||
| UNCOMPENSATED OVERTIME CALCULATION | ||||
| Note: Complete this section ONLY if proposed rates are calculated using other than 2,080 hours per year. | ||||
| Note: Complete this section ONLY if | ||||
| company job titles are different from | Year 1 Labor Rates | |||
| those specified in the RFP. | Labor | Adjusted Hourly | Effective | |
| Offeror's Labor Categories | Rate (1) | Rate (2) | Hours (3) | |
| Professional | ||||
| Program Manager (Resume) | ||||
| Program Manager | ||||
| Project Manager (Resume 1) | ||||
| Project Manager (Resume 2) | ||||
| Project Manager | ||||
| Engineer/Scientist 3 - General | ||||
| Engineer/Scientist 3 - Systems/Software Engineer | ||||
| Engineer/Scientist 2 - Network Engineer | ||||
| Management Analyst 3 (Resume 1) | ||||
| Management Analyst 3 (Resume 2) | ||||
| Management Analyst 3 | ||||
| Technical Analyst 3 | ||||
| Technical Writer/Editor 3 | ||||
| Subject Matter Expert (SME) 5 (Resume 1) | ||||
| Subject Matter Expert (SME) 5 (Resume 2) | ||||
| Subject Matter Expert (SME) 5 | ||||
| Subject Matter Expert (SME) 4 (Resume 1) | ||||
| Subject Matter Expert (SME) 4 (Resume 2) | ||||
| Subject Matter Expert (SME) 4 (Resume 3) | ||||
| Subject Matter Expert (SME) 4 | ||||
| Subject Matter Expert (SME) 3 (Resume 1) | ||||
| Subject Matter Expert (SME) 3 (Resume 2) | ||||
| Subject Matter Expert (SME) 3 (Resume 3) | ||||
| Subject Matter Expert (SME) 3 | ||||
| Management & Program Technician 3 |
(1) Labor Rate is annual salary divided by 2,080 hours.
| (2)Adjusted Hourly Rate is annual salary divided by total hours |
| recorded. |
| (3) Effective Hours are the total hours recorded, |
| including leave. |
| Was Uncompensated Overtime used to calculate the | |
| professional labor rates? (Yes/No) | |
| Uncompensated Overtime Policy |
| SCA Categories | SCA # | Offeror's Labor Categories |
| Administrative Assistant | 01020 | |
| Supply Technician | 01410 | |
| Computer Systems Analyst III | 14103 | |
| Technical Instructor | 15090 | |
| Technical Instructor/Course Developer (Resume 1) | 15095 | |
| Technical Instructor/Course Developer (Resume 2) | 15095 | |
| Technical Instructor/Course Developer | 15095 | |
| Shipping & Receiving Clerk | 21130 | |
| Warehouse Specialist | 21410 |
&"Times New Roman,Bold"&14&A
&A &"Times New Roman,Regular"Source Selection Information See FAR 2.101 and 3.104
Benefit Summary
RFP: N65236-15-R-0005
Company Name:
PROFESSIONAL EMPLOYEE COMPENSATION PLAN
INSTRUCTIONS:
| Salaries | See Attached Salary Data sheet |
| Salary Supporting Data | See Attached Salary Data sheet |
| Escalation | |
| Eligibility for Benefits | |
| Vacation | |
| Sick Leave | |
| Holidays | |
| Military Leave | |
| Jury Duty | |
| Medical Insurance | |
| Dental Care | |
| Vision Care | |
| Short Term Disability | |
| Long-Term Disability | |
| Life Insurance | |
| AD&D | |
| Retirement /Pension | |
| Education Assistance | |
| % of Salary/Fringe Rate | |
| Additional Notes: |
&"Times New Roman,Bold"&14
&"Times New Roman,Bold"&14&A
| &A | &"Times New Roman,Regular"Source Selection Information |
| See FAR 2.101 and 3.104 | &P of &N |
Salary Data
RFP: N65236-15-R-0005
| INSTRUCTIONS: | Complete this page only if you are providing 18,800 hours or more per year of professional labor. This page and the preceding Benefit Summary Chart constitute the Professional Employee Compensation Plan. | |||
| PROFESSIONAL SALARIES | SUPPORTING SALARY DATA | |||
| Labor Category | Year 1 Unloaded Rate | Year 1 Salary | Compensation Survey Name / Compensation Data Source | Survey Date |
| Program Manager (Resume) | ||||
| Program Manager | ||||
| Project Manager (Resume 1) | ||||
| Project Manager (Resume 2) | ||||
| Project Manager | ||||
| Engineer/Scientist 3 - General | ||||
| Engineer/Scientist 3 - Systems/Software Engineer | ||||
| Engineer/Scientist 2 - Network Engineer | ||||
| Management Analyst 3 (Resume 1) | ||||
| Management Analyst 3 (Resume 2) | ||||
| Management Analyst 3 | ||||
| Technical Analyst 3 | ||||
| Technical Writer/Editor 3 | ||||
| Subject Matter Expert (SME) 5 (Resume 1) | ||||
| Subject Matter Expert (SME) 5 (Resume 2) | ||||
| Subject Matter Expert (SME) 5 | ||||
| Subject Matter Expert (SME) 4 (Resume 1) | ||||
| Subject Matter Expert (SME) 4 (Resume 2) | ||||
| Subject Matter Expert (SME) 4 (Resume 3) | ||||
| Subject Matter Expert (SME) 4 | ||||
| Subject Matter Expert (SME) 3 (Resume 1) | ||||
| Subject Matter Expert (SME) 3 (Resume 2) | ||||
| Subject Matter Expert (SME) 3 (Resume 3) | ||||
| Subject Matter Expert (SME) 3 | ||||
| Management & Program Technician 3 |
Labor rates are based on hours per year
&"Times New Roman,Bold"&14&A
&A &"Times New Roman,Regular"Source Selection Information See FAR 2.101 and 3.104
Microsoft_Excel_Worksheet1.xlsx Benefits - Instructions
EMPLOYEE COMPENSATION PLAN
Salaries Provide a chart of salaries for the base year using the Salary Data spreadsheet in the pricing model. The salaries shall track back to the cost proposal submitted. Provide the number of hours per year (2,080 or other number). The compensation levels proposed should reflect a clear understanding of work to be performed and should indicate the capability to obtain and keep suitably qualified personnel to meet mission objectives. The salaries must take into account differences in skills, the complexity of various disciplines and professional job difficulty. CAUTION: Proposals envisioning compensation levels lower than those of predecessor contractors will be evaluated on the basis of maintaining program continuity, uninterrupted high quality work, and availability of required competent employees.
Salary Supporting Data Provide supporting data such as recognized national and regional compensation surveys and studies of professional, public and private organizations used in establishing the total compensation structure. It is not necessary to provide the actual survey.
Escalation Enter the proposed escalation for professional employees used for this proposal.
Eligibility for Benefits Provide either a general statement regarding eligibility for fringe benefits, or discuss with regard to each benefit. Does the benefit package apply to only the full-time employees, or are part-time employees eligible. What is the company's definition of a full-time and part-time employee?
Vacation Enter the number of vacation days per year at the various levels of years of employment. If your company uses Personal Time Off (PTO) instead, describe what that includes here.
Sick Leave Enter the number of paid sick days allowed per year.
Holidays Enter the number of paid holidays per year.
Military leave Describe the company policy, if any, regarding short term (annual training), and long term (active duty deployment) military leave. How much leave is allowed per year? Is the leave paid or unpaid?
Jury Duty Describe the company policy, if any, regarding Jury Duty. How much time is allowed per year? Is the leave paid or unpaid?
Medical Insurance Briefly describe the type of health care plans provided. Describe what portion of the premiums the company pays for employees and for dependents. If the company offers Healthcare Flexible Spending Accounts, provide that information as well.
Dental Care See guidelines for Medical Insurance above.
Vision Care See guidelines for Medical Insurance above.
Short Term Disability Describe the Short Term Disability coverage, if offered. Describe what portion of the premiums the company pays for employees and for dependents.
Long-Term Disability Describe the LongTerm Disability coverage, if offered. Describe what portion of the premiums the company pays for employees and for dependents.
Life Insurance Describe the Life Insurance coverage. Describe the portion of the premiums the company pays for employees, and any optional additional coverage available.
AD&D Describe the Accidental Death & Dismemberment coverage, if offered. Describe the portion of the premiums paid by the company.
Retirement /Pension Describe any 401(k) , pensions, or Profit Sharing . Who is eligible to participate? What is the company contribution and what is the vesting period?
Educational Assistance Describe the company policy on educational assistance. What expenses are reimbursed? What is the average amount per employee per year?
% of Salary What is the company fringe benefit rate? If there is no separate fringe rate, what portion of the overhead is fringe benefits?
Additional Notes: Describe any additional benefits you feel are significant.
Prepared by: Jean Duncan Revised 7-29-11 image2.emf
File details come from the government source that posted it.