J.12 Monthly Financial Report Burn Rate Template JUN2021.xlsx

XLSX spreadsheet 28 KB Posted Dec 9, 2021

Attached to: EMERALD Follow-on: "CLOVER" Multiple-Award IDIQ Contract (Amendment 0005)
Solicitation number: HM0476-21-R-0023
Issued by: Department of Defense National Geospatial Intelligence Agency

View the file

Other files

File	Type	Posted
Sol_HM047621R0023_Amd 0005_28MAR22.pdf	PDF	Mar 28, 2022
J.17 Self-Scoring Sheet 18MAR22.xlsx	XLSX spreadsheet	Mar 28, 2022
Sol_HM047621R0023_Amd 0005_28MAR22 Markup.pdf	PDF	Mar 28, 2022
Sol_HM047621R0023_Amd 0004_08MAR22.pdf	PDF	Mar 9, 2022
J.17 Self-Scoring Sheet 1MAR22.xlsx	XLSX spreadsheet	Mar 9, 2022
J.19 Past Performance Questionnaire 08MAR22 Markup.docx	DOCX document	Mar 9, 2022
J.19 Past Performance Questionnaire 08MAR22.docx	DOCX document	Mar 9, 2022
Sol_HM047621R0023_Amd 0004_08MAR22 Markup.pdf	PDF	Mar 9, 2022
J.17 Self-Scoring Sheet 1MAR22 Markup.xlsx	XLSX spreadsheet	Mar 9, 2022
Sol_HM047621R0023_Amd 0003 Consolidated Markup_11FEB22.pdf	PDF	Feb 14, 2022
Sol_HM047621R0023_Amd 0003 Consolidated_11FEB22.pdf	PDF	Feb 14, 2022
J.18 Relevant Experience Project Template JAN22.docx	DOCX document	Feb 7, 2022
Sol_HM047621R0023_Amd 0002 Consolidated_04FEB22.pdf	PDF	Feb 4, 2022
J.19 Past Performance Questionnaire 03FEB22.docx	DOCX document	Feb 4, 2022
J.2 Incentive Award Fee Plan JAN22.pdf	PDF	Feb 4, 2022
J.17 Self-Scoring Sheet JAN22.xlsx	XLSX spreadsheet	Feb 4, 2022
CLOVER QAs_Amd 0002_04FEB22.pdf	PDF	Feb 4, 2022
J.7 NDA JAN22.pdf	PDF	Feb 4, 2022
J.1 Multiple-Award IDIQ SOW 03FEB22.pdf	PDF	Feb 4, 2022
HM047621R0023-0001 CLOVER RFP - Amendment 1.pdf	PDF	Dec 10, 2021
J.5a Resume Template APR2021.docx	DOCX document	Dec 9, 2021
J.10 Monthly Staff Report Template JUN2021.xlsx	XLSX spreadsheet	Dec 9, 2021
J.15 Labor Rate Matrix - Task Order Template JUN2021.xlsx	XLSX spreadsheet	Dec 9, 2021
J.9 Travel Template JUN2021.xlsx	XLSX spreadsheet	Dec 9, 2021
J.7 NDA MAY2021.docx	DOCX document	Dec 9, 2021
CLOVER RFP HM047621R0023 Question and Answer Template.xlsx	XLSX spreadsheet	Dec 9, 2021
J.21 Telework Plan Template JUN2021.docx	DOCX document	Dec 9, 2021
J.20 FCL Information Template MAY2021.docx	DOCX document	Dec 9, 2021
J.19 Past Performance Questionnaire v3 9DEC2021.docx	DOCX document	Dec 9, 2021
J.5b Resume Instructions APR2021.docx	DOCX document	Dec 9, 2021
J.1 Multiple-Award IDIQ SOW v6_28SEP2021.pdf	PDF	Dec 9, 2021
J.18 Relevant Experience Project Template JUN2021.docx	DOCX document	Dec 9, 2021
J.23 FCL Application Supporting Documentation.docx	DOCX document	Dec 9, 2021
J.4 Skill Definition MAY2021.docx	DOCX document	Dec 9, 2021
CLOVER RFP HM047621R0023.pdf	PDF	Dec 9, 2021
J.2 Incentive Award Fee Plan JUL2021_FDOsigned.pdf	PDF	Dec 9, 2021
J.13 Monthly Activity Report Template APR2021.docx	DOCX document	Dec 9, 2021
J.3 Labor Rate Matrix - IDIQ Template JUN2021.xlsx	XLSX spreadsheet	Dec 9, 2021
J.14 Weekly Activity Report Template APR2021.docx	DOCX document	Dec 9, 2021
J.8 DD254 DRAFT 11MAR2021 v1.pdf	PDF	Dec 9, 2021
J.17 Self-Scoring Sheet v3 12JUN2021.xlsx	XLSX spreadsheet	Dec 9, 2021
J.22 FCL_Orientation_Handbook_9_March_2021.pdf	PDF	Dec 9, 2021
J.11 Monthly Financial Report CV Template JUN2021.xlsx	XLSX spreadsheet	Dec 9, 2021
J.16 Position Matrix Template MAY2021.xlsx	XLSX spreadsheet	Dec 9, 2021
J.6 OCI Disclosure and Analysis Form MAY2021.doc	DOC document	Dec 9, 2021

Show all 45

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.

Price Report

Contract Name and Number
POP:	COLOR KEY:
TASK ORDER #

T. Cardin: T. Cardin:

Each Task Order/Block of Work should be on a separate sheet.		One time entry (or as needed)
	Overall Contract Value		Monthly Entry

Total Contract LoE Hours		Enter the CLIN, Position ID, Name, and Rate once and it will populate throughout the entire spreadsheet. Insert rows as needed and copy the embedded formulas down.
Total Labor Amount
Total Travel & ODCs
Total Contract Amount	$0.00

BASELINE HOURS WORK SCHEDULED (PROPOSED)

CLIN

T. Cardin: T. Cardin:

Group by CLIN Position ID T. Cardin: T. Cardin:

Insert the unique position ID	Name		Nov-21	Dec-21	Jan-22	Feb-22	Mar-22	Apr-22	May-22	Jun-22	Jul-22	Aug-22	Sep-22	Oct-22	Total Hours PROPOSED
	123AB	06-XYZ-DO-001	Sally Smith		155.0	155.0	155.0	155.0	155.0	155.0	155.0	155.0	155.0	155.0	155.0	155.0	1,860.0
	123AB	06-XYZ-DO-002	Donald Duck		155.0	155.0	155.0	155.0	155.0	155.0	155.0	155.0	155.0	155.0	155.0	155.0	1,860.0
	123AB	06-XYZ-DO-003	Mickey Mouse		155.0	155.0	155.0	155.0	155.0	155.0	155.0	155.0	155.0	155.0	155.0	155.0	1,860.0
	999YZ	13-ABC-DO-099	Bram Stoker		155.0	155.0	155.0	155.0	155.0	155.0	155.0	155.0	155.0	155.0	155.0	155.0	1,860.0
	Total Baseline Hours				620.0	620.0	620.0	620.0	620.0	620.0	620.0	620.0	620.0	620.0	620.0	620.0	7,440.0

BASELINE COSTS WORK SCHEDULED (PROPOSED)
CLIN	Position ID

T. Cardin: T. Cardin:

Insert the unique position ID

Name

RATE

Nov-21

Dec-21

Jan-22

Feb-22

Mar-22

Apr-22

May-22

Jun-22

Jul-22

Aug-22

Sep-22

Oct-22

Total Dollars PROPOSED

123AB

06-XYZ-DO-001

Sally Smith

T. Cardin: T. Cardin:

Input name in the hours section and it will populate throughout.	$59.93	$9,289.15	$9,289.15	$9,289.15	$9,289.15	$9,289.15	$9,289.15	$9,289.15	$9,289.15	$9,289.15	$9,289.15	$9,289.15	$9,289.15	$111,469.80
	123AB	06-XYZ-DO-002	Donald Duck	$62.45	$9,679.75	$9,679.75	$9,679.75	$9,679.75	$9,679.75	$9,679.75	$9,679.75	$9,679.75	$9,679.75	$9,679.75	$9,679.75	$9,679.75	$116,157.00
	123AB	06-XYZ-DO-003	Mickey Mouse	$101.01	$15,656.55	$15,656.55	$15,656.55	$15,656.55	$15,656.55	$15,656.55	$15,656.55	$15,656.55	$15,656.55	$15,656.55	$15,656.55	$15,656.55	$187,878.60
	999YZ	13-ABC-DO-099	Bram Stoker	$130.00	$20,150.00	$20,150.00	$20,150.00	$20,150.00	$20,150.00	$20,150.00	$20,150.00	$20,150.00	$20,150.00	$20,150.00	$20,150.00	$20,150.00	$241,800.00
	Total Baseline Costs				$54,775.45	$54,775.45	$54,775.45	$54,775.45	$54,775.45	$54,775.45	$54,775.45	$54,775.45	$54,775.45	$54,775.45	$54,775.45	$54,775.45	$657,305.40

ACTUAL HOURS WORK PERFORMED
CLIN	Position ID

T. Cardin: T. Cardin:

Insert the unique position ID T. Cardin: T. Cardin:

Each Task Order/Block of Work should be on a separate sheet.

T. Cardin: T. Cardin:

Insert the unique position ID T. Cardin: T. Cardin:

Input name in the hours section and it will populate throughout.	Name		Nov-21	Dec-21	Jan-22	Feb-22	Mar-22	Apr-22	May-22	Jun-22	Jul-22	Aug-22	Sep-22	Oct-22	Total ACTUAL Hours
	123AB	06-XYZ-DO-001	Sally Smith		140.0	160.0	155.0										455.0
	123AB	06-XYZ-DO-002	Donald Duck		80.0	120.0	155.0										355.0
	123AB	06-XYZ-DO-003	Mickey Mouse		40.0	160.0	155.0										355.0
	SUBTOTAL HOURS for CLIN 123AB				260.0	440.0	465.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	1,165.0
	999YZ	13-ABC-DO-099	Bram Stoker		99.0	155.0	155.0
	SUBTOTAL HOURS for CLIN 999YZ				99.0	155.0	155.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0

Total Actual Labor Hours 359.0 595.0 620.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 1,165.0

ACTUAL COST WORK PERFORMED
CLIN	Position ID

T. Cardin: T. Cardin:

Insert the unique position ID

Name

Nov-21

Dec-21

Jan-22

Feb-22

Mar-22

Apr-22

May-22

Jun-22

Jul-22

Aug-22

Sep-22

Oct-22

Total ACTUAL Dollars

123AB

06-XYZ-DO-001

Sally Smith

$59.93

T. Cardin: T. Cardin:

copied from above	$8,390.20	$9,588.80	$9,289.15	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$27,268.15
	123AB	06-XYZ-DO-002	Donald Duck	$62.45	$4,996.00	$7,494.00	$9,679.75	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$22,169.75
	123AB	06-XYZ-DO-003	Mickey Mouse	$101.01	$4,040.40	$16,161.60	$15,656.55	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$35,858.55
	SUBTOTAL HOURS for CLIN 123AB				$17,426.60	$33,244.40	$34,625.45	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$85,296.45
	999YZ	13-ABC-DO-099	Bram Stoker	$130.00	$12,870.00	$20,150.00	$20,150.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
	SUBTOTAL COSTS for CLIN 999YZ				$12,870.00	$20,150.00	$20,150.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00

Total Actual Costs $17,426.60 $33,244.40 $34,625.45 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $85,296.45

VARIANCE HOURS WORK (Proposed - Actual)
CLIN	Work Role	Name	Nov-21	Dec-21	Jan-22	Feb-22	Mar-22	Apr-22	May-22	Jun-22	Jul-22	Aug-22	Sep-22	Oct-22	Total VARIANCE Hours
123AB	06-XYZ-DO-001	Sally Smith	15.0	(5.0)	0.0	155.0	155.0	155.0	155.0	155.0	155.0	155.0	155.0	155.0	1,405.0
123AB	06-XYZ-DO-002	Donald Duck	75.0	35.0	0.0	155.0	155.0	155.0	155.0	155.0	155.0	155.0	155.0	155.0	1,505.0
123AB	06-XYZ-DO-003	Mickey Mouse	115.0	(5.0)	0.0	155.0	155.0	155.0	155.0	155.0	155.0	155.0	155.0	155.0	1,505.0
999YZ	13-ABC-DO-099	Bram Stoker	56.0	0.0	0.0	155.0	155.0	155.0	155.0	155.0	155.0	155.0	155.0	155.0	1,451.0
Total Variance - HOURS			205.0	25.0	0.0	465.0	465.0	465.0	465.0	465.0	465.0	465.0	465.0	465.0	4,415.0

VARIANCE COSTS WORK (PROPOSED - ACTUAL)
CLIN	Work Role	Name	Nov-21	Dec-21	Jan-22	Feb-22	Mar-22	Apr-22	May-22	Jun-22	Jul-22	Aug-22	Sep-22	Oct-22	Total VARIANCE Dollars
123AB	06-XYZ-DO-001	Sally Smith	$898.95	($299.65)	$0.00	$9,289.15	$9,289.15	$9,289.15	$9,289.15	$9,289.15	$9,289.15	$9,289.15	$9,289.15	$9,289.15	$84,201.65
123AB	06-XYZ-DO-002	Donald Duck	$4,683.75	$2,185.75	$0.00	$9,679.75	$9,679.75	$9,679.75	$9,679.75	$9,679.75	$9,679.75	$9,679.75	$9,679.75	$9,679.75	$93,987.25
123AB	06-XYZ-DO-003	Mickey Mouse	$11,616.15	($505.05)	$0.00	$15,656.55	$15,656.55	$15,656.55	$15,656.55	$15,656.55	$15,656.55	$15,656.55	$15,656.55	$15,656.55	$152,020.05
999YZ	13-ABC-DO-099	Bram Stoker	$7,280.00	($13,094.40)	($14,475.45)	$20,150.00	$20,150.00	$20,150.00	$20,150.00	$20,150.00	$20,150.00	$20,150.00	$20,150.00	$20,150.00	$156,503.55
Total Variance - COST			$17,198.85	$1,381.05	$0.00	$34,625.45	$34,625.45	$34,625.45	$34,625.45	$34,625.45	$34,625.45	$34,625.45	$34,625.45	$34,625.45	$330,208.95

CUMULATIVE HOURS	Nov-21	Dec-21	Jan-22	Feb-22	Mar-22	Apr-22	May-22	Jun-22	Jul-22	Aug-22	Sep-22	Oct-22	Total
BASELINE HOURS	620.00	1,240.00	1,860.00	2,480.00	3,100.00	3,720.00	4,340.00	4,960.00	5,580.00	6,200.00	6,820.00	7,440.00	48,360.00
ACTUAL HOURS	359.00	954.00	1,574.00	1,574.00	1,574.00	1,574.00	1,574.00	1,574.00	1,574.00	1,574.00	1,574.00	1,574.00	17,053.00
AVAILABLE HOURS	261.00	286.00	286.00	906.00	1,526.00	2,146.00	2,766.00	3,386.00	4,006.00	4,626.00	5,246.00	5,866.00	31,307.00

TRAVEL

CLIN

Nov-21

Dec-21

Jan-22

Feb-22

Mar-22

Apr-22

May-22

Jun-22

Jul-22

Aug-22

Sep-22

Oct-22

Total

ACTUAL TRAVEL

123AB

$1,500.00

$2,500.00

$0.00

CUMULATIVE DOLLARS	Nov-21	Dec-21	Jan-22	Feb-22	Mar-22	Apr-22	May-22	Jun-22	Jul-22	Aug-22	Sep-22	Oct-22	Total
CUMULATIVE BASELINE COST WORK SCHEDULED	$54,775.45	$109,550.90	$164,326.35	$219,101.80	$273,877.25	$328,652.70	$383,428.15	$438,203.60	$492,979.05	$547,754.50	$602,529.95	$657,305.40	$4,272,485.10
LABOR FUNDED AMOUNT	$12,345,678.00	$12,345,678.00	$12,395,678.00	$12,395,678.00	$12,395,678.00	$12,395,678.00	$12,395,678.00	$12,395,678.00	$12,395,678.00	$12,395,678.00	$12,395,678.00	$12,395,678.00	$148,648,136.00
TRAVEL FUNDED AMOUNT	$98,765.00	$98,765.00	$88,765.00	$88,765.00	$88,765.00	$88,765.00	$88,765.00	$88,765.00	$88,765.00	$88,765.00	$88,765.00	$88,765.00	$1,085,180.00
CUMULATIVE LABOR COST	$17,426.60	$50,671.00	$85,296.45	$85,296.45	$85,296.45	$85,296.45	$85,296.45	$85,296.45	$85,296.45	$85,296.45	$85,296.45	$85,296.45	$921,062.10
CUMULATIVE TRAVEL COST	$1,500.00	$4,000.00	$4,000.00	$4,000.00	$4,000.00	$4,000.00	$4,000.00	$4,000.00	$4,000.00	$4,000.00	$4,000.00	$4,000.00	$45,500.00
CUMULATIVE TOTAL ACTUAL COST	$18,926.60	$54,671.00	$89,296.45	$89,296.45	$89,296.45	$89,296.45	$89,296.45	$89,296.45	$89,296.45	$89,296.45	$89,296.45	$89,296.45	$966,562.10
LABOR $$ REMAINING (FUNDED - INVOICED)	$12,328,251.40	$12,295,007.00	$12,310,381.55	$12,310,381.55	$12,310,381.55	$12,310,381.55	$12,310,381.55	$12,310,381.55	$12,310,381.55	$12,310,381.55	$12,310,381.55	$12,310,381.55	$147,727,073.90
TRAVEL/ODC $$ REMAINING (FUNDED - INVOICED)	$97,265.00	$94,765.00	$84,765.00	$84,765.00	$84,765.00	$84,765.00	$84,765.00	$84,765.00	$84,765.00	$84,765.00	$84,765.00	$84,765.00	$1,039,680.00

ESTIMATE TO COMPLETE

T. Cardin: T. Cardin:

how much $$ is needed to get to the end of the current period of performance, by month

T. Cardin: T. Cardin:

Group by CLIN T. Cardin: T. Cardin:

copied from above T. Cardin: T. Cardin:

Insert the unique position ID	CLIN 123AB			$20,000,000.00	$18,000,000.00	$30,000,000.00
		ESTIMATE TO COMPLETE	CLIN 999YZ			$50,000.00	$46,950.00	$100,000.00

Funded Amount $149,733,316 Explanation for Variances:

Bram Stoker came on board mid month.

Mickey Mouse was hospitalized with rat poisoning.

YTD Actual Labor Costs	$921,062
YTD Actual Travel Costs	$45,500
Total Actual Costs To Date	$966,562
Percent Funding Spent	0.65%

HM0476-21-R-0023 &"Tahoma,Bold"&12UNCLASSIFIED

CLOVER, <Contract Number>: Contract Year Attachment J.12 Monthly Financial Report Burn Rate Template

As of: &D &"Tahoma,Bold"&12Unclassified Agency/Contractor - Proprietary & Sensitive

DATA DISPLAYED IS FOR DEMO PURPOSES ONLY, AND USED TO TEST FORMULAS.

IT IS NOT REAL AND SHOULD BE REPLACED WITH REAL DATA

File details come from the government source that posted it. Updated Dec 10, 2021.