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…
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…
Using 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…
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
- 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_forwardAble, 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_forwardWhen employees arrive for work at Harlan Manufacturing, they punch their time cards at a time clock in an unsupervised area. Mary, the time-keeping clerk, tries to keep track of the employees but is often distracted by other things. Every Friday, she submits the time cards to Marsha, the payroll clerk.Marsha copies all time cards and files the copies in the employees’ folders. She uses employee wage records and tax tables to calculate the net pay for each employee. She sends a copy of the payroll register to the accounts payable department and files a copy in the payroll department. She updates the employee records with the earnings and prepares the payroll summary and sends it to the cash disbursements department along with the paychecks.After receiving the payroll summary, John, an accounts payable clerk, authorizes the cash disbursements department to prepare paychecks. John then updates the cash disbursements journal. The treasurer signs the paychecks and gives them to the…arrow_forward
- Automated 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_forwardPayroll: Risks and Controls Below are some of the processes that are typically executed before, during, and after a payroll cycle: Employees record their hours worked. The supervisor reviews and approves each employee's time records with their signature. An officer from the Human Resources department updates employee files after receiving authorized records of overtime and leaves (vacations, illness, etc.) from the supervisor. Afterward, approved records are sent to the payroll officer in the accounting department. The payroll officer calculates the gross payment, applies deductions, and calculates the net payment. Subsequently, the final payroll is sent for the controller's approval. Payments are issued to employees using their preferred delivery method (check or direct deposit). Entries are generated for the corresponding payroll transactions. Withholdings for payroll taxes, Social Security, and Medicare are respectively remitted to the Department of Treasury and the Internal…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
- 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) 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_forwardHolly employees use a time clock in an unsupervised area to record their time on the job. The timekeeping clerk tries to monitor the process but is often distracted by other duties. Every Friday, the shop foremen collect the time cards for their subordinates, review and approve them, and deliver them to the payroll clerk. The payroll clerk uses a stand-alone PC to record the employee earnings in the employee records and print a hard-copy payroll register. The payroll clerk sends one copy of the payroll register to the accounting department. The clerk then files the time cards and a copy of the payroll register in the payroll department. The accounting department clerk receives the payroll register, reviews it for accuracy, and uses the department computer to record the transaction by posting to subsidiary and GL accounts, including wages expense, cash, and various withholding accounts. The clerk then prints the hard-copy checks, which are written on the general cash account. The clerk…arrow_forward
- The amount of time over which an employee is paid is known as ___________. payroll pay period payroll register payroll clerkarrow_forwardSwenson Company has the following payroll procedures.Identify the payroll function to which each procedure pertains. Payroll Procedures Payroll Function (a) Supervisor approves overtime work. Hiring EmployeesPaying the PayrollPreparing the PayrollTimekeeping (b) The human resources department prepares hiring authorization forms for new hires. Hiring EmployeesPaying the PayrollPreparing the PayrollTimekeeping (c) A second payroll department employee verifies payroll calculations. Hiring EmployeesPaying the PayrollPreparing the PayrollTimekeeping (d) The treasurer’s department pays employees. Hiring EmployeesPaying the PayrollPreparing the PayrollTimekeepingarrow_forwardFlorenzo Corp. is a small manufacturing firm with 60 employees in seven departments. When the need arises for new workers in the plant, the departmental manager interviews applicants and hires on the basis of those interviews. The manager has each new employee complete a withholding form. The manager then writes the rate of pay on the W‐4 and forwards it to payroll. When workers arrive for their shift, they pull their time cards from a holder near the door and keep the time card with them during the day to complete the start and end times of their work day. On Friday, the time cards are removed from the holder and taken to payroll by any employee who is not busy that morning. If there were any pay rate changes for the payroll period due to raises or promotions, the manager calls the payroll department to inform payroll of these rate changes. Using the rate changes and the time cards, the payroll department prepares the checks from the regular bank account of Florenzo Corp. The manager…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Principles of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher:Cengage LearningExcel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning
- College Accounting, Chapters 1-27AccountingISBN:9781337794756Author:HEINTZ, James A.Publisher:Cengage Learning,
Principles of Cost Accounting
Accounting
ISBN:9781305087408
Author:Edward J. Vanderbeck, Maria R. Mitchell
Publisher:Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
College Accounting, Chapters 1-27
Accounting
ISBN:9781337794756
Author:HEINTZ, James A.
Publisher:Cengage Learning,