B08_Attch1_Amnd_1_Price_Schedule_0001.xlsx
XLSX spreadsheet 36 KB Posted
- Solicitation number
- 140P2125R0009
About this file
This is a comprehensive pricing schedule and task order spreadsheet for a National Park Service (NPS) socioeconomic research and visitor study project. The document details labor categories with specific education requirements and experience levels, including roles such as Senior Project Manager, Social Scientists, Economists, Statisticians, Interviewers, and Data Analysts. The task order covers three primary phases: study design and methods development, survey administration and data collection across 24 national parks, and data analysis and reporting.
The spreadsheet provides detailed task breakdowns with estimated hours for each labor category, covering activities like project management, survey instrument development, field implementation, data entry, analysis, and reporting. The study will involve intercept surveys at five locations per park, with results to be reported both by individual park and nationally by park unit category. Labor categories range from high-level roles like Senior Project Managers (requiring MS/PhD with 10 years experience) to entry-level positions like Survey Interviewers (requiring high school diploma). The document indicates that while contractors cannot adjust core labor categories or hours, they may propose additional categories with justification.
View the file
Other files
Show all 17
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
Labor Rates
| Contractors MAY NOT adjust the labor categories below. However, if there are additional labor categories, please create a separate table below reflecting those changes and explain why such changes are being proposed. Changes will NOT be evaluated as a part of the evaluation process. | ||||||
| Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | 6 Month Extension | |
| Labor Categories | ||||||
| Project management | ||||||
| Senior Project Manager | ||||||
| Team lead | ||||||
| Field Supervisor | ||||||
| Social Scientist | ||||||
| Senior social scientist | ||||||
| Social Scientist 1 | ||||||
| Social Scientist 2 | ||||||
| Social Scientist 3 | ||||||
| Social Scientist 4 | ||||||
| Social Scientist 5 | ||||||
| Economists | ||||||
| Senior Economist | ||||||
| Economist 1 | ||||||
| Economist 2 | ||||||
| Economist 3 | ||||||
| Statistician | ||||||
| Senior statistician | ||||||
| Statistician | ||||||
| Interviewer | ||||||
| Survey Interviewer 1 | ||||||
| Survey Interviewer 2 | ||||||
| Survey Interviewer 3 | ||||||
| Field Interviewer | ||||||
| Interview Specialist (bilingual) | ||||||
| Data analyst | ||||||
| Data analyst | ||||||
| Senior data analyst | ||||||
| Analyst | ||||||
| Data supervisor | ||||||
| Data entry specialist | ||||||
| Databse Administrator | ||||||
| Other | ||||||
| Ecologist | ||||||
| Transportation analyst | ||||||
| Transportation Engineer | ||||||
| Scientist | ||||||
| Planner 1 | ||||||
| Planner 2 | ||||||
| Facilitator | ||||||
| Technical Writer/Editor | ||||||
| Graphics Specialist | ||||||
| ALL RATES WILL BE HOURLY AND FULLY BURDENED |
Education Requirements
| Labor Categories | Minimum Education | Experience |
| Project management | ||
| Senior Project Manager | MS | 10 |
| Team lead | BS/BA | 2 |
| Field Supervisor | BS/BA | 2 |
| Social Scientist | ||
| Senior social scientist | PhD | 10 |
| Social Scientist 1 | BS/BA | 2 |
| Social Scientist 2 | BS/BA | 2 |
| Social Scientist 3 | MS | 2 |
| Social Scientist 4 | MS | 2 |
| Social Scientist 5 | MS | 2 |
| Economists | ||
| Senior Economist | PHD | 10 |
| Economist 1 | MS | 2 |
| Economist 2 | MS | 2 |
| Economist 3 | MS | 2 |
| Statistician | ||
| Senior statistician | PhD | 10 |
| Statistician | MS | 5 |
| Interviewer | ||
| Survey Interviewer 1 | HS | 1 |
| Survey Interviewer 2 | HS | 2 |
| Survey Interviewer 3 | HS | 3 |
| Field Interviewer | HS | 4 |
| Interview Specialist (bilingual) | BS/BA | 1 |
| Data analyst | ||
| Data analyst | BS/BA | 2 |
| Senior data analyst | MS | 5 |
| Analyst | BS/BA | 2 |
| Data supervisor | MS | 2 |
| Data entry specialist | BS/BA | 1 |
| Databse Administrator | BS/BA | 2 |
| Other | ||
| Ecologist | MS | 5 |
| Transportation analyst | BS/BA | 2 |
| Transportation Engineer | MS | 5 |
| Facilitator | MS | 2 |
| Technical Writer/Editor | MS | 2 |
| Graphics Specialist | BS/BA | 3 |
| Scientist | MS | 2 |
| Planner 1 | BS/BA | 1 |
| Planner 2 | BS/BA | 2 |
JOTR Task Order
| Hours are estimated. Contractors MAY NOT adjust the hours/labor categories below. However, if there are additional labor hours/categories for any of the tasks below, please create a separate table below reflecting those changes and explain why such changes are being proposed. Changes will NOT be evaluated as a part of the evaluation process. | ||||||||||||
| Hours by Task | Labor Cost by Task | Expenses | TOTAL COST | |||||||||
| Labor Class: | Senior Project Manager | Graphics Specialist/ Admin Support | Economist | Survey Interviewer 3 | Data Supervisor | Social Scientist 2 | Senior Social Scientist | Social Scientist 1 | ||||
| Hourly Rate |
| Task 1.1 Study development | ||||||||||||
| Project management and coordination | 8 | 8 | 4 | 0 | 0 | 4 | 8 | 0 | 32 | $0 | $0 | $0 |
| Organize and schedule project scoping calls (up to 2 calls, 1 hour each) | 4 | 0 | 4 | 0 | 0 | 0 | 4 | 0 | 12 | $0 | $0 | $0 |
| Develop final survey instrument | 0 | 0 | 2 | 0 | 0 | 0 | 2 | 0 | 4 | $0 | $0 | $0 |
| Develop study plan, including samping, staffing, schedule, logistics plan | 0 | 0 | 2 | 0 | 0 | 2 | 2 | 0 | 6 | $0 | $0 | $0 |
| Prepare and submit ICR package and respond to OMB questions | 0 | 0 | 2 | 0 | 0 | 0 | 2 | 0 | 4 | $0 | $0 | $0 |
| Recruit field staff, obtain park research permit, arrange travel, pack and ship equipment | 0 | 0 | 2 | 0 | 0 | 2 | 0 | 0 | 4 | $0 | $0 | $0 |
| Subtotal | 12 | 8 | 16 | 0 | 0 | 8 | 18 | 0 | 62 | $0 | $0 | $0 |
| 1.2 On-site scoping and data collection | ||||||||||||
| Onsite scoping (site scoping, staff training) | 0 | 0 | 0 | 40 | 0 | 8 | 0 | 12 | 60 | $0 | $0 | $0 |
| Survey sampling | 0 | 0 | 4 | 400 | 0 | 24 | 8 | 0 | 436 | $0 | $0 | $0 |
| Generate field report | 0 | 0 | 4 | 0 | 0 | 4 | 12 | 0 | 20 | $0 | $0 | $0 |
| Subtotal | 0 | 0 | 8 | 440 | 0 | 36 | 20 | 12 | 516 | $0 | $0 | $0 |
| 1.3 Data entry and storage | ||||||||||||
| Mailback data entry (600 surveys, 5 minutes each) | 0 | 0 | 2 | 0 | 50 | 4 | 0 | 0 | 56 | $0 | $0 | $0 |
| Ensure data accuracy | 0 | 0 | 2 | 0 | 0 | 4 | 2 | 4 | 12 | $0 | $0 | $0 |
| Prepare formatted datasets | 0 | 0 | 4 | 0 | 0 | 4 | 4 | 12 | 24 | $0 | $0 | $0 |
| Subtotal | 0 | 0 | 8 | 0 | 50 | 12 | 6 | 16 | 92 | $0 | $0 | $0 |
| Total | 12 | 8 | 32 | 440 | 50 | 56 | 44 | 28 | 670 | $0 | $0 | $0 |
| 2.1 Results Report | ||||||||||||
| Prepare draft report | 12 | 48 | 8 | 0 | 0 | 8 | 8 | 8 | 92 | $0 | $0 | $0 |
| Prepare final report | 6 | 34 | 10 | 0 | 0 | 10 | 10 | 10 | 80 | $0 | $0 | $0 |
| Present results and recommendations to park staff via 2-hour teleconference results presentation | 4 | 6 | 12 | 0 | 0 | 4 | 6 | 12 | 44 | $0 | $0 | $0 |
| Subtotal | 22 | 88 | 30 | 0 | 0 | 22 | 24 | 30 | 216 | $0 | $0 | $0 |
| Task Order Total | $0 | $0 |
Expenses
| Travel - Visitor Study | |
| Task 1.2 Onsite scoping and data collection - JOTR | |
| Onsite equipment | $0 |
| Travel - Counting tasks | |
| Hotel (3 Interviewers in 3 rooms; 12 days onsite; $186 per room/night) | $0 |
| Hotel (1 Social Science Specialist, 5 days onsite; 1 Senior Social Scientist, 3 days onsite) | $0 |
| Airfare (3 interviews, 1 Social Science Specialist, 1 Senior Social Scientist) | $0 |
| Rental car & fuel (3 interviewers, 1 car, 12 days onsite; 1 Social Science Specialist & 1 Senior Social Scientist, 1 car, 5 days onsite) | $0 |
| Meals (3 Interviewers; 12 days onsite, 86/day, 64.5/first and last day) | $0 |
| Meals (1 Social Science Specialist, 5 days onsite; 1 Senior Social Scientist, 3 days onsite) | $0 |
| Subtotal Task 1.2 | $0 |
| 1.3 Data entry and storage | |
| Survey Mailings and Postage | $0 |
| Subtotal Task 1.3 | $0 |
| Total | $0 |
| Contractor May Adjust Number of Personnel/Days as Deemed Appropriate. Must provide an explanation to differences. |
MOCK SEM Task Order
| Assumes: | ||||||||||||||||
| Five intercept locations per park | ||||||||||||||||
| Results reported by park and nationally per park unit category | Hours are estimated. Contractors MAY NOT adjust the hours/labor categories below. However, if there are additional labor hours/categories for any of the tasks below, please create a separate table below reflecting those changes and explain why such changes are being proposed. Changes will NOT be evaluated as a part of the evaluation process. | |||||||||||||||
| Vendor Team | Hours by Task | Labor Cost by Task | Expenses | TOTAL COST | ||||||||||||
| Labor Class: | Senior Project Manager | Graphics Specialist | Senior Social Scientist | Social Scientist 2 | Statistician | Economist 1 | Social Scientist 1 | Team Lead/Task Order Leader | Field Supervisor (Interview Specialist) | Survey Interviewer 3 | Interview Specialist- (Bilingual) | Data Supervisor | ||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Task 1.0 Study design and methods development | ||||||||||||||||
| Project Management | 40 | 0 | 40 | 40 | 0 | 40 | 120 | 0 | 120 | 0 | 0 | 24 | 424 | $0.00 | $0.00 | $0.00 |
| 1.1 Organize and schedule project scoping phone calls | 10 | 0 | 10 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 30 | $0.00 | $0.00 | $0.00 |
| 1.2 Develop survey instruments | 12 | 0 | 24 | 24 | 18 | 18 | 180 | 0 | 0 | 0 | 0 | 0 | 276 | $0.00 | $0.00 | $0.00 |
| 1.3 Develop data collection and data management plan | 12 | 12 | 24 | 24 | 24 | 24 | 160 | 0 | 0 | 0 | 0 | 0 | 280 | $0.00 | $0.00 | $0.00 |
| Subtotal Task 1.0 | 74 | 12 | 98 | 98 | 42 | 82 | 460 | 0 | 120 | 0 | 0 | 24 | 1010 | $0.00 | $0.00 | $0.00 |
| Task 2.0 Survey administration, data collection, and data entry (24 parks) | ||||||||||||||||
| Project Management | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 | $0.00 | $0.00 |
| 2.1 Coordinate with park unit point of contact | 72 | 0 | 120 | 120 | 0 | 100 | 480 | 0 | 360 | 0 | 0 | 60 | 1312 | $0.00 | $0.00 | $0.00 |
| 2.2 Field implementation | 60 | 0 | 120 | 120 | 0 | 120 | 480 | 0 | 360 | 9000 | 2000 | 60 | 12320 | $0.00 | $0.00 | $0.00 |
| 2.3 Data entry and storage | 24 | 0 | 40 | 0 | 0 | 0 | 160 | 100 | 120 | 600 | 160 | 120 | 1324 | $0.00 | $0.00 | $0.00 |
| Subtotal Task 2.0 | 156 | 0 | 280 | 240 | 0 | 220 | 1120 | 100 | 840 | 9600 | 2160 | 240 | 14956 | $0.00 | $0.00 | $0.00 |
| Task 3.0 Data analysis and reporting | ||||||||||||||||
| Project Management | 24 | 24 | 16 | 0 | 0 | 24 | 160 | 0 | 0 | 0 | 0 | 16 | 264 | $0.00 | $0.00 | $0.00 |
| 3.1 Data analysis | 24 | 0 | 80 | 120 | 80 | 80 | 800 | 0 | 0 | 0 | 0 | 0 | 1184 | $0.00 | $0.00 | $0.00 |
| 3.2 Results report | 24 | 120 | 80 | 80 | 40 | 80 | 700 | 0 | 0 | 0 | 0 | 0 | 1124 | $0.00 | $0.00 | $0.00 |
| Subtotal Task 3.0 | 72 | 144 | 176 | 200 | 120 | 184 | 1660 | 0 | 0 | 0 | 0 | 16 | 2572 | $0.00 | $0.00 | $0.00 |
Total all tasks 302 156 554 538 162 486 3240 100 960 9600 2160 280 18538 $0.00 $0.00 $0.00
| Park Name | Code | State | County | City | Lodging | M&IE(Full) | M&IE(Part) | Flight | Airport | Airfare | Lodging (13 or 19) | M&IE Full(11 or 17) | M&IE Partial(2 days) | Cost (Per Park) |
| Mojave National Park | MOJA | CA | San Bernadino | Kelso | $0 | $0 | $0.00 | $0 | LAS | $0 | $0 | $0 | $0.00 | $0 |
| Kobuk Valley NP* | KOVA | AK | Northwest Arctic Borough | Kotzebue | $0 | $0 | $0.00 | $0 | ANC | $0 | $0 | $0 | $0.00 | $0 |
| Voyageurs National Park | VOYA | MN | Koochiching | International Falls | $0 | $0 | $0.00 | $0 | MSP | $0 | $0 | $0 | $0.00 | $0 |
| Yellowstone National Park | YELL | WY | Cody | Park | $0 | $0 | $0.00 | $0 | COD | $0 | $0 | $0 | $0.00 | $0 |
| Big Cypress National Preserve | BICY | FL | Collier | Ochopee | $0 | $0 | $0.00 | $0 | OPF | $0 | $0 | $0 | $0.00 | $0 |
| Muir Woods National Monument | MUWO | CA | Marin | Mill Valley | $0 | $0 | $0.00 | $0 | SFO | $0 | $0 | $0 | $0.00 | $0 |
| Charles Pinckney National Historic Site* | CHPI | SC | Charleston | Mount Pleasant | $0 | $0 | $0.00 | $0 | CHS | $0 | $0 | $0 | $0.00 | $0 |
| Saint Paul's Church National Historic Site | SAPA | NY | Westchester | Mount Vernon | $0 | $0 | $0.00 | $0 | LGA | $0 | $0 | $0 | $0.00 | $0 |
| Thomas Stone National Historic Site* | THST | MD, VA | Charles | Port Tobacco | $0 | $0 | $0.00 | $0 | DCA | $0 | $0 | $0 | $0.00 | $0 |
| Independence National Historical Park | INDE | PA | Philadelphia | Philadelphia | $0 | $0 | $0.00 | $0 | PHL | $0 | $0 | $0 | $0.00 | $0 |
| World War II Valor in the Pacific National Monument | VALR | HI | Honolulu | Honolulu | $0 | $0 | $0.00 | $0 | HNL | $0 | $0 | $0 | $0.00 | $0 |
| San Francisco Maritime National Historical Park | SAFR | CA | San Francisco | San Francisco | $0 | $0 | $0.00 | $0 | SFO | $0 | $0 | $0 | $0.00 | $0 |
| Ninety Six National Historic Site | NISI | SC | Greenwood | Ninety Six | $0 | $0 | $0.00 | $0 | GSP | $0 | $0 | $0 | $0.00 | $0 |
| Pecos National Historical Park | PECO | NM | San Miguel | Pecos | $0 | $0 | $0.00 | $0 | SAF | $0 | $0 | $0 | $0.00 | $0 |
| Pea Ridge National Military Park | PERI | AR | Benton | Garfield | $0 | $0 | $0.00 | $0 | XNA | $0 | $0 | $0 | $0.00 | $0 |
| Cowpens National Battlefield | COWP | SC | Cherokee | Gaffney | $0 | $0 | $0.00 | $0 | GSP | $0 | $0 | $0 | $0.00 | $0 |
| Lewis and Clark National Historical Park | LEWI | OR, WA | Clatsop | Astoria | $0 | $0 | $0.00 | $0 | PDX | $0 | $0 | $0 | $0.00 | $0 |
| San Juan Island National Historical Park | SAJH | PR | San Juan | Friday Harbor | $0 | $0 | $0.00 | $0 | SEA | $0 | $0 | $0 | $0.00 | $0 |
| Obed Wild & Scenic River | OBED | TN | Morgan | Wartburg | $0 | $0 | $0.00 | $0 | TYS | $0 | $0 | $0 | $0.00 | $0 |
| Piscataway Park | PISC | MD, VA | Prince George's | Accokeek | $0 | $0 | $0.00 | $0 | DCA | $0 | $0 | $0 | $0.00 | $0 |
| Missouri National Recreational River | MNRR | SD, NE | Yankton | Yankton | $0 | $0 | $0.00 | $0 | FSD | $0 | $0 | $0 | $0.00 | $0 |
| Assateague Island National Seashore | ASIS | MD, VA | Worcester | Berlin | $0 | $0 | $0.00 | $0 | SBY | $0 | $0 | $0 | $0.00 | $0 |
| Cape Cod National Seashore | CACO | MA | Eastham | Eastham | $0 | $0 | $0.00 | $0 | PVC | $0 | $0 | $0 | $0.00 | $0 |
| Chattahoochee River National Recreation Area | CHAT | GA | Fulton | Sandy Springs | $0 | $0 | $0.00 | $0 | ATL | $0 | $0 | $0 | $0.00 | $0 |
| Totals | $0 | $0 | $0 | $0 | $0 | |||||||||
| Other Direct Costs | ||||||||||||||
| Item | Description | Estimated Cost | Qty | Estimated Total | ||||||||||
| Rental Car (simple) | 4 rental cars per park | $0.00 | 4 | $0.00 | ||||||||||
| Rental Car (complex) | 4 rental cars per park | $0.00 | 4 | $0.00 | ||||||||||
| Mileage (simple) | 1000 miles per park | $0.00 | 4 | $0.00 | ||||||||||
| Mileage (complex) | 1000 miles per park | $0.00 | 4 | $0.00 | ||||||||||
| Parking | Estimated per park | $0.00 | 1 | $0.00 | ||||||||||
| Other Transportation Fees | Estimated per park | $0.00 | 1 | $0.00 | ||||||||||
| Field Equipment | 3 tablets and additional field costs | $0.00 | 1 | $0.00 | ||||||||||
| Meeting Expenses | Estimated costs | $0.00 | 1 | $0.00 | ||||||||||
| Vendor Direct Costs | Translation of the primary SEM survey per park | $0.00 | 1 | $0.00 | ||||||||||
| Reproducibles | Executive summaries (4 color and 4 full B&W) | $0.00 | 1 | $0.00 | ||||||||||
| Quantity may differ from above but contractor must provide rationale for differences. | Total (per each of 21 parks) | $0.00 | ||||||||||||
| Total (per each of 3 complex) | $0.00 | |||||||||||||
| Total simple | $0.00 | |||||||||||||
| Total complex | $0.00 | |||||||||||||
| Total all parks | $0.00 | |||||||||||||
| Postage costs per park | ||||||||||||||
| Item | Description | Estimated Cost | Qty | Estimated Total | ||||||||||
| Deliveries/Postage | 21 parks to achieve 400 response | $0.00 | 21 | $0.00 | ||||||||||
| Deliveries/Postage | 3 parks to achieve 800 response | $0.00 | 3 | $0.00 | ||||||||||
| Quantity may differ from above but contractor must provide rationale for differences. | Total postage (24 parks) | $0.00 |
| Direct Costs | ||||
| Item | Description | Estimated Cost | Qty | Estimated Total |
| Travel to present in Fort Collins | 2 people RT flight | $0.00 | 2 | $0.00 |
| 2 people lodging by 1 night | $0.00 | 2 | $0.00 | |
| 2 people rental cars by 2 days | $0.00 | 4 | $0.00 | |
| 2 people fuel | $0.00 | 2 | $0.00 | |
| 2 people per diem meals (1 day) | $0.00 | 2 | $0.00 | |
| 2 people meals 1/2 day travel day | $0.00 | 2 | $0.00 | |
| Quantity may differ from above but contractor must provide rationale for differences. | Subtotal ODC per park | $0.00 |
| Total Costs | |
| Item | Cost |
| Estimated Travel Costs | $0.00 |
| ODC | $0.00 |
| Postage | $0.00 |
| Travel to FOCO | $0.00 |
| Total | $0.00 |
File details come from the government source that posted it. Updated .