Attachment 07 - MSS CDRLS Enclosure 2_CDRL A003_Sample_Format.xlsx

XLSX spreadsheet 33 KB Posted

Attached to
Amendment 0003 to Meteorological Support Services - Reagan Test Site: Formal Request for Proposals (RFP)
Solicitation number
W9113M-24-R-0061
Issued by

About this file

Written by GovTribe AI ·

This document contains a sample template for a fully loaded summary spreadsheet for meteorological support services. The template includes sections for labor hours and costs by budget project and CLIN, materials costs with escalation notes, travel and other direct costs, operations and maintenance costs by CWBS category, and fully loaded hourly rates.

The related federal contract opportunity is a formal RFP from the Department of the Army Materiel Command Contracting Command at Redstone Arsenal for meteorological support services at the Reagan Test Site. The RFP seeks proposals for these meteorological support services but does not include pricing terms, response dates, or other salient details.

View the file

Other files

File Type Posted
W9113M-24-0061 0003.pdf PDF
W9113M-24-R-0061 Conformed Copy.pdf PDF
Attachment 01_MSS PWS_Revison 01.pdf PDF
Attachment_12_ Questions and Answers.xlsx XLSX spreadsheet
RTS _FY24-27_Mission Schedule and Summary.pptx PPTX presentation
W9113M-24-R-0061 (amendment 02).pdf PDF
Attachment_12_ amended_ Questions and Answers.docx DOCX document
W9113M-24-R-0061(amendment 01).pdf PDF
W9113M-24-R-0061 (amendment 01).pdf PDF
Attachment 12_Cost-Price Schedule Template.xlsx XLSX spreadsheet
Attachment 02_MSS-PRS_FINAL.pdf PDF
Attachment 06 - RTS_Meteorological Facility and Equipment Manual (MFEM).pdf PDF
Attachment 10_MSS_Labor_Categories.xlsx XLSX spreadsheet
Attachment 01_MSS PWS_FINAL.pdf PDF
Attachment 11_Proposal-Adequacy-Checklist-.pdf PDF
Attachment 09_DD254_Draft (1).pdf PDF
Attachment 05_MSS_GFP.xlsx XLSX spreadsheet
Attachment 04 - MSS CDRLS Enclosure 1_General_Instructions.pdf PDF
Attachment 03 - MSS_DSL.pdf PDF
Attachment 04a_CDRL_Portfolio_signed.pdf PDF
W9113M-24-R-0061.pdf PDF
Attachment 08__Data Rights (1).pdf PDF
Show all 22

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.

Fully Loaded Summary

MISSION / PROJECT TITLE:

BY Budget
Project IDProject NameLabor Hrs($) Labor Cost($) Direct Material Cost($) Other Direct CostTotalFully Loaded Hrly
ARRW ATF-1
W1000CONUS Support$ - 0
W1100Program Management /ENG Spt$ - 0$0.00
W1200Meteorologist Support$ - 0$0.00
W1300Technician Support$ - 0$0.00
W1400Mission Met Systems Support$ - 0
W1500Consultant Meteorologist Support$ - 0
W1510Consultant Technician Support$ - 0
W1600Wake Is Meteorologist Support$ - 0
W1610Wake Is Technician Support$ - 0
W1700MET Rocket Meteorologist Support$ - 0
W1710MET Rocket Technician Support$ - 0
W2000CONUS Travel$ - 0
W2010OCONUS Travel$ - 0
$ - 0Check
TOTALs0.0$ - 0$ - 0$ - 0$ - 0ERROR:#VALUE!

CLIN_Summary

BY CLIN (PROEJCT TITLE)
EmployeeHoursRateAmount
A$ - 0
B$ - 0
C$ - 0
D$ - 0
E$ - 0
F$ - 0
G$ - 0
H$ - 0
I$ - 0
J$ - 0
K$ - 0
Total Hours0$ - 0
Labor Fringe Overhead%ERROR:#VALUE!
Overhead%ERROR:#VALUE!
Sub-Total Direct LaborERROR:#VALUE!
G&A%ERROR:#VALUE!
Total Fully Loaded Direct LaborERROR:#VALUE!
Fee (Labor Only)%ERROR:#VALUE!
CLI (List) (MSN / PROJECT Labor)ERROR:#VALUE!
CLIN(List) (MSN / PROJECT MaterialERROR:#VALUE!
CLIN(List) MSN / PROJECT Travel/ODCERROR:#VALUE!
CLIN(List) MSN / PROEJCT DBAERROR:#DIV/0!
TotalERROR:#VALUE!

Material QTY Unit Price Price Location tc={71CF3C31-F7B2-4F48-89EB-7706504D8F07}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

Material Escalated by 1.0343 for FY21 per the Contract Reply:

Escalated for FY22 price

Item$ - 0KWA
Item$ - 0KWA
Item$ - 0KWA
Miscellaneous & Shipping$ - 0KWA
Total Materials$ - 0
G&A%ERROR:#VALUE!
Total Material KWA LoadedERROR:#VALUE!

Travel_ODC

TripTrip FromTotal Trips/YrDestination# Empl/TripTravel ModeDaysNightsAirfareRental/Mileage/TaxiInternetPer Diem M&EPer Diem M&E 1,LastPer Diem LdgAirfareRental/MileageInternetPer Diem M&EPer Diem M&E 1,LastPer Diem LdgHotel TaxTotal per EmployeeTotal Cost per Trip
RATES ($)COST PER EMPLOYEE ($ Rounded)C * (E * V)
Mission SupportKWA1ROI1Air0000000.00000000000$0
Subtotal$0
G&A%ERROR:#VALUE!
TotalERROR:#VALUE!

DBA

Contract:
Contractor:
DBA Annual & Liability
Local Community Meteorological Support SummaryOps&Maint Equipment / Instrumentation SummaryI&M SummaryMSNS ESTTotal Annualized Hrs (no MSNS)
Total Hours by CWBS- 0- 0- 0
% of Total Annualized Hrs (No Missions)ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
Allocation of DBA by CWBS CategoryERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
G&A%ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
Note: Actual Mission Hours to be allocated DBA on a monthly basis.
Fully Loaded Hourly Rate (est)ERROR:#DIV/0!
(KWA only)(List Mission / Project)0ERROR:#DIV/0!

File details come from the government source that posted it. Updated .