A Computerized Payroll System

Theoretical 1. 0Introduction1 1. 1Statement of the Problem 1. 2Current condition of the Technology 1-2-1-4 1. 3Objectives 1-5 1. 3. 1General Problem 1-5 1. 3. 2Specific Problem 1-5 †1-6 1. 3. 3General Objectives1-6 1. 3. 4Specific Objectives 1-6 †1-7 1. 3. 5Scope and Limitations 1-7 †1-9 2. 0Theoretical Framework2-1 2. 1Introduction 2-1 2. 2Database Management 2. 3Information System2 2. 4Transaction Processing System2-3 2. 5Computer2-3 2. 5. 1Hardware2-3 2. 5. 2Software2-4 2. 5. 3Microsoft Access2-4 2. 5. 4Microsoft Word2-4 3. A Computerized Payroll System for Arias Garments 3-1 3. 1. Presentation 3-1 3. 2 System Design Specification 3-1 3. 3 System Development Life Cycle Diagram 3-2 †3-4 3. 3. 1. Framework Planning 3-2 3. 3. 2. Framework Analysis 3. 3. 3. Framework Design 3. 3. 4. Framework Implementation3-4 3. 3. 5. Framework Maintenance 3-4 Data Flow Diagram of Regular Employees (Current System) 3-5 Data Flow Diagram of Contractual Employees (Current System) 3- 6 3. 3 Proposed Data Diagram 3-7-3-8 3. 4 Entity Relationship Diagram 3-9 3. 5 Input Specification 3-10-3-12 Information Structure of Database: Personal Data 3-10 Data Structure of Database: Regular payroll3-10-3-11 Data Structure of Database: Formula for Regular 3-10 Data Structure of Database: Contractual Payroll3-11-3-12 Data Structure of Database: Formula for Contractual 3-12 Data Structure of Database: Deductions 3-12 4. 0. Execution Analysis 4-1 4. 1. Presentation 4-1 4. 2. Exploratory 4. 3. Information Gathering Procedures and Output4-2 4. 3. 1. Meeting 4-2 4. 3. 2. Observation4-2 †4-3 4. 4. Research Method 4-3 4. 4. 1. Web 4-3 4. 4. 2. Library 4-4 5. 0. End 5-1 5. 1. Proposal 5-1-5-2 Appendices Appendix A (work plan) Appendix B (Certification and letter) Appendix C (transcript of meeting) Appendix D (test structures and reports) Appendix E (costs) Appendix f (screen shots) 1. 0 Introduction 1. 1Statement of the Problem Not such a long time ago, all payrolls used to be determined physically with no assistance from the PC. Professional’s bookkeepers contributed a ton of time and vitality into monitoring all worker information, documents and data, figuring month to month pay rates, benefits and duties. Also, they did this all by keeping various documents loaded up with track records for every single individual utilized. These days, in any case, thing are for more basic than they used to be. Since innovation is constantly committed to making thing simpler and better, a serious wide assortment of electronic finance framework is accessible to spare us from this dreary undertaking. Presently as opposed to keeping many documents and spending in less hours ascertaining, you should simply get a finance programming framework and let it accomplish the dreadful work. The automated finance framework sets aside time and cash simple to utilize and down to earth. Manual finance framework is performed completely by hand and can bring about finance blunders and normally moderate procedure. These days business foundation on partnership must utilize present day advances to make their assignments simpler and quicker, innovations that will help individuals to take care of complex issues. Organizations needs advance framework that spares time and furthermore secure. The greater part of organization presently utilizes modernized finance framework. A mechanized finance framework won't just purpose troublesome issues yet in addition it will give quick process and exact computation of the compensation. 1. 2Current State of the Technology Exchange handling frameworks offer ventures the way to quickly process exchanges to guarantee the smooth progression of information and the movement of procedures all through the undertaking. Dealing with a finance framework physically is a repetitive employment. Hours worked, charges, and government reasoning are determined y hand, mistake in calculation can happen subsequently. Ensuring that every worker is paid as needs be and on time is an administration obligation that ought to be painstakingly arranged and executed. Inability to deal with a finance adequately may cause numerous issues for the organization and its workers. It could mean loss of cash, respectability, and trust between the two gatherings. In many cases, it takes numerous long stretches of work and labor to take care of business. In specific cases, successful finance the board is undermined by the absence of a compelling framework. Most organizations may have enough labor and assets. Be that as it may, with a compelling data innovation, dealing with a finance will be easier, financially savvy, convenient and dependable. One of the organizations that utilization manual finance framework is the Arias Garments. It was set up last September 18, 1994 at #88 Bargy. Latag, Lipa City, under the administration of Mr. Alex Arias together with his better half Mrs. Anita Carol Katigbak. It began with just forty machines and ten workers. The capital of Arias Garments is Php 500,000. 00. By 1996, Arias Garments turned into the subcontractor of Champan Garments. Champan Garments produce and transport items like Gap, Banana Republic, Old Navy, Tommy, and Hilfinger. Starting at now, Arias Garments have 176 machines and 100 representatives (40 ordinary and 60 authoritative). 8:00AM is the time-in of workers, 4:00PM is the break, and they think about 8:15AM as late. Representatives who are late or either log-out sooner than 4:00PM will have a reasoning on their wages (conclusion is 0. 61 every minutes late or under time). First offense, for late and workers who under time, will be given admonition, second and third offense is suspension and fourth offense is end. Assembling is their primary business, their product offerings are: Jeans, Skirts, and shorts for maternity, newborn children, and sorts. Their customers are from various nations: Japan, UK, Hongkong, China, and Taiwan. Arias Garments isn't permitted to sell or assembling item here in Philippines, since this is an understanding among Arias and Champan Garments. They likewise have customary and legally binding representative, with regards to compensation it is as yet the equivalent, Php293. 0 is the compensation rate every day. Standard workers have government benefits (SSS, PagIbig, and Phil wellbeing). Arias Garments is a lowest pay permitted by law worker that’s why they are paying the base sum on the administration finding. PagIbig conclusion is Php100. 00 every month, since week after week is the cut-off period Php100. 00 will be pa rtitioned by four in light of the fact that there are a month in a month; Php25. 00 is the reasoning for each cut-off period on PagIbig. In PhilHealth, Php50. 00 is the every month, so per cut-off period is Php12. 50. With respect to SSS derivation the Compliance Officer is given a table of finding given by SSS. Since representatives are the lowest pay permitted by law worker they need to pay Php133. multi month or Php33. 33 for each cut-off period. Legally binding workers don’t have benefits; it implies they don’t need to pay government derivation. Representatives of Arias Garments are not making good on charges, since they are the lowest pay permitted by law worker and don't get remittance from the organization, hence they are zero evaluated or tax exempt. Concerning occasion, representatives who work during occasion will have a twofold compensation. Ordinary representatives who worked, one year or more have an excursion leave ( strategy with respect to leave olicy is composed at the back part at supplement ___? ) They utilized day by day time card to screen the participation of representatives and each Thursday is their cut-off period. Bookkeeping Process is overseen by the Compliance Officer in particular, Mrs. Korina Navarro. She physically figures each day the employeeâ⠂¬â„¢s wages and vital conclusions, she went through three hours every day to complete and refresh the employee’s compensation. By glancing through the time card she figures out how to process the days functioned of 100 employees’s that causes wrong and postpone calculation of the week by week pay. Reports for SSS, PagIbig, and Phil wellbeing will be set up by the Compliance Officer that expend a large portion of her time in a day. Due to enormous number of Arias Garments workers, the Compliance Officer experience diverse issue like moderate exchange and off base calculation of wages and reasonings, incorrect report age and insufficient production of pay slip. 1. 3Objectives 1. 3. 1General Problem How to configuration, create and improve the present finance arrangement of Arias Garments? 1. 3. 2Specific Problem †¢How to include and refresh the employee’s record quicker? In view of meeting the Compliance Officer takes a greater amount of her time on including and refreshing employee’s record. As a result of enormous number of Arias Garments representative, it causes erroneous contribution on including and refreshing information. †¢How to make precise calculations of the employee’s finance? In light of the meeting led, the Compliance Officer of Arias Garments registers the employee’s compensation incorporates certain derivations (SSS, Phil Health and PagIbig) and fundamental leave, nonattendance, occasion pay, and under time that are painstakingly considered for the calculations of the net compensation physically. Trading and off base outcomes normally occurred. Arias Garments make their compensation slip physically additionally, for this situation the consistence official needs to take a gander at the table once more to check each of the employee’s pay and record it on a compensation slip to formalized the pay moderate exchange and incorrect compensation slip is the regularly result. †¢How to limit the time setting up the week after week representative reports? In light of perception the consistence official is the one in particular who readies the week by week worker reports that devour a large portion of her time in a day. Arias Garments observing framework is executed physically, hence creating reports expend additional time. 1. 3. 3General destinations This investigation intends to improve the present finance arrangement of Arias Garments by creating and planning an automated finance. 1. 3. 4Specific Objectives Specifically, the examination points: †¢To build up an Information Module that will contain individual data of representatives. This module will improve the methods of including and refreshing documents and record of workers of Arias Garments using mechanized finance data