Attachment_L9_-_TOR_214-26_-_Task_Order_Pricing_Template_-_Revision_3.xlsx

XLSX spreadsheet 61 KB Posted Feb 12, 2014

Attached to: Multiple Award Task Order Contract (MATOC) Federal contract opportunity
Solicitation number: NIHOF2013536
Issued by: Department of Health and Human Services National Institutes of Health

About this file

From the source

Attachment L9 - TOR 214-26 - Task Order Pricing Template - Revision 3

View the file

Other files for this federal contract opportunity

Other files attached to Multiple Award Task Order Contract (MATOC), newest first.
File	Type	Posted
TOR_00-13_-_Revised_Drawings_-_dated_02-10-14.pdf	PDF	Feb 12, 2014
Specification_Section_01_33_00_-_Revision_1.pdf	PDF	Feb 12, 2014
Amendment_0005.docx	DOCX document	Feb 12, 2014
Attachment_L5_-_TOR_13-00_-_Task_Order_Pricing_Template_-_Revision_3.xlsx	XLSX spreadsheet	Feb 12, 2014
Attachment_L6__TOR_214-20__Statement_of_Work__Revision_3.pdf	PDF	Feb 12, 2014
Section_H_-_Special_Contract_Requirements_-_Revision_1.pdf	PDF	Feb 12, 2014
Section_G_-_Contract_Administration_Data_-_Revision_1.pdf	PDF	Feb 12, 2014
SF_30_-_NIHOF2013536_-_Amendment_0004.pdf	PDF	Feb 11, 2014
Amendment_0003.docx	DOCX document	Feb 6, 2014
MATOC_Pre-Proposal_Conference_Sign-in_Sheet.pdf	PDF	Feb 6, 2014
SF_30_-_NIHOF2013536_-_Amendment_0003.pdf	PDF	Feb 6, 2014
MATOC_Pre-Proposal_Conference_Briefing.pptx	PPTX presentation	Feb 6, 2014
Attachment_L9_-_TOR_214-26_-_Task_Order_Pricing_Template_-_Revision_2.xlsx	XLSX spreadsheet	Feb 6, 2014
Attachment_L8_-_TOR_214-26_-_Statement_of_Work_-_Revision_2.pdf	PDF	Feb 3, 2014
Attachment_L7_-_TOR_214-20_-_Task_Order_Pricing_Template_-_Revision_1.xlsx	XLSX spreadsheet	Feb 3, 2014
Attachment_L9_-_TOR_214-26_-_Task_Order_Pricing_Template_-_Revision_1.xlsx	XLSX spreadsheet	Feb 3, 2014
SF_30_-_NIHOF2013536_-_Amendment_0002.pdf	PDF	Feb 3, 2014
Attachment_L5_-_TOR_13-00_-_Task_Order_Pricing_Template_-_Revision_2.xlsx	XLSX spreadsheet	Feb 3, 2014
Amendment_0002.docx	DOCX document	Feb 3, 2014
Attachment_L6_-_TOR_214-20_-_Statement_of_Work_-_Revision_2.pdf	PDF	Feb 3, 2014
Attachment_L8_-_TOR_214-26_-_Statement_of_Work_-_Revision_1.pdf	PDF	Jan 24, 2014
Statement_of_Work_-_Revision_1_-_01-24-14.pdf	PDF	Jan 24, 2014
Specification_Section_01_35_26.docx	DOCX document	Jan 24, 2014
Specification_Section_01_45_00.docx	DOCX document	Jan 24, 2014
Section_J_-_List_of_Attachments_-_Revision_1.pdf	PDF	Jan 24, 2014
Section_L_-_Instructions _Conditions _and_Notices_to_Offerors_-_Revision_1.pdf	PDF	Jan 24, 2014
Attachment_L6_-_TOR_214-20_-_Statement_of_Work_-_Revision_1.pdf	PDF	Jan 24, 2014
Section_E_-_Inspection_and_Acceptance_-_Revision_1.pdf	PDF	Jan 24, 2014
SF_30_-_NIHOF2013536_-_Amendment_0001.pdf	PDF	Jan 24, 2014
Attachment_L2_-_Past_Performance_Transmittal_Letter_-_Revision_1.docx	DOCX document	Jan 24, 2014
Attachment_L5_-_TOR_13-00_-_Task_Order_Pricing_Template_-_Revision_1.xlsx	XLSX spreadsheet	Jan 24, 2014
Attachment_L9_-_TOR_214-26_-_Task_Order_Pricing_Template.xlsx	XLSX spreadsheet	Jan 24, 2014
Amendment_0001.docx	DOCX document	Jan 24, 2014
New_Equipment_Submission_Worksheet_Template.xls	XLS spreadsheet	Jan 24, 2014
Specification_Section_01_33_00.docx	DOCX document	Jan 24, 2014
Attachment_L7_-_TOR_214-20_-_Task_Order_Pricing_Template.xlsx	XLSX spreadsheet	Jan 24, 2014
FMB-NC_Engineering_Guidelines_and_Material_Requirements--Revision_C.pdf	PDF	Jan 17, 2014
Attachment_L3_Past_Performance_Questionnaire.pdf	PDF	Jan 17, 2014
Wage_Determination--NC130093--Highway.pdf	PDF	Jan 17, 2014
Wage_Determination--NC130080--Heavy.pdf	PDF	Jan 17, 2014
Attachment_L1_Experience_Summary_Sheet.pdf	PDF	Jan 17, 2014
Certificate_of_Current_Cost_or_Pricing_Data.pdf	PDF	Jan 17, 2014
Task_Order_Pricing_Template.xlsx	XLSX spreadsheet	Jan 17, 2014
SF_1442.pdf	PDF	Jan 17, 2014
Solicitation_NIHOF2013536_-_RTP_MATOC.pdf	PDF	Jan 17, 2014
Disclosure_of_Lobbying_Activities.pdf	PDF	Jan 17, 2014
Statement_of_Work--12-6-13.pdf	PDF	Jan 17, 2014
Wage_Determination--NC130028--Building.pdf	PDF	Jan 17, 2014
Wage_Determination--NC130019--Heavy_Dredging.pdf	PDF	Jan 17, 2014
Attachment_L4_TOR_213-00--Statement_of_Work.pdf	PDF	Jan 17, 2014

Show all 50

Multiple Award Task Order Contract (MATOC) has more files on GovTribe.

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.

TOR 214-26 - Base Price

TOR#214-26: North Plan HTHW Air Seperator Valve Replacment
Date:
Contractor:
	Quantitiy		Material		Labor			Equipment	Subcontractor
Item	No.	Unit	Unit Cost	Total	Total Hrs	Rate	Total
Demolition
Valve removal		EA
Insulation removal		LF
All other demolltion work	1	LOT
Mechanical
14" High Performance Butterfly Valve installation		EA
Bolt/Gasket kit		EA
Valve Flange cleaning and refacing		FLANGE
Insulation installation		LF
Labeling/valve tags	1	LOT
All other mechanical work	1	LOT
Administrative

Task Order Management

Project Manager

Superintendent

Quality Control Manager

TOTAL LABOR HOURS * Labor hours and rates are crew rates and crew hours 0.0

TOTAL DOLLARS PRIOR TO TAX	$0.00	$0.00	$0.00	$0.00
SALES TAX	$0.00		$0.00
ELEMENT SUBTOTALS	$0.00	$0.00	$0.00	$0.00

Instructions:	Task Order Subtotal		$0.00
1) All costs for a line item within a category shall encompass all costs for that line item for the entire task order	Field Overhead	0.00%	$0.00
2) Labor rates are to include fringe in accordance with the applicable Wage Determinations	G & A	0.00%	$0.00
3) Subcontractor total shall include all costs associated with subcontractor (e.g. overhead/G&A/management/profit charged by subcontractor). The columns available for Task	Profit	0.00%	$0.00
Order Management of the Subcontractor will include only the amounts that the Prime Contractor is charging for management over and above what the Subcontractor is including.	TOTAL (without bond)		$0.00
4) Work required but not separately priced within a work category shall be included in the "All other work" item	Bond	0.000%	$0.00
5) Sales tax only applies to material and rental equipment bought specifically for performance of the task order (contractor owned equipment is exempt)	Grand Total		$0
6) Task Order Subtotal = Material Element Subtotal + Direct Labor Element Subtotal + Equipment Subtotal + Subcontractor Element Subtotal
7) $30K - $150K (Payment Bond and Irrevocable Letter of Credit), over $150K (Payment and Performance Bonds)
[NOTE: Performance Bond is acceptable in lieu of Irrevocable Letter of Credit]
8) If a category of work is required to perform the SOW but not included on the Task Order Pricing Template, the contractor shall submit a question to the Contracting Officer
requesting clarification. The total proposed price shall include all work required to perform the Statement of Work (regardless of whether a question is asked).
9) The Administrative category is only for work that is supplemental to performing the work identified in the Statement of Work (e.g. on a larger task order if a contractor wishes
to have a Secretary perform submittal work and incorporate that as a direct cost instead of capturing that cost in Overhead or G&A).

&16Task Order Pricing Template

Option (1)

TOR#214-26: North Plan HTHW Air Seperator Valve Replacment
Date:
Contractor:
	Quantitiy		Material		Labor			Equipment	Subcontractor
Item	No.	Unit	Unit Cost	Total	Total Hrs	Rate	Total
OPTION 1 - Replace Flanges (V-1)
Replace two 300 lb Class 14" flanges		EA
Misc. welding and fitting material		EA
Weld Testing		EA
All other work	1	LOT
Administrative

Task Order Management

Project Manager

Superintendent

Quality Control Manager

TOTAL LABOR HOURS * Labor hours and rates are crew rates and crew hours 0.0

TOTAL DOLLARS PRIOR TO TAX	$0.00	$0.00	$0.00	$0.00
SALES TAX	$0.00		$0.00
ELEMENT SUBTOTALS	$0.00	$0.00	$0.00	$0.00

Instructions:	Task Order Subtotal		$0.00
1) All costs for a line item within a category shall encompass all costs for that line item for the entire task order	Field Overhead	0.00%	$0.00
2) Labor rates are to include fringe in accordance with the applicable Wage Determinations	G & A	0.00%	$0.00
3) Subcontractor total shall include all costs associated with subcontractor (e.g. overhead/G&A/management/profit charged by subcontractor). The columns available for Task	Profit	0.00%	$0.00
Order Management of the Subcontractor will include only the amounts that the Prime Contractor is charging for management over and above what the Subcontractor is including.	TOTAL (without bond)		$0.00
4) Work required but not separately priced within a work category shall be included in the "All other work" item	Bond	0.000%	$0.00
5) Sales tax only applies to material and rental equipment bought specifically for performance of the task order (contractor owned equipment is exempt)	Grand Total		$0
6) Task Order Subtotal = Material Element Subtotal + Direct Labor Element Subtotal + Equipment Subtotal + Subcontractor Element Subtotal
7) $30K - $150K (Payment Bond and Irrevocable Letter of Credit), over $150K (Payment and Performance Bonds)
[NOTE: Performance Bond is acceptable in lieu of Irrevocable Letter of Credit]
8) If a category of work is required to perform the SOW but not included on the Task Order Pricing Template, the contractor shall submit a question to the Contracting Officer
requesting clarification. The total proposed price shall include all work required to perform the Statement of Work (regardless of whether a question is asked).
9) The Administrative category is only for work that is supplemental to performing the work identified in the Statement of Work (e.g. on a larger task order if a contractor wishes
to have a Secretary perform submittal work and incorporate that as a direct cost instead of capturing that cost in Overhead or G&A).

&16Task Order Pricing Template

Option (2)

TOR#214-26: North Plan HTHW Air Seperator Valve Replacment
Date:
Contractor:
	Quantitiy		Material		Labor			Equipment	Subcontractor
Item	No.	Unit	Unit Cost	Total	Total Hrs	Rate	Total
OPTION 1 - Replace Flanges (V-2)
Replace two 300 lb Class 14" flanges		EA
Misc. welding and fitting material		EA
Weld Testing		EA
All other work	1	LOT
Administration

Task Order Management

Project Manager

Superintendent

Quality Control Manager

TOTAL LABOR HOURS * Labor hours and rates are crew rates and crew hours 0.0

TOTAL DOLLARS PRIOR TO TAX	$0.00	$0.00	$0.00	$0.00
SALES TAX	$0.00		$0.00
ELEMENT SUBTOTALS	$0.00	$0.00	$0.00	$0.00

Instructions:	Task Order Subtotal		$0.00
1) All costs for a line item within a category shall encompass all costs for that line item for the entire task order	Field Overhead	0.00%	$0.00
2) Labor rates are to include fringe in accordance with the applicable Wage Determinations	G & A	0.00%	$0.00
3) Subcontractor total shall include all costs associated with subcontractor (e.g. overhead/G&A/management/profit charged by subcontractor). The columns available for Task	Profit	0.00%	$0.00
Order Management of the Subcontractor will include only the amounts that the Prime Contractor is charging for management over and above what the Subcontractor is including.	TOTAL (without bond)		$0.00
4) Work required but not separately priced within a work category shall be included in the "All other work" item	Bond	0.000%	$0.00
5) Sales tax only applies to material and rental equipment bought specifically for performance of the task order (contractor owned equipment is exempt)	Grand Total		$0
6) Task Order Subtotal = Material Element Subtotal + Direct Labor Element Subtotal + Equipment Subtotal + Subcontractor Element Subtotal
7) $30K - $150K (Payment Bond and Irrevocable Letter of Credit), over $150K (Payment and Performance Bonds)
[NOTE: Performance Bond is acceptable in lieu of Irrevocable Letter of Credit]
8) If a category of work is required to perform the SOW but not included on the Task Order Pricing Template, the contractor shall submit a question to the Contracting Officer
requesting clarification. The total proposed price shall include all work required to perform the Statement of Work (regardless of whether a question is asked).
9) The Administrative category is only for work that is supplemental to performing the work identified in the Statement of Work (e.g. on a larger task order if a contractor wishes
to have a Secretary perform submittal work and incorporate that as a direct cost instead of capturing that cost in Overhead or G&A).

&16Task Order Pricing Template

Option (3)

TOR#214-26: North Plan HTHW Air Seperator Valve Replacment
Date:
Contractor:
	Quantitiy		Material		Labor			Equipment	Subcontractor
Item	No.	Unit	Unit Cost	Total	Total Hrs	Rate	Total
OPTION 1 - Replace Flanges (V-3)
Replace two 300 lb Class 14" flanges		EA
Misc. welding and fitting material		EA
Weld Testing		EA
All other work	1	LOT
Administration

Task Order Management

Project Manager

Superintendent

Quality Control Manager

TOTAL LABOR HOURS * Labor hours and rates are crew rates and crew hours 0.0

TOTAL DOLLARS PRIOR TO TAX	$0.00	$0.00	$0.00	$0.00
SALES TAX	$0.00		$0.00
ELEMENT SUBTOTALS	$0.00	$0.00	$0.00	$0.00

Instructions:	Task Order Subtotal		$0.00
1) All costs for a line item within a category shall encompass all costs for that line item for the entire task order	Field Overhead	0.00%	$0.00
2) Labor rates are to include fringe in accordance with the applicable Wage Determinations	G & A	0.00%	$0.00
3) Subcontractor total shall include all costs associated with subcontractor (e.g. overhead/G&A/management/profit charged by subcontractor). The columns available for Task	Profit	0.00%	$0.00
Order Management of the Subcontractor will include only the amounts that the Prime Contractor is charging for management over and above what the Subcontractor is including.	TOTAL (without bond)		$0.00
4) Work required but not separately priced within a work category shall be included in the "All other work" item	Bond	0.000%	$0.00
5) Sales tax only applies to material and rental equipment bought specifically for performance of the task order (contractor owned equipment is exempt)	Grand Total		$0
6) Task Order Subtotal = Material Element Subtotal + Direct Labor Element Subtotal + Equipment Subtotal + Subcontractor Element Subtotal
7) $30K - $150K (Payment Bond and Irrevocable Letter of Credit), over $150K (Payment and Performance Bonds)
[NOTE: Performance Bond is acceptable in lieu of Irrevocable Letter of Credit]
8) If a category of work is required to perform the SOW but not included on the Task Order Pricing Template, the contractor shall submit a question to the Contracting Officer
requesting clarification. The total proposed price shall include all work required to perform the Statement of Work (regardless of whether a question is asked).
9) The Administrative category is only for work that is supplemental to performing the work identified in the Statement of Work (e.g. on a larger task order if a contractor wishes
to have a Secretary perform submittal work and incorporate that as a direct cost instead of capturing that cost in Overhead or G&A).

&16Task Order Pricing Template

Pay Rates

			4D	4D	4D	4D	4D				GB	GB	GB	GB	GB
			Base Year	1st Option	2nd Option	3rd Option	4th Option				Base Year	1st Option	2nd Option	3rd Option	4th Option
			2012	2013	2014	2015	2016
1AA	Professional Cat I	Project Manager	$94.54	$98.32	$102.25	$106.34	$110.60	1AA	Professional Cat I	Project Manager	$58.27
1AB	Professional Cat II	QC Manager	$55.00	$57.20	$59.49	$61.87	$64.34	1AB	Professional Cat II	QC Manager	$41.99
	Professional Level 2	Project Engineer	$137.50	$143.00	$148.72	$154.67	$160.86		Professional Level 2	Project Engineer	$127.50
1AC	Professional Cat III	Non-reg Engineer	$95.15	$98.96	$102.91	$107.03	$111.31	1AC	Professional Cat III	Non-reg Engineer	$95.00
1AD	Professional Cat IV	Secretary, word pro	$29.60	$30.78	$32.02	$33.30	$34.63	1AD	Professional Cat IV	Secretary, word pro	$18.08
1AE	Professional Cat V	Cat 2 Super	$62.75	$65.26	$67.87	$70.59	$73.41	1AE	Professional Cat V	Cat 2 Super	$41.99
1AF	Skill Cat I	Foreman	$39.62	$41.20	$42.85	$44.57	$46.35	1AF	Skill Cat I	Foreman	$32.30
1AG	Skill Cat II	Electrician	$32.35	$33.64	$34.99	$36.39	$37.84	1AG	Skill Cat II	Electrician	$37.45
1AH	Skill Cat III	Carpenter	$29.31	$30.48	$31.70	$32.97	$34.29	1AH	Skill Cat III	Carpenter	$26.29
		HVAC Mechanics	$30.03	$31.23	$32.48	$33.78	$35.13			HVAC Mechanics	$39.27
		Plumbers	$43.75	$45.50	$47.32	$49.21	$51.18			Plumbers	$38.68
		Laborer	$20.73	$21.56	$22.42	$23.32	$24.25			Laborer	$13.31
		Pipefitter	$43.75	$45.50	$47.32	$49.21	$51.18			Pipefitter	$58.10
		Equipment operator	$29.31	$30.48	$31.70	$32.97	$34.29			Equipment operator	$17.61
		Truck driver	$20.57	$21.39	$22.25	$23.14	$24.06			Truck driver	$19.25

Contractor: 4D

Contractor: Guerrero Builders

Bond Calc (1 Sheet)

Total Before Bond=	ERROR:#REF!
Bond=	ERROR:#REF!
Bond Percent=	ERROR:#REF!
Grand Total with Bond=	ERROR:#REF!

Calculations
Up to Amount
$ 100,000.00	ERROR:#REF!	$ 25.00	ERROR:#REF!
$ 400,000.00	ERROR:#REF!	$ 15.00	ERROR:#REF!
$ 2,000,000.00	ERROR:#REF!	$ 10.00	ERROR:#REF!
$ 7,500,000.00	ERROR:#REF!	$ 10.00	ERROR:#REF!
$ 7,500,000.00	ERROR:#REF!	$ 9.00	ERROR:#REF!
		Total:	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!

Up to Amount	ERROR:#REF!
$ 100,000.00	ERROR:#REF!	$ 25.00	ERROR:#REF!
$ 400,000.00	ERROR:#REF!	$ 15.00	ERROR:#REF!
$ 2,000,000.00	ERROR:#REF!	$ 10.00	ERROR:#REF!
$ 7,500,000.00	ERROR:#REF!	$ 10.00	ERROR:#REF!
$ 7,500,000.00	ERROR:#REF!	$ 9.00	ERROR:#REF!
		Total:	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!

Up to Amount	ERROR:#REF!
$ 100,000.00	ERROR:#REF!	$ 25.00	ERROR:#REF!
$ 400,000.00	ERROR:#REF!	$ 15.00	ERROR:#REF!
$ 2,000,000.00	ERROR:#REF!	$ 10.00	ERROR:#REF!
$ 7,500,000.00	ERROR:#REF!	$ 10.00	ERROR:#REF!
$ 7,500,000.00	ERROR:#REF!	$ 9.00	ERROR:#REF!
		Total:	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!

Up to Amount	ERROR:#REF!
$ 100,000.00	ERROR:#REF!	$ 25.00	ERROR:#REF!
$ 400,000.00	ERROR:#REF!	$ 15.00	ERROR:#REF!
$ 2,000,000.00	ERROR:#REF!	$ 10.00	ERROR:#REF!
$ 7,500,000.00	ERROR:#REF!	$ 10.00	ERROR:#REF!
$ 7,500,000.00	ERROR:#REF!	$ 9.00	ERROR:#REF!
		Total:	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!

Up to Amount	ERROR:#REF!
$ 100,000.00	ERROR:#REF!	$ 25.00	ERROR:#REF!
$ 400,000.00	ERROR:#REF!	$ 15.00	ERROR:#REF!
$ 2,000,000.00	ERROR:#REF!	$ 10.00	ERROR:#REF!
$ 7,500,000.00	ERROR:#REF!	$ 10.00	ERROR:#REF!
$ 7,500,000.00	ERROR:#REF!	$ 9.00	ERROR:#REF!
		Total:	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!

Up to Amount	ERROR:#REF!
$ 100,000.00	ERROR:#REF!	$ 25.00	ERROR:#REF!
$ 400,000.00	ERROR:#REF!	$ 15.00	ERROR:#REF!
$ 2,000,000.00	ERROR:#REF!	$ 10.00	ERROR:#REF!
$ 7,500,000.00	ERROR:#REF!	$ 10.00	ERROR:#REF!
$ 7,500,000.00	ERROR:#REF!	$ 9.00	ERROR:#REF!
		Total:	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!

Up to Amount	ERROR:#REF!
$ 100,000.00	ERROR:#REF!	$ 25.00	ERROR:#REF!
$ 400,000.00	ERROR:#REF!	$ 15.00	ERROR:#REF!
$ 2,000,000.00	ERROR:#REF!	$ 10.00	ERROR:#REF!
$ 7,500,000.00	ERROR:#REF!	$ 10.00	ERROR:#REF!
$ 7,500,000.00	ERROR:#REF!	$ 9.00	ERROR:#REF!
		Total:	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!

Up to Amount	ERROR:#REF!
$ 100,000.00	ERROR:#REF!	$ 25.00	ERROR:#REF!
$ 400,000.00	ERROR:#REF!	$ 15.00	ERROR:#REF!
$ 2,000,000.00	ERROR:#REF!	$ 10.00	ERROR:#REF!
$ 7,500,000.00	ERROR:#REF!	$ 10.00	ERROR:#REF!
$ 7,500,000.00	ERROR:#REF!	$ 9.00	ERROR:#REF!
		Total:	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!

Up to Amount	ERROR:#REF!
$ 100,000.00	ERROR:#REF!	$ 25.00	ERROR:#REF!
$ 400,000.00	ERROR:#REF!	$ 15.00	ERROR:#REF!
$ 2,000,000.00	ERROR:#REF!	$ 10.00	ERROR:#REF!
$ 7,500,000.00	ERROR:#REF!	$ 10.00	ERROR:#REF!
$ 7,500,000.00	ERROR:#REF!	$ 9.00	ERROR:#REF!
		Total:	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!

Up to Amount	ERROR:#REF!
$ 100,000.00	ERROR:#REF!	$ 25.00	ERROR:#REF!
$ 400,000.00	ERROR:#REF!	$ 15.00	ERROR:#REF!
$ 2,000,000.00	ERROR:#REF!	$ 10.00	ERROR:#REF!
$ 7,500,000.00	ERROR:#REF!	$ 10.00	ERROR:#REF!
$ 7,500,000.00	ERROR:#REF!	$ 9.00	ERROR:#REF!
		Total:	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!

Up to Amount	ERROR:#REF!
$ 100,000.00	ERROR:#REF!	$ 25.00	ERROR:#REF!
$ 400,000.00	ERROR:#REF!	$ 15.00	ERROR:#REF!
$ 2,000,000.00	ERROR:#REF!	$ 10.00	ERROR:#REF!
$ 7,500,000.00	ERROR:#REF!	$ 10.00	ERROR:#REF!
$ 7,500,000.00	ERROR:#REF!	$ 9.00	ERROR:#REF!
		Total:	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!

Up to Amount	ERROR:#REF!
$ 100,000.00	ERROR:#REF!	$ 25.00	ERROR:#REF!
$ 400,000.00	ERROR:#REF!	$ 15.00	ERROR:#REF!
$ 2,000,000.00	ERROR:#REF!	$ 10.00	ERROR:#REF!
$ 7,500,000.00	ERROR:#REF!	$ 10.00	ERROR:#REF!
$ 7,500,000.00	ERROR:#REF!	$ 9.00	ERROR:#REF!
		Total:	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!

Up to Amount	ERROR:#REF!
$ 100,000.00	ERROR:#REF!	$ 25.00	ERROR:#REF!
$ 400,000.00	ERROR:#REF!	$ 15.00	ERROR:#REF!
$ 2,000,000.00	ERROR:#REF!	$ 10.00	ERROR:#REF!
$ 7,500,000.00	ERROR:#REF!	$ 10.00	ERROR:#REF!
$ 7,500,000.00	ERROR:#REF!	$ 9.00	ERROR:#REF!
		Total:	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!

Up to Amount	ERROR:#REF!
$ 100,000.00	ERROR:#REF!	$ 25.00	ERROR:#REF!
$ 400,000.00	ERROR:#REF!	$ 15.00	ERROR:#REF!
$ 2,000,000.00	ERROR:#REF!	$ 10.00	ERROR:#REF!
$ 7,500,000.00	ERROR:#REF!	$ 10.00	ERROR:#REF!
$ 7,500,000.00	ERROR:#REF!	$ 9.00	ERROR:#REF!
		Total:	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!

Bond Calc (2 Sheet)

Total Before Bond=	$0.00
Bond=	$ - 0
Bond Percent=
Grand Total with Bond=	$ - 0

Calculations
Up to Amount
$ 100,000.00	$ - 0	$ 25.00	$ - 0
$ 400,000.00	$ - 0	$ 15.00	$ - 0
$ 2,000,000.00	$ - 0	$ 10.00	$ - 0
$ 7,500,000.00	$ - 0	$ 10.00	$ - 0
$ 7,500,000.00	$ - 0	$ 9.00	$ - 0
		Total:	$ - 0	$ - 0	1

Up to Amount	$ - 0
$ 100,000.00	$ - 0	$ 25.00	$ - 0
$ 400,000.00	$ - 0	$ 15.00	$ - 0
$ 2,000,000.00	$ - 0	$ 10.00	$ - 0
$ 7,500,000.00	$ - 0	$ 10.00	$ - 0
$ 7,500,000.00	$ - 0	$ 9.00	$ - 0
		Total:	$ - 0	$ - 0	1

Up to Amount	$ - 0
$ 100,000.00	$ - 0	$ 25.00	$ - 0
$ 400,000.00	$ - 0	$ 15.00	$ - 0
$ 2,000,000.00	$ - 0	$ 10.00	$ - 0
$ 7,500,000.00	$ - 0	$ 10.00	$ - 0
$ 7,500,000.00	$ - 0	$ 9.00	$ - 0
		Total:	$ - 0	$ - 0	1

Up to Amount	$ - 0
$ 100,000.00	$ - 0	$ 25.00	$ - 0
$ 400,000.00	$ - 0	$ 15.00	$ - 0
$ 2,000,000.00	$ - 0	$ 10.00	$ - 0
$ 7,500,000.00	$ - 0	$ 10.00	$ - 0
$ 7,500,000.00	$ - 0	$ 9.00	$ - 0
		Total:	$ - 0	$ - 0	1

Up to Amount	$ - 0
$ 100,000.00	$ - 0	$ 25.00	$ - 0
$ 400,000.00	$ - 0	$ 15.00	$ - 0
$ 2,000,000.00	$ - 0	$ 10.00	$ - 0
$ 7,500,000.00	$ - 0	$ 10.00	$ - 0
$ 7,500,000.00	$ - 0	$ 9.00	$ - 0
		Total:	$ - 0	$ - 0	1

Up to Amount	$ - 0
$ 100,000.00	$ - 0	$ 25.00	$ - 0
$ 400,000.00	$ - 0	$ 15.00	$ - 0
$ 2,000,000.00	$ - 0	$ 10.00	$ - 0
$ 7,500,000.00	$ - 0	$ 10.00	$ - 0
$ 7,500,000.00	$ - 0	$ 9.00	$ - 0
		Total:	$ - 0	$ - 0	1

Up to Amount	$ - 0
$ 100,000.00	$ - 0	$ 25.00	$ - 0
$ 400,000.00	$ - 0	$ 15.00	$ - 0
$ 2,000,000.00	$ - 0	$ 10.00	$ - 0
$ 7,500,000.00	$ - 0	$ 10.00	$ - 0
$ 7,500,000.00	$ - 0	$ 9.00	$ - 0
		Total:	$ - 0	$ - 0	1

Up to Amount	$ - 0
$ 100,000.00	$ - 0	$ 25.00	$ - 0
$ 400,000.00	$ - 0	$ 15.00	$ - 0
$ 2,000,000.00	$ - 0	$ 10.00	$ - 0
$ 7,500,000.00	$ - 0	$ 10.00	$ - 0
$ 7,500,000.00	$ - 0	$ 9.00	$ - 0
		Total:	$ - 0	$ - 0	1

Up to Amount	$ - 0
$ 100,000.00	$ - 0	$ 25.00	$ - 0
$ 400,000.00	$ - 0	$ 15.00	$ - 0
$ 2,000,000.00	$ - 0	$ 10.00	$ - 0
$ 7,500,000.00	$ - 0	$ 10.00	$ - 0
$ 7,500,000.00	$ - 0	$ 9.00	$ - 0
		Total:	$ - 0	$ - 0	1

Up to Amount	$ - 0
$ 100,000.00	$ - 0	$ 25.00	$ - 0
$ 400,000.00	$ - 0	$ 15.00	$ - 0
$ 2,000,000.00	$ - 0	$ 10.00	$ - 0
$ 7,500,000.00	$ - 0	$ 10.00	$ - 0
$ 7,500,000.00	$ - 0	$ 9.00	$ - 0
		Total:	$ - 0	$ - 0	1

Up to Amount	$ - 0
$ 100,000.00	$ - 0	$ 25.00	$ - 0
$ 400,000.00	$ - 0	$ 15.00	$ - 0
$ 2,000,000.00	$ - 0	$ 10.00	$ - 0
$ 7,500,000.00	$ - 0	$ 10.00	$ - 0
$ 7,500,000.00	$ - 0	$ 9.00	$ - 0
		Total:	$ - 0	$ - 0	1

Up to Amount	$ - 0
$ 100,000.00	$ - 0	$ 25.00	$ - 0
$ 400,000.00	$ - 0	$ 15.00	$ - 0
$ 2,000,000.00	$ - 0	$ 10.00	$ - 0
$ 7,500,000.00	$ - 0	$ 10.00	$ - 0
$ 7,500,000.00	$ - 0	$ 9.00	$ - 0
		Total:	$ - 0	$ - 0	1

Up to Amount	$ - 0
$ 100,000.00	$ - 0	$ 25.00	$ - 0
$ 400,000.00	$ - 0	$ 15.00	$ - 0
$ 2,000,000.00	$ - 0	$ 10.00	$ - 0
$ 7,500,000.00	$ - 0	$ 10.00	$ - 0
$ 7,500,000.00	$ - 0	$ 9.00	$ - 0
		Total:	$ - 0	$ - 0	1

Up to Amount	$ - 0
$ 100,000.00	$ - 0	$ 25.00	$ - 0
$ 400,000.00	$ - 0	$ 15.00	$ - 0
$ 2,000,000.00	$ - 0	$ 10.00	$ - 0
$ 7,500,000.00	$ - 0	$ 10.00	$ - 0
$ 7,500,000.00	$ - 0	$ 9.00	$ - 0
		Total:	$ - 0	$ - 0	1

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