Attachment_2_-_RFP_Amendment_0002_IDIQ_Pricing_Sheet.xlsx
XLSX spreadsheet 21 KB Posted
- Attached to
- Air Force Geospatial Support Services Federal contract opportunity
- Solicitation number
- FA4452-17-R-0021
About this file
This document contains an amendment to an IDIQ pricing sheet for geospatial support services. The amendment provides updated instructions for offerors to complete the pricing model spreadsheet. Offerors must fill in their company name and CAGE code. They must then provide proposed labor category titles that correspond to the government's labor categories and skill levels. Rates must be entered for on-site and off-site labor for the base period and four ordering periods, including projected rate escalation. Contingency rates are also required. The pricing sheet calculates totals automatically. Offerors are requested to review the information for accuracy.
Attachment 2 - IDIQ Pricing Sheet - Amendment 0002
View the file
Other files for this federal contract opportunity
Show all 49
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
Pricing Instructions
FA4452-17-R-0021
Attachment 2
ATTACHMENT 2:
PRICING WORKSHEET INSTRUCTIONS
TABLE OF CONTENTS
| PART 1: PRICING MODEL SPREADSHEET.......................................... 3 |
| A. EXCEL FILE OVERVIEW............................................................. 3 |
| B. WORKSHEET NOTES .................................................................. 3 |
| C. WORKSHEET INSTRUCTIONS .................................................. 3 |
PART I: PRICING MODEL SPREADSHEET
Each Offeror will use the attached Microsoft Excel file titled “Pricing Sheet” to fill in their proposed Labor Category Title, Government On-Site and Off-Site fully burdened labor rates for the Government’s labor category skill matrix. Pricing shall be provided for the Base Period and all Ordering Periods. Proposed ordering period pricing and rates shall include projected rate escalation for those years. Contingency rates shall be included for the Base Period and all Ordering Periods.
A. EXCEL FILE OVERVIEW
The Excel file consists of one combined worksheet titled “Pricing Sheet” which includes the Ordering Periods as follows:
| Base Ordering Period | (1 Jan 18 – 30 Nov 18) |
| Ordering Period 1 | (1 Dec 18 – 30 Nov 19) |
| Ordering Period 2 | (1 Dec 19 – 30 Nov 20) |
| Ordering Period 3 | (1 Dec 20 – 30 Nov 21) |
| Ordering Period 4 | (1 Dec 21 – 30 Nov 22) |
Contingency
B. WORKSHEET NOTES
The worksheet contains the following information:
| Column Heading | Description | |
| Company Name | To be entered in by Offeror. | |
| Cage Code | To be entered in by Offeror. | |
| Gov’t Labor Category Title | See Attachment 4 definitions. | |
| Contractor Labor Category Title | To be entered in by Offeror. | |
| Skill Level | See Attachment 4 definitions. | |
| Rate Period | Contract Period of Performance. | |
| Gov’t On-Site Rate | To be entered in by Offeror. | |
| Gov’t Off-Site Rate | To be entered in by Offeror. | |
| Total Labor | Equals ‘On-Site Total’ and ‘Off-Site Total’. |
C. WORKSHEET INSTRUCTIONS
1. In the worksheet titled “Pricing Sheet”, fill-in your company name in cell A1.
2. In the worksheet titled “Pricing Sheet”, fill-in your company Cage Code in cell A2.
3. Enter in your company's proposed ‘Labor Category Title’ for each proposed person.
4. Enter in your company’s proposed ‘Gov’t On-site’ labor rates for each ‘Labor Category Title’ under Column D rows 7 through 67. Government On-Site labor value totals under Column D will automatically be calculated for each row. In Column D row 68, a total ‘On-Site Total’ value will be calculated for rows 7 through 67.
5. Enter in your company’s proposed ‘Off-Site’ labor rates for each ‘Labor Category Title’ under Column E rows 7 through 67. Off-Site labor value totals under Column E will automatically be calculated for each row. In Column E row 68, a total ‘Off-Site Total’ value will be calculated for rows 7 through 67.
6. Repeat the above steps for Ordering Periods 1 through 4 and Surge/Contingency in Columns F through O.
7. Offerors are requested to review and verify their information.
Pricing Sheet
| Company Name: |
| Cage Code: |
Base Ordering Period: 17 Nov 17 - 16 Nov 18 Base Period Contingency: Ordering Period 1: 17 Nov 18 - 16 Nov 19 Ordering Period 1 Contingency: Ordering Period 2: 17 Nov 19 - 16 Nov 20 Ordering Period 2 Contingency: Ordering Period 3: 17 Nov 20 - 16 Nov 21 Ordering Period 3 Contingency: Ordering Period 4: 17 Nov 21 - 16 Nov 22 Ordering Period 4 Contingency:
| Government Labor Category Title | Contractor Labor Category Title | Skill Level | Government On-Site | Government Off-Site | Government On-Site | Government Off-Site | Government On-Site | Government Off-Site | Government On-Site | Government Off-Site | Government On-Site | Government Off-Site | Government On-Site | Government Off-Site | Government On-Site | Government Off-Site | Government On-Site | Government Off-Site | Government On-Site | Government Off-Site | Government On-Site | Government Off-Site |
| Geospatial/GIS Technician 1 | Entry Level | |||||||||||||||||||||
| Geospatial/GIS Technician 2 | Mid Level | |||||||||||||||||||||
| Geospatial/GIS Analyst 1 | Mid Level | |||||||||||||||||||||
| Geospatial/GIS Analyst 2 | Senior Level | |||||||||||||||||||||
| Geospatial/GIS Analyst 3 | Master Level | |||||||||||||||||||||
| Geospatial/GIS Developer 1 | Mid Level | |||||||||||||||||||||
| Geospatial/GIS Developer 2 | Senior Level | |||||||||||||||||||||
| Geospatial/GIS Developer 3 | Master Level | |||||||||||||||||||||
| Geospatial Data Architect | Senior/Master Level | |||||||||||||||||||||
| Land Surveyor 1 | Entry Level | |||||||||||||||||||||
| Land Surveyor 2 | Mid Level | |||||||||||||||||||||
| Land Surveyor 3 | Senior Level | |||||||||||||||||||||
| Photogrammetrist 1 | Entry Level | |||||||||||||||||||||
| Photogrammetrist 2 | Mid Level | |||||||||||||||||||||
| Photogrammetrist 3 | Senior Level | |||||||||||||||||||||
| Imagery Analyst 1 | Entry Level | |||||||||||||||||||||
| Imagery Analyst 2 | Mid Level | |||||||||||||||||||||
| Imagery Analyst 3 | Senior Level | |||||||||||||||||||||
| Geospatial Engineer 1 | Entry Level | |||||||||||||||||||||
| Geospatial Engineer 2 | Mid Level | |||||||||||||||||||||
| Geospatial Engineer 3 | Senior Level | |||||||||||||||||||||
| Geospatial Engineer 4 | Master Level | |||||||||||||||||||||
| GIS Project Manager or Geospatial Program Manager | Senior Level | |||||||||||||||||||||
| Geospatial Strategic Consultant | Master Level | |||||||||||||||||||||
| Business Analyst 1 | Mid Level | |||||||||||||||||||||
| Business Analyst 2 | Senior Level | |||||||||||||||||||||
| Business Analyst 3 | Master Level | |||||||||||||||||||||
| Information Technology (IT) Technician 1 | Entry Level | |||||||||||||||||||||
| Information Technology (IT) Technician 2 | Mid Level | |||||||||||||||||||||
| Information Technology (IT) Technician 3 | Mid Level or Higher | |||||||||||||||||||||
| System Administrator 1 | Entry Level | |||||||||||||||||||||
| System Administrator 2 | Mid Level | |||||||||||||||||||||
| System Administrator 3 | Senior Level | |||||||||||||||||||||
| Database Administrator 1 | Entry Level | |||||||||||||||||||||
| Database Administrator 2 | Mid Level | |||||||||||||||||||||
| Database Administrator 3 | Senior Level | |||||||||||||||||||||
| Website/Web Developer | Mid Level | |||||||||||||||||||||
| Software/Web Application Developer | Senior Level | |||||||||||||||||||||
| Website/Web-Based Application Administrator | Mid Level | |||||||||||||||||||||
| Information Assurance/Security Specialist 1 | Mid Level | |||||||||||||||||||||
| Information Assurance/Security Specialist 2 | Senior Level | |||||||||||||||||||||
| IT Portfolio Management Specialist 1 | Mid Level | |||||||||||||||||||||
| IT Portfolio Management Specialist 2 | Senior Level | |||||||||||||||||||||
| Technical/System/IT Architect | Senior Level | |||||||||||||||||||||
| Enterprise Architect | Master Level | |||||||||||||||||||||
| Communications Specialist 1 | Entry Level | |||||||||||||||||||||
| Communications Specialist 2 | Mid Level | |||||||||||||||||||||
| Communications Specialist 3 | Senior Level | |||||||||||||||||||||
| Event Coordinator 1 | Entry Level | |||||||||||||||||||||
| Event Coordinator 2 | Mid Level | |||||||||||||||||||||
| Event Coordinator 3 | Senior Level | |||||||||||||||||||||
| Graphic/Web Designer 1 | Entry Level | |||||||||||||||||||||
| Graphic/Web Designer 2 | Mid Level | |||||||||||||||||||||
| Instructor 1 | Entry Level | |||||||||||||||||||||
| Instructor 2 | Mid Level | |||||||||||||||||||||
| Instructor 3 | Senior Level | |||||||||||||||||||||
| Technical Writer | Mid Level | |||||||||||||||||||||
| Operations Manager | Senior Level | |||||||||||||||||||||
| Contract Project Manager 1 | Mid Level | |||||||||||||||||||||
| Contract Project Manager 2 | Senior Level | |||||||||||||||||||||
| Contract Program Manager | Master Level | |||||||||||||||||||||
| Summary Total | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
&"-,Bold"RFP FA4452-17-R-0021 Attachment 2 IDIQ Pricing Sheet &"-,Bold"Amendment 0002
File details come from the government source that posted it. Updated .