Questions from Accounting Information Systems

Q: a. Download the spreadsheet for this problem from the course Web

a. Download the spreadsheet for this problem from the course Web site. b. In column I, under the label “Ghost Employee?” write a function that compares the employee# in the timecards column to the em...

Q: What internal control procedure(s) would be most effective in

What internal control procedure(s) would be most effective in preventing the following errors or fraudulent acts? a. An inadvertent data entry error caused an employee’s wage rate to be overstated in...

Q: Although most medium and large companies have implemented sophisticated payroll and HRM

Although most medium and large companies have implemented sophisticated payroll and HRM systems like the one described in this chapter, many smaller companies still maintain separate payroll and HRM s...

Q: Arlington Industries manufactures and sells engine parts for large industrial equipment.

Arlington Industries manufactures and sells engine parts for large industrial equipment. The company employs over 1,000 workers for three shifts, and most employees work overtime when necessary. Figur...

Q: Objective: Learn how to find and correct errors in complex spreadsheets

Objective: Learn how to find and correct errors in complex spreadsheets used for payroll. a. Read the article “Ferret Out Spreadsheet Errors” by Mark G. Simkin, in the Journal of Accountancy (Februar...

Q: Objective: Learn how to use the VLOOKUP function for payroll calculations

Objective: Learn how to use the VLOOKUP function for payroll calculations. a. Read the article “Make Excel a Little Smarter” by Lois S. Mahoney and Charles Kelliher in the Journal of Accountancy (Jul...

Q: Payroll has traditionally been an accounting function and some CPAs have provided

Payroll has traditionally been an accounting function and some CPAs have provided payroll processing services to their clients. Today, CPAs are finding additional new lucrative opportunities to provid...

Q: What is the purpose of each of the following control procedures (

What is the purpose of each of the following control procedures (i.e., what threats is it designed to mitigate)? a. Compare a listing of current and former employees to the payroll register. b. Recon...

Q: a. Read the article “Tweaking the Numbers,” by Theo

a. Read the article “Tweaking the Numbers,” by Theo Callahan in the June 2001 issue of the Journal of Accountancy (either the print edition, likely available at you...

Q: Which control procedure would be most effective in addressing the following problems

Which control procedure would be most effective in addressing the following problems? a. When entering a journal entry to record issuance of new debt, the treasurer inadvertently transposes two digit...