Attachment 0012 - Cost Variance Report Template.xlsx

XLSX spreadsheet 24 KB Posted Oct 4, 2017

Attached to: Logistics Civil Augmentation Program (LOGCAP) V Federal contract opportunity
Solicitation number: W52P1J-16-R-0001
Issued by: Department of the Army Materiel Command Joint Munitions Command

About this file

Written by GovTribe AI · Dec 30, 2023

This document contains a cost variance report template for the Logistics Civil Augmentation Program (LOGCAP) IV contract along with relevant federal contract opportunity details. The template is designed to capture cost, budget, and performance data across multiple base camp services and logistics functions. It includes tables for reporting information at the work breakdown structure level, by cost element and site, along with several supporting data files.

The related federal contract opportunity notice announces an industry week in October 2015 for the Logistics Civil Augmentation Program V pre-solicitation. Army Sustainment Command and Army Contracting Command - Rock Island will host sessions for Enhanced Army Global Enterprise business alliance holders and an LOGCAP industry day. The event location and schedule are specified, with further instructions on registration and one-on-one meeting requests to follow.

From the source

Cost Variance Report Template

View the file

Other files for this federal contract opportunity

Other files attached to Logistics Civil Augmentation Program (LOGCAP) V, newest first.
File	Type	Posted
LOGCAP_V_Industry_Day_24Oct17_Attendee_List.pdf	PDF	Nov 1, 2017
LOGCAP_V_Industry_Day_24OCT2017.pdf	PDF	Oct 20, 2017
Attachment 0009 - Soto Cano Tech Exhibit.xlsx	XLSX spreadsheet	Oct 4, 2017
Attachment 0004 - Iraq Tech Exhibit.xlsx	XLSX spreadsheet	Oct 4, 2017
Attachment 0006 - Kwajalein Tech Exhibit.xlsx	XLSX spreadsheet	Oct 4, 2017
Attachment 0016 - Cost Reimbursable Pricing Proposal Format.xlsx	XLSX spreadsheet	Oct 4, 2017
Attachment 0003 - AP Other Tech Exhibit.xlsx	XLSX spreadsheet	Oct 4, 2017
Attachment 0020 - Small Business Report.xls	XLS spreadsheet	Oct 4, 2017
Attachment 0021 - Regional Capability Matrix.xlsx	XLSX spreadsheet	Oct 4, 2017
Attachment 0019 - Small Business Participation Plan.docx	DOCX document	Oct 4, 2017
Attachment 0007 - NTC Tech Exhibit.xlsx	XLSX spreadsheet	Oct 4, 2017
Attachment 0018 - Required Supporting Documentation.docx	DOCX document	Oct 4, 2017
Attachment 0022 - Contract Performance Questionnaire.docx	DOCX document	Oct 4, 2017
Attachment 0008 - AFRICOM Tech Exhibit.xlsx	XLSX spreadsheet	Oct 4, 2017
Attachment 0005 - EUCOM Tech Exhibit.xlsx	XLSX spreadsheet	Oct 4, 2017
Attachment 0001 - LOGCAP V PWS.docx	DOCX document	Oct 4, 2017
Attachment 0002 - Kuwait Tech Exhibit.xlsx	XLSX spreadsheet	Oct 4, 2017
Attachment 0011 - Workload Data Report Template.xlsx	XLSX spreadsheet	Oct 4, 2017
LOGCAP_Industry_Day_Registration_Form_24Oct17.docx	DOCX document	Sep 27, 2017
LCV_Industry_Day_Announcement_24-25Oct17.pdf	PDF	Sep 21, 2017
Industry_Timeline.pptx	PPTX presentation	Aug 25, 2017
LOGCAP_V_PWS_20170802_DRAFT.pdf	PDF	Aug 7, 2017
LOGCAP_V_Notional_Tech_Exhibit.xlsx	XLSX spreadsheet	Aug 7, 2017
LOGCAP_V_Attendee_List_23May17.pdf	PDF	Jun 6, 2017
LOGCAP_V_Industry_Day_23May17_FINAL.pdf	PDF	Jun 6, 2017
LOGCAP_V_Industry_Day_Slides_23May17.pdf	PDF	May 19, 2017
Draft_RFP_Q&A_Industry_Release.pdf	PDF	May 16, 2017
LOGCAP_Industry_Day_Registration_Form_23May17.docx	DOCX document	Apr 26, 2017
Indirect_Rate_Limitation.pdf	PDF	Apr 14, 2017
Industry_Week_Announcement_Industry_Day_23May17.ppt	PPT presentation	Apr 14, 2017
LOGCAP_Standardized_PWS_DRAFT.pdf	PDF	Apr 14, 2017
Past_Performance_Questionnaire.pdf	PDF	Apr 14, 2017
Cost_Narrative.pdf	PDF	Apr 14, 2017
Cost_Price_Proposal_Requirements.pdf	PDF	Apr 14, 2017
Draft_RFP-RFI_Template.xlsx	XLSX spreadsheet	Apr 14, 2017
Small_Business_Participation.pdf	PDF	Apr 14, 2017
FFP_Pricing_Template.xlsx	XLSX spreadsheet	Apr 14, 2017
Financial_Capability_Documentation.pdf	PDF	Apr 14, 2017
W52P1J16R0001_LCV_DRAFT_RFP.pdf	PDF	Apr 14, 2017
Support.pdf	PDF	Apr 14, 2017
LOGCAP_V_Industry_day_Q A.pdf	PDF	Nov 21, 2016
LOGCAP_V_Industry_Day_Brief_FINAL_15_Nov_16.pdf	PDF	Nov 15, 2016
I-74_exit_closure.pdf	PDF	Nov 10, 2016
LOGCAP_Requirements_Template_-_Workload_ _H.2.xlsx	XLSX spreadsheet	Nov 7, 2016
LOGCAP_Standardized_PWS.pdf	PDF	Nov 7, 2016
LOGCAP_Industry_Day_Registration_Form.docx	DOCX document	Oct 18, 2016
Industry_Week_Announcement.ppt	PPT presentation	Oct 6, 2016
LCV_SB_sources_sought.pdf	PDF	May 17, 2016
ASC_Industry_Week.pptx	PPTX presentation	Oct 21, 2015
LOGCAP_Industry_Day_Registration_Form.docx	DOCX document	Oct 7, 2015

Show all 50

Logistics Civil Augmentation Program (LOGCAP) V 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.

Summary

LOGCAP IV COST VARIANCE & DATA SET

Contract Information:

Contractor Name

Contract #

Task Order Information:

Task Order #

Task Order Description

Reporting Period Information:

POP Start

POP End

Current Period Start

Current Period End

TO POP Cost Summary

WBS Ref.	Service	(CP) Budgeted Cost	(CP) ACWP	(CP) Variance	(CTD) Budgeted Cost	(CTD) ACWP	(CTD) Variance	(TP) Budget Cost	(TP) ACWP	(TP) ETC	(TP) EAC	(TP) Variance
04.00	Base Camp Services
04.01	Shelter and Billeting
04.02.	Utility Operations.
04.02.01	Environmental Control
04.02.02	Power/Electricity
04.02.03	Emergency Back up Power Generation
04.03	Water and Ice service
04.03.01	Source Raw Water
04.03.02	Produce Bulk Potable Water
04.03.03	Produce Bulk Non-Potable Water
04.03.04	Ice Services
04.04	Textile Services
04.04.01	Full Service Laundry
04.04.02	Medical Service Laundry
04.04.03	Self-Service Laundry
04.04.04	Textile Repair
04.05	Custodial Services
04.06	Food Service Operations
04.07	Reserved
04.08	Pest Services
04.09	Waste Management Services
04.09.01	Non-Hazardous Solid Waste Management
04.09.02	Hazardous Waste Management
04.09.03	Medical Waste Management
04.09.04	Gray Water Management, Recycle and Reuse
04.09.05	Sewage and Black Water Waste Management
04.10	Morale, Welfare, Recreation Services
04.10.01	Morale, Welfare, Recreation Communication Centers
04.10.02	Community Centers
04.10.03	Athletic and Exercise Centers
04.10.04	Athletic Fields and Activities
04.11	Postal Operations
04.12	Fire and Emergency Services (F&ES).
04.12.01	Fire Protection Services
04.12.02	Fire Fighting Services
04.12.02	Fire Protection Services
04.12.03	Ambulance Services
04.12.04	Medical and Health Services
04.12.04.01	Medical Care (Role 1)
04.12.04.01.01	Physician's Assistant
04.12.04.01.02.	Nurse Practitioner
04.12.04.02	Medical Treatment Facility (Role 2)
04.12.04.02.01	Family Practice Physician – Board Certified
04.12.04.02.02.	Physician's Assistant
04.12.04.02.03	Nurse Practitioner
04.12.04.02.04	Registered Nurse
04.13	Security Services
04.13.01.	Badging Services and Biometric Support.
04.13.02.	Baggage and Postal Security Screening
04.14	Horizontal (Roads, Grounds, and Barrier) Maintenance Activities
04.15	Range Management
04.16	Camp Operations and Maintenance Management
04.17	Camp Logistics Support Functions
04.17.01	Class III Retail Operations
04.17.02	Agricultural Cleaning.
04.18	Mortuary Affairs
04.19	Communication and Information Technology Support
04.19.01.	Automated Information Systems.
05.00	Supply Management, Strategic and Operational
05.01	Manage Supplies and Equipment, Operational and Tactical (Point of Service or Installation)
05.01.01	Supply Support Activity (SSA) Operations, Tactical (Point of Service or Installation)
05.01.02	Inventory Management, Operational and Tactical (Point of Service or Installation).
05.01.03	Forward Redistribution Point (FRP)
05.02	Property Management
05.03	Class III Bulk Operations
05.04	Ammunition and Munition Operations
05.05	Class VIII Medical Supply
06.00	Maintenance
06.01	Equipment and Material Maintenance (field level and below depot sustainment maintenance).
06.01.01	Service
06.01.02	Fault Repair
06.01.01	Fault Repair
06.01.03	Recovery
06.01.04	Oil Analysis
06.01.05	Calibration
06.02	Facility Maintenance.
06.02	Facility Maintenance.
07.00
07.01.	Mode Operations.
07.01.01.	Motor Transportation
07.01.01.01.	Base Motor Pool and Dispatch
07.01.01.01	Base Motor Pool and Dispatch
07.01.01.02.	Drayage
07.01.01.02	Drayage
07.01.02	Air transportation.
07.01.02.01.	Autonomous/Semi-Autonomous Aerial Delivery.
07.01.03	Inland Water Transportation.
07.01.04	Personnel Transport.
07.02	Intermodal Operations.
07.02.01	Ports.
07.02.02	Terminals.
07.02.02	Terminals
07.03.	Containerization
07.03.01	Container Management
07.03.02	Container Certification and Recertification
07.04.	Theater Distribution.
07.04.01	Transportation Resource Planning/Asset Visibility/In-Transit Visibility.
07.04.02.	Load Configuration Operations.
07.04.02	Load Configuration Operations.
07.05	Movement Control Team Support Operations
07.06	Air Transportation Operations
07.06.01	Airfield Management
07.06.02.	Airfield Safety.
07.06.02	Airfield Safety.
07.06.03.	Airfield Operations.
07.06.03	Airfield Operations.
07.06.04	Air Traffic Control (ATC)
07.06.05	Air Traffic Control Maintenance.
07.06.06	Weather Support to Air Operations.
08.00	Team LOGCAP Forward Support

TO Cost Element Summary

Cost Element	Current Budgeted Cost	Current ACWP	Current Variance	Total Period Budgeted Cost	Total Period ACWP	Total Period Variance	Total Period ETC	Total Period EAC	(TP) Variance
Labor
Material
Equipment
ODC
Subcontract

Cost Data File

CLIN	Site #	Site Name	Customer/Bill Payer	POP Identifier	POP Start	POP End	Current Period Start	Current Period End	WBS Ref.	Service	Cost Element	Current Budgeted Cost	Current Incurred Cost	Current Committed Cost	Current ACWP (Incurred + Committed)	Current Variance	(CTD) Budgeted Cost	(CTD) Incurred	(CTD) Committed	(CTD) ACWP	(CTD) Variance	Total Period Budgeted Cost	Total Period Incurred Cost	Total Period Committed Cost	Total Period ACWP (Incurred + Committed)	Total Period Variance	Total Period ETC	Total Period EAC	(TP) Variance	Current Period Burn Rate	Total Period Burn Rate
									04.00	Base Camp Services
									04.01	Shelter and Billeting
									04.02.	Utility Operations.
									04.02.01	Environmental Control
									04.02.02	Power/Electricity
									04.02.03	Emergency Back up Power Generation
									04.03	Water and Ice service
									04.03.01	Source Raw Water
									04.03.02	Produce Bulk Potable Water
									04.03.03	Produce Bulk Non-Potable Water
									04.03.04	Ice Services
									04.04	Textile Services
									04.04.01	Full Service Laundry
									04.04.02	Medical Service Laundry
									04.04.03	Self-Service Laundry
									04.04.04	Textile Repair
									04.05	Custodial Services
									04.06	Food Service Operations
									04.07	Reserved
									04.08	Pest Services
									04.09	Waste Management Services
									04.09.01	Non-Hazardous Solid Waste Management
									04.09.02	Hazardous Waste Management
									04.09.03	Medical Waste Management
									04.09.04	Gray Water Management, Recycle and Reuse
									04.09.05	Sewage and Black Water Waste Management
									04.10	Morale, Welfare, Recreation Services
									04.10.01	Morale, Welfare, Recreation Communication Centers
									04.10.02	Community Centers
									04.10.03	Athletic and Exercise Centers
									04.10.04	Athletic Fields and Activities
									04.11	Postal Operations
									04.12	Fire and Emergency Services (F&ES).
									04.12.01	Fire Protection Services
									04.12.02	Fire Fighting Services
									04.12.02	Fire Protection Services
									04.12.03	Ambulance Services
									04.12.04	Medical and Health Services
									04.12.04.01	Medical Care (Role 1)
									04.12.04.01.01	Physician's Assistant
									04.12.04.01.02.	Nurse Practitioner
									04.12.04.02	Medical Treatment Facility (Role 2)
									04.12.04.02.01	Family Practice Physician – Board Certified
									04.12.04.02.02.	Physician's Assistant
									04.12.04.02.03	Nurse Practitioner
									04.12.04.02.04	Registered Nurse
									04.13	Security Services
									04.13.01.	Badging Services and Biometric Support.
									04.13.02.	Baggage and Postal Security Screening
									04.14	Horizontal (Roads, Grounds, and Barrier) Maintenance Activities
									04.15	Range Management
									04.16	Camp Operations and Maintenance Management
									04.17	Camp Logistics Support Functions
									04.17.01	Class III Retail Operations
									04.17.02	Agricultural Cleaning.
									04.18	Mortuary Affairs
									04.19	Communication and Information Technology Support
									04.19.01.	Automated Information Systems.
									05.00	Supply Management, Strategic and Operational
									05.01	Manage Supplies and Equipment, Operational and Tactical (Point of Service or Installation)
									05.01.01	Supply Support Activity (SSA) Operations, Tactical (Point of Service or Installation)
									05.01.02	Inventory Management, Operational and Tactical (Point of Service or Installation).
									05.01.03	Forward Redistribution Point (FRP)
									05.02	Property Management
									05.03	Class III Bulk Operations
									05.04	Ammunition and Munition Operations
									05.05	Class VIII Medical Supply
									06.00	Maintenance
									06.01	Equipment and Material Maintenance (field level and below depot sustainment maintenance).
									06.01.01	Service
									06.01.02	Fault Repair
									06.01.01	Fault Repair
									06.01.03	Recovery
									06.01.04	Oil Analysis
									06.01.05	Calibration
									06.02	Facility Maintenance.
									06.02	Facility Maintenance.
									07.00
									07.01.	Mode Operations.
									07.01.01.	Motor Transportation
									07.01.01.01.	Base Motor Pool and Dispatch
									07.01.01.01	Base Motor Pool and Dispatch
									07.01.01.02.	Drayage
									07.01.01.02	Drayage
									07.01.02	Air transportation.
									07.01.02.01.	Autonomous/Semi-Autonomous Aerial Delivery.
									07.01.03	Inland Water Transportation.
									07.01.04	Personnel Transport.
									07.02	Intermodal Operations.
									07.02.01	Ports.
									07.02.02	Terminals.
									07.02.02	Terminals
									07.03.	Containerization
									07.03.01	Container Management
									07.03.02	Container Certification and Recertification
									07.04.	Theater Distribution.
									07.04.01	Transportation Resource Planning/Asset Visibility/In-Transit Visibility.
									07.04.02.	Load Configuration Operations.
									07.04.02	Load Configuration Operations.
									07.05	Movement Control Team Support Operations
									07.06	Air Transportation Operations
									07.06.01	Airfield Management
									07.06.02.	Airfield Safety.
									07.06.02	Airfield Safety.
									07.06.03.	Airfield Operations.
									07.06.03	Airfield Operations.
									07.06.04	Air Traffic Control (ATC)
									07.06.05	Air Traffic Control Maintenance.
									07.06.06	Weather Support to Air Operations.
									08.00	Team LOGCAP Forward Support

UCO Data File CLIN Site # Site Name UCO # Customer/Bill Payer POP Start POP End Cost Element Total Period Budgeted Cost Total Period ACWP Total Period ETC Total Period EAC (TP) Variance

CLIN Data File CLIN POP Start Date POP End Date Customer Obligated Funding

WBS Listing

LISTING OF PWS PARAGRAPHS
WBS Ref.	Service
04.00	Base Camp Services
04.01	Shelter and Billeting
04.02.	Utility Operations.
04.02.01	Environmental Control
04.02.02	Power/Electricity
04.02.03	Emergency Back up Power Generation
04.03	Water and Ice service
04.03.01	Source Raw Water
04.03.02	Produce Bulk Potable Water
04.03.03	Produce Bulk Non-Potable Water
04.03.04	Ice Services
04.04	Textile Services
04.04.01	Full Service Laundry
04.04.02	Medical Service Laundry
04.04.03	Self-Service Laundry
04.04.04	Textile Repair
04.05	Custodial Services
04.06	Food Service Operations
04.07	Reserved
04.08	Pest Services
04.09	Waste Management Services
04.09.01	Non-Hazardous Solid Waste Management
04.09.02	Hazardous Waste Management
04.09.03	Medical Waste Management
04.09.04	Gray Water Management, Recycle and Reuse
04.09.05	Sewage and Black Water Waste Management
04.10	Morale, Welfare, Recreation Services
04.10.01	Morale, Welfare, Recreation Communication Centers
04.10.02	Community Centers
04.10.03	Athletic and Exercise Centers
04.10.04	Athletic Fields and Activities
04.11	Postal Operations
04.12	Fire and Emergency Services (F&ES).
04.12.01	Fire Protection Services
04.12.02	Fire Fighting Services
04.12.02	Fire Protection Services
04.12.03	Ambulance Services
04.12.04	Medical and Health Services
04.12.04.01	Medical Care (Role 1)
04.12.04.01.01	Physician's Assistant
04.12.04.01.02.	Nurse Practitioner
04.12.04.02	Medical Treatment Facility (Role 2)
04.12.04.02.01	Family Practice Physician – Board Certified
04.12.04.02.02.	Physician's Assistant
04.12.04.02.03	Nurse Practitioner
04.12.04.02.04	Registered Nurse
04.13	Security Services
04.13.01.	Badging Services and Biometric Support.
04.13.02.	Baggage and Postal Security Screening
04.14	Horizontal (Roads, Grounds, and Barrier) Maintenance Activities
04.15	Range Management
04.16	Camp Operations and Maintenance Management
04.17	Camp Logistics Support Functions
04.17.01	Class III Retail Operations
04.17.02	Agricultural Cleaning.
04.18	Mortuary Affairs
04.19	Communication and Information Technology Support
04.19.01.	Automated Information Systems.
05.00	Supply Management, Strategic and Operational
05.01	Manage Supplies and Equipment, Operational and Tactical (Point of Service or Installation)
05.01.01	Supply Support Activity (SSA) Operations, Tactical (Point of Service or Installation)
05.01.02	Inventory Management, Operational and Tactical (Point of Service or Installation).
05.01.03	Forward Redistribution Point (FRP)
05.02	Property Management
05.03	Class III Bulk Operations
05.04	Ammunition and Munition Operations
05.05	Class VIII Medical Supply
06.00	Maintenance
06.01	Equipment and Material Maintenance (field level and below depot sustainment maintenance).
06.01.01	Service
06.01.02	Fault Repair
06.01.01	Fault Repair
06.01.03	Recovery
06.01.04	Oil Analysis
06.01.05	Calibration
06.02	Facility Maintenance.
06.02	Facility Maintenance.
07.00
07.01.	Mode Operations.
07.01.01.	Motor Transportation
07.01.01.01.	Base Motor Pool and Dispatch
07.01.01.01	Base Motor Pool and Dispatch
07.01.01.02.	Drayage
07.01.01.02	Drayage
07.01.02	Air transportation.
07.01.02.01.	Autonomous/Semi-Autonomous Aerial Delivery.
07.01.03	Inland Water Transportation.
07.01.04	Personnel Transport.
07.02	Intermodal Operations.
07.02.01	Ports.
07.02.02	Terminals.
07.02.02	Terminals
07.03.	Containerization
07.03.01	Container Management
07.03.02	Container Certification and Recertification
07.04.	Theater Distribution.
07.04.01	Transportation Resource Planning/Asset Visibility/In-Transit Visibility.
07.04.02.	Load Configuration Operations.
07.04.02	Load Configuration Operations.
07.05	Movement Control Team Support Operations
07.06	Air Transportation Operations
07.06.01	Airfield Management
07.06.02.	Airfield Safety.
07.06.02	Airfield Safety.
07.06.03.	Airfield Operations.
07.06.03	Airfield Operations.
07.06.04	Air Traffic Control (ATC)
07.06.05	Air Traffic Control Maintenance.
07.06.06	Weather Support to Air Operations.
08.00	Team LOGCAP Forward Support

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