Attachment 7 Co-efficient Spreadsheet for pricing (basic contract).xlsx

XLSX spreadsheet 36 KB Posted Apr 16, 2025

Attached to: Job Order Contract (JOC) Region B
Solicitation number: W15QKN-25-R-A030
Issued by: Department of the Army Materiel Command Contracting Command Picatinny Arsenal

About this file

Written by GovTribe AI · Apr 17, 2025

The file is a pricing coefficient spreadsheet for a Job Order Contract (JOC) solicitation covering construction and renovation services across six states. The solicitation (W15QKN-25-R-A030) is restricted to 8(a) small businesses in New York, New Jersey, Pennsylvania, Connecticut, Maryland, and West Virginia, issued by the U.S. Army Contracting Command - New Jersey on behalf of the 99th Readiness Division. The spreadsheet outlines notational values for five ordering periods, with consistent line items for normal working hours, non-standard working hours, overhead, and profit across different states.

The contract scope includes general building renovation, road and pavement repair, environmental work, and minor construction activities involving excavation, plumbing, demolition, electrical, structural, mechanical, concrete, and environmental remediation. Each state has similar pricing structures, with slight variations in overhead and profit rates, particularly for West Virginia, which shows incrementally increasing rates across ordering periods. The notational values for normal working hours start at $724,713 in the first period and progressively increase to $791,775 in the fifth period, indicating potential annual contract value growth.

View the file

Other files

File	Type	Posted
Solicitation Amendment W15QKN25RA0300002 SF 30.pdf	PDF	May 27, 2025
Solicitation Amendment W15QKN25RA030-0001.pdf	PDF	May 22, 2025
25-R-A030 CSS 97951 Heat Pump Replacement Seed Project - Questions and Answers.pdf	PDF	May 5, 2025
Exhibit A - Quality Control Plan- DD Form 1423 - CDRL A001.pdf	PDF	Apr 16, 2025
Attachment 3- SF 1413.pdf	PDF	Apr 16, 2025
Exhibit B - Safety Plan- DD Form 1423 - CDRL A002.pdf	PDF	Apr 16, 2025
Attachment 10 - Quality Assurance Plan JOC B.pdf	PDF	Apr 16, 2025
Attachment 9 - Section M Rev 1 - W15QKN-25-R-A030.pdf	PDF	Apr 16, 2025
Attachment 5 - Statement of Work - Job Order District B.pdf	PDF	Apr 16, 2025
Attachment 2 - Contr Proposal Worksheet TO-SEED.xlsx	XLSX spreadsheet	Apr 16, 2025
Attachment 1 DD Form 2626.pdf	PDF	Apr 16, 2025
Attachment 4 - CSS 97951 Seed Project DBA WD CT20250023 Mod 03 Dated 14 March 2025.pdf	PDF	Apr 16, 2025
Attachment 12 - 99th RD Area of Responsibility Map.pdf	PDF	Apr 16, 2025
Attachment 6 - Seed Project SOW- CT030-Branford-B08-CSS 97951 Replace Heat Pump.pdf	PDF	Apr 16, 2025
Attachment 8 - Section L Rev 1 - W15QKN-25-R-A030.pdf	PDF	Apr 16, 2025
Solicitation - W15QKN25RA030 - Released.pdf	PDF	Apr 16, 2025

Show all 16

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.

Ordering Period 1

	DISTRICT A
CLIN 1001	STATE	NOTATIONAL VALUE	CO-EFFICIENT	OVERHEAD/PROFIT RATE	VALUE
	NEW YORK (Including NYC and Long Island)
	NORMAL WORKING HOURS	$ 724,713		DO NOT FILL IN	$ - 0
	OTHER THAN NORMAL WH	$ 35,000		DO NOT FILL IN	$ - 0
	NON PRE-PRICED ITEMS
	OVERHEAD	$ 40,000	DO NOT FILL IN		$ - 0
	PROFIT	$ 40,000	DO NOT FILL IN		$ - 0
				NEW YORK TOTAL	$ - 0

PENNSYLVANIA
NORMAL WORKING HOURS	$ 724,713		DO NOT FILL IN	$ - 0
OTHER THAN NORMAL WH	$ 35,000		DO NOT FILL IN	$ - 0
NON PRE-PRICED ITEMS
OVERHEAD	$ 40,000	DO NOT FILL IN		$ - 0
PROFIT	$ 40,000	DO NOT FILL IN		$ - 0
			PENNSYLVANIA TOTAL	$ - 0

CONNECTICUT
NORMAL WORKING HOURS	$ 724,713		DO NOT FILL IN	$ - 0
OTHER THAN NORMAL WH	$ 35,000		DO NOT FILL IN	$ - 0
NON PRE-PRICED ITEMS
OVERHEAD	$ 40,000	DO NOT FILL IN		$ - 0
PROFIT	$ 40,000	DO NOT FILL IN		$ - 0
			CONNECTICUT TOAL	$ - 0

MARYLAND
NORMAL WORKING HOURS	$ 724,713		DO NOT FILL IN	$ - 0
OTHER THAN NORMAL WH	$ 35,000		DO NOT FILL IN	$ - 0
NON PRE-PRICED ITEMS
OVERHEAD	$ 40,000	DO NOT FILL IN		$ - 0
PROFIT	$ 40,000	DO NOT FILL IN		$ - 0
			MARYLAND TOTAL	$ - 0

NEW JERSEY
NORMAL WORKING HOURS	$ 724,713		DO NOT FILL IN	$ - 0
OTHER THAN NORMAL WH	$ 35,000		DO NOT FILL IN	$ - 0
NON PRE-PRICED ITEMS
OVERHEAD	$ 40,000	DO NOT FILL IN		$ - 0
PROFIT	$ 40,000	DO NOT FILL IN		$ - 0
			NEW JERSEY TOTAL	$ - 0

WEST VIRGINIA
NORMAL WORKING HOURS	$ 724,713		DO NOT FILL IN	$ - 0
OTHER THAN NORMAL WH	$ 35,000		DO NOT FILL IN	$ - 0
NON PRE-PRICED ITEMS
OVERHEAD	$ 40,000	DO NOT FILL IN		$ - 0
PROFIT	$ 40,000	DO NOT FILL IN		$ - 0
			WEST VIRGINIA TOTAL	$ - 0

Ordering Period 2

	DISTRICT A
CLIN 2001	STATE	NOTATIONAL VALUE	CO-EFFICIENT	OVERHEAD/PROFIT RATE	VALUE
	NEW YORK (Including NYC and Long Island)
	NORMAL WORKING HOURS	$ 740,984.00		DO NOT FILL IN	$ - 0
	OTHER THAN NORMAL WH	$ 35,000.00		DO NOT FILL IN	$ - 0
	NON PRE-PRICED ITEMS
	OVERHEAD	$ 40,000.00	DO NOT FILL IN		$ - 0
	PROFIT	$ 40,000.00	DO NOT FILL IN		$ - 0
				NEW YORK TOTAL	$ - 0

PENNSYLVANIA
NORMAL WORKING HOURS	$ 740,984.00		DO NOT FILL IN	$ - 0
OTHER THAN NORMAL WH	$ 35,000.00		DO NOT FILL IN	$ - 0
NON PRE-PRICED ITEMS
OVERHEAD	$ 40,000.00	DO NOT FILL IN		$ - 0
PROFIT	$ 40,000.00	DO NOT FILL IN		$ - 0
			PENNSYLVANIA TOTAL	$ - 0

CONNECTICUT
NORMAL WORKING HOURS	$ 740,984.00		DO NOT FILL IN	$ - 0
OTHER THAN NORMAL WH	$ 35,000.00		DO NOT FILL IN	$ - 0
NON PRE-PRICED ITEMS
OVERHEAD	$ 40,000.00	DO NOT FILL IN		$ - 0
PROFIT	$ 40,000.00	DO NOT FILL IN		$ - 0
			CONNECTICUTTOTAL	$ - 0

MARYALND
NORMAL WORKING HOURS	$ 740,984.00		DO NOT FILL IN	$ - 0
OTHER THAN NORMAL WH	$ 35,000.00		DO NOT FILL IN	$ - 0
NON PRE-PRICED ITEMS
OVERHEAD	$ 40,000.00	DO NOT FILL IN		$ - 0
PROFIT	$ 40,000.00	DO NOT FILL IN		$ - 0
			MARYLAND TOTAL	$ - 0

NEW JERSEY
NORMAL WORKING HOURS	$ 740,984.00		DO NOT FILL IN	$ - 0
OTHER THAN NORMAL WH	$ 35,000.00		DO NOT FILL IN	$ - 0
NON PRE-PRICED ITEMS
OVERHEAD	$ 40,000.00	DO NOT FILL IN		$ - 0
PROFIT	$ 40,000.00	DO NOT FILL IN		$ - 0
			NEW JERSEY TOTAL	$ - 0

WEST VIRGINA
NORMAL WORKING HOURS	$ 740,984.00		DO NOT FILL IN	$ - 0
OTHER THAN NORMAL WH	$ 35,000.00		DO NOT FILL IN	$ - 0
NON PRE-PRICED ITEMS
OVERHEAD	$ 41,200.00	DO NOT FILL IN		$ - 0
PROFIT	$ 41,200.00	DO NOT FILL IN		$ - 0
			WEST VIRGINIA TOTAL	$ - 0

WH- WORKING HOURS

Ordering Period 3

	DISTRICT A
CLIN 3001	STATE	NOTATIONAL VALUE	CO-EFFICIENT	OVERHEAD/PROFIT RATE	VALUE
	NEW YORK (Including NYC and Long Island)
	NORMAL WORKING HOURS	$ 757,580.00		DO NOT FILL IN	$ - 0
	OTHER THAN NORMAL WH	$ 35,000.00		DO NOT FILL IN	$ - 0
	NON PRE-PRICED ITEMS
	OVERHEAD	$ 40,000.00	DO NOT FILL IN		$ - 0
	PROFIT	$ 40,000.00	DO NOT FILL IN		$ - 0
				NEW YORK TOTAL	$ - 0

PENNSYLVANIA
NORMAL WORKING HOURS	$ 757,580.00		DO NOT FILL IN	$ - 0
OTHER THAN NORMAL WH	$ 35,000.00		DO NOT FILL IN	$ - 0
NON PRE-PRICED ITEMS
OVERHEAD	$ 40,000.00	DO NOT FILL IN		$ - 0
PROFIT	$ 40,000.00	DO NOT FILL IN		$ - 0
			PENNSYLVANIA TOTAL	$ - 0

CONNECTIUT
NORMAL WORKING HOURS	$ 757,580.00		DO NOT FILL IN	$ - 0
OTHER THAN NORMAL WH	$ 35,000.00		DO NOT FILL IN	$ - 0
NON PRE-PRICED ITEMS
OVERHEAD	$ 40,000.00	DO NOT FILL IN		$ - 0
PROFIT	$ 40,000.00	DO NOT FILL IN		$ - 0
			CONNECTICUT TOTAL	$ - 0

MARYLAND
NORMAL WORKING HOURS	$ 757,580.00		DO NOT FILL IN	$ - 0
OTHER THAN NORMAL WH	$ 35,000.00		DO NOT FILL IN	$ - 0
NON PRE-PRICED ITEMS
OVERHEAD	$ 40,000.00	DO NOT FILL IN		$ - 0
PROFIT	$ 40,000.00	DO NOT FILL IN		$ - 0
			MARYLAND TOTAL	$ - 0

NEW JERSEY
NORMAL WORKING HOURS	$ 757,580.00		DO NOT FILL IN	$ - 0
OTHER THAN NORMAL WH	$ 35,000.00		DO NOT FILL IN	$ - 0
NON PRE-PRICED ITEMS
OVERHEAD	$ 40,000.00	DO NOT FILL IN		$ - 0
PROFIT	$ 40,000.00	DO NOT FILL IN		$ - 0
			NEW JERSEY TOTAL	$ - 0

WEST VIRGINIA
NORMAL WORKING HOURS	$ 757,580.00		DO NOT FILL IN	$ - 0
OTHER THAN NORMAL WH	$ 35,000.00		DO NOT FILL IN	$ - 0
NON PRE-PRICED ITEMS
OVERHEAD	$ 42,436.00	DO NOT FILL IN		$ - 0
PROFIT	$ 42,436.00	DO NOT FILL IN		$ - 0
			WEST VIRGNINA TOTAL	$ - 0

Ordering Period 4

	DISTRICT A
CLIN 4001	STATE	NOTATIONAL VALUE	CO-EFFICIENT	OVERHEAD/PROFIT RATE	VALUE
	NEW YORK (Including NYC and Long Island)
	NORMAL WORKING HOURS	$ 774,508.00		DO NOT FILL IN	$ - 0
	OTHER THAN NORMAL WH	$ 35,000.00		DO NOT FILL IN	$ - 0
	NON PRE-PRICED ITEMS
	OVERHEAD	$ 40,000.00	DO NOT FILL IN		$ - 0
	PROFIT	$ 40,000.00	DO NOT FILL IN		$ - 0
				NEW YORK TOTAL	$ - 0

PENNSYLVANIA
NORMAL WORKING HOURS	$ 774,508.00		DO NOT FILL IN	$ - 0
OTHER THAN NORMAL WH	$ 35,000.00		DO NOT FILL IN	$ - 0
NON PRE-PRICED ITEMS
OVERHEAD	$ 40,000.00	DO NOT FILL IN		$ - 0
PROFIT	$ 40,000.00	DO NOT FILL IN		$ - 0
			PENNSYLVANIA TOTAL	$ - 0

CONNECTICUT
NORMAL WORKING HOURS	$ 774,508.00		DO NOT FILL IN	$ - 0
OTHER THAN NORMAL WH	$ 35,000.00		DO NOT FILL IN	$ - 0
NON PRE-PRICED ITEMS
OVERHEAD	$ 40,000.00	DO NOT FILL IN		$ - 0
PROFIT	$ 40,000.00	DO NOT FILL IN		$ - 0
			CONNECTICUT TOTAL	$ - 0

MARYLAND
NORMAL WORKING HOURS	$ 774,508.00		DO NOT FILL IN	$ - 0
OTHER THAN NORMAL WH	$ 35,000.00		DO NOT FILL IN	$ - 0
NON PRE-PRICED ITEMS
OVERHEAD	$ 40,000.00	DO NOT FILL IN		$ - 0
PROFIT	$ 40,000.00	DO NOT FILL IN		$ - 0
			MARYLAND TOTAL	$ - 0

NEW JERSEY
NORMAL WORKING HOURS	$ 774,508.00		DO NOT FILL IN	$ - 0
OTHER THAN NORMAL WH	$ 35,000.00		DO NOT FILL IN	$ - 0
NON PRE-PRICED ITEMS
OVERHEAD	$ 40,000.00	DO NOT FILL IN		$ - 0
PROFIT	$ 40,000.00	DO NOT FILL IN		$ - 0
			NEW JERSEY TOTAL	$ - 0

WEST VIRGINIA
NORMAL WORKING HOURS	$ 774,508.00		DO NOT FILL IN	$ - 0
OTHER THAN NORMAL WH	$ 38,245.00		DO NOT FILL IN	$ - 0
NON PRE-PRICED ITEMS
OVERHEAD	$ 43,709.00	DO NOT FILL IN		$ - 0
PROFIT	$ 43,709.00	DO NOT FILL IN		$ - 0
			WEST VIRGINIA TOTAL	$ - 0

Ordering Period 5

DISTRICT B
STATE	NOTATIONAL VALUE	CO-EFFICIENT	OVERHEAD/PROFIT RATE	VALUE
NEW YORK (Including NYC and Long Island)
NORMAL WORKING HOURS	$ 791,775.00		DO NOT FILL IN	$ - 0
OTHER THAN NORMAL WH	$ 35,000.00		DO NOT FILL IN	$ - 0
NON PRE-PRICED ITEMS
OVERHEAD	$ 40,000.00	DO NOT FILL IN		$ - 0
PROFIT	$ 40,000.00	DO NOT FILL IN		$ - 0
			NEW YORK TOTAL	$ - 0

PENNSYLVANIA
NORMAL WORKING HOURS	$ 791,775.00		DO NOT FILL IN	$ - 0
OTHER THAN NORMAL WH	$ 35,000.00		DO NOT FILL IN	$ - 0
NON PRE-PRICED ITEMS
OVERHEAD	$ 40,000.00	DO NOT FILL IN		$ - 0
PROFIT	$ 40,000.00	DO NOT FILL IN		$ - 0
			PENNSYLVANIA TOTAL	$ - 0

CONNECTICUT
NORMAL WORKING HOURS	$ 791,775.00		DO NOT FILL IN	$ - 0
OTHER THAN NORMAL WH	$ 35,000.00		DO NOT FILL IN	$ - 0
NON PRE-PRICED ITEMS
OVERHEAD	$ 40,000.00	DO NOT FILL IN		$ - 0
PROFIT	$ 40,000.00	DO NOT FILL IN		$ - 0
			CONNECTICUT TOTAL	$ - 0

MARYLAND
NORMAL WORKING HOURS	$ 791,775.00		DO NOT FILL IN	$ - 0
OTHER THAN NORMAL WH	$ 35,000.00		DO NOT FILL IN	$ - 0
NON PRE-PRICED ITEMS
OVERHEAD	$ 40,000.00	DO NOT FILL IN		$ - 0
PROFIT	$ 40,000.00	DO NOT FILL IN		$ - 0
			MARYLAND TOTAL	$ - 0

NEW JERSEY
NORMAL WORKING HOURS	$ 791,775.00		DO NOT FILL IN	$ - 0
OTHER THAN NORMAL WH	$ 35,000.00		DO NOT FILL IN	$ - 0
NON PRE-PRICED ITEMS
OVERHEAD	$ 40,000.00	DO NOT FILL IN		$ - 0
PROFIT	$ 40,000.00	DO NOT FILL IN		$ - 0
			NEW JERSEY TOTAL	$ - 0

WEST VIRGINIA
NORMAL WORKING HOURS	$ 791,775.00		DO NOT FILL IN	$ - 0
OTHER THAN NORMAL WH	$ 35,000.00		DO NOT FILL IN	$ - 0	.
NON PRE-PRICED ITEMS
OVERHEAD	$ 40,000.00	DO NOT FILL IN		$ - 0
PROFIT	$ 40,000.00	DO NOT FILL IN		$ - 0
			WEST VIRGINIA TOTAL	$ - 0

PROPOSAL TOTAL

District A Contractor Summary Sheet

Ordering Period 1

(12- Month Period of

Time After Base IDIQ Contract Award)	Ordering Period 2
(12- Month Period of Time After Ordering Period 1 Due)	Ordering Period 3
(12- Month Period of Time After Ordering Period 2 Due)	Ordering Period 4
(12- Month Period of Time After Ordering Period 3 Due)	Ordering Period 5
(12- Month Period of Time After Ordering Period 4 Due)	Proposal Total
	NEW YORK (Including NYC and Long Island)	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	PENNSYLVANIA	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	CONNECTICUT	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	MARYLAND	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	NEW JERSEY	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	WEST VIRGINIA	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Ordering Period Subtotal	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

File details come from the government source that posted it. Updated Apr 16, 2025.