Attachment-03A-Price-Proposal-for-SI-Services.xlsx

XLSX spreadsheet 96 KB Posted

Attached to
RFP Enterprise Resource Planning Suite and System integrator Services
Solicitation number
RFP 26-00268-AHAC
Issued by
Philadelphia County, Philadelphia City, Pennsylvania

About this file

This is a price proposal template for the Southeastern Pennsylvania Transportation Authority (SEPTA) Enterprise Resource Planning (ERP) Software and Implementation Services procurement in Pennsylvania. The comprehensive Excel workbook requires proposers to provide detailed pricing and staffing information across multiple implementation phases including Governance and Project Management, Planning and Design, Configuration-Build-Test, Training-Deployment-Support, and Organizational Change Management (OCM). The template covers three functional areas: Finance and Procurement, HCM and Payroll, and Planning and Budgeting. Proposers must complete 13 worksheets detailing costs, vendor person-days, staffing plans for both proposer and SEPTA resources, day rates for onshore and offshore delivery centers, milestones and deliverables, pricing assumptions, and Application Maintenance and Support (AMS) services for years 1-5 with optional renewal periods for years 4-5.

All pricing must be provided in U.S. dollars and include fully burdened rates covering all direct and indirect costs required to execute the scope of work. The template requires comprehensive staffing plans showing resource allocation by role, seniority, location (onshore/offshore), monthly person-days over a potential 72-month period, and day rates with an 8-hour standard workday. Travel expenses must be estimated separately and comply with SEPTA Travel Regulations and Per Diem guidelines but are not included in the total implementation fees. Proposers must provide rate cards for onshore U.S. resources and up to three offshore/nearshore delivery center locations. The AMS pricing section requires pricing for 5x8 remote core support with 24x7 Priority 1 coverage. Incomplete responses may render proposals non-responsive, and proposers are prohibited from altering the workbook's formulas or structure.

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

Instructions

SEPTA ERP Software and Implementation Services
Pricing and Staffing Instructions & General Provisions
INSTRUCTIONS:

1. Proposer MUST provide a complete response to all sections in this workbook for ERP implementation and related services. Failure to comply may render the proposal non-responsive. Please follow the instructions in each of the worksheets and attach additional documents to this template where requested.

2. Proposers must provide comprehensive, all-inclusive pricing for all services, deliverables, implementation phases, and ongoing support detailed in their proposal. The proposed fees and rates must encompass all direct and indirect costs required to fully execute the scope of work.

1. Workbook Structure & Response Matrix
#Worksheet NameCategoryInput TypeWorksheet Purpose & Submission Requirement
1Summary By ServicesSummaryAuto-CalculatedSummarizes total implementation fees and vendor person-days across service phases. Do not input data here; values link automatically from detailed tabs.
2Summary By PhaseSummaryProposer InputSummarizes cost and effort broken down by functional scope (Finance/Procurement, HCM/Payroll, Planning/Budgeting) across all lifecycle phases.
3Gov & Proj MgmtProject Phase CostProposer InputDetailed cost and vendor person-days for Program Governance, Quality Assurance, and Project Management across each service area.
4Plan & DesignProject Phase CostProposer InputCost and vendor effort for Planning, Initial Core Team Training, Gap/Fit Analysis, Solution Design (Core, Migration, Reporting, Integration, Security), and Test Planning.
5Config-Build-TestProject Phase CostProposer InputCost and vendor effort for Core System Configuration, Technical Build components (Reports, Interfaces, Conversions, Extensions, Forms, Workflows, Mobile App), and Testing.
6Train-Deploy-SupProject Phase CostProposer InputCost and effort for End-User and Technical Training Delivery, Cutover Preparation and Deployment, Hypercare Post-Go-Live Support, and Value Realization.
7OCMProject Phase CostProposer InputCost and effort for Organizational Change Management (stakeholder management, change enablement, communications, and business readiness). NOTE: Training is in Train-Deploy-Sup.
8Proposer Staffing PlanStaffing ModelProposer InputComprehensive monthly resource allocation plan by role, seniority, location (Onshore/Offshore), day rate, and total person-days.
9SEPTA Staffing PlanStaffing ModelProposer InputEstimated monthly resource loading and FTE commitments required from SEPTA counterpart staff across all project workstreams and phases.
10Rate CardCommercial RatesProposer InputFully burdened daily and hourly billing rates and standard daily hours for all proposed project roles across Onshore and multiple Offshore/Nearshore delivery centers.
11Milestones & DeliverablesDeliverables & FeesProposer InputItemized list of major milestones, key deliverables, acceptance criteria, target schedule, and associated milestone fee allocations tying to the Total Implementation Fee.
12Pricing AssumptionsCommercial TermsProposer InputItemized commercial, technical, and operational assumptions underlying proposed fees, including the explicit operational or cost impact if assumptions are not realized.
13AMSPost-Go-Live AMSProposer InputApplication Maintenance & Support (AMS) service pricing for Years 1–3 (base period) and Years 4–5 (optional renewal periods), assuming 5x8 remote core support with 24x7 P1 coverage.
2. Visual Legend & Formatting Standards
Proposer Data Input Required: Cells where proposers are required to enter costs, effort, rates, or textual details.
Calculated Formula Cell: Auto-calculated or cross-sheet referenced cell. Proposers MUST NOT overwrite these formulas.
Black / Solid GrayNot Applicable (N.A.) / Blocked Cell: Cells where data entry is not permitted (e.g., travel expenses in effort tables).
3. Submission Rules & General Ground Rules
1. Currency: All proposed costs, fees, and rates must be quoted in United States Dollars ($ USD).
2. Completeness: Proposer must provide responses to all applicable tabs. Blank or omitted sections may result in the proposal being deemed non-responsive.
3. Travel & Expenses: Travel and living expenses must be estimated separately where indicated and must adhere strictly to SEPTA Travel Regulations and Per Diem guidelines.
4. Formula Integrity: Do not alter, delete, or break worksheet formulas. If additional columns are needed in Staffing or Milestones, insert columns within the established table boundaries.

Summary By Services

SEPTA ERP Software and Implementation Services
Summary By Services
DO NOT enter information here - it will be calculated automatically from your input in the detailed phase tabs.
Total Fees (excludes Travel Expenses)Total Fees ($)Total # Vendor Person-DaysPerson-Days
Governance and Project Mgmt.$0Governance and Project Mgmt.0
Planning & Design$0Planning & Design0
Config-Build-Test$0Config-Build-Test0
Training, Deployment and Initial Support$0Deployment and Initial Support0
Organization Change Management$0Organization Change Management0
PROJECT TOTAL excl. travel exp.$0Project TOTAL0
Informational: Note travel expenses are not included in the total numbers above but are shown below, pulled from the detailed tabs that follow
Total Travel Expenses$0
GRAND TOTAL incl. travel exp.$0

Summary By Phase

SEPTA ERP Software and Implementation Services
Summary By Phase
Provide the cost summary and effort estimates per proposed phase for each in-scope functional area.
Cost SummaryProject Cost: Gov & Proj MgmtProject Cost: Plan & DesignProject Cost: Config-Build-TestProject Cost: Train-Deploy-SupportProject Cost: OCMTravel ExpensesTotal
Finance & Procurement$0$0$0$0$0$0$0
HCM and Payroll$0$0$0$0$0$0$0
Planning and Budgeting$0$0$0$0$0$0$0
Total$0$0$0$0$0$0$0
Efforts SummaryPerson-days: Gov & Proj MgmtPerson Days: Plan & DesignPerson Days: Config-Build-TestPerson Days: Train-Deploy-SupportPerson Days: OCMTravel ExpensesTotal
Finance & Procurement000000
HCM and Payroll000000
Planning and Budgeting000000
Total000000

Gov & Proj Mgmt

SEPTA ERP Software and Implementation Services
Project Cost - Governance & Project Management
INSTRUCTIONS: Please provide costs and effort (person-days) associated with Governance & Project Management roles supporting each implementation service area below. Travel Expenses for this phase should be entered in the designated rows.
Total CostTotal # Vendor Person-Days
Planning & Design$0Planning & Design0
Configuration, Build and Test$0Configuration, Build and Test0
Train, Deploy and Initial Support$0Train, Deploy and Initial Support0
Organization Change Management Services$0Organization Change Management Services0
Travel Expenses$0Travel ExpensesN.A.
Project GRAND TOTAL$0Project GRAND TOTAL0

Plan & Design

SEPTA ERP Software and Implementation Services
Project Cost - Plan & Design
INSTRUCTIONS: Please provide total costs and vendor effort (in person-days) for all Planning and Design services detailed below. Subtotals for Design Services and Solution Design will automatically calculate from underlying line items.
Total CostTotal # Vendor Person-Days
Planning Services$0Planning Services0
Design Services$0Design Services0
Initial Core Team Training$0Initial Core Team Training0
Gap/Fit and Requirement Analysis$0Gap/Fit and Requirement Analysis0
Solution Design$0Solution Design0
Core Design (i.e., config/workflow design)$0Core Design (i.e., config/workflow design)0
Data Migration Specific Design$0Data Migration Specific Design0
Reporting/Analytics Specific Design$0Reporting/Analytics Specific Design0
Integration Specific Design$0Integration Specific Design0
Security Specific Design$0Security Specific Design0
Test Planning and Design$0Test Planning and Design0
Value Realization (During Planning & Design phase)$0Value Realization (During Planning & Design phase)0
Travel Expenses$0Travel ExpensesN.A.
Planning & Design Phase GRAND TOTAL$0Planning & Design Phase GRAND TOTAL0

Config-Build-Test

SEPTA ERP Software and Implementation Services
Project Cost - Configuration, Build, & Testing
INSTRUCTIONS: Please provide total costs and vendor effort (in person-days) for Configuration, Build, and Testing services below. Build Services subtotals will automatically calculate from the technical build components.
Total CostTotal # Vendor Person-Days
Core Configuration Services$0Core Configuration Services0
Build Services (don't populate; will auto sum)$0Build Services (don't populate; will auto sum)0
Reporting/Analytics Development$0Reporting/Analytics Development0
Interface Development$0Interface Development0
Data Conversion Development$0Data Conversion Development0
Extension/Customization Development$0Extension/Customization Development0
Forms Development$0Forms Development0
Workflows$0Workflows0
Mobile Apps$0Mobile Apps0
Testing Services$0Testing Services0
Value Realization Services (During Config-Build-Test)$0Value Realization Services (During Config-Build-Test)0
Travel Expenses$0Travel ExpensesN.A.
Config-Build-Test Phase GRAND TOTAL$0Config-Build-Test Phase GRAND TOTAL0

Train-Deploy-Sup

SEPTA ERP Software and Implementation Services
Project Cost - Train, Deploy, & Support
INSTRUCTIONS: Please provide costs and vendor effort (in person-days) associated with Training Delivery, Cutover/Deployment, Initial Post Go-Live Support (Hypercare), and Value Realization. NOTE: Training efforts and cost must be included in this tab (not in the OCM tab).
Total CostTotal # Vendor Person-Days
Training Delivery Services$0Training Delivery Services0
Deployment Services (Cutover Prep/Cutover)$0Deployment Services (Cutover Prep/Cutover)0
Initial Support Services (i.e., Hypercare)$0Initial Support Services (i.e., Hypercare)0
Value Realization (During Train-Deploy-Support)$0Value Realization (During Train-Deploy-Support)0
Travel Expenses$0Travel ExpensesN.A.
Training, Deployment and Supp Phase GRAND TOTAL$0Training, Deployment and Supp Phase GRAND TOTAL0

OCM

SEPTA ERP Software and Implementation Services
Project Cost - Organizational Change Management
INSTRUCTIONS: Please provide costs and vendor effort (in person-days) associated with Organizational Change Management (OCM) across the three phases below. NOTE: OCM includes stakeholder engagement, change enablement, and communications. Training is NOT included in this tab, but must be provided in the 'Train-Deploy-Sup' tab.
Total CostTotal # Vendor Person-Days
OCM Services - Planning & Design Phase$0OCM Services - Planning and Design Phase0
OCM Services - Configuration, Build, & Testing Phase$0OCM Services - Configuration, Build, & Testing Phase0
OCM Services - Train, Deploy, & Support Phase$0OCM Services - Train, Deploy, & Support Phase0
Travel Expenses$0Travel ExpensesN.A.
Organization Change Management GRAND TOTAL$0Organization Change Management GRAND TOTAL0

Proposer Staffing Plan

SEPTA ERP Software and Implementation Services
Proposer Staffing Plan
INSTRUCTIONS: Proposer MUST provide its detailed staffing plan for each resource and each Service Schedule of the program that is included in its proposal.

Each row should represent one individual resource and all cells must be completed. If a resource is required in multiple phases, they may be listed separately for each phase. Dropdown lists are provided for standard phases.

Based on the proposed staffing plan, proposers can add more months/columns as needed.

Definitions:

Onshore means the resource will work either at a SEPTA or Proposer location within U.S.A.

Landed Offshore means the resource will be flown in from Proposer's offshore location (e.g., Global Delivery Center) to work Onshore.

Offshore means the resource will work from Proposer's Global Delivery Centers across geographies.

Resource Work Location means the primary location from where this resource will work (either remote/home, SEPTA, or named off-shore or regional delivery center location) Resource Home Location means the City/State or City/Country where the resource lives

Primary Project PhaseResource Work LocationResource Home LocationRole NameSeniority LevelOn-Shore/
Off-ShoreDay Rate ($)Total Person-DaysTotal Resource CostMonth 1Month 2Month 3Month 4Month 5Month 6Month 7Month 8Month 9Month 10Month 11Month 12Month 13Month 14Month 15Month 16Month 17Month 18Month 19Month 20Month 21Month 22Month 23Month 24Month 25Month 26Month 27Month 28Month 29Month 30Month 31Month 32Month 33Month 34Month 35Month 36Month 37Month 38Month 39Month 40Month 41Month 42Month 43Month 44Month 45Month 46
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
0$0
Total Proposer Staffing0$00000000000000000000000000000000000000000

SEPTA Staffing Plan

SEPTA ERP Software and Implementation Services
SEPTA Staffing Plan
INSTRUCTIONS: Proposer MUST provide a staffing plan estimate for expected SEPTA counterpart resources for each phase and workstream. Each row should represent one role or functional requirement, indicating the estimated person-days per month expected from SEPTA personnel. If a resource is required in multiple phases, they may be listed separately for each phase. Dropdown lists are provided for standard categories. If a resource is required in multiple phases, they may be listed separately for each phase. Dropdown lists are provided for standard phases.

Based on the proposed staffing plan, proposers can add more months/columns as needed.

Project Effort (Person-Days per Month)
Primary Project PhaseRole Name / TitleTotal Person-DaysMonth 1Month 2Month 3Month 4Month 5Month 6Month 7Month 8Month 9Month 10Month 11Month 12Month 13Month 14Month 15Month 16Month 17Month 18Month 19Month 20Month 21Month 22Month 23Month 24Month 25Month 26Month 27Month 28Month 29Month 30Month 31Month 32Month 33Month 34Month 35Month 36Month 37Month 38Month 39Month 40Month 41Month 42Month 43Month 44Month 45Month 46Month 47
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Total SEPTA Counterpart Effort (Person-Days)000000000000000000000000000000000000000000000000

Rate Card

SEPTA ERP Software and Implementation Services
Rate Card
INSTRUCTIONS: Proposer MUST provide fully burdened daily rates for all roles in scope of the RFP and Statement of Work. Day rates must reflect the specified standard work hours per day (typically 8.0 hours). Separate tables are provided for Onshore and Offshore delivery locations.
Rate Card: Onshore (United States) - Location: Onshore
#Role NameSeniority LevelPerson-Day Rate ($)# of Work Hours in DayImplied Hourly Rate ($)
1$08.0$0
2$08.0$0
3$08.0$0
4$08.0$0
5$08.0$0
6$08.0$0
7$08.0$0
8$08.0$0
9$08.0$0
10$08.0$0
11$08.0$0
12$08.0$0
13$08.0$0
14$08.0$0
15$08.0$0
16$08.0$0
17$08.0$0
18$08.0$0
19$08.0$0
20$08.0$0
21$08.0$0
22$08.0$0
23$08.0$0
24$08.0$0
25$08.0$0
26$08.0$0
27$08.0$0
28$08.0$0
29$08.0$0
30$08.0$0
31$08.0$0
32$08.0$0
33$08.0$0
34$08.0$0
35$08.0$0
36$08.0$0
37$08.0$0
38$08.0$0
39$08.0$0
40$08.0$0
41$08.0$0
42$08.0$0
43$08.0$0
44$08.0$0
45$08.0$0
46$08.0$0
47$08.0$0
48$08.0$0
49$08.0$0
50$08.0$0
Rate Card: Offshore Delivery Center 1 - Location: [Insert Location: e.g., Bangalore / Hyderabad, India]
#Role NameSeniority LevelPerson-Day Rate ($)# of Work Hours in DayImplied Hourly Rate ($)
1$08.0$0
2$08.0$0
3$08.0$0
4$08.0$0
5$08.0$0
6$08.0$0
7$08.0$0
8$08.0$0
9$08.0$0
10$08.0$0
11$08.0$0
12$08.0$0
13$08.0$0
14$08.0$0
15$08.0$0
16$08.0$0
17$08.0$0
18$08.0$0
19$08.0$0
20$08.0$0
21$08.0$0
22$08.0$0
23$08.0$0
24$08.0$0
25$08.0$0
26$08.0$0
27$08.0$0
28$08.0$0
29$08.0$0
30$08.0$0
31$08.0$0
32$08.0$0
33$08.0$0
34$08.0$0
35$08.0$0
36$08.0$0
37$08.0$0
38$08.0$0
39$08.0$0
40$08.0$0
41$08.0$0
42$08.0$0
43$08.0$0
44$08.0$0
45$08.0$0
46$08.0$0
47$08.0$0
48$08.0$0
49$08.0$0
50$08.0$0
Rate Card: Offshore Delivery Center 2 - Location: [Insert Location: e.g., Manila, Philippines]
#Role NameSeniority LevelPerson-Day Rate ($)# of Work Hours in DayImplied Hourly Rate ($)
1$08.0$0
2$08.0$0
3$08.0$0
4$08.0$0
5$08.0$0
6$08.0$0
7$08.0$0
8$08.0$0
9$08.0$0
10$08.0$0
11$08.0$0
12$08.0$0
13$08.0$0
14$08.0$0
15$08.0$0
16$08.0$0
17$08.0$0
18$08.0$0
19$08.0$0
20$08.0$0
21$08.0$0
22$08.0$0
23$08.0$0
24$08.0$0
25$08.0$0
26$08.0$0
27$08.0$0
28$08.0$0
29$08.0$0
30$08.0$0
31$08.0$0
32$08.0$0
33$08.0$0
34$08.0$0
35$08.0$0
36$08.0$0
37$08.0$0
38$08.0$0
39$08.0$0
40$08.0$0
41$08.0$0
42$08.0$0
43$08.0$0
44$08.0$0
45$08.0$0
46$08.0$0
47$08.0$0
48$08.0$0
49$08.0$0
50$08.0$0
Rate Card: Offshore / Nearshore Delivery Center 3 - Location: [Insert Location: e.g., Latin America / Eastern Europe]
#Role NameSeniority LevelPerson-Day Rate ($)# of Work Hours in DayImplied Hourly Rate ($)
1$08.0$0
2$08.0$0
3$08.0$0
4$08.0$0
5$08.0$0
6$08.0$0
7$08.0$0
8$08.0$0
9$08.0$0
10$08.0$0
11$08.0$0
12$08.0$0
13$08.0$0
14$08.0$0
15$08.0$0
16$08.0$0
17$08.0$0
18$08.0$0
19$08.0$0
20$08.0$0
21$08.0$0
22$08.0$0
23$08.0$0
24$08.0$0
25$08.0$0
26$08.0$0
27$08.0$0
28$08.0$0
29$08.0$0
30$08.0$0
31$08.0$0
32$08.0$0
33$08.0$0
34$08.0$0
35$08.0$0
36$08.0$0
37$08.0$0
38$08.0$0
39$08.0$0
40$08.0$0
41$08.0$0
42$08.0$0
43$08.0$0
44$08.0$0
45$08.0$0
46$08.0$0
47$08.0$0
48$08.0$0
49$08.0$0
50$08.0$0

Milestones & Deliverables

SEPTA ERP Software and Implementation Services
Milestones & Key Deliverables
INSTRUCTIONS: Proposer MUST provide all Major Milestones and Key Deliverables across the main Phases & Services. All Key Deliverables must be linked to a Milestone. Please include the fees in column E that are associated with each major milestone. These fees should tie to the Total Fees provided in the prior Pricing tabs.
Primary Phase / ServiceMilestone #Milestone Name / DescriptionKey Deliverable Name / DescriptionFees Associated With Milestone ($)
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
Total Milestone Fees (Must Reconcile to Total Implementation Fees)$0

Pricing Assumptions

SEPTA ERP Software and Implementation Services
Pricing Assumptions
INSTRUCTIONS: Proposer should use this table to itemize all key assumptions underlying its proposed pricing and staffing, and identify the operational/cost impact if the assumptions are not realized. Assumptions must not conflict with mandatory RFP terms.
#Assumption Description and RationaleImpact if Assumption Not Realized
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50

AMS

SEPTA ERP Software and Implementation Services
Managed Support Services (AMS Pricing)
INSTRUCTIONS: Proposer should provide Application Maintenance Support (AMS) service pricing assuming 5x8 remote services with 24x7 P1 coverage; include SLAs, scope of services, and escalation paths in the proposal narrative.
Managed Support ServicesYear 1Year 2Year 3Year 4 (Optional Renewal Period 1)Year 5 (Optional Renewal Period 2)5-Year Total Cost
Total Estimated Hours per year0
Hourly Rate ($)$0$0$0$0$0$0
Total Annual Cost ($)$0$0$0$0$0$0

This is the start of the file's text. The full file is on GovTribe.

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