TE C - Monthly Progress and Financial.doc

DATA ITEM DESCRIPTION

Form Approved

OMB NO. 0704-0188

Public reporting burden for this collection of information is estimated to average 110 hours per response, including the time for reviewing instructions, searching existing data sources, gathering and maintaining the data needed, and completing and reviewing the collection of information. Send comments regarding this burden estimate or any other aspect of this collection of information, including suggestions for reducing this burden, to Department of Defense, Washington Headquarters Services, Directorate for Information Operations and Reports, 1215 Jefferson Davis Highway, Suite 1204, Arlington, VA 22202-4302, and to the Office of Management and Budget, Paperwork Reduction Project (0704-0188), Washington, DC 20503.

1. TITLE

A001/TE C, Monthly Progress & Financial Report

2. IDENTIFICATION NUMBER

3. DESCRIPTION/PURPOSE

This requirement summarizes the Contractor’s activities for the preceding month and cumulative totals for the fiscal year.

4. APPROVAL DATE (YYMMDD)

5. OFFICE OF PRIMARY RESPONSIBILITY (OPR)

USAOTC FSTD/AMDTD

6a. DTIC APPLICABLE

6b. GIDEP APPLICABLE

7. APPLICATION/INTERRELATIONSHIP

This Data Item Description contains the content requirements for the data products generated by the specific and discrete task requirements for this data included in this contract. This report will be provided for the three different organizations: FSTD and AMDTD

8. APPROVAL LIMITATION

9a. APPLICABLE FORMS

9b. AMSC NUMBER

10. PREPARATION INSTRUCTIONS

10.1 EXECUTIVE SUMMARY. Contractor format is acceptable.

a. Highlights of reported month's activities, including problems encountered and efforts to continually improve performance.

b. Projected activities.

10.2 PROGRESS AND HISTORICAL.

a. Task Order Summation. Provide the following information for all requirements that were issued during the fiscal year.

1. Task Order Number

2. Task Order Title

3. Government POC

4. Contractor POC

5. Purchasing POC

6. Task Order Issued

7. TIP Due Date

8. TIP Submitted

9. Amount Estimated

10. Amount Approved

11. Remarks

12. Amount Funded

13. Date Approved

11. DISTRIBUTION STATEMENT

DISTRIBUTION STATEMENT A: Approved for public release; distribution unlimited.

OMB NO. 0704-0188

b. Task Order Status Report. Provide the following information for each tasking that was active during reporting period.

1. Number and title of Task Order.

2. Government initiator.

3. Contractor point of contact.

4. Date tasking was initiated.

5. Date of TIP submission.

6. Date of TIP approval.

7. Synopsis of Task/Deliverables.

8. Date of closure/projected completion.

9. Current Activities and Accomplishments.

10. Problems encountered and action taken. Identification and explanation of significant costs and schedule variances on a cumulative and projected at completion basis.

11. Actions requiring a government response or action. When there are actions requiring Government a response the "Task Order Status Report" and information in the transmittal message shall be sent to the Task Order initiator and the COR. Why is this sent? The Gov. gets the monthly anyway?

12. Projected progress.

c. Provide the following information in real time via the Contractor provided System.

1. Resources Scheduling and Tracking. Provide a list of Government Property that is available, scheduled or being used to support testing. Also, provide the average total cost (repair parts + labor to maintain that equipment). Property that is not available for use, i.e., loaned, in maintenance etc shall be noted on this list. This list shall be treated as a living document reflecting what property and instrumentation is being used to support tests. The filters shall be placed to view:

(a) Instrumentation

(b) Communication equipment

(c) Technology, Computer Software, Computer Hardware, Simulations, Stimulations, and other technical systems The list shall reflect the following information:

(1) Nomenclature

(2) Mode

(3) Quantity on the GP list plus items returned to the Government to support loans

(4) Quantity in maintenance

(5) Total quantity available for test support

OMB NO. 0704-0188

2. Not Used

3. Purchasing

(a) Purchases. Provide the information listed below for all purchases requiring government approval that were initiated or active during the month of record.

(1) Identification number of the purchase.

(2) Class of Supply

(3) When the purchase was initiated.

(4) When the purchase was approved by the government.

(5) Cost

(6) Current status of the purchase.

(b) List the number of purchase actions, the number of line items and cost for each category below:

(1) Large purchase (<$25k)

(2) Medium purchase ($1K - $25K)

(3) Small purchase (<$1k)

(4) Totals

(c) List the dollar amount of purchase for each category below:

(1) Large business

(2) Small business

(3) Total purchase

(4) Small disadvantaged business (SDB)

(5) Small women-owned business (SWOB)

(6) Hub zone

(7) Veteran-owned small business (VOSB)

(8) Service-disabled veteran-owned small business

(9) Other small business

(10) Total small business purchase

(d) List the dollar amount of purchase for each category below:

(1) Non-competitive purchases

(2) Competitive purchases

(3) Categories

a. Software

b. Supplies

c. Services

d. Equipment

(e) List the dollar amount of cost saving monthly and calendar year to date:

(1) Negotiated monthly

(2) Extraordinary monthly

(3) Total (monthly and calendar year to date)

(f) List procurements from Government sources by Task Order number, month, and CY totals for committed funds to procure items from GSA, MILSTRIP, and HAZMART.

(g) List procurement from government sources for fuel by month by FY (Jan-Sep; Oct-Dec) and CY total. List gallons used and fuel cost. Subtotal fiscal year procurements.

(h) List mileage for all vehicles to include leased by month and maintain a cumulative total.

4. Property Administration.

(a) Property Book Transactions. List by quarters, by month, the dollar amount and quantity of receipts, turn-ins, and shipments. Show cumulative totals.

(b) Property List. List in separate tables the following information for these property book transactions: Receipts, OFF-contracts (calibration, warranty repair, or other repair of equipment), Off-station for test support (GP on hand receipt in support in support of a test), Off-station Loan) (based on government TIL; sent to other contractors as directed by KO-, Turned in:

(1) Part #

(2) Description

(3) Unit

(4) Class of Supply

(5) Total price

(6) Action code

(7) Total quantity

(c) Property Losses. List by month individual loss, damage and destruction reports (LDDR's). List DTN#, LDDR#, Part#, Nomenclature, Quantity, Cost of Loss Property Accountability Action Taken, and Remarks.

(d) The current government property list shall be made available to the Government.

5. Maintenance.

(a) GP Maintenance Actions. Report the condition (awaiting technical inspection, in repair, repaired, awaiting parts, in service, awaiting service) of all equipment returned from tests or loans. Report instrumentation separately:

(1) Task Order #

(2) Work order #

(3) Task description

(4) Not Used

(5) Start date

(6) End date

(7) Labor hours

(8) Labor cost

(9) Parts cost

(10) Status code

(11) Not Used

(b) Report and maintenance work orders in three categories: > 30 days and < 90 days, > 90 days and < 18 0 days , >

180 days. List:

(1) Task Order #

(2) Work order #

(3) Task description

(4) Not Used

(5) Start date

(6) End date

(7) # days old

(8) Labor hours

(9) Labor cost

(10) Parts cost

(11) Status code

(12) Not Used

(c) Quantity Control Report. Provide the following information for the month:

(1) List monthly and CY cumulative receiving inspection, showing lots inspected, lots accepted, lots rejected, and lots accepted with minor discrepancies.

(2) List monthly and CY cumulative drawing reviews, showing number reviewed, number approved, and number rejected and corrected.

(3) Not Used

(4) List Base logistics sampling results, showing department, nomenclature sampled, lot pass/fail results, sample quantity, and reliability rates (monthly and cumulative).

(5) Not used

(d) Safety Report Provide the following information for the month:

(1) Discuss safety related training completed during the month.

(2) Discuss fire, safety, and HAZMAT inspections conducted

(3) Not used

(4) Provide synopsis of injuries occurring during the month

(5) Provide synopsis of vehicle accidents occurring during the month

(6) List total lost days for the month caused by injury or accident

(e) Travel Report. List all travel performed during the month in the following format:

(1) Task Order#

(2) Name of traveler

(3) Job title of traveler

(4) Purpose of travel

(5) Final destination

(6) Start date

(7) End date

(8) Estimate cost

10.3 FINANCIAL. This section provides the Government with the status of funds expended by the contractor for the previous month and the cumulative total for the fiscal year. The monthly financial sections shall match the monthly invoices. The following reports shall be submitted:

(a) Summary of Costs by CLIN. Provide the monthly actual and estimated costs by CLIN for each month.

Provided subtotals by fiscal years (Jan-Sep Oct-Dec) and total calendar year.

(1) Category. The categories are labor (direct labor, overtime, premium overtime) and reimbursable by CLIN.

(2) Actual Cost (Act). The total dollars committed each month subtotaled by fiscal years (Jan-Sep and Oct-Dec) and totaled by calendar year.

(3) Estimated Costs (Est.). The estimated expenditures each month subtotaled by fiscal years (Jan-Sep and Oct-Dec) and totaled by calendar year. Estimated shall be updated not less than quarterly.

(b) Summary of Actual and Estimated Costs by Task Order. Provided the monthly actual and estimated cost by Task Order for each month. The Base Task Order shall be divided into Logistics and Instrumentation categories. Provided subtotals by fiscal years (Jan-Sep and Oct-Dec) and total by calendar year.

(1) Category for labor, list direct labor, overtime labor, and premium overtime labor by Task Order and CLIN. Subtotal each category and total each column.

(2) Actual cost (Act). The total dollars committed each month subtotaled by fiscal years (Jan-Sep and Oct-Dec) and totaled by calendar year.

(3) Estimated Cost (Est.). The estimated expenditure each month subtotaled by fiscal years (Jan-Sep and Oct-Dec) and totaled by calendar year. Estimates shall be updated not less than quarterly.

(c) Summary of Costs by CLIN. Provide a cost by CLIN for each Task Order. Provide cost by final years (Jan-Sep and

Oct-Dec) and total by calendar year.

(1) Category. For labor, list direct labor, overtime labor, and premium overtime labor by CLIN for each Task Order. Subtotal each category and total each column. For reimbursable, show cost for items >$5K, items <$5K, travel, and reimbursable subtotal.

(2) Actual Cost (Act). The total dollars committed each month subtotaled by fiscal years (Jan-Sep and Oct-Dec) and totaled by calendar year.

(3) Estimated Costs (Est.). The estimated expenditure each month subtotal by fiscal years (Jan-Sep and Oct-Dec) and totaled by calendar year. Estimated shall be updated not less than quarterly.

(d) Labor Allocation by Task Order. Reports hours expended during the month for each TAR. Provided summary cost by labor category for the month

(1) Labor Code. List all labor codes that have worked on Task Order efforts.

(2) Position Title. List all job titles for personnel supporting the Task Order.

(3) Hours. Provide the actual and estimated hours worked for each Task Order for each job category.

(4) Cost. Provide the actual and estimated labor dollars for each Task Order for each job category.

(e) Commitments by Task Order. Report commitments purchased during the month subtotaled for each Task Order.

(1) Task Order#

(2) Purchase order (PO)#

(3) Date of purchase.

(4) Item description.

(5) Cost.

10.4 STAFFING.

(a) Provide the following information for all personnel currently of contract:

(1) Labor code

(2) Position title

(3) Name

(4) Hire date

(5) Loaded hourly rate

(b) Provided the following information for all personnel hired during the month:

(1) Labor code

(2) Position title

(3) Name

(4) Hire date

(5) Loaded hourly rate

(c) Provided the following information for all personnel terminated during the month:

(1) Labor code

(2) Position title

(3) Name

(4) Termination date

(5) Reason for termination

(d) Provided the following information for all personnel changing position during the month.

(1) Old labor code/new labor code

(2) Old position title/new position title

(3) Name

(4) Changing date

DD Form 1664, APR 89 Previous editions are obsolete DD Form 1664, APR 89 Previous editions are obsolete