B08_Attachment_2_Price_Schedule.xlsx

XLSX spreadsheet 41 KB Posted Feb 3, 2025

Attached to: Prospectus Develpment IDIQ Firm Fixed Price
Solicitation number: 140P2125Q0008
Issued by: Department of the Interior National Park Service National Office

About this file

Written by GovTribe AI · Feb 3, 2025

This is a pricing schedule spreadsheet template for a National Park Service IDIQ contract for prospectus development services. The document outlines 10 key tasks including project due diligence, market analysis, rate studies, property valuation, financial analysis, prospectus development, and panel support. It defines 12 labor categories ranging from Executive/Senior VP to various Subject Matter Experts (SMEs) in areas like personal property appraisal, food services, marina services, recreation, transportation, and retail.

The template provides hourly labor rate ranges (Executive/Senior VP: $281.88-$386.42; Senior VP: $219.35-$340.30) and estimated hours per task across a base year and four ordering periods plus a six-month extension option. Each ordering period anticipates approximately 465-1,415 total hours per task grouping. The spreadsheet includes detailed minimum education and experience requirements for each labor category, such as relevant undergraduate degrees and specific years of industry experience. Contractors may propose different labor categories or hours but must provide rationale for any changes from the template estimates.

View the file

Other files

File	Type	Posted
Sol_140P2125Q0008_Amd_0001.pdf	PDF	Feb 25, 2025
Solicitation_140P2125Q0008_Questions_and_Answers_0001.pdf	PDF	Feb 25, 2025
B08_Attachment_2_Price_Schedule_Post_Q_A_2_24_25_0001.xlsx	XLSX spreadsheet	Feb 25, 2025
Attachment_06-B08-Example_Task_Order_Scope_of_Work_Post_Q_A_2_24_25_0001.docx	DOCX document	Feb 25, 2025
B08_Attachment_1_PWS_IDIQ.pdf	PDF	Feb 3, 2025
B04_Attachment_6_EVALUATION_FACTORS_TABLE.pdf	PDF	Feb 3, 2025
B08_Attachment_4_Example_Task_Order_Deliverable_Timeline_and_Payment_Schedule.xlsx	XLSX spreadsheet	Feb 3, 2025
B08_Attachment_5_Past_Perf__Questionnaire.pdf	PDF	Feb 3, 2025
B08_Attachment_03_Example_Task_Order_.pdf	PDF	Feb 3, 2025
Sol_140P2125Q0008.pdf	PDF	Feb 3, 2025

On GovTribe

Work with this file

Download the original file
Contacts named in this file
Similar government files
Ask GovTribe AI about this file

Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

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

**NOTE TO CONTRACTORS** All hours and labor categories are estimates only. You may adjust the hours/labo categories but must provide rationale as to why you have selected different hours/labor categories.

IDIQ

PRICE SCHEDULE
				All labor hours are estimates.
				If proposing different labor categories or labor hours than listed below, please provide a rationale for each labor category that is different from those below.
BASE YEAR							Anticipated Hours Per Task Annually - Subject to Change
Category ID #	Labor Category Title	Hourly Labor Rate Range		Labor Category Title	Rate		Task 1	Task 2	Task 3	Task 4	Task 5	Task 6	Task 7	Task 8	Task 9	Task 10	PROPOSED COST
1	Executive/Senior VP	$ 386.42	$ 281.88	Executive/Senior VP			10	3	3	4	15	5	8	0	0	0	ERROR:#VALUE!
2	Senior VP	$ 340.30	$ 219.35	Senior V/P			21	23	20	8	60	22	21	12	0	0	$0.00
3				VP/Project Manager			21	23	20	8	60	22	21	12	2	20	$0.00
4				Senior Associate - Lead Financial Analyst			21	23	20	8	60	22	21	12	0	0	$0.00
5	Associate	$ 213.20	$ 132.23	Associate			10	14	12	5	24	12	12	7	0	0	$0.00
6				Assistant			10	14	12	5	24	12	12	7	2	0	$0.00
7	Subject Matter Expert-Personal Property Appraiser	$ 241.90	$ 155.80	Subject Matter Exerpert (SME) - Personal Property Appraiser			0	0	0	80	0	0	0	0	0	0	$0.00
8				SME - Food and Beverage Services			0	0	1	1	8	1	0	0	0	0	$0.00
9				SME - Marina Services			0	0	1	1	8	1	0	0	0	0	$0.00
10				SME - Expert-Recreation, Tour and Backcountry Service			0	0	1	1	8	1	0	0	0	0	$0.00
11				SME- Transportation and Vessel Services			0	0	1	1	8	1	0	0	0	0	$0.00
12				SME - Retail Services			0	0	1	1	8	1	0	0	0	0	$0.00
						Total	93	100	90	121	267	98				20	$0.00

ORERING PERIOD ONE							Anticipated Hours Per Task Annually - Subject to Change
Category ID #	Labor Category Title	Hourly Labor Rate Range		Labor Category Title	Rate		Task 1	Task 2	Task 3	Task 4	Task 5	Task 6	Task 7	Task 8	Task 9	Task 10	PROPOSED COST
1	Executive/Senior VP	$ 386.42	$ 281.88	Executive/Senior VP			10	3	3	4	15	5	8	0	0	0	$0.00
2	Senior VP	$ 340.30	$ 219.35	Senior V/P			21	23	20	8	60	22	21	12	0	0	$0.00
3				VP/Project Manager			21	23	20	8	60	22	21	12	2	20	$0.00
4				Senior Associate - Lead Financial Analyst			21	23	20	8	60	22	21	12	0	0	$0.00
5	Associate	$ 213.20	$ 132.23	Associate			10	14	12	5	24	12	12	7	0	0	$0.00
6				Assistant			10	14	12	5	24	12	12	7	2	0	$0.00
7	Subject Matter Expert-Personal Property Appraiser	$ 241.90	$ 155.80	Subject Matter Exerpert (SME) - Personal Property Appraiser			0	0	0	80	0	0	0	0	0	0	$0.00
8				SME - Food and Beverage Services			0	0	1	1	8	1	0	0	0	0	$0.00
9				SME - Marina Services			0	0	1	1	8	1	0	0	0	0	$0.00
10				SME - Expert-Recreation, Tour and Backcountry Service			0	0	1	1	8	1	0	0	0	0	$0.00
11				SME- Transportation and Vessel Services			0	0	1	1	8	1	0	0	0	0	$0.00
12				SME - Retail Services			0	0	1	1	8	1	0	0	0	0	$0.00
						Total	93	100	88	119	251	96				20	$0.00

ORDERING PERIOD TWO							Anticipated Hours Per Task Annually - Subject to Change
Category ID #	Labor Category Title	Hourly Labor Rate Range		Labor Category Title	Rate		Task 1	Task 2	Task 3	Task 4	Task 5	Task 6	Task 7	Task 8	Task 9	Task 10	PROPOSED COST
1	Executive/Senior VP	$ 386.42	$ 281.88	Executive/Senior VP			10	3	3	4	15	5	8	0	0	0	$0.00
2	Senior VP	$ 340.30	$ 219.35	Senior V/P			21	23	20	8	60	22	21	12	0	0	$0.00
3				VP/Project Manager			21	23	20	8	60	22	21	12	2	20	$0.00
4				Senior Associate - Lead Financial Analyst			21	23	20	8	60	22	21	12	0	0	$0.00
5	Associate	$ 213.20	$ 132.23	Associate			10	14	12	5	24	12	12	7	0	0	$0.00
6				Assistant			10	14	12	5	24	12	12	7	2	0	$0.00
7	Subject Matter Expert-Personal Property Appraiser	$ 241.90	$ 155.80	Subject Matter Exerpert (SME) - Personal Property Appraiser			0	0	0	80	0	0	0	0	0	0	$0.00
8				SME - Food and Beverage Services			0	0	1	1	8	1	0	0	0	0	$0.00
9				SME - Marina Services			0	0	1	1	8	1	0	0	0	0	$0.00
10				SME - Expert-Recreation, Tour and Backcountry Service			0	0	1	1	8	1	0	0	0	0	$0.00
11				SME- Transportation and Vessel Services			0	0	1	1	8	1	0	0	0	0	$0.00
12				SME - Retail Services			0	0	1	1	8	1	0	0	0	0	$0.00
						Total	93	100	92	123	283	100				20	$0.00

ORDERING PERIOD THREE							Anticipated Hours Per Task Annually - Subject to Change
Category ID #	Labor Category Title	Hourly Labor Rate Range		Labor Category Title	Rate		Task 1	Task 2	Task 3	Task 4	Task 5	Task 6	Task 7	Task 8	Task 9	Task 10	PROPOSED COST
1	Executive/Senior VP	$ 386.42	$ 281.88	Executive/Senior VP			10	3	3	4	15	5	8	0	0	0	$0.00
2	Senior VP	$ 340.30	$ 219.35	Senior V/P			21	23	20	8	60	22	21	12	0	0	$0.00
3				VP/Project Manager			21	23	20	8	60	22	21	12	2	20	$0.00
4				Senior Associate - Lead Financial Analyst			21	23	20	8	60	22	21	12	0	0	$0.00
5	Associate	$ 213.20	$ 132.23	Associate			10	14	12	5	24	12	12	7	0	0	$0.00
6				Assistant			10	14	12	5	24	12	12	7	2	0	$0.00
7	Subject Matter Expert-Personal Property Appraiser	$ 241.90	$ 155.80	Subject Matter Exerpert (SME) - Personal Property Appraiser			0	0	0	80	0	0	0	0	0	0	$0.00
8				SME - Food and Beverage Services			0	0	1	1	8	1	0	0	0	0	$0.00
9				SME - Marina Services			0	0	1	1	8	1	0	0	0	0	$0.00
10				SME - Expert-Recreation, Tour and Backcountry Service			0	0	1	1	8	1	0	0	0	0	$0.00
11				SME- Transportation and Vessel Services			0	0	1	1	8	1	0	0	0	0	$0.00
12				SME - Retail Services			0	0	1	1	8	1	0	0	0	0	$0.00
						Total	93	100	92	123	283	100				20	$0.00

ORDERING PERIOD FOUR							Anticipated Hours Per Task Annually - Subject to Change
Category ID #	Labor Category Title	Hourly Labor Rate Range		Labor Category Title	Rate		Task 1	Task 2	Task 3	Task 4	Task 5	Task 6	Task 7	Task 8	Task 9	Task 10	PROPOSED COST
1	Executive/Senior VP	$ 386.42	$ 281.88	Executive/Senior VP			10	3	3	4	15	5	8	0	0	0	$0.00
2	Senior VP	$ 340.30	$ 219.35	Senior V/P			21	23	20	8	60	22	21	12	0	0	$0.00
3				VP/Project Manager			21	23	20	8	60	22	21	12	2	20	$0.00
4				Senior Associate - Lead Financial Analyst			21	23	20	8	60	22	21	12	0	0	$0.00
5	Associate	$ 213.20	$ 132.23	Associate			10	14	12	5	24	12	12	7	0	0	$0.00
6				Assistant			10	14	12	5	24	12	12	7	2	0	$0.00
7	Subject Matter Expert-Personal Property Appraiser	$ 241.90	$ 155.80	Subject Matter Exerpert (SME) - Personal Property Appraiser			0	0	0	80	0	0	0	0	0	0	$0.00
8				SME - Food and Beverage Services			0	0	1	1	8	1	0	0	0	0	$0.00
9				SME - Marina Services			0	0	1	1	8	1	0	0	0	0	$0.00
10				SME - Expert-Recreation, Tour and Backcountry Service			0	0	1	1	8	1	0	0	0	0	$0.00
11				SME- Transportation and Vessel Services			0	0	1	1	8	1	0	0	0	0	$0.00
12				SME - Retail Services			0	0	1	1	8	1	0	0	0	0	$0.00
						Total	93	100	92	123	283	100				20	$0.00
																	TOTAL PROPOSED COST
					TOTAL HOURS		465	500	460	615	1415	500				100	$0.00

ORDERING PERIOD SIX MONTH EXTENSION							Anticipated Hours Per Task Annually - Subject to Change
Category ID #	Labor Category Title	Hourly Labor Rate Range		Labor Category Title	Rate		Task 1	Task 2	Task 3	Task 4	Task 5	Task 6	Task 7	Task 8	Task 9	Task 10	PROPOSED COST
1	Executive/Senior VP	$ 386.42	$ 281.88	Executive/Senior VP			10	3	3	4	15	5	8	0	0	0	$0.00
2	Senior VP	$ 340.30	$ 219.35	Senior V/P			21	23	20	8	60	22	21	12	0	0	$0.00
3				VP/Project Manager			21	23	20	8	60	22	21	12	2	20	$0.00
4				Senior Associate - Lead Financial Analyst			21	23	20	8	60	22	21	12	0	0	$0.00
5	Associate	$ 213.20	$ 132.23	Associate			10	14	12	5	24	12	12	7	0	0	$0.00
6				Assistant			10	14	12	5	24	12	12	7	2	0	$0.00
7	Subject Matter Expert-Personal Property Appraiser	$ 241.90	$ 155.80	Subject Matter Exerpert (SME) - Personal Property Appraiser			0	0	0	80	0	0	0	0	0	0	$0.00
8				SME - Food and Beverage Services			0	0	1	1	8	1	0	0	0	0	$0.00
9				SME - Marina Services			0	0	1	1	8	1	0	0	0	0	$0.00
10				SME - Expert-Recreation, Tour and Backcountry Service			0	0	1	1	8	1	0	0	0	0	$0.00
11				SME- Transportation and Vessel Services			0	0	1	1	8	1	0	0	0	0	$0.00
12				SME - Retail Services			0	0	1	1	8	1	0	0	0	0	$0.00
						Total	93	100	92	123	283	100				20	$0.00
																	TOTAL PROPOSED COST
					TOTAL HOURS		465	500	460	615	1415	500				100	$0.00

File details come from the government source that posted it. Updated Feb 3, 2025.