Wednesday, March 6, 2019

Attendance Monitoring with Payroll System

att stop overance monitor WITH PAYROLL SYSTEM FOR CYCLEMAR CALOOCAN plenty A re primary(prenominal)s summary and bearing give Presented to Quezon City polytechnic University San Bartolome In Partial Fulfillment of the Requirements for the Degree of Bachelor of Science in entropy Technology by Tahum, Marilyn T. Desuyo, gilbert D. Co, Joseph Darwin C. Lim, Tom Angel L. prof Mary Joy D. Vinas prof Elimar Ravina October 2011 SAD COORDINATOR AND ISs HEAD espousal SHEET This form Analysis and Design Project entitled attention MONITORING WITH PAYROLL SYSTEM FOR CYCLEMAR CALOOCAN CORPORATION later on having been recommended and approved is herewith accepted by the assureation technology Department of Quezon City polytechnic institute University San Bartolome ______________________ Ms. Lorena A. Tayamora SAD Coordinator ______________________ Ms. Maria Aura Impang IS Head October 3, 2011 PANELS appla consumption SHEET This dust Analysis and Design Project entitled ATTENDANCE MONITORING WITH PAYROLL SYSTEM FOR CYCLEMAR CALOOCAN CORPORATION intermited by Desuyo, Gilbert D. Co, Joseph Darwin C. Lim, Tom Angel L. Tahum, Marilyn T. afterwards having been presented is hereby approved y the pas conviction members of the panel _____________________________________ Pane joust Pane tend October 3, 2011 October 3, 2011 ______________________ Lead Panelist October 3, 2011 ACKNOWLEDGEMENT above altogether, the prop binglents would alike(p) to thank the ever loving God for giving them the experience and patience to finish this re hunt club. The researchers would like to express their sincerest gratitude to their p atomic number 18nts for their untiring support emotion eithery and fiscally. The counselors atomic number 18 in any case thankful to Professor Mary Joy D. Vinas for modify the commencement, second and third chapters of this research.Special thanks to their parents, and friends who supported them. The proponents would like to pop run into t heir appreciation to daily roundmar Caloo potful Corporation who bequeathingly cooperates for the say athletic field. To their classmates who allow minded(p) ideal support and assurance, thank you for your succession and effort. To all the people who give way been the instruments for the action of this research, thank you very much ABSTRACT proposeationATTENDANCE MONITORING WITH PAYROLL SYSTEM Proponents GILBERT D. DESUYO JOSEPH DARWIN C. CO TOM ANGEL L. LIM MARILYN TAHUM Professor Prof.Mary Joy Daniel Vinas Prof. Elimar Ravina Degree Bachelor of Science in breeding Technology Date Completed October 2011 Statement of the chore The CYCLEMAR CALOOCAN CORPORATION is a caller-out located at 10th avenue Caloocan City. By conducting a phoner visit and interviews, the proponents found out that the society habits a Bundy time in their attention supervise and utilise a manual motion for the constitutesheet. A chore that is ob serviced apply the manual dodging o f rules is the absquatulate of while or the accelerate of the emergence in all(prenominal) payslip. other task is a secure place for track record.From employ clock snip card and payslips, the companys rungs use ledgers for the motions. As a solution to this, the proponents proposed a computerized strategy to be evaluated by Cyclemar. The proponents believe that the computerized agreement can give solution to their problems. Through computerization, these monitoring can be turned with change magnitude speed, since their sheer volume would easily overwhelm any manual brass. In developing the formation, the proponents have ga at that placed the experience, software computer programme and hardware requirements that are needed for the evaluation of the computerized arrangement.In the end of the moot, the proponents expect good results at the end of the evaluation. Hypothesis There is significant variance between the proposed and the exist strategy in terms of accuracy, effectiveness, reliability, security and speed. methodological analysis The proponents utilize fountainheadnaires for the gathering of training needed in determining the problems met by the employees of the Cyclemar Caloocan Corporation. Informal interview, observations and actual experiences of one of the proponents were in addition embroild in constructing the questionnaire.The questionnaire consisted of criteria that measure the manual arranging in terms of accuracy, effectiveness, reliability, security and speed. The first draft of the questionnaire was submitted to the professor of the proponents for corrections and suggestions. afterward the validity and reliability of the questionnaire has been established, the investigators then sought the approval of their Professor as well as the maker of the Cyclemar Caloocan Corporation to allow them to conduct the study. After the approval of these authorities, the proponents administered the questionnaires.By the cartridge clip the survey questionnaires were answered by the respondents, the proponents had gathered forrader the results were tallied for evaluation and interpretation. The employees of Cyclemar Caloocan Corporation were the respondents of this study. In finding out the problems, the employees and regular members were the origin of selective t all(prenominal)ing. On the other hand, the employees were the ones to evaluate the performance of the alert and the proposed remains. Findings The findings of this study are presented as follows 1.The proponents found out that the following features should be included in the proposed transcription to design a remains that can provide selective information repository for the attention observe and history transactions in a computerized format, and that is cap fit of adding, computing, editing, deleting employees, searching records and generating reports a. Easy access buttons b. Search bars c. b repair for the interface d. Summary /history of the payroll transactions e. Generated reports f. Automatic computing g. Different take aim of access h. Error messages for wrong inputs i. Restoration of entropybase j. Back-up for database k. shortcut keys l. entropybase for username and password 2. The proponents found out that 100% of the employees believed that automatic computation and search bars should be included in the system to eliminate the outcome in payroll transactions and in searching and retrieving employees records. sulphur to the most needed features for the proposed system is the automatic computation in which surgical result go forth be computed in a short stage of time. summateitionally the proponents found out that there is no significant deviance between the proposed and the existing system in terms of accuracy, effectiveness, reliability, security and speed.The computed t-value of the proposed and existing system generally is greater than the critical value hence the worthless hypothe sis is rejected. Conclusions The proponents conclude that the most common problem of the company is the speed for which 27% of the employees believed that the system is speedy or 73% believed that the existing system does cause frequent delays in the companys payroll transactions. In the proposed system in which the employees were the evaluator in terms of the five criteria utter above, the arithmetic weighted mean of speed increases from 2. 15 or bonnie in the existing system to 4. 2 or excellent in the proposed system. It shows that the proposed system provide serve well the employees to get across membership application savings deposit transaction, withdrawal of savings transaction, loan approval transaction, and loan run and loan payment in a speedy way. Recommendations Based on the findings and conclusion derived from this study, the proponents post the following recommendations 1. The attention monitor with payroll system of Cyclemar Caloocan Corporation entrust be imp lemented in the company so that the time-consuming and complex log-in/log-out of the employees bequeath be simplified and speedy. . digital signatures such(prenominal) as bar code lecturer pass on be used to determine the employees identity. 3. The payroll of the employees in the Accounting separate entrust be included in the system. TABLE OF CONTENTS Title Page i Acceptance planing automobileii Approval Sheetiii Dedication iv Acknowledgement . vi Abstract. septet List of turn offsxii List of genss. .. xiv CHAPTER I. THE PROBLEM AND ITS BACKGROUND mise en scene of the Study1 Organizational Directory 1. Organizational Chart2 2. Duties and Responsibility3 Objectives of the Study 10 1. General Objectives10 2. Specific Objectives10 logical implication of the Study11 Scope and confinement13 Scopeof the Study13 Limitations of the Study13 Definition of Terms 14 CHAPTER IIREVIEW OF relate LITERATURE AND STUDIES outside(prenominal) and local belles-lettres16 Foreign and L ocal Studies18 Methodology of the Study20 1. Theoretical exemplar22 2. Conceptual Framework24 CHAPTER IIISYSTEM PLANNINGA. comment of the Existing frame27 1. background plot27 2. DFD Diagram28 B.Problem Definition30 1. Problem Description30 2. Anticipated Business Benefits30 3. System Capabilities31 C. Project feasibleness32 1. Project Development Cost32 2. Cost Benefit Analysis33 a. Existing System33 b. Proposed System37 CHAPTER IVSYSTEM ANALYSISA. Information Gathering Tools and Techniques41 1. Questionnaire41 2. Interview Guide41 B. Description of the Proposed System42 C. System Requirement Model421. Event Table42 2. Context Diagram/DFD Diagram/ wasting disease Case Diagram43 3. System menstruumchart/ operation Diagram/Sequence Diagram45 4.Location Diagram50 CHAPTER VSYSTEM DESIGN A. Systems Design Models51 1. Screen Layout51 2. hatch Layout55 B. Database Design56 1. Table Description in Normalized bound56 2. Table affinitys/Entity Relationship Diagram57 3. Data Struct ure58 4. Data Dictionary60 CHAPTER VIRECOMMENDATIONConclusion 62 Justification63 APPENDIX Project Schedule and Work Assignment / Gantt ChartA CertificationsB counterpart of InterviewC Survey unionizes/ QuestionnairesD Sample painss and ReportsE Screen Design F .Users ManualG syllabus ListingH Floor Plan / Ne twork LayoutI On Field PhotographJBIBLIOGRAPHY PERSONAL VITAE CHAPTERI THE PROBLEM AND ITS BACKGROUND Background of the Study Cyclemar Caloocan Corporation has a rate of flow system that is accessible to all employees. Which found out that Bundy clock is used to monitor their employees attending and for their payroll. The system cannot provide the convenience because of wish of organize records. The system is also not reliable for subdivisions because it is not updated and accomplishable to going away of data. Mr. Romeo Bautista is the owner of Cyclemar Caloocan Corporation located at 336 10th roadway Grace Park Caloocan City. In 1962, Mr.Bautista started a subscribe r line by selling of bicycles and foreswear separate with a few employees then, the number of employees increase up to present date with multiple numbers of employees and five (5) departments. In 1969, the company started selling motorcycles and spare parts, and then in 1985, they built motorcycle units with spare parts. This is the place where you can buy genuine, OEM and replacement parts for Kawasaki, Yamaha, Suzuki, Honda, China and chinaware motorcycles and scooters and wide and secured space for alterings and installment of accessories for your motorcycle and/or scooter.They also are accepting wholesale and retail of motorcycle spare parts. And now they are looking forward to become one of the Philippines leading suppliers of bikes and motorcycle. Currently, the company is self-made since its establishment in 1962. Organizational directory 1. Organizational Chart Figure 1. 1 Organizational chart 2. Duties and Responsibility comptroller Prepare profit and loss statement s and monthly finis and cost accounting reports. Compile and analyze financial information to prepare entries to accounts, such as general ledger accounts, and muniment business transactions. Establish, keep au courant, and coordinate the implementation of accounting and accounting control procedures. discerp and review budgets and expenses for local, state, federal, and private funding, contracts, and grants. Monitor and review accounting and related system reports for accuracy and completeness. Prepare and review budget, revenue, expense, payroll entries, invoices, and other accounting documents. lose it revenue and expenditure trends and recommend appropriate budget levels, and ensure expenditure control. Explain billing invoices and accounting policies to staff, vendors and clients. Resolve accounting discrepancies. Recommend, develop and maintain financial data bases, computer software systems and manual filing systems. supervise the input and handling of financ ial data and reports for the companys automated financial systems. act with internal and external auditors in completing audits. Other duties as depute Human Resource circumspection interlocking and Recruiting Interviewing, recruiting, testing, temporary labor coordination. grooming and Development Orientation, performance centering, skills training, productivity enhancement. CompensationWage and salary administration, capriole descriptions, executive compensation, incentive pay, job evaluation. Benefits Insurance, vacation leave administration, retirement plans, profit sharing, stock plans. Employee Services Employee give earance programs, relocation services, outplacement services. Employee and Community Relations federal agency surveys, labor relations, issuings, labor law compliance, discipline force out Records Information system records. Health and Safety Safety inspection, drug testing, health, and wellness. Strategic Planning pla passary human resources, forec asting, planning, mergers and acquisitions.Sales administrator oppose Market Awareness In order to tailor their megascopic revenue pitches, sales executives need to keep abreast of changes in the market that impact their target audience. They moldiness reckon dips and rises in demand for clients products, lifetime and wear of machinery, and changes in the stock market that whitethorn hinder sales. In plus, they should be aware of the sales strategies of competitors, both for their business and their clients businesses. The more alert a sales executive is, the more accurately the necessarily of nodes are targeted and unexampled market opportunities identified.Meet a shadow Line Most sales executives have quarterly and annual sales goals that they strive to make full through with(predicate)out the year. To do so, they attempt to convince existing clients to increase their purchases from the companya process which is called upsellingor search for new clients. Often, sal es executives operate on the idea that it takes less effort to moderate current customers than to find new ones, and, therefore, focus their energy on upselling. Maintain Relationships A sales executive is often a master of relationships with clients, vendors and employees.A good relationship can lead to new sales leads, increased purchasing and referrals. Sales executives put a great deal of time and energy into creating and nurturing their relationships, and make a point to offer value and opportunity wherever manageable. Manage a Territory Depending on the nature of a business, a sales executive may be creditworthy for taking care of clients in a geographic region and be the person called with problems. Managing a specific sales territory often involves travel to meet with customers and suppliers to ensure that operations are smooth and to reinforce the strength of the relationship. negociate Contracts For ongoing throws or large orders, a sales executive is responsible for negotiating the terms of the sale and drawing up a contract. This ensures that both parties understand what is and is not included in the order and protects against liability. In the sale of equipment, for example, a sales executive may negotiate prices for the setup, installation and testing, in addition to the initial purchase. Retail Salesmen Sales Retail salesmen often make sales presentations to customers.They may show customers a variety of products and explain the features and benefits of each, to help the customer make an informed decision about a purchase. They also inform the customer of any sales or promotions that are currently afoot(predicate) or happening in the near prospective. Once the customer makes a decision, the salesman may also process the transaction. Customer Service Retail salesmen assist customers in locating store merchandise and handling product returns. whatsoever(a) salesmen may customize a product to meet a customers needs, such as in a mens c lothing store, where a salesman measures a customer for a suit fitting.They may also assist customers by carrying large items, like televisions, to their cars. Merchandising When there are no customers in their department or in the store, salesmen may perform merchandising functions. This includes grammatical construction product displays and rearranging products on the shelf in accordance with a mold layout, known as a planogram. They may also change set on sales and promotional items. Store Operations In some retail establishments the salesmen will be responsible for opening or closing a store.If opening a store, the salesman must arrive in proceed of the opening time to ensure that the store is telly for the mean solar days customers. When closing, duties may include reconciling cash registers and taking the days cash receipts to the bank for deposit. Management Functions Some salesmen may also have the responsibility of managing a department in addition to their sales duties. This can involve ordering merchandise, devising work schedules and supervising the activities of other salesmen. Department managers are usually held accountable for the profitability of their departments in addition to making sales. bread and butter Manager lay down a well-operated maintenance team. Assist and supervise maintenance team to handle all maintenance works. Maintain and manage highly automated office equipment. Maintain efficiency levels. Prepare maintenance budget. Initiate spare parts planning and second sourcing. Support staff and force to improve product achievements. Review and evaluate maintenance operations. Improvise maintenance operations to hand over on costs and work time. Implement best practices, standards and procedures in all maintenance functionalities. single-valued function supply Capable of handling day to day office work like filing, bank related work, other national work. Assisting in office chores Co-coordinating with ve ndors. Maintenance lag Background Though specialists can develop expertise in only one trade like carpentry or plumbing, maintenance workers must be skilled in several crafts so that they can work on all problems that develop in a business. Duties Maintenance workers repair and maintain machines, diagnose and repair electrical or plumbing problems, paint and fix the facility structure, and queue up computer, heating or cooling systems.Objectives of the Study 1. General Objective The main objective of the study is to enhance the attending monitoring system using a barcode scanner that will improve the daily attendance as well as salary process of each employee efficient. 2. Specific Objectives The study aims to have user maintenance that will secure the system towards the non-trusted personnel or those people outside the office. The study aims to require a difference from their current when it comes to the design. The study aims to strengthen a module for attendance monitor ing of the employees. The study aims to developed efficiently salary of each employee The study aims to gain a module that will give a summarize list of report of the payroll of the employees. Significance of the Study This study will have significant effort in promoting the good work environment in workplace and motivations of its employees. This will become beneficial to the employer and employee in strategic focusing. By understanding the attendance monitoring and benefits of payroll processing, this research will be assured of a competitive advantage.Moreover, this study will be accommodative to the management and business practitioners in training and informing them in the theater of operations of human resources management, objectives, and strategies. It will also serve as a future reference for researchers on the subject of human resources and corporate companies. And importantly, this research will educate employee in deciding on whether an exertion e. g. business indu stry is really fulfilling its responsibility to the community or is just showing off to promote the management. COMPANYAfter the implementation, the system will be able to meet all the need of the company regarding the attendance monitoring and payroll process made in the company. It also provides efficient slipway on the employees record. MANAGEMENT Regarding the attendance monitoring with payroll made in the company, the management will also be benefited when it comes to managing and manipulating payroll process. It also provides reports that will help the management to view all records of the employee study made inside. PERSONNEL military unit and staff/employee will be the only that is most important because they are the one who will used and focus the system.They will have a clear understanding about the system because of the clear and appropriate design made by the proponents. They will also have a genial and easy monitoring of Daily Time Record (DTR) of the employees. PROP ONENTS This project helps the proponent to enhance their technical skills, communication skills, project management skills, interpersonal skills and also in programming skills. Aside from that, the proponent will have a better understanding regarding the attendance monitoring with payroll system by the management. Scope and Limitation Scope of the studyThis study attention supervise with Payroll System will enhance the capability of the attendance in Cyclemar Corporation by changing from Bundy clock to Bar code referee monitoring twisting of the employee for making efficient payroll system. It includes the features that can Add Employees record, Edit Employees information, Delete Employees record, print / Save the Pay Slip of each employee and Updating Employees information as well as the Weekly Salary, hard cash advance, the rate per day, overtime, Gross payment, Net pay, and Deduction such as refuse tax and SSS, adding up with a log-in log-out process for security purpose.Li mitation of the study The study, Attendance supervise with Payroll System does not secure the attendance of executive staff such as the Owner, trainees and security staff such as the security guard due to the company pays them through a security agency. excessively the study does not cover the sales and inventory of the company and the Accounting department will only use the system for the salaries and wages of the employees and other accounting functions are not covered.Also the HR department will only use to check and bank the attendance of the employees and does not cover the other functions of the HR such as hiring new employees. /Definition of Terms Attendance the number of employees present Barcode proofreader Is an electronic device for reading printedbarcodes. Like aflatbed scanner, it consists of a light source, a lens and a light sensor translating opthalmic impulses into electrical ones. Additionally, n proto(prenominal) all barcode readers containdecodercircuitry an alyzing the barcodes image data provided by the sensor and sending the barcodes content to the scanners utput port. Bundy time A time clock, sometimes known as a clock card machine or punch clock or time recorder. calculating machine software Is the collection of computer programs and related data that provide the instructions tattle a computer what to do. Database Is an organized collection ofdatafor one or more purposes, usually in digital form. The data are typically organized to model relevant aspects of reality. DTR Daily Time Record list of the log-in / log-out record of the employee.Employee A person in the service of another(prenominal) under any contract of hire, express or implied, oral or written, where the employer has the power or right to control and direct the employee in the existent details of how the work is to be performed. Lilo Log-in and Log-out. operating(a) system (OS) Is a set of system software programs in a computer that regulate the ways application so ftware programs use the computer hardware and the ways that users control the computer. Original equipment manufacturer (OEM) Refers to the company that sea captainly manufactured the product.When referring to self-propelling parts, OEM designates a replacement part made by the manufacturer of the original part. Pay slip Is traditionally a paper document (acheque) issued by anemployertopayan employeefor services rendered. In recent times, the physical paycheck has been more and more replaced by electronicdirect depositto bank accounts. Such employees may keep mum receive a pay slip, but any given up cheque is marked asnon-negotiableand cannot be cashed. Payroll Is the sum of allfinancialrecords ofsalariesfor an employee,wages, bonuses anddeductions.In accounting, payroll refers to the amount paid to employees for services they provided during a certain period of time. SQL (Structured Query Language) is aprogramming languagedesigned for managing data inrelational database managem ent systems(RDBMS). System a system of elements that cross in the manner of threads in a net that are related or connected may fluctuate in quantity and value. System Development Life Cycle (SDLC) Is the process of creating or altering systems, and the models and methodologies that people use to develop of these systems.Visual Basic . concluding (VB. lowest) Is a version of Microsofts Visual Basic that was designed, as part of the companys . NET product group, to make Web services applications easier to develop. CHAPTERII REVIEW OF RELATED LITERATURE AND STUDIES Foreign and Local Literature Foreign Literature correspond to Primer (2005), for umpteen businesses automating the collecting of employee attendance data when employees begin their shifts is still a manualprocess.Even business that has automated or computerized processes such as scheduling, inventory, purchasing, general ledger and payroll processing still use manual methods such as time cards or attendance sheets to col lect time and attendance data. NOVAtime (2007), the system that will give management the power to not only utilize the tools we have available to us today, but will continue to grow and evolve, giving it the capability to co-ordinated and utilize the tools the new millennium promises to bring us. NOVAtime has brought a system designed for growth while maintaining the maximum in flexibility.Where the sophistication lies within the programmed apparatus of the system, allowing for a quick and simple implementation and employee training cycle. After all the true test of a system is not only in the production and wealth ofreporting, but in the simplicity and ease of its operation, in conjunction with a simple and accommodating implementation program. Local Literature Aquilan (2004) made a comparable thesis on the automation of time attendance that records the time in and time out of every employee using barcode system.It tends to eliminate the manual recording system of time and attend ance and also include salary computation of each employee based on the time and attendance reports. Ramon Faloran (2005) wrote in the article The Computer Edge of the New Employment and Opportunities in the Philippine Daily Inquirer. He stated that computer gives you a different feeling about what is happening in the company. Business will be highly competitive and innovative because the computer provides instant information. Cantoma (2004) in her thesis entitled Computer Library System for St.James honorary society stated that, in manual system in retrieving, maintaining security and bundle records take place because of the years gone by. Furthermore, these files were only kept in envelopes and folders in wooden rocks. There are also instances when the right information is given to a wrong person, which affect quality of service. Foreign and Local Studies Foreign Study Columbia State Community College (2006) uses computer acknowledgement account (Log In earn and Password) for ac cess to the institutions computer usage logs occurs electrically through the individual users log in/out process.Users are also informed that they are responsible for any computer files, database and/orinternet sites that are accessed through their computer identification account, notwithstanding their misery to adhere to the log in/out process, on their voluntarypublication of their account information to others. Local Studies Mendrez (2007) made a similar study for Vision Designer Inc. It has an identification machine aimed at verifying a person entering through the swiping ofidentification cards. After entering their given code number, the identification cards are swiped in the machines card reader to trigger the verification.If access granted, the micro switch will then automatically unlock to allow enter. This will help a lot in monitoring attendances accurately and more precise. A group of computer engineers in Rebisco Biscuits Corporation proposed a thesis report for what i s the same Innodata Corps is implementing right now computerized daily time record as an alternative for Bundy clock. The kernel ofacquiring inside the company premises is by swiping cards into a machine that reads every record of each employee then monitor and displays the time a particularemployee logs in and out.In the 2005 annual report of the tone Products Research and Development Institute under the Department of Science and Technology, it is said that, The computerized database and attendance on Forest Products Research and Development Institute was designed to facilitate the Institutes data entry,processing, computation and maintenance of employee time and attendance transactions. The system allows employees to log in/out as the swipe their IDs through a barcode reader attached to a computer terminal. The processing forms include those for legal holidays, travel order, tardiness, under time, vacation and sickleave.Pertinent Report forms have been designed for easier acces s to all these data. Attendance Monitoring with Payroll System Attendance Monitoring with Payroll System is the key to proficient and prospering time tracking and management in your workplace. It is a software-based time and attendance system that allows the user to collect and organize employee time data but and accurately. You can use our system to Easily and efficiently track your employee time. Manage your time & attendance data and employee profiles. Reduce the headaches and time associated with payroll.Best of all, Our Attendance Monitoring with Payroll System can quickly pay for itself in time savings, reduction of time theft and elimination of payroll errors. Methodology of the Study software package Development Life Cycle (SDLC) Model Employee The relevance of System Development Life Cycle to this study is that it typically provides an climb in problem solving and is made up of several phases. The SDLC begin explains that a project must have requirement analysis an d how project planning begins that is essential for this research.The proponents use a use case draw because it describes a sequence of actions that provide something of measurable value to an instrument and is worn as a horizontal ellipse. This study need to use an Use Case Development life Cycle because it typically explain the activities performed in a software development project such as requirements description of steps or actions between a user or actor and a software system which leads the user towards something useful. The proponents chose this because documentation is produced at an early stage of the development.The requirement analysis identifies and defines the need for the new system. It analyzes the information needs of the end users and creates a blueprint with the necessary specifications for the hardware, software, people and data resources. In the design phase, the proponents made a plan on how to solve the problems specify by the requirement document. It is als o in this phase where the proponents identified the modules to be developed on the software to produce the desired results 1. Theoretical Framework Figure 2. 2 The diagram in figure 2. shows the theoretical fashion model of Attendance Monitoring with Payroll system. The study was from the concept of Transaction process System (TPS). The input starts when the employee log-in and log-out through barcode reader, in which the system will automatically read each barcode ID. The process inside the system includes the process being made between the employee and accounting department. The system computes the number of hours which the employee attendance by the Daily time Record (DTR), the attendance made as well as payroll.The system also store and display data about how employee transact with the accounting department. The attendance report by the company was save in the database. All process being made is recorded in the system. As a log-in and log-out being processed by the system, it is capable of generating reports like the number of hour attends taxes, net par and gross pay as well as salary. This process will serve as a summary of information from the system as an attendance monitoring. 2. Conceptual frameworkOn the basis of the foregoing concepts, theories, and findings of related literature, studies and insights taken from them, a conceptual model is develop as shown below foreplay PROCESS sidetrack Knowledge Requirements System Analysis a.Barcode reader Attendance monitoring using barcode reader with payroll a. Requirement Analysis system for CycleMar Caloocan b.Requirement Definition Corporation Software Design a. Windows 7 OS a. Software Engineering b. Visual Studio 9 Life Cycle c. MySQL b. System Flowchart c.Context Diagram hardware Requirements d. Data Flow Diagram - 1GB Memory -Intel Dual Core System Development -Optical cringe a. Scheduling of Activities -bar code reader b.Program Coding Figure 2. 3 input signal 1. Knowledge Requirements The following are the knowledge requirements for the study. The proponents must have knowledge on barcode reader.The team must also have knowledge regarding Payroll system how they work and processes involved inside attendance monitoring with payroll system. 2. Software Requirements These are the software requirements of the system. The proponents used Windows 7 as their Operating System and Visual Studio 9 as their programming language. In their system database, the proponents used MySQL for storing of data and information. 3. Hardware Requirements There are two hardware requirements for the study. The processor of the computer must at least be Pentium IV and the RAM memory is 1GB. Barcode reader will be used to scan the barcode image printed in the employees ID. PROCESS 1. System AnalysisThe proponents must analyze the companys problem in order to design a system based on the nee ds of the company. They identified the companys problem and specify a solution gibe to the problem. The proponents conducted interview and gathered information about the process under existing system of the company. 2. System Design The proponents designed a computerized system on attendance monitoring and payroll system. The number of hours will be recorded to the computer-based log-in and log-out system database. If an employee scans his/her appointment Card (ID), the system will record his/her log-in time and when the employee logs-out, the employee will scan again his/her I. D.Then when the payday comes, the accountant will release the pay slip of the employees. 3. System Development The proponents had six (6) months to do the research. In the first two months, the team gathered all the needed information for the study. On the third month, the team made the systems flowchart and program flowchart. The third and fourth months, the team did the encoding of program, the making an d designing of the database, connecting the barcode device to the system and database. On the fifth and sixth months, the system was evaluated and tested according to its function. The proponents expected the barcode reader was to be more or less than Php 2,000. 00 I. OUTPUTAfter the planning stage, gathering of relevant information, making and debugging the program and after six consecutive months of making the study, the computerized log-in and log-out was developed. The performance of this system will be tested by conducting lot of testing for trial and error. The system was evaluated by the company. CHAPTERIII SYSTEM PLANNING A. Description of the Existing System 1. Context Diagram Figure 3. 1 Context Diagram of attendance monitoring with payroll system 2. Data Flow Diagram Figure 3. 2. 1 attendance monitoring with payroll system Figure 3. 2. 2 Extracted data flow diagram for attendance monitoring. B. Problem Definition 1. Problem Description CycleMar Caloocan Corporation has a multiple number of employees that they managed in every department especially in the Retails and Whole Sales department.The problem was in the Attendance Monitoring and Payroll System. The company was using a Bundy Clock for their Attendance monitoring of the employees. The Bundy clock will not run if theres no time card. The problem occurs when the records of the Attendance is being process for their Payroll System. When the payroll was process, they will record the attendance of each employee manually. So, the attendance records of the employees save manually and it takes a lot of time consuming to do that. The other problem is the space need to store the used time cards. In the payroll system, they compute manually depend on the level of the salaries and deductions of each employee. 2. Anticipated Business BenefitsThe company benefits to be obtained from the new system for Attendance Monitoring for Payroll System for CycleMar Caloocan Corporation are to mix its technological com ponent. More immediate benefits include the following Computerized attendance Monitoring System Reduce data redundancy User friendly Monitoring System for Payroll System Easy to identify records develop a database server to support the monitoring and payroll records Secure records and information of the entire system come a data report Process transaction efficiency 3. System Capabilities To obtain corporation benefit listed previously, the users support subsystem will include the following capabilities. SUBSYSTEMS CAPABILITIES Attendance Monitoring Computerize Login and Logout to record data. Have an efficient Attendance Monitoring. Have a new and Effective device. (Barcode Reader) for employees ID. Application (Employee) Easy to record a new employees. Update employees record. Maintain reliable storage information of each employee. Payroll Have reliable records of the employees to compute salaries. Maintain reliable storage information of each employee in ter ms of salaries. Figure 3. 1 system capabilities C. Project Feasibility 1. Project Development Cost Personnel eyeshot Salary Project Manager PHP 25,000. 00 Senior Technical Specialist PHP 20,000. 00 System Analyst PHP 17,500. 0 Database Analyst PHP 16,500. 00 Programmer PHP 15,000. 00 tot up PHP 94,000. 00 Hardware Quantity special(prenominal) harm fundamental harm 3 Intel Celeron (PC Set) PHP 11,960. 00 PHP 35,880. 0 1 C10-W PHP 1,580. 00 PHP 1,580. 00 Contact Barcode digital scanner 1 TP-Link SF-1008D 8-port spank PHP 720. 00 PHP 720. 00 (Network Switch) 3 APC BE-500R-PH ES500va black PHP 2,540. 00 PHP 7,620. 0 (UPS/AVR) PHP 16,800. 00 PHP 45,800. 00 Software Quantity bad-tempered harm Total monetary value 3 Microsoft Windows 7 ProfessionalPHP 7,160. 00 PHP 21,480. 00 2 Microsoft Office 2010 Home and PHP 9,330. 00 PHP 18,660. 0 Business PHP 16,490. 00 PHP 40,140. 00 article of furniture and Fixtures Quantity event Price Total Price 2 Computer Chair PHP 770 PHP 2,310. 00 3 Office Table PHP 900 PHP 2,700. 0 PHP 1,670. 00 PHP 5,010. 00 Expenses Particular marrow Training Expenses PHP 15,000. 00 Transportation PHP 3,000. 00 PHP 18,000. 00 Summary Particular Amount Personnel PHP 94,000. 00 Hardware PHP 45,800. 00 Software PHP 40,140. 00 Furniture and Fixture PHP 5,010. 00 Expenses PHP 18,000. 0 PHP 202,950. 00 2. Cost Benefit Analysis Personnel Number No. of Working days Hours/Day value/Day Accountant Head 1 20,000. 00 20,000. 00 240,000. 00 Accountant 10 12,000. 00 12,000. 00 144,000. 00 Office ply 40 10,000. 00 10,000. 00 120,000. 0 Secretary 7 9,000. 00 9,000. 00 108,000. 00 Sales Executive Head 1 15,000. 00 15,000. 00 180,000. 00 Sales Executive 10 10,000. 00 10,000. 00 120,000. 00 Sales round 10 10,000. 00 10,000. 00 120,000. 00 Retail Head 1 22,000. 00 22,000. 00 264,000. 0 Sales Staff 50 10,000. 00 10,000. 00 120,000. 00 Maintenance Head 1 25,000. 00 25,000. 00 300,0 00. 00 Maintenance Staff 50 10,000. 00 10,000. 00 120,000. 00 Service advisor 20 12,000. 00 12,000. 00 144,000. 00 Unit Head 1 25,000. 0 25,000. 00 300,000. 00 Unit Staff 30 9,500. 00 9,500. 00 114,000. 00 2,187,178. 00 2,394,000. 00 Hardware Quantity Particular Price Total Price 1 Bundy Clock 3,500. 00 3,500. 00 Stationeries and Supplies Quantity Particular Price Total 200 pieces Time Card 119. 75 239. 50 1 pieces Ball pen 15. 00 15. 00 254. 50 Expenses Particular Amount Hardware PHP 3,500. 0 Stationeries and Supplies PHP 254. 50 Total PHP 3,754. 50 Summary Existing Cost Particular Amount Personnel PHP 2,394,000. 00 Expenses PHP 3,754. 0 Total PHP 2,397,754. 50 Present take to be Analysis Year Present Value (15%) Existing System 0 1. 000 2,397,754. 50 1 0. 869 2,083,648. 600 2 0. 756 1,812,702. 02 3 0. 657 1,575,324. 706 4 0. 572 1,372,515. 574 5 0. 497 1,191,683. 986 6 0. 432 1,035,829. 944 11,469,459. 712 An Analysis and Design of Cyclemar Caloocan Corporation B. Cost Analysis of the Proposed System Personnel Monthly Salary Personnel Number No. of Working Days Hours/Day Rate/Day System Administrator 2 13,000. 00 13,000. 00 312,000. 00 Accountant Head 1 20,000. 00 20,000. 00 240,000. 00 Accountant 10 12,000. 00 12,000. 00 144,000. 0 Office Staff 40 10,000. 00 10,000. 00 120,000. 00 Secretary 7 9,000. 00 9,000. 00 108,000. 00 Sales Executive Head 1 15,000. 00 15,000. 00 180,000. 00 Sales Executive 10 10,000. 00 10,000. 00 120,000. 00 Sales Staff 10 10,000. 00 10,000. 00 120,000. 0 Retail Head 1 22,000. 00 22,000. 00 264,000. 00 Sales Staff 50 10,000. 00 10,000. 00 120,000. 00 Maintenance Head 1 25,000. 00 25,000. 00 300,000. 00 Maintenance Staff 50 10,000. 00 10,000. 00 120,000. 00 Service Advisor 20 12,000. 00 12,000. 00 144,000. 0 Unit Head 1 25,000. 00 25,000. 00 300,000. 00 Unit Staff 30 9,500. 00 9,500. 00 114,000. 00 2,200,178. 00 2,706,000. 00 Hardware Quantity Particular Price Total Price 3 Intel Celeron (PC Set) PHP 11,960. 00 PHP 35,880. 0 1 C10-W PHP 1,580. 00 PHP 1,580. 00 Contact Barcode Scanner 1 TP-Link SF-1008D 8-port Switch PHP 720. 00 PHP 720. 00 (Network Switch) 3 APC BE-500R-PH ES500va black PHP 2,540. 00 PHP 7,620. 0 (UPS/AVR) PHP 16,800. 00 PHP 45,800. 00 Software Quantity Particular Price Total Price 3 Microsoft Windows 7 ProfessionalPHP 7,160. 00 PHP 21,480. 00 2 Microsoft Office 2010 Home and PHP 9,330. 00 PHP 18,660. 0 Business PHP 16,490. 00 PHP 40,140. 00 Furniture and Fixtures Quantity Particular Price Total Price 2 Computer Chair PHP 770 PHP 2,310. 00 3 Office Table PHP 900 PHP 2,700. 0 PHP 1,670. 00 PHP 5,010. 00 Stationeries and Supplies Quantity Particular Price Total 5 Ream Bond Paper 185. 00 925. 00 24 Black Ink 50. 00 1,200. 00 24 Color Ink 90. 0 2,160. 00 4,285. 00 Expenses Particular Existing System Proposed System Personnel 2,394,000. 00 2,706,000. 00 Hardware 3,500. 00 45,800. 00 Software 0. 0 40,140. 00 Furniture and Fixtures 0. 00 5,010. 00 Stationeries and Supplies 254. 50 4,285. 00 Equipment annual Maintenance 36,000. 00 Total 2,397,754. 50 2,837,235. 00 CHAPTERIV SYSTEM ANALYSIS training GATHERING TOOL AND TECHNIQUES A. QuestionnaireThis questionnaire is distributed in order to gather information regarding the exercise of personality questionnaire in human resource processes as well as its advantages and disadvantages. Through your participation, the study will be able to make possible recommendations that will highlight the functions of personality questionnaire and the guidelines for its appropriate utilization. The following questions that you will read below pertain to your perception on the use of personality questionnaire in recruiting and appraising applicants or employees. Kindly encircle the number of your choice in answering this questionnaire. Please answer the questions as honestly as possible. thank you very much for your cooperation. B. GUI DE QUESTION The specific guide question is relate from the CycleMar Caloocan Corp.The question is about the companys Attendance Monitoring for Payroll System. Our guide question for CycleMar Caloocan Corporation is the following Who is the Owner of the company? What was the History of the company? What is the Organizational Chart of the company? What is the existing system of the company? What is the problem about the existing system of the company? When the problem of the system happened? Where the problem happened? What is the process of their attendance monitoring and payroll system? Who are involved in the system? How many are the employees? How many departments are there in their company? What Is a Time and Attendance Tracking Method?Description of the proposed system Cyclemar Caloocan Corporation uses a Bundy clock to record the attendance monitoring of the employees. In this reason we are urged to create a computerized attendance monitoring with payroll system tha t will record the attendance of the employees time-in and time-out of every department for also the processing of the salary. Solutions to problems compose a computerized attendance monitoring with payroll system that record abstain and accurate employees attendance. The manual system losses its data from the previous records so the proponents were urged to create a long term archive of data that will benefit the company in the future.Losses of visibles is an everyday routine and cannot be eliminated but according to our research and own observations the losses that the company was getting for this past years can be minimize by creating a proper designation of materials to every staff, in that way each material can be properly monitored during a certain event. Context Diagram pic Data Flow Diagram pic pic pic pic pic pic pic CHAPTERV SYSTEM DESIGN precondition AND IMPLEMENTATION A. Systems Design Models 1. Screen Layout USER LOGIN DTR (Daily Rime Record) Form Administator Form A dd User Form (Administrator) Human Resource Home Form Human Resource Employees Record Form Human Resource Logged Form Accounting Home Form Accounting Payroll Form Accounting Payroll Summary Form 2. Report Layout Organizational Directory B. Database Design 1. Table Description in Normalized Form Table Name Nos. f field Description tbl_emp 8 Employees Informations tbl_logged 5 Employees Logged tbl_payroll 10 Payroll datas of employees tbl_total 5 Total of Earnings, Deductions and Hours tbl_user 4 Users Logged informations 2. Table Relationships/Entity Relationship Diagram One to Many Relationship 3. Data Structure tbl_emp tbl_logged tbl_payroll tbl_total tbl_user 4. Data Dictionary Table Name tbl_emp Employees Information id_num INTEGER Unique number for each employee Lastname VARCHAR(45) Employees Surname Fname VARCHAR(45) Employees Given Name MidName VARCHAR(45) Employees Middle Name Gender VARCHAR(10) Employees Gender Status VARCHAR(20) Employees Status Position VARCHA R(45) Position of employee

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.