TE-G Burn Rate Example.xlsx

XLSX spreadsheet 145 KB Posted Feb 28, 2017

Attached to: Base Operation Support Services for Dugway Proving Grounds, UT
Solicitation number: W911S6-16-R-0002
Issued by: Department of the Army Materiel Command Mission and Installation Contracting Command Joint Base Lewis-McChord

About this file

From the source

TE-G Burn Rate Example

View the file

Other files

File	Type	Posted
Response_to_Question_3.xlsx	XLSX spreadsheet	Apr 4, 2017
Attachment 12 Amendment 0002 FY15 IJO Historical List.xlsx	XLSX spreadsheet	Mar 31, 2017
TE H GFP and CAP Report.xlsx	XLSX spreadsheet	Mar 31, 2017
Attachment 1-DPG BOSS PWS--Amend 0002.pdf	PDF	Mar 31, 2017
Attachment L3 PPQ, 16-R-0002, DPG BOSS, 10Mar17.docx	DOCX document	Mar 31, 2017
W911S6-16-R-0002-0002 Conformed CopyFinal.pdf	PDF	Mar 31, 2017
Attachment 8 General Decision Number UT170067.pdf	PDF	Mar 31, 2017
Attachment L6-Proposed Staffing Amendment 0002.xlsx	XLSX spreadsheet	Mar 31, 2017
W911S6-16-R-0002-0002 Modification Final.pdf	PDF	Mar 31, 2017
Attachment 9 WD 15-5489.pdf	PDF	Mar 31, 2017
Attachment 11A DD Form 254 Amend0002.pdf	PDF	Mar 31, 2017
Attachment L2 Relevant Contracts, 16-R-0002, Amend 0002.pdf	PDF	Mar 31, 2017
Attachment 7 General Decision Number UT170057.pdf	PDF	Mar 31, 2017
DPG_BOSS_Set_2_Responses_to_Questions.xlsx	XLSX spreadsheet	Mar 31, 2017
Attachment L5 Pricing Proposal Form Amend0002.xlsx	XLSX spreadsheet	Mar 31, 2017
Attachment 6 General Decision Number UT170031.pdf	PDF	Mar 31, 2017
Attachment 11B DD Form 254 Cont Amendment 0002.pdf	PDF	Mar 31, 2017
Attachment 5 General Decision Number UT170107.pdf	PDF	Mar 31, 2017
DPG_BOSS_Set_1_Responses_to_Questions.xlsx	XLSX spreadsheet	Mar 30, 2017
Attachment L5 Pricing Proposal Form --16-R-0002 DPG BASEOPS10Mar17.xlsx	XLSX spreadsheet	Mar 14, 2017
Attachment L3 PPQ, 16-R-0002, DPG BOSS, 10Mar17.docx	DOCX document	Mar 14, 2017
Attachment L2 Relevant Contracts, 16-R-0002, Dugway Proving Grounds, BOSS,10Mar17.docx	DOCX document	Mar 14, 2017
Attachment L6-Proposed Staffing.xlsx	XLSX spreadsheet	Mar 14, 2017
W911S6-16-R-0002-0001 SF33 Conformed Copy Released.pdf	PDF	Mar 14, 2017
W911S6-16-R-0002-0001 SF30 Modification Document Released.pdf	PDF	Mar 14, 2017
Attachment L4 PPQCover, 16-R-0002, DPG BOSS, 14 MAR 17 V2 J1.pdf	PDF	Mar 14, 2017
TE-BB Chemical Usage Report.xlsx	XLSX spreadsheet	Feb 28, 2017
TE-YYY Number Movements & Placements.xlsx	XLSX spreadsheet	Feb 28, 2017
TE-UUU List Back Flow Preventors.pdf	PDF	Feb 28, 2017
TE-BBB-1 AST-UllageLog.docx	DOCX document	Feb 28, 2017
TE-LLL Utility Data.docx	DOCX document	Feb 28, 2017
TE-FF Snow Removal Priorities.pdf	PDF	Feb 28, 2017
TE-Q-1 Historical Work Load.xlsx	XLSX spreadsheet	Feb 28, 2017
TE-BB-1 Daily Report.docx	DOCX document	Feb 28, 2017
TE-XX HVAC Filters.pdf	PDF	Feb 28, 2017
TE-N Water Contamination Threat.pdf	PDF	Feb 28, 2017
TE-P Real Property PM Task List.xlsx	XLSX spreadsheet	Feb 28, 2017
TE-DD Paved Roads & Parking Sections.xlsx	XLSX spreadsheet	Feb 28, 2017
TE-B Typical Certifications.pdf	PDF	Feb 28, 2017
Attachment 8 General Decision Number UT67.pdf	PDF	Feb 28, 2017
TE-R Historic Buildings.pdf	PDF	Feb 28, 2017
Attachment 5 General Decision Number UT107.pdf	PDF	Feb 28, 2017
TE-XXX Estimated Appliances Replacment.xlsx	XLSX spreadsheet	Feb 28, 2017
TE-LL UPS Locations.xlsx	XLSX spreadsheet	Feb 28, 2017
TE-FF-1 Historical Snowfall Data.xlsx	XLSX spreadsheet	Feb 28, 2017
TE-SS Air Conditioner Systems.pdf	PDF	Feb 28, 2017
TE-TT Chiller Water Chemistry.xlsx	XLSX spreadsheet	Feb 28, 2017
TE-UU Exhaust Fans.pdf	PDF	Feb 28, 2017
TE-EE Unpaved Roads.pdf	PDF	Feb 28, 2017
TE-DDD List of Lifting Devices.xlsx	XLSX spreadsheet	Feb 28, 2017

Show 40 more

Latest 50 of 127 listed here. See the rest on GovTribe.

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.

Chart4

Cumulative Budget vs Spending

1 #REF! 1 1 #REF! 1 1 #REF! 1 1 #REF! 1

Sheet1

Spending Vs Contract Value

1 #REF! 1 1 #REF! 1 1 #REF! 1 1 #REF! 1

Chart5

Actual spending comparison by FY 1 #REF! 1 1 #REF! 1 Period

Dollars

ECVSum

Solicitation: W911S6-16-R-0002
Technical Exhibit
TE-G Burn Rate Report
10/30/15
	FY## ECV Funding Requirements
		Total	BOS	SRM
	BOS 200-Appliance Repair	-	-	-
	BOS 400-Fac Engin Srvcs	-	-	-
	BOS 404-Grounds Maint	-	-	-
	BOS 408-Snow,Ice, & Sand	-	-	-
	SRM 411-Fac Maint-Vertical	-	-	-
	SRM 420-Fac Maint-Horizontal	-	-	-
	BOS 500-Electrical	-
	BOS 501-Heating/Cooling	-	-	-
	BOS 502-Water	-	-	-
	BOS 503-Waste Water	-	-	-
	BOS 504-Other Utility	-	-	-
	BOS 400-CMR	-	-	-
		-	-	-
	Materials Total	- 0	- 0	- 0
	Labor with G&A	- 0	- 0	- 0
	Fee	- 0	-	-

Constants

CONSTANTS
FY##	Oct

Rodney J. Miller: Rodney J. Miller:

Includes Sept 30th in all counts		Nov		Dec		Jan		Feb		Mar		Apr		May		Jun		Jul		Aug		Sep
	YTD Day Count	0		0		0		0		0		0		0		0		0		0		0		0		0
	Invoice Period	P1	P2	P1	P2	P1	P2	P1	P2	P1	P2	P1	P2	P1	P2	P1	P2	P1	P2	P1	P2	P1	P2	P1	P2
	Invoiceable Days	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
	Invoiced Days	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
	Uninvoiced Days	0		0		0		0		0		0		0		0		0		0		0		0		0
	Billable Days	0		0		0		0		0		0		0		0		0		0		0		0		0
	Billed Days	0		0		0		0		0		0		0		0		0		0		0		0		0
	Estimated Days	0		0		0		0		0		0		0		0		0		0		0		0		0
	Unbilled Days	0		0		0		0		0		0		0		0		0		0		0		0		0
													0												0

	Dollars	Set aside	Forecastable Dollars	Additions	Start Date		Remaining Days	12/31/69
Estimated Contract Value	ERROR:#REF!	150,000.00	ERROR:#REF!	- 0	End Date		Remaining WD	0
SRM Funding Received	- 0		- 0
BOS Funding Received	- 0		- 0	- 0	Holidays	10/14/13
Estimated SRM Value	ERROR:#REF!	75,000.00	ERROR:#REF!	ERROR:#REF!		11/11/13
Labor - Regular (%)	ERROR:#REF!		ERROR:#REF!			11/28/13
Overtime (%)	ERROR:#REF!		ERROR:#REF!			12/25/13
Davis-Bacon (%)	ERROR:#REF!		ERROR:#REF!			1/1/14
Materials	ERROR:#REF!	75,000.00	ERROR:#REF!			1/20/14
Estimated BOS Value	ERROR:#REF!	75,000.00	ERROR:#REF!	ERROR:#REF!		2/17/14
Labor - Regular (%)	ERROR:#REF!		ERROR:#REF!			5/26/14
Overtime (%)	ERROR:#REF!		ERROR:#REF!			7/4/14
Davis-Bacon (%)	ERROR:#REF!		ERROR:#REF!			9/1/14
Materials	ERROR:#REF!	75,000.00	ERROR:#REF!
Seasonal Labor Value	- 0
Target Fee	ERROR:#REF!	100,000.00	ERROR:#REF!

Printed: &D &T &P of &N &F -- &A

Forecast

FORECAST		October	November	December	January	February	March	April	May	June	July	August	September	Total	Daily Burn
Labor
	SRM	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#REF!
	REG	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#REF!
	OT	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#REF!
	DB	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#REF!
	BOS	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#REF!
	REG	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#REF!
	OT	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#REF!
	DB	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#REF!
		0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00

Material															Daily Burn
	SRM	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#REF!
	BOS	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#REF!
		0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00

Combined															Daily Burn
	SRM	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#REF!
	BOS	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#REF!
		0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	121,603.49

Fee

SRM

ERROR:#REF!

BOS

0.00

ERROR:#REF!

Set Aside

Cummulative total

ERROR:#REF!

0.00

Contract Total

ERROR:#REF!

Printed: &D &T &P of &N &F -- &A

Overview

Invoiced Through Date	CONTRACT	BOS	SRM	CONTRACT
	Forecasted			Total	Variance
Loaded Invoiced Labor
Regular Labor	$ - 0	$ - 0	$ - 0	$ - 0
Overtime Labor	$ - 0	$ - 0	$ - 0	$ - 0
Davis Bacon Labor	$ - 0	$ - 0	$ - 0	$ - 0
Labor Summary as of Last Invoice	$ - 0	$ - 0	$ - 0	$ - 0
Estimated LOADED Labor Since Last Invoiced
Regular Labor	ERROR:#REF!	$ - 0	$ - 0	$ - 0
Overtime Labor	ERROR:#REF!	$ - 0	$ - 0	$ - 0
Davis Bacon Labor	ERROR:#REF!	$ - 0	$ - 0	$ - 0
Est. G&A @ ?% for uninvoiced Lbr		$ - 0	$ - 0
Est. Labor Summary as of Last Invoice		$ - 0	$ - 0	$ - 0
Total Invoiced & Estimated Labor	ERROR:#REF!	$ - 0	$ - 0	$ - 0	ERROR:#REF!

Materials
Total Materials Invoiced	ERROR:#REF!	$ - 0	$ - 0	$ - 0
Outstanding Material Obligations		$ - 0	$ - 0	$ - 0
Est. G&A @ 4% for uninvoiced Mat'l		$ - 0	$ - 0
Total Invoiced & Obligated Materials	ERROR:#REF!	$ - 0	$ - 0	$ - 0	ERROR:#REF!

Total Cost Summary	ERROR:#REF!	$ - 0	$ - 0	$ - 0	ERROR:#REF!
Target Fee	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Total Expenditures	ERROR:#REF!	$ - 0	$ - 0	$ - 0	ERROR:#REF!
Total Contract Value	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!
Total Funding Received		$ - 0	$ - 0	$ - 0
Received Funding Available		$ - 0	$ - 0	$ - 0
Funding Due		ERROR:#REF!	ERROR:#REF!	ERROR:#REF!
Unobligated Funds	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!
Percentage Obligated to Date	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!

	Days remaining to end of Fiscal Year	0.0		Estimates as of:	4/13/2014
	Days remaining at forecast burn rate	ERROR:#REF!	ERROR:#REF!
Date remaining funds will be expended		ERROR:#REF!	ERROR:#REF!	Estimated dates $'s 75% Spent

Forecast Burn Rate	ERROR:#REF!	ERROR:#REF!	CONTRACT	ERROR:#REF!
Invoiced Burn Rate	ERROR:#DIV/0!	ERROR:#DIV/0!	BOS	ERROR:#REF!
Current Projection Burn Rate	ERROR:#DIV/0!	ERROR:#DIV/0!	SRM	ERROR:#REF!
Current Maximum Daily Burn Rate	ERROR:#REF!	ERROR:#REF!

&"Arial,Bold"&14CONFIDENTIAL

Overview-BOS

Invoiced Through Date	CONTRACT	BOS
	Forecast	H, J & M	Variance
Loaded Invoiced Labor
Regular Labor		$ - 0
Overtime Labor		$ - 0
Davis Bacon Labor		$ - 0
Labor Summary as of Last Invoice	$ - 0	$ - 0
Estimated LOADED Labor Since Last Invoice
Regular Labor	ERROR:#REF!	$ - 0
Overtime Labor	ERROR:#REF!	$ - 0
Davis Bacon Labor	ERROR:#REF!	$ - 0
Est. G&A @ 4% for uninvoiced Lbr		$ - 0
Est. Labor Summary as of Last Invoice		$ - 0
Total Invoiced and Estimated Labor	ERROR:#REF!	$ - 0	ERROR:#REF!

Materials
Total Materials Invoiced	ERROR:#REF!	$ - 0
Outstanding Material Obligations		$ - 0
Est. G&A @ 4% for uninvoiced Mat'l		$ - 0
Total Invoiced & Obligated Materials	ERROR:#REF!	$ - 0	ERROR:#REF!

Target Fee	$ - 0	$ - 0	$ - 0
Cost Summary	ERROR:#REF!	$ - 0	ERROR:#REF!
Total Expenditures	ERROR:#REF!	$ - 0	ERROR:#REF!
Total Contract Value	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!
Total Funding Received		$ - 0
Received Funding Available		$ - 0
Funding Due		ERROR:#REF!
Unobligated Funds	ERROR:#REF!	ERROR:#REF!
Percentage Obligated to Date	ERROR:#REF!	ERROR:#REF!

	Days remaining to end of Fiscal Year	0.0
	Days remaining at forecast burn rate	ERROR:#REF!	75% Spent
Date remaining funds will be expended		ERROR:#REF!	ERROR:#REF!

Forecast Burn Rate	ERROR:#REF!
Invoiced Burn Rate	ERROR:#DIV/0!
Current Projection Burn Rate	ERROR:#DIV/0!

Sheryl Irish: Sheryl Irish:

Original formula pointed to P29 but with all fee being charged to BOS for FY14 Current Maximum Daily Burn Rate ERROR:#REF!

&"Arial,Bold"&14CONFIDENTIAL

Overview-SRM

Invoiced Through Date	CONTRACT	SRM
	Forecast	K	Variance
Loaded Invoiced Labor
Regular Labor		$ - 0
Overtime Labor		$ - 0
Davis Bacon Labor		$ - 0
Labor Summary as of Last Invoice	$ - 0	$ - 0
Estimated LOADED Labor Since Last Invoice
Regular Labor	ERROR:#REF!	$ - 0
Overtime Labor	ERROR:#REF!	$ - 0
Davis Bacon Labor	ERROR:#REF!	$ - 0
Est. G&A @ 4% for uninvoiced Lbr		$ - 0
Est. Labor Summary as of Last Invoice		$ - 0
Total Invoiced and Estimated Labor	ERROR:#REF!	$ - 0	ERROR:#REF!

Materials
Total Materials Invoiced	ERROR:#REF!	$ - 0	ERROR:#REF!
Outstanding Material Obligations		$ - 0
Est. G&A @ 4% for uninvoiced Mat'l		$ - 0
Total Invoiced & Obligated Materials	ERROR:#REF!	$ - 0	ERROR:#REF!

Target Fee		$ - 0	$ - 0
Cost Summary	ERROR:#REF!	$ - 0	ERROR:#REF!
Total Expenditures	ERROR:#REF!	$ - 0	ERROR:#REF!
Total Contract Value	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!
Total Funding Received		$ - 0
Received Funding Available		$ - 0
Funding Due		ERROR:#REF!
Unobligated Funds	ERROR:#REF!	ERROR:#REF!
Percentage Obligated to Date	ERROR:#REF!	ERROR:#REF!

	Days remaining to end of Fiscal Year	0.0
	Days remaining at forecast burn rate	ERROR:#REF!	75% Spent
	Date remaining funds will be expended
ERROR:#REF!	ERROR:#REF!

Forecast Burn Rate	ERROR:#REF!
Invoiced Burn Rate	ERROR:#DIV/0!
Current Projection Burn Rate	ERROR:#DIV/0!
Current Maximum Daily Burn Rate	ERROR:#REF!

&"Arial,Bold"&14CONFIDENTIAL&"Arial,Regular"&10

Invoiced

INVOICED		October	November	December	January	February	March	April	May	June	July	August	September	Total
Labor															Daily Burn
	SRM	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#DIV/0!
	REG (%)	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#DIV/0!
	OT (%)	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#DIV/0!
	DB (%)	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#DIV/0!
	BOS	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#DIV/0!
	REG (%)	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#DIV/0!
	OT (%)	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#DIV/0!
	DB (%)	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#DIV/0!
		0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#DIV/0!

Material															Daily Burn
	SRM	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#DIV/0!
	BOS	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#DIV/0!
		0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#DIV/0!

Total															Daily Burn
	SRM	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#DIV/0!
	BOS	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#DIV/0!
		0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00

Fee
	SRM	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
	BOS	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
		0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#DIV/0!

Cummulative total 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

COMPLETE Yes Yes Yes Yes Yes Yes

Invoice #1		ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!
	SRM Labor	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
	BOS Labor	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
	SRM Material	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
	BOS Material	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
	SRM Fee	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
	BOS Fee	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
	Total	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
Invoice #2		ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!
	SRM Labor	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
	BOS Labor	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
	SRM Material	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
	BOS Material	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
	SRM Fee	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
	BOS Fee	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
	Total	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00

Printed: &D &T &P of &N &F -- &A

Contract System

		October	November	December	January	February	March	April	May	June	July	August	September	Total
Labor															Daily Burn
	SRM	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#DIV/0!
	REG (%)	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#DIV/0!
	OT (%)	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#DIV/0!
	DB (%)	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#DIV/0!
	BOS	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#DIV/0!
	REG (%)	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#DIV/0!
	OT (%)	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#DIV/0!
	DB (%)	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#DIV/0!
	FRINGE	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#DIV/0!
	REG	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#DIV/0!
	OT	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#DIV/0!
	DB	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#DIV/0!
		0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#DIV/0!
	Diff to Invoiced	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00

Material															Daily Burn
	SRM	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#DIV/0!
		0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
	BOS	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#DIV/0!
		0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
		0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#DIV/0!
	Diff to Invoiced	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00

Total															Daily Burn
	SRM	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#DIV/0!
	BOS	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#DIV/0!
	FRINGE	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#DIV/0!
		0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#DIV/0!

Cummulative total	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
Diff to Invoiced	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00

Printed: &D &T &P of &N &F -- &A

Projection

BUDGET		October	November	December	January	February	March	April	May	June	July	August	September	Total
Labor															Daily Burn
	SRM	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#DIV/0!
	REG	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#DIV/0!
	OT	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#DIV/0!
	DB	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#DIV/0!
	BOS	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#DIV/0!
	REG	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#DIV/0!
	OT	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#DIV/0!
	DB	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#DIV/0!
		0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#DIV/0!
	Forecast Value	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
	Variance	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00

Material															Daily Burn
	SRM	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#DIV/0!
	BOS	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#DIV/0!
		0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#DIV/0!
	Forecast Value	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
	Variance	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00

Outstanding Obligations
	SRM	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#DIV/0!
	BOS	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#DIV/0!
		0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00

Total															Daily Burn
	SRM	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#DIV/0!	ERROR:#REF!
	BOS	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#DIV/0!	ERROR:#REF!
		0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#DIV/0!
	Forecast Value	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
	Variance	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00

Cummulative total	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
Cummulative forecast	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00

Total + Obligations
	SRM	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#DIV/0!	ERROR:#REF!
	Fee	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00		ERROR:#REF!
	BOS	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#DIV/0!	ERROR:#REF!
	Fee	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00		ERROR:#REF!
		0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#DIV/0!
	Forecast Value	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!
	Variance	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!

SRM Fee	0.00	0.00	0.00
BOS Fee	0.00	0.00	0.00

Printed: &D &T &P of &N &F -- &A

ChartingData

CHARTING DATA		October	November	December	January	February	March	April	May	June	July	August	September	Total
Forecast															Daily Burn
	SRM	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!
	Labor	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#DIV/0!
	Materials	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#DIV/0!
	Fee	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!
	Cummulative	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!
	BOS	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#DIV/0!
	Labor	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#DIV/0!
	Materials	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#DIV/0!
	Fee	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#DIV/0!
	Cummulative	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
	Total Cumm	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!

Invoiced															Daily Burn
	SRM	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#DIV/0!
	Labor	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#DIV/0!
	Materials	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#DIV/0!
	Fee	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#DIV/0!
	Cummulative	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
	BOS	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#DIV/0!
	Labor	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#DIV/0!
	Materials	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#DIV/0!
	Fee	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#DIV/0!
	Cummulative	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
	Total Cumm	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00

Projection															Daily Burn
	SRM	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#DIV/0!
	Labor	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#DIV/0!
	Materials	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#DIV/0!
	Fee	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#DIV/0!
	Cummulative	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
	BOS	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#DIV/0!
	Labor	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#DIV/0!
	Materials	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#DIV/0!
	Fee	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#DIV/0!
	Cummulative	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
	Total Cumm	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00

Printed: &D &T &P of &N &F -- &A

Contract Cum

Forecast October November December January February March April May June July August September 0 0 0 0 0 0 0 0 0 0 0 0 0.00 October November December January February March April May June July August September 0 0 0 0 0 0 0 0 0 0 0 0 Projection October November December January February March April May June July August September 0 0 0 0 0 0 0 0 0 0 0 0 BOSCumm

BOS Forecast/Invoiced/Projection Forecast October November December January February March April May June July August September 0 0 0 0 0 0 0 0 0 0 0 0 Invoiced October November December January February March April May June July August September 0 0 0 0 0 0 0 0 0 0 0 0 Projection October November December January February March April May June July August September 0 0 0 0 0 0 0 0 0 0 0 0 SRMCum

SRM Forecast/Invoiced/Projection Forecast October November December January February March April May June July August September 0 0 0 0 0 0 0 0 0 0 0 0 Invoiced October November December January February March April May June July August September 0 0 0 0 0 0 0 0 0 0 0 0 Projection October November December January February March April May June July August September 0 0 0 0 0 0 0 0 0 0 0 0 SRMLabor

Forecast October November December January February March April May June July August September 0 0 0 0 0 0 0 0 0 0 0 0 Invoiced October November December January February March April May June July August September 0 0 0 0 0 0 0 0 0 0 0 0 Projection October November December January February March April May June July August September 0 0 0 0 0 0 0 0 0 0 0 0 Sheet2

		October	November	December	January	February								Total	SRM slide	Diff
Material															Shortage
	SRM Invoiced	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
	O/S Obligations	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
	Combined Obligations	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00

Forecast Value	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
Variance	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	ERROR:#REF!	ERROR:#REF!	G & A Accrual

		October	November	December	January	February	March	April	May	June	July	August	September	Total
Projected		0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
	SRM Invoiced	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
	O/S Obligations	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
	Combined Obligations	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00

Forecast Value	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
Variance	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00

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