Accounting Information Systems
10th Edition
ISBN: 9781337619202
Author: Hall, James A.
Publisher: Cengage Learning,
expand_more
expand_more
format_list_bulleted
Question
Chapter 10, Problem 7P
a.
To determine
Draw an REA diagram for Company C to support the payroll process.
b.
To determine
Depict the cardinalities to association between entities in REA diagram of Company C.
c.
To determine
Identify the tables, keys and attributes required for implementation of REA model.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these 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…
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…
The Tennis Club Company makes custom tennis rackets. The manufacturing supervisor interviews people who have specialized manufacturing skills for recruitment, and he informs payroll when an employee is hired. The employees punch a card to a time clock to record the hours they work. The employees are also required to keep a record of the time they spend working on each order. The supervisor approves all time cards.
The accountant analyzes the job tickets and prepares a labor distribution summary. Payroll prepares the payroll register and paychecks. The supervisor distributes the paychecks to the employees. Payroll informs cash disbursement of the funds required to cover the entire payroll amount. The cash disbursements clerk ensures that there are adequate funds in the company's regular checking account to cover the payroll.
Required:
1. Identify and discuss three internal control weaknesses.
2. Suggest an improvement to internal control for each weakness.
Chapter 10 Solutions
Accounting Information Systems
Ch. 10 - What is a user view?Ch. 10 - Prob. 2RQCh. 10 - Prob. 3RQCh. 10 - What are economic resources?Ch. 10 - What are economic events?Ch. 10 - Prob. 6RQCh. 10 - Prob. 7RQCh. 10 - Prob. 8RQCh. 10 - Prob. 9RQCh. 10 - Prob. 10RQ
Ch. 10 - Prob. 11RQCh. 10 - Prob. 12RQCh. 10 - Prob. 13RQCh. 10 - Prob. 14RQCh. 10 - Prob. 15RQCh. 10 - Prob. 16RQCh. 10 - Prob. 17RQCh. 10 - Prob. 18RQCh. 10 - Prob. 19RQCh. 10 - Prob. 20RQCh. 10 - Prob. 1DQCh. 10 - Explain the relationship between cardinality and...Ch. 10 - Prob. 3DQCh. 10 - Prob. 4DQCh. 10 - Prob. 5DQCh. 10 - Prob. 6DQCh. 10 - Distinguish between economic events and support...Ch. 10 - Prob. 8DQCh. 10 - Why are traditional accounting events, such as...Ch. 10 - Prob. 10DQCh. 10 - Prob. 11DQCh. 10 - Prob. 12DQCh. 10 - Prob. 1MCQCh. 10 - Which of the following is not a characteristic of...Ch. 10 - Prob. 3MCQCh. 10 - Which of the following associations would most...Ch. 10 - Prob. 5MCQCh. 10 - Prob. 6MCQCh. 10 - Prob. 7MCQCh. 10 - Prob. 8MCQCh. 10 - Prob. 9MCQCh. 10 - Prob. 10MCQCh. 10 - Prob. 1PCh. 10 - Bentley Restorations Company restores and sells...Ch. 10 - Prob. 3PCh. 10 - Prob. 4PCh. 10 - Prepare an REA model depicting the issuance of raw...Ch. 10 - Cryogenics Inc., is a leading developer, designer,...Ch. 10 - Prob. 7PCh. 10 - Prob. 8PCh. 10 - Prob. 9PCh. 10 - Prob. 10P
Knowledge Booster
Similar questions
- 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_forwardDave’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_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 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. Required Identify the segregation of duties problems in the system. 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_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
- Holly 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_forwardHome Depot Kenya ltd employees use a time clock in an unsupervised area to record their time on the job. The time-keeping 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 general ledger accounts including wages expense, cash, and various withholding accounts. The clerk then prints the hard-copy checks, which are writ- ten on…arrow_forwardHome Depot Kenya ltd employees use a time clock in an unsupervised area to record theirtime on the job. The time-keeping 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 employeerecords and print a hard-copy payroll register. The payroll clerk sends one copy of the payrollregister to the accounting department. The clerk then files the time cards and a copy of thepayroll register in the payroll department.The accounting department clerk receives the payroll register, reviews it for accuracy, anduses the department computer to record the transaction by posting to subsidiary and generalledger accounts including wages expense, cash, and various withholding accounts. The clerkthen prints the hard-copy checks, which are written on the general cash…arrow_forward
- Payroll Processing SystemHolly employees use a time clock in an unsupervised area to record their time on the job. The time-keeping clerk tries to monitor the process, but is often distracted by other duties. Every Friday, the shop foremen collects the time cards for their subordinates, review and approve them, and deliver them to the payroll clerk. The payroll clerk uses a standalone 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 general ledger ac- counts, including wages expense, cash, and various withholding accounts. The clerk then prints the hard-copy checks, which are…arrow_forward< Internal control procedures 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 their entire department in and out. 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…arrow_forward> Mary Tan is the controller for Duck Associates, a property management company in Portland, Oregon. Each year, Tan and payroll clerk Toby Stock meet with the external auditors about payroll accounting. This year, the auditors suggest that Tan consider outsourcing Duck Associates's payroll accounting to a company specializing in payroll processing services. This would allow Tan and her staff to focus on their primary responsibility: accounting for the properties under management. At present, payroll requires 1.5 employee positions-payroll clerk Toby Stock and a bookkeeper who spends half her time entering payroll data in the system. meniups/l Tan considers this suggestion, and she lists the following items relating to out- sourcing payroll accounting: a. The current payroll software that was purchased for $4,000 three years ago would not be needed if payroll processing were outsourced. b. uck Associates's bookkeeper would spend half her time preparing the weekly payroll input form that…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 Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
- Business Its Legal Ethical & Global EnvironmentAccountingISBN:9781305224414Author:JENNINGSPublisher:Cengage
Auditing: A Risk Based-Approach (MindTap Course L...AccountingISBN:9781337619455Author:Karla M Johnstone, Audrey A. Gramling, Larry E. RittenbergPublisher:Cengage Learning
Principles of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher:Cengage Learning
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
Business Its Legal Ethical & Global Environment
Accounting
ISBN:9781305224414
Author:JENNINGS
Publisher:Cengage
Auditing: A Risk Based-Approach (MindTap Course L...
Accounting
ISBN:9781337619455
Author:Karla M Johnstone, Audrey A. Gramling, Larry E. Rittenberg
Publisher:Cengage Learning
Principles of Cost Accounting
Accounting
ISBN:9781305087408
Author:Edward J. Vanderbeck, Maria R. Mitchell
Publisher:Cengage Learning