computerized payroll system

23
Computerized Payroll System for Derf’s Manpower and General Services Phils, Inc., DEVELOPERS : Dandamun, Raihana S. Fernandez, Apols V. Gicaro, Mark Francis G. Tancinco, Angelique M.

Upload: francis-genavia

Post on 31-Oct-2014

44 views

Category:

Documents


5 download

DESCRIPTION

 

TRANSCRIPT

Page 1: Computerized payroll system

Computerized Payroll System

for Derf’s Manpower and

General Services Phils, Inc.,DEVELOPERS :

Dandamun, Raihana S.Fernandez, Apols V.

Gicaro, Mark Francis G.Tancinco, Angelique M.

Page 2: Computerized payroll system

Introduction:• Derf’s Manpower and General Services, Phils., Inc. is a private corporation

duly registered with the Securities and Exchange Commission (SEC), Bureau of Internal Revenue (BIR), and the Department of Labor and Employment (DOLE).

• At present Derf’s have the following clients: SM Homeworld, Pollandre Manufacturing Corp., Blue Mountain Worldwide Distribution Inc., Green Light Recreative, Apollo Lightning Inc., and Enderun Colleges.

• Derf’s Manpower and General Services, Phils., Inc. had been the priority of the developers in creating a computerized payroll system for the benefit of the company and its employees, as well as to provide a payroll system that offers fast transactions, generates reports and lessens the time consumed in preparing the payroll.

Page 3: Computerized payroll system

GENERAL PROBLEM:

The Derf’s Manpower and General Services, Phils., Inc. is having a hard time in manually checking each daily time record of employee, monitoring of previous loans, cash advances and charges and preparing essential reports.

Page 4: Computerized payroll system

SPECIFIC PROBLEMS:

• The Derf’s Manpower and General Services, Phils., Inc. is

having a hard time in monitoring the previous loan, cash advances, and charges of the employee due to unorganized employee records, wherein the Staff has to find a specific employee record on a different folders.

• The Derf’s Manpower and General Services, Phils., Inc. consumes time and effort in manually checking each daily time record of the employee.

• The Derf’s Manpower and General Services, Phils., Inc. is having difficulties in making reports because of the voluminous files stored and placed in the filing cabinets.

Page 5: Computerized payroll system

GENERAL OBJECTIVE:

To design and develop a Computerized Payroll System for Derf’s Manpower and General Services, Phils., Inc. that provides fast transactions, minimize the manual checking of employees daily time record, monitors previous employee loans, cash advances and charges, and can generate essential reports.

Page 6: Computerized payroll system

SPECIFIC OBJECTIVES:

• To minimize the manual checking of each daily time records of the employee.

• To develop a module that will monitor the status of employee’s loan and other deductions such as cash advances and charges.

• To develop a module that will generate essential reports.

Page 7: Computerized payroll system

SCOPE AND LIMITATIONS:

Page 8: Computerized payroll system

SCOPE:• It covers the time-in and time-out of employees through

biometrics, specifically through a fingerprint scanner technology.

• It also covers the process of preparing the pay slip of each employee, monitors loans, cash advances, charges, keeping the records and easily computes the basic pay, regular overtime pay, overtime with night differential pay, pay during day off, special and legal holiday pay, gross pay, SSS contributions, PhilHealth contributions, Pag-Ibig contributions, admin fee, cash bond, loans, cash advances, charges deductions and net pay.

Page 9: Computerized payroll system

LIMITATIONS:• The system cannot generate report of appraisals and

evaluation reports of the employee because it was not included in the system.

• The system will only be used for payroll transactions by the company specifically Derf’s Manpower and General Services, Phils., Inc. It will not be employed in any other company other than Derf’s Manpower

Page 10: Computerized payroll system

ENTITY RELATIONSHIP DIAGRAM

Page 11: Computerized payroll system

Figure 3.2.4.1 ERD Illustration of Logical Diagram

Page 12: Computerized payroll system

Figure 3.2.4.2 ERD Illustration of Physical Diagram

(A)

Page 13: Computerized payroll system

Figure 3.2.4.3 ERD Illustration of

Physical Diagram (B)

Page 14: Computerized payroll system

DATA FLOW DIAGRAM

Page 15: Computerized payroll system

Figure 3.2.5.1 DFD Context

Level

Page 16: Computerized payroll system

Figure 3.2.5.2 DFD (A)

Page 17: Computerized payroll system

Figure 3.2.5.3 Exploded DFD (B)

Page 18: Computerized payroll system

Figure 3.2.5.4 Exploded DFD (C)

Page 19: Computerized payroll system

Figure 3.2.5.5 Exploded DFD (D)

Page 20: Computerized payroll system

COMPUTATIONS

Page 21: Computerized payroll system

Descriptions Computations

Total No. of regular days worked Total No. of regular days worked * rate = Basic Pay

Regular Overtime (hours) (Rate/8) * 1.25 (constant) = OT Pay

Overtime with Night Differential (Rate/8) * 1. 35 (constant) = OTWND Pay

Duty on Day off Rate * 1. 3 = DOD Pay

Legal Holidays Rate * 200 % = Legal Holiday Pay

Special Holidays Rate * 1.3 % = Special Holiday Pay

Gross Pay Basic Pay + OT Pay + OTWND Pay + DOD Pay + Legal

Holiday Pay + Special Holiday Pay = Gross Pay

SSS Contributions Employee Share (depends on compensation range

per month) / 26 (employees regular work days per

month) = result * total no. of regular days worked

Salary Computation

Page 22: Computerized payroll system

PhilHealth Contributions Employee Share (depends on compensation range

per month) / 26 (employees regular work days per

month) = result * total no. of regular days worked

Pag-Ibig Contributions Employee Share (depends on compensation range

per month) / 26 (employees regular work days per

month) = result * total no. of regular days worked

Cash Bond Basic Pay * 5% = Cash Bond

Admin Fee Basic Pay * 2% = Admin Fee

Lates (Rate/8 hours) / 60 minutes = Late

Other Deductions Cash Advance + Charges + Loans = Other Deductions

Total Deductions SSS co + PhilHealth/Pag-Ibig Contributions + Cash

Bond + Admin Fee + Late + Other Deductions =

TotalDeductions

Net Pay Gross Pay – Total Deductions = Net Pay

Page 23: Computerized payroll system

13th Month Pay Computation

13th Month Pay Computation Daily rate * 26 regular working days of an employee per month / 313, regular working days of an

employee per year = result * total number of days worked by the employee = 13th Month Pay .