WALCABA CORPORATION

1
WALCABA CORPORATION

• Creating The Path For Technological Things To Come

2
Systems Development Team

• Eric Boyd
• Keith E. Cole II
• Tanyell Berry
• Lawrence Parker

3
Project Background

• Project was requested in January 2003 by Manager
  Edward Z. Cash of the Credit Department
• A request for a new system that needed immediate
  attention

4
Team Objective

• To investigate the possible computerization of
  the workload of the Credit Department and its
  possible cost effectiveness

5
SCOPE

• System Boundaries
• Access limited to only Mr. Edward Cash and Mr.
  Doug Bradstreet
• Interfaces with Accounts Receivable and Order
  Entry departments

6
Approach

• Conducted three Interviews with Mr. Edward Z.
  Cash
• Conferences with Accounts Receivable and Order
  Entry Departments
• Researched for hardware and software components
  for implementation of the new system

7
Present System Description

• OUTPUTS
• New Credit Statements
• Credit Changes
• Monthly Reports
• Credit Memos

8
Present System Description, Cont.

• INPUTS
• New Customer Requests
• Financial Statements Trade and Bank References
• Request of Credit Increase
• Credit History from Accounts Receivable
• PROCESSING REQUIREMENTS
• Establishing / Adjusting Credit
• Generate Letters to External Entities
• Create Memos to Internal Entities

9
Present System Description, Cont.

• CONTROLS
• Files are located in the File Cabinet and locked
  overnight

10
Present Context Diagram
11
Present Diagram Zero
12
Proposed System Description

• OUTPUTS
• Credit Limits to Customers
• Order Entry Retrieves Data
• Credit Change
• INPUTS
• Request New/Adjusted Credit
• Faxed References Statements
• Credit History from Accounts Receivable

13
Proposed Systems Description(cont.)

• Processing Requirements
• Order Entry Communication
• Accounts Receivable Communication
• Financial Statements/References
• Controls
• Access to Database Limited
• Edward Z. Cash, Doug Bradstreet
• Order Entry(Read-only mode)

14
Proposed System Description(cont.)

• New Requirements
• Network and Server Capability
• Database Implementation
• Order Entry Data Retrieval Allowed
• Faxed References
• Email System
• Website for Customer Access

15
Proposed Context Diagram
16
Proposed Diagram Zero
17
Implementation Plan

• For Successful Project Completion
• Database (Access) Design Network
• Encourage electronic data exchange (faxes,
  emails, etc.) between outside factors (customer,
  references, etc.)
• Allow Order Entry to access database
• Efficient Feasibility
• Operational Feasibility
• Technical Feasibility
• Economical Feasibility

18
Operational Feasibility

• High-speed credit processing
• Overcome communication barriers
• Accelerated credit establishments improves
  company credibility
• Any previous schedules are no longer issues

19
Technical Feasibility

• Inexpensive and easy to access resources
• Little training may be needed
• Will improve overall department performance
• Easy processing and data tracking
• An increase in credit establishments
  (monthly/weekly, etc.)

20
Economic Feasibility

• Resources low in cost
• Hardware
• Server
• Two client computers
• Printers
• Network Cards, Network cable systems
• Necessary Software
• Network Configuration
• Training

21
Economic Feasibility (cont.)

• Tangible Benefits
• Reduces Overtime
• Database which reduces the need for paperwork
• Intangible Benefits
• A new Web site that enhances companys image
• A user-friendly system that improves employee
  satisfaction
• Improves overall communication expectations
• Database security
• More Efficient Organization

22
System Costs Alternatives
23
Payback Period

• The current system workload consist of 2-4
  customers per week and 6-10 credit changes per
  week.
• The new system will increase the workload and
  reduce the time to approve credit.
• The new system will take 2-5 business days to
  approve credit, compared to 5-20 business days.
• This new system will definitely support the
  expected 10 increase in sales with an estimated
  2 year payback period.

24
Recommendation(Alternative One)

• Closely meets the departments goals in every
  possible aspect
• Lower overall cost
• Small Payback Period
• Faster data processing
• In addition, we recommend that each department
  have an email system, and have Internet access.

25
ANY QUESTIONS?
WALCABA INC. Bringing the world closer
together!!!