Describe four computer assisted audit tests

Assignment Help Auditing
Reference no: EM13340760

You have just been assigned to manage the audit for a new large client of your firm, Cheap Music Downloads Inc. (CMD). CMD is a subsidiary of a client of your firm that manufactures audio and video equipment for international distribution. CMD has been in operation for two years, when its custom information systems were established.

CMD runs a web site that allows customers to order songs using their credit card only. There are tens of thousands of small transactions daily. Once the credit card has been authorized by the credit card processing intermediary, CMD's web sales system generates a 16 digit sequential code that the customer uses to access the song via the web site. CMD will then record both the sale and the royalty for the song.

Quarterly, CMD remits royalties to artists based upon the number of copies of the song that has sold, if the accumulated royalty exceeds $25.00 for that artist. Artist royalties that do not exceed $25.00 will be paid every two years if there has not been a payment during that time.

All contracted royalty rates, artist names and song titles are recorded in CMD's database tables. Some of the content of the database tables is listed below:

34_Describe four computer assisted audit tests.png

Required:

A. Describe four computer assisted audit tests (CAATs) that you could run using generalized audit software (such as ACL) in order to audit royalty expenses. For each test, describe the audit assertion associated with the test.

B. Describe three internal controls that should exist over sales or royalty transactions or over the database tables. For each control:

(i) State the control

(ii) Describe (not just state) the specific transaction-related audit assertion associated with the control (or state the purpose of the control)

(iii) Provide an audit test that you could use to test the control

C. Use the concept of rotational testing to discuss whether (or not) you would be required to test specific automated controls at CMD this year.

Reference no: EM13340760

Questions Cloud

Determine the moment of inertia of the flywheel : An energy storage system based on a flywheel (a rotating disk) can store a maximum of 4.2 MJ when the flywheel is rotating at 17,500revolutions per minute
Ow many neutrons are produced in the reaction : Write a nuclear reaction for the neutron-induced fission of U-235 to produce Te-137 and Zr-87 How many neutrons are produced in the reaction
Milk is an emulsion of oil/fat and water : Milk is an emulsion of oil/fat and water. Although both components are transparent the  mixture is opaque, as photons (particles of light that travel in straight lines at 2.998x108 m/s) that enter the mixture are scattered in random directions eac..
Determine what is the average acceleration of the elevator : An elevator is moving upward with a speed of 11 m/s.Three seconds later, the elevator is still moving upward, but its speed has been reduced to 5.0m/s what is the average acceleration of the elevator during the 3.0 s interval
Describe four computer assisted audit tests : Describe three internal controls that should exist over sales or royalty transactions or over the database tables and describe four computer assisted audit tests (CAATs) that you could run using generalized audit software in order to audit royalty ..
Should the brinkers accept this offer right away : Should the Brinkers accept this offer right away? What quantitative factors and what operational, qualitative or strategic factors should Five-speed and Wilbur take into account in making this decision?
What is velocity vector of point p located at the coordinate : A circular disk, centered at the origin of a coordinate system, is rotating at a constant angular velocity ?0. In Cartesian coordinates, what is the velocity vector of the point P located at the cartesian coordinate (1,1).
Explain glacial acetic acid is a liquid with a molarity : Glacial acetic acid is a liquid with a molarity of 17.4 M. Report your answer in mLs with the correct number of significant figures
Draw conclusions regarding the nature of the problem : Identify and describe or explain the problem that the managers of the organization in question are encountering. What has happened to make the managers realize that the problem has arisen? What is the likely cause of the problem?Why is the prob..

Reviews

Write a Review

Auditing Questions & Answers

  Accounting roles-standards and future changes

A solid set of accounting standards is also part of an economy's infrastructure. Investors don't want to put up capital unless there's a system that communicates financial results.

  Who is the chairman of the audit committee

What are the standards or legislations that management and auditor complied with as according to directors' responsibility paragraph and auditor's responsibility paragraph in the audit report?

  Prepare correct bank reconciliation

Prepare a correct bank reconciliation( Hint: Deduct the amount of the theft from the adjusted balance per books).

  Audit risk and its components

For each of the above independent situations: (1) describe the overall impact on audit risk and provide your reasons for your answer, and (2) identify the specific component(s) of audit risk affected.

  Ways of external auditor

Perhaps the issue of independence in internal audit departments goes back to, as you mentioned before, the morality of the internal audit staff. The internal audit department I worked for took the issue of independence seriously. It was important ..

  Write-off of bad debts and forgiveness income

How is the write-off of a bad debt handled on the tax return? How must the debtor handle the forgiveness of the debt? Why?

  What would be your biggest concerns regarding risk and why

Briefly explain what you would consider to be the top five vulnerabilities of Vista/Windows 7 and describe what are three similarities and three differences between the Trust Services Principles and COBIT 4.1?

  Database system-effective internal control system

Discuss how database systems along with their characteristics (such as referential integrity -- but there are others) can help companies have an effective internal control system. Gives the three database characteristics and explains them.

  Audit reports

Once a company has received a going-concern audit opinion, speculate to likelihood that company will remain in business.

  Which time he terminated his employment with jernigan

Behalf of the management to the board of director on the effectiveness of the new system - effectiveness and efficiency of the system - plans to establish a separate department that will provide internal audit service to his audit clients.

  Failure of tyco international

Discuss how auditing may have played a role in the failure of Tyco International. How did the audit process potentially contribute to the firm's failure?

  Objectives for goodners huntington sales office

Identify six key control weaknesses and its implication that were evident in Huntington unit's operations and develop control policies or procedures to alleviate the control weaknesses you identified in responding to question above.

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