A Computerized Payroll System

Unique 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. Test 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 great deal of time and vitality into monitoring all worker information, documents and data, figuring month to month pay rates, benefits and charges. What's more, they did this all by keeping various documents loaded up with track records for every single individual utilized. These days, be that as it may, thing are for more straightforward than they used to be. Since innovation is constantly devoted to making thing simpler and better, a significant wide assortment of automated finance framework is accessible to spare us from this dull assignment. Presently as opposed to keeping many records and spending in less hours figuring, you should simply get a finance programming framework and let it accomplish the awful work. The automated finance framework sets aside time and cash simple to utilize and commonsense. Manual finance framework is performed totally by hand and can bring about finance mistakes and normally moderate procedure. These days business foundation on enterprise must utilize current innovations to make their errands simpler and quicker, advances that will help individuals to take care of complex issues. Organizations needs advance framework that spares time and furthermore secure. The vast majority 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 precise count of the compensation. 1. 2Current State of the Technology Exchange handling frameworks offer undertakings the way to quickly process exchanges to guarantee the smooth progression of information and the movement of procedures all through the endeavor. Dealing with a finance framework physically is a repetitive employment. Hours worked, expenses, and government derivation are determined y hand, mistake in calculation can happen thus. Ensuring that every worker is paid as needs be and on time is an administration obligation that ought to be deliberately arranged and executed. Inability to deal with a finance adequately may cause numerous issues for the organization and its representatives. It could mean loss of cash, uprightness, and trust between the two gatherings. Regularly, it takes numerous long stretches of work and labor to take care of business. In specific cases, successful finance the executives is undermined by the absence of a compelling framework. Most organizations may have enough labor and assets. Notwithstanding, with a compelling data innovation, dealing with a finance will be less complex, financially savvy, auspicious 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 workers (40 ordinary and 60 legally binding). 8:00AM is the time-in of representatives, 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 conclusion on their wages (finding is 0. 61 every minutes late or under time). First offense, for late and representatives 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, babies, 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 additionally have standard and legally binding worker, with regards to pay it is as yet the equivalent, Php293. 0 is the compensation rate every day. Ordinary 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 conclusion. PagIbig derivation is Php100. 00 every month, since week after week is the cut-off period Php100. 00 will be separated by fo ur in light of the fact that there are a month in a month; Php25. 00 is the derivation for every cut-off period on PagIbig. In PhilHealth, Php50. 00 is the every month, so per cut-off period is Php12. 50. Concerning SSS finding the Compliance Officer is given a table of conclusion given by SSS. Since workers are the lowest pay permitted by law worker they need to pay Php133. multi month or Php33. 33 for every cut-off period. Authoritative workers don’t have benefits; it implies they don’t need to pay government conclusion. Workers 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, in this way they are zero appraised or tax exempt. With respect to occasion, representatives who work during occasion will have a twofold compensation. Ordinary representatives who worked, one year or more have a get-away leave ( approach with respect to leave olicy is composed at the back part at addendum ___? ) 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 to be specific, Mrs. Korina Navarro. She physically processes each day the employee’s wages and fundamental findings, 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 off base and postpone calculation of the week by week compensation. Reports for SSS, PagIbig, and Phil wellbeing will be set up by the Compliance Officer that expend the greater part of her time in a day. In view of enormous number of Arias Garments workers, the Compliance Officer experience diverse issue like moderate exchange and erroneous calculation of wages and derivations, off base report age and ineffectual formation 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 light of meeting the Compliance Officer takes a greater amount of her time on including and refreshing employee’s record. In view of enormous number of Arias Garments representative, it causes mistaken contribution on including and refreshing information. †¢How to make precise calculations of the employee’s finance? In view of the meeting led, the Compliance Officer of Arias Garments processes the employee’s pay 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 erroneous outcomes generally occurred. Arias Garments make their compensation slip physically likewise, 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 mistaken compensation slip is the frequently result. †¢How to limit the time setting up the week after week worker reports? In light of perception the consistence official is the one in particular who readies the week after week representative reports that expend the greater part of her time in a day. Arias Garments observing framework is executed physically, along these lines creating reports expend additional time. 1. 3. 3General destinations This investigation means to improve the present finance arrangement of Arias Garments by creating and planning a modernized finance. 1. 3. 4Specific Objectives Specifically, the examination points: †¢To build up an Information Module that will contain individual data of workers. This module will improve the techniques of including and refreshing documents and record of workers of Arias Garments using automated finance information