Attachment 2 -USMMA Pricing Template V6.xlsx

XLSX spreadsheet 147 KB Posted Oct 21, 2020

Attached to: USMMA Student Information System Federal contract opportunity
Solicitation number: 693JF721R000001
Issued by: Department of Transportation Maritime Administration

About this file

Written by GovTribe AI · Dec 28, 2023

This document contains a pricing template and instructions for offerors to provide cost information for a student information system replacement project at the United States Merchant Marine Academy. Offerors are asked to provide all one-time and recurring software, hardware, and third-party pricing on various tabs in the spreadsheet template. The template includes tabs for software subscription pricing by module, one-time software pricing, fixed-price and time-and-materials implementation services costs, hourly rate cards, and resource hour estimates for both the offeror and USMMA. Offerors should base subscription pricing on a five-year contract term and provide all pricing in U.S. dollars.

View the file

Other files for this federal contract opportunity

Other files attached to USMMA Student Information System, newest first.
File	Type	Posted
Amendment 3- SF30.pdf	PDF	Dec 18, 2020
Amendment 3- Additional QA Responses.pdf	PDF	Dec 18, 2020
Amendment 2 Attachment 1 Responses to Questions.pdf	PDF	Dec 8, 2020
Amendment 2 SF30.pdf	PDF	Dec 8, 2020
Amendment 2 Attachment 2-USMMA Org.pdf	PDF	Dec 8, 2020
Amendment 1 SF30- 693JF721R000001.pdf	PDF	Nov 3, 2020
Amendment 1- SIS Solicitation.pdf	PDF	Nov 3, 2020
Amendment 1 Attachment 1 -Updated PWS.pdf	PDF	Nov 3, 2020
Amendement 1 Attachment 3 - Responses to Initial Questions.pdf	PDF	Nov 3, 2020
Amendment 1 Attachment 2- QA Response Form.docx	DOCX document	Nov 3, 2020
Solicitation 693JF721R000001 (USMMA SIS).pdf	PDF	Oct 21, 2020
Attachment 1 -PWS .pdf	PDF	Oct 21, 2020
Attachment 3- Past Performance Eval Form.doc	DOC document	Oct 21, 2020
Attachment 4- QA Response Form.docx	DOCX document	Oct 21, 2020

Show all 14

On GovTribe

Work with this file on GovTribe

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.

0. Instructions

Instructions for Completing Pricing Spreadsheet

Offerors are asked to provide all cost information related to their proposed solution on each of the tabs within this spreadsheet file. Per the instructions in the RFP, the price information must include all third party software pricing (one-time and recurring, hardware and software). All Pricing must be provided in US dollars.

Here are instructions for each tab:

Tab 1: Summary

Enter the Offeror name in cell A1. No other information can be entered on this tab. Please "Save As" to also include the firms' name in the file name. The rest of the fields on the tab are self-calculating.

Tab 2: Software Subscription

This tab provides a place for Offerors to put the subscription pricing for each module. Pricing for OPTIONAL products or subscriptions may also be entered on this tab. Pricing estimates should be based on a 5-year contract term.

Each Offeror may define their own "unit" of pricing. Often, a unit is based on student FTE, staff FTE, or staff named user. USMMA prefers that all units be based on some verifiable data, such as IPEDS student FTE.

Tab 3: Software One-Time

This tab provides a place for Offerors to put any one-time pricing for their recommended software solution. No recurring costs should be recorded on this tab. Within this tab are:

Application Software One-Time Price This section is intended for all proposing Offeror products that are required to provide a solutions that addresses all of USMMA's needs.

Tools One-Time Price This section is intended for all separate tools required to provide a solutions that addresses all of USMMA's needs. These tools and their associated pricing should not be replicated in any other category.

3rd Party Add-On One-Time Price This section is intended for all 3rd Party products that are required to provide a solutions that addresses all of USMMA's needs. These products and their associated pricing should not be replicated in any other category.

Other One-Time Costs - Including Software Training This section is intended for identifying any other costs that are required for the Offeror's proposal to successfully address USMMA's needs. Enter any software training courses or training materials are not included in any other section.

Tab 4a: Services Fixed Price

Use this tab to complete any portion of the implementation services proposal that is fixed-price.

Fixed-Price Services - For Items Required For Go-Live Offerors are asked in the first few lines to provide fixed prices for conducting a ‘vanilla’ implementation, i.e. no software extensions (or customizations). The vanilla implementation will include all interfaces, reports, workflows, etc. covered within the SOW. Please reference any sections of your written responses that might be relevant.

Fixed Price Services - For Optional Services Offerors are asked to provide fixed prices for any optional services (e.g. additional training, flat-fee interface development, etc.)

Tab 4b: Services Time & Mat.

Use this tab to complete any portion of the implementation services proposal that is time and materials.

Not to Exceed Time & Materials Services - For Items Required For Go-Live Offerors are asked in the first few lines to provide fixed prices for conducting a ‘vanilla’ implementation, i.e. no software extensions (or customizations). The vanilla implementation will include all interfaces, reports, workflows, etc. covered within the SOW. Please reference any sections of your written responses that might be relevant.

Not to Exceed Time & Materials Services - For Optional Services Offerors are asked to provide fixed prices for any optional services (e.g. additional training, flat-fee interface development, etc.)

Justification for using this pricing model instead of fixed price.

Offers using this pricing model must provide a justification of why this model used rather than fixed-price.

Tab 5: Services Hourly Rate Card

You are required to provide fixed hourly rates to allow USMMA to lock-in rates for the duration of the implementation and for any needed change orders.

Tab 6: USMMA Resource Hours

This tab is intended to provide estimated hours for USMMA staff across each month of the project. USMMA the wishes to understand the anticipated internal support hours needed to staff this implementation.

Tab 7: Offeror Resource Hours

This tab is intended to provide estimated hours the Offeror will staff across each month of the project. USMMA the wishes to understand the anticipated monthly vendor staff hours needed for this implementation.

Tab 8: Assumptions

This is a free format page. Offerors can include any information/assumptions that they wish to include. However, any contract terms and conditions should be included within the Offeror's standard product agreement.

Page &P of &N &F

1. Summary

INSERT Offeror NAME
Proposed Pricing Summary
REQUIRED SOFTWARE COSTS
5-Year Subscription Price		Subscription Extended Pricing					Total
		$ Year 1	$ Year 2	$ Year 3	$ Year 4	$ Year 5	$ Dollars
	TOTAL 5-YEAR SUBSCRIPTION PRICE	$ -	$ -	$ -	$ -	$ -	$ -
Software (One-Time)
	Application Software	$ -
	Tools Software	$ -
	3rd Party Add-on	$ -
	Other One-Time Costs - Including Software Training	$ -
TOTAL ONE-TIME PRICE		$ -

OPTIONAL SOFTWARE COSTS
OPTIONAL 5-Year Products or Subscriptions		OPTIONAL Subscription Extended Pricing					Total
		$ Year 1	$ Year 2	$ Year 3	$ Year 4	$ Year 5	$ Dollars
	TOTAL 5-YEAR OPTIONAL SUBSCRIPTION COSTS	$ -	$ -	$ -	$ -	$ -	$ -

IMPLEMENTATION COSTS
Implementation Services - Fixed Price Proposals
	Total Fixed Costs for Required Items
	$ -
	Total Fixed Costs for Optional Items
	$ -

Implementation Services - Time and Materials
	Time & Materials Costs for Required Items	$ -
	Time & Materials Costs for Optional Items	$ -

TOTAL IMPLEMENTATION COSTS		$ -
	Blended Hourly Rate	$ -

NOTE: Insert the Offeror Name in cell A1. There are no other data entry fields on this page.

2. Software Subscription

Software Recurring Pricing
Subscription (Support & Maintenance)				Subscription Extended Pricing					Total
List Cost by Application Module	Unit Type	# of Units	$/Unit	$ Year 1	$ Year 2	$ Year 3	$ Year 4	$ Year 5	$ Dollars
									$ -
									$ -
									$ -
									$ -
									$ -
									$ -
									$ -
									$ -
									$ -
									$ -
									$ -
									$ -
									$ -
									$ -
									$ -
									$ -
Total Support & Maintenance Pricing				$ -	$ -	$ -	$ -	$ -	$ -

OPTIONAL Products or Subscriptions				OPTIONAL Product Subscriptions Pricing					Total
List Price by Product Below:	Unit Type	# of Units	$/Unit	$ Year 1	$ Year 2	$ Year 3	$ Year 4	$ Year 5	$ Dollars
									$ -
									$ -
									$ -
									$ -
									$ -
									$ -
									$ -
									$ -
									$ -
Total OPTIONAL Product Subscriptions Pricing				$ -	$ -	$ -	$ -	$ -	$ -

3. Software One-time

Software One-Time Price
Application Software: One-Time Price
Application Software Price List By Module:	Delivered Version / Supplier	Functionality Provided	Unit Type	# of Units	$/Unit	Pricing

$Year 1

						$ -
						$ -
						$ -
						$ -
						$ -
						$ -
						$ -
						$ -
						$ -
						$ -
Total Application Software Price						$ -
Tools One-Time Price
List Tools Below:	Version / Supplier	Functionality Provided	Unit Type	# of Units	$/Unit	Pricing

$Year 1

						$ -
						$ -
						$ -
						$ -
						$ -
						$ -
Total Tools Price						$ -
3rd Party Add-On One-time Price
List Below:	Version / Supplier	Functionality Provided	Unit Type	# of Units	$/Unit	Pricing

$Year 1

					$ -
					$ -
					$ -
					$ -
					$ -
					$ -
Total 3rd Party Add-On Price					$ -
Other One-Time Costs - Including Software Training
List Detail	Functionality Provided	Unit Type	# of Units	$/Unit	$ Year 1
					$ -
					$ -
					$ -
					$ -
					$ -
					$ -
					$ -
					$ -
					$ -
					$ -
					$ -
					$ -
					$ -
					$ -
					$ -
Total Other One-Time Costs					$ -

4a. Services Fixed-Price

	Implementation Services
	Fixed Price Services - For Services Required For Go-Live
	Deliverable or Cost Category - Required Items
(assuming a "vanilla" / no-modifications implementation project)	Additional Description of Services
(Please reference relevant sections of offer written reponse)	One-Time, Fixed-Price

TOTAL ONE-TIME COST FOR REQUIRED ITEMS: $ -

	Fixed Price Services - For OPTIONAL Services
	Deliverable or Cost Category - Optional Items - Fixed Price
	Additional Description of Services
(Please reference relevant sections of offer written reponse)	Optional One-Time, Fixed Price

TOTAL ONE-TIME COST FOR OPTIONAL ITEMS: $ -

4b. Services Time & Mat.

	Implementation Services
	Not to Exceed Time & Materials Services - For Services Required For Go-Live
	Deliverable or Cost Category - Required Items
(assuming a "vanilla" / no-modifications implementation project)	Additional Description of Services
(Please reference relevant sections of offer written reponse)	One-Time, Time & Materials

TOTAL ONE-TIME COST FOR REQUIRED ITEMS: $ -

	Not to Exceed Time & Materials Services - For OPTIONAL Services
	Deliverable or Cost Category - Optional Items - Fixed Price
	Additional Description of Services
(Please reference relevant sections of offer written reponse)	Optional One-Time, Time & Materials Price

	TOTAL ONE-TIME COST FOR OPTIONAL ITEMS:	$ -
Justification for using this pricing model instead of fixed price.

5. Services Hourly Rate Card

Implementation Services Hourly Rate Card
Position	2021		2022		Total Vendor Hours / Position	Total Vendor Cost / Position	Budgeted Travel and Living Cost For This Position
	Hourly Rate ($/Hr)	Projected Vendor Hours	Hourly Rate ($/Hr)	Projected Vendor Hours
Project Manager					0	$ -
Technical Lead					0	$ -
Technical Staff					0	$ -
Functional Lead					0	$ -
Functional Staff					0	$ -
					0	$ -
					0	$ -
					0	$ -
					0	$ -
					0	$ -
					0	$ -
					0	$ -
					0	$ -
					0	$ -
					0	$ -
TOTAL Estimated Hours & Cost		0		0	0	$ -	$ -
					BLENDED HOURLY RATE	TBD

The above list must include ALL Positions that the vendor plans to bill during this project.

6. USMMA Resource Hours

USMMA SIS Replacement Project
USMMA Resources Plan		2021 Hours												2022 Hours
Role	Total Hours	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
TOTALS	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
USMMA Project Office Staff
	0
	0
	0
	0
	0
USMMA Functional Staff
	0
	0
	0
	0
	0
	0
	0
	0
	0
	0
USMMA Technical Staff
	0
	0
	0
	0
	0
	0
	0
	0
	0
	0
USMMA - Other Project Staff
	0
	0
	0
	0
	0
	0
	0
	0
	0
	0

7. Offeror Resource Hours

USMMA SIS Replacement Project
Offeror / Implementation Partner Resources Plan		2021 Hours												2022 Hours
Role	Total Hours	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
TOTALS	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
Offeror Project Office Staff
	0
	0
	0
	0
	0
Offeror Functional Staff
	0
	0
	0
	0
	0
	0
	0
	0
	0
	0
Offeror Technical Staff
	0
	0
	0
	0
	0
	0
	0
	0
	0
	0
Offeror - Other Project Staff
	0
	0
	0
	0
	0
	0
	0
	0
	0
	0

8. Assumptions Pricing Proposal Assumptions

	NOTE: This is a free format page. Offerors can include any information/assumptions that they wish to include. However, any contract terms and conditions should be included within the Offeror's standard product agreement.
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
51
52
53
54
55
56
57
58
59
60

File details come from the government source that posted it. Updated Oct 21, 2020.