1 / 29

Proposed Solution for Karnak Supply Company

Proposed Solution for Karnak Supply Company. ProTek Presenters: Jim Clarke Jim Hildenbrand Ryan Schussler Rick Wise. Will Clark Teresa Costante Natalie Gendelman Steve Hark Shawn Johnson. Antony Kravchuk Nikesh Patel Paul Philips Dave Weber. Fellow Team Members. Agenda.

meredith-horne
Download Presentation

Proposed Solution for Karnak Supply Company

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Proposed Solution forKarnak Supply Company ProTek Presenters: Jim Clarke Jim Hildenbrand Ryan Schussler Rick Wise

  2. Will Clark Teresa Costante Natalie Gendelman Steve Hark Shawn Johnson Antony Kravchuk Nikesh Patel Paul Philips Dave Weber Fellow Team Members

  3. Agenda • Introduction • Problem Overview • Project Description • Business Process Reengineering • Solution Details • Prototype Demonstration • Lessons Learned • Question and Answer Session

  4. Introduction • Karnak Supply Company (KSC) presently operates as an inventory based warehouse located in a major northeastern city. • KSC lost its facilities due to eminent domain. • Liquidation of company assets.

  5. Problem Overview • Decided to move to a electronic order entry system. • This includes the creation of a new enterprise resource system: • Earn government funding by employing at least 50% handicapped persons as customer service agents. • Develop relationships with both suppliers and customers to increase profitability.

  6. Project Description • Develop Electronic Order Processing System Prototype • Customer Relations Management • Enterprise Resource Planning • System Solution Documentation • Functional and Technical Overview • System Capabilities • Security Considerations • Cost Overview

  7. Business Process Reengineering • Limitations with existing concept of operations • Reengineer the existing business process • Reduce limitations of existing business process • Standard Reseller Distribution Operation • More effective and efficient operating environment

  8. Existing Concept of Operations

  9. Proposed Concept of Operations

  10. Business Process Reengineering: Proposed Solution Concept of Operation Breakdown:

  11. Business Process Reengineering: Quotation Process

  12. Business Process Reengineering: Order Processing Breakdown

  13. Business Process Reengineering: Billing Process Breakdown

  14. Business Justification for Proposed Solution • Preliminary Solution Package identified as BS/1 and Paradox Integrated. • Encountered Difficulties • Poor interface design • Integration problems • Poor customer service • Flat-file data storage

  15. Business Justification for Proposed Solution (continued) • Major integration issues • Purchase Order and Accounts Payable Modules • No reference between purchase order and bill • Risk of human error during Data re-entry • Difficult referencing a particular bill to original purchase order

  16. Solution Details • The system will utilize Commercial Off The Shelf Software (COTS) called Compiere • Open Source ERP Software with integrated CRM Solutions • Compiere provides a comprehensive solution for small-to-medium sized enterprises in distribution and service on a global basis and covers: • Supply Chain Management • Customer Management • Accounting Modules

  17. Solution DetailsFunctional Overview • Source: http://compiere.org/functionality/qtc.html

  18. Solution DetailsRequisition-to-Pay Source: http://compiere.org/functionality/rtp.html

  19. Solution DetailsCost Analysis

  20. Solution DetailsCost Analysis

  21. Technical Overview • Compiere Specifications • Server Specifications • Client Requirements • Remote Access • Security Considerations

  22. Technical OverviewCompiere Specifications • Open Source Solution • Customizable Modules • Built Using Java Technologies • Oracle 10g Database • Broader Database Support in Future • Compiere Support Solutions Available

  23. Technical OverviewServer Specifications • Dell PowerEdge 2800 Server • Microsoft Windows 2003 Server Standard • Includes Oracle 10g SE1 Database with 10 CALs • MailEnable Standard e-mail Server Software • Java Development Kit (JDK)

  24. Technical OverviewClient Requirements • Windows 2000/XP Recommended; Windows 98/ME and NT4 at a Minimum • Java Runtime Environment (JRE) • Compiere Client Application • High-speed Internet Connection with Firewall Router

  25. Technical OverviewRemote Access • VPN connectivity • L2TP/IPSec Protocol

  26. Technical OverviewSecurity Specifications • L2TP/IPSec • EAP-TLS Certificate and/or Smart Card Authentication • IPSec 168-bit Triple DES (3DES) Encryption • Remote Access and Corporate Network Policies • Logging • Routers with Built in Firewalls and Intrusion Detection

  27. Prototype Demonstration

  28. Lessons Learned • Customer Relations • Project Management • Time Management • Overcoming obstacles • Systems Analysis Procedures • Software Evaluation and Testing

  29. Questions

More Related