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

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

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

Do violent video games encourage players to become violent in real life?

 Write an outline for Speech 3, the persuasive belief speech, following the outline guidelines and formatting requirements (Do violent video games encourage players to become violent in real life?).  1000-1200 WORDS https://virtualspeech.com/blog/persuasive-speech-outline-structure-delivery Topics: https://blog.prepscholar.com/good-persuasive-speech-topics Do violent video games encourage players to become violent in real life? https://www.youtube.com/watch?v=YKKWOx43pIY WE HAVE DONE THIS ASSIGNMENT BEFORE, WE CAN ALSO DO IT FOR YOU GET SOLUTION FOR THIS ASSIGNMENT,  Get Impressive Scores in Your Class CLICK HERE TO MAKE YOUR ORDER   on Do violent video games encourage players to become violent in real life? Are You looking for Assignment and Homework Writing help?  We Provide High-Quality Academic Papers at Affordable Rates. No Plagiarism. TO BE RE-WRITTEN FROM THE SCRATCH