ATTACHMENT 5- Pricing Worksheet.xlsx

XLSX spreadsheet 22 KB Posted Feb 19, 2021

Attached to: Cyber Core Technical Instructor/ Writer Support Federal contract opportunity
Solicitation number: W9124921R0011
Issued by: Department of the Army Materiel Command Mission and Installation Contracting Command Fort Eustis

About this file

Written by GovTribe AI · Dec 28, 2023

This pricing worksheet template is to be used by offerors responding to solicitation number W9124921R0011 for Cyber Core Technical Instructor/Writer support services. The contractor will provide all necessary personnel, supervision, and non-personal services to perform duties defined in the performance work statement, excluding government furnished property and services. The contractor must perform in accordance with all contract standards. The pricing worksheet lists a base period and three one-year option periods for offerors to provide fully burdened pricing for technical instructor labor categories based on an estimated number of net productive hours. Instructions are included to update labor categories, escalation percentages between option years, and indirect cost rates prior to use.

View the file

Other files for this federal contract opportunity

Other files attached to Cyber Core Technical Instructor/ Writer Support, newest first.
File	Type	Posted
W9124921R0011 A0005.pdf	PDF	Mar 12, 2021
ATTACHMENT 5 Updated Pricing Worksheet._ Amendment 05.xlsx	XLSX spreadsheet	Mar 12, 2021
ATTACHMENT 5 Updated Pricing Worksheet._ Amendment 04.xlsx	XLSX spreadsheet	Mar 12, 2021
Updated ATTACHMENT 5- Pricing Worksheet._ Amendment 04.xlsx	XLSX spreadsheet	Mar 11, 2021
W9124921R0011 A0004.pdf	PDF	Mar 11, 2021
W9124921R0011 Amendment 03.pdf	PDF	Mar 9, 2021
Updated ATTACHMENT 5- Pricing Worksheet._ Amendment 01.xlsx	XLSX spreadsheet	Mar 9, 2021
W9124921R0011 A0002.pdf	PDF	Mar 9, 2021
W9124921R0011 A0001.pdf	PDF	Mar 8, 2021
UPDATED ATTACHMENT 5- Pricing Worksheet._ Amendment 01.pdf	PDF	Mar 8, 2021
W9124921R0011 Solicitation.pdf	PDF	Feb 19, 2021
ATTACHMENT 7 - DD254.pdf	PDF	Feb 19, 2021
ATTACHMENT 6 - WAGE DETERMINATION - FT. GORDON.PDF	PDF	Feb 19, 2021
ATTACHMENT 4 - PAST PERFORMANCE QUESTIONNAIRE.DOCX	DOCX document	Feb 19, 2021
ATTACHMENT 2 - SPECIFIC RELEVANT CONTRACT REFERENCE SHEETS.DOCX	DOCX document	Feb 19, 2021
ATTACHMENT 3 - Consent Form for the Release of Past.DOCX	DOCX document	Feb 19, 2021

Show all 16

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.

Summary

BASE PERIOD	TOTAL COST	OPTION PERIOD 1	TOTAL COST	OPTION PERIOD 2	TOTAL COST	OPTION PERIOD 3	TOTAL COST
CLIN 0001	$ - 0	CLIN 1001	$ - 0	CLIN 2001	$ - 0	CLIN 3001	$ - 0
CLIN 0002	$ - 0	CLIN 1002	$ - 0	CLIN 2002	$ - 0	CLIN 3002	$ - 0

Base Period Total $0.00 Option Period 1 Total $0.00 Option Period 2 Total $0.00 Option Period 3 Total $0.00

GRAND TOTAL $0.00

Note: Please show $0 for CMR CLINS when it will not be separately priced

Internal Note: Make sure you add/delete CLINS and period of performance on here as well.

Pricing - Fully Burden Base Period IMPORTANT COMMENT Symone Collins: Symone Collins:

Make sure do the following prior to using as an Attachment to the solicitation:

- Change the Period of Performance based on your requirements. This only show s a Base and three (3) one-year option periods. However, you may need to add or delete based on your requirement needs.

- Delete all comments as these are internal and not meant for vendors to see.

Exempt/ Non-Exempt Full Time Equivalent Labor Hours Base Wage Rate Fringe Overhead Subtotal G&A Subtotal Profit Total Total Paid to Vendor based on ____ hours Symone Collins: Symone Collins:

Usually, the net productive hours fall around 1871 or 1872. However, you will need to confirm with the requiring activity and make sure that number is entered here so all Offerors will propose pricing based on the same net productive hours

For Example: Cyber COE determines there net productive hours from taking 2087 (available hours) - 216 (80 - holidays, 80-Leave, 56-Sick) = 1871

Labor Category/Classification Rate Symone Collins: Symone Collins:

This is what will be paid to Employee	0.00%	0.00%	Cost	0.00%	Cost	0.00%	Rate
	BCC Technical Instructors			28065
					$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
					$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
					$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
											$ - 0	$ - 0	$ - 0
					$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
					$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
					$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Option 1

		Escalation	Fringe	Overhead	Subtotal	G&A	Subtotal	Profit/Fee	Total
Labor Category / Classification		0.00%	0.00%	0.00%	Cost	0.00%	Cost	0.00%	Rate
BCC Technical Instructors	28065
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

Option 2

		Escalation	Fringe	Overhead	Subtotal	G&A	Subtotal	Profit/Fee	Total
Labor Category / Classification		0.00%	0.00%	0.00%	Cost	0.00%	Cost	0.00%	Rate
BCC Technical Instructors	28065
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

Option 3

	Escalation	Fringe	Overhead	Subtotal	G&A	Subtotal	Profit/Fee	Total
Labor Category / Classification	0.00%	0.00%	0.00%	Cost	0.00%	Cost	0.00%	Rate

$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

The net productive hours are based on an estimated overall average. The available hours of ______ were reduced by an estimated ____ indirect hours. The ____ indirect hours are holiday, vacation, sick, training, etc..

Symone Collins: Symone Collins:

Update

Symone Collins: Symone Collins:

This is what will be paid to Employee Symone Collins: Symone Collins:

Make sure do the following prior to using as an Attachment to the solicitation:

- Change the Period of Performance based on your requirements. This only show s a Base and three (3) one-year option periods. However, you may need to add or delete based on your requirement needs.

- Delete all comments as these are internal and not meant for vendors to see.

Symone Collins: Symone Collins:

For Example: Cyber COE determines there net productive hours from taking 2087 (available hours) - 216 (80 - holidays, 80-Leave, 56-Sick) = 1871

*****************************************Fringe , Overhead, G&A, Profit varies depending on the company.*********************************************************

**************************************** Government allows for no more than a 3% escalation between option years.*************************************************

The Base rate is what the employee will receive.

Fringe is the employee package like insurance, tsp etc.

Overhead is the cost of operating a business ie rent, utilities etc.

G&A General and Administrative Expense is for any management, finanacil and other epense which is incurred by or allocted to a business unit and which is for management and administration of the business unit as a whole.

Profit/Fee is the amout after the costs of doing business.

File details come from the government source that posted it. Updated Feb 19, 2021.