Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Lous Travel is an independent travel agency. The following system is used by Lous Travel to process weekly payroll for hourly personnel. Lous Travel has

Lou’s Travel is an independent travel agency. The following system is used by Lou’s Travel to process weekly payroll for hourly personnel. Lou’s Travel has a central data processing department. Payroll personnel have online access from terminals located in the payroll department. (Start Drawing here) Paragraph 1: listed by sentence The process begins as data processing prints time sheets from the employee/payroll master file. The payroll department distributes the time sheets to the various departments (internal entity). The employees (in each Department) fill in the time sheets each day. Department supervisors review and sign the time sheets at the end of the week and return them to the payroll department. Paragraph 2: listed by sentence The payroll department arranges the time sheets alphabetically by department (received at the end of the week.) Payroll clerks update the Sick and vacation log file for vacation or sick leave hours. If an employee has exceeded the allowable hours, the clerk marks the hours as “leave without pay” on the time sheet. This is an exception. The time sheets and any special adjustments are then keyed into the current week activity file by the clerks. The time sheets are then filed alphabetically in the Time record history file. Paragraph 3: listed by sentence When the activity file is verified, the data processing department runs a “missing persons” list of active employees who show no time sheet entry for the current week. Payroll contacts the appropriate supervisor to resolve the problem and requests a time sheet if necessary. This is an exception. If the employee does not bring a time sheet soon enough, he or she has to request a manual paycheck be prepared. A manual paycheck is an adjustment in the following week’s payroll run. Otherwise, the missing late time sheet is keyed and verified before the payroll is run. The use of a manual check and/or late time sheet is very unusual. The “missing persons” report is forwarded to the Controller. Paragraph 4: listed by sentence Payroll processing is performed by the data processing department. The system creates the current week pay register file, using the employee/payroll master file and the current week activity file. The general ledger file is updated. The following items are printed from the current week pay register file: paychecks with attached stubs, pay stubs for direct deposit checks, a check register (the listing of all checks), a payroll register (the listing of each employee paycheck calculated from gross to net pay), and various payroll reports. Paragraph 5: listed by sentence The paychecks with attached stubs, pay stubs for direct deposit checks, payroll register, and check register are given to the cashier. The payroll reports are given to the Controller. The cashier gets the check-signing machine and signs the paychecks. The cashier checks the total dollar amount and the number of checks and direct deposits against the payroll register. She places the checks with attached stubs and pay stubs for direct deposit in envelopes. She gives these to the department supervisors, who sign for them and give them to the employees. Money to fund the bank payroll account is transferred to the bank by wire transfer. Complete: Table of entity and activity--optional Context diagram Chronologically sorted table of entity and activity with groups Level zero dfd

Step by Step Solution

3.40 Rating (159 Votes )

There are 3 Steps involved in it

Step: 1

ANSWER It is an enormous database that helps travel agents and travel websites store and ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managerial Accounting

Authors: Susan V. Crosson, Belverd E. Needles

8th Edition

9780618777174, 618777180, 618777172, 978-0618777181

More Books

Students also viewed these Accounting questions

Question

Graph the solution sets in Problems 316. x 100

Answered: 1 week ago

Question

express more than actually felt (amplification),

Answered: 1 week ago