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) Federal contract opportunity
- Solicitation number
- W9113M-24-R-0061
About this file
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 for this federal contract opportunity
Show all 22
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
Text version
Fully Loaded Summary
MISSION / PROJECT TITLE:
| BY Budget | |||||||
| Project ID | Project Name | Labor Hrs | ($) Labor Cost | ($) Direct Material Cost | ($) Other Direct Cost | Total | Fully Loaded Hrly |
| ARRW ATF-1 |
| W1000 | CONUS Support | $ - 0 | ||||||
| W1100 | Program Management /ENG Spt | $ - 0 | $0.00 | |||||
| W1200 | Meteorologist Support | $ - 0 | $0.00 | |||||
| W1300 | Technician Support | $ - 0 | $0.00 | |||||
| W1400 | Mission Met Systems Support | $ - 0 | ||||||
| W1500 | Consultant Meteorologist Support | $ - 0 | ||||||
| W1510 | Consultant Technician Support | $ - 0 | ||||||
| W1600 | Wake Is Meteorologist Support | $ - 0 | ||||||
| W1610 | Wake Is Technician Support | $ - 0 | ||||||
| W1700 | MET Rocket Meteorologist Support | $ - 0 | ||||||
| W1710 | MET Rocket Technician Support | $ - 0 | ||||||
| W2000 | CONUS Travel | $ - 0 | ||||||
| W2010 | OCONUS Travel | $ - 0 | ||||||
| $ - 0 | Check | |||||||
| TOTALs | 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#VALUE! |
CLIN_Summary
| BY CLIN (PROEJCT TITLE) | |||
| Employee | Hours | Rate | Amount |
| A | $ - 0 | ||
| B | $ - 0 | ||
| C | $ - 0 | ||
| D | $ - 0 | ||
| E | $ - 0 | ||
| F | $ - 0 | ||
| G | $ - 0 | ||
| H | $ - 0 | ||
| I | $ - 0 | ||
| J | $ - 0 | ||
| K | $ - 0 | ||
| Total Hours | 0 | $ - 0 | |
| Labor Fringe Overhead | % | ERROR:#VALUE! | |
| Overhead | % | ERROR:#VALUE! | |
| Sub-Total Direct Labor | ERROR:#VALUE! | ||
| G&A | % | ERROR:#VALUE! | |
| Total Fully Loaded Direct Labor | ERROR:#VALUE! | ||
| Fee (Labor Only) | % | ERROR:#VALUE! | |
| CLI (List) (MSN / PROJECT Labor) | ERROR:#VALUE! | ||
| CLIN(List) (MSN / PROJECT Material | ERROR:#VALUE! | ||
| CLIN(List) MSN / PROJECT Travel/ODC | ERROR:#VALUE! | ||
| CLIN(List) MSN / PROEJCT DBA | ERROR:#DIV/0! | ||
| Total | ERROR:#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 | $ - 0 | KWA | |
| Item | $ - 0 | KWA | |
| Item | $ - 0 | KWA | |
| Miscellaneous & Shipping | $ - 0 | KWA | |
| Total Materials | $ - 0 | ||
| G&A | % | ERROR:#VALUE! | |
| Total Material KWA Loaded | ERROR:#VALUE! |
Travel_ODC
| Trip | Trip From | Total Trips/Yr | Destination | # Empl/Trip | Travel Mode | Days | Nights | Airfare | Rental/Mileage/Taxi | Internet | Per Diem M&E | Per Diem M&E 1,Last | Per Diem Ldg | Airfare | Rental/Mileage | Internet | Per Diem M&E | Per Diem M&E 1,Last | Per Diem Ldg | Hotel Tax | Total per Employee | Total Cost per Trip |
| RATES ($) | COST PER EMPLOYEE ($ Rounded) | C * (E * V) | ||||||||||||||||||||
| Mission Support | KWA | 1 | ROI | 1 | Air | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 |
| Subtotal | $0 | |
| G&A | % | ERROR:#VALUE! |
| Total | ERROR:#VALUE! |
DBA
| Contract: |
| Contractor: |
| DBA Annual & Liability | |||||||
| Local Community Meteorological Support Summary | Ops&Maint Equipment / Instrumentation Summary | I&M Summary | MSNS EST | Total 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 Category | ERROR:#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) | 0 | ERROR:#DIV/0! |
File details come from the government source that posted it. Updated .