Accounting Information Systems
10th Edition
ISBN: 9781337619202
Author: Hall, James A.
Publisher: Cengage Learning,
expand_more
expand_more
format_list_bulleted
Question
Chapter 9, Problem 21P
To determine
Prepare an entity level data model that contains only entities and shows the cardinalities between them.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Employees at the Sagerod Manufacturing Company record their hours worked on paper time cards that are inserted into a time clock machine at the beginning and end of each shift. On Fridays, the supervisor collects the time cards, reviews and signs them, and sends them to the payroll clerk. The clerk calculates the pay for each employee and updates the employee earnings file. This involves adding a new record for each employee in the pay period that reflects the employee’s gross pay, tax deductions, and other withholdings for the period. The clerk then prepares a paycheck for each employee and records them in the check register. The check register and corresponding paychecks reflect each employee’s net earnings for the period. Based on these records, the clerk prepares a payroll summary, which is sent with the paychecks to the cash disbursements clerk. The clerk reviews the payroll summary, updates the cash disbursements journal to record the total payroll, and prepares a check for the…
The following describes the payroll procedures for a hypothetical company.Every Thursday, the timekeeping clerk sends employee time cards to the payroll department for processing. Based on the hours worked reflected on the time cards, the employee pay rate and withholding information in the employee file, and the tax rate reference file, the payroll clerk calculates gross pay, withholdings, and net pay for each employee. The clerk then manually prepares paychecks for each employee, files hard copies of the paychecks in the payroll department, and posts the earnings to the hard-copy employee records. Finally, the clerk manually prepares a payroll summary and sends it and the paychecks to the cash disbursements department. The cash disbursements clerk reconciles the payroll summary with the paychecks and manually records the transaction in the hard-copy cash disbursements journal. The clerk then files the payroll summary and sends the paychecks to the treasurer for signing. The signed…
The following describes the payroll procedures for Cooper Toy Train Company.
Every Thursday, Raj, the timekeeping clerk, keys the timecard data from the employees into the
system, prints a summary report, sends the summary report to Penny in the payroll department
where it is filed by date, and then files the timecards alphabetically and date.
The last Thursday of each month, Penny, the payroll clerk, processes the payroll which includes
calculating gross pay, calculating withholdings, calculating net pay, printing the checks, printing
the payroll summary report and the payroll file is updated. Penny then sends the checks and the
payroll summary report to Leonard in the cash disbursements department.
Leonard, the cash disbursements clerk, reconciles the payroll summary with the paychecks and
then records the transaction in the cash disbursements file. He then files the payroll summary by
date and sends the paychecks to the treasurer, Sheldon, for signing.
The signed checks are then…
Chapter 9 Solutions
Accounting Information Systems
Ch. 9 - Prob. 1RQCh. 9 - Prob. 2RQCh. 9 - Prob. 3RQCh. 9 - Prob. 4RQCh. 9 - Prob. 5RQCh. 9 - Prob. 6RQCh. 9 - Prob. 7RQCh. 9 - Prob. 8RQCh. 9 - Prob. 9RQCh. 9 - Prob. 10RQ
Ch. 9 - Prob. 11RQCh. 9 - Prob. 12RQCh. 9 - Prob. 13RQCh. 9 - Prob. 14RQCh. 9 - Prob. 15RQCh. 9 - Prob. 16RQCh. 9 - Prob. 17RQCh. 9 - What are the conditions for third normal form...Ch. 9 - Prob. 19RQCh. 9 - Prob. 20RQCh. 9 - Prob. 21RQCh. 9 - What is a user view?Ch. 9 - Prob. 23RQCh. 9 - Prob. 24RQCh. 9 - Prob. 25RQCh. 9 - Prob. 1DQCh. 9 - Prob. 2DQCh. 9 - Prob. 3DQCh. 9 - Prob. 4DQCh. 9 - Prob. 5DQCh. 9 - Prob. 6DQCh. 9 - Prob. 7DQCh. 9 - Prob. 8DQCh. 9 - Prob. 9DQCh. 9 - Prob. 10DQCh. 9 - Prob. 11DQCh. 9 - Prob. 12DQCh. 9 - Prob. 13DQCh. 9 - Prob. 14DQCh. 9 - Prob. 15DQCh. 9 - Discuss the accounting implications of the update,...Ch. 9 - Prob. 17DQCh. 9 - Prob. 18DQCh. 9 - Prob. 19DQCh. 9 - Prob. 20DQCh. 9 - Prob. 1MCQCh. 9 - Prob. 2MCQCh. 9 - Prob. 3MCQCh. 9 - Prob. 4MCQCh. 9 - Prob. 5MCQCh. 9 - Prob. 6MCQCh. 9 - Prob. 7MCQCh. 9 - Prob. 8MCQCh. 9 - Prob. 9MCQCh. 9 - Prob. 10MCQCh. 9 - Prob. 11MCQCh. 9 - Prob. 12MCQCh. 9 - Prob. 13MCQCh. 9 - Prob. 14MCQCh. 9 - Prob. 15MCQCh. 9 - Prob. 16MCQCh. 9 - Prob. 17MCQCh. 9 - Prob. 18MCQCh. 9 - The Mega Supply Corporation has three divisions:...Ch. 9 - Prob. 2PCh. 9 - Lesters Rentals is located in Cincinnati, Ohio....Ch. 9 - Prob. 4PCh. 9 - Prob. 5PCh. 9 - Prob. 6PCh. 9 - Prob. 7PCh. 9 - Prob. 8PCh. 9 - Prob. 9PCh. 9 - Prob. 10PCh. 9 - Prob. 11PCh. 9 - Prob. 12PCh. 9 - Prepare the 3NF base tables needed to produce the...Ch. 9 - Prob. 14PCh. 9 - Prob. 15PCh. 9 - Prob. 16PCh. 9 - Prob. 17PCh. 9 - Prob. 18PCh. 9 - Prob. 21PCh. 9 - Prob. 22PCh. 9 - Prob. 23PCh. 9 - Prob. 24P
Knowledge Booster
Similar questions
- Every 2 weeks, employees for a manufacturing firm submit their time cards to the supervisor, who reviews and approves them. They are the submitted to the payroll department. At that time, the human resources clerk also submits a personnel action to the payroll clerk. The payroll clerk enters the information from these source documents into the employee records and then adds the employee hours to a payroll register reflecting employee pay rates, deductions, and job classification. One copy of the payroll register, along with the time cards, is filed in the payroll department, and one copy is sent to the AP department.Next the payroll clerk sends the employee paychecks to the cash disbursements department. The checks are signed and distributed to the employees by the paymaster. The AP department prepares a cash disbursements voucher. A copy of the voucher and a copy of the payroll register are sent to the cash disbursements department and are then posted to the general ledger. The cash…arrow_forwardUsing this supplemental information, analyze the flowchart in the diagram. The personnel department determines the wage rate of all employees. To start the process, personnel sends the payroll coordinator, George Jones, an authorization form in order to add an employee to the payroll. After Jones enters this information into the system, the computer automatically determines the overtime and shift differential rates for the individual, updating the payroll master files. Employees use a time clock to record the hours worked. Every Monday morning, George Jones collects the previous week’s time cards and begins the computerized processing of payroll information to produce paychecks the following Friday. Jones then reviews the time cards to ensure that the hours worked are correctly totaled; the system determines overtime and/or any shift differential. Jones performs all other processes displayed on the flowchart. The system automatically assigns a sequential number to each payroll check…arrow_forwardPAYROLLThe following describes the payroll procedures for a hypothetical company.Every Thursday, the timekeeping clerk sends employee time cards to the payrolldepartment for processing. Based on the hours worked reflected on the time cards, theemployee pay rate and withholding information in the employee file, and the tax ratereference file, the payroll clerk calculates gross pay, withholdings, and net pay for eachemployee. The clerk then manually pre-pares paychecks for each employee, files hardcopies of the paychecks in the payroll department, and posts the earnings to the hardcopy employee records. Finally, the clerk manually prepares a payroll summary andsends it and the paychecks to the cash disbursements department. The cashdisbursements clerk reconciles the payroll summary with the paychecks and manuallyrecords the transaction in the hard-copy cash disbursements journal. The clerk then filesthe payroll summary and sends the paychecks to the treasurer for signing.The signed…arrow_forward
- Dave’s Scooters is a small manufacturer of specialty scooters. The company employs 14 production workers and four administrative persons. The following procedures are used to process the company’s weekly payroll:a. Whenever an employee receives a pay raise, the supervisor must fill out a wage adjustment form, which is signed by the company president. This form is used to change the employee’s wage rate in the payroll system.b. All employees are required to record their hours worked by clocking in and out on a time clock. Employees must clock out for lunch break. Due to congestion around the time clock area at lunch time, management has not objected to having one employee clock in and out for an entire department.c. Whenever a salaried employee is terminated, Personnel authorizes Payroll to remove the employee from the payroll system. However, this procedure is not required when an hourly worker is fired. Hourly employees only receive a paycheck if their time cards show hours worked.…arrow_forwardAutomated Application Controls. The following provides a brief description of the computerized payroll system used by Merriman in its biweekly processing of payroll for its employees.1. Employees automatically record their attendance (hours worked) as they log in at thebeginning and end of the workday.2. At the end of each payroll period (every two weeks), employees print and authorizetheir attendance records, submitting them to their supervisor. The computer prenumbersthese attendance records and generates them in chronological order based on when theemployee submits his or her final attendance for that payroll period.3. Supervisors review the attendance records submitted by their employees and authorizethese records, which the supervisors then forward to data entry conversion operators.4. Data conversion operators input the attendance record number, employee number, andhours worked from the attendance records that have been approved by the employeesupervisors into a file to be used…arrow_forwardMatt Demko is the loading dock supervisor for a dry cement packaging company. His work crew is composed of unskilled workers who load large transport trucks with bags of cement, gravel, and sand. The work is hard, and the employee turnover rate is high. Employees record their attendance on separate time cards. Demko authorizes payroll payments each week by signing the time cards and submitting them to the payroll department. Payroll then prepares the paychecks and gives them to Demko, who distributes them to his work crew. a. Prepare a systems flowchart of the procedures described here. b. Identify any control problems in the system. c. What sorts of fraud are possible in this system?arrow_forward
- Able, an employee of ABC Company, was in charge of collecting the timecards of all the employees in his division (including his own) and delivering them to the division supervisor. After the supervisor reviewed and approved the timecards, Able delivered them to the payroll accounting department, where paychecks were issued. Able would fill out his timecard in erasable ink, wait until his supervisor had signed off on it, and then change the number of hours on the timecard before he took it to payroll accounting. This increased the size of his paychecks. This is an example of: a. Check tampering b. Forgery c. A ghost employee scheme d. A falsified hours and salary schemearrow_forwardA Forman of a construction company is responsible for a construction crew comprised of many unskilled workers. The work is hard, and employee turnover rate is high with individuals often leaving without notice. Throughout the work week employees record their attendance on separate time cards, which the foreman approves and submits to the payroll department at the end of week. Based on the time cards, the payroll department prepares the paychecks, sends them to the foreman who then distributes the checks to his work crew. 1-Identify the segregation of duties problems in the system. 2-What sorts of fraud may result from the above control problem(s)?arrow_forwardPrepare a payroll check using the information from the payroll register for Bill Brown for the pay period ending on August 31. Fill out the check stub using information from the payroll register. Prepare the check. Sign your name. Use name Yaira Hundley. Completed payroll register is attached.arrow_forward
- A Forman of a construction company is responsible for a construction crew comprised of many unskilled workers. The work is hard, and the employee turnover rate is high with individuals often leaving without notice. Throughout the workweek, employees record their attendance on separate time cards, which the foreman approves and submits to the payroll department at the end of the week. Based on the time cards, the payroll department prepares the paychecks and sends them to the foreman who then distributes the checks to his work crew. 1) Identify the segregation of duties problems in the system. 2) What sorts of fraud may result from the above control problem(s)?arrow_forwardA Forman of a construction company is responsible for a construction crew comprised of many unskilled workers. The work is hard, and the employee turnover rate is high with individuals often leaving without notice. Throughout the workweek, employees record their attendance on separate time cards, which the foreman approves and submits to the payroll department at the end of the week. Based on the time cards, the payroll department prepares the paychecks and sends them to the foreman who then distributes the checks to his work crew. 1) What sorts of fraud may result from the above control problem(s)?arrow_forwardA Forman of a construction company is responsible for a construction crew comprised of many unskilled workers. The work is hard, and the employee turnover rate is high with individuals often leaving without notice. Throughout the workweek, employees record their attendance on separate time cards, which the foreman approves and submits to the payroll department at the end of the week. Based on the time cards, the payroll department prepares the paychecks and sends them to the foreman who then distributes the checks to his work crew. 1) Identify the segregation of duties problems in the system.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
College Accounting, Chapters 1-27AccountingISBN:9781337794756Author:HEINTZ, James A.Publisher:Cengage Learning,
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
College Accounting, Chapters 1-27
Accounting
ISBN:9781337794756
Author:HEINTZ, James A.
Publisher:Cengage Learning,