Skip to main content

Anston Products sells equipment and parts to retailers throughout the United States

Answer all parts of these requirements on this page through page 7-33. It is more convenient to complete the assignment if you remove pages 7-31 and 7-33 now. For each requirement, include the command you used, where applicable, and the correct answer or exception(s) found. For requirements that require a printout, include the assignment number on the printout you hand in to the instructor.
Anston Products sells equipment and parts to retailers throughout the United States. You are planning tests of inventory purchases for the yea r ended 6/30115. Inventory acquisitions are by far the most significant acquisition transactions, and they a rerecorded in a separate acquisitions journal already included in ACL as the Inventory _Purchases table in the Anston Products project.
You have already completed the preliminary internal controls assessment for acquisitions and have identified several deficiencies. After completing planning, your assistant will be doing tests of controls and substantive tests of transactions for acquisitions, as well as year-end testing of accounts payable.
The IT department informed you that there a re 752 records in the file and the control totals for only the amount column is 4,090,981.79. The general ledger totals for inventory purchases are:
July
$ 234,250.59
January
$ 247,300.69
August
$ 190,742.00
February
$ 1,358,603.66
September
$ 311,244.41
March
$ 250,049.56
October
$ 176,435.11
April
$ 204,049.56
November
$ 300,942.85
May $ 321,416.05
December $ 301,940.49
June $ 293,731.16
Complete the following requirements using ACL:
Q 1. Use the Verify, Count, and Total commands to determine the completeness of the inventory purchases file and the accuracy of the information provided by IT. Explain.
Answer:
Q 2. Determine whether the general ledger monthly total is correct. Explain.
Answer:
Q 3. Without using any analysis commands, identify any date or data concerns that you believe require any follow-up. State what you did and any concerns identified.
Answer:
Q 4. Perform classify or summarize commands on the key fields as a test of their reasonableness. State each command you used, the fields used in the command, and any concerns that you believe require additional testing.
Answer:
Q 5. The audit plan calls for testing a random sample of all acquisition transactions, as well as tests of the existence and completeness of year-end accounts payable. Indicate how you would modify your testing in response to the concerns identified

Comments

Post a Comment

Popular posts from this blog

Should pit bull terriers be banned in my community

 Discussion Forum: Counterarguments (Should pit bull terriers be banned in my community) You created a question about the topic for your W6 Rough Draft. For this discussion, you will give an answer to that question in the form of a thesis statement. "Dieting Makes People Fat" Main Post: Share your thesis statement with your classmates. Please note: As with last week’s discussion, nothing here is set in stone. Be open to changing everything about your topic, including your position and audience, as you research it and get feedback from your classmates. Topic + Position/Purpose + Supporting Points =Thesis Statement Example: Suppose the question you posed in the Week 5 discussion was something like, “Should pit bull terriers be banned in my community?” After doing some preliminary research, you have concluded that pit bulls, if raised properly, are no more dangerous than other breeds of dogs. Your thesis statement can be something like, “Pitbulls should not be banned
Post a Comment
Read more

Controversy Associated With Dissociative Disorders

 Assignment: Controversy Associated With Dissociative Disorders The  DSM-5-TR  is a diagnostic tool. It has evolved over the decades, as have the classifications and criteria within its pages. It is used not just for diagnosis, however, but also for billing, access to services, and legal cases. Not all practitioners are in agreement with the content and structure of the  DSM-5-TR , and dissociative disorders are one such area. These disorders can be difficult to distinguish and diagnose. There is also controversy in the field over the legitimacy of certain dissociative disorders, such as dissociative identity disorder, which was formerly called multiple personality disorder. In this Assignment, you will examine the controversy surrounding dissociative disorders. You will also explore clinical, ethical, and legal considerations pertinent to working with patients with these disorders. Photo Credit: Getty Images/Wavebreak Media To Prepare · Review this week’s Learning
Post a Comment
Read more

CYBER SECURITY and how it can impact today's healthcare system and the future

 Start by reading and following these instructions: Create your Assignment submission and be sure to cite your sources, use APA style as required, and check your spelling. Assignment: Recommendations Document Due Week 6 (100 pts) Main Assignment Recommendations Document The 1250 to 1500-word deliverable for this week is an initial draft of your recommendations. Note that this is a working document and may be modified based on insights gained in module eight and your professor's feedback. This document should contain the following elements: Summary of your problem or opportunity definition A list of possible recommendation alternatives. In this section, you are not yet at the point of suggesting the best set of recommendations but you are trying to be creative and explore all the different ways that the problem or opportunity might best be addressed. The end result here will be a list of alternatives among which you will choose your final recom
Post a Comment
Read more