3.4 Appendix B - Attachment 4 - SO Tracker-20210628.xlsx

XLSX spreadsheet 22 KB Posted

Attached to
Sources Sought - CEHNC FUELS PROGRAM
Solicitation number
PANHES-25-P-0000-001794
Issued by

About this file

This is a service order tracking spreadsheet (Appendix B - Attachment 4) used to monitor maintenance and repair work orders. The tracker contains multiple tabs for different types of service orders including Not-to-Exceed (NTE) orders, Regular Service Orders (RSO), and currently open service orders. The spreadsheet tracks key metrics such as initiation days (18-day target), DLA approval days (5-day target), execution days (30-day target), and total days (75-day target). It includes fields for contractor information, service order numbers, maintenance categories, values, status updates, scheduled dates, and completion tracking.

The tracker appears to be associated with a fuel program recurring maintenance and minor repair contract administered by the U.S. Army Corps of Engineers Engineering Support Center in Huntsville. Sample entries show service orders for troubleshooting work valued at $12,000, with various status updates tracking parts identification and sourcing activities. The spreadsheet serves primarily as a program management tool rather than containing specific requirements or solicitation information.

View the file

Other files

File Type Posted
Sources Sought FUELS - Programmatic Rev1 7 May 25.docx DOCX document
6.0 - Appendix E ISR 15-Bulk_Fuel_Facilities FY25.xlsx XLSX spreadsheet
2.0 Appendix A RM_SO Process_20241220_PgM Reviewed Incorporated.docx DOCX document
3.1 Appendix B - Attachment 1 - Three Week Look Ahead_20230420.xlsx XLSX spreadsheet
3.2 Appendix B - Attachment 2 - Monthly Report Format 20240910.docx DOCX document
2.2 Appendix A - Attachment 2 Contractor Travel Expense Report_20240910.xlsx XLSX spreadsheet
9.0 Appendix H - Minor Repairs Incidental to Maintenance Activities POJ 20231009.xlsx XLSX spreadsheet
7.0 CUID - v2.1.pdf PDF
8.0 Appendix G_UFC 3-460-03 Maintenance Table- v4.3.pdf PDF
6.0 Appendix E ISR 14_operational_fuel_facilities FY25.xlsx XLSX spreadsheet
3.0 Appendix B Reporting Requirements_20240910.docx DOCX document
4.0 Appendix C Task Order Specifications_202401216.docx DOCX document
5.0 Appendix D Antiterrorism and OPSEC 20230206.docx DOCX document
PWS LEX FMP Template - v2.2.xlsx XLSX spreadsheet
PWS VNC FMP Template - v2.2.xlsx XLSX spreadsheet
PWS KEQ FMP Template - v2.2.xlsx XLSX spreadsheet
PWS CVZ FMP Template - v2.2.xlsx XLSX spreadsheet
PWS SHP FMP Template - v2.2.xlsx XLSX spreadsheet
PWS PBA FMP Template - v2.2.xlsx XLSX spreadsheet
PWS GRB FMP Template - v2.2.xlsx XLSX spreadsheet
PWS BRO FMP Template - v2.2.xlsx XLSX spreadsheet
PWS BAR FMP Template - v2.2.xlsx XLSX spreadsheet
PWS EFS FMP Template - v2.2.xlsx XLSX spreadsheet
PWS LAU FMP Template - v2.2.xlsx XLSX spreadsheet
PWS CHF FMP Template - v2.2.xlsx XLSX spreadsheet
PWS BEU FMP Template - v2.2.xlsx XLSX spreadsheet
PWS GDF FMP Template - v2.2.xlsx XLSX spreadsheet
PWS BLI FMP Template - v2.2.xlsx XLSX spreadsheet
PWS TKR FMP Template - v2.2.xlsx XLSX spreadsheet
PWS RBN FMP Template - v2.2.xlsx XLSX spreadsheet
PWS MAA FMP Template - v2.2.xlsx XLSX spreadsheet
PWS FSH FMP Template - v2.2.xlsx XLSX spreadsheet
PWS FSO FMP Template - v2.2.xlsx XLSX spreadsheet
PWS LRG FMP Template - v2.2.xlsx XLSX spreadsheet
PWS RRT FMP Template - v2.2.xlsx XLSX spreadsheet
PWS ALT FMP Template - v2.2.xlsx XLSX spreadsheet
PWS TUL FMP Template - v2.2.xlsx XLSX spreadsheet
PWS BL2 FMP Template - v2.2.xlsx XLSX spreadsheet
PWS ELL FMP Template - v2.2.xlsx XLSX spreadsheet
PWS WRF FMP Template - v2.2.xlsx XLSX spreadsheet
PWS LLD FMP Template - v2.2.xlsx XLSX spreadsheet
PWS DYE FMP Template - v2.2.xlsx XLSX spreadsheet
12.0 PWS Appendix K Real Property Data_20230420.xlsx XLSX spreadsheet
PWS RAN FMP Template - v2.2.xlsx XLSX spreadsheet
PWS FSM FMP Template - v2.2.xlsx XLSX spreadsheet
PWS _Fuels RMMR 20241220.docx DOCX document
Show all 46

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

Color Split Branch Phase Contractor SO Number MaintCategory Value SO Type Status QAE Initiated SO Date Received Initiation Days (18) DLA Received DLA Approved HNC Days (22) DLA Days (5) > $10K Review Days (22/27) OFC Days (KTR) NTPDate NTP + 30 Days Expected_Submission Scheduled_Start_Date Scheduled Completion Date # Days scheduled from NTP Date Completed Execution Days (30) Total Days (75) ContractNumber Initiation Duration over 18 Metric Duration from NTP Metric Duration From Scheduled Date

POH XXXX-XXXX Not Invoiced Branch Phase Contractor SONumber MaintCategory Actual Cost SOType Status SOCompletionDate Days_Since_Completion InvoiceDate InvoiceAmt Invoice_Number Contractor Comments

POH XXXX-XXXX NTE-ESO Tracker

BranchPhaseContractorSO NumberMaintenance CategoryValueSO TypeStatusApproved DateDays Since ApprovalScheduled_Start_DateScheduled Completion Date# Days scheduled from ApprovalDate CompletedDate SO ReceivedDays to SO ReceiptContractor Comments
Air ForcePOHKTR NamXXX-KTR-152NTroubleshoot$12,000.00NTENTE05-Feb-201415-Jan-2024-Feb-20142/3/2020 ; Parts indentified NTE increase pending; 1/21/2020 ; Parts being sourced;

POH XXXX-XXXX RSO-LL

Currently Open Service Orders
BranchPhaseContractorSO NumberMaintCategoryValueSO TypeStatusFMSR InitiatedSO Date ReceivedInitiation Days (18)
DoD_Admin: Initiation Days Metric is 18 dayDLA ReceivedDLA ApprovedHNC Days (22)
DoD_Admin: HNC Days Metric is 22 daysDLA Days (5) > $10KReview Days (22/27)OFC Days (KTR)NTPDateNTP + 30 DaysExpected_SubmissionScheduled_Start_DateScheduled Completion Date# Days scheduled from NTPDate CompletedExecution Days (30)

DoD_Admin: Execution days for service orders that are not completed are calculated using Todays Date.

DoD_Admin: Initiation Days Metric is 18 day DoD_Admin: HNC Days Metric is 22 days Total Days (75) ContractNumber Contractor Comments

&"Times New Roman,Bold"&14APPENDIX B - ATTACHMENT 4 SERVICE ORDER TRACKER

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