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
Issued by

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 TITLETASK NUMBERTASK DEFINITION SUMMARY*
Project Due Diligence1Introductory 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 Analysis2Market overview.
Operational perormance overview.
Recommendations and conclusions.
Rate Study3List of comparables.
Rate study.
Personal Property Valuation4Personal Property Valuation and Replacement Schedule
Cost estimates.
Financial Investment Analysis and Scenario Meeting5Baseline buildup.
Financial model.
Scenario Meeting
Executive summary and insurance requirements
Franchise Fee Analysis Report
Initial Prospectus Development6Draft prospectus documents - Alternative 6A (Most Prospectus Documents)
Roundtable Meeting Preparation and Execution7Roundtable Meeting Preparation and Draft 2 Prospectus Documents
Roundtable Meeting Attendance
Post-Roundtable memo.
Final Draft Prospectus Documents8Final draft prospectus documents.
Panel Support9One week panel.
Additional Scenario Analysis10One 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 SuppliesQtyUnit
0001NPS Commercial Services Prospectus Development1Job
Labor Categories
Category ID #Labor Category TitleMinimum Level EducationMinimum 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.

3VP/Project ManagerRelevant 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.
4Senior AssociateRelevant 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.
5AssociateRelevant 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.
6AssistantHigh 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.
7Subject Matter Expert-Personal Property AppraiserRelevant undergraduate degree or appropriate certificationsAt 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.
8Subject Matter Expert-Food and Beverage ServicesRelevant undergraduate degree or appropriate certificationsAt 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.
9Subject Matter Expert-Marina ServicesRelevant undergraduate degree or appropriate certificationsAt 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.
10Subject Matter Expert-Recreation, Tour and Backcountry ServiceRelevant undergraduate degree or appropriate certificationsAt 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.
11Subject Matter Expert-Transportation and Vessel ServicesRelevant undergraduate degree or appropriate certificationsAt 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.
12Subject Matter Expert-Retail ServicesRelevant undergraduate degree or appropriate certificationsAt 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 TitleHouly Labor RateHours Task 1Task 1 TotalHours Task 2Task 2 TotalHours Task 3Task 3 TotalHours Task 4Task 4 TotalHours Task 5Task 5 TotalHours Task 6Task 6 TotalHours Task 7Task 7 TotalHours Task 8Task 8 TotalHours Task 9Task 9 TotalHours Task 10Task 10 TotalTotal Task Order
1Executive/Senior VP$ - 010$ - 03$ - 03$ - 04$ - 015$ - 05$ - 08$ - 00$ - 00$ - 00$ - 0$ - 0
2Senior VP$ - 021$ - 023$ - 020$ - 08$ - 060$ - 022$ - 021$ - 012$ - 00$ - 00$ - 0$ - 0
3VP/Project Manager$ - 021$ - 023$ - 020$ - 08$ - 060$ - 022$ - 021$ - 012$ - 02$ - 020$ - 0$ - 0
4Senior Associate - Lead Financial Analyst$ - 021$ - 023$ - 020$ - 08$ - 060$ - 022$ - 021$ - 012$ - 00$ - 00$ - 0$ - 0
5Associate$ - 010$ - 014$ - 012$ - 05$ - 024$ - 012$ - 012$ - 07$ - 00$ - 00$ - 0$ - 0
6Assistant$ - 010$ - 014$ - 012$ - 05$ - 024$ - 012$ - 012$ - 07$ - 02$ - 00$ - 0$ - 0
7Subject Matter Expert-Personal Property Appraiser$ - 00$ - 00$ - 00$ - 080$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0$ - 0
8Subject Matter Expert-Food and Beverage Services$ - 00$ - 00$ - 01$ - 01$ - 08$ - 01$ - 00$ - 00$ - 00$ - 00$ - 0$ - 0
9Subject Matter Expert-Marina Services$ - 00$ - 00$ - 01$ - 01$ - 08$ - 01$ - 00$ - 00$ - 00$ - 00$ - 0$ - 0
10Subject Matter Expert-Recreation, Tour and Backcountry Service$ - 00$ - 00$ - 01$ - 01$ - 08$ - 01$ - 00$ - 00$ - 00$ - 00$ - 0$ - 0
11Subject Matter Expert-Transportation and Vessel Services$ - 00$ - 00$ - 01$ - 01$ - 08$ - 01$ - 00$ - 00$ - 00$ - 00$ - 0$ - 0
12Subject Matter Expert-Retail Services$ - 00$ - 00$ - 01$ - 01$ - 08$ - 01$ - 00$ - 00$ - 00$ - 00$ - 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 TitleHourly Labor Rate RangeLabor Category TitleRate
1Executive/Senior VP$ 386.42$ 281.88Executive/Senior VP
2Senior VP$ 340.30$ 219.35Senior V/P
3VP/Project Manager
4Senior Associate - Lead Financial Analyst
5Associate$ 213.20$ 132.23Associate
6Assistant
7Subject Matter Expert-Personal Property Appraiser$ 241.90$ 155.80Subject Matter Exerpert (SME) - Personal Property Appraiser
8SME - Food and Beverage Services
9SME - Marina Services
10SME - Expert-Recreation, Tour and Backcountry Service
11SME- Transportation and Vessel Services
12SME - Retail Services
ORERING PERIOD ONE
Category ID #Labor Category TitleHourly Labor Rate RangeLabor Category TitleRate
1Executive/Senior VP$ 386.42$ 281.88Executive/Senior VP
2Senior VP$ 340.30$ 219.35Senior V/P
3VP/Project Manager
4Senior Associate - Lead Financial Analyst
5Associate$ 213.20$ 132.23Associate
6Assistant
7Subject Matter Expert-Personal Property Appraiser$ 241.90$ 155.80Subject Matter Exerpert (SME) - Personal Property Appraiser
8SME - Food and Beverage Services
9SME - Marina Services
10SME - Expert-Recreation, Tour and Backcountry Service
11SME- Transportation and Vessel Services
12SME - Retail Services
ORDERING PERIOD TWO
Category ID #Labor Category TitleHourly Labor Rate RangeLabor Category TitleRate
1Executive/Senior VP$ 386.42$ 281.88Executive/Senior VP
2Senior VP$ 340.30$ 219.35Senior V/P
3VP/Project Manager
4Senior Associate - Lead Financial Analyst
5Associate$ 213.20$ 132.23Associate
6Assistant
7Subject Matter Expert-Personal Property Appraiser$ 241.90$ 155.80Subject Matter Exerpert (SME) - Personal Property Appraiser
8SME - Food and Beverage Services
9SME - Marina Services
10SME - Expert-Recreation, Tour and Backcountry Service
11SME- Transportation and Vessel Services
12SME - Retail Services
ORDERING PERIOD THREE
Category ID #Labor Category TitleHourly Labor Rate RangeLabor Category TitleRate
1Executive/Senior VP$ 386.42$ 281.88Executive/Senior VP
2Senior VP$ 340.30$ 219.35Senior V/P
3VP/Project Manager
4Senior Associate - Lead Financial Analyst
5Associate$ 213.20$ 132.23Associate
6Assistant
7Subject Matter Expert-Personal Property Appraiser$ 241.90$ 155.80Subject Matter Exerpert (SME) - Personal Property Appraiser
8SME - Food and Beverage Services
9SME - Marina Services
10SME - Expert-Recreation, Tour and Backcountry Service
11SME- Transportation and Vessel Services
12SME - Retail Services
ORDERING PERIOD FOUR
Category ID #Labor Category TitleHourly Labor Rate RangeLabor Category TitleRate
1Executive/Senior VP$ 386.42$ 281.88Executive/Senior VP
2Senior VP$ 340.30$ 219.35Senior V/P
3VP/Project Manager
4Senior Associate - Lead Financial Analyst
5Associate$ 213.20$ 132.23Associate
6Assistant
7Subject Matter Expert-Personal Property Appraiser$ 241.90$ 155.80Subject Matter Exerpert (SME) - Personal Property Appraiser
8SME - Food and Beverage Services
9SME - Marina Services
10SME - Expert-Recreation, Tour and Backcountry Service
11SME- Transportation and Vessel Services
12SME - Retail Services

TOTAL HOURS

ORDERING PERIOD SIX MONTH EXTENSION
Category ID #Labor Category TitleHourly Labor Rate RangeLabor Category TitleRate
1Executive/Senior VP$ 386.42$ 281.88Executive/Senior VP
2Senior VP$ 340.30$ 219.35Senior V/P
3VP/Project Manager
4Senior Associate - Lead Financial Analyst
5Associate$ 213.20$ 132.23Associate
6Assistant
7Subject Matter Expert-Personal Property Appraiser$ 241.90$ 155.80Subject Matter Exerpert (SME) - Personal Property Appraiser
8SME - Food and Beverage Services
9SME - Marina Services
10SME - Expert-Recreation, Tour and Backcountry Service
11SME- Transportation and Vessel Services
12SME - Retail Services
TOTAL HOURS

File details come from the government source that posted it. Updated .