47QFAA24R0004_T10_08d_Attachment 5 Task Order 01 Pricing Spreadsheet for Evaluation_2024-06-10.xlsx

XLSX spreadsheet 89 KB Posted Jun 26, 2024

Attached to: Budget Department Management System (BDMS) Implementation & Support Services for PBGC Federal contract opportunity
Solicitation number: 47QFAA24R0004
Issued by: General Services Administration Federal Acquisition Service Assisted Acquisition Services Region 1

About this file

Written by GovTribe AI · Jun 26, 2024

This document is a pricing spreadsheet template for a federal contract opportunity for Budget Department Management System (BDMS) Implementation & Support Services for the Pension Benefit Guaranty Corporation (PBGC).

The template requires offerors to provide fully burdened labor rates, travel rates, other direct costs, and G&A/M&H rates for various labor categories over a base year and nine option years. The labor categories include roles such as SCRUM Master, Project Manager, Business Analyst, Trainer, and various levels of Subject Matter Experts and Developers. Offerors must also provide rationale for any additional labor categories proposed. The total evaluated price and total price for award are calculated based on the labor, travel, and ODC amounts entered. This template will be used as part of the pricing submission for Solicitation Number 47QFAA24R0004 for the BDMS Implementation & Support Services contract.

View the file

Other files for this federal contract opportunity

Other files attached to Budget Department Management System (BDMS) Implementation & Support Services for PBGC, newest first.
File	Type	Posted
47QFAA24R0004_T10_08a Solicitation_RFP_2024-07-16 Amendment 3.docx	DOCX document	Jul 16, 2024
47QFAA24R0004_T10_08a Solicitation_RFP_2024-07-12.docx	DOCX document	Jul 12, 2024
47QFAA24R0004_T10_08d_Attachment 6_Prior Experience Worksheet_2024-07-12.xlsx	XLSX spreadsheet	Jul 12, 2024
47QFAA24R0004_T10_08d_Attachment 4_Task Order 01 Labor Category Positions and Key Personnel_2024-07-12.xlsx	XLSX spreadsheet	Jul 12, 2024
47QFAA24R0004 Questions and Answers 12 July 2024.xlsx	XLSX spreadsheet	Jul 12, 2024
47QFAA24R0004_T10_08a Solicitation_RFP_2024-07-03.pdf	PDF	Jul 3, 2024
47QFAA24R0004_T10_08d_Attachment 10_ITSLCM Handbook_2024-06-10.pdf	PDF	Jun 26, 2024
47QFAA24R0004_T10_08d_Attachment 15 Section K Full Text Reps and Certs_2024-06-10.pdf	PDF	Jun 26, 2024
47QFAA24R0004_T10_08d_Attachment 11_IT Solutions Life Cycle Management (ITSLCM) Framework_2024-06-10.pdf	PDF	Jun 26, 2024
47QFAA24R0004_T10_08d_Attachment 7_Past Performance Questionnaire and Reference Sheet_2024-06-10.docx	DOCX document	Jun 26, 2024
47QFAA24R0004_T10_08d_Attachment 3_IDIQ Master Staffing Plan_2024-06-10.xlsx	XLSX spreadsheet	Jun 26, 2024
47QFAA24R0004_T04_02a_BRAND NAME JA_2024-06-04.pdf	PDF	Jun 26, 2024
47QFAA24R0004_T10_08a Solicitation_RFP_2024-06-05.pdf	PDF	Jun 26, 2024
47QFAA24R0004_T10_08d_Attachment 14_GSA CUI Guide_2024-06-10.pdf	PDF	Jun 26, 2024
47QFAA24R0004_T10_08b_Attachment 1_Task Order 01 CLINs 0001 and 0002 PWS_2024-06-10.pdf	PDF	Jun 26, 2024
47QFAA24R0004_T10_08d_Attachment 12 BISD Operating Model Playbook - The 6 Plays_2024-06-10.pdf	PDF	Jun 26, 2024
47QFAA24R0004_T10_08b_Attachment 2 Task Order 01 CLIN 0003 Statement of Objectives_2024-06-10.pdf	PDF	Jun 26, 2024
47QFAA24R0004_T10_08d_Attachment 6_Prior Experience Worksheet_2024-06-10.xlsx	XLSX spreadsheet	Jun 26, 2024
47QFAA24R0004_T10_08d_Attachment 13 Consent to Purchase (CTP) Form_2024-06-10.xlsx	XLSX spreadsheet	Jun 26, 2024
47QFAA24R0004_T10_08d_Attachment 4_Task Order 01 Labor Category Positions and Key Personnel_2024-06-10 _.xlsx	XLSX spreadsheet	Jun 26, 2024
47QFAA24R0004_T10_08d_Attachment 9_BDMS Design Document_2024-06-10.pdf	PDF	Jun 26, 2024
47QFAA24R0004_T10_08c_Attachment 8_Task Order 01 QASP_2024-06-07.pdf	PDF	Jun 26, 2024

Show all 22

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.

Pricing Cover Sheet

47QFAA24R0004

Attachment 3 Part 1 (Pricing Cover Sheet)

Offeror to complete responses within the yellow fields.

1	Company Name:
2	Address:
4	DUNS Number:
	UEI Number:
6	Pricing good for 150 days?
7	Proposed hourly rates are fully burdened? (yes/no)
9	Proposed G&A/M&H rate is fixed for the life of the order? (yes/no)
10	Proposed Travel Mark-up rate is fixed for the life of the order? (yes/no)

Sign and Date Here:

Please complete this form, sign, print, and include in PDF Portfolio 4

Pricing Summary

Directions: Only fill in Labor Totals in Yellow Boxes. These totals come from the tabs in this worksheet. Fill in proposed percentage amounts for Travel, Travel Mark-Up, ODCs, and G&A/M&H rates in Yellow Boxes (D6:L15).
Year	Labor Total	Travel	Travel with Mark-Up	Other Direct Costs (ODCs)	ODCs with Mark-Up	Total Evaluated Price	Total Proposed Price	Travel Mark-Up	G&A/M&H Rate (Indirect)
Base Year	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Option Year 1	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Option Year 2	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Option Year 3	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Option Year 4	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Option Year 5	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Option Year 6	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Option Year 7	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Option Year 8	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Option Year 9	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
6-Month Option (FAR 52.217-8)	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Total Evaluated Price	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Total Price for Award	$0.00	$0.00		$0.00			$0.00

Prompt Payment Terms

Base Year

Directions: Input the total Number of Positions needed for each Labor Category (Column C), Hours per Person (Column D), and provide a labor rate for each Labor Category (Column F). The Total Estimated Direct Labor Dollars in cell G22 is the total Labor Price that will be automatically inputed on the Pricing Summary Sheet for this Period of Performance.
Labor Category Description	Number of Positions	Hours per Person	Total Hours (Base)	Labor Rate	Total (Base)	Travel	Other Direct Costs	Total (Base)
SCRUM Master			0		$0.00
Project Manager - Level III			0
Business Analyst - Level III			0
Trainer			0
Organizational Change Manager			0
Technical Lead			0
System Administrator			0
Developer - SME II			0
Developer - SME I			0
Enterprise Architect			0
Subject Matter Expert I			0
Subject Matter Expert II			0
Subject Matter Expert III			0
Technical Writer			0
Training Specialist Level I			0
Training Specialist Level II			0
Total Estimated Direct Labor Hours			0
Total Estimated Direct Labor Dollars					$0.00	$0.00	$0.00	$0.00

Option Year 1

Directions: Input the total Number of Positions needed for each Labor Category (Column C), Hours per Person (Column D), and provide a labor rate for each Labor Category (Column F). The Total Estimated Direct Labor Dollars in cell G22 is the total Labor Price that will be automatically inputed on the Pricing Summary Sheet for this Period of Performance.
Labor Category Description	Number of Positions	Hours per Person	Total Hours (Option Year 1)	Labor Rate	Total (Option Year 1)	Travel	Other Direct Costs	Total (Option Year 1)
SCRUM Master			0		$0.00
Project Manager - Level III			0
Business Analyst - Level III			0
Trainer			0
Organizational Change Manager			0
Technical Lead			0
System Administrator			0
Developer - SME II			0
Developer - SME I			0
Enterprise Architect			0
Subject Matter Expert I			0
Subject Matter Expert II			0
Subject Matter Expert III			0
Technical Writer			0
Training Specialist Level I			0
Training Specialist Level II			0
Total Estimated Direct Labor Hours			0
Total Estimated Direct Labor Dollars					$0.00	$0.00	$0.00	$0.00

Option Year 2

Directions: Input the total Number of Positions needed for each Labor Category (Column C), Hours per Person (Column D), and provide a labor rate for each Labor Category (Column F). The Total Estimated Direct Labor Dollars in cell G22 is the total Labor Price that will be automatically inputed on the Pricing Summary Sheet for this Period of Performance.
Labor Category Description	Number of Positions	Hours per Person	Total Hours (Option Year 2)	Labor Rate	Total (Option Year 2)	Travel	Other Direct Costs	Total (Option Year 2)
SCRUM Master			0		$0.00
Project Manager - Level III			0
Business Analyst - Level III			0
Trainer			0
Organizational Change Manager			0
Technical Lead			0
System Administrator			0
Developer - SME II			0
Developer - SME I			0
Enterprise Architect			0
Subject Matter Expert I			0
Subject Matter Expert II			0
Subject Matter Expert III			0
Technical Writer			0
Training Specialist Level I			0
Training Specialist Level II			0
Total Estimated Direct Labor Hours			0
Total Estimated Direct Labor Dollars					$0.00	$0.00	$0.00	$0.00

Option Year 3

Directions: Input the total Number of Positions needed for each Labor Category (Column C), Hours per Person (Column D), and provide a labor rate for each Labor Category (Column F). The Total Estimated Direct Labor Dollars in cell G22 is the total Labor Price that will be automatically inputed on the Pricing Summary Sheet for this Period of Performance.
Labor Category Description	Number of Positions	Hours per Person	Total Hours (Option Year 3)	Labor Rate	Total (Option Year 3)	Travel	Other Direct Costs	Total (Option Year 3)
SCRUM Master			0		$0.00
Project Manager - Level III			0
Business Analyst - Level III			0
Trainer			0
Organizational Change Manager			0
Technical Lead			0
System Administrator			0
Developer - SME II			0
Developer - SME I			0
Enterprise Architect			0
Subject Matter Expert I			0
Subject Matter Expert II			0
Subject Matter Expert III			0
Technical Writer			0
Training Specialist Level I			0
Training Specialist Level II			0
Total Estimated Direct Labor Hours			0
Total Estimated Direct Labor Dollars					$0.00	$0.00	$0.00	$0.00

Option Year 4

Directions: Input the total Number of Positions needed for each Labor Category (Column C), Hours per Person (Column D), and provide a labor rate for each Labor Category (Column F). The Total Estimated Direct Labor Dollars in cell G22 is the total Labor Price that will be automatically inputed on the Pricing Summary Sheet for this Period of Performance.
Labor Category Description	Number of Positions	Hours per Person	Total Hours (Option Year 4)	Labor Rate	Total (Option Year 4)	Travel	Other Direct Costs	Total (Option Year 4)
SCRUM Master			0		$0.00
Project Manager - Level III			0
Business Analyst - Level III			0
Trainer			0
Organizational Change Manager			0
Technical Lead			0
System Administrator			0
Developer - SME II			0
Developer - SME I			0
Enterprise Architect			0
Subject Matter Expert I			0
Subject Matter Expert II			0
Subject Matter Expert III			0
Technical Writer			0
Training Specialist Level I			0
Training Specialist Level II			0
Total Estimated Direct Labor Hours			0
Total Estimated Direct Labor Dollars					$0.00	$0.00	$0.00	$0.00

Option Year 5

Directions: Input the total Number of Positions needed for each Labor Category (Column C), Hours per Person (Column D), and provide a labor rate for each Labor Category (Column F). The Total Estimated Direct Labor Dollars in cell G22 is the total Labor Price that will be automatically inputed on the Pricing Summary Sheet for this Period of Performance.
Labor Category Description	Number of Positions	Hours per Person	Total Hours (Option Year 5)	Labor Rate	Total (Option Year 5)	Travel	Other Direct Costs	Total (Option Year 5)
SCRUM Master			0		$0.00
Project Manager - Level III			0
Business Analyst - Level III			0
Trainer			0
Organizational Change Manager			0
Technical Lead			0
System Administrator			0
Developer - SME II			0
Developer - SME I			0
Enterprise Architect			0
Subject Matter Expert I			0
Subject Matter Expert II			0
Subject Matter Expert III			0
Technical Writer			0
Training Specialist Level I			0
Training Specialist Level II			0
Total Estimated Direct Labor Hours			0
Total Estimated Direct Labor Dollars					$0.00	$0.00	$0.00	$0.00

Option Year 6

Directions: Input the total Number of Positions needed for each Labor Category (Column C), Hours per Person (Column D), and provide a labor rate for each Labor Category (Column F). The Total Estimated Direct Labor Dollars in cell G22 is the total Labor Price that will be automatically inputed on the Pricing Summary Sheet for this Period of Performance.
Labor Category Description	Number of Positions	Hours per Person	Total Hours (Option Year 6)	Labor Rate	Total (Option Year 6)	Travel	Other Direct Costs	Total (Option Year 6)
SCRUM Master			0		$0.00
Project Manager - Level III			0
Business Analyst - Level III			0
Trainer			0
Organizational Change Manager			0
Technical Lead			0
System Administrator			0
Developer - SME II			0
Developer - SME I			0
Enterprise Architect			0
Subject Matter Expert I			0
Subject Matter Expert II			0
Subject Matter Expert III			0
Technical Writer			0
Training Specialist Level I			0
Training Specialist Level II			0
Total Estimated Direct Labor Hours			0
Total Estimated Direct Labor Dollars					$0.00	$0.00	$0.00	$0.00

Option Year 7

Directions: Input the total Number of Positions needed for each Labor Category (Column C), Hours per Person (Column D), and provide a labor rate for each Labor Category (Column F). The Total Estimated Direct Labor Dollars in cell G22 is the total Labor Price that will be automatically inputed on the Pricing Summary Sheet for this Period of Performance.
Labor Category Description	Number of Positions	Hours per Person	Total Hours (Option Year 7)	Labor Rate	Total (Option Year 7)	Travel	Other Direct Costs	Total (Option Year 7)
SCRUM Master			0		$0.00
Project Manager - Level III			0
Business Analyst - Level III			0
Trainer			0
Organizational Change Manager			0
Technical Lead			0
System Administrator			0
Developer - SME II			0
Developer - SME I			0
Enterprise Architect			0
Subject Matter Expert I			0
Subject Matter Expert II			0
Subject Matter Expert III			0
Technical Writer			0
Training Specialist Level I			0
Training Specialist Level II			0
Total Estimated Direct Labor Hours			0
Total Estimated Direct Labor Dollars					$0.00	$0.00	$0.00	$0.00

Option Year 8

Directions: Input the total Number of Positions needed for each Labor Category (Column C), Hours per Person (Column D), and provide a labor rate for each Labor Category (Column F). The Total Estimated Direct Labor Dollars in cell G22 is the total Labor Price that will be automatically inputed on the Pricing Summary Sheet for this Period of Performance.
Labor Category Description	Number of Positions	Hours per Person	Total Hours (Option Year 8)	Labor Rate	Total (Option Year 8)	Travel	Other Direct Costs	Total (Option Year 8)
SCRUM Master			0		$0.00
Project Manager - Level III			0
Business Analyst - Level III			0
Trainer			0
Organizational Change Manager			0
Technical Lead			0
System Administrator			0
Developer - SME II			0
Developer - SME I			0
Enterprise Architect			0
Subject Matter Expert I			0
Subject Matter Expert II			0
Subject Matter Expert III			0
Technical Writer			0
Training Specialist Level I			0
Training Specialist Level II			0
Total Estimated Direct Labor Hours			0
Total Estimated Direct Labor Dollars					$0.00	$0.00	$0.00	$0.00

Option Year 9

Directions: Input the total Number of Positions needed for each Labor Category (Column C), Hours per Person (Column D), and provide a labor rate for each Labor Category (Column F). The Total Estimated Direct Labor Dollars in cell G22 is the total Labor Price that will be automatically inputed on the Pricing Summary Sheet for this Period of Performance.
Labor Category Description	Number of Positions	Hours per Person	Total Hours (Option Year 9)	Labor Rate	Total (Option Year 9)	Travel	Other Direct Costs	Total (Option Year 9)
SCRUM Master			0		$0.00
Project Manager - Level III			0
Business Analyst - Level III			0
Trainer			0
Organizational Change Manager			0
Technical Lead			0
System Administrator			0
Developer - SME II			0
Developer - SME I			0
Enterprise Architect			0
Subject Matter Expert I			0
Subject Matter Expert II			0
Subject Matter Expert III			0
Technical Writer			0
Training Specialist Level I			0
Training Specialist Level II			0
Total Estimated Direct Labor Hours			0
Total Estimated Direct Labor Dollars					$0.00	$0.00	$0.00	$0.00

ESRI_MAPINFO_SHEET

DO NOT EDIT

For Esri use only

Additional Labor Categories

Directions: Provide any additional necessary Labor Categories in Column B, number of positions in Column C, number of Hours per Person in Column D, and Labor Rate in Column F. The Total Estimated Direct Labor Dollars for each Additional Labor Category, per Period of Performance, if deemed appropriate to this effort, will be added to the labor totals calculated in each Period of Performance on those pages by the CO prior to award. Below the chart, please input the Additional Labor Category name again and complete the rationale for its inclusion in this task order (currently at B45-C:49).
Labor Category Description	Number of Positions	Hours per Person	Total Hours (Base)	Labor Rate	Base Labor Total	Hours per Person	Total Hours (Option 1)	Labor Rate	Option 1 Labor Total	Hours per Person	Total Hours (Option 2)	Labor Rate	Option 2 Labor Total	Hours per Person	Total Hours (Option 3)	Labor Rate	Option 3 Labor Total	Hours per Person	Total Hours (Option 4)	Labor Rate	Option 4 Labor Total
Additional Labor Category 1			0		$0.00		0		$0.00		0		$0.00		0		$0.00		0		$0.00
Additional Labor Category 2			0		$0.00		0		$0.00		0		$0.00		0		$0.00		0		$0.00
Additional Labor Category 3			0		$0.00		0		$0.00		0		$0.00		0		$0.00		0		$0.00
Additional Labor Category 4			0		$0.00		0		$0.00		0		$0.00		0		$0.00		0		$0.00
Additional Labor Category 5			0		$0.00		0		$0.00		0		$0.00		0		$0.00		0		$0.00
Additional Labor Category 6			0		$0.00		0		$0.00		0		$0.00		0		$0.00		0		$0.00
Additional Labor Category 7			0		$0.00		0		$0.00		0		$0.00		0		$0.00		0		$0.00
Additional Labor Category 8			0		$0.00		0		$0.00		0		$0.00		0		$0.00		0		$0.00
Additional Labor Category 9			0		$0.00		0		$0.00		0		$0.00		0		$0.00		0		$0.00
Additional Labor Category 10			0		$0.00		0		$0.00		0		$0.00		0		$0.00		0		$0.00
Total Estimated Direct Labor Hours			0		$0.00		0		$0.00		0		$0.00		0		$0.00		0		$0.00

Labor Category Description	Number of Positions	Hours per Person	Total Hours (Option 5)	Labor Rate	Option 5 Labor Total	Hours per Person	Total Hours (Option 6)	Labor Rate	Option 6 Labor Total	Hours per Person	Total Hours (Option 7)	Labor Rate	Option 7 Labor Total	Hours per Person	Total Hours (Option 8)	Labor Rate	Option 8 Labor Total	Hours per Person	Total Hours (Option 9)	Labor Rate	Option 9 Labor Total
Additional Labor Category 1			0		$0.00		0		$0.00		0		$0.00		0		$0.00		0		$0.00
Additional Labor Category 2			0		$0.00		0		$0.00		0		$0.00		0		$0.00		0		$0.00
Additional Labor Category 3			0		$0.00		0		$0.00		0		$0.00		0		$0.00		0		$0.00
Additional Labor Category 4			0		$0.00		0		$0.00		0		$0.00		0		$0.00		0		$0.00
Additional Labor Category 5			0		$0.00		0		$0.00		0		$0.00		0		$0.00		0		$0.00
Additional Labor Category 6			0		$0.00		0		$0.00		0		$0.00		0		$0.00		0		$0.00
Additional Labor Category 7			0		$0.00		0		$0.00		0		$0.00		0		$0.00		0		$0.00
Additional Labor Category 8			0		$0.00		0		$0.00		0		$0.00		0		$0.00		0		$0.00
Additional Labor Category 9			0		$0.00		0		$0.00		0		$0.00		0		$0.00		0		$0.00
Additional Labor Category 10			0		$0.00		0		$0.00		0		$0.00		0		$0.00		0		$0.00
Total Estimated Direct Labor Hours			0		$0.00		0		$0.00		0		$0.00		0		$0.00		0		$0.00
Labor Category	Rationale for why this labor category is necessary (what role will it play in the overall effort, how does its work play into the overall effort, what specific sections and tasks of the PWS does this labor category support and tie into, how will these hours and costs be minimized and tracked to ensure they stay within the defined scope of this project?)
Labor Category 1
Labor Category 2
Labor Category 3
Labor Category 4
Labor Category 5
Labor Category 6
Labor Category 7
Labor Category 8
Labor Category 9
Labor Category 10

Cross-Walk of LCATS This Crosswalk of PBGC LCATS to OFFEROR'S LCATS is provided for proposal use.

TO LCAT Name	Offeror's LCAT Name
SCRUM Master
Project Manager - Level III
Business Analyst - Level III
Trainer
Organizational Change Manager
Technical Lead
System Administrator
Developer - SME II
Developer - SME I
Enterprise Architect
Subject Matter Expert I
Subject Matter Expert II
Subject Matter Expert III
Technical Writer
Training Specialist Level I
Training Specialist Level II

File details come from the government source that posted it. Updated Jun 26, 2024.