Complete the table of entity and activity-optional

Assignment Help Accounting Basics
Reference no: EM132651404

Question - DFD Test Narrative: Lou's Travel [Payroll Subsystem]

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.

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.

Required - Complete the Table of entity and activity-optional and Context diagram and Chronologically sorted table of entity and activity with groups, Level zero dfd.

Reference no: EM132651404

Questions Cloud

Professional development : Professional development prepares you to be the best educator you can be for your students and ensure continual growth as you remain current in the profession
What three specific pieces that would make change decision : Which option will you recommend to your manager? Why? What are three specific pieces of information that would make you change your decision?
What amount of dividends were paid during the month : At October 1, Waterway Enterprises reported stockholders' equity of $69300. What amount of dividends were paid during the month
How strategies promote collaboration and communication : Describe why these strategies were used and how the strategies promote collaboration, communication, critical thinking, and creativity.
Complete the table of entity and activity-optional : Complete the Table of entity and activity-optional and Context diagram and Chronologically sorted table of entity and activity with groups, Level zero dfd
What should the value of the company be : Assume TikTok has recently filed to go public in the United States. Assuming TikTok goes public at the end of 2020, what should the value of the company be?
Explain rewards systems for unions and their purpose : Explain alternative rewards systems for unions and their purpose. Your response must be a minimum of 200 words in length. Summarize and explain the influence.
What is the present value of compensation for each of jobs : Assume all cash flows occur at the end of the year. What is the present value of compensation for each of jobs through year 3?
By what amount the total assets must change : If total liabilities increased by $31000 and stockholders' equity increased by $20600 during a period of time, then total assets must change by what amount

Reviews

Write a Review

Accounting Basics Questions & Answers

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd