Pricing Spreadsheet ID04200073 08 13 2020.xlsx
XLSX spreadsheet 20 KB Posted
- Attached to
- Benefits Methods Development and Other Relevant Analyses for the Evaluation of Air Pollution Control Policies Federal contract opportunity
- Solicitation number
- ID04200073
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| Questions and Answers Final ID04200073 10 22 2020 .xlsx | XLSX spreadsheet | |
| ITO SOW v4 ID04200073 Amd 001 10 22 2020.pdf | ||
| Past Performance Questionaire ID04200073 08 13 2020.doc | DOC document | |
| Questions and Answers Attachment ID04200073 06 22 2020.xlsx | XLSX spreadsheet | |
| ITO SOW v3 ID04200073 09 30 2020.pdf | ||
| ITO Attachment Previous Experience Information Sheet ID04200073 06 23 2020.docx | DOCX document | |
| QASP ID04200073 06 22 2020.doc | DOC document |
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
Cover
| ORANGE PREFILLED CELLS AND FORMULAS SHALL NOT BE CHANGED. ANY CHANGES MADE WILL BE REVERTED BACK TO THE ORIGINAL NUMBERS AND FORMULAS | |||||
| BLUE CELLS ARE FILLABLE | |||||
| Task Number: | ID04200073 | ||||
| Program Title: | Benefits Methods Development and Other Relevant Analyses (BORA) for the Evaluation of Air Pollution Control Policies | ||||
| Company Name: | |||||
| Basic Year | Option Year I | Option Year II | Total | ||
| CLIN X001 | $0.00 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | |
| CLIN X002 | $299,789.00 | $329,789.00 | $329,789.00 | $959,367.00 | |
| CLIN X003 | $75,468.00 | $75,468.00 | $75,468.00 | $226,404.00 | |
| Total | $375,257.00 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | |
| Total Evaluated Price (TEP): | ERROR:#DIV/0! |
Base Year
| CLIN 0001 Direct Labor Hours - BASE YEAR | |||||
| Labor Category | Hours | x | Hourly Rate | = | Labor Cost |
| Senior Program Manager (Level 3) | 800 | x | = | $0.00 | |
| Senior Program Manager (Level 2) | 600 | x | = | $0.00 | |
| Senior Environmental Scientist (Level 3) | 800 | x | = | $0.00 | |
| Senior Environmental Economist (Level 4) | 800 | x | = | $0.00 | |
| Senior Environmental Economist (Level 3) | 200 | x | = | $0.00 | |
| Senior Environmental Statistician (4) | 150 | x | = | $0.00 | |
| Senior Research Geographer (3) | 250 | x | = | $0.00 | |
| Senior Environmental Analyst (2) | 200 | x | = | $0.00 | |
| Senior Computer Scientist/GIS Specialist | 500 | x | = | $0.00 | |
| Senior GIS Database Administrator | 400 | x | = | $0.00 | |
| Senior GIS Programmer/Analyst (3) | 400 | x | = | $0.00 | |
| Senior Environmental Regulatory Analyst (3) | 500 | x | = | $0.00 | |
| Mid-Level GIS Project Manager (Level 2) | 350 | x | = | $0.00 | |
| Mid-Level Research Geographer (Level 2) | 250 | x | = | $0.00 | |
| Mid-Level Environmental Scientist (Level 2) | 200 | x | = | $0.00 | |
| Mid-Level Environmental Economist (Level 3) | 200 | x | = | $0.00 | |
| Mid-Level Environmental Statistician | 150 | x | = | $0.00 | |
| Mid-Level Environmental Analyst (Level 2) | 100 | x | = | $0.00 | |
| Mid-Level GIS Programmer/Analyst (Level 2) | 350 | x | = | $0.00 | |
| Mid-Level Environmental Regulatory Analyst | 200 | x | = | $0.00 | |
| Mid-Level Computer Scientist/GIS Specialist | 200 | x | = | $0.00 | |
| Mid-Level GIS/Cartographer | 200 | x | = | $0.00 | |
| Mid-Level GIS Technician 2 | 150 | x | = | $0.00 | |
| Mid-Level Video Specialist | 200 | x | = | $0.00 | |
| Mid-Level Document Design/Production | 150 | x | = | $0.00 | |
| Mid-Level Editor/Writer | 300 | x | = | $0.00 | |
| Communications Specialist (2) | 150 | x | = | $0.00 | |
| Training Specialist (2) | 150 | x | = | $0.00 | |
| Webinar Specialist (2) | 200 | x | = | $0.00 | |
| Website & Graphic Design & Support Specialist | 200 | x | = | $0.00 | |
| Junior Research Geographer (Level 1) | 100 | x | = | $0.00 | |
| Junior GIS Project Manager (Level 1) | 100 | x | = | $0.00 | |
| Junior Environmental Scientist (Level 2) | 200 | x | = | $0.00 | |
| Junior Environmental Economist (Level 2) | 400 | x | = | $0.00 | |
| Junior Environmental Statistician | 250 | x | = | $0.00 | |
| Junior Environmental Analyst | 250 | x | = | $0.00 | |
| Junior Computer Scientist/GIS Specialist | 500 | x | = | $0.00 | |
| Junior GIS Technician (Level 1) | 250 | x | = | $0.00 | |
| Junior Environmental Regulatory Analyst | 500 | x | = | $0.00 | |
| Junior Video Specialist | 300 | x | = | $0.00 | |
| Entry Level Environmental Scientist | 400 | x | = | $0.00 | |
| Entry Level Environmental Statistician | 400 | x | = | $0.00 | |
| Entry Level Computer Scientist/GIS Specialist | 400 | x | = | $0.00 | |
| Entry Level Environmental Economist | 400 | x | = | $0.00 | |
| Entry Level Environmental Regulatory Analyst | 600 | x | = | $0.00 | |
| Entry Level Document Design/Production | 500 | x | = | $0.00 | |
| Entry Level Video Specialist | 400 | x | = | $0.00 | |
| Administrative Support | 1,000 | x | = | $0.00 | |
| Contract Support Specialist | 1,000 | x | = | $0.00 | |
| Logistics Coordinator | 200 | x | = | $0.00 | |
| Document Design/Production | 550 | x | = | $0.00 | |
| Total | 18,000.00 | $0.00 | |||
| CLIN 0002 Materials | $329,789.00 |
CLIN 0003 Travel $75,468.00
| SUBTOTAL | $405,257.00 | |
| G&A | 0% | $0.00 |
| TOTAL PROPOSED | $405,257.00 |
Option Year 1
| CLIN 0001 Direct Labor Hours - Option YEAR 1 | |||||
| Labor Category | Hours | x | Hourly Rate | = | Labor Cost |
| Senior Program Manager (Level 3) | 800 | x | = | $0.00 | |
| Senior Program Manager (Level 2) | 600 | x | = | $0.00 | |
| Senior Environmental Scientist (Level 3) | 800 | x | = | $0.00 | |
| Senior Environmental Economist (Level 4) | 800 | x | = | $0.00 | |
| Senior Environmental Economist (Level 3) | 200 | x | = | $0.00 | |
| Senior Environmental Statistician (4) | 150 | x | = | $0.00 | |
| Senior Research Geographer (3) | 250 | x | = | $0.00 | |
| Senior Environmental Analyst (2) | 200 | x | = | $0.00 | |
| Senior Computer Scientist/GIS Specialist | 500 | x | = | $0.00 | |
| Senior GIS Database Administrator | 400 | x | = | $0.00 | |
| Senior GIS Programmer/Analyst (3) | 400 | x | = | $0.00 | |
| Senior Environmental Regulatory Analyst (3) | 500 | x | = | $0.00 | |
| Mid-Level GIS Project Manager (Level 2) | 350 | x | = | $0.00 | |
| Mid-Level Research Geographer (Level 2) | 250 | x | = | $0.00 | |
| Mid-Level Environmental Scientist (Level 2) | 200 | x | = | $0.00 | |
| Mid-Level Environmental Economist (Level 3) | 200 | x | = | $0.00 | |
| Mid-Level Environmental Statistician | 150 | x | = | $0.00 | |
| Mid-Level Environmental Analyst (Level 2) | 100 | x | = | $0.00 | |
| Mid-Level GIS Programmer/Analyst (Level 2) | 350 | x | = | $0.00 | |
| Mid-Level Environmental Regulatory Analyst | 200 | x | = | $0.00 | |
| Mid-Level Computer Scientist/GIS Specialist | 200 | x | = | $0.00 | |
| Mid-Level GIS/Cartographer | 200 | x | = | $0.00 | |
| Mid-Level GIS Technician 2 | 150 | x | = | $0.00 | |
| Mid-Level Video Specialist | 200 | x | = | $0.00 | |
| Mid-Level Document Design/Production | 150 | x | = | $0.00 | |
| Mid-Level Editor/Writer | 300 | x | = | $0.00 | |
| Communications Specialist (2) | 150 | x | = | $0.00 | |
| Training Specialist (2) | 150 | x | = | $0.00 | |
| Webinar Specialist (2) | 200 | x | = | $0.00 | |
| Website & Graphic Design & Support Specialist | 200 | x | = | $0.00 | |
| Junior Research Geographer (Level 1) | 100 | x | = | $0.00 | |
| Junior GIS Project Manager (Level 1) | 100 | x | = | $0.00 | |
| Junior Environmental Scientist (Level 2) | 200 | x | = | $0.00 | |
| Junior Environmental Economist (Level 2) | 400 | x | = | $0.00 | |
| Junior Environmental Statistician | 250 | x | = | $0.00 | |
| Junior Environmental Analyst | 250 | x | = | $0.00 | |
| Junior Computer Scientist/GIS Specialist | 500 | x | = | $0.00 | |
| Junior GIS Technician (Level 1) | 250 | x | = | $0.00 | |
| Junior Environmental Regulatory Analyst | 500 | x | = | $0.00 | |
| Junior Video Specialist | 300 | x | = | $0.00 | |
| Entry Level Environmental Scientist | 400 | x | = | $0.00 | |
| Entry Level Environmental Statistician | 400 | x | = | $0.00 | |
| Entry Level Computer Scientist/GIS Specialist | 400 | x | = | $0.00 | |
| Entry Level Environmental Economist | 400 | x | = | $0.00 | |
| Entry Level Environmental Regulatory Analyst | 600 | x | = | $0.00 | |
| Entry Level Document Design/Production | 500 | x | = | $0.00 | |
| Entry Level Video Specialist | 400 | x | = | $0.00 | |
| Administrative Support | 1,000 | x | = | $0.00 | |
| Contract Support Specialist | 1,000 | x | = | $0.00 | |
| Logistics Coordinator | 200 | x | = | $0.00 | |
| Document Design/Production | 550 | x | = | $0.00 | |
| Total | 18,000.00 | $0.00 | |||
| CLIN 0002 Materials | $329,789.00 |
CLIN 0003 Travel $75,468.00
| SUBTOTAL | $405,257.00 | |
| G&A | 0% | $0.00 |
| TOTAL PROPOSED | $405,257.00 |
Option Year 2
| CLIN 0001 Direct Labor Hours - Option YEAR 2 | |||||
| Labor Category | Hours | x | Hourly Rate | = | Labor Cost |
| Senior Program Manager (Level 3) | 800 | x | = | $0.00 | |
| Senior Program Manager (Level 2) | 600 | x | = | $0.00 | |
| Senior Environmental Scientist (Level 3) | 800 | x | = | $0.00 | |
| Senior Environmental Economist (Level 4) | 800 | x | = | $0.00 | |
| Senior Environmental Economist (Level 3) | 200 | x | = | $0.00 | |
| Senior Environmental Statistician (4) | 150 | x | = | $0.00 | |
| Senior Research Geographer (3) | 250 | x | = | $0.00 | |
| Senior Environmental Analyst (2) | 200 | x | = | $0.00 | |
| Senior Computer Scientist/GIS Specialist | 500 | x | = | $0.00 | |
| Senior GIS Database Administrator | 400 | x | = | $0.00 | |
| Senior GIS Programmer/Analyst (3) | 400 | x | = | $0.00 | |
| Senior Environmental Regulatory Analyst (3) | 500 | x | = | $0.00 | |
| Mid-Level GIS Project Manager (Level 2) | 350 | x | = | $0.00 | |
| Mid-Level Research Geographer (Level 2) | 250 | x | = | $0.00 | |
| Mid-Level Environmental Scientist (Level 2) | 200 | x | = | $0.00 | |
| Mid-Level Environmental Economist (Level 3) | 200 | x | = | $0.00 | |
| Mid-Level Environmental Statistician | 150 | x | = | $0.00 | |
| Mid-Level Environmental Analyst (Level 2) | 100 | x | = | $0.00 | |
| Mid-Level GIS Programmer/Analyst (Level 2) | 350 | x | = | $0.00 | |
| Mid-Level Environmental Regulatory Analyst | 200 | x | = | $0.00 | |
| Mid-Level Computer Scientist/GIS Specialist | 200 | x | = | $0.00 | |
| Mid-Level GIS/Cartographer | 200 | x | = | $0.00 | |
| Mid-Level GIS Technician 2 | 150 | x | = | $0.00 | |
| Mid-Level Video Specialist | 200 | x | = | $0.00 | |
| Mid-Level Document Design/Production | 150 | x | = | $0.00 | |
| Mid-Level Editor/Writer | 300 | x | = | $0.00 | |
| Communications Specialist (2) | 150 | x | = | $0.00 | |
| Training Specialist (2) | 150 | x | = | $0.00 | |
| Webinar Specialist (2) | 200 | x | = | $0.00 | |
| Website & Graphic Design & Support Specialist | 200 | x | = | $0.00 | |
| Junior Research Geographer (Level 1) | 100 | x | = | $0.00 | |
| Junior GIS Project Manager (Level 1) | 100 | x | = | $0.00 | |
| Junior Environmental Scientist (Level 2) | 200 | x | = | $0.00 | |
| Junior Environmental Economist (Level 2) | 400 | x | = | $0.00 | |
| Junior Environmental Statistician | 250 | x | = | $0.00 | |
| Junior Environmental Analyst | 250 | x | = | $0.00 | |
| Junior Computer Scientist/GIS Specialist | 500 | x | = | $0.00 | |
| Junior GIS Technician (Level 1) | 250 | x | = | $0.00 | |
| Junior Environmental Regulatory Analyst | 500 | x | = | $0.00 | |
| Junior Video Specialist | 300 | x | = | $0.00 | |
| Entry Level Environmental Scientist | 400 | x | = | $0.00 | |
| Entry Level Environmental Statistician | 400 | x | = | $0.00 | |
| Entry Level Computer Scientist/GIS Specialist | 400 | x | = | $0.00 | |
| Entry Level Environmental Economist | 400 | x | = | $0.00 | |
| Entry Level Environmental Regulatory Analyst | 600 | x | = | $0.00 | |
| Entry Level Document Design/Production | 500 | x | = | $0.00 | |
| Entry Level Video Specialist | 400 | x | = | $0.00 | |
| Administrative Support | 1,000 | x | = | $0.00 | |
| Contract Support Specialist | 1,000 | x | = | $0.00 | |
| Logistics Coordinator | 200 | x | = | $0.00 | |
| Document Design/Production | 550 | x | = | $0.00 | |
| Total | 18,000.00 | $0.00 | |||
| CLIN 0002 Materials | $329,789.00 |
CLIN 0003 Travel $75,468.00
| SUBTOTAL | $405,257.00 | |
| G&A | 0% | $0.00 |
| TOTAL PROPOSED | $405,257.00 |
File details come from the government source that posted it. Updated .