Sec J Att 12 Travel Status Report Template 7 Feb 20.pdf

PDF 104 KB Posted Feb 21, 2020

Attached to: TEAMS-Next Contracting, Compliance, Cost/Price and Operations (C3PO)
Solicitation number: HQ0858-20-R-0001
Issued by: DOD Missile Defense Agency

About this file

Written by GovTribe AI · Dec 27, 2023

This document contains a travel status report template for tracking contractor travel expenses against multiple appropriation line items (ACRNs). The template includes instructions for completing a travel log to capture trip details such as dates, destinations, estimates, and invoices by fiscal year, company, stakeholder, contract line item, and ACRN. A macro button automates sorting by ACRN and summarizing expenses. The template also includes a table to input stakeholders, associated ACRNs, and obligated funds. Expense entries in the travel log will auto-populate remaining balances against each ACRN.

The related federal contract opportunity is a solicitation from the Missile Defense Agency seeking proposals for executive advisory and management support services in areas such as contracting, compliance, pricing, operations, and small business programs. The cost-plus-fixed-fee level of effort contract has a two-year base period and up to three one-year and one six-month option periods, to be awarded on a full small business set-aside basis. Proposals are due by March 23, 2020 for this requirement under the TEAMS-Next acquisition vehicle.

View the file

Other files

File	Type	Posted
Contractor BETA.SAM.GOV Quick Start Guide.pdf	PDF	Mar 12, 2020
Sec J Att 15 SOFA Travel Clauses.pdf	PDF	Feb 21, 2020
Sec J Att 06 Individual Contractor NDA 9 Jan 20.pdf	PDF	Feb 21, 2020
Att L6 Accounting System Checklist 7 Feb 20.doc	DOC document	Feb 21, 2020
Att L2 PPQ Form 20 Feb 20.docx	DOCX document	Feb 21, 2020
Sec J Att 05 TERP Pricing Model 19 Feb 20.xlsx	XLSX spreadsheet	Feb 21, 2020
Sec J Att 11 Cost Report Template 10 Feb 20.xlsx	XLSX spreadsheet	Feb 21, 2020
Att L3 Sample Consent Letter 9 Jan 20.pdf	PDF	Feb 21, 2020
Att L1 PPI Form 20 Feb 20.docx	DOCX document	Feb 21, 2020
Sec J Att 08 DD-254 19 Feb 20.pdf	PDF	Feb 21, 2020
Sec J Att 03 TERP Procedures 19 Feb 20.pdf	PDF	Feb 21, 2020
Sec J Att 09 Auth ODC Travel by CLIN.xlsx	XLSX spreadsheet	Feb 21, 2020
Sec J Att 13 Monthly Manpower Report Template 7 Feb 20.xlsx	XLSX spreadsheet	Feb 21, 2020
HQ0858-20-R-0001 C3PO.pdf	PDF	Feb 21, 2020
Att L7 OCI Disclosure Form 6 Feb 20.docx	DOCX document	Feb 21, 2020
Sec J Exh A CDRLs.pdf	PDF	Feb 21, 2020
Sec J Att 01 C3PO SOW 19 Feb 20.pdf	PDF	Feb 21, 2020
Sec J Att 07 PPBE Form 9 Jan 20.pdf	PDF	Feb 21, 2020
TEAMS-Next C3PO Sec M 20 Feb 20.pdf	PDF	Feb 21, 2020
Sec J Att 14 Quarterly Accomplishment Report Template 12 Feb 20.pdf	PDF	Feb 21, 2020
Att L5 Excel Pricing Worksheet 19 Feb 20.xlsx	XLSX spreadsheet	Feb 21, 2020
Sec J Att 04 TERP Form 19 Feb 20.pdf	PDF	Feb 21, 2020
Att L4 Client Authorization Letter 9 Jan 20.pdf	PDF	Feb 21, 2020
Sec J Att 02 G-06 Allot of Funds 11 Feb 20.pdf	PDF	Feb 21, 2020
Sec J Att 10 Monthly Status Report Template 10 Feb 20.pdf	PDF	Feb 21, 2020
TEAMS-Next C3PO Sec L 20 Feb 20.pdf	PDF	Feb 21, 2020

Show all 26

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.

Travel Log Instructions:

1. Select "Enable Content" to enable Macros.

STK

Travel

ACRN STK ACRN Obligated Amount

AB BA AB‐BA 250,000.00$

10. Travel Log is written in Excel 2010.

11. If you have any questions, please contact your task order COTR.

Formula Field

Color Indicates Data Input Field

Formula Field ‐ Conditional Formatting

9. Gray and Purple highlighted cells represent columns that are auto‐populated. No input required.

8. If travel plans are CANCELLED, reduce the Form 110 Estimate field and the Actual Invoiced Amount field on the appropriate row in the Travel

Log to zero and add comment in the "Notes" column as "CANCELLED."

7. Any changes to previously "INVOICED" travel requires a new entry in the travel log to account for any subsequent adjustments.

No Color = Auto‐Populated

NOTE: In order for workbook to function properly, instructions must be followed in sequential order.

5. Once travel data entry is complete, select "Ctrl Home" to return to top of spreadsheet. Scroll across to the macro located in column X, cell

X7 and select travel log sort. This will automatically sort all travel data by ACRN.

6. Select "Travel Summary" tab to view travel data by Stakeholder. To update summary, click on the "Select to Refresh Travel Summary" macro button located in cell A2.

2. Rename and save file as Travel Status Report‐Contractor Name‐Date.xlsm ‐ i.e. Travel Status Report‐ABC Company‐07192017.xlsm

IMPORTANT: Failure to SAVE file with the ".xlsm" Extension will ELIMINATE all Enabled macros

3. Select "Travel Log" tab. Scroll across to column X & select Goto Stakeholder(STK) CLIN Obligation Table macro. CLIN database table (starts in cell A1106) and input each of your STK(s) , STK travel ACRN, and the obligated amount for each ACRN. Do not enter data in column C of this table. It will auto‐populate. Once all obligations have been entered, select "Ctrl Home" to begin entering data into the Travel Log.

4. Select "Ctrl Home." Enter all applicable data in light blue highlighted cells ‐ i.e. Calendar Year; Company; Name; Form 110 Estimate; STK;

CLIN; SubCLIN; Travel ACRN; Start Date; End Date; Trip Destination; Purpose; Actual Invoice; Invoice #; Invoice Date; and Notes. All other columns are auto‐populated.

Calendar

Year Company Name

Form 110

Estimate STK CLIN SubCLIN

Travel

ACRN

STK

Travel

ACRN

Obligated

Amount Start Date End Date Trip Destination Purpose

Actual Invoiced

Amount Invoice Number Invoice Date Notes

Calculation of

Funding

Remaining

Funding

Remaining

Running Total

Funds

Remaining % of Obligation

‐ ‐$ ‐$ ‐$ ‐$ 0.00%

Data

STK

STK Travel

ACRN CLIN Obligated SubCLIN Form 110 Estimate Actual Invoiced Amount Funds Remaining

% of

Obligation

Grand Total

File details come from the government source that posted it. Updated Feb 22, 2020.