Price Format Template.xlsx

XLSX spreadsheet 46 KB Posted

Attached to
CNSP Financial Analyst Support - SEAPORT
Solicitation number
N0024426RS005
Issued by

About this file

This is a Price Format Template for the CNSP Financial Analyst Support - SEAPORT contract (Solicitation N0024426RS005) with the Department of the Navy Naval Supply Systems Command. The template establishes the pricing structure for a base year (October 1, 2026 - September 30, 2027) and four option years extending through 2030-2031. The contract requires a team of seven full-time equivalent (FTE) financial analysts across multiple labor categories: one Senior Financial Analyst III serving as Project Manager (KEY personnel), two Financial Analyst III positions including an Accounting Analyst (KEY personnel), two additional Financial Analyst III positions, and two Financial Analyst II positions. Labor rates, fringe benefits, overhead, and G&A percentages are to be populated by the offeror, with all formulas remaining the offeror's responsibility for accuracy.

The pricing template includes two primary contract line item numbers (CLINs): CLIN 1000 for labor and CLIN 3000 for travel and other direct costs. Travel costs are specified as $50,000 for the base year with 2% annual escalation through the option years ($51,000 for Option Year 1, $52,020 for Option Year 2, $53,060.40 for Option Year 3, and $54,121.61 for Option Year 4). The template also contains a separate FAR 52.217-8 6-Month Extension section accommodating different personnel (Project Manager, four Instructors with specialized roles including Boat Captain, Navigator, Coxswain, and Engineer, and a Communicator) with $27,060.81 in travel costs, though this section contains formula errors in the submitted template requiring correction by the offeror.

View the file

Other files

Show all 12

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

Summary Period of Performance Hours Total

CLINS

Oct 1 -Sep 30TotalFFP Labor CLINSCR Travel CLINSFFP & CR
Base Year2026 - 20270$ - 0$ - 0$ - 0
Option Year 12027 - 20280$ - 0$ - 0$ - 0
Option Year 22028 - 20290$ - 0$ - 0$ - 0
Option Year 32029 - 20300$ - 0$ - 0$ - 0
Option Year 42030 - 20310$ - 0$ - 0$ - 0
TOTAL FFP Price$ - 0$ - 0$ - 0
Fringe0.00%
Overhead0.00%
G&A Onsite0.00%
Fee0.00%
Escalation YearOY1OY2OY3OY4
Escalation Labor0.00%0.00%0.00%0.00%
Offeror is responsible for accuracy of all formulas in its submission

Base Year

Labor CategoryFTELabor HoursLabor RateFringeOHG&ABurdened RateFeeExtended
0.00%0.00%0.00%0.00%
Senior Financial Analyst III (Project Manager) (KEY)1$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Financial Analyst III (Accounting Analyst) (KEY)2$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Financial Analyst III2$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Financial Analyst II2$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0
Other Direct Cost (Travel)$ 50,000.00

Subtotals 7 - 0 Total $ 50,000.00

CLINCostFeeTotal
Labor1000$ - 0$ - 0$ - 0
Travel3000$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0

Option 1

Labor CategoryFTELabor HoursLabor RateFringeOHG&ABurdened RateFeeExtended
0.00%0.00%0.00%0.00%
Senior Financial Analyst III (Project Manager) (KEY)1$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Financial Analyst III (Accounting Analyst) (KEY)2$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Financial Analyst III2$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Financial Analyst II2$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0
Other Direct Cost (Travel)$ 51,000.00

Subtotals 7 - 0 Total $ 51,000.00

CLINCostFeeTotal
Labor5000$ - 0$ - 0$ - 0
Travel7000$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0

Option 2

Labor CategoryFTELabor HoursLabor RateFringeOHG&ABurdened RateFeeExtended
0.00%0.00%0.00%0.00%
Senior Financial Analyst III (Project Manager) (KEY)1$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Financial Analyst III (Accounting Analyst) (KEY)2$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Financial Analyst III2$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Financial Analyst II2$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0
Other Direct Cost (Travel)$ 52,020.00

Subtotals 7 - 0 Total $ 52,020.00

CLINCostFeeTotal
Labor5000$ - 0$ - 0$ - 0
Travel7000$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0

Option 3

Labor CategoryFTELabor HoursLabor RateFringeOHG&ABurdened RateFeeExtended
0.00%0.00%0.00%0.00%
Senior Financial Analyst III (Project Manager) (KEY)1$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Financial Analyst III (Accounting Analyst) (KEY)2$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Financial Analyst III2$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Financial Analyst II2$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0
Other Direct Cost (Travel)$ 53,060.40

Subtotals 7 - 0 Total $ 53,060.40

CLINCostFeeTotal
Labor5000$ - 0$ - 0$ - 0
Travel7000$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0

Option 4

Labor CategoryFTELabor HoursLabor RateFringeOHG&ABurdened RateFeeExtended
0.00%0.00%0.00%0.00%
Senior Financial Analyst III (Project Manager) (KEY)1$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Financial Analyst III (Accounting Analyst) (KEY)2$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Financial Analyst III2$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Financial Analyst II2$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0
Other Direct Cost (Travel)$ 54,121.61

Subtotals 7 - 0 Total $ 54,121.61

CLINCostFeeTotal
Labor5000$ - 0$ - 0$ - 0
Travel7000$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0

Far 52.217-8 6-Month Extension

Labor CategoryFTELabor HoursLabor RateFringeOHG&ABurdened RateFeeExtended
0.00%0.00%0.00%0.00%
Project Manager0.5- 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Instructor 1 (Boat Captain)1- 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Instructor 2 (Navigator)1- 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Instructor 3 (Coxswain)1- 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Instructor 4 (Engineer)1ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!
Instructor 5 (Communicator)1ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!
ERROR:#REF!
Other Direct Cost (Travel)$ 27,060.81

Subtotals 5.5 ERROR:#REF! Total ERROR:#REF!

CLINCostFeeTotal
Labor5000ERROR:#REF!ERROR:#REF!ERROR:#REF!
Travel7000$ 27,060.81$ - 0$ 27,060.81
ERROR:#REF!ERROR:#REF!ERROR:#REF!

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