Integrated Logistics System - Inventory and Maintenance Management

1. Integrated Logistics System- Inventory and MaintenanceManagement Prepared by Antonio Jenkins-Lara Jenkins-Lara Consulting Houston, Texas “Only those who will risk going too far can possibly find out how far one can go.” T.S. Elliot 2002

2. Table of Contents • Executive Summary 3 • Who is JLC? 4 • What is SILC-im? 5 • How can JLC help you? 6 • SILC-im Functionalities 7 • Service Offering – Logistics 9 • Service Offering – Information Technology 10 • Satisfied Customers 11 • SILC-im Sample Screens 12 • JLC Management 24 • Conclusion 25

3. Executive Summary The war against terrorism and drug trafficking requires, among other things, reliable equipment resulting from a professional preventive maintenance program. Jenkins-Lara Consulting (JLC) has leveraged the expertise of a recent acquisition to develop the first integrated logistics application in Spanish based on proven US Army logistics doctrine –Sistema Integrado de Logística Computarizada –inventario y mantenimiento (SILC-im). This tool may be used in public, private or military organizations, and will allow senior management or donor agencies to monitor the care given to the donated equipment. SILC-im is an effective tool in accomplishing the Department of Defense mission in Latin America and in helping SOUTHCOM raise the level of professionalism throughout its area of responsibility; all while improving the readiness of these armed forces and increasing their level of property accountability. This application and the subsequent support meet the stated requirements for funding under the Foreign Military Sales (FMS), Foreign Military Financing (FMF), and Foreign Aid Programs.

4. Who is JLC? • JLC is a veteran-owned small business that has successfully executed contracts in finance, logistics, training, and software development. • JLC has successfully executed multi-year contracts with private and military clients in Latin America. • JLC has a fully deployable and multifunctional bilingual staff with experience performing in challenging environments overseas. • JLC developed the first logistics application, in Spanish, based on proven US military logistics doctrine –inventory and maintenance. Some of these functionalities will be included in the $100 million US Army’s GCSS-A.

5. What is SILC-im? • SILC-im is the first logistics application written in Spanish based on US military logistics doctrine. • SILC-im was developed with the “appropriate technology” in mind, the technology available in developing nations. • SILC-im is a logistics application that considers the maintenance and supply needs of all types of organizations –government entities, non-governmental organizations, corporations, and the armed forces. • SILC-im runs in an MS Windows environment, and the Internet version is under development. • SILC-im operates in a network environment. • SILC-im accepts national stock numbers and manufacturer part numbers. • SILC-im files may be exported to any RDBMS. • SILC-im is designed with remote technical support capabilities. • SILC-im is Y2K compliant.

6. How can JLC help you? • JLC will grant the needed user licenses to enhance the entity’s operations using SILC-im. • JLC will install and configure the SILC-im, and customize it as needed. • JLC will provide 24/7 system support in Spanish, and will travel on-site whenever the problem may not be fixed through remote technical support. • JLC will provide, load and configure all software upgrades. • JLC can integrate the existing hardware or provide new hardware under a turnkey agreement. • JLC may assist the foreign Armed Forces in issues dealing with training related to USAID or USSOUTHCOM. • JLC can provide the needed on-site operators. • JLC can provide initial, train-the-trainer, and refresher training in Spanish. • JLC can design, build, configure, and maintain the LAN/WAN/MAN. • JLC can translate the user interface into any language, to include Pashto! • JLC may create and provide donors’ reports.

7. SILC-im Functionalities • User Management: • SILC-im allows an unlimited number of users to be added. • Security Management: • the system administrator can control access to the system, selected functions, and datafields. • Catalog Management: • SILC-im allows the users to import, create and update a catalog of equipment and repair parts. • Asset Management: • SILC-im allows the users to add, modify and delete end items or systems with their respective subsystems and components, each one with a separate administrative number, but linked to each other for readiness. • Operator Management: • SILC-im allows the users to add, modify, and delete the driving records of the operators with information on restrictions.

8. SILC-im Functionalities (Cont.) • Inventory Management: • SILC-im allows the users to add the information of the suppliers, as well as inventory information with warehouse location and stockage level data. • Maintenance Management: • SILC-im allows the users to add, modify, and delete deferred maintenance faults with the corresponding corrective action; manage the preventive maintenance service schedule for each piece of equipment; and dispatch the equipment to authorized operators. • Readiness Management: • SILC-im allows the users to keep track of the availability of the different equipment considering the system relationship. • Report Management: • SILC-im allows the users or the donor agency to obtain predefined reports, or to create customized reports from historical data.

9. Service Offering – Logistics • STAMIS Support: Functional and system support for SARSS 1/2, 2AC/B, CTASC, SAMS 1/2, ULLS-G/A/S4, ILAP, SPBS-R, SILC. • Training: Bilingual classroom/field, initial or refresher training in Project Management, Project Finance, Logistics Doctrine (Inventory and Maintenance Management), SARSS, SAMS, ULLS, and SILC. • LOG Support:GOCO; BASOPS; motor pool & warehouse management; safety and readiness record keeping; MAIT-type visits; warehousing, packing & crating; property accountability; freight forwarding; Wireless/Fiber/Copper Networks; Wireless Local Loop(WLL), International VPN, Global Fiber Circuit Provisioning & Management; Forward Operating Location (FOL) support overseas. • Development: Applications development; legacy systems translation and integration; ad hoc reporting capabilities.

10. Service Offering – Information Technology* • Platforms: Windows 2000, Windows NT, UNIX, LINUX, Sun Solaris, IBM Mainframe and OpenVMS • Languages:C, C++, Visual C++, Java, Visual Basic (VB), SQL, .Net, Pascal, JavaScript, VBScript, Active Server Pages (ASP), Dynamic SQL, and Fortran. • GUI:VB, HTML, CSS, DHTML, X-Windows, and Motif. • Databases: Oracle RDBMS, Oracle Rdb, Informix, Sybase, DB2, MS Access, MS SQL Server, and DB2. • Middleware/SOAP, XML, CORBA, TCP/IP, DCE, ODBC, JDBC, DDE, Protocols: Java Beans, COM/DCOM, and Web Services. • ERP: SAP, PeopleSoft, Oracle Financials/HR, and JD Edwards. • System Analysis/ Network Diagnosis, Firewalls, and Hardware and Software Integration: Integration. *Services offered by a strategic partner, but supervised and under the responsibility of JLC.

11. List of Satisfied Customers • US Army South – Office of the Deputy Chief of Staff for Logistics (ODCSLOG) • US Army South – Directorate of Planning Training and Mobilization (DPTM) • US National Guard Bureau – Theater Equipment and Maintenance Site (TEAMS) • US Army South GSA – General Services Administration • US Army Southern Command – Joint Task Force Bravo (Honduras) • Pacific Architects and Engineers • Global Associates • Repuestos Samsung • Enron Caribbean Basin • Enron Broadband Services • Reliant Resources Incorporated • Shell Oil (Panama)

12. SILC-im Entry Screen This screen shows the official licensee and the user license number granted by JLC.

13. Consolidated Unit Data Screen This screen shows the information of the units, systems, subsystems, operators, and supervisors added.

14. Unit Data Menu These options allow the users to add, modify, and delete a unit and its basic data.

15. Equipment Data Menu These options allow the users to add, modify, and delete data dealing with the systems and subsystems, to include scheduled services, fuel management, and deferred deficiencies.

16. Maintenance Faults & Scheduled Services • Allows users to add new • deferred maintenance • deficiencies. • Allows users to view and select the • scheduled service by opening a work • order to annotate the deficiencies.

17. Work Order Option This option allows the users to create a work order linked to a previously added deficiency.

18. Work Order Menu These options allow the users to update, cancel, and print work orders, as well as to link and issue required repair parts to fix the identified maintenance deficiencies.

19. Equipment Dispatch & Operator Record • Allows users to dispatch • equipment to authorized and • licensed operators. • Allows users to manage the • operators’ personal data, • restrictions, and the equipment • they are qualified to operate, • and then print a license.

20. Suppliers & Parts Request • Allows users to add the suppliers’ • information. • Allows users to request a repair • part for stockage, or to repair a • maintenance fault.

21. Repair Parts Menu These options allow the users to maintain a repair part record, update the information in the catalog, and obtain historical information, to include safety stockage level.

22. Repair Parts Options • Allows users to add • catalog data that will be • used to request the part. • Allows users to obtain historical • data dealing with the demand for • that repair part and purpose of the • requests.

23. Tools & Reports Management These options allow the users to access the utilities menu and the pre-designed reports.

24. JLC Management Antonio Jenkins-Lara is the Founder and Senior Consultant at JLC. Mr. Jenkins- Lara holds a Master degree in Finance with post-graduate studies in Economics, and has taught at the college level in American and Panamanian universities. He was a logistics specialist for the US Army in Europe and an automated logistics instructor at the US Army Logistics School. As a Senior Logistics Analyst, professor Jenkins-Lara traveled to remote sites throughout Latin America to train logisticians and to provide logistics and telecommunications support to military exercises. From 1996 to 1999, Innovative Logistics (INNOLOG), the firm led by Mr. Jenkins-Lara, managed four different logistics systems at what used to be the largest equipment maintenance and supply facility in Latin America, TEAMS. INNOLOG also held the US Army South's contract for logistics training, officer leadership, property accountability, and small arms, among others. He has written extensively in financial areas and has served as a financial and Technology consultant, as well as a telecommunications and e-commerce business developer throughout the Caribbean region. Antonio also developed critical functions associated with the logistics of provisioning fiber optic capacity in a bandwidth trading environment for Houston-based energy companies. Feel free to visit our website at http://www.jenkins-lara.com, or contact Antonio at (281) 208-3706 or at antonio@jenkins-lara.com.

25. Conclusion Jenkins-Lara Consulting and its staff are ready, willing and able to share American logistics know-how with Latin American governments and Armed Forces. JLC staff members are bilingual and fully deployable. Whenever required, JLC will use its resources to translate SILC-im user interface into any language. JLC will also draw from its network of experienced systems and logistics personnel for deployment in regions other than Latin America. JLC will gladly negotiate the terms of a fielding, training, and system support contract with the Department of State (civilian), the Department of Defense (military), USAID (local foreign governments), or with a major government contractor.