Accounting System

Contents

• Scope
• Motivation & Benefits
• Schedule
• Team
• Budget
• Status

Scope

• Payroll (Personnel Accounts) Entry'er
  • sss, salary distribution, statements, and many other reports
• General Accounts Editor, Entry'er
• Red Book (Consolidated Statements)
• Inventory

Motivations & Benefits

• we have grown above the capabilities of the current system
• an integrated centralized database system will lessen the currently (redundant) encoding requirements
• payroll has changes that need to be added to the system. a system that can easily accomodate future changes is needed.
• consolidated statements (the whole red book) should be mostly automatic
• statements should have bar graphs and pie charts
• system should be able to generate any statement (general account) in 2 minutes
• personnel should be able to see their statements from AOLIS Information Kiosk, WAP, and SMS

Schedule

6 months. June 2004 - December 2004

Team

• Winelfed G. Pasamba
• Marc Henry S. Galang
• Glenson Carlo Galupo
• Aldwin Tapeceria
• LJ Arne Carpena
• with consultation from Ma'am Romelda M. Rodelas (chief accountant), Mr. Mervyn Allan N. Olarte (Treasurer), Mr. Robert A. Borromeo (VP Finance), Mr. Ruben T. Carpizo (MBA), Mr. Ivar Nelson E. Bingcang (MSIT), and Mr. Danilo C. Bosito (ITC).

The engineering team is composed of some of the best computer science students, led by one of the original AOLIS developers, and backed by people who will directly benefit from the system.

Budget

98k

Status

• database design and foundation, 90% working, 50% was working since 1st sem 2000 (aolis foundations)
• ~5 printable reports at 90% finished (final test and touches needed)
• payroll, 30%
• consolidated statements, 5% (prolonged analysis has resulted in a simpler and easier software design)
• dynamic graphs and barcharts, 35%

We are currently in the lightest activity but are analyzing and incubating the project in our minds.