B08_Attachment_2_Price_Schedule_Post_Q_A_2_24_25_0001.xlsx
XLSX spreadsheet 37 KB Posted
- Attached to
- Prospectus Develpment IDIQ Firm Fixed Price
- Solicitation number
- 140P2125Q0008
About this file
This is a pricing schedule template for a National Park Service IDIQ contract focused on commercial services prospectus development. The document outlines 10 core tasks including project due diligence, market analysis, rate studies, property valuation, financial analysis, prospectus development, roundtable meetings, and panel support.
The template details 12 labor categories ranging from Executive/Senior VP to various Subject Matter Experts (SMEs) in fields like personal property appraisal, food services, marina services, recreation, transportation, and retail. Each position includes minimum education and experience requirements. The pricing schedule covers a base year, four ordering periods, and a six-month extension option, with specified hourly rate ranges for key positions (Executive/Senior VP: $281.88-$386.42, Senior VP: $219.35-$340.30, Associate: $132.23-$213.20, SME-Personal Property Appraiser: $155.80-$241.90). The document includes an example task order worksheet for vendors to input their proposed hours and rates across all 10 tasks.
View the file
Other files
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
TASK DEFINITIONS
| TASK TITLE | TASK NUMBER | TASK DEFINITION SUMMARY* |
| Project Due Diligence | 1 | Introductory meeting. |
| Advanced Information Request, daily fieldwork schedule, site visit presentation and agenda. | ||
| Kick-off meeting. | ||
| Interviews. | ||
| Competitive and comparable facilities. | ||
| Support facilities analysis. | ||
| Photographs. | ||
| Exit briefing. | ||
| Market Analysis | 2 | Market overview. |
| Operational perormance overview. | ||
| Recommendations and conclusions. | ||
| Rate Study | 3 | List of comparables. |
| Rate study. | ||
| Personal Property Valuation | 4 | Personal Property Valuation and Replacement Schedule |
| Cost estimates. | ||
| Financial Investment Analysis and Scenario Meeting | 5 | Baseline buildup. |
| Financial model. | ||
| Scenario Meeting | ||
| Executive summary and insurance requirements | ||
| Franchise Fee Analysis Report | ||
| Initial Prospectus Development | 6 | Draft prospectus documents - Alternative 6A (Most Prospectus Documents) |
| Roundtable Meeting Preparation and Execution | 7 | Roundtable Meeting Preparation and Draft 2 Prospectus Documents |
| Roundtable Meeting Attendance | ||
| Post-Roundtable memo. | ||
| Final Draft Prospectus Documents | 8 | Final draft prospectus documents. |
| Panel Support | 9 | One week panel. |
| Additional Scenario Analysis | 10 | One additional scenario analysis. |
| * See Attachment "Example Task Order Scope of Work" for detailed requirements for each task. |
LABOR CATEGORY DESCRIPTIONS
Labor Category Descriptions
| Contract Line Item No. (CLIN) | Schedule of Supplies | Qty | Unit |
| 0001 | NPS Commercial Services Prospectus Development | 1 | Job |
| Labor Categories | |||
| Category ID # | Labor Category Title | Minimum Level Education | Minimum Experience |
(Years / Field of Expertise) 1 Executive/Senior VP Relevant undergraduate degree, such as business, finance, or hospitality. At a minimum, should have a relevant undergraduate degree, served in a leading capacity on five completed projects (including at least three with an initial time frame in excess of 24 months), have technical training as needed (Microsoft Office, financial modeling, etc.), and have at least 15 years of experience in the hospitality industry sufficient to demonstrate this capability.
2 Senior VP Relevant undergraduate degree, such as business, finance, or hospitality. At a minimum, should have a relevant undergraduate degree, served in a leading capacity on four completed projects (including at least two with an initial time frame in excess of 24 months), have technical training as needed (Microsoft Office, financial modeling, etc.), and have at least 10 years of experience in the hospitality industry sufficient to demonstrate this capability.
| 3 | VP/Project Manager | Relevant undergraduate degree, such as business, finance, or hospitality. | At a minimum, should have a relevant undergraduate degree, have served in a leading capacity on three completed projects (including at least one with an initial time frame in excess of 24 months), have technical training as needed (Microsoft Office, financial modeling, etc.), and have experience in the hospitality industry sufficient to demonstrate this capability. |
| 4 | Senior Associate | Relevant undergraduate degree, such as business, finance, or hospitality. | At a minimum, should have a relevant undergraduate degree, have served in a leading capacity on two completed projects (including at least one with an initial time frame in excess of 24 months), have technical training as needed (Microsoft Office, financial modeling, etc.), and have relevant experience in the hospitality industry sufficient to demonstrate this capability. |
| 5 | Associate | Relevant undergraduate degree, such as business, finance, or hospitality. | At a minimum, should have a relevant undergraduate degree and have two years experience in the hospitality or relevant industry sufficient to demonstrate this capability. |
| 6 | Assistant | High school diploma or equivalent. | At a minimum, should have a relevant undergraduate degree or have experience in a relevant industry sufficient to demonstrate this capability. |
| 7 | Subject Matter Expert-Personal Property Appraiser | Relevant undergraduate degree or appropriate certifications | At a minimum, should have a relevant undergraduate degree or appropriate certifications, and have technical expertise and experience in the relevant industry sufficient to demonstrate this capability. |
| 8 | Subject Matter Expert-Food and Beverage Services | Relevant undergraduate degree or appropriate certifications | At a minimum, should have a relevant undergraduate degree or appropriate certifications, and have technical expertise and experience in the relevant industry sufficient to demonstrate this capability. |
| 9 | Subject Matter Expert-Marina Services | Relevant undergraduate degree or appropriate certifications | At a minimum, should have a relevant undergraduate degree or appropriate certifications, and have technical expertise and experience in the relevant industry sufficient to demonstrate this capability. |
| 10 | Subject Matter Expert-Recreation, Tour and Backcountry Service | Relevant undergraduate degree or appropriate certifications | At a minimum, should have a relevant undergraduate degree or appropriate certifications, and have technical expertise and experience in the relevant industry sufficient to demonstrate this capability. |
| 11 | Subject Matter Expert-Transportation and Vessel Services | Relevant undergraduate degree or appropriate certifications | At a minimum, should have a relevant undergraduate degree or appropriate certifications, and have technical expertise and experience in the relevant industry sufficient to demonstrate this capability. |
| 12 | Subject Matter Expert-Retail Services | Relevant undergraduate degree or appropriate certifications | At a minimum, should have a relevant undergraduate degree or appropriate certifications, and have technical expertise and experience in the relevant industry sufficient to demonstrate this capability. |
EXAMPLE TASK ORDER
| Example Task Order Pricing (Labor Only) | |||||||||||||||||||||||
| Use Labor Rates for Base Ordering Period 1. It is not necessary to use all the labor categories for the example task order pricing. | |||||||||||||||||||||||
| Category ID # | Labor Category Title | Houly Labor Rate | Hours Task 1 | Task 1 Total | Hours Task 2 | Task 2 Total | Hours Task 3 | Task 3 Total | Hours Task 4 | Task 4 Total | Hours Task 5 | Task 5 Total | Hours Task 6 | Task 6 Total | Hours Task 7 | Task 7 Total | Hours Task 8 | Task 8 Total | Hours Task 9 | Task 9 Total | Hours Task 10 | Task 10 Total | Total Task Order |
| 1 | Executive/Senior VP | $ - 0 | 10 | $ - 0 | 3 | $ - 0 | 3 | $ - 0 | 4 | $ - 0 | 15 | $ - 0 | 5 | $ - 0 | 8 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | $ - 0 |
| 2 | Senior VP | $ - 0 | 21 | $ - 0 | 23 | $ - 0 | 20 | $ - 0 | 8 | $ - 0 | 60 | $ - 0 | 22 | $ - 0 | 21 | $ - 0 | 12 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | $ - 0 |
| 3 | VP/Project Manager | $ - 0 | 21 | $ - 0 | 23 | $ - 0 | 20 | $ - 0 | 8 | $ - 0 | 60 | $ - 0 | 22 | $ - 0 | 21 | $ - 0 | 12 | $ - 0 | 2 | $ - 0 | 20 | $ - 0 | $ - 0 |
| 4 | Senior Associate - Lead Financial Analyst | $ - 0 | 21 | $ - 0 | 23 | $ - 0 | 20 | $ - 0 | 8 | $ - 0 | 60 | $ - 0 | 22 | $ - 0 | 21 | $ - 0 | 12 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | $ - 0 |
| 5 | Associate | $ - 0 | 10 | $ - 0 | 14 | $ - 0 | 12 | $ - 0 | 5 | $ - 0 | 24 | $ - 0 | 12 | $ - 0 | 12 | $ - 0 | 7 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | $ - 0 |
| 6 | Assistant | $ - 0 | 10 | $ - 0 | 14 | $ - 0 | 12 | $ - 0 | 5 | $ - 0 | 24 | $ - 0 | 12 | $ - 0 | 12 | $ - 0 | 7 | $ - 0 | 2 | $ - 0 | 0 | $ - 0 | $ - 0 |
| 7 | Subject Matter Expert-Personal Property Appraiser | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 80 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | $ - 0 |
| 8 | Subject Matter Expert-Food and Beverage Services | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 1 | $ - 0 | 1 | $ - 0 | 8 | $ - 0 | 1 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | $ - 0 |
| 9 | Subject Matter Expert-Marina Services | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 1 | $ - 0 | 1 | $ - 0 | 8 | $ - 0 | 1 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | $ - 0 |
| 10 | Subject Matter Expert-Recreation, Tour and Backcountry Service | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 1 | $ - 0 | 1 | $ - 0 | 8 | $ - 0 | 1 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | $ - 0 |
| 11 | Subject Matter Expert-Transportation and Vessel Services | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 1 | $ - 0 | 1 | $ - 0 | 8 | $ - 0 | 1 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | $ - 0 |
| 12 | Subject Matter Expert-Retail Services | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 1 | $ - 0 | 1 | $ - 0 | 8 | $ - 0 | 1 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | $ - 0 |
| TOTAL | $ - 0 |
IDIQ
| PRICE SCHEDULE | |||||
| All labor hours are estimates. | |||||
| If proposing different labor categories than listed below, please provide a rationale for each labor category that is different from those below. | |||||
| BASE YEAR | |||||
| Category ID # | Labor Category Title | Hourly Labor Rate Range | Labor Category Title | Rate | |
| 1 | Executive/Senior VP | $ 386.42 | $ 281.88 | Executive/Senior VP | |
| 2 | Senior VP | $ 340.30 | $ 219.35 | Senior V/P | |
| 3 | VP/Project Manager | ||||
| 4 | Senior Associate - Lead Financial Analyst | ||||
| 5 | Associate | $ 213.20 | $ 132.23 | Associate | |
| 6 | Assistant | ||||
| 7 | Subject Matter Expert-Personal Property Appraiser | $ 241.90 | $ 155.80 | Subject Matter Exerpert (SME) - Personal Property Appraiser | |
| 8 | SME - Food and Beverage Services | ||||
| 9 | SME - Marina Services | ||||
| 10 | SME - Expert-Recreation, Tour and Backcountry Service | ||||
| 11 | SME- Transportation and Vessel Services | ||||
| 12 | SME - Retail Services |
| ORERING PERIOD ONE | |||||
| Category ID # | Labor Category Title | Hourly Labor Rate Range | Labor Category Title | Rate | |
| 1 | Executive/Senior VP | $ 386.42 | $ 281.88 | Executive/Senior VP | |
| 2 | Senior VP | $ 340.30 | $ 219.35 | Senior V/P | |
| 3 | VP/Project Manager | ||||
| 4 | Senior Associate - Lead Financial Analyst | ||||
| 5 | Associate | $ 213.20 | $ 132.23 | Associate | |
| 6 | Assistant | ||||
| 7 | Subject Matter Expert-Personal Property Appraiser | $ 241.90 | $ 155.80 | Subject Matter Exerpert (SME) - Personal Property Appraiser | |
| 8 | SME - Food and Beverage Services | ||||
| 9 | SME - Marina Services | ||||
| 10 | SME - Expert-Recreation, Tour and Backcountry Service | ||||
| 11 | SME- Transportation and Vessel Services | ||||
| 12 | SME - Retail Services |
| ORDERING PERIOD TWO | |||||
| Category ID # | Labor Category Title | Hourly Labor Rate Range | Labor Category Title | Rate | |
| 1 | Executive/Senior VP | $ 386.42 | $ 281.88 | Executive/Senior VP | |
| 2 | Senior VP | $ 340.30 | $ 219.35 | Senior V/P | |
| 3 | VP/Project Manager | ||||
| 4 | Senior Associate - Lead Financial Analyst | ||||
| 5 | Associate | $ 213.20 | $ 132.23 | Associate | |
| 6 | Assistant | ||||
| 7 | Subject Matter Expert-Personal Property Appraiser | $ 241.90 | $ 155.80 | Subject Matter Exerpert (SME) - Personal Property Appraiser | |
| 8 | SME - Food and Beverage Services | ||||
| 9 | SME - Marina Services | ||||
| 10 | SME - Expert-Recreation, Tour and Backcountry Service | ||||
| 11 | SME- Transportation and Vessel Services | ||||
| 12 | SME - Retail Services |
| ORDERING PERIOD THREE | |||||
| Category ID # | Labor Category Title | Hourly Labor Rate Range | Labor Category Title | Rate | |
| 1 | Executive/Senior VP | $ 386.42 | $ 281.88 | Executive/Senior VP | |
| 2 | Senior VP | $ 340.30 | $ 219.35 | Senior V/P | |
| 3 | VP/Project Manager | ||||
| 4 | Senior Associate - Lead Financial Analyst | ||||
| 5 | Associate | $ 213.20 | $ 132.23 | Associate | |
| 6 | Assistant | ||||
| 7 | Subject Matter Expert-Personal Property Appraiser | $ 241.90 | $ 155.80 | Subject Matter Exerpert (SME) - Personal Property Appraiser | |
| 8 | SME - Food and Beverage Services | ||||
| 9 | SME - Marina Services | ||||
| 10 | SME - Expert-Recreation, Tour and Backcountry Service | ||||
| 11 | SME- Transportation and Vessel Services | ||||
| 12 | SME - Retail Services |
| ORDERING PERIOD FOUR | |||||
| Category ID # | Labor Category Title | Hourly Labor Rate Range | Labor Category Title | Rate | |
| 1 | Executive/Senior VP | $ 386.42 | $ 281.88 | Executive/Senior VP | |
| 2 | Senior VP | $ 340.30 | $ 219.35 | Senior V/P | |
| 3 | VP/Project Manager | ||||
| 4 | Senior Associate - Lead Financial Analyst | ||||
| 5 | Associate | $ 213.20 | $ 132.23 | Associate | |
| 6 | Assistant | ||||
| 7 | Subject Matter Expert-Personal Property Appraiser | $ 241.90 | $ 155.80 | Subject Matter Exerpert (SME) - Personal Property Appraiser | |
| 8 | SME - Food and Beverage Services | ||||
| 9 | SME - Marina Services | ||||
| 10 | SME - Expert-Recreation, Tour and Backcountry Service | ||||
| 11 | SME- Transportation and Vessel Services | ||||
| 12 | SME - Retail Services |
TOTAL HOURS
| ORDERING PERIOD SIX MONTH EXTENSION | |||||
| Category ID # | Labor Category Title | Hourly Labor Rate Range | Labor Category Title | Rate | |
| 1 | Executive/Senior VP | $ 386.42 | $ 281.88 | Executive/Senior VP | |
| 2 | Senior VP | $ 340.30 | $ 219.35 | Senior V/P | |
| 3 | VP/Project Manager | ||||
| 4 | Senior Associate - Lead Financial Analyst | ||||
| 5 | Associate | $ 213.20 | $ 132.23 | Associate | |
| 6 | Assistant | ||||
| 7 | Subject Matter Expert-Personal Property Appraiser | $ 241.90 | $ 155.80 | Subject Matter Exerpert (SME) - Personal Property Appraiser | |
| 8 | SME - Food and Beverage Services | ||||
| 9 | SME - Marina Services | ||||
| 10 | SME - Expert-Recreation, Tour and Backcountry Service | ||||
| 11 | SME- Transportation and Vessel Services | ||||
| 12 | SME - Retail Services | ||||
| TOTAL HOURS |
File details come from the government source that posted it. Updated .