Introduction

1

47CHAPTER IINTRODUCTION

Technology plays vital role in innovation. Over the years we have seen technology to evolve like a child burgeons into adulthood. Without technology, life would be more difficult than it already is. We are now living in a world which is technologically civilized, where almost all human activities involve the use of technology and every person wants to be recognized with a device or gadget which is technically advanced.

Nowadays, computer serves an important part when it comes to basic day to day processes conducted in our community. It allows a user to accomplish tasks or things and it also enables the user to create a more accurate and reliable output.

Information system has two categories which is manually or Computer Based Information System (CBIS). Before CBIS, data were done manually. This manual process is called non-computerized system. Meaning all the information were written and stored in cabinet files. Non-computerized is not efficient because searching for a certain information is time consuming and it is confusing. To eliminate this problem, a system is created known as Computerized System or CBIS. Computer Based Information System (CBIS) is efficient because users will just have to input data which the CBIS will process and kept in storage such as a database.

Manual system is a system that involves data processing which does not make use of database system or stored program computing equipment. As of now, The H.O Abalos Builders Inc. uses a traditional manual system. The head of the human resource department said the Corporation still uses first generation manual system in recording data and salary computation with the use of tools such as pens, pencils and papers to record important documents to be stored in a filing cabinet.

The proposed system will be using Barcode based technology Barcode technology works of off a principle called symbology. Symbology at its basic form is what defines the barcode; it determines the mapping and interpretation of the encoded information or data. This encoding allows the scanning device to know when a digit or character starts and when it stops, similar to a binary representation. We recognize barcodes as an array of parallel lines alternating between white and black lines. Barcode technology provides a simple and inexpensive method of recording data or information in a number of applications.Barcode is an optical machine readable representation of data relating to the object to which it is attached. Originally barcodes systematically represented data by varying the widths and spacings of parallel lines, it may be referred to as a linear or one-dimensional (1D)

By using Barcode technology the management will benefit from the following:1. Time Savers Think back to the ways of doing inventory. The task involved a lot of manpower and number-crunching, not to mention the fact that it was tedious with a nice margin for making mistakes. Enter the barcode and barcode scanners. Now with the fraction of manpower and the scan of a barcode, inventory is a breeze. Instead of having to physically log everything in by hand, the barcode contains all the information. All that is needed is a simple scan of a barcode and that information is translated into a computer.2. Increased Efficiency Human beings are not infallible, so therefore, mistakes can be made when recording information and tracking other items like inventory and expenses.

3. Smoother Internal Operations There are always a system of checks and balances for every business to ensure that rules is followed both internally and externally with various governing bodies. For instance, a Business must account for every asset to the IRS. Companies can spend hundreds of man hours every year or use bar codes on their assets to keep track of them. In addition, when internal operations run more smoothly, then their way of conducting business with customers runs smoothly too.4. Barcode promotes better decision making Because data is obtained rapidly and accurately, it is possible to make more informed decision. Better decision ultimately saves both time and money.

Local area connection (LAN) concept is a computer network that interconnects computers in a limited area such as home, school, one site to another, computer laboratory and office building using network media.

The proposed system was conducted to change the existing manual procedures to computerized system to make more accurate results and perform repetitive tasks quickly, efficiently and without complaints, ease of access andstoring files in a database where it is more secure. The computerized system will increase the productivity and reduce the human errors, thus improve their performance and lessen the time consumed.

Background of the Study

H.O. ABALOS BUILDERS INC. , formerly known as Jolar Engineering & Industrial Sales was established July 1996 by its founder and owner, Engr. Hilario O. Abalos, however, only became operational a year after its registration as trading company. Due to the on-going demand on technical and clientele services, the owner has diversified its services from trading company to specialty contractor of Electro Mechanical works, structural and architectural steel fabrication and eventually to construct and maintenance of industrial, commercial building and warehouses.

The expansion of the company was introduced in the early part of the year 2000 with the principal forming and additionally group to sustain the on-going demand on technical services. A new group that will practically meet the needs of the clients from pre- planning phase, design phase up to construction phase. A new concept also that will basically become an advantage to the owner in terms of coordination and decision making not yet to mention economical aspects. Projects undertaken were listed herein since the company formally started its services and up to now, making its way although stiff competition continually arises. Now that H.O. ABALOS BUILDERS INC. has expanded its services, a new goal has been set to serve bigger clients but still uses a manual procedure such as keeping attendance of the employees in a logbook which collusion may happen, storing files in a filing cabinet which is prone from tampering and unorganized files and manual computation of each employees` salary where miscalculation may happen.

Mission and Vision

Vision

H.O. ABALOS BUILDERS INC shall be known as one of the principal building construction contractor specializing in (MEPS) Mechanical, Electrical, Plumbing, Sanitary, and Fire Protection and General Engineering services in the PhilippinesMission

We shall deliver quality workmanship and service to our clients to meet their technical requirement. We shall train and motivate personnel to achieve the highest standards of ethics and excellence. For our suppliers, we shall ensure mutual cooperation and commitment to achieve an environment of trust and confidence. We shall ensure good return of investment to our partner.We shall be good steward of God.

Organizational Chart

Hilario O. AbalosPres. & General Manager, PME

Human ResourcesAdministrativeFinanceArchitecture

M.A Noime PadayaoAdmin ManagerJocelyn AbalosFinance ManagerViolante LagadanProj. Manager, ArcArlyn R. AbalosH.R. Manager

Joseph ConstantinoProj. in charge, ArchMary Jane TabiosH.R. Associate

ConsultantEngineering

Ricardo MalabananStructural Civil ConsultantMyra PanganLegal ConsultantHilario Reblera Jr.Project Coordinator,MEEdmark BragaProject Coordinator, ECE

Figure 1.1

H.O Abalos Builders Inc.

Finance

Jocelyn AbalosFinance Manager

Figure 1.2Finance Department of H.O Abalos Builders Inc.

Human Resources

Arlyn R. AbalosH.R. Manager

Mary Jane TabiosH.R. Associate

Figure 1.3Human Resource Department of H.O Abalos Builders Inc.

Administrative

M.A Noime PadayaoAdmin Manager

Figure 1.4Administrative Department of H.O Abalos Builders Inc.

Architecture

Violante LagadanProject Manager, Arc

Joseph ConstantinoProject in-charge, Arch

Figure 1.5Architect Department of H.O Abalos Builders Inc.

Engineering

Hilario Reblera Jr.Project Coordinator,MEEdmark BragaProject Coordinator, ECE

Figure 1.6Engineering Department of H.O Abalos Builders Inc.

Consultant

Ricardo MalabananStructural Civil ConsultantMyra PanganLegal Consultant

Figure 1.7Consultant Department of H.O Abalos Builders Inc.

Statement of the problem

The general purpose of the study is to design, develop, evaluate and Implement the proposed system that will help the company in providing a more reliable and accessible way of recording and monitoring employees information in a secure and safe manner. The system will benefit the Human Resource department particularly in these following problems:

1. The existing system uses a logbook to record and monitor the employees attendance which is prone to data tampering.

2. The existing system uses a filing cabinet to store each employees records and credentials (file 201). Thus, files are unorganized and can be accessed by anybody.

3. The existing system computes the salary of each individual employee manually which is very time consuming and may cause incorrect computation of salary

4. The existing system cannot produce accurate and timely reports such as overtime, under time, cash advance and audit trail reports that may be needed by the employee for monitoring their own records

5. The existing system used a manual method in transferring files from one area to another. That may cause the loss of file rendering the data inaccurate

Objective of the Study

The primary objective of this study is to create a system which the human resource department integrates, utilize, enhance and organize all the transaction for the companies benefits. The second objective is to make more accurate, reliable and secure system that will store all information in a database

As such, the proponents would like to develop an automated system with the following goals in mind:.1. The proposed system will use an identification card with a unique barcode to monitor the employees attendance in which it would be the reference for the computation of the employees` salary2. The proposed system creates a database where all the files of human resource personnel and employees record are stored on a secure and manageable environment

3. The proposed system will automatically compute the salary of an employee. Through this method, the company will save more time creating an accurate computation of an employees` salary

4. To generate reports which will automatically be filtered the necessary and needed reports such as; overtime record, under-time record, cash advance, and audit trail reports by letting the user choose what kind of report that he/she needed to be print out.

5. To establish faster connections across the organization without hassle of copying files to the flash disk and transferring it to another user through the help of local area network connection. The system will create a network throughout the company which will ensure faster and safer transferring of information from one department to another.

Scope and Limitations

The H.O Abalos Builders Inc. has expand widely and aim their goal, but still uses manual procedure in activities such as keeping the attendance of the employees` in a logbook, computing the salary of each employees manually which uses a calculator and storing the files and records of the company in a filing cabinet.

The proponents would like to change the existing system from manual to automated procedure. It will enhance everything which will include a more accessible and organize way of monitoring an employees record and allow ease of access for all the employees with their data through the help of automated report, lessen the consumed time needed for processing data and transactions. This system will enable the records to be more accurate and would be stored in a database for security purposes.

The proposed system has this following procedures, the registration where the human resource personnel will register the records of the current employees and will provide a registration form for the new applicants, they must fill up the registration form questions such as last name, first name, middle name, age, birth-date, address and gender etc. the human resource personnel will then register it to the system. The system has two level of access which is the administrator and manager. The administrator can access the whole system, can manipulate or change data inside the database and monitors the employees record. The manager will be the one responsible to communicate with the employees in to enable them to monitor their respective records.The system will also use a barcode system in monitoring log-in in and out of an employee through the use of an I.D wherein a barcode is installed. The barcode will consist of a unique employee number, name, position or designation, address and contact person in case of emergency. There will be a time management program to the system which records the start time, end time, late, overtime in minutes, and under time which would be the basis for an accurate salary computation for each employee.The audit trail is the one that records everything from the time you log-in and by the time you log-out. The employees can request a copy of their respective attendance through the manager in case they have questions regarding their salary. The salary computation will be based from the time management system module and will also include deductions such as wages and taxes or bonuses such as incentives. There is a report where the system will display the daily, quarterly or yearly overall attendance of each specific user that would be generated by the manager. The system will compose of a main system and a backup to enable a secure and reliable data management process.The proposed system is only limited to monitoring, updating, administering an employees record only. The system will not include verifying an employees credential, unregistered change in location of an employee, payment method for employees and the correctness of the data encoded by the administrator.

CHAPTER IISYSTEM DESIGN

System Design is the process of defining the architecture, components modules, interfaces, and data for a system to satisfy specified requirements. System design could be seen as the application of the system theory to product development. There is some overlap with the discipline of system analysis, system architecture and system engineering.

The topic of product development blends the perspective of marketing, design and manufacturing into single approach to product development, then design is the act of taking the marketing information and creating the design of the product to be manufactured. System design is therefore the process of defining and developing systems to satisfy specified requirements of the user. Until 1990s system design had a crucial and respected role in the data processing industry. The 1990s standardization of hardware and software resulted in the ability to build modular systems. The increasing importance of software running on generic platforms has enhanced the discipline of software engineering.

Object-oriented analysis and design methods are becoming the most widely use methods for computer system design. It is the widely used for modeling software systems and is increasingly used for high designing non-software systems and organizations.

There are two types of system design the logical and physical design: logical design is about the presentation of flow of data, inputs and outputs of the system, it uses some design tools which are flow chart, DFD, data dictionary, IPO and HIPO. The users will interact with the system especially updating and making inquiries about the data of the system. It specifies the methods of interaction in terms in menu of menu structures and command structures. A logical design is about Conceptual Blueprint of a software application, illustrating entities, relationship, rules and process of the system.

The Physical design is about the stage where you must do the actual input and output process of the system where all the logical specifications of the system are converted to description of the system through real hardware. This process is where you can see how data input inside of the system and how it displayed as output.

Description of the Existing System

The company was established on 1997 as trading company for industrial items but eventually diversified its operation to fabrication of steel works and now focusing on electro-mechanical works. Now, since the owner is a Professional Mechanical Engineer, The Company offers it service for mechanical consultancy works as follows. Design of HVAC system, elevators, overhead cranes and other related mechanical works. Because of the present needs the company now extent their service into plumbing, sanitary and fire protection works.

The existing system of H.O Abalos Builders Inc. is using manual procedures in registration, attendance and salary computation for their employees records. The human resource personnel place all the files in an envelope and store it in a filing cabinet. For attendance, they are using a logbook for monitoring the log-in and log out procedures. For the salary computation, the existing system uses manual computation method through the use of tools such as calculators, pens, etc. to compute for the salary of an employee.

Narrative Description of the Existing System

The following are the procedures on how the existing system operates.

1. Registration

1.1 The new applicant must fill up the registration form which is provided by the human resource personnel. The must fill up some personal question information such as name, address, email address, contact number and birth-date.

1.2 For the employee that is already registered to the system, their existing records will be stored in a document that is hidden in a file cabinet.

2. Attendance

2.1 The employees are using a logbook for monitoring the attendance.

2.2 When the employee is present, their time in and time out entries are recorded in the logbook.

2.3 When the employee is absent, no record of attendance will be recorded in the logbook. Absences will be deducted from their salary.

2.4 When the employee will have overtime there must be an overtime form from the Human Resource Department that will be signed.

3. Salary computation

3.1 The employees name is written manually in their pay slips.

3.2 The human resource personnel compute all the salary of each individual employee manually by using Microsoft Excel.

3.3 All appropriate deductions will be deducted in their monthly salary

4. Periodic reports

4.1 The employees request all the records can be viewed daily, quarterly, and yearly depending on the time frame of each projects4.2 The management will provide a photo copy of pay slip information manually fill up form.

4.3 All employees will assign to a log book and bandy clock for attendance and monitoring.

Procedural Flowchart of the Existing System

Start

Select Option

Registration Registration

Monitoring Monitoring

Salary Salary Computation Computation

End

Figure 1Main menu of Existing System

Registration

A

Personal information

Filing CabinetVerify information

A If information isValid?

Create I.D

Identification card

A2

Figure 2Registration of the Existing System

Monitoring

A

Employee name

Filling cabinetVerify record

Valid?

A

Filling cabinet

Check attendance

Is the employee absent?Filling cabinetRecord Attendance

Is the employee on leave?Filling cabinet

Record Attendance

Is the employee Present?Filling cabinetRecord Attendance

No record

A2

Figure 3Monitoring of attendance of the Existing System

Salary ComputationPay slipPrintCompute SalaryVerify recordEmployee name

CB

Salary * rate tax-deductionrate= 0, tax=0, deduction=0

Filling cabinet

CValid?

A2

Log bookRetrieve attendance

Filling cabinetRetrieve tax

Log bookRetrieve deduction

BE

Figure 4Salary Computation of the Existing System

ReportsIf valid

DE

Name of employee

Filling cabinetVerify record

DE

Select option

Filling Cabinet

Basic informationPrintFile

Check basic information

MonitoringFilePrint

Check hours workedHours worked

PrintFileMonitoringCheck deductionDeduction

PrintSalary computationPay slip

File

A2Figure 5Reports of the Existing System

Analysis of the Existing System

After the interviewed and knowing all the information and procedures that has given to the proponents, it analyzes the entire problem occurring to the existing system which is the registration, attendance and salary computation. The process of storing files is not secured and unorganized, also the salary computation method may cause error due to inaccurate data gathered through manual methods.

The proponents came up to a conclusion that in order to solve the problems mention above, the proponents would like to implement a new automated system that will help the establishment to run more effectively, efficiently and keep files in a more organized and secure place.

Introduction of the new technologies and software is required to increase the efficiency and productivity, in that way human errors and inaccuracies will be lessen by the used of automated computerized system itself.

Description of the Proposed SystemThrough strict research and analysis of the current problems and possible solutions, the proponents have concluded the recommendation of system software with barcode technology. The system would scan each employee`s unique identification cards that has a unique serial code installed which will serve as their daily time entries and by which would be associated with the employee respective record within the database, the proponents agreed that through this process, the occurrence of errors and inaccurate data would be prevented specially in monitoring their log-in and log-out process.

The proposed system will help the H.O Abalos Builders establishment to be more effective and accurate in handling transactions. All the files will be organized, secured and saved into the database. The log-in and log-out procedure of the employees will be more accurate and would prevent errors in the salary computation.

The recommended system shall automate the registration of the establishment. A new applicant shall fill out an application form that was provided by the human resource personnel and he will deem if the applicants is qualified or not for the position offered. After that the human resource will rewrite all the initial records of the new applicants and convert the files from hard copy to soft copy and if it is all done, a unique number and identification swiping device is generated, the database will store and verify the unique number. When the employee is going to log-in or log-out to the system he will have to use the identification card and swipe it, after that the database will verify it again if its valid or invalid.

If the employee wants to work overtime, he must take an overtime form that must be signed by the human resource head department. The system has two levels of access; the human resource manager and administrator; the difference between them is that the human resource manager has limitations of what he can access while the administrator can fully access the whole system. The human resource will input the unique number of the employee into the system and the salary will be automatically computed and generated, the stored records on the database will be the basis for the computation of their respective salary. Deductions are applied for their absences or late and taxes such as: SSS, Philhealth, Pag-ibig contribution and etc. the system will also generate a pay slip for each employees, by which they can view the record of their respective attendance. The systems also have a help module which would serve as a reference for the user to fully understand the functions of the proposed system.

Narrative Description of the Proposed System

The following are the procedure for the execution of the proposed system

Registration and Verification

1. New applicants must fill up the entire questions in the registration form such as name, age, contact number, birth date, address, nationality etc.2. The human resource personnel will claim the registration form and rewrite all the initial records of the new applicants and it will be stored in the systems database.3. After that, a unique number and identification swiping device is generated for the employee and the database will store and verify the unique number, the identification card will serve as employees` indication for daily time entry.Security

1. A unique username and password will be created for the systems administrators. Password must be eight to twelve(8 to 12) characters long and case sensitive.2. There will be two level of access the Administrator and Human resource personnel; the Administrator can access the whole system while the Human resource has a limitation on what he can access.

3. If the users password is invalid for three time there will be a forgot password? that will be displayed, and clicking that button will ask for a secret question and secret answer.

4. An audit trail report will be generated to monitor the valid users of the system.Attendance

1. When the employee is about to log-in or log-out he must swipe the identification card and the database will verify it if its valid or invalid.

2. When the employee is present, their time entries are recorded to the system and will be stored in the database.

3. If the employee is absent or late, absent will have no record, and if late it will be deducted to the employees salary.

4. When the employee exceeded the working hours, he will acquire an overtime form that will be signed by the Human Resource Personnel.

Salary Computation

1. The human resource personnel will look all the records of each employee`s that was stored in the database of the system, this records will be the basis of the computation of their salary.

2. There are two types of deduction: 2.1.1. The first one is, if they are late, absent and taxes.2.1.2. The other one is for their own benefits the SSS, Philhealth, and Pag-ibig contribution.

3. The human resource personnel will indicate the unique number of each employee and the system will verify the inquiry. The unique number is valid to an employee the system will automatically computes the salary according to records that was stored in the database.

3.1.1. The system can generate employees personal information.

3.2. The system will compute the salary of each employee based on their attendance.

4. All employees may claim their salary on a weekly basis.

Reports

1. Every week the system will generate a pay slips on each employees.

2. In the pay slip, employees computed salary will be indicated as well as other deductions and other income.

3. The system can also generate other necessary reports such as government contributions, loans and basic information. Help

1. The user can inquire information regarding the following:

1.1 System tutorial1.2 System information

Procedural Flowchart of the Proposed System

ARegistration

Personal information

Verify information

Database

AEmployee record/I.DInformation valid?DatabaseA1SaveGenerate employee no.

Figure 1Registration of the Proposed System

Log In

Input User / Pass

DatabaseVerify information

Verifying Account

Main Menu

No Existing Account

A1

Figure 2Log-in module

Forgot Password

A

Input secret answer

DatabaseA1Verifying answer

Correct Answer?

AInput another answer?Incorrect Answer

A1

Display username and password

Figure 3Forgot Password module

AI.D Generator

DatabaseVerifying user/ passInput User/ pass

Input another acoount?Valid?

ANO existing account

Account verify

A1

Generating ID code

Database

Barcode has been created for this account

A1

Figure 4I.D Generator module

Start

Counter=0

T

Enter username and password

Verify username and passwordValid?Counter=counter+1Select level of accessDatabase

Forgot passwordCounter=3

AdministratorA1EndIf level of access=1If level of access=1Manager

T

Figure 5Main menu of the Proposed System

Administrator

Select Option

RegistrationHelpSalary ComputationMonitoringSalary ComputationReportMonitoringRegistrationHelpReport

A1

Figure 5.1Administrator Account

ManagerA1RegistrationHelpReportHelpReportRegistrationSelect Option

Figure 5.2Manager Account

AMonitoring

ADatabaseRecord OTOT formScan employees BarcodeA1Valid? Is Employee overtime?DatabaseDatabaseSave record of log in and log - outVerify employee barcode

Figure 6Monitoring of Attendance of the Proposed System

Salary ComputationDatabaseDatabaseDatabaseCompute salarySalary = rate * attendance tax -deductionGet employee rateGet employee hours of workedValid?Input name of employeeSalary = rate * attendancerate= 0, tax=0, deduction=0

A

Verify employee account

A

Compute salary

A1

Figure 7Salary computation of the Proposed System

AReports

A1ReportPrintSalary ComputationPay slipBasic InformationRetrieve basic informationDatabaseReportPrintReportPrintmonitoringRetrieve hours workedHours workedReportPrintDatabaseDatabaseRetrieve basic informationBasic InformationSelect optionAValid?Verify employee recordEnter employee name

Figure 8Reports of the Proposed System

Enter username and passwordHelp

DisplayDisplay answerDatabaseSearchInput querySystem informationA1validValid

Figure 9Help module

Diagram of the Proposed System

0.0Human Resource Management SystemForH.O Abalos Builders Inc.Context Diagram

New User/ updated employees informationDisplay employees informationPrint ReportPayslipLevel of accessAdmin/ManagerAdministratorID createdID generatorSalary computationSearchUsername/PasswordAdd/EditReportAdmin/ManagerAdministrator

Dataflow Diagram of the Proposed System

Registration

1.0Registration

Generate IDInput personal information

Admin/ManagerAdmin/Manager

Register personal information

Account registered

D1Database

Exploded 1.1 Verification

Display output/Main menuInput username and password1.1Verification

Admin/ManagerAdmin/Manager

Verifying accountAccount Verified

D1Database

Attendance Monitoring

2.0Monitoring

Display time in and outInput name of employee

AdminAdmin

Verify RecordRecord Verified

D1Database

Security

3.0Security

LoginDetailsEnter Username/Password

Admin/HR

Admin/HR

VerifiedUsernameAnd PasswordVerify username and password

D1Database

Exploded 3.1 Forgot Password

Enter Username/Secret question3.1Security

Retrieved/Display Password

Admin/HR

Admin/HR

Confirmed User information and question

Verify User InformationD1Database

Report

ChooseReport Type4.0Report

View/Print Report

Admin/HR

Admin/HR

GenerateReport

Verify Report TypeD1Database

Maintenance

New User info/Back-up complete5.0Maintenance

Maintenance Information

Admin/HR

Admin/HR

UpdateEdit user information back-upD1Database

Exploded 5.1 Add

5.1Add

Backup completeAdd User Info

Admin/HR

Admin/HR

Confirmed added information/Update

Added informationD1Database

Exploded 5.2 Edit

View updated employees info5.2Edit

Input user informationAdmin

Admin

Updated user informationEdit information back-upD1Database

Search

Enter Employee Number6.0Search

Display Employees Information

Admin/HR

Admin/HR

Verified EmployeesInformation

Searching informationD1Database

Help

7.0Help

DisplayAnswerChoose QuestionAdmin/HR

Admin/HR

Retrieved Answers

Search for answersD1Database

ID generator

Enter Employees Name8.0ID Generator

ID created

ManagerManager

Account VerifiedVerifying account

D1Database

Enter Employees NameAdminSalary Computation

Salary Computed9.0Salary Computation

Admin

D1Database

Account VerifiedVerifying account

CHAPTER IIIMETHODOLOGY

Method is a systematic arrangement of ideas and topics presented in order to achieve something that was designed or planned. In this section, the proponents will discuss the methods used in order to achieve the goals for the proposed integrated payroll system for human resource department. It will lay out the information of the research methods used, data gathering procedures, and the software development methods.

Feasibility Study

A feasibility study is an analysis of the growth and development of an idea. The feasibility study focuses on helping to answer the essential question of should the proposed project idea proceed? all the activities of the study are directed toward helping to answer the questions. The proposed automated payroll system is a feasible; for it is possible if applied even it requires a great cost. It is very lucrative to use in such a way that it will develop and improve the existing payroll system procedure of the company.

Technical Feasibility

The large part of determining resources has to do with assessing technical feasibility. It considers the technical requirements of the proposed project. The technical requirements are then compared to the technical capability of the organization. The system project is considered technical feasible if the internal technical capability is sufficient to support the project requirements.

A computer is made up of both hardware and software; hardware consists of the physical components, while the software consists of the computer program itself. The proponents would like to set a hardware and software requirements for the proposed system such as pc, monitor, keyboard, printer and barcode scanner etc. for the hardware and Microsoft access 2007, Visual basic.NET 2008 for software requirements.

The proponents will be implementing Visual Basic.Net 2008 as a front- end graphical user interface with an objected-oriented programming concept that uses objects as their interactions to design applications and computer programs. This is and objected-oriented programming language that can reference a wide variety of objects and can be implemented on Microsoft windows operating system platforms which are commonly used by the most companies in the Philippines nowadays. It also features a click and drag function for easy system construction for the proposed system. The front end will also features data access and database connectivity, essential to this study since the modular structures of the proposed system calls for a database to be incorporated into it. The proponents will also use Microsoft access 2007 as the back-end of the proposed system. This database system would be best for Visual Basic.NET and would be suitable since both of them are products of the Microsoft Corporation which can provide a large capacity of data for storing massive amounts of data through tables and is also compatible with the chosen front-end. Microsoft access 2007 is a software product whose primary functions is to store and retrieve data that is initialized by the other software applications, an underlying component of the proposed database.

Operational Feasibility

Operational feasibility measures how well is the proposed system solves the problems that might occur, and takes advantage of the opportunities identified during scope definition and how it satisfies the requirements identified in the requirements analysis phase of system development. The advantage of implementing an integrated payroll system is; it was adaptable to the users for it is less complicated than the manual existing system. It is easier to operate and doesn`t required too much time and effort for it is manageable. Benefits of the proposed automated payroll system is when users are computing the payroll, the system will make it easier for them to find the total salary of each employee. The system will give less effort and time on the transactions of the company and give accurate reports. The system will also make it easier to identify errors in transactions if it happens.

Economical Feasibility

Economics analysis could also be referred to a cost/benefit analysis. This is where the most frequently used method for evaluating the effectiveness of a new system. In this economic analysis the procedure is to determine the benefits and savings that are expected from the payroll system and compare them with cost. If benefits surpass the costs, then the decision is made to design and implement the proposed payroll system.

The proposed automated payroll system will give benefits to the company these benefits include the tangible and intangible benefits. Tangible benefits are usually measured in terms of monthly and annual savings or profit to the firm such as fewer processing errors, increased through output, decreased response time, elimination of job steps, reduce expenses. Intangible benefits are those benefits that are difficult or impossible to quantify such as improved company goodwill, improved employee satisfaction.

Having these kinds of benefits will also give the company some cost. These costs are classified into two categories; first is system development costs which are one-time cost associated with analysis, design and implementation. Second is the operating cost defined as lifetime system benefits which must recovered, both the development and operating costs. These operating costs can be classified as fixed or variable costs. Fixed costs are the lease payments and software license payments; and divided salaries of data processing operators and support personnel. Variable costs are the computer usage such as CPU time used, terminal connect time used, storage used.

Cost Benefit Analysis

Cost Benefit Analysis (CBA) is significant in this study to identify the cost and benefits factors of the given company. It is a technique designed to determine the feasibility of a project plan by quantifying its cost and benefits.

I. Hardware CostItemSpecificationsPrice

MemoryKingston 2GB DDR3700.00

MotherboardIntel E5700 (3.0G)2,700.00

Hard Disk320GB Hitachi SATA3,400.00

Optical DriveLG Optical Drive950.00

Power SupplyATX power supply300.00

MonitorAOE monitor 16150.00

KeyboardPS/2 Keyboard150.00

MousePS/2 Mouse150.00

BarcodePOS Barcode Reader3,500.00

Total: 24,850.00Source: www.sulit.com.ph

II. Software CostSoftwareQuantityPrice

Visual Basic.Net 200814,000

Microsoft Office 200713,000

Total: 7,000Source: www.sulit.com.ph

I. Software Development CostPersonnelNumber of PersonnelAmountDayCost

Programmer45009045,000

System Analyst45909053,100

Total: 98,100 Source: payscale.com.ph

II. Stationaries and SuppliesItemQuantityPrice

Ball pen444,00

Short Bond paper1199.00

Sliding Folder110.00

Short Brown Envelope216.00

Short Plastic110.00

Ink black1600.00

Ink colored1600.00

Total: 1,479.00Source: www.nationalbookstore.com.ph

III. Utility ExpensesItemCost

Computer w/ monitor1,852.20

Computer printer1,296.90

Electricity3,905.10

Total: 7,054.20Source: www.meralco.com.ph

IV. Training CostPersonnelAmountDayHoursCost

Human Resource300581,500.00

Managers500582,500.00

Total: 4,000.00Note: two (2) employees will be trainedSource: www.payscale.com.ph

V. Summary of CostHardware cost24,850.00

Software cost7,000.00

Software Development cost98,100.00

Stationeries and Supplies1,479.00

Utility Expense7,054.00

Training cost4,000.00

Total: 142,483.20

Estimated Benefits1. Transactions, computation of payments and report will be more benefitable and will approximately increase to 90% Estimate: 128,234.88

Total Estimated Benefits: 128,234.88

Payback Period

Formula:(Cost/Benefits) * 12 months(142,483.20/128,234.88) * 12 = 13= 1 year and 1 month

Return of investment:

Formula:(Benefits/Cost)(128,243.88/142,483.20)*100% = 90%

Data Gathering Instruments

A term used to describe a process of preparing and gathering data, the purpose of data gathering is to collect or obtain information to keep on record, to make decisions about important issues and to pass information to others.

InterviewIt is a formal meeting in person that has the objective to gain information in the research of the system. The purpose of interview is to understand how the system operates and the problems occurring on the existing system.

Internet ResearchThe proponents use internet method for seeking relevant information through sites and search engines to gain more reliable, accurate data and information.

Observation methodObservation method was used by the developers because it is the most fundamental type of data gathering method. It is a way to gather information on the spot by taking note of the details of procedures, flows, and routine of particular research target.Library methodThe proponents also use library method because it is the most common, widely used, and conservative method of data gathering. The developers found related books, thesis and other published and unpublished materials in order to collect requirements for the system.

Data Gathering Procedures

During gathering stage, The proponents conducted an interview with the Human Resource and President of the H.O Abalos Builders, who gave the mission and vision, organizational chart of the company, resources at hand, flow of the company`s existing system, process of computing the salaries and monitoring of the employees. This interview also concluded the specific main information needed in the study. The proponents then utilized the internet, method of seeking relevant and essential information through searching engine via online which provided some vague and some informative information related to the proposed system. The internet was also the basis of information based on technicalities and specifications.Finally, the proponents took the opportunity to inspect the physical condition of the company, to learn the routine of employees and to observe the process of the existing system that leads to ideas of the current problems being encountered.

System Requirements

The proposed system is compatible with either the following requirements

HardwareHardware

Processor4x speed DVD-ROM Drive

Hard Disk320 GB

MouseOptical

Monitor17 LCD Flat Screen Monitor

KeyboardUSB Keyboard

PrinterHP PSC 1410 series

Power SupplyATX power supply

BarcodePOS/Laser Barcode Reader, Autosense With Stand

Table 1.1Hardware Specifications

SoftwareRecommended

Front EndVisual Basic.NET 2008

Back EndMicrosoft Access 2007

Table 1.2Software Specifications

Schedule Feasibility

Table 1.3Gantt ChartLegend: Appendix A Approval LetterAppendix B Highlights of the interviewAppendix C Data DictionaryAppendix D Sample Screen LayoutAppendix E Curriculum VitaeAppendix F Permits (Prelim, Midterm, Finals)CHAPTER IVSUMMARY, CONCLUSION AND RECOMMENDATION

Summary

Todays generation requires every work to be done in an easy way to efficiently utilize time and effort yet still having a productive report. An example of this is pushing through the computerization of H.O Abalos Builders Inc. Having this done, the Administrator and H.R Manager will conveniently access every employees records through a database which would enable the company to create reports easier and more accurately. At the same time through this process it the company can ensure a more reliable and more accurate data for the employees salary computations.

In the year of 1996, Mr. Hilario Oliveros Abalos founded the Jolar Engineering and industrial sales to serve the on-going demand on technical and clientele services. The owner has diversified its services from trading company to specialty contractor of Electro Mechanical works, structural and architectural steel fabrication and eventually to construct and maintenance of industrial, commercial building and warehouses. By the year 2012, due to the increase in demands for mechanical services, the company decided to incorporate itself by which it is now known by the name, H.O Abalos Builders INC. The H.O. Abalos Builders INC. currently uses the pen, calculator and paper system, and occasionally the basic office programs like word and excel. Currently its processes are plagued with errors and inconsistencies brought about by the basic human errors like misread penmanship, and confusion in reading. Though the use of computers is a bit more advanced, how the information is processed makes it just as unreliable.

An upgrade of its grading system will benefit the institution by leaps and bounds, and also give some extra advantages. With the use of computers, The Human resource department would be relieved with the stress of writing with a pen. Errors from penmanship will be eliminated with the uniform fonts that will be used by the software. There will be a lesser need for the human resource manager to do overtime to do the necessary computation for the salary of an employee now that the information is easily accessible to authorized users and the time they will need to process data will be greatly reduced. By integrating its management system with the more up to date staples like LAN systems and better software, information processed by the human resource personnel will become more precise, reliable, accessible and secure.

The research study that the proponents created gives solutions in the current problems occurring of H.O Abalos Builders. There are many things that has been done such as researching about related study; thesis, books, internet and interview about some questions with vague answers and the approval of some colleagues studying in the field of programming who conducted the same research.

Conclusion

Based on the information stated in chapter 1 and based on the data gathered, the proponents surmise that the H.O Abalos builders Inc. is in need of a H.R management system upgrade and have come up with the appropriate solution. The proponents have devised a system that will streamline the procedure of processing records and salary computation with the following modules:

1. The current system uses log book to monitor the individual time-in and outs of an employee. The proposed system uses an identification card to monitor the attendance of an employee. It will be easier to monitor the records through the database and would lessen the time required for log-in and log-out. The identification card is installed with a unique barcode number on it to provide individual records for each employee.

2. The existing system cannot provide security on their records and data storage. To provide security module that will ensure that only authorized user will be able to access the system. These will provide two levels of access, the Administrator and the Human Resource Manager. They should log-in with their username and password. For entering such information it will only allow three valid inputs for a user to enter their username and password, failing to do so, automatically locked the system. The Administrator has full access to all modules of the system. He is also the only one authorize to edit data from the system. The Human Resource manager is responsible for the interaction of the employees and their respective records.

3. The computation of salary is done manually which may result to inaccurate salary computation. The proposed system will provide an accurate and faster computation of salary by allowing the user to view the records of an employee which includes the attendance, deductions and taxes that may be used for cross-reference with their pay slip that would be generated by the system. With this the process of information would be much faster compared to manual system.

4. The system cannot provide sufficient report for a particular transaction when needed.The proposed system also have a reports module that will automatically filter the necessary and needed reports such as overall attendance, salary computation report, taxes/benefits and the audit trail reports by letting the user to choose what kind of report that he/she need to be print out. Having this will also help the organization to avoid misplacing of the reports. And it will reduce the time consume in finding other kind of reports.

Recommendation

With new generation theres a lot of new high tech, it is evident that everyone must adhere to the needs of this new day and age. H.O Abalos Builders Inc. manual system is old, outdated, worn down, and cannot be expected to be applied to an ever growing number of employees and still maintain its accuracy. The proponents recommend to the next developer or future researcher to:

1. The proponents recommend the company to use the bank as means of salary distribution.2. The proponents recommend the company to use a WAN based technology instead of LAN based, for wide and complete inspection of the workers in the other sites.3. The proponents recommend to the company to use an online system for more efficiency and accessibility.4. The proponents recommend the company to use a biometric technology to enhance security level.

Integrated payroll system for H.O corporation utilizing local area network based technology

1

Integrated payroll system for H.O corporation utilizing local area network based technology