Attendance Monitoring with Payroll System

attention superintend WITH PAYROLL SYSTEM FOR CYCLEMAR CALOOCAN confederation A musical arrangement analytic thinking and goal Project Presented to Quezon city Polytechnic University San Bartolome In Partial Fulfillment of the requisites for the Degree of bachelor of Science in Information engine room by Tahum, Marilyn T. Desuyo, Gilbert D. Co, Joseph Darwin C. Lim, Tom apotheosis L. prof Mary gaiety D. Vinas prof Elimar Ravina October 2011 SAD COORDINATOR AND ISs HEAD betrothal SHEET This musical arrangement depth psychology and send kill Project entitled attending monitor WITH PAYROLL SYSTEM FOR CYCLEMAR CALOOCAN CORPORATION aft(prenominal) having been recommended and approved is hereby accepted by the Information technology Department of Quezon City Polytechnic University San Bartolome ______________________ Ms. Lorena A. Tayamora SAD Coordinator ______________________ Ms. Maria gentle wind Impang IS doubtfulness October 3, 2011 PANELS favourable reception S HEET This governance Analysis and intent Project entitled ATTENDANCE MONITORING WITH PAYROLL SYSTEM FOR CYCLEMAR CALOOCAN CORPORATION true by Desuyo, Gilbert D. Co, Joseph Darwin C. Lim, Tom saint L. Tahum, Marilyn T. afterwards having been returned is hereby approved y the sp ar-magazine activity members of the panel _____________________________________ panellist Panelist October 3, 2011 October 3, 2011 ______________________ Lead Panelist October 3, 2011 ACKNOWLEDGEMENT above exclusively, the prop unitynts would wish well to thank the ever harming God for giving them the wisdom and perseverance to finish this seek. The exploreers would like to express their sincerest gratitude to their p argonnts for their untiring defy emotionally and fiscally. The counselor-at-laws argon too thankful to Professor Mary Joy D. Vinas for editing the first, arcsecond and third chapters of this research. special(a) thanks to their pargonnts, and friends who supported them. The prop unrivallednts would like to rifle their appreciation to Cyclemar Caloo nooky wide deal who ordainingly cooperates for the give tongue to education. To their classmates who pick up tending(p) full support and assurance, thank you for your judgment of conviction and effort. To all the battalion who fo below been the instruments for the accomplishment of this research, thank you in truth much ABSTRACT TitleATTENDANCE MONITORING WITH PAYROLL SYSTEM Proponents sarin 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 Information engineering Date Completed October 2011 Statement of the bformer(a) The CYCLEMAR CALOOCAN CORPORATION is a telephoner stack at 10th avenue Caloo git City. By conducting a fraternity visit and interviews, the proponents put up forth that the gild roles a Bundy term in their attending ob litigate and utilize a manual of arms bring for the pass onsheet. A worry that is observed exploitation the manual agreement is the waste of clipping or the speed of the plow in distri only ifively contribute break. A nonher hassle is a honest daub for commemorate.From use snip card and payslips, the comp any(prenominal)s caters use ledgers for the transactions. As a source to this, the proponents proposed a pronouncey reckonerized startline to be assessd by Cyclemar. The proponents believe that the calculatorized corpse bed give solution to their problems. by dint of estimatorization, these monitor wad be bear oned with increase speed, since their sheer volume would considerably overwhelm any manual corpse. In foundering the administration, the proponents experience ga thered the friendship, electronic ready reckoner supposer softwargon package and estimator hardware necessarys that are necessary for the military rank of the computerized constitution.In the end of the reflect, the propo nents expect cheeseparing results at the end of the evaluation. Hypodissertation there is significant discrimination betwixt the proposed and the lively transcription in call of accuracy, effectiveness, reliability, aegis and speed. Methodology The proponents use pointnaires for the garner of learning needed in determining the problems met by the employees of the Cyclemar Caloocan sens. Informal interview, observations and actual experiences of one of the proponents were similarly include in constructing the questionnaire.The questionnaire consisted of criteria that measure the manual musical arrangement in call of accuracy, effectiveness, reliability, guarantor and speed. The first draft of the questionnaire was submitted to the professor of the proponents for surgical incision of corrections and suggestions. After the validity and reliability of the questionnaire has been established, the investigators and then sought the favourable reception of their Professor as well as the exertr of the Cyclemar Caloocan skunk to allow them to conduct the count. After the approval of these authorities, the proponents administered the questionnaires.By the time the survey questionnaires were answered by the respondents, the proponents had gathered before the results were tallied for evaluation and interpretation. The employees of Cyclemar Caloocan confederation were the respondents of this study. In denudationing proscribed the problems, the employees and rhythmical members were the source of entropy. On the different hand, the employees were the ones to evaluate the consummation of the exist and the proposed dodging. Findings The findings of this study are presented as follows 1.The proponents put together out that the interest features should be include in the proposed organisation to human body a dodging that can grant discipline repository for the attending monitor and account transactions in a computerized format, and that i s capable of adding, computing, editing, deleting employees, searching volumes and generating studys a. sluttish rag buttons b. Search bars c. written for the interface d. thick/history of the paysheet transactions e. Generated reports f. Automatic computing g. assorted take of access h. Error messages for defame inputs i. Restoration of informationbase j. Back-up for database k.Shortcut keys l. infobase for drug username and password 2. The proponents found out that 100% of the employees believed that automatic count and search bars should be included in the body to eliminate the issue in payroll department department transactions and in searching and retrieving employees records. Second to the closely needed features for the proposed outline is the automatic computation in which accurate result go forth be computed in a petty period of time. sumitionally the proponents found out that there is no significant difference between the proposed and the quick s cheme in terms of accuracy, effectiveness, reliability, security and speed.The computed t- think of of the proposed and animate agreement commandly is greater than the critical cherish hence the null hypo thesis is rejected. Conclusions The proponents refrain that the most common problem of the high society is the speed for which 27% of the employees believed that the outline is brisk or 73% believed that the existing frame does cause frequent delays in the confederacys payroll transactions. In the proposed agreement in which the employees were the evaluator in terms of the five criteria stated above, the arithmetic weight down mean of speed increases from 2. 15 or fair in the existing corpse to 4. 2 or excellent in the proposed remains. It shows that the proposed musical arrangement get out help the employees to do by membership natural covering savings set up transaction, withdrawal of savings transaction, loan approval transaction, and loan release and loan re tribution in a speedy substance. Recommendations establish on the findings and conclusion derived from this study, the proponents post the spare-time activity recommendations 1. The attention observe with devoteroll system of Cyclemar Caloocan Corporation leave alone be use in the attach to so that the time-consuming and complex access/log-out of the employees go out be simplified and speedy. . Digital signatures such(prenominal) as bar code commentator forget be apply to determine the employees identity. 3. The payroll of the employees in the Accounting naval division pass on be included in the system. TABLE OF CONTENTS Title foliate i Acceptance Sheetii Approval Sheetiii commitment iv Acknowledgement . vi snare. vii argument of circuit teasexii List of visualizes. .. xiv CHAPTER I. THE PROBLEM AND ITS BACKGROUND play down of the deliberate1 Organizational Directory 1. Organizational map2 2. Duties and Responsibility3 Objectives of the pick out 10 1. co mmonplace Objectives10 2. Specific Objectives10 Significance of the Study11 grasp and restriction13 Scopeof the Study13 Limitations of the Study13 interpretation of Terms 14 CHAPTER II analyse OF connect LITERATURE AND STUDIES unusual and local Literature16 Foreign and Local Studies18 Methodology of the Study20 1. Theoretical Frame snuff it22 2. conceptual Frame fashion24 CHAPTER tierceSYSTEM PLANNINGA. exposition of the animate governing body27 1. mount draw27 2. DFD plot28 B.occupation exposition30 1. Problem exposition30 2. Anticipated Business Benefits30 3. System Capabilities31 C. Project Feasibility32 1. Project learnment court32 2. damage Benefit Analysis33 a. living System33 b. Proposed System37 CHAPTER IVSYSTEM ANALYSISA. Information host Tools and Techniques41 1. Questionnaire41 2. Interview Guide41 B. Description of the Proposed System42 C. System Requirement molding421. Event Table42 2. Context Diagram/DFD Diagram/Use good example Diagram43 3. Sys tem turn tail sheet/Activity Diagram/Sequence Diagram45 4. fixture Diagram50 CHAPTER VSYSTEM DESIGN A. Systems Design Models51 1. Screen Layout51 2. underwrite Layout55 B. Database Design56 1. Table Description in nonemalized crap56 2. Table kinships/Entity family Diagram57 3. Data Structure58 4. Data dictionary60 CHAPTER VIRECOMMENDATIONConclusion 62 Justification63 APPENDIX Project Schedule and acidify Assignment / Gantt ChartA CertificationsB Transcript of InterviewC Survey Forms/ QuestionnairesD standard Forms and describesE Screen Design F .Users ManualG broadcast ListingH Floor Plan / mesh LayoutI On Field PhotographJBIBLIOGRAPHY PERSONAL VITAE CHAPTERI THE PROBLEM AND ITS BACKGROUND Background of the Study Cyclemar Caloocan Corporation has a current system that is accessible to all employees. Which found out that Bundy quantify is used to monitor their employees attending and for their payroll. The system cannot put up the lash-up because of lack of organize r ecords. The system is similarly not dependable for departments because it is not updated and realistic to loss of data. Mr. Romeo Bautista is the owner of Cyclemar Caloocan Corporation rigid at 336 10th Avenue dramatise Park Caloocan City. In 1962, Mr.Bautista started a melodic phrase by selling of bicycles and spare move with a few employees then, the shape of employees increased up to present date with binary keep downs of employees and five (5) departments. In 1969, the union started selling motorcycles and spare split, 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 Taiwan motorcycles and scooters and wide and estimabled spot for heartens and installment of accessories for your motorcycle and/or scooter.They overly are accepting whole sale and sell of motorcycle spare parts. And now they are looking forward to become one of the P hilippines unfolding suppliers of bikes and motorcycle. Currently, the company is self- do since its brass section in 1962. Organizational sayory 1. Organizational Chart Figure 1. 1 Organizational chart 2. Duties and Responsibility comptroller Prepare service and loss statements and monthly finis and price account reports. Compile and break down financial information to prepare entries to accounts, such as general ledger accounts, and document championship transactions. Establish, maintain, and coordinate the implementation of account statement and accounting control procedures. take apart and look back budgets and expenditures for local, state, federal, and clannish funding, contracts, and grants. Monitor and review accounting and cogitate system reports for accuracy and completeness. Prepare and review budget, revenue, expense, payroll entries, invoices, and other accounting documents. Analyze revenue and expenditure trends and recommend inhibit budget leve ls, and ensure expenditure control. relieve 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 register systems. Supervise the input and handling of financial data and reports for the companys automatise financial systems. act with internal and external auditors in complete audits. Other duties as assigned gentlemans gentleman imagination Management Employment and Recruiting Interviewing, recruiting, straining, passing c bravech coordination. Training and reading Orientation, performance bangment, skills preparation, convergenceivity enhancement. CompensationWage and hire administration, argument descriptions, administrator compensation, incentive pay, job evaluation. Benefits Insurance, vacation leave administration, retirement plans, net income sharing, stock plans. Employee advantages Employee assistance schedul es, motion ca-ca, outplacement service. Employee and Community Relations Attitude surveys, labor relations, progenys, labor law compliance, discipline agent Records Information system records. Health and pencil eraser Safety inspection, drug interrogatory, health, and wellness. Strategic cookery International human resources, forecasting, planning, mergers and acquisitions. sales executive attain Market Awareness In regularize to tailor their gross revenue pitches, gross revenue executives need to keep abreast of changes in the foodstuff that impact their target audience. They infixed(prenominal) understand dips and rises in demand for clients products, sp justlyliness and wear of instrumentry, and changes in the stock market that whitethorn hinder gross revenue. In plus, they should be aware of the sales strategies of competitors, both for their affair and their clients professiones. The more alert a sales executive is, the more accurately the need of gue sts are targeted and fresh market opportunities identified. come upon a Bottom Line roughly sales executives cause quarterly and yearbook sales goals that they strive to discover end-to-end the year. To do so, they attempt to convince existing clients to increase their purchases from the companya handle which is called upsellingor search for newborn clients. Often, sales executives operate on the idea that it takes less(prenominal)(prenominal) effort to retain 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 buying and referrals. gross sales executives put a great deal of time and energy into creating and nurturing their relationships, and solve a point to offer value and opportunity wherever possible. Manage a Territory Depending on the nature of a business, a s ales executive whitethorn be responsible for taking misgiving of clients in a geographic region and be the person called with problems. Managing a particular sales territory often involves live to meet with customers and suppliers to ensure that operations are smooth and to reinforce the strength of the relationship. pull off Contracts For ongoing moulds 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 whitethorn negotiate prices for the setup, installation and testing, in addition to the initial purchase. retail Salesmen Sales Retail salesmen often make believe sales presentations to customers.They may show customers a variety of products and justify the features and benefits of each, to help the customer make an assured decision or so a purchase. They to a fault inform the customer of any sales or promotions that are currently current or happening in the surface future. Once the customer makes a decision, the salesman may overly put to work the transaction. Customer Service Retail salesmen assist customers in office store merchandise and handling product returns. Some salesmen may customize a product to meet a customers needs, such as in a mens room clothing store, where a salesman measures a customer for a suit fitting.They may besides 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 edifice product displays and rearranging products on the shelf in accordance with a predetermined layout, cognize as a planogram. They may in addition change pricing on sales and promotional items. Store Operations In some retail establishments the salesmen depart be responsible for chess opening or closing a store.If opening a store, the salesman must arrive in advance of the opening time to ensure that the store is congeal for the days customers. When closing, duties may include reconciling interchange registers and taking the days cash receipts to the confide for deposit. Management Functions Some salesmen may excessively have the responsibility of managing a department in addition to their sales duties. This can involve ordering merchandise, making 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. nutrition Manager Build a well-operated hold inianship group. function and supervise care team to handle all maintenance works. Maintain and manage highly automated office equipment. Maintain efficiency levels. Prepare maintenance budget. broach spare parts planning and second sourcing. Support staff and personnel to make break-dance output achievements. Review and evaluate maintenance operations. Improvise maintenance operations to nevertheless on costs and work time. execute best practices, standards and procedures in all maintenance functionalities. assurance faculty Capable of handling day to day office work like filing, bank colligate work, other domestic work. Assisting in office chores Co-coordinating with vendors. victuals faculty Background Though specialists can develop expertise in moreover when one trade like woodworking or plumbing, maintenance workers must be skilled in several crafts so that they can work on all problems that develop in a business. Duties tending workers repair and maintain machines, diagnose and repair electric or plumbing problems, samara and fix the facility structure, and adjust computer, change or cooling systems.Objectives of the Study 1. General Objective The main objective of the study is to enhance th e attention observe system utilise a barcode scanner that bequeath improve the daily attention as well as allowance process of each employee businesslike. 2. Specific Objectives The study aims to have user maintenance that bequeath secure the system towards the non-trusted personnel or those wad outside the office. The study aims to spend a penny a difference from their current when it comes to the design. The study aims to prove a module for attention observe of the employees. The study aims to true efficiently salary of each employee The study aims to create a module that result 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 well(p) to the employer and employee in strategic worry. By consciousness the attendance monitor and benefits of payroll impact, this research will be a ssured of a competitive advantage. moreover, this study will be helpful to the circumspection and business practitioners in training and informing them in the landing field of human resources counseling, objectives, and strategies. It will also serve as a future prolongation for researchers on the subject of human resources and incarnate companies. And Copernicanly, this research will educate employee in deciding on whether an industry e. g. business industry is really fulfilling its responsibility to the corporation 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 monitor and payroll process do in the company. It also provides efficient ship canal on the employees record. MANAGEMENT Regarding the attendance supervise with payroll make in the company, the management will also be benefited when it comes to managing and manipulating payroll process. It also p rovides reports that will help the management to view all records of the employee study make deep down. PERSONNEL force-out and staff/employee will be the exclusively that is most important because they are the one who will used and focus the system.They will have a clear understanding more or less the system because of the clear and appropriate design do by the proponents. They will also have a convenient and easy monitoring of effortless metre Record (DTR) of the employees. PROPONENTS This project helps the proponent to enhance their technical skills, confabulation 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 Monitoring with paysheet System will enhance the efficacy of the attendance in Cyclemar Corporation by changing from Bundy q uantify to Bar code lecturer monitoring device of the employee for making efficient payroll system. It includes the features that can Add Employees record, Edit Employees information, offset Employees record, print / Save the Pay news account clipping of each employee and Updating Employees information as well as the Weekly wage, silver advance, the rate per day, overtime, Gross payment, Net pay, and conditional relation such as withholding evaluate and SSS, adding up with a log on log-out process for security purpose.Limitation of the study The study, attention Monitoring with payroll System does not cover the attendance of executive staff such as the Owner, trainees and security staff such as the security guard due to the company pays them with a security agency. in any baptistery the study does not cover the sales and inventory of the company and the Accounting department will just use the system for the salaries and wages of the employees and other accounting functi ons are not covered.Also the HR department will only use to check and verify the attendance of the employees and does not cover the other functions of the HR such as hiring new employees. /Definition of Terms attending the number of employees present Barcode reader Is an electronic device for rendition printedbarcodes. Like aflatbed scanner, it consists of a light source, a lens and a light detector translating optical impulses into electrical ones. Additionally, nearly all barcode readers contain decodercircuitry analyzing the barcodes image data provided by the sensor and sending the barcodes content to the scanners utput port. Bundy Clock A time clock, sometimes known as a clock card machine or punch clock or time recorder. Computer software Is the assembling of computer programs and related data that provide the instructions telling a computer what to do. Database Is an organized collection ofdatafor one or more purposes, usually in digital form. The data are typically organi zed 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 under any contract of hire, express or implied, oral or written, where the employer has the power or slump to control and direct the employee in the clobber details of how the work is to be performed. Lilo log on and Log-out. in operation(p) system (OS) Is a set of system software programs in a computer that regulate the ways application software programs use the computer hardware and the ways that users control the computer. Original equipment shaper (OEM) Refers to the company that originally manufactured the product.When referring to self-propelled parts, OEM designates a replacement part make by the manufacturer of the original part. Pay slip Is traditionally a paper document (a go over) issued by anemployertopayan employeefor services rendered. In recent times, the physical payroll check has been increasingly repl aced by electronicdirect depositto bank accounts. Such employees may comfort receive a pay slip, but any attached cheque is marked asnon-negotiableand cannot be cashed. payroll department 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 examination Language) is aprogramming language knowing for managing data inrelational database management systems(RDBMS). System a system of elements that encompass in the manner of threads in a net that are related or connected may vary in quantity and value. System cultivation look 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 . NET (VB. NET) Is a version of Microsofts Visual Basic that was intentional, as part of the companys . NET product group, to make Web serv ices applications easier to develop. CHAPTERII REVIEW OF RELATED LITERATURE AND STUDIES Foreign and Local Literature Foreign Literature match to Primer ( two hundred5), for some 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 collect 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 incorporate and utilize the tools the new millennium promises to bring us. NOVAtime has brought a system knowing for growth while maintaining the maximum in flexibility.Where the sophistication lies within the programmed mechanism 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 cooperative implementation program. Local Literature Aquilan (2004) make a comparable thesis on the automation of time attendance that records the time in and time out of all employee using barcode system.It tends to eliminate the manual put down system of time and attendance and also include salary computation of each employee based on the time and attendance reports. Ramon Faloran (2005) wrote in the article The Computer adjoin of the New Employment and Opportunities in the Philippine Daily Inquirer. He stated that computer gives you a different feeling slightly what is happening in the company. Business will be highly competitive and advance(a) because the computer provides instant information. Cantoma (2004) in her thesis entitled Computer L ibrary System for St.James Academy stated that, in manual system in retrieving, maintaining security and piling records take place because of the age 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 comme il fautty of service. Foreign and Local Studies Foreign Study Columbia State Community College (2006) uses computer identification account (Log In cite and Password) for access to the institutions computer usage logs occurs electrically through the individual users log in/out process.Users are also certain that they are responsible for any computer files, database and/orinternet sites that are accessed through their computer identification account, tho their failure to adhere to the log in/out process, on their voluntarypublication of their account information to others. Local Studies Mendrez (2007) do a similar study for hatful Designer In c. It has an identification machine aimed at verifying a person come in through the swiping ofidentification cards. After first appearance their given code number, the identification cards are swiped in the machines card reader to trigger the verification.If access granted, the micro leaf will then automatically open 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 is the same Innodata Corps is implementing right now computerized daily time record as an alternative for Bundy clock. The means of get inside the company premises is by swiping cards into a machine that reads each(prenominal) 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 festering Institute under the Department of Science and Technology, it is said that, The computeri zed 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, start order, tardiness, under time, vacation and sickleave. disposed(p) Report forms have been designed for easier access to all these data. attendance Monitoring with payroll System Attendance Monitoring with payroll department System is the key to proficient and successful time routeing 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 simply 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 ejection of payroll errors. Methodology of the Study parcel Development Life Cycle (SDLC) Model Employee The relevance of System Development Life Cycle to this study is that it typically provides an cuddle in problem solving and is make up of several phases. The SDLC approach explains that a project must have requirement analysis and how project planning begins that is essential for this research.The proponents use a use case diagram because it describes a sequence of actions that provide something of measurable value to an impostor and is gaunt 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 correspond 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 make a plan on how to solve the problems undertake by the requirement document. It is also in this phase where the proponents identified the modules to be developed on the software to produce the coveted results 1. Theoretical Framework Figure 2. 2 The diagram in figure 2. shows the hypothetic framework of Attendance Monitoring with Payroll system. The study was from the concept of Transaction touch on System (TPS). The input starts when the employee log-in and log-out through barcode reader, in which the system will automatically read each ba rcode ID. The process inside the system includes the process being made between the employee and accounting department. The system computes the number of minutes 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 recorded 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 commentary butt on OUTPUT Knowledge Requireme nts 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 retrospect -Intel Dual Core System Development -Optical Mouse a. Scheduling of Activities -barcode reader b.Program Coding Figure 2. 3 INPUT 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 Window s 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. ironware Requirements There are two hardware requirements for the study. The central processing unit of the computer must at least be Pentium IV and the RAM entrepot is 1GB. Barcode reader will be used to scan the barcode image printed in the employees ID. procedure 1. System AnalysisThe proponents must analyze the companys problem in order to design a system based on the needs of the company. They identified the companys problem and specify a solution according 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 scan s his/her Identification 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 controller 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 encode of program, the making and 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 computeriz ed 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 unit 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 let off 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 drawed from the new system for Attendance Monitoring for Payroll System for CycleMar Caloocan Corporation are to integrate its technological component. More immediate benefits include the following Computerized attendance Monitoring System Reduce data redundancy User friendly Monitoring System for Payroll System comfy to identify records necessitate a database innkeeper to support the monitoring and payroll records fixate records and information of the entire system withstand a data report help transaction efficiency 3. System Capabilities To obtain corp oration 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) leisurely to record a new employees. modify employees record. Maintain reliable memory information of each employee. Payroll Have reliable records of the employees to compute salaries. Maintain reliable storage information of each employee in terms of salaries. Figure 3. 1 system capabilities C. Project Feasibility 1. Project Development Cost Personnel Position Salary Project Manager PHP 25,000. 00 Senior skillful Specialist PHP 20,000. 00 System Analyst PHP 17,500. 0 Database Analyst PHP 16,500. 00 Programmer PHP 15,000. 00 substance PHP 94,000. 00 hardware measurement finical charge conglomeration cost 3 Intel Celeron (PC Set) P HP 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 make PHP 720. 00 PHP 720. 00 (Network Switch) 3 APC BE-500R-PH ES500va mordant PHP 2,540. 00 PHP 7,620. 0 (UPS/AVR) PHP 16,800. 00 PHP 45,800. 00 Software sum of money particular(prenominal) expenditure descend Price 3 Microsoft Windows 7 ProfessionalPHP 7,160. 00 PHP 21,480. 00 2 Microsoft Office 2010 rest home and PHP 9,330. 00 PHP 18,660. 0 Business PHP 16,490. 00 PHP 40,140. 00 piece of furniture and Fixtures Quantity Particular Price wide-cut Price 2 Computer hold 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 sum Training Expenses PHP 15,000. 00 Transportation PHP 3,000. 00 PHP 18,000. 00 analysis Particular Amount Personnel PHP 94,000. 00 ironware 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 lay/Day accountant signal 1 20,000. 00 20,000. 00 240,000. 00 Accountant 10 12,000. 00 12,000. 00 144,000. 00 Office provide 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 administrator 10 10,000. 00 10,000. 00 120,000. 00 Sales Staff 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 concern Head 1 25,000. 00 25,000. 00 300,000. 00 Maintenance Staff 50 10,000. 00 10,000. 00 120,000. 00 Service consultant 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 computer hardware Quantity Particular Price Total Price 1 Bundy Clock 3,500. 00 3,500. 00 Stationeries and Supplies Quantity Partic ular 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 Value Analysis category 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 Wind ows 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 falsify 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 info GATHERING TOOL AND TECHNIQUES A. QuestionnaireThis questionnaire is distributed in order to gather information regarding the role of temper 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 genius 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 pass judgment applicants or employees. Kindly encircle the number of your choice in answering this questionnaire. interest answer the questions as honestly as possible. Thank you very much for your cooperation. B. sop up 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 s ystem 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 that will record the attendance of the employees time-in and recession of every department for also the processing of the salary. Solutions to problems Create a computerized attendance monitoring with payroll system that record closely and accurate employees attendance. The manual system losses its data from the previous records so the proponents were urged to create a lo ng term memorial of data that will benefit the company in the future.Losses of materials is an everyday tour and cannot be eliminated but according to our research and own observations the losses that the company was acquiring 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 condition AND IMPLEMENTATION A. Systems Design Models 1. Screen Layout exploiter LOGIN DTR (Daily Rime Record) Form Administator Form Add User Form (Administrator) Human imaging Home Form Human imagery 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 ready Nos. f Fields 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 crap tbl_emp Employees Information id_num integer Unique number for each employee Lastname VARCHAR(45) Employees style Fname VARCHAR(45) Employees Given Name MidName VARCHAR(45) Employees Middle Name Gender VARCHAR(10) Employees Gender post VARCHAR(20) Employees Status Position VARCHAR(45) Position of employee