Payroll System

The solution has to take care of calculation of salary as per rules of the Company. This Payroll System is a full-featured system that manages financial information of every employee in an organization. It computes and processes the payroll in the certain payroll period. This Payroll System is also a flexible compensation administration solution. It is designed to help human resource professionals as well as finance and accounting personnel to manage employee compensation, deductions, allowances, and benefits in an organization.The system is integrated with the Employee’s information, offers efficient features and functionalities to manage company's expenses. Background of the Study Trends Asia Marketing and Services Corporation (TRAMSCO) provide superior corporate assistance and business solution by giving various services to the companies, business owners, entrepreneurs and professionals. Trends Asia Marketing and Services Corporation (TRAMSCO) offer solutions to help your b usiness succeed. They are committed to excellence in providing an effective, efficient support system for all phases of your business.They can assist you from start-up, taking care of the countless details that need to be handled, they can help with tasks relating to day-to day operations, and they can help formulate and implement effective business strategies to help your business grow and flourish. Because of these, Trends Asia Marketing and Services Corporation (TRAMSCO) grows immediately but Mrs. Agnes De Guzman Francia the owner realize that its hard to use the â€Å"Mano – Mano System† when she gives the salary and wages to her employees, since her business achieved the highly status recommendation around the Philippines.She decided to cooperate with a computer manufacturer in designing and analyzing the system. She request to the computer designer to do something that makes easier when she giving the salary of her employees. She adds some details like the log â €“ in form, because she said, she wants to personalize and to maintain the confidentiality of the information contains. She also added some details in the second form like employee’s name, and no. of hours worked and the other design and details are done by the computer designer. After 5 – 6 years working out with this system, Mrs.Agnes De Guzman Francia wants to update their Payroll System and change the other information. That‘s why we offer Mrs. Agnes De Guzman Francia a free system which conceptualized the information according to her wants. Problem Definition Last Friday December 11, 2009, we decided to start doing our system entitled Payroll System. To describe the system before we conceptualize it, it contains Employee’s Name, No. of hours worked, O. T. pay, Rate per hour, basic pay, and Gross pay. Now we added the deductions that typically reduced in the salary in a regular employee, it contains SSS, MED, Total Deductions and Net pay.Of course before we succeed in doing this system, we encounter a lot of problems and those are problems are not easy to solve like the calculation that we need to input to performed the right calculations in this system, we don’t know how much is the cost of the SSS, MED and the Other fees that we need to lessen in the salary of a employee. To solve these problems our group think some possibilities which help us to fulfil our project. First we asked some regular employees how much the cost of the SSS that their employer deducts in their salary.Our Second option is we search and surf the net to know the cost of following. Significance of the Study Payroll System is important to every company because any business that employed people will have to process those wages of the employee when they are due. In order to make sure that your payroll is processed correctly and accurately, you need a system which appropriate to your needs. That’s why this system exists. Payroll System is done by calculating how much each employee is owed, then making the appropriate deductions for tax, SSS pensions, etc. nd sending those to the relevant tax offices. Then payslips need to be printed and issued to employees and the duplicate copy will be given to the administration or to the accounting department to record the transaction. Scope and Delimitation CHAPTER 2 Existing systems overview Background of the Company Last quarter of 2004, four friends have conceptualized venturing into salon operations, since no one has knowledge in salon operations; they agreed to venture into salon franchise agreement.Trends Asia Marketing ; Services Corporation (TRAMSCO) was incorporated on October 4, 2004 to formally handle the franchise agreement with F Salon ; Body Spa. The franchise outlet was located in San Joaquin, Pasig Branch. First quarter of year 2005, the corporation engaged in various services aside from operating a salon franchise. The corporation engaged itself in providing manpower outsourcing and other allied services. Management of the franchise was left under Trends Asia Marketing ; Services Corporation (TRAMSCO).Conflict on financing the manpower activities which remained solely on the part of its operations manager, Mrs. Agnes De Guzman Francia, prompted her to segregate the F Salon ; Body Spa Franchise from Trends Asia Marketing ; Services Corporation (TRAMSCO), and pursue its manpower sourcing and allied services. The salon franchise is continuing to date with the original partners who established it and Trends Asia Marketing ; Services Corporation (TRAMSCO) was left under the management of Mrs. Agnes De Guzman Francia.Trends Asia Marketing ; Services Corporation (TRAMSCO) now was transformed as a family corporation. Having seen the viability and profitability of salon operation, the husband and wife team of Francia’s locate feasible locations for possible salon outlet. On September 2006, an existing salon outlet was being sold by its owner who is migrating abroad. Right there and then, the couple decided to buy out and pay for the existing salon and transform the salon outlet into what it is today. Yanna’s Salon ; Body Spa opened on September 24, 2006 till under the operation nd management of Trends Asia Marketing ; Services Corporation (TRAMSCO). Yanna’s Salon was named from the spouse’s youngest daughter â€Å"Yanna†. The Salon from the initial opening date, continue to how brisk business and good sales performance. Trends Asia Marketing ; Services Corporation (TRAMSCO) at present is continuing its manpower sourcing and business set up and accounting services. The 1st Yanna’s Salon is situated in corner Village East, Cainta Rizal which commences its operations on September 18, 2006 and the 2nd outlet in Rosario, Pasig City commences on November 24, 2006.The company has a target of at least maintaining 6 company owned salon locations starting within Rizal Area and in the future a possib ility of offering salon franchises in any parts of the Metropolis and in nearby provinces. Yanna’s Salon ; Body Spa is a full – service beauty salon adhering to consistently provide high customer satisfaction by rendering excellent service, quality products, and furnishing an enjoyable atmosphere at an acceptable price/value relationship.They will also maintain a friendly, fair and creative work environment, which respects diversity, ideas, and hard work. Existing Systems Overview Existing Systems Overview | | |UTILITY EXPENSE | |   | Annual Expense | | |Monthly Expense | | |   |   |   | |   |   |   | |WATER |P 1,800. 0 |P 21, 600. 00 | |   |   |   | |   |   |   | |   |   |   | | |UTILITY EXPENSE | |   | |Annual Expense | | |Monthly Expense | | |   |   | | |   |   |   | |TELEPHONE |P 3, 300. 00 |P 39, 600. 0 | |   |   |   | |   |   |   | |   |   | | Data Flow Diagram CHAPTER 3 System findings System Findings A nalysis for Proposed System Cost CHAPTER 4 System implementation System Implementation Chart of Comparison for the Existing and Proposed System [pic] Statistical Computation Monthly Benefit (MB) |Annual Benefit (AB) | |MB = EC – PC |EC * 12 Months =? | |MB = 30,000 – 15,000 |PC * 12 Months =? | |MB = 15,000 |AB = EC – PC | |   |AB = 360,000 – 180,000 | |   |AB = 180,000 | Break Even Analysis [pic] Comparative Chart for Monthly and Annual Benefit Existing Monthly Cost |Existing Annual Cost | |Existing Monthly Cost = 30,000 |Existing Annual Cost = 360,000 | |After 5 months = 150,000 |After 5 years = 1,800,000 | |Monthly Benefit = 6,000 |Annual Benefit = 72,000 | | | | |Proposed Monthly Cost |Proposed Annual Cost | |Proposed Monthly Cost = 15,000 |Proposed Annual Cost = 180,000 | |After 5 months = 75,000 |After 5 years = 900,000 | |Monthly Benefit = 3,000 |Annual Benefit = 36,000 | Comparative Chart for Monthly and Annual BenefitComparative Chart for Mon thly and Annual Benefit CHAPTER 5 Summary Summary Conclusion Recommendation Objective of the Study The Primary objective of this study is to continuously operate the Payroll Department of Trends Asia Marketing ; Services Corporation (TRAMSCO) which held the salary and wages of their employees. Secondly, the Payroll Department of Trends Asia Marketing ; Services Corporation (TRAMSCO) make a payroll report easier rather than before. [pic] ———————– START NO YES LOGIN CALCULATE EXIT B. P = N. H. W * R. P/H O. T = R. P/H * -1. 25 GP = B. P + O. T D = SSS + MED + OTHERS FEES N. P = GP – D OUT PUT END END FLOW CHART Payroll System Title: A LAN- Based Attendance Monitoring System Using Biometric Device For Don Jesus Gonzales High School Brief Description of the Proposed Thesis Don Jesus Gonzales High School is located at Pandacaqui Resettlement Mexico Pampanga . At present, the school doesn’t have an automated system which can verify if the person entering the school is a bonified student . The school security guard just check the id of the students one by one before entering the school. Sometimes, some people were able to pass even without id when there are many students going in. The proposed system will allow the guard to be able to know by the biometric device if the person entering the school is a registered student or not. Another, the faculty members also takes time in writing the time when they arrived and/or go out to school. The system will record the â€Å"time in† and â€Å"time out† of the faculty members . Upon scanning all their finger to the biometric device. It will also assure the safety of the students, staff and school. The system will use biometric device to verify all the finger if its registered on the database to ensure that the person entering the school is a bonified student. Also when the student entering the school has a violation, a notice will appear on the monitor screen. To keep record of the â€Å"time in† and â€Å"time out† of the faculty members, same procedure also by the use of biometric device, the information will be saved on the database The system itself is secured. Before a person access the system, he/she would be asked to input a username and password then it will be processed if it is granted or decried. The authorized persons are the principal, guidance councilor, the head of the computer subjects and one school coordinator. Statement of objectives These are the objectives of the proposed study General Objective The main objective of the study is to create a LAN based student monitoring and faculty attendance. Monitoring System using biometric device for Don Jesus Gonzales High School that will identify if the person enters the school is a bonified student and to record the â€Å"time in† and â€Å"time out† of the faculty members. Specific Objectives * To ensure the security of the school. * To increase the visibility of trespassers/intruders. * To have an accurate data about the attendance of the faculty. To automate the system that is efficient and user friendly. * To provide notification about student’s violation. Significance of Proposed Thesis Topic or Justification The study benefits its locale, Don Jesus Gonzales High School. The system is a good way in increasing the campus security. It will assure the safety of the students, faculty, staff and community. Also, it will incre ase the visibility of the intruders and avoid violence in the school.. The faculty members and students will also benefits on this study since the system will make the process faster and hassle free. Lastly, the system can also be a basis of other school in developing an students and faculty monitoring system. Review of Related Literature And Studies Fingerprint biometrics are used in a variety of applications including electronic door locks, smart cards, vehicle ignition control systems, USB sticks with fingerprint controlled access, and many others. Digital signal processing elements in fingerprint scanners perform complex DSP functions such as filters, transforms, feature extraction, matching operations and other algorithms. At the CARTES & IDentification 2011 conference in Paris, France, DigitalPersona, Inc. nnounced that the company has open sourced its new MINEX-certified FingerJetFX fingerprint feature extraction technology. FingerJetFX, Open Source Edition (OSE), is free, portable software that device manufacturers and application developers can use to convert bulky fingerprint images into small, mathematical representations called fingerprint â€Å"templates† for efficient storage or comparison. The software has been released under the Lesser GNU Public License (LGPL), giving developers the flexibility to adapt the extractor to their particular platforms and applications. DigitalPersona is also offering a separate commercially-licensed version that adds fast fingerprint matching for both identification and verification while still running in a small amount of memory. Once the image is captured the digital information is transferred to a digital signal processor to generate a match. The first step in the matching process is conditioning the scanned fingerprint. Finger print readers rarely use the full fingerprint for identification. Rather, DSPs use algorithms to extract the unique features and patterns of each print to generate a unique digital code. The second step in the software flow is to take the code generated from the scanned image and compare it to a database of potential matches. The compare step requires the system to have access to print information in a networked database or a non-volatile memory unit. Computer Hardware and Software to be Used The study will use several software and hardware for the development of the proposed system. Software * Visual studio * Visual Basic 2000- for the main design of the system interface of the system. * Microsoft Office 2007 Microsoft Access- for the database of the system. Hardware * Computer set * Processor Intel ® Pentium ® 4cpu 3. 00 GHz * Memory 1014MB RAM * Internet connection * Biometric device Detailed Features of the Proposed System These are the detailed features of the proposed system * Secured access of the system. * User Friendly interface. * Time-In time-Out of faculty using Biometric * Notification/Flash Message to students with violation * The system displays im age and other basic info about the students and faculty members * Biometric scanning to able to enter the school. Payroll System Telecommunications network is a combination of nodes and links which are arranged in a manner so that the message may pass from the one part of the network to the other by traveling over variable nodes. Essential Parts of the Network There are five basic segments of this type of network. These parts include terminals, channels, processors, computers and control softwares. The starting and ending point of the telecommunication networks is known as a network terminal. There are many input and output devices which are often placed under the heading of terminals. Telecommunication processors are often helpful in transferring data between the terminals of the network. These processors also provide variety of control and support functions. Telecommunication channels are the reception and transmission point for the data and messages. The network computers are arranged in a manner so that they establish a network connection using different media, these computer terminals help in communication. Telecommunication network software governs the control and functional activities with the help of software in a network. The structure of telecommunication network has three main components the control plane, the user plane and the management plane. As indicated by its name the control plane carries control information and data. The data plane or user plane monitors the user traffic in the network. The third and last component management plane carries the operation and administration traffic over the network. Types of Telecommunication Networks. Telecommunication network has many types like wide area network, metropolitan area network, local area network, campus area network, personal area network, virtual private networks, client server network, peer to peer network, network computing. The network which is spread over a large geographic area is known as wide area network. This network has helped businesses which are dispersed over different regions to communicate to the head office. Metropolitan area network covers the area of nearly one city or county. Its area and coverage is more than the local area network and less han the wide area network. The communication of computers in a very small geographical area is known as local area network. Campus area network is a network which is restricted to the small geographical area which is limited to the university campus or a building. Personal area network is a network which is limited to an individual. Virtual private network is built on the principle of secure encrypted network in order to provide complete security to the users. The client server network is network which is connected to the LAN at one end and the back up server at the other end. When a computer uses network browser to connect to the other computers in the network it is known as network computing. Microsoft office online is the good example of such kind of network. Peer to peer network is used for connecting only those computers which have copy rights to use each others resources. Examples of a Telecommunication Network The first example of the telecommunication network is computer networks . computer network is set of computers which are attached to each other for the purpose of resource sharing. The second example is the internet. Internet is the global network which allows the users in many dispersed areas to connect via web browsers and telecommunication technologies provide by internet services providers. Third example is of the public switched telephone networks, it is a circuit switched network which used to carry analog signals but now it carries digital signals mostly. The fourth example is the working of global telex; it is a set of machines which include teleprinters and tele typewriters. The last example is of the aircraft communication addressing Payroll System Title: A LAN- Based Attendance Monitoring System Using Biometric Device For Don Jesus Gonzales High School Brief Description of the Proposed Thesis Don Jesus Gonzales High School is located at Pandacaqui Resettlement Mexico Pampanga . At present, the school doesn’t have an automated system which can verify if the person entering the school is a bonified student . The school security guard just check the id of the students one by one before entering the school. Sometimes, some people were able to pass even without id when there are many students going in. The proposed system will allow the guard to be able to know by the biometric device if the person entering the school is a registered student or not. Another, the faculty members also takes time in writing the time when they arrived and/or go out to school. The system will record the â€Å"time in† and â€Å"time out† of the faculty members . Upon scanning all their finger to the biometric device. It will also assure the safety of the students, staff and school. The system will use biometric device to verify all the finger if its registered on the database to ensure that the person entering the school is a bonified student. Also when the student entering the school has a violation, a notice will appear on the monitor screen. To keep record of the â€Å"time in† and â€Å"time out† of the faculty members, same procedure also by the use of biometric device, the information will be saved on the database The system itself is secured. Before a person access the system, he/she would be asked to input a username and password then it will be processed if it is granted or decried. The authorized persons are the principal, guidance councilor, the head of the computer subjects and one school coordinator. Statement of objectives These are the objectives of the proposed study General Objective The main objective of the study is to create a LAN based student monitoring and faculty attendance. Monitoring System using biometric device for Don Jesus Gonzales High School that will identify if the person enters the school is a bonified student and to record the â€Å"time in† and â€Å"time out† of the faculty members. Specific Objectives * To ensure the security of the school. * To increase the visibility of trespassers/intruders. * To have an accurate data about the attendance of the faculty. To automate the system that is efficient and user friendly. * To provide notification about student’s violation. Significance of Proposed Thesis Topic or Justification The study benefits its locale, Don Jesus Gonzales High School. The system is a good way in increasing the campus security. It will assure the safety of the students, faculty, staff and community. Also, it will incre ase the visibility of the intruders and avoid violence in the school.. The faculty members and students will also benefits on this study since the system will make the process faster and hassle free. Lastly, the system can also be a basis of other school in developing an students and faculty monitoring system. Review of Related Literature And Studies Fingerprint biometrics are used in a variety of applications including electronic door locks, smart cards, vehicle ignition control systems, USB sticks with fingerprint controlled access, and many others. Digital signal processing elements in fingerprint scanners perform complex DSP functions such as filters, transforms, feature extraction, matching operations and other algorithms. At the CARTES & IDentification 2011 conference in Paris, France, DigitalPersona, Inc. nnounced that the company has open sourced its new MINEX-certified FingerJetFX fingerprint feature extraction technology. FingerJetFX, Open Source Edition (OSE), is free, portable software that device manufacturers and application developers can use to convert bulky fingerprint images into small, mathematical representations called fingerprint â€Å"templates† for efficient storage or comparison. The software has been released under the Lesser GNU Public License (LGPL), giving developers the flexibility to adapt the extractor to their particular platforms and applications. DigitalPersona is also offering a separate commercially-licensed version that adds fast fingerprint matching for both identification and verification while still running in a small amount of memory. Once the image is captured the digital information is transferred to a digital signal processor to generate a match. The first step in the matching process is conditioning the scanned fingerprint. Finger print readers rarely use the full fingerprint for identification. Rather, DSPs use algorithms to extract the unique features and patterns of each print to generate a unique digital code. The second step in the software flow is to take the code generated from the scanned image and compare it to a database of potential matches. The compare step requires the system to have access to print information in a networked database or a non-volatile memory unit. Computer Hardware and Software to be Used The study will use several software and hardware for the development of the proposed system. Software * Visual studio * Visual Basic 2000- for the main design of the system interface of the system. * Microsoft Office 2007 Microsoft Access- for the database of the system. Hardware * Computer set * Processor Intel ® Pentium ® 4cpu 3. 00 GHz * Memory 1014MB RAM * Internet connection * Biometric device Detailed Features of the Proposed System These are the detailed features of the proposed system * Secured access of the system. * User Friendly interface. * Time-In time-Out of faculty using Biometric * Notification/Flash Message to students with violation * The system displays im age and other basic info about the students and faculty members * Biometric scanning to able to enter the school. Payroll System Telecommunications network is a combination of nodes and links which are arranged in a manner so that the message may pass from the one part of the network to the other by traveling over variable nodes. Essential Parts of the Network There are five basic segments of this type of network. These parts include terminals, channels, processors, computers and control softwares. The starting and ending point of the telecommunication networks is known as a network terminal. There are many input and output devices which are often placed under the heading of terminals. Telecommunication processors are often helpful in transferring data between the terminals of the network. These processors also provide variety of control and support functions. Telecommunication channels are the reception and transmission point for the data and messages. The network computers are arranged in a manner so that they establish a network connection using different media, these computer terminals help in communication. Telecommunication network software governs the control and functional activities with the help of software in a network. The structure of telecommunication network has three main components the control plane, the user plane and the management plane. As indicated by its name the control plane carries control information and data. The data plane or user plane monitors the user traffic in the network. The third and last component management plane carries the operation and administration traffic over the network. Types of Telecommunication Networks. Telecommunication network has many types like wide area network, metropolitan area network, local area network, campus area network, personal area network, virtual private networks, client server network, peer to peer network, network computing. The network which is spread over a large geographic area is known as wide area network. This network has helped businesses which are dispersed over different regions to communicate to the head office. Metropolitan area network covers the area of nearly one city or county. Its area and coverage is more than the local area network and less han the wide area network. The communication of computers in a very small geographical area is known as local area network. Campus area network is a network which is restricted to the small geographical area which is limited to the university campus or a building. Personal area network is a network which is limited to an individual. Virtual private network is built on the principle of secure encrypted network in order to provide complete security to the users. The client server network is network which is connected to the LAN at one end and the back up server at the other end. When a computer uses network browser to connect to the other computers in the network it is known as network computing. Microsoft office online is the good example of such kind of network. Peer to peer network is used for connecting only those computers which have copy rights to use each others resources. Examples of a Telecommunication Network The first example of the telecommunication network is computer networks . computer network is set of computers which are attached to each other for the purpose of resource sharing. The second example is the internet. Internet is the global network which allows the users in many dispersed areas to connect via web browsers and telecommunication technologies provide by internet services providers. Third example is of the public switched telephone networks, it is a circuit switched network which used to carry analog signals but now it carries digital signals mostly. The fourth example is the working of global telex; it is a set of machines which include teleprinters and tele typewriters. The last example is of the aircraft communication addressing Payroll System Telecommunications network is a combination of nodes and links which are arranged in a manner so that the message may pass from the one part of the network to the other by traveling over variable nodes. Essential Parts of the Network There are five basic segments of this type of network. These parts include terminals, channels, processors, computers and control softwares. The starting and ending point of the telecommunication networks is known as a network terminal. There are many input and output devices which are often placed under the heading of terminals. Telecommunication processors are often helpful in transferring data between the terminals of the network. These processors also provide variety of control and support functions. Telecommunication channels are the reception and transmission point for the data and messages. The network computers are arranged in a manner so that they establish a network connection using different media, these computer terminals help in communication. Telecommunication network software governs the control and functional activities with the help of software in a network. The structure of telecommunication network has three main components the control plane, the user plane and the management plane. As indicated by its name the control plane carries control information and data. The data plane or user plane monitors the user traffic in the network. The third and last component management plane carries the operation and administration traffic over the network. Types of Telecommunication Networks. Telecommunication network has many types like wide area network, metropolitan area network, local area network, campus area network, personal area network, virtual private networks, client server network, peer to peer network, network computing. The network which is spread over a large geographic area is known as wide area network. This network has helped businesses which are dispersed over different regions to communicate to the head office. Metropolitan area network covers the area of nearly one city or county. Its area and coverage is more than the local area network and less han the wide area network. The communication of computers in a very small geographical area is known as local area network. Campus area network is a network which is restricted to the small geographical area which is limited to the university campus or a building. Personal area network is a network which is limited to an individual. Virtual private network is built on the principle of secure encrypted network in order to provide complete security to the users. The client server network is network which is connected to the LAN at one end and the back up server at the other end. When a computer uses network browser to connect to the other computers in the network it is known as network computing. Microsoft office online is the good example of such kind of network. Peer to peer network is used for connecting only those computers which have copy rights to use each others resources. Examples of a Telecommunication Network The first example of the telecommunication network is computer networks . computer network is set of computers which are attached to each other for the purpose of resource sharing. The second example is the internet. Internet is the global network which allows the users in many dispersed areas to connect via web browsers and telecommunication technologies provide by internet services providers. Third example is of the public switched telephone networks, it is a circuit switched network which used to carry analog signals but now it carries digital signals mostly. The fourth example is the working of global telex; it is a set of machines which include teleprinters and tele typewriters. The last example is of the aircraft communication addressing