Exhibit G_Cost Proposal.xlsx

XLSX spreadsheet 36 KB Posted

Attached to
Capital, Bond, And Investment Tracking And Reporting Software
Solicitation number
2136608
Issued by
New York County, Nissequogue Village, New York

About this file

This is a cost proposal exhibit for the Battery Park City Authority (BPCA), a New York state and local entity, seeking software solutions for capital expenditure tracking, bond fund management, and investment reconciliation services. The BPCA requests proposals from software vendors to provide either Scope A (capital expenditure tracking and reporting with bond fund drawdown management), Scope B (investment reconciliation and reporting), or both scopes. Scope A services encompass multi-year budgeting, funding source management, work order and allowance tracking, amendment tracking, real-time cost visibility, configurable report generation by fund and project, bond disbursement tracking, drawdown request processing, approval workflows, and bond fund sustainability reporting. Scope B services include portfolio management, trade entry and approval workflows, reconciliation of positions and transactions, interest income tracking, book versus market valuation, and GASB-compliant footnote generation. Both scopes require integration with BPCA's current Microsoft Dynamics GP general ledger system and future ERP platform, including bidirectional data flows, scheduled imports and exports, and audit-ready logging.

The cost proposal exhibit (Exhibit G) provides the pricing structure and financial terms for proposers bidding on this opportunity. Proposers must detail their software licensing costs, implementation service fees, ongoing support and maintenance expenses, and any integration or customization costs associated with connecting to the BPCA's existing and future financial systems. The proposal should clearly delineate pricing for Scope A only, Scope B only, and combined Scope A and B offerings to allow BPCA to evaluate different implementation scenarios and total cost of ownership across the requested services.

View the file

Other files

File Type Posted
FINAL RFP_Capital Bond Invest RFP.pdf PDF
Exhibit H_Requirements Response.xlsx XLSX spreadsheet

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

Instructions

EXHIBIT G - COST PROPOSAL
Battery Park City Authority (BPCA) - Capital, Bond, and Investment Tracking and Reporting Software
PurposeThis workbook is used to submit your Cost Proposal in response to BPCA's RFP for Capital and Investment Management Software. Complete all applicable tabs for the Scope(s) to which you are responding.
ScopesScope A: Capital Expenditure Tracking and Reporting and Bond Fund Drawdown Management

Scope B: Investment Reconciliation and Reporting Complete the Combined Summary tab if responding to both Scopes.

Tabs Complete for Scope A proposal: Scope A - Costs, Scope A - T&M Detail, and Scope A - Assumptions.

Complete for Scope B proposal: Scope B - Costs, Scope B - T&M Detail, and Scope B - Assumptions.

Combined Summary: Complete if responding to both Scopes. Identify any cost differences or savings from a combined engagement.

Total Cost Summary: Auto-populated from other tabs. No input required.

Input CellsEnter all cost estimates in yellow cells. Yellow cells with blue text are input fields. Do not modify formulas in non-yellow cells.
Basis for PricingProvide all cost estimates on a Fixed Fee basis unless otherwise noted. All pricing should assume a user base of up to 20 users. The T&M Detail tabs support the Firm Fixed Implementation Fee and are informational only; they do not establish a time-and-materials basis for payment. Your fixed fee need not equal the T&M buildup exactly, but each entry should be reasonably supported by it. The reconciliation checks flag any line differing from its T&M support by more than the variance tolerance (a fixed 10% tolerance); explain flagged items in the "comments" column.
Deployment ModelsIf you offer multiple deployment or pricing models please complete a separate Exhibit G for each model.

Scope A - Costs

EXHIBIT G - COST PROPOSAL
Scope A: Capital Expenditure Tracking and Reporting and Bond Fund Drawdown Management
Instructions: Enter all cost estimates in yellow cells on a Fixed Fee basis. All pricing should assume up to 20 users. Leave blank if a line item does not apply.
SECTION 1: ONE-TIME COSTS
Cost ItemCost ($)Notes / Assumptions
Travel Expenses (if applicable)
Implementation (Enter Here, and (Also Provide Detail at Scope A- T&M Detail)
Initiation and Planning
Requirements Analysis and System Design
System Configuration, Integrations and Data Conversion
User Acceptance Testing
Training and Go-Live Readiness
Deployment and Cut-over
Stabilization and Closeout
Other (describe in Notes):
Other (describe in Notes):
Total Firm Fixed Implementation Fee-
SECTION 2: ONGOING OPERATIONAL COSTS (5-YEAR VIEW: 3 BASE YEARS + 2 OPTION YEARS)
Cost ItemYear 1 ($)Year 2 ($)Year 3 ($)Year 4 ($)
(Option Year 1)Year 5 ($)
(Option Year 2)5-Year Total ($)Notes / Assumptions
Annual Subscription / Licensing Fee-
Annual Maintenance and Support-
Upgrades / Updates (if not included in subscription)-
Non-Production Environments (test, sandbox, training)-
Additional Training (ongoing)-
Other (describe in Notes):-
Other (describe in Notes):-
Total Ongoing Operational Costs------
SECTION 3: TOTAL COST SUMMARY
Cost ItemImplementation ($)Year 1 ($)Year 2 ($)Year 3 ($)Year 4 ($)
(Option Year 1)Year 5 ($)
(Option Year 2)5-Year Total ($)
Firm Fixed Implementation Fee--
Ongoing Operational Costs------
Total Cost of Ownership-------
EDIT CHECK: T&M RECONCILIATION
Compares each fixed-fee entry to the supporting T&M buildup. Entries within the variance tolerance are acceptable; items flagged "Review variance" should be explained in your proposal. The fixed fee need not equal the T&M total exactly.
Section 1: One-Time Costs
Cost ItemT&M Calculated ($)Cost Tab Entry ($)Variance ($)
[Entry − T&M]StatusVariance (%)Comments
Initiation and Planning$0$0$0—
Requirements Analysis and System Design$0$0$0—
System Configuration, Integrations and Data Conversion$0$0$0—
User Acceptance Testing$0$0$0—
Training and Go-live Readiness$0$0$0—
Deployment and Cut-over$0$0$0—
Stabilization and Closeout$0$0$0—
Other (describe in Notes):$0$0$0—
Other (describe in Notes):$0$0$0—
Total$0$0$0—

Scope A - T&M Detail

EXHIBIT G - COST PROPOSAL
Scope A: Capital Expenditure Tracking and Reporting and Bond Fund Drawdown Management — T&M Detail
This tab provides T&M detail supporting the cost proposal. Enter Role, Hourly Rate, and Hours by cost item. Use the Edit Check section at the bottom to confirm totals reconcile to the Cost Proposal tab before submitting.
The T&M Detail tabs are provided for informational purposes only to support the Firm Fixed Implementation Fee and do not establish a time-and-materials basis for payment.
SECTION 1: ONE-TIME COSTS — T&M DETAIL
Enter role names and hourly rates in columns A–B. Enter estimated hours for each cost item in the yellow cells. Extended Cost per role (col N) calculates automatically. Total Extended Cost by item (row 19) must reconcile to the Cost Proposal tab.
Role / Staff CategoryHourly
Rate ($)Initiation and PlanningRequirements Analysis and System DesignSystem Configuration, Integrations and Data ConversionUser Acceptance TestingTraining and Go-Live ReadinessDeployment and Cut-overStabilization and CloseoutOther (Describe)Other (Describe)Total
HoursTotal
Cost ($)Notes /

Assumptions

0
0
0
0
0
0
0
0
0
0
Total Hours0000000000
Total Extended Cost ($)$0$0$0$0$0$0$0$0$0$0

Scope A - Assumptions

EXHIBIT G - COST PROPOSAL
Scope A: Capital Expenditure Tracking and Reporting and Bond Fund Drawdown Management — Assumptions Narrative
Use this worksheet to capture the cost-related assumptions underlying your Cost Proposal for this Scope. Enter your responses in the yellow cells; expand the cells or attach additional pages if you need more room. Your implementation approach, deliverables, and assumptions about BPCA responsibilities should be addressed in your Technical Proposal, not repeated here. These assumptions support, but do not modify, the figures entered on the Costs and T&M Detail tabs.
1. Exclusions and Optional Services
Identify anything not included in the Firm Fixed Implementation Fee. Price any optional services separately and label them clearly as optional.
2. Pricing Assumptions
State the assumptions behind your pricing, including user count, deployment and hosting model, licensing/subscription model and term, integrations, data conversion scope, and any onsite or travel assumptions reflected in the fee.
3. Other Assumptions and Notes
Note any additional assumptions, dependencies, or clarifications relevant to your Cost Proposal for this Scope.

Scope B - Costs

EXHIBIT G - COST PROPOSAL
Scope B: Investment Reconciliation and Reporting
Instructions: Enter all cost estimates in yellow cells on a Fixed Fee basis. All pricing should assume up to 20 users. Leave blank if a line item does not apply.
SECTION 1: ONE-TIME COSTS
Cost ItemCost ($)Notes / Assumptions
Travel Expenses (if applicable)
Implementation (Detail at Scope B - T&M Detail Tab)
Initiation and Planning
Requirements Analysis and System Design
System Configuration, Integrations and Data Conversion
User Acceptance Testing
Training and Go-Live Readiness
Deployment and Cut-over
Stabilization and Closeout
Other (describe in Notes):
Other (describe in Notes):
Total Firm Fixed Implementation Fee-
SECTION 2: ONGOING OPERATIONAL COSTS (5-YEAR VIEW: 3 BASE YEARS + 2 OPTION YEARS)
Cost ItemYear 1 ($)Year 2 ($)Year 3 ($)Year 4 ($)
(Option Year 1)Year 5 ($)
(Option Year 2)5-Year Total ($)Notes / Assumptions
Annual Subscription / Licensing Fee-
Annual Maintenance and Support-
Upgrades / Updates (if not included in subscription)-
Non-Production Environments (test, sandbox, training)-
Additional Training (ongoing)-
Other (describe in Notes):-
Other (describe in Notes):-
Total Ongoing Operational Costs------
SECTION 3: TOTAL COST SUMMARY
Cost ItemImplementation ($)Year 1 ($)Year 2 ($)Year 3 ($)Year 4 ($)
(Option Year 1)Year 5 ($)
(Option Year 2)5-Year Total ($)
Firm Fixed Implementation Fee--
Ongoing Operational Costs------
Total Cost of Ownership-------
EDIT CHECK: T&M RECONCILIATION
Compares each fixed-fee entry to the supporting T&M buildup. Entries within the variance tolerance are acceptable; items flagged "Review variance" should be explained in your proposal. The fixed fee need not equal the T&M total exactly.
Section 1: One-Time Costs
Cost ItemT&M Calculated ($)Cost Tab Entry ($)Variance ($)
[Entry − T&M]StatusVariance (%)Comments
Initiation and Planning$0$0$0—
Requirements Analysis and System Design$0$0$0—
System Configuration, Integrations and Data Conversion$0$0$0—
User Acceptance Testing$0$0$0—
Training and Go-live Readiness$0$0$0—
Deployment and Cut-over$0$0$0—
Stabilization and Closeout$0$0$0—
Other (describe in Notes):$0$0$0—
Other (describe in Notes):$0$0$0—
Total$0$0$0—

Scope B - T&M Detail

EXHIBIT G - COST PROPOSAL
Scope B: Investment Reconciliation and Reporting — T&M Detail
This tab provides T&M detail supporting the cost proposal. Enter Role, Hourly Rate, and Hours by cost item. Use the Edit Check section at the bottom to confirm totals reconcile to the Cost Proposal tab before submitting.
The T&M Detail tabs are provided for informational purposes only to support the Firm Fixed Implementation Fee and do not establish a time-and-materials basis for payment.
SECTION 1: ONE-TIME COSTS — T&M DETAIL
Enter role names and hourly rates in columns A–B. Enter estimated hours for each cost item in the yellow cells. Extended Cost per role (col N) calculates automatically. Total Extended Cost by item (row 19) must reconcile to the Cost Proposal tab.
Role / Staff CategoryHourly
Rate ($)Initiation and PlanningRequirements Analysis and System DesignSystem Configuration, Integrations and Data ConversionUser Acceptance TestingTraining and Go-Live ReadinessDeployment and Cut-overStabilization and CloseoutOther (Describe)Other (Describe)Total
HoursTotal
Cost ($)Notes /

Assumptions

0
0
0
0
0
0
0
0
0
0
Total Hours0000000000
Total Extended Cost ($)$0$0$0$0$0$0$0$0$0$0

Scope B - Assumptions

EXHIBIT G - COST PROPOSAL
Scope B: Investment Reconciliation and Reporting — Assumptions Narrative
Use this worksheet to capture the cost-related assumptions underlying your Cost Proposal for this Scope. Enter your responses in the yellow cells; expand the cells or attach additional pages if you need more room. Your implementation approach, deliverables, and assumptions about BPCA responsibilities should be addressed in your Technical Proposal, not repeated here. These assumptions support, but do not modify, the figures entered on the Costs and T&M Detail tabs.
1. Exclusions and Optional Services
Identify anything not included in the Firm Fixed Implementation Fee. Price any optional services separately and label them clearly as optional.
2. Pricing Assumptions
State the assumptions behind your pricing, including user count, deployment and hosting model, licensing/subscription model and term, integrations, data conversion scope, and any onsite or travel assumptions reflected in the fee.
3. Other Assumptions and Notes
Note any additional assumptions, dependencies, or clarifications relevant to your Cost Proposal for this Scope.

Combined Summary

EXHIBIT G - COST PROPOSAL
Combined Scope Summary (Complete only if responding to both Scope A and Scope B)
This tab summarizes the cost of a combined Scope A and Scope B engagement. If your combined pricing differs from the sum of the individual Scope proposals (e.g., due to shared platform costs, integration efficiencies, or volume discounts), reflect those differences in the Adjustment row and explain in the Notes section below.
Cost ItemImplementation ($)Year 1 ($)Year 2 ($)Year 3 ($)Year 4 ($)
(Option Year 1)Year 5 ($)
(Option Year 2)5-Year Total ($)
Scope A: Capital Expenditure Tracking and Bond Fund Drawdown Management-------
Scope B: Investment Reconciliation and Reporting-------
Combined Engagement Adjustment (enter savings as negative; additional costs as positive):--
Total Combined Cost of Ownership (Scope A + Scope B + Adjustment)-------
Notes: Describe the nature of any combined engagement adjustment (e.g., shared infrastructure, integration efficiencies, volume discount):

Total Cost Summary

EXHIBIT G - COST PROPOSAL
Total Cost Summary
This tab is auto-populated from the Scope A, Scope B, and Combined Summary tabs. No input is required.
Cost ItemImplementation ($)Year 1 ($)Year 2 ($)Year 3 ($)Year 4 ($)
(Option Year 1)Year 5 ($)
(Option Year 2)5-Year Total ($)
Scope A Only: Capital Expenditure Tracking and Bond Fund Drawdown Management-------
Scope B Only: Investment Reconciliation and Reporting-------
Combined (Scope A + Scope B)-------

Settings

EXHIBIT G - COST PROPOSAL : INTERNAL SETTINGS
This worksheet is intentionally hidden. It holds the variance tolerance used by the T&M reconciliation Status checks. Do not edit unless authorized by BPCA.
Variance tolerance (+/-%)10%
Referenced by the EDIT CHECK: T&M RECONCILIATION Status columns on the Scope A / Scope B Costs tabs

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