Attachment 4 - ILMS Workload Metrics.xlsx

XLSX spreadsheet 105 KB Posted

Attached to
Integrated Logistics Management System (ILMS) Federal contract opportunity
Solicitation number
19AQMM21R0135
Issued by
Department of State Office of Acquisition Management

About this file

This draft request for proposal (RFP) solicits proposals for the Integrated Logistics Management System (ILMS) contract, an indefinite delivery/indefinite quantity contract with a single award to provide enterprise supply chain management services and technologies to the Department of State. Key details include: the Department intends to issue RFP 19AQMM21R0135 for ILMS, which supports requisition, procurement, warehousing, transportation, receipt, and tracking of goods and services domestically and overseas, as well as federal assistance, fleet management, diplomatic pouch and mail services, and service management. The contract has a base period of one year with nine one-year options, and utilizes firm fixed price, time and materials, and other contract types as needed. The NAICS code is 541511 with a $30 million size standard. Proposals will be evaluated using best value tradeoff, and offerors must hold or be able to obtain a TOP SECRET facility clearance. Industry questions are due by July 20, 2021 and the pre-solicitation event is scheduled for August 2, 2021, with RFP release anticipated in September 2021.

View the file

Other files for this federal contract opportunity

Other files attached to Integrated Logistics Management System (ILMS), newest first.
File Type Posted
21R0135 Questions and Answers- Round 2.pdf PDF
Interested Parties List update 2022 03.pdf PDF
Interested Parties List update 2022 02 25.pdf PDF
PreSolicitation Event Slides 2022 02 23.pdf PDF
19AQMM21R0135 Notice 2022 02 03.pdf PDF
Interested Parties List.pdf PDF
Contractor Questions and Answers -- Set 1.xlsx XLSX spreadsheet
Attachment 3B PMARS to Citibank Integration.pdf PDF
Attachment 3C myGrants Invoice Submission Portal Integration Documentation.docx DOCX document
Attachment 3G Trans TLite_Integration Diagram.pptx PPTX presentation
Attachment 3K Trans TLite_Integration Documentation.docx DOCX document
Attachment C - Factor 2 LCAT Mix (Template).xlsx XLSX spreadsheet
Attachment D - Factor 6 Past Performance Questionnaire (Template).docx DOCX document
Attachment I - Factor 7 Pricing for IDIQ and TO1 (Template).xlsx XLSX spreadsheet
Attachment 1 IDIQ Rate Schedule Worksheet.xlsx XLSX spreadsheet
Attachment 2 - ILMS Systems (Module Inventory).xlsx XLSX spreadsheet
Task Order 001 Operations and Maintenance Draft.docx DOCX document
Attachment 3A ILMS Integration Diagram.pdf PDF
Attachment 3F RSOTools_IntegrationDiagram.pdf PDF
Attachment 3L Ariba Integration Schematic Diagram.pdf PDF
Attachment J - TO1 ILMS Key Position Qualifications.xlsx XLSX spreadsheet
Attachment 3J PMARS_PMARS to Citibank Integration.docx DOCX document
Attachment E - Past Performance References.docx DOCX document
Attachment F - Factor 8 Small Business Participation Commitment (Template).xlsx XLSX spreadsheet
19AQMM21R0135 Solicitation B-M Draft.docx DOCX document
Attachment 5 - DOS Value Engineering Policy.docx DOCX document
Attachment 6 - ILMS Labor Category Descriptions.docx DOCX document
TO 1 Attachment 1 - Incentives_Matrix.xlsx XLSX spreadsheet
Attachment 3D DPM_Integration Diagram.pdf PDF
Attachment 3E Grants_Integration Diagram.pdf PDF
Attachment 3H myServices and eCC_Integration Documentation.docx DOCX document
Attachment 3I myServices Integration Diagram.pdf PDF
Attachment A-Mandatory Minimum Requirements (Template).xlsx XLSX spreadsheet
Attachment B - Factor 1 Corporate Capabilities and Experience (Template).xlsx XLSX spreadsheet
Attachment G - Factor 9 Joint Venture Signature Page.docx DOCX document
Show all 35

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

Tab 1 (Customer Support)

Number of Tier 0 incidents per monthPercentage breakdown of incidents by type (Tier 1 and 2 Combined)
MonthJan-19Feb-19Mar-19Apr-19May-19Jun-19Jul-19Aug-19Sep-19Oct-19Nov-19Dec-19Jan-20Feb-20Mar-20Apr-20May-20Jun-20Jul-20Aug-20Sep-20Oct-20Nov-20Dec-20CY2019CY2020
Total Tier 0399383381617585426531531465419316531543370306269521522958307636314070355828362965Process Question (General)45865.2%ILMS Password Reset - GO User49475.2%
Error Message Ariba45135.1%Domestic - User Access - Login Issues41264.4%
Number of Tier 1 incidents per monthSystem Issue44245.0%User Permissions - Update40224.3%
Total Tier 1 INC274526383248375934873215378339614409353432513502502146163836457831823907450354936152481040334340User Account Management37794.2%System Issue38364.1%
Approval Flow - Temporary Update37044.2%Error Message Ariba37884.0%
Number of Tier 2 incidents per monthExisting User - Account Unlock34883.9%Vendor Request Form37754.0%
Total Tier 2 INC165921432643264425392639328237714122279028892461240227542473143815921895236431134071206322092227Domestic - User Access - Login Issues33733.8%User Account Management33143.5%
Additional Tier 2 contacts (including user access requests & S-ILMS mailbox)1225143915781896128416111741220227401709170618271452183116926385981024159815002020223915951927User Account and Logon31403.5%Existing User - Single sign on (SSO) upd32003.4%
Total Tier 2 volume288435824221454038234250502359736862449945954288385445854165207621902919396246136091430238044154Assignment Change27563.1%Approval Flow - Temporary Update31333.3%
Number of total contacts per monthPercentage breakdown of incidents by type (Tier 1 and 2 Combined)
Contacts8254925699311129710160990211598128241521610473106471051114835126151026211206894412097134201625018947149721219813088
Error Message Financial – RFMS23772.7%User Login24992.6%
Average number of incidents by hour for a 24 hour period - October to May (2019 & 2020) (Tier 1 and 2 Combined)Access Request Form - How to Complete/Su20812.3%Assignment Change20682.2%
Hour01234567891011121314151617181920212223Existing User - Single sign on (SSO) upd20442.3%Access Request Form - How to Complete/Su17921.9%
Average256340381389351340398472543547492401344350336274167927486103121134185User Access/Configuration19562.2%User Account Management - myServices Gen16431.7%
Approval Flow - Permanent Update15841.8%User Access/Configuration15961.7%
Average number of incidents by hour for a 24 hour period - June & July (2019 & 2020) (Tier 1 and 2 Combined)Access Request Form - Expedite / Status Request14771.7%Access Request Form - Expedite / Status Request15771.7%
Hour01234567891011121314151617181920212223FPDS - Task Bypass12191.4%User Account and Logon15561.6%
Average2263233934253833684235055785965414323583683513021971107485105117133157Existing User - Profile Update (Name, Em12081.4%Error Message Financial – RFMS15301.6%
Access Request Form - Approval Issues11341.3%Existing User - Profile Update (Name, Em11491.2%
Average number of incidents by hour for a 24 hour period - August & September (2019 & 2020) (Tier 1 and 2 Combined)Scanner Questions/Issues10581.2%Existing User - Password Reset10921.2%
Hour01234567891011121314151617181920212223Assignment Change - How to Submit10241.2%FPDS - Task Bypass10041.1%
Average326473563605528507576694779745695546481475463380252159102121165191196227Reports/Searches9071.0%Approval Flow - Permanent Update10021.1%
Account Deactivation9001.0%Error Message9041.0%
pCards - Add/Update8621.0%Existing User – Password Reset8710.9%
Unlock User Account8330.9%Reports/Searches8510.9%
Modifications - Current Year7900.9%Assignment Change - How to Submit7550.8%
User Profile7740.9%Overseas - Awards & Post-Award Tasks - A7370.8%
Overseas - Awards & Post-Award Tasks - A7730.9%Access Request Form - Approval Issues7210.8%
Error Message7440.8%Account Deactivation6630.7%
DS-127 Report6280.7%Domestic - Funding Opportunities and App6480.7%
Access Request Form - ILMS Referral5060.6%New User – Account Creation6400.7%
Domestic - Funding Opportunities and App4940.6%pCards - Add/Update5390.6%
Domestic - Ariba - Awards4820.5%Scanner Questions/Issues5380.6%
Catalogs - FSSI Waiver Request4740.5%Existing User – Account Unlock4650.5%
Enhancement Request3960.4%Overseas - FIT - Oblig/Commit Error4590.5%
Domestic - Grantee User Access - Login I3950.4%Password Reset4410.5%
Domestic - Configuration - User Account3870.4%Domestic - Ariba - Awards4380.5%
Error Message Financial – GFMS3700.4%User Profile4330.5%
Domestic - General Information & Policy3680.4%Domestic - Configuration - User Account4260.5%
Domestic - Post Award Activities - Servi3510.4%Domestic - Grantee User Access - Login I4250.4%
Vendor Errors/Questions3460.4%Domestic - General Information & Policy4220.4%
Annual Inventory Questions/Issues3440.4%Unlock User Account4150.4%
Domestic - Awards3430.4%User Access/Configuration - Asset Manage3930.4%
PCCR Task Issue3310.4%Process Question (General) - Asset Manag3860.4%
Workflow Process3200.4%Domestic - Awards3810.4%
Domestic - User Access - Single Sign On3070.3%Itinerary3540.4%
Password Reset3050.3%Access Request Form - ILMS Referral3530.4%
Configuration Change3020.3%DS-127 Report3380.4%
Receiving Services2990.3%Vendor Errors/Questions3360.4%
User Access/Configuration - Asset Manage2970.3%Domestic - Post Award Activities - Servi3270.3%
Award Error2920.3%Annual Inventory Questions/Issues3260.3%
Audit Request2900.3%Award Error3250.3%
Overseas - FIT - Oblig/Commit Error2820.3%Audit Request2630.3%
Process Question (General) - Asset Manag2820.3%pCards - Process Questions2620.3%
Domestic - FIT - Oblig/Commit Error2550.3%User Access/Configuration - Asset_Manage2570.3%
pCards - Process Questions2520.3%Slow Performance2440.3%
Existing User - Password Reset2470.3%Configuration Change2440.3%
FPDS - Task Errors2470.3%PCCR Task Issue2310.2%
Overseas - Configuration - User Account2440.3%Enhancement Request2280.2%
Overseas - General Information & Policy2400.3%Process Question (General) - Final Recei2280.2%
Scanner Software Installation2390.3%Error Message Financial – GFMS2210.2%
Print Issue2110.2%Overseas - Configuration - User Account2100.2%
Service Request Access2100.2%Configuration Workflow - myServices Gene1940.2%
Blanket Purchase Agreements (BPAs)2090.2%Domestic - FIT - Oblig/Commit Error1800.2%
Status of Request2050.2%Domestic - RPM and PFF1760.2%
Slow Performance2000.2%Domestic - User Access - Single Sign On1750.2%
Add Signature1990.2%Receiving Services1740.2%
Domestic - User Access - Access Request Form1950.2%Self Service Portal Assistance1620.2%
Integration Issue1870.2%User Access/Configuration - Final Receip1620.2%
User Access/Configuration - Analytics an1830.2%FPDS - Task Errors1610.2%
Email Notifications1830.2%Overseas - User Access - Login Issues1590.2%
Process Question (General) - Final Recei1810.2%Fiscal Data1530.2%
User Access/Configuration - Final Receip1780.2%Overseas - Closeout1530.2%
Pouch Status/Missing Pouch1710.2%Overseas - Configuration - Post/Office1530.2%
Fiscal Data1610.2%Navigation1500.2%
Overseas - Closeout1560.2%Overseas - General Information & Policy1470.2%
Overseas - System Issue1430.2%Add Signature1380.1%
New User – Account Creation1350.2%New User - Account Creation1380.1%
Domestic - System Issue1340.2%User Access/Configuration - Loanable Pro1370.1%
Location Request Form1330.1%User Account Management - mySrvcs Gen1310.1%
Access to Reports1300.1%Modification1300.1%
Overseas - Configuration - Post/Office1290.1%Process Question (General) - Loanable Pr1290.1%
Overseas - User Access - Login Issues1270.1%IT Service Center Referral - Config/Setu1280.1%
Domestic - Vendor Questions1250.1%Domestic - User Access - Access Request Form1260.1%
Itinerary1230.1%Integration Issue1240.1%
Missing or Unlocatable Order - Final Rec1200.1%Missing or Unlocatable Order - Final Rec1230.1%
Transportation Lite1200.1%Email Notifications1220.1%
Asset Disposal1180.1%User Access/Configuration - Analytics an1200.1%
Existing User – Password Reset1170.1%Print Issue1180.1%
Catalogs - Admininstrative (General Ques1110.1%Domestic - System Issue1160.1%
Approval Process1110.1%pCards - Transaction Limit Change1110.1%
User Account - New1060.1%Transportation Lite1090.1%
Overseas - User Access - Access Request Form1010.1%Blanket Purchase Agreements (BPAs)1090.1%
Self Service Portal Assistance1000.1%Service Request Access1040.1%
Location/Office Code - Add930.1%User Access/Configuration - Transportati1010.1%
Access Request Form900.1%Location Request Form1000.1%
Existing User – Account Unlock900.1%Pouch Status/Missing Pouch990.1%
Overseas - Vendor Questions890.1%Documents Tab970.1%
User Access/Configuration - Loanable Pro870.1%User Access/Configuration - Motor Vehicl970.1%
Domestic - Grantee User - System Navigat870.1%Access Request Form960.1%
Process Question (General) - Motor Vehic870.1%Approval Process950.1%
Process Question (General) - Loanable Pr860.1%Process Question (General) - Ariba Contr910.1%
pCards - Reporting840.1%Overseas - Payment Portal900.1%
Location/Office Code - Update820.1%Domestic - FIT - Other890.1%
Domestic - FIT - Other810.1%Scanner Software Installation880.1%
Domestic - ServiceNow - Funding Package800.1%Process Question (General) - Transportat880.1%
Navigation800.1%Domestic - Grantee User - System Navigat870.1%
Process Question (General) - Ariba Contr760.1%Process Question (General) - Motor Vehic870.1%
Listserv (Add/Update/Remove)760.1%Overseas - Vendor Questions870.1%
Attachment/Document Issue750.1%Overseas - User Access - Access Request Form840.1%
Adding Assets730.1%Overseas - System Issue830.1%
Security710.1%Domestic - FIT - SAD (GFMS/PMS)810.1%
User Access/Configuration - Transportati680.1%Workflow Process790.1%
Domestic - Integration - Grants.gov - Se660.1%Domestic - Configuration - Bureau/Office780.1%
User Account - Update640.1%COR780.1%
Move to Ordered Status630.1%Service Provider / Post Admin - mySrvcs750.1%
User Access/Configuration - Motor Vehicl630.1%Domestic - Vendor Questions740.1%
Add/Update Locations630.1%Process Question (General) - Status Trac720.1%
Accuracy620.1%Domestic - ServiceNow - Funding Package710.1%
Managing Requests620.1%ILMS Knowledge Center690.1%
Domestic - Configuration - Bureau/Office610.1%FMIS - Maintenance Page650.1%
Asset Transfers610.1%User Access/Configuration - Medical Expe620.1%
Referral - IRM/MRA580.1%Domestic - Integration - Grants.gov - Se620.1%
DEAV570.1%Catalogs - Admininstrative (General Ques600.1%
Vendor eForm - Add560.1%Listserv (Add/Update/Remove)600.1%
User Access/Configuration - Medical Expe520.1%Asset Disposal590.1%
New User - Account Creation520.1%Reporting590.1%
Process Question (General) - Medical Exp520.1%User Account - New580.1%
FMIS - Fuel Page510.1%Process Question (General) - Asset_Manag570.1%
Documents Tab510.1%Process Question (General) - Analytics a570.1%
Missing or Unlocatable Order - Status Tr510.1%Status of Request560.1%
Domestic - Training480.1%User Account - Update550.1%
Process Question (General) - Status Trac480.1%Domestic - Training540.1%
Overseas - Post Award Tasks470.1%Overseas - Awards & Post-Award Tasks - S540.1%
Process Question (General) - Transportat470.1%Traveler Profile Creation/Management510.1%
Catalogs - MSR - ELP/HELP/SELP470.1%pCards - Reporting500.1%
Domestic - FIT - SAD (GFMS/PMS)460.1%User Access/Configuration - Status Track470.0%
Process Question (General) - Analytics a460.1%Location/Office Code - Update470.0%
Modifications - Prior Year460.1%Modifications - Current Year470.0%
Add Agency450.1%Domestic - Email Notifications470.0%
ILMS Knowledge Center450.1%Location/Office Code - Add470.0%
Catalog - Item Missing440.0%Purchase Card Reconciliation - eInvoicin460.0%
Procurement Invoice430.0%User Access/Configuration - Loanable Mob460.0%
Lost Customer Request410.0%Access to Reports450.0%
Approval Flow - System Admin410.0%Process Question (General) - Medical Exp450.0%
Domestic - SAMS Award File/Status Tracking410.0%Move to Ordered Status440.0%
Domestic - FIT - Vendor410.0%FMIS - Fuel Page440.0%
Overseas - Awards & Post-Award Tasks - S390.0%Referral - IRM/MRA430.0%
Domestic - RPM and PFF390.0%Missing or Unlocatable Order - Status Tr410.0%
Approval Issues380.0%NDAA410.0%
Approval Flow - Update POC List370.0%Add/Update Locations400.0%
Domestic - Analytics - Data/General Ques370.0%New Account Request400.0%
Catalogs - Expendables Stock370.0%Itinerary Creation390.0%
Single Sign On Setup (SSO)360.0%Asset Transfers390.0%
FMIS - Dispatch Page350.0%Catalog - Item Missing380.0%
MV Worksheet Issue350.0%Domestic - Closeout Checklist - ServiceN370.0%
FMIS - Vehicles Page350.0%Domestic - SAMS Award File/Status Tracking360.0%
Process Question (General) - Ariba S-ILM350.0%Domestic - Analytics - Data/General Ques350.0%
(Pilot) Referral - Mobility Team340.0%DEAV350.0%
COR340.0%Data File Load350.0%
Official Visits Issue340.0%Domestic - FIT - Vendor340.0%
SPEAR320.0%FMIS - Vehicles Page330.0%
New Account Request320.0%Approval Flow - Update POC List320.0%
FMIS - Maintenance Page320.0%Attachment/Document Issue320.0%
Unable to Publish310.0%Domestic - FIT - Error Correct320.0%
IT Service Center Referral - Config/Setu310.0%Approval Flow - System Admin310.0%
Purchase Card Reconciliation - eInvoicin310.0%Adding Assets290.0%
Missing or Unlocatable Asset - Asset Man310.0%Missing or Unlocatable Asset - Asset Man290.0%
Surcharges300.0%Process Question (General) - Config/Setu280.0%
(Pilot) Referral - eCC Team280.0%Traveler Profile280.0%
Vendor - Add280.0%Vendor - Add270.0%
Analytics Portal - Report Subscriptions270.0%Add Agency260.0%
Domestic - Email Notifications270.0%Voucher Issue260.0%
Overseas - Payment Portal260.0%FMIS - Dispatch Page250.0%
Trip Requests260.0%MV Worksheet Issue240.0%
Overseas - Integration260.0%Single Sign On Setup (SSO)240.0%
Process Question (General) - Config/Setu250.0%Overseas - Post Award Tasks230.0%
User Access/Configuration - Loanable Mob250.0%Referral - Training Team230.0%
Annual Review250.0%Accuracy230.0%
Domestic - Enhancement Request250.0%Trip Requests230.0%
Domestic - Grantee User Access - Account230.0%SPEAR230.0%
Vendor eForm - Update230.0%Catalogs - Expendables Stock220.0%
Data File Load230.0%Unable to Publish210.0%
Funding Template230.0%Procurement Invoice210.0%
Submitting a Request220.0%Surcharges210.0%
Domestic - Closeout Checklist - ServiceN220.0%Annual Review200.0%
Overseas - Searches210.0%Material Stock Requests (MSR)190.0%
Domestic - FIT - Error Correct210.0%Multi-Factor Authentication Issues190.0%
Analytics Portal - Fleet200.0%Analytics Portal - Report Subscriptions190.0%
Add New Vehicle Type200.0%Managing Requests190.0%
User Access/Configuration - Status Track200.0%Checklist190.0%
Domestic - Analytics - New Report200.0%CMMS190.0%
Currency Issues200.0%DVAR Issue180.0%
Route Changes200.0%Funding Template180.0%
Material Stock Requests (MSR)190.0%Referral - Mobility Team - Asset_Managem170.0%
Disposal Issue180.0%Generating Documents170.0%
Domestic - Searches170.0%Process Question (General) - Ariba S-ILM170.0%
Referral - Training Team170.0%Analytics Portal - Fleet170.0%
Overseas - Analytics - Data/General Ques170.0%Overseas - Searches160.0%
Modification160.0%Currency Issues160.0%
Analytics Portal - Procure-to-Pay160.0%Access/Missing Links160.0%
Survey160.0%Disposal Issue160.0%
Access/Missing Links160.0%Domestic - Enhancement Request160.0%
Domestic - FIT - Payment160.0%(Pilot) Referral - Mobility Team150.0%
Voucher Issue150.0%Missing Order150.0%
Referral - eFiling Policy/Compliance150.0%Catalogs - MSR - ELP/HELP/SELP150.0%
Missing Order150.0%Analytics Portal - Procure-to-Pay150.0%
Generating Documents140.0%Official Visits Issue140.0%
Assignment Change - Expedite / Status Request140.0%Multiple Order Invoice Submission Page120.0%
Traveler Profile130.0%Overseas - User Access - Single Sign On120.0%
Analytics Portal - Expendables130.0%Referral - PM Desk Officer120.0%
Non-Procurement Invoice130.0%Domestic - FIT - Payment120.0%
Overseas - User Access - Single Sign On130.0%Modifications - Prior Year120.0%
Catalogs - FSSI120.0%Lost Customer Request120.0%
Access Request Form - SILMS Referral120.0%Domestic - Analytics - New Report110.0%
Multiple Order Invoice Submission Page110.0%Security110.0%
Analytics Portal - Property110.0%Non-Procurement Invoice110.0%
Shipment Updates110.0%Survey110.0%
PMM110.0%Overseas - Integration100.0%
Overseas - Analytics - Modify Report110.0%Itinerary Workflow100.0%
Contract eFiling100.0%Post Settings Configuration100.0%
Mobile100.0%Approval Issues100.0%
Overseas - Email Notifications100.0%Clauses - Add/Update100.0%
Invoices/Tags100.0%Analytics Portal - Property100.0%
Referral - CGFS100.0%Vendor Payment90.0%
CMMS100.0%Service Provider Portal Navigation90.0%
Online/Offline Receiving100.0%Overseas - Analytics - Data/General Ques90.0%
Shipping Documents100.0%Add New Vehicle Type80.0%
Referral - DPM Answer Person90.0%FMIS - Employees Page80.0%
Clauses - Add/Update80.0%Route Changes80.0%
Referral - Mobility Team80.0%Submitting a Request80.0%
No Active Approver80.0%Post Administration80.0%
Domestic - Analytics - Dashboard80.0%Picking & Delivery - Missing Item80.0%
Domestic - Analytics - Modify Report80.0%Overseas - Training70.0%
Post Administration80.0%Invoices/Tags70.0%
Catalogs - Furniture80.0%Contract eFiling70.0%
Order Management - Not Processing70.0%Online/Offline Receiving70.0%
WebILMS & Mobile Trip Request70.0%Modifications70.0%
Missing Line Items70.0%Order Management - Not Processing70.0%
Referral - Deployment Team70.0%Domestic - Searches70.0%
VAT60.0%Shipment Updates70.0%
Process Question (General) - Loanable Mo60.0%Shipping Documents70.0%
Overseas - Enhancement Request60.0%Mobile70.0%
Checklist60.0%PMM60.0%
Vendor Payment60.0%Overseas - FIT - Other60.0%
Item Missing60.0%Domestic - FIT - FADR60.0%
Overseas - Training50.0%Referral - CGFS60.0%
Administrative Setup50.0%Inspection Issue60.0%
User Access/Configuration - Medical Mobi50.0%Access Request Form - SILMS Referral50.0%
Overseas - Analytics - New Report50.0%Catalog - Missing Images50.0%
Overseas - Analytics - Dashboard50.0%Domestic - Configuration - User Proxy Ac50.0%
Printing50.0%Referral - Training Team - Asset Managem50.0%
Referral - Analytics Team50.0%Approvals / Notifications - Official Vis50.0%
User Access/Configuration - Asset_Manage50.0%Account Management50.0%
Dispatch Date50.0%Delete PE ID/TA40.0%
Personnel50.0%Process Question (General) - Loanable Mo40.0%
Catalog - Missing Images40.0%Domestic - Analytics - Modify Report40.0%
Replenishment40.0%Referral - Mobility Team40.0%
Analytics Portal - Shipping40.0%Item Missing40.0%
GFSS Referral40.0%Referral - OPE40.0%
SPE40.0%Referral - DPM Answer Person40.0%
Domestic - Configuration - User Proxy Ac40.0%Enhancement Request - Analytics and Repo40.0%
Referral - Training Team - Analytics and40.0%Referral - eFiling Policy/Compliance40.0%
Referral - OPE40.0%Domestic - Grantee User Access - Account40.0%
Vendor - Update40.0%Missing Line Items40.0%
Ariba – Item/Order Issue40.0%GFSS Referral30.0%
XenMobile40.0%VAT30.0%
Integration Issue - Attachments40.0%Administrative Setup30.0%
Domestic - Slow Performance40.0%SPE30.0%
Policy/Compliance Question40.0%New Users30.0%
New Users30.0%Overseas - Analytics - Dashboard30.0%
Referral - Training Team - Asset Managem30.0%Referral - AQMOPS30.0%
Enhancement Request - Analytics and Repo30.0%Overseas - Enhancement Request30.0%
Help & Support Page Questions - Portal S30.0%Referral - Fleet Support Team30.0%
Modifications30.0%Catalogs - FSSI Waiver Request30.0%
Updating an Article30.0%Referral - Fleet Support Team - Motor Ve30.0%
New Vendor Form Referral30.0%Ariba – Item/Order Issue30.0%
Referral - PM Desk Officer30.0%Domestic - Slow Performance30.0%
Adding a New Article30.0%Personnel30.0%
Inspection Issue30.0%Catalogs - Furniture30.0%
Duplicate PI IDs30.0%Slow Performance - Analytics and Reporti20.0%
Ariba – User Access/Config30.0%Order Forms20.0%
Overseas - Slow Performance30.0%Analytics Portal - Expendables20.0%
pCards - FPDS Integration30.0%Integration Issue - Attachments20.0%
Enhancement Request - Knowledge Manageme30.0%Printing20.0%
Missing Links30.0%User Access/Configuration - Medical Mobi20.0%
Recurring Obligation Document20.0%No Active Approver20.0%
Order Forms20.0%Inter-Unit Transfer20.0%
CRP Receipt Loader20.0%Vouchers20.0%
FMIS - Employees Page20.0%Missing Links20.0%
Deleting an Article20.0%Vehicle Management20.0%
Referral - Fleet Support Team20.0%Referral - Analytics Team20.0%
Referral - Training Team - Ariba Contrac20.0%Updating an Article20.0%
App - Driver20.0%Help & Support Page Questions - Portal S20.0%
Vouchers20.0%Ariba – User Access/Config20.0%
Enhancement Request - Medical Expendable20.0%New Requisition Process20.0%
App - Procurement20.0%Service Provider20.0%
Reports/Searches - Asset Management S-IL20.0%Catalogs - FSSI20.0%
Picking & Delivery - Missing Item20.0%Overseas - Analytics - New Report20.0%
Vendor Request Form - Expedite10.0%Adding a New Article10.0%
FMIS - Scheduler10.0%Analytics Portal - Shipping10.0%
FPDS Integration10.0%Referral - Deployment Team10.0%
Referral - Mobility Team - Expendables M10.0%Appointment Scheduling10.0%
Delete PE ID/TA10.0%Dispatch Date10.0%
New/Update Ariba Only Vendor10.0%Duplicate PI IDs10.0%
pCards10.0%CRP Receipt Loader10.0%
Referral - Mobility Team - Loanable Mobi10.0%Domestic - Analytics - Dashboard10.0%
DA Referral10.0%Referral - Training Team - Loanable Prop10.0%
Referral - Training Team - Medical Expen10.0%Catalogs - Drexel10.0%
Inter-Unit Transfer10.0%FPDS Integration10.0%
Referral - Training Team - Motor Vehicle10.0%Domestic - FIT - Novation10.0%
App - Loanable Property10.0%WebILMS & Mobile Trip Request10.0%
Referral - Voucher Team10.0%Reset Account10.0%
Vendor Request Form - How to Complete/Su10.0%Referral - Training Team - Ariba Contrac10.0%
Move Requisition10.0%FMIS - Scheduler10.0%
Picking & Delivery - Cancelled Item10.0%Enhancement Request - Knowledge Manageme10.0%
Location Request Form - Expedite / Status Request10.0%Room List / Room Build10.0%
Catalogs - Drexel10.0%Recurring Obligation Document10.0%
Referral - Fleet Support Team - Motor Ve10.0%Overseas - Email Notifications10.0%
Classified Pouch Dashboard10.0%Travel & Reports10.0%
Funding10.0%Picking & Delivery - Cancelled Item10.0%
Grand Total88928Referral - Training Team - Status Tracki10.0%
DA Referral10.0%
pCards - FPDS Integration10.0%
Overseas - Slow Performance10.0%
Replenishment10.0%
Policy/Compliance Question10.0%
Referral - Mobility Team - Loanable Mobi10.0%
Overseas - Analytics - Modify Report10.0%
Move Requisition10.0%
Grand Total94473100.0%

Tab 2 (Product Management)

Comments:
Incidents are escalated from CSD to Tier III functional support staff, who use extensive knowledge to prioritize and track low complexity issues. Medium and higher issues are assessed during weekly developer calls where initial requirements are analyzed by developers. Level of effort is validated by the functional team and any high or greater incidents are brought to client management for prioritization.
The technical infrastructure encompasses over 260 servers, 60 databases, and 10 environments (two environments are Production; 8 are lower environments).
In 2019, Release Management supported 46 releases.
In 2020, Release Management supported 53 releases. (This includes PS Upgrade as 1 release)
Complexity Descriptions:
Low – Low complexity incident that requires limited stakeholder involvement and can be addressed by the Tier III functional team via script, permission update or routine configuration change. Should not require formalized testing due to routine nature of the change. Does not require a release.
Medium – Medium complexity incident that can be resolved with a monthly or quarterly release. Involves less than 10 hours of total development time and a limited number of test scenarios.
High – Should be able to be fit in a typical quarterly release cycle. Typically involves between 10-80 hours of development and unit testing.
Very High – Complex project that will not be able to be accommodated in a normal release cycle. Likely involves multiple stakeholders that are needed to refine scope and formalize a project plan. Many of these requests are spun out into a separate project rather than being addressed by the production support team.
Current Backlog by Urgency (as of 1/15/2021)
UrgencyAribaCross Functional
Low1739
Medium4433
High7111
Total13283
Current Backlog by Complexity (as of 1/15/2021)
ComplexityAribaCross Functional
Low2642
Medium4325
High3716
Very High260
Total13283
Tier 3 Incidents by Month
MonthAribaCross-FunctionalTech ArcTotal
Jan-1943533947821
Feb-1937226098730
Mar-1932624261629
Apr-1920429261557
May-1921029635541
Jun-1912828161470
Jul-1914829648492
Aug-1916526652483
Sep-1920131261574
Oct-199328037410
Nov-1910418434322
Dec-1911021034354
Jan-206831047425
Feb-206327747387
Mar-207424855377
Apr-206115549265
May-206215556273
Jun-207317532280
Jul-205416624244
Aug-2010221060372
Sep-2010221149362
Oct-205724639342
Nov-205923835332
Dec-206721433314
Total33385863115510356

Tab 3 (Data Mgmt-Analytics)

ILMS maintains over 375 data dashboards for its customers and users. 1 data dashboard represents a single dashboard page containing relevent metrics and graphs. Active dashboards are published dashboards in use by customers/users. Planned dashboards are either backlogged or in development. Legacy dashboards are no longer in use by customers/users and are archived and available for use if required again.

TypeFunctional AreaProduct NameActive CountPlanned CountLegacy Count
Number of dashboards by functional area - 4949614
DashboardProperty121020
DashboardProperty1. Property Insights – Composition (3)3
DashboardProperty2. Property Insights – GSO Compliance (3)3
DashboardProperty3. Property Insights – Phase II (2)2
DashboardProperty4. INL Asset Summary (2)2
DashboardProperty5. INL Data Trends & Action Items (2)2
DashboardExpendables2200
DashboardExpendables1. Expendables Dashboard1
DashboardExpendables2. Medical Expendables Dashboard1
DashboardProcure-to-Pay6321
DashboardProcure-to-Pay1. eInvoicing Dashboard - Pending Action1
DashboardProcure-to-Pay2. eInvoicing Dashboard - Fully Processed1
DashboardProcure-to-Pay3. eInvoicing Dashboard - Workload Management1
DashboardProcure-to-Pay4. Procurement Insights – (2 planned)2
DashboardProcure-to-Pay5. Contracting Dashboard1
DashboardFleet212100
DashboardFleet1. FI – Composition (3) + NLG3
DashboardFleet2. FI – Acquisitions (3) + NLG3
DashboardFleet3. FI – Disposals (3) + NLG3
DashboardFleet4. FI – Cost (3) + NLG3
DashboardFleet5. FI – Utilization (3) + NLG3
DashboardFleet6. FI – Maintenance (3) + NLG3
DashboardFleet7. FI – Safety and Satisfaction (3) + NLG3
DashboardOPS/Shipping11
DashboardOPS/Shipping1. Shipping Dashboard1
DashboardSAMS11
DashboardSAMS1. Federal Assistance Dashboard1
DashboardPouch & Mail183213
DashboardPouch & Mail1. DPM Executive Summary1
DashboardPouch & Mail2. DPM Transit Analysis1
DashboardPouch & Mail3. DPM Post Health11
DashboardPouch & Mail4. DPO Transit (planned)1
DashboardPouch & Mail5. DPO Scorecard (planned)
DashboardPouch & Mail6. DPO Reporting: Post Progress Report1
DashboardPouch & Mail7. DPO Reporting: Prograde GBS Receptacles1
DashboardPouch & Mail8. DPO Reporting: Retrograde ILMS Receptacles1
DashboardPouch & Mail9. DPO Reporting: Prograde Cost and Weight1
DashboardPouch & Mail10. DPO Reporting: Retrograde Cost and Weight1
DashboardPouch & Mail11. DPO Reporting: Gateway to Overseas Transit Time1
DashboardPouch & Mail12. DPO Reporting: Prograde Extra Services Piece Count1
DashboardPouch & Mail13. DPM Dashboard Transit Time1
DashboardPouch & Mail14. DPM Dashboard Cost & Weight1
DashboardPouch & Mail15. DPM Dashboard Global1
DashboardPouch & Mail16. DPM Dashboard Post Report Card1
DashboardPouch & Mail17. DPM Dashboard Carrier Report Card1
DashboardPouch & Mail18. DPM Dashboard Class Performance1
DashboardDS8800
DashboardDS1. DSPS Splash Page1
DashboardDS2. DSPS - Average Performance Summary1
DashboardDS3. DSPS - Funding1
DashboardDS4. DSPS - Personnel1
DashboardDS5. DSPS - Risks1
DashboardDS6. DSPS - Issues and Challenges1
DashboardDS7. DSPS – Bureau Level Measures (FBS)1
DashboardDS8. MCESG WMS Dashboard1
Number of reports by functional area - 304270727
ReportsProperty757230
ReportsProperty1. Aging Assets in the Warehouse1
ReportsProperty2. Last Scan1
ReportsProperty3. FAP Asset Profile1
ReportsProperty4. Residential Asset Replacement Plan1
ReportsProperty5. Misclassified FAP1
ReportsProperty6. Standard Furnishing Profile1
ReportsProperty7. Domestic Property Management1
ReportsProperty8. Property Insights Drilldowns (58)58
ReportsProperty9. PM Book1
ReportsProperty10. DF – Cost Adjustments1
ReportsProperty11. DF – Disposals1
ReportsProperty12. DF – Scans1
ReportsProperty13. DF – Tags1
ReportsProperty14. DF – Locations1
ReportsProperty15. DF – Final Receipt1
ReportsProperty16. Hyper – DS132 Approval1
ReportsProperty17. Hyper – AIM (2)2
ReportsExpendables3300
ReportsExpendables1. Months of Supply1
ReportsExpendables2. Facilities Maintenance Inventory1
ReportsExpendables3. Health Unit Digest1
ReportsProcure-to-Pay191900
ReportsProcure-to-Pay1. Open PR Summary (+1 Drilldown)2
ReportsProcure-to-Pay2. Processed PR Summary (+2 Drilldowns)3
ReportsProcure-to-Pay3. Pending Procurement Receipts1
ReportsProcure-to-Pay4. Overseas Procurement Spend1
ReportsProcure-to-Pay5. Do Not Integrate (DNI)1
ReportsProcure-to-Pay6. NDAA1
ReportsProcure-to-Pay7. DF Procurement1
ReportsProcure-to-Pay8. Procurement IT Report1
ReportsProcure-to-Pay9. P2P - PCR Charges1
ReportsProcure-to-Pay10. P2P - FAP Ordered vs. Received1
ReportsProcure-to-Pay11. P2P - Generator Fuel Consumption1
ReportsProcure-to-Pay12. P2P - Post Process Efficiency1
ReportsProcure-to-Pay13. P2P - eFiling1
ReportsProcure-to-Pay14. eInvoicing Drilldowns (3)3
ReportsFleet1009640
ReportsFleet1. Vehicle Utilization1
ReportsFleet2. Fleet Efficiency Report1
ReportsFleet3. ICASS Motorpool Workload Count1
ReportsFleet4. VAM/MVS Compliance1
ReportsFleet5. Vehicle Acquisition Pipeline1
ReportsFleet6. MV Vehicle Request Report1
ReportsFleet7. Fleet Insights Drilldowns (90)90
ReportsFleet8. Hyper – MV Approvals (4)4
ReportsOps/Shipping5500
ReportsOps/Shipping1. Worldwide Frustrated Receipts1
ReportsOps/Shipping2. Transit Time for Personal Effects by Destination1
ReportsOps/Shipping3. Transit Time for Personal Effects by Geographic Bureau1
ReportsOps/Shipping4. Transit Time for Supplies by Destination1
ReportsOps/Shipping5. Transit Time for Supplies by Geographic Bureau1
ReportsSAMS212100
ReportsSAMS1. Award Level1
ReportsSAMS2. Award Level with Financials1
ReportsSAMS3. Award Level Grouped & Summarized1
ReportsSAMS4. Award Action Level1
ReportsSAMS5. Award Action Level with Financials1
ReportsSAMS6. Recipient Organization1
ReportsSAMS7. FY Awards by Office – OCR Tasker1
ReportsSAMS8. Awards to Country1
ReportsSAMS9. CFDA Report1
ReportsSAMS10. Closeout Report1
ReportsSAMS11. OCR Tasker by Office1
ReportsSAMS12. Solicitations Closing Report 2.01
ReportsSAMS13. Awards to Cities/States1
ReportsSAMS14. Awards with GO and GOR1
ReportsSAMS15. Closeout Action Amounts1
ReportsSAMS16. Grants List1
ReportsSAMS17. Proposals by solicitations1
ReportsSAMS18. Top Ten Funded Organizations1
ReportsSAMS19. Indicator Report1
ReportsSAMS20. Disaggregate Report1
ReportsSAMS21. Progress Report1
ReportsPouch & Mail270027
ReportsPouch & Mail1. Cargo Cost (Monthly)1
ReportsPouch & Mail2. Carrier Cost Avoidance (Monthly)1
ReportsPouch & Mail3. Cost per KG Shipped (Monthly)1
ReportsPouch & Mail4. Classified Pieces Shipped (Monthly)1
ReportsPouch & Mail5. Classified Pieces Received (Monthly)1
ReportsPouch & Mail6. Customer Satisfaction (Monthly)1
ReportsPouch & Mail7. Perfect Order Fulfillment (Monthly)1
ReportsPouch & Mail8. Monthly Pouches Received1
ReportsPouch & Mail9. Monthly Pouches Shipped1
ReportsPouch & Mail10. Total Weight Received (Monthly)1
ReportsPouch & Mail11. Total Weight Shipped(Monthly)1
ReportsPouch & Mail12. Unclassified Item Cycle Transit Time (Monthly)1
ReportsPouch & Mail13. Web Hits (Monthly)1
ReportsPouch & Mail14. Cargo Cost (Quarterly)1
ReportsPouch & Mail15. Carrier Cost Avoidance (Quarterly)1
ReportsPouch & Mail16. Cost per KG Shipped (Quarterly)1
ReportsPouch & Mail17. Classified Pieces Shipped (Quarterly)1
ReportsPouch & Mail18. Classified Pieces Received (Quarterly)1
ReportsPouch & Mail19. Customer Satisfaction (Quarterly)1
ReportsPouch & Mail20. Perfect Order Fulfillment (Quarterly)1
ReportsPouch & Mail21. Quarterly Pouches Received1
ReportsPouch & Mail22. Quarterly Pouches Shipped1
ReportsPouch & Mail23. Total Weight Received (Quarterly)1
ReportsPouch & Mail24. Total Weight Shipped (Quarterly)1
ReportsPouch & Mail25. Unclassified Item Cycle Transit Time (Quarterly)1
ReportsPouch & Mail26. Web Hits (Quarterly)1
ReportsPouch & Mail27. Carrier Performance (Quarterly)1
ReportsDS545400
ReportsDS1. DSPS Drilldowns from Dashboard (21)21
ReportsDS2. MCESG WMS Dashboard (+33 Drilldowns)33
Number of subscriptions by functional area - 242400
SubscriptionsProperty7700
SubscriptionsProperty1. Aging Assets in the Warehouse1
SubscriptionsProperty2. Last Scan1
SubscriptionsProperty3. Residential Asset Replacement Plan1
SubscriptionsProperty4. Misclassified FAP1
SubscriptionsProperty5. Property Digest1
SubscriptionsProperty6. Locations Not Scanned in 4 years1
SubscriptionsProperty7. Non-Office furniture moved to the OFF_FURNIT location1
SubscriptionsExpendables4400
SubscriptionsExpendables1. Expendables Digest1
SubscriptionsExpendables2. Maintenance and Repair Digest1
SubscriptionsExpendables3. Health Unit Digest1
SubscriptionsExpendables4. Months of Supply1
SubscriptionsProcure-to-Pay6600
SubscriptionsProcure-to-Pay1. Procurement Digest1
SubscriptionsProcure-to-Pay2. Open FPDS Tasks1
SubscriptionsProcure-to-Pay3. Open PR Summary1
SubscriptionsProcure-to-Pay4. Pending Procurement Receipts1
SubscriptionsProcure-to-Pay5. Overseas Procurement Spend1
SubscriptionsProcure-to-Pay6. Rejected PCard Transactions in the previous statement1
SubscriptionsFleet5500
SubscriptionsFleet1. Fleet Digest (3 Drilldowns)4
SubscriptionsFleet2. Fleet Efficiency Report1
SubscriptionsOps/Shipping1111
SubscriptionsOps/Shipping1. Shipping Digest1
SubscriptionsSAMS0000
SubscriptionsPouch & Mail0000
SubscriptionsDS0000
SubscriptionsManagement1100
SubscriptionsManagement1. Management Digest1

Tab 4 (Config-Release Mgmt)

ILMS System Migrations - 2019 - 2020
TeamEnvironmentCY19 MigrationsCY20 MigrationsNotes
AribaDEV200+160+Includes migration of developer sandboxes to shared Dev environment
AribaTST155123
AribaSTG155123Includes both “Connected STG” and “Standalone STG”
AribaTRN6549
AribaPRD6549
myGrantsTST5 major5 major
28 ASAP28 ASAP
myGrantsTRN5 major5 major
28 ASAP28 ASAP
myGrantsPRD5 major5 major
28 ASAP28 ASAP
PeoplesoftDEV9572,057Baseline environment where development begins
PeoplesoftTST9572,057
PeoplesoftSTG500800Approximate based on average migrations to STG per CR
PeoplesoftTRN246382
PeoplesoftPRD246382
.NET PortalDEV1530Baseline environment where development begins
.NET PortalTST1530Approximate
.NET PortalSTG1020Approximate
.NET PortalTRN714
.NET PortalPRD714
MyServicesTest9 major10 major
40 O&M21 O&M
MyservicesInnovate9 major10 major
40 O&M21 O&M
MyServicesTrain9 major10 major
40 O&M21 O&M
MyServicesProduction9 major10 major
40 O&M21 O&M
PMARSDEV1041042/week
PMARSSTG3030
PMARSTRN441 per release
PMARSPRD44
AnalyticsTST300360Estimated, includes MSTR and Hana per package
AnalyticsSTG500500Estimated, includes MSTR and Hana per package
AnalyticsTRN00No Analytics Training Instance, plan to set up later in CY21
AnalyticsPRD75115Estimated, includes MSTR and Hana per package. Includes subscription scripts and external data loads such as SHEM, myServices, FAP, DSPS
MobileDEV200400See below
MobileTST200400See below
MobileSTG200400See below
MobilePRD2424See below

image1.png

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