Section_5_Cost_Sheet.xlsx

XLSX spreadsheet 35 KB Posted Jan 10, 2024

Attached to: Montana Access to Quality Childcare System MAQCS Rebid
Solicitation number: DPHHS-RFP-2024-0497KH
Issued by: Montana

About this file

Written by GovTribe AI · May 21, 2025

The document is a Cost Sheet Excel file for the Virginia Department of Game and Inland Fisheries (DGIF) related to the Montana Access to Quality Childcare System (MAQCS) Rebid, specifically addressing the cost proposal requirements for a system design and implementation project. The spreadsheet contains multiple tabs detailing design, development, implementation (DDI) costs, maintenance and operations (M&O) expenses, staff cost estimates, ongoing services rates, and potential value-added services across a six-year period from June 1, 2024, to May 31, 2030. The total project budget is not to exceed $10,000,000, with costs structured across design, implementation, warranty, and post-warranty maintenance phases.

The pricing structure includes detailed breakdowns for staff roles and hourly rates across project phases such as Initiation, Phase 1, Phase 2, and Enhancement, with roles ranging from Project Managers to Developers, with hourly rates varying from $10 to $160. The document provides a framework for task order negotiations, allowing the state to acquire additional services beyond the initial contract scope. The cost sheet allows for flexibility in pricing, including a section for value-added services where vendors can propose additional system components or services beyond the original request, with both retail and actual proposed costs to be specified. The rates and cost estimates are meant to provide transparency and enable precise budgeting for the Montana child care licensing system implementation.

View the file

Other files

File	Type	Posted
CCUBS Rows per table11.29.23.xlsx	XLSX spreadsheet	Jan 10, 2024
Output_Inventory_MAQCS.xlsx	XLSX spreadsheet	Jan 10, 2024
Attach 7 - Resource Allocation Schedules.xlsx	XLSX spreadsheet	Jan 10, 2024
Project_Management_Deliverables_MAQCS.xlsx	XLSX spreadsheet	Jan 10, 2024
Attach 8 - Technology Matrix.xlsx	XLSX spreadsheet	Jan 10, 2024
Acronyms_Definitions_and_Terms_MAQCS.xlsx	XLSX spreadsheet	Jan 10, 2024
CCUBS_Production_Calendar_2023_MAQCS.pdf	PDF	Jan 10, 2024
CCUBS_ERD_Tables_MAQCS.pdf	PDF	Jan 10, 2024
1200452-event.pdf	PDF	Jan 10, 2024
Attach 9 -Baseline Technical Requirements.xlsx	XLSX spreadsheet	Jan 10, 2024
CCUBS_Data_Dictonary_MAQCS.xlsx	XLSX spreadsheet	Jan 10, 2024

Show all 11

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.

Instructions

PRICING: INSTRUCTIONS
MT DPHHS ExploreMT	MAQCS

Complete - Cost sheet using the five (5) tabs that follow. Do not alter tab 5.2.1A or 5.2.1B any way when entering information. Enter data only. Add rows to tabs 5.2.2, 5.2.3, and 5.2.4 as needed to input data. Do not alter these tabs in any other way.

If additional clarifying information is needed, include that in response to each section NOT in this spreadsheet.

1A and 1B The Pricing Total tabs (5.2.1A and 5.2.1B) requires Offerors to enter all costs for the Offeror to provide a System that meets DPHHS’s needs as outlined in this RFP. Offerors must enter the cost of designing, developing, configuring and implementing the System and the cost of providing the ongoing operations and maintenance of the System.

DPHHS expects this section to represent ALL costs for implementation of the system to be represented in this section. DO NOT add rows or alter this sheet other than inputting data.

2	The Staff Cost Estimates sheet provides an overview of the staff allocation across the project by role. This estimate should include all staff working through end of warranty and should be in alignment with the project cost excluding non-staff costs. Add rows as needed.
3	DPHHS may, at its convenience, wish to acquire additional ongoing services related to this RFP through the use of a Task Order. Upon execution of a Task Order, the Contractor and DPHHS will negotiate the tasks and the time frames for each task. DPHHS will require the Contractor to submit a specific cost proposal explaining the payment schedule and the general labor expectations.

The Rate Card tab outlines the role and responsibilities and the associated hourly rate to be used for Task Orders. While rate information is required, it will not be considered in deriving each Offerorr’s overall cost score. Example data has been provided and should be replaced with actual data. Add rows as needed.

4 The Value-Add Services tab provides an opportunity for Offerors to propose additional System components and services that are not included as requirements in the RFP.

System components and/or services may be proposed at a cost to DPHHS or may be offered as no-cost enhancements. Offerors are requested to provided both the retail value of the proposed Value-Add Service (define as the price DPHHS would pay to procure the value-added service/component singularly) and the actual proposed cost to DPHHS. While value add information is required, the functionality WILL NOT be considered as part of the proposed functionality and the cost WILL NOT be included in the price calculation described in Section 6.2.

This section IS NOT to be used to propose functionality in modules that represent a menu style section for DPHHS to build 'total cost' values. It is ONLY to be used to suggest functionality that was not included in the RFP. Add rows as needed.

&"-,Bold"&9VIRGINIA DEPARTMENT OF GAME AND INLAND FISHERIES

&10Page &P of &N

5.2.1A DDI and Warr Cost

DDI and Warranty COST
MAQCS	Enter Data in the Yellow Cells Only

			Project DDI and Warranty Time Period
		PRICING COMPONENT	Year 1	Year 2	Year3	Year 4	Year 5	Year6	TOTAL
			Jun 1, 2024 -
May. 31, 2025	Jun 1, 2025 -
May. 31, 2026	Jun 1, 2026 -
May. 31, 2027	Jun 1, 2027 -
May. 31, 2028	Jun 1, 2028 -
May. 31, 2029	Jun 1, 2029 -

May. 31, 2030

Section A: Overall Cost of System
DESIGN, DEVELOPMENT & IMPLEMENTATION SERVICES*	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
POST-IMPLEMENTATION SERVICES **
Warranty Support	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
SUB-TOTAL POST-IMPLEMENTATION SERVICES	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
SUB-TOTAL: OVERALL COST OF System ***	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Total in cell I14 - NOT TO EXCEED $10,000,000

* Include all warranty cost in Post-Implementation Services. Any license costs should be included in this row.

**DO NOT include an maintenance and operations costs on this sheet.

*** All travel, meals, lodging, and miscellaneous expenses must be included in services.

Enter zero(0) for any year with no DDI or Warranty costs

&"-,Bold"&9VIRGINIA DEPARTMENT OF GAME AND INLAND FISHERIES

&9APPENDIX 4 - COST RESPONSE: TOTAL

DGIF LICENSING SYSTEM RFP

RFP # KT 00263-434 &10Page &P of &N

5.2.1B Maintenance Cost

TOTAL COST
MAQCS	Enter Data in the Yellow Cells Only

	Post Warranty M&O Cost
PRICING COMPONENT	M&O Year 1*	M&O Year 2	M&O Year3	TOTAL

Section 1BA: Maintenance
POST-IMPLEMENTATION SERVICES **
Maintenance and Operations***	$ - 0	$ - 0	$ - 0	$ - 0
SUB-TOTAL POST-IMPLEMENTATION SERVICES	$ - 0	$ - 0	$ - 0	$ - 0
TOTAL POST-IMPLEMENTATION SERVICES	$ - 0	$ - 0	$ - 0	$ - 0
	*Year 1 begins the day after the end of the warranty period. Each year thereafter (Year 2, Year 3) begins the day after the year before. Enter costs for the entire year (12-months).

** Only include cost for Maintenance and Operations of the System following the warranty period, including any proposed cost of hosting.

*** All travel, meals, lodging, and miscellaneous expenses must be included in services.

&"-,Bold"&9VIRGINIA DEPARTMENT OF GAME AND INLAND FISHERIES

&9APPENDIX 4 - COST RESPONSE: TOTAL

RFP # KT 00263-434 &10Page &P of &N

5.2.2 Staff Cost Estimates

Staff Cost Estimates
MAQCS	Enter Data in the Yellow Cells Only

In order to review capacity planning for this project, fill in the role, number of hours, and rate for the staff matrix for this project.

***Example roles, hours and rates provided - modify to fit your plan.

Phase	Role Title	Total Hours	Hourly Rate	Total
Initiation	Project Manager	2060	$ 160	$ 329,600.00
Initiation	Business Analyst1	2060	$ 150	$ 309,000.00
Initiation	Architecture	2060	$ 120	$ 247,200.00
Initiation	Data Base Administrator	2060	$ 100	$ 206,000.00
Phase 1	Project Manager	2060	$ 160	$ 329,600.00
Phase 1	Business Analyst1	2060	$ 150	$ 309,000.00
Phase 1	Business Analyst2	2060	$ 140	$ 288,400.00
Phase 1	Quality Assurance	1040	$ 130	$ 135,200.00
Phase 1	Architecture	2060	$ 120	$ 247,200.00
Phase 1	DevOps	1040	$ 110	$ 114,400.00
Phase 1	Data Base Administrator	2060	$ 100	$ 206,000.00
Phase 1	Developer1	1040	$ 90	$ 93,600.00
Phase 1	Developer2	2060	$ 80	$ 164,800.00
Phase 1	Developer3	1040	$ 70	$ 72,800.00
Phase 1	Developer4	2060	$ 60	$ 123,600.00
Phase 1	Developer5	1040	$ 50	$ 52,000.00
Phase 2	Project Manager	2060	$ 160	$ 329,600.00
Phase 2	Business Analyst1	2060	$ 150	$ 309,000.00
Phase 2	Business Analyst2	2060	$ 140	$ 288,400.00
Phase 2	Quality Assurance	1040	$ 130	$ 135,200.00
Phase 2	Architecture	2060	$ 120	$ 247,200.00
Phase 2	DevOps	1040	$ 110	$ 114,400.00
Phase 2	Data Base Administrator	2060	$ 100	$ 206,000.00
Phase 2	Developer1	1040	$ 90	$ 93,600.00
Phase 1	Developer2	2060	$ 80	$ 164,800.00
Phase 1	Developer3	1040	$ 70	$ 72,800.00
Phase 2	Test Manager	2060	$ 40	$ 82,400.00
Phase 2	Tester	1040	$ 30	$ 31,200.00
Phase 2	Training Manager	2060	$ 20	$ 41,200.00
Phase 2	Trainer	1040	$ 10	$ 10,400.00
Enhancement	Project Manager	2060	$ 160	$ 329,600.00
Enhancement	Business Analyst1	2060	$ 150	$ 309,000.00
Enhancement	Developer1	2060	$ 20	$ 41,200.00
Enhancement	Tester	1040	$ 10	$ 10,400.00
*add rows as needed

5.2.3 Ongoing Services

Ongoing Services
MAQCS	Enter Data in the Yellow Cells Only

DPHHS may, at its convenience, wish to acquire additional services related to this RFP through the use of a Task Order. Please provide the Role Title, Representative Responsibilities/Tasks, and the Hourly Rate for all roles included in your response. These rates are assumed to be the rates that will be used for any future Task Orders.

Rate is defined as cost per hour for each resource.

Example roles, and rates provided - modify to fit your plan.

Role Title	Representative Responsibilities / Tasks	Hourly Rate
Project Manager	*Describe each role and expierence level	$ 120
Senior Business Analyst		$ 110
Business Analyst		$ 100
Quality Assurance		$ 90
Architecture		$ 80
DevOps		$ 70
Data Base Administrator		$ 60
Senior Developer		$ 50
Developer		$ 40
Test Manager		$ 30
Tester		$ 20
Training Manager		$ 10
Trainer		$ 5

*add rows as needed

&"-,Bold"&9VIRGINIA DEPARTMENT OF GAME AND INLAND FISHERIES

&10Page &P of &N

5.2.4 Value Add Services

VALUE-ADD
MAQCS
	Enter Data in the Yellow Cells Only

Note: Value-Add Services are additional System functionality or services proposed by the Offeror that are above and beyond what is necessary to satisfy the requirements contained in this RFP and its associated documents.

If a Offeror desires to provide a Value-Add Service for a discounted price, please note the retail value and the discounted price in the above.

Offerors are required to provided a cost for each proposed Value-Add Service.

	PRICING COMPONENT	Year 1	Year 2	Year3	Year 4	Year 5	Year6	TOTAL
		Jun 1, 2024 -
May. 31, 2025	Jun 1, 2025 -
May. 31, 2026	Jun 1, 2026 -
May. 31, 2027	Jun 1, 2027 -
May. 31, 2028	Jun 1, 2028 -
May. 31, 2029	Jun 1, 2029 -

May. 31, 2030

VALUE-ADD SERVICES	Retail Value	Actual Cost to DPHHS	Retail Value	Actual Cost to DPHHS	Retail Value	Actual Cost to DPHHS	Retail Value	Actual Cost to DPHHS	Retail Value	Actual Cost to DPHHS	Retail Value	Actual Cost to DPHHS
< Insert Value-Add Service >	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
< Insert Value-Add Service >	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
< Insert Value-Add Service >	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
< Insert Value-Add Service >	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
< Insert Value-Add Service >	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
< Insert Value-Add Service >	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
< Insert Value-Add Service >	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
< Insert Value-Add Service >	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
< Insert Value-Add Service >	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
< Insert Value-Add Service >	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
< Insert Value-Add Service >	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
< Insert Value-Add Service >	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
< Insert Value-Add Service >	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
< Insert Value-Add Service >	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
TOTAL: VALUE-ADD SERVICES	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
*add rows as needed

&"-,Bold"&9VIRGINIA DEPARTMENT OF GAME AND INLAND FISHERIES

&9APPENDIX 4 - COST RESPONSE: VALUE-ADD SERVICES

RFP # KT 00263-434 &10Page &P of &N

File details come from the government source that posted it. Updated May 20, 2025.