Attachment 5.xlsx

XLSX spreadsheet 48 KB Posted Aug 16, 2012

Attached to: Support Services for FHWAs Office of Technical Services, with Specific Focus on the National Highway Institute, the Technology Partnerships Program, and the Knowledge Application Team
Solicitation number: DTFH61-12-R-00054
Issued by: Department of Transportation Federal Highway Administration

About this file

From the source

Attachment 5 - Price Template

View the file

Other files

File	Type	Posted
DTFH61-12-R-00054 - Responses to Questions.pdf	PDF	Sep 5, 2012
DTFH61-12-R-00054 Amendment 2.PDF	PDF	Sep 5, 2012
DTFH61-12-R-00054 - Pre-Proposal Web-Conference Record.pdf	PDF	Aug 29, 2012
DTFH61-12-R-00054 Amendment 1.PDF	PDF	Aug 29, 2012
Attachment 2.pdf	PDF	Aug 16, 2012
Attachment 4.pdf	PDF	Aug 16, 2012
Attachment 7.docx	DOCX document	Aug 16, 2012
Attachment 3.pdf	PDF	Aug 16, 2012
Attachment 6.pdf	PDF	Aug 16, 2012
RFP- DTFH61-12-R-00054.pdf	PDF	Aug 16, 2012
Attachment 1.pdf	PDF	Aug 16, 2012

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.

Summary Cost Category Price Year 1 Price Year 2 Price Year 3 Price Year 4 Price Year 5 Five Year Total

Labor

Other Direct Costs

Travel

Subtotal for Travel &Other Direct Costs

Grand Total $0.00

RFP: DTFH61-12-R-00054

Attachment 5: Price Template

Year 1

	Cost Category	Direct Hourly Labor Rate	Annual Hours	Fringe	G&A	Overhead	Profit	Loaded Rated Year 1	Total Year 1
	LABOR
1	Administrative Assistant		1900
2	Administrative Assistant		1900
3	Administrative Assistant		1900
4	Administrative Assistant		1900
5	Business Analyst - high		1900
6	Business Analyst - high		1900
7	Business Analyst - mid		1900
8	Business Analyst - mid		1900
9	Business Analyst - mid		1900
10	Business Analyst - mid		1900
11	Business Analyst - mid		1900
12	Financial Analyst		1900
13	ISD - high		1250
14	ISD - high		1900
15	ISD - high		1900
16	ISD - high		1900
17	ISD - high		1900
18	ISD - high		1900
19	ISD - low		1900
20	ISD - low		1900
21	Materials Manager		1900
22	Transportation Analyst		1900
23	Project Manager		1900
24	Business Analyst - low		1900
25	Business Analyst - mid		1900
26	Marketing Analyst		1900
27	Graphics Designer - high		200
28	Graphics Designer - mid		200
29	Graphics Designer - low		200
30	Learning Management Specialist		200
31	ISD - high		1000
32	ISD - mid		1000
33	ISD - low		1000
34	Administrative Support		1900
35	Marketing Manager and Specialist		400
36	IT Specialist - high		200
37	IT Specialist - mid		200
38	IT Specialist - low		200
39	Business Analyst - high		1900
40	Business Analyst - mid		1900
41	Business Analyst - low		1900
42	Transportation SME - high		200
43	Transportation SME - mid		200
44	Transportation SME - low		200

Total Labor $0.00

Other Direct Costs

Travel Estimate

Total Other Direct Costs & Travel $0.00

Grand Total: $0.00

Attachment 5: Price Template

Year 2

	Cost Category	Direct Hourly Labor Rate	Annual Hours	Fringe	G&A	Overhead	Profit	Loaded Rated Year 2	Total Year 2
	LABOR
1	Administrative Assistant		1900
2	Administrative Assistant		1900
3	Administrative Assistant		1900
4	Administrative Assistant		1900
5	Business Analyst - high		1900
6	Business Analyst - high		1900
7	Business Analyst - mid		1900
8	Business Analyst - mid		1900
9	Business Analyst - mid		1900
10	Business Analyst - mid		1900
11	Business Analyst - mid		1900
12	Financial Analyst		1900
13	ISD - high		1250
14	ISD - high		1900
15	ISD - high		1900
16	ISD - high		1900
17	ISD - high		1900
18	ISD - high		1900
19	ISD - low		1900
20	ISD - low		1900
21	Materials Manager		1900
22	Transportation Analyst		1900
23	Project Manager		1900
24	Business Analyst - low		1900
25	Business Analyst - mid		1900
26	Marketing Analyst		1900
27	Graphics Designer - high		200
28	Graphics Designer - mid		200
29	Graphics Designer - low		200
30	Learning Management Specialist		200
31	ISD - high		1000
32	ISD - mid		1000
33	ISD - low		1000
34	Administrative Support		1900
35	Marketing Manager and Specialist		400
36	IT Specialist - high		200
37	IT Specialist - mid		200
38	IT Specialist - low		200
39	Business Analyst - high		1900
40	Business Analyst - mid		1900
41	Business Analyst - low		1900
42	Transportation SME - high		200
43	Transportation SME - mid		200
44	Transportation SME - low		200

Total Labor $0.00

Other Direct Costs

Travel Estimate

Total Other Direct Costs & Travel $0.00

Grand Total: $0.00

Attachment 5: Price Template

Year 3

	Cost Category	Direct Hourly Labor Rate	Annual Hours	Fringe	G&A	Overhead	Profit	Loaded Rated Year 3	Total Year 3
	LABOR
1	Administrative Assistant		1900
2	Administrative Assistant		1900
3	Administrative Assistant		1900
4	Administrative Assistant		1900
5	Business Analyst - high		1900
6	Business Analyst - high		1900
7	Business Analyst - mid		1900
8	Business Analyst - mid		1900
9	Business Analyst - mid		1900
10	Business Analyst - mid		1900
11	Business Analyst - mid		1900
12	Financial Analyst		1900
13	ISD - high		1250
14	ISD - high		1900
15	ISD - high		1900
16	ISD - high		1900
17	ISD - high		1900
18	ISD - high		1900
19	ISD - low		1900
20	ISD - low		1900
21	Materials Manager		1900
22	Transportation Analyst		1900
23	Project Manager		1900
24	Business Analyst - low		1900
25	Business Analyst - mid		1900
26	Marketing Analyst		1900
27	Graphics Designer - high		200
28	Graphics Designer - mid		200
29	Graphics Designer - low		200
30	Learning Management Specialist		200
31	ISD - high		1000
32	ISD - mid		1000
33	ISD - low		1000
34	Administrative Support		1900
35	Marketing Manager and Specialist		400
36	IT Specialist - high		200
37	IT Specialist - mid		200
38	IT Specialist - low		200
39	Business Analyst - high		1900
40	Business Analyst - mid		1900
41	Business Analyst - low		1900
42	Transportation SME - high		200
43	Transportation SME - mid		200
44	Transportation SME - low		200

Total Labor $0.00

Other Direct Costs

Travel Estimate

Total Other Direct Costs & Travel $0.00

Grand Total: $0.00

Attachment 5: Price Template

Year 4

	Cost Category	Direct Hourly Labor Rate	Annual Hours	Fringe	G&A	Overhead	Profit	Loaded Rated Year 4	Total Year 4
	LABOR
1	Administrative Assistant		1900
2	Administrative Assistant		1900
3	Administrative Assistant		1900
4	Administrative Assistant		1900
5	Business Analyst - high		1900
6	Business Analyst - high		1900
7	Business Analyst - mid		1900
8	Business Analyst - mid		1900
9	Business Analyst - mid		1900
10	Business Analyst - mid		1900
11	Business Analyst - mid		1900
12	Financial Analyst		1900
13	ISD - high		1250
14	ISD - high		1900
15	ISD - high		1900
16	ISD - high		1900
17	ISD - high		1900
18	ISD - high		1900
19	ISD - low		1900
20	ISD - low		1900
21	Materials Manager		1900
22	Transportation Analyst		1900
23	Project Manager		1900
24	Business Analyst - low		1900
25	Business Analyst - mid		1900
26	Marketing Analyst		1900
27	Graphics Designer - high		200
28	Graphics Designer - mid		200
29	Graphics Designer - low		200
30	Learning Management Specialist		200
31	ISD - high		1000
32	ISD - mid		1000
33	ISD - low		1000
34	Administrative Support		1900
35	Marketing Manager and Specialist		400
36	IT Specialist - high		200
37	IT Specialist - mid		200
38	IT Specialist - low		200
39	Business Analyst - high		1900
40	Business Analyst - mid		1900
41	Business Analyst - low		1900
42	Transportation SME - high		200
43	Transportation SME - mid		200
44	Transportation SME - low		200

Total Labor $0.00

Other Direct Costs

Travel Estimate

Total Other Direct Costs & Travel $0.00

Grand Total: $0.00

Attachment 5: Price Template

Year 5

	Cost Category	Direct Hourly Labor Rate	Annual Hours	Fringe	G&A	Overhead	Profit	Loaded Rated Year 5	Total Year 5
	LABOR
1	Administrative Assistant		1900
2	Administrative Assistant		1900
3	Administrative Assistant		1900
4	Administrative Assistant		1900
5	Business Analyst - high		1900
6	Business Analyst - high		1900
7	Business Analyst - mid		1900
8	Business Analyst - mid		1900
9	Business Analyst - mid		1900
10	Business Analyst - mid		1900
11	Business Analyst - mid		1900
12	Financial Analyst		1900
13	ISD - high		1250
14	ISD - high		1900
15	ISD - high		1900
16	ISD - high		1900
17	ISD - high		1900
18	ISD - high		1900
19	ISD - low		1900
20	ISD - low		1900
21	Materials Manager		1900
22	Transportation Analyst		1900
23	Project Manager		1900
24	Business Analyst - low		1900
25	Business Analyst - mid		1900
26	Marketing Analyst		1900
27	Graphics Designer - high		200
28	Graphics Designer - mid		200
29	Graphics Designer - low		200
30	Learning Management Specialist		200
31	ISD - high		1000
32	ISD - mid		1000
33	ISD - low		1000
34	Administrative Support		1900
35	Marketing Manager and Specialist		400
36	IT Specialist - high		200
37	IT Specialist - mid		200
38	IT Specialist - low		200
39	Business Analyst - high		1900
40	Business Analyst - mid		1900
41	Business Analyst - low		1900
42	Transportation SME - high		200
43	Transportation SME - mid		200
44	Transportation SME - low		200

Total Labor $0.00

Other Direct Costs

Travel Estimate

Total Other Direct Costs & Travel $0.00

Grand Total: $0.00

Attachment 5: Price Template

Position Descriptions

	Position	Type	Technical Classification	Primary job description
1	Administrative Assistant	Onsite Core Positions	End user of technology	Front desk support such as answering phones and greeting visitors
2	Administrative Assistant	Onsite Core Positions	End user of technology	Training room and conference coordination
3	Administrative Assistant	Onsite Core Positions	End user of technology	General office support
4	Administrative Assistant	Onsite Core Positions	End user of technology	Administrative support to director
5	Business Analyst - high	Onsite Core Positions	End user of technology	Project management and facilitation for LTAP/TTAP outreach and meetings
6	Business Analyst - high	Onsite Core Positions	End user of technology	Special projects such as updating Web based training due to software upgrades
7	Business Analyst - mid	Onsite Core Positions	End user of technology	Project support for Universities and Grants
8	Business Analyst - mid	Onsite Core Positions	End user of technology	Project support for Universities and Grants
9	Business Analyst - mid	Onsite Core Positions	End user of technology	Project support for Universities and Grants
10	Business Analyst - mid	Onsite Core Positions	End user of technology	Customer support for Web Conferences
11	Business Analyst - mid	Onsite Core Positions	End user of technology	Project and customer support for Web conferences
12	Financial Analyst	Onsite Core Positions	End user of technology	Financial analysis support
13	ISD - high	Onsite Core Positions	End user of technology	Instructor liaison
14	ISD - high	Onsite Core Positions	End user of technology	Instructional system designer - NHI standards, ISD review, upload WBTs
15	ISD - high	Onsite Core Positions	End user of technology	Instructional system designer - NHI standards, ISD review, upload WBTs
16	ISD - high	Onsite Core Positions	End user of technology	Instructional system designer - NHI standards, ISD review, upload WBTs
17	ISD - high	Onsite Core Positions	End user of technology	Instructional system designer - NHI standards, ISD review, upload WBTs
18	ISD - high	Onsite Core Positions	End user of technology	Instructional system designer - NHI standards, ISD review, upload WBTs
19	ISD - low	Onsite Core Positions	End user of technology	Instructional system designer - NHI standards, ISD review, upload WBTs
20	ISD - low	Onsite Core Positions	End user of technology	Instructional system designer - NHI standards, ISD review, upload WBTs
21	Materials Manager	Onsite Core Positions	End user of technology	Order and manage materials fulfillment for instructor led courses and NHI store
22	Transportation Analyst	Onsite Core Positions	End user of technology	Project support for LTAP/TTAP with transportation expertise
23	Project Manager	Onsite Core Positions	End user of technology	Project manager of support services contract
24	Business Analyst - low	Optional Systems and Marketing	Technical	Develop basic change requests, test changes to site, customer support
25	Business Analyst - mid	Optional Systems and Marketing	Technical	Develop advanced change requests, test changes to site, advanced data analysis
26	Marketing Analyst	Optional Systems and Marketing	End user of technology	Provide marketing support including developing and sending bluelines, conference support
27	Graphics Designer - high	Special Projects	End user of technology	Develop graphics such as for a specific campaign or rebranding
28	Graphics Designer - mid	Special Projects	End user of technology	Develop graphics such as for a specific campaign or rebranding
29	Graphics Designer - low	Special Projects	End user of technology	Develop graphics such as for a specific campaign or rebranding
30	Learning Management Specialist	Special Projects	Technical	Provide technical best practices on LMS design, development, and operation
31	ISD - high	Special Projects	End user of technology	Provide ISD support for special projects
32	ISD - low	Special Projects	End user of technology	Provide ISD support for special projects
33	ISD - mid	Special Projects	End user of technology	Provide ISD support for special projects
34	Administrative Support	Special Projects	End user of technology	Provide Administrative support for special projects such as data entry
35	Marketing Manager and Specialist	Special Projects	End user of technology	Provide marketing best practices and project management
36	IT Specialist - mid	Special Projects	Technical	Provide technical best practices and guidance on NHI IT systems such as related to integration of complex systems
37	IT Specialist - low	Special Projects	Technical	Provide technical best practices and guidance on NHI IT systems such as related to integration of complex systems
38	IT Specialist - high	Special Projects	Technical	Provide technical best practices and guidance on NHI IT systems such as related to integration of complex systems
39	Business Analyst - high	Special Projects	End user of technology	Provide business analyst support such as for complex projects or analysis
40	Business Analyst - mid	Special Projects	End user of technology	Provide business analyst support such as for complex projects or analysis
41	Business Analyst - low	Special Projects	End user of technology	Provide business analyst support such as for complex projects or analysis
42	Transportation SME - high	Special Projects	End user of technology	Instruct NHI courses or serve as a Subject Matter Expert for course development
43	Transportation SME - mid	Special Projects	End user of technology	Instruct NHI courses or serve as a Subject Matter Expert for course development
44	Transportation SME - low	Special Projects	End user of technology	Instruct NHI courses or serve as a Subject Matter Expert for course development

Attachment 5: Price Template

File details come from the government source that posted it. Updated Nov 14, 2017.