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…
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.…
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
- A weekly payroll summary made from labor time records shows the following data for Pima Company: Overtime is payable at one-and-a-half times the regular rate of pay and is distributed to all jobs worked on during the period. a. Determine the net pay of each employee. The income taxes withheld for each employee amount to 15% of the gross wages. b. Prepare journal entries for the following: 1. Recording the payroll. 2. Paying the payroll. 3. Distributing the payroll. (Assume that the overtime premium will be charged to all jobs worked on during the period.) 4. The employers payroll taxes. (Assume that none of the employees has achieved the maximum wage bases for FICA and unemployment taxes.)arrow_forwardAdams, Inc., pays its employees weekly wages in cash. A supplementary payroll sheet that lists the employees names and their earnings for a certain week is shown below. Complete the payroll sheet by calculating the total amount of payroll and indicating the least possible number of denominations that can be used in paying each employee. However, no employees are to be given bills in denominations greater than 20.arrow_forwardThe total wages and salaries earned by all employees of James Industries during the month of February, as shown in the labor cost summary and the schedule of fixed administrative and sales salaries, are classified as follows: a. Prepare a journal entry to distribute the wages earned during February. b. What is the total amount of payroll taxes that will be imposed on the employer for the payroll, assuming that three administrative employees with combined earnings this period of 4,500 have exceeded 8,000 in earnings prior to the period?arrow_forward
- The total wages and salaries earned by all employees of Langen Electronics, Ltd. during March, as shown in the labor cost summary and the schedule of fixed administrative and sales salaries, are classified as follows: a. Prepare a journal entry to distribute the wages earned during March. b. What is the total amount of payroll taxes that will be imposed on the employer for the payroll, assuming that two administrative employees with combined earnings this period of 3,000 have exceeded 8,000 in earnings prior to the period?arrow_forwardTrowbridge Company has just completed the processing of its year-end payroll and distributed all the weekly paychecks. The payroll department is now computing the amount of the annual bonus to be given each worker. What methods may be used by the company in determining the amount of federal income taxes to be withheld from the annual bonus payments?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_forward
- Matt 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_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. 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_forward
- A 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_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_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_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,Principles of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher:Cengage Learning
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, 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