Attachment 4 - Pricing Worksheet.xlsx

XLSX spreadsheet 22 KB Posted Dec 10, 2020

Attached to: Military Health Systems Service (MHSS) Helpdesk Support, Information Management and Information Technology (IM/IT) services
Solicitation number: W9124921R0002
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 document contains a pricing worksheet template and details for Solicitation Number W9124921R0002 from the Department of the Army Materiel Command Mission and Installation Contracting Command Fort Eustis. The solicitation requests proposals for Military Health Systems Service Helpdesk Support and Information Management and Information Technology services. The pricing worksheet template includes columns for labor rates, fringe benefits, overhead costs, general and administrative expenses, and profit margins applied across base and option periods. It provides instructions to offerors to populate the template with pricing for required labor categories and escalation rates between option years not to exceed 3%. The solicitation also seeks these IM/IT services in support of the Military Health System to be provided at multiple locations.

View the file

Other files

File	Type	Posted
Solicitation - W9124921R0002.pdf	PDF	Dec 10, 2020
Attachment 3 - Consent Form for the Release of Past Performance.pdf	PDF	Dec 10, 2020
Attachment 1 - Past Performance Cover Letter and Assessment Questionnair.._.pdf	PDF	Dec 10, 2020
Attachment 2 - Specific Relevant Contract Reference Sheets.pdf	PDF	Dec 10, 2020

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

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

$ - 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

$ - 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

$ - 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, financial and other expenses 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 Dec 10, 2020.