B08_Attachment_4_Example_Task_Order_Deliverable_Timeline_and_Payment_Schedule.xlsx

XLSX spreadsheet 28 KB Posted

Attached to
Prospectus Develpment IDIQ Firm Fixed Price
Solicitation number
140P2125Q0008
Issued by

About this file

Written by GovTribe AI ·

This file is a detailed deliverable timeline and payment schedule spreadsheet for a National Park Service (NPS) concessions contract development project running from April 2025 to December 2026. The timeline breaks down 10 major tasks: Project Planning, Market Analysis, Rate Comparability Study, Personal Property Valuation, Financial Investment Analysis, Initial Prospectus Development, Roundtable Meeting, Final Prospectus Documents, Panel Support, and Additional Scenario Analysis (optional).

The schedule includes specific payment percentages tied to deliverables within each task, with major milestones including a site visit (Task 1, 75% payment), market analysis report (Task 2, 75% for draft), personal property valuation report (Task 4, 70% for draft), and financial investment analysis (Task 5, multiple payments). The timeline incorporates review periods by NPS, typically 2-4 weeks per deliverable, and includes both virtual and in-person meetings. Optional travel components are noted for scenario meetings and panel evaluations. Each task has specific deliverable requirements including reports, Excel workbooks, presentations, and memos, with clearly defined turnaround times ranging from 5 to 20 business days.

View the file

Other files

File Type Posted
Sol_140P2125Q0008_Amd_0001.pdf PDF
Solicitation_140P2125Q0008_Questions_and_Answers_0001.pdf PDF
B08_Attachment_2_Price_Schedule_Post_Q_A_2_24_25_0001.xlsx XLSX spreadsheet
Attachment_06-B08-Example_Task_Order_Scope_of_Work_Post_Q_A_2_24_25_0001.docx DOCX document
B08_Attachment_1_PWS_IDIQ.pdf PDF
B04_Attachment_6_EVALUATION_FACTORS_TABLE.pdf PDF
B08_Attachment_2_Price_Schedule.xlsx XLSX spreadsheet
B08_Attachment_5_Past_Perf__Questionnaire.pdf PDF
B08_Attachment_03_Example_Task_Order_.pdf PDF
Sol_140P2125Q0008.pdf PDF

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.

Example Deliverable Timeline

Task NameDeliverable TypePayment Schedule (% based per task)Start DateEnd DateDuration (weeks)Deliverable Timing
Project Planning
Task 1: Planning and Due Diligence
Introductory MeetingVirtual MeetingMonday, April 21, 2025Friday, April 25, 202511-2 hour call occurs within 2 weeks (10 business days) of task order award.
Draft Advanced Information Request (AIR), Daily Fieldwork Schedule, Site Visit Presentation/AgendaMemo and Presentation20%Monday, April 28, 2025Friday, May 02, 20251The consultant will submit the AIR, cover letter, and Daily Fieldwork Schedule within 1 week (5 business days) after the Introductory Meeting.
NPS Review of AIR, Fieldwork Schedule, and Site Visit Presentation/AgendaMonday, May 05, 2025Friday, May 09, 202511 week (5 business days) to review the draft AIR, fieldwork schedule and site visit presentation/agenda.
Final AIR and Fieldwork ScheduleMemo and Presentation5%Monday, May 12, 2025Friday, May 16, 20251The consultant will have 1 week (5 business days) to incorporate NPS comments, issue a final Daily Fieldwork Schedule and Presentation/Agenda, and send the AIR and cover letter to existing concessioner.
Site Visit w/ Fieldwork Kick-off PresentationMeeting/Presentation5%Monday, May 19, 2025Friday, May 23, 20251The consultant will incorporate NPS comments and be prepared to present the finale at the kick-off meeting.
Site Visit Exit BriefingMeeting/Presentation75% + travelMonday, May 19, 2025Friday, May 23, 20251This can be done onsite or remotely on a later date if needed. The consultant will provide a copy to the COR.
NPS/Concessioner AIR ResponseMonday, May 26, 2025Friday, June 13, 20253The consultant will submit information collected from the AIR, 3 weeks (15 business days) following the Fieldwork Exit Briefing.
Task 2: Market Analysis
Draft Market AnalysisReport75%Monday, May 26, 2025Friday, June 20, 20254The consultant will submit the Draft Market Analysis 4 weeks (20 business days) following the Fieldwork Exit Briefing (Task 1).
NPS Review of Draft Market AnalysisMonday, June 23, 2025Friday, July 18, 202544 weeks (20 business days) to review the Draft Market Analysis.
Final Draft Market AnalysisReport25%Monday, July 21, 2025Friday, August 01, 20252The consultant will have 2 weeks (10 business days) to incorporate NPS comments on the Draft Market Analysis and provide the final.
Task 3: Rate Comparability Study (optional)
Draft List of Potential ComparablesMemo5%Monday, April 28, 2025Friday, May 09, 20252The consultant will have 2 weeks (10 business days) after the Introductory Meeting (Task 1) to deliver a Draft List of Potential Comparables.
NPS Review of Potential ComparablesMonday, May 12, 2025Friday, May 23, 202522 weeks (10 business days) to review the Potential Comparables
Draft Rate StudyReport75%Monday, May 26, 2025Friday, June 20, 20254The consultant will submit the Draft Rate Study 4 weeks (20 business days) following the Fieldwork Exit Briefing (Task 1).
NPS Review of Draft Rate StudyMonday, June 23, 2025Friday, July 18, 202544 weeks (20 business days) to review the Draft Rate Study.
Final Rate StudyReport20%Monday, July 21, 2025Friday, August 01, 20252The consultant will have 2 weeks (10 business days) to incorporate NPS comments and provide the Final Rate Study.
Task 4: Personal Property Valuation, Replacement Schedule, and Estimates
Draft Personal Property Valuation (PPV) Report and Draft Cost Estimates for Personal Property ImprovementsReport and Excel Workbook70%Monday, May 26, 2025Friday, June 20, 20254The consultant will submit the Draft PPV report within 4 weeks (20 business days) following the Fieldwork Exit Briefing (Task 1, including a text narrative that describes all methodologies, data sources, and assumptions used.
NPS Review of Draft PPV Report and Draft Cost Estimates for Personal Property ImprovementsMonday, June 23, 2025Friday, July 18, 202544 weeks (20 business days) to review Draft PPV Repor and Cost Estimates.
Final PPV Report and Cost Estimates for Personal Property ImprovementsReport and Excel Workbook30%Monday, July 21, 2025Friday, August 01, 20252The consultant will have 2 weeks (10 business days) to incorporate NPS comments and return the final PPV.
Task 5: Financial Investment Analysis and Scernio Meeting
Pre Baseline CallVirtual Meeting5%Monday, August 04, 2025Friday, August 08, 20251The consultant must schedule and facilitate this call within 1 week (5 business days) of submitting the draft PP improvement cost estimates. NOTE: NPS should have CA and LSI data by this point.
Draft Baseline Buildup (Report and Financial Model)Report and Excel Workbook30%Monday, August 04, 2025Friday, August 15, 20252The consultant will provide the Baseline Buildup and the financial model at least 2 weeks (10 business days) after the delivery of the final Market Analysis.
NPS Review of Draft Baseline BuildupMonday, August 18, 2025Friday, September 05, 202533 (15 business days) weeks to review Baseline Buildup and model.
Post Draft Baseline and Model ReviewVirtual Meeting5%Monday, August 18, 2025Friday, August 22, 20251The consultant will schedule this call within 1 week (5 business days) of the delivery of the Draft Baseline Buildup.
Final Baseline Buildup (Report and Financial Model)Report and Excel Workbook10%Monday, September 08, 2025Friday, September 12, 20251The consultant will have 1 week (5 business days) to incorporate NPS comments and deliver the final.
Draft Scenario Meeting Presentation (final being presented at the SM)Presentation5%Monday, September 15, 2025Friday, September 19, 20251The consultant will submit a PowerPoint presentation at least 1 week (5 business days) before the Scenario Meeting.
NPS Review of Draft PresentationMonday, September 22, 2025Friday, September 26, 20251At least 3 days to review the draft presentation.
Scenario Meeting (SM) AttendanceMeeting/Presentation5%Monday, September 29, 2025Friday, October 03, 20251The consultant will facilitate the meeting and present final PowerPoint.
Scenario Meeting Travel (optional)Traveltravel costMonday, September 29, 2025Friday, October 03, 20251
Draft SM Analysis Executive Summary and Insurance Requirements Request FormMemo10%Monday, October 06, 2025Friday, October 17, 20252The consultant will submit an Executive Summary and the completed Insurance Requirements Request form 2 weeks (10 business days) after the Scenario Meeting.
NPS Review of Draft SM Analysis Executive Summary and Insurance Requirements Request FormMonday, October 20, 2025Friday, October 31, 202522 weeks (10 business days) to review SM Executive Summary and Insurance Requirements Request Form
Final SM Analysis Executive SummaryMemo5%Monday, November 03, 2025Friday, November 14, 20252The consultant will have 2 weeks (10 business days) to incorporate NPS comments on the draft executive summary report and deliver the final.
Draft Franchise Fee Analysis (FFA)Report and Excel Workbook15%Monday, November 03, 2025Friday, November 28, 20254The consultant will provide the draft FFA reportand all supporting documents (including spreadsheets, models, and analysis) 4 weeks (20 business days) after receiving NPS comments on the SM Executive Summary.
NPS Review of Draft FFAMonday, December 01, 2025Friday, December 26, 202544 weeks (20 business days) to review the draft FFA and supporting docs.
Final FFAReport and Excel Workbook5%Monday, December 29, 2025Friday, January 09, 20262The consultant will have 2 weeks (10 business days) to incorporate NPS comments and provide the final FFA and all supporting documents.
PSF4 Panel Evaluation FormsExcel Workbook5%Monday, February 16, 2026Friday, February 27, 20262The consultant must deliver the PSF4 Panel Forms two weeks after receiving comments on the Draft 2 prospectus documents (task 7)
Task 6: Initial Prospectus Development Documents
Draft 1 Prospectus DocumentsDocuments100%Monday, December 01, 2025Friday, December 12, 20252The consultant will submit draft 1 prospectus documents 2 weeks (10 business days) after submitting the draft FFA.

tc={26606888-55AC-47D7-AA1F-13890B4A26DB}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

You may adjust the timing of this deliverable based on project team preference. You could have the documents delivered at the same time as the draft FFA or stagger the deliverable so they do not overlap at all.

NPS Review of Draft 1 Prospectus Docs (Project Team)Monday, December 15, 2025Friday, January 09, 202644 weeks (20 business days) for NPS/Project Team Review of Draft 1.
Task 7 Roundtable Meeting
Draft 2 Prospectus DocumentsDocuments40%Monday, January 12, 2026Friday, January 23, 20262The consultant will have 2 weeks (10 business days) to incorporate NPS Draft 1 comments and provide a revised draft (Draft 2).
NPS Review of Draft 2 (RT Participants, Project Team, BCs)Monday, January 26, 2026Friday, February 13, 202633 weeks (15 business days) to review Draft 2 prospectus docs.
Pre-roundtable Issues Memo and Meeting AgendaMemo10%Monday, February 16, 2026Friday, February 20, 202611 week for the consultant to clean up Draft 2 comments in preparation for RT meeting discussion and provide issues memo and agenda.
Roundtable Meeting AttendanceMeeting with Presentation40%Monday, February 23, 2026Friday, February 27, 202611-2 days during this week.
Rountable Meeting Travel (optional)travel costMonday, February 23, 2026Friday, February 27, 2026
Post Roundtable MemoMemo10%Monday, March 02, 2026Friday, March 06, 20261The consultant will deliver the Post Roundtable Memo 1 week (5 business days) after the conclusion of the Roundtable.
Task 8: Final Prospectus Documents
Draft 3 Roundtable Prospectus documents (Post- Roundtable Documents)Documents50%Monday, March 09, 2026Friday, March 27, 20263After the Post-RT Memo is delivered, the consultant will make changes to the prospectus documents as needed within 3 weeks (15 business days).
NPS Review of Draft 3 Prospectus Documents (all NPS review BC,RC,SOL,Project Team)Monday, March 30, 2026Friday, April 17, 202633 weeks (15 business days) for review of Draft 3.
Final (Draft 4) Prospectus DocumentsDocuments50%Monday, April 20, 2026Friday, May 01, 20262The consultant will deliver "camera-ready" final (draft 4) documents incorporating NPS comments within 2 weeks (10 business days) of receiving draft 3 comments.
Task 9: Panel Support
Panel Evaluation (optional)Meeting100%Monday, December 07, 2026Friday, December 11, 202612-3 weeks to convene evaluation panel after receiving offers
Panel Travel (optional)travel costMonday, December 07, 2026Friday, December 11, 2026
Task 10: ADDITIONAL SCENARIO ANAYSIS (OPTIONAL)
ADDITIONAL SCENARIO ANAYSIS (OPTIONAL)Meeting100%TBDTBD
TRAVEL TO THE SECOND SCENARIO MEETING (OPTIONAL)travel costTBDTBD

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