Two brothers, Aidi and Hakim formed Excellent Service Sdn Bhd, which provide a variety of services to their neighbourhood, such as gardening and housekeeping. Aidi acts as a director while Hakim is a manager.

When a customer requests for their service, Adam, the supervisor will prepare a job order form and give the form to an employee together with a time slip. A time slip is a form that captures details of employee’s name, id, date of the job and the time taken to accomplish a particular job. The company has pre-printed copies of this document, which are kept by the supervisor.

The employee will start working after he receives the job order form and time slip, based on the job description in the job order form. After completing the task, he fills in the time slip. The following is the procedure to pay employees for the job that they have completed.

The filled time slip, together with the job order form will be handed by the employees to the supervisor. The supervisor then checks the time slip and endorses it. The endorsed time slip is then kept in the temporary file, while the job order form will be filed in the cabinet chronologically.

At the end of the month, the time slips in the temporary file will be reviewed by a payroll clerk to determine the gross wages of the employees. The reviewed time slips then are transferred to permanent file and kept by employees’ name. To calculate the net wages, the clerk will refer to the data in the employee file and payroll file for any additions and deductions. After calculating the net wages, the clerk then prepares a payroll register, agency checks and employee checks. All these three documents will be reviewed and verified by a manager. All the verified documents will be sent back to the clerk for distribution and filing. The employee checks are distributed to the employees, while the payroll register will be kept in a fixed cabinet files by employee numbers. All the agency checks will be posted to all relevant government agencies.

REQUIRED:

(a) Prepare a context diagram and logical (level 0) data flow diagram for payroll payment procedures for Excellent Service Sdn Bhd. Then, prepare a flowchart for the above system for Excellent Service Sdn Bhd

Answer rating: 100% (QA)

Context diagram Entities are customer employee manager clerk supervisor dir... View the full answer