B08_Attch1_Price_Schedule_.xlsx
XLSX spreadsheet 36 KB Posted
- Solicitation number
- 140P2125R0009
About this file
The file is a comprehensive Excel-based pricing schedule and task order breakdown for a National Park Service socioeconomic research project. The document details labor categories with specific education requirements and experience levels, ranging from high school to PhD across roles such as Project Directors, Social Scientists, Economists, Statisticians, Interviewers, and Data Analysts. The pricing schedule covers a five-year contract period with a six-month extension option, specifying hourly rates for each labor category.
The task order outlines a detailed visitor study involving 24 national parks, with three primary project phases: study design and methods development, survey administration and data collection, and data analysis and reporting. The project scope includes developing survey instruments, coordinating with park contacts, field implementation, data entry, analysis, and reporting. The total estimated project hours are 18,538, with significant time allocated to tasks like field implementation (12,320 hours) and data analysis (1,184 hours). The project aims to collect visitor data across diverse national park locations, including sites in California, Alaska, Minnesota, Wyoming, and other states, to inform NPS strategic planning and management.
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
| Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | 6 Month Extension | |
| Labor Categories | ||||||
| Project management | ||||||
| Senior Project Director | ||||||
| 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 Specislist (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 Director | MS | 5 |
| Senior Project Manager | MS | 5 |
| Team lead | BS/BA | 2 |
| Field Supwervisor | BS/BA | 2 |
| Social Scientist | ||
| Senior social scientist | PhD | 5 |
| 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 | 5 |
| Economist 1 | MS | 2 |
| Economist 2 | MS | 2 |
| Economist 3 | MS | 2 |
| Statistician | ||
| Senior statistician | PhD | 5 |
| Statistician | MS | 5 |
| Interviewer | ||
| Survey Interviewer 1 | HS | 1 |
| Survey Interviewer 2 | HS | 2 |
| Survey Interviewer 3 | HS | 3 |
| Field Interviewer | HS | 4 |
| Interview Specislist (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 |
JOTR Task Order
| Hours are Estimated. Contractor May Adjust Hours/Labor Categories as Appropriate. Must Provide Rationale for Changes. | ||||||||||||
| Otak | Sub-ITRR | Sub-RRC | Hours by Task | Labor Cost by Task | Expenses | TOTAL COST | ||||||
| Labor Class: | Senior Project Director | 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 | ||||||||||||||||
| 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 .