Question: Is it inherently a control failure to have a GAP in sequence number?What could reasonably account for a gap?Why might a GAP indicate a control

  1. Is it inherently a control failure to have a GAP in sequence number?What could reasonably account for a gap?Why might a GAP indicate a control problem?
  2. Were any POs issued to vendors not on the vendor master list? If so how many and what are the potential problems?
  3. How would you determine if the open PO is a problem?Assume we are at calendar year end, which, if any, PO numbers should be investigated?
  4. Are there any POs where the Quantity received is not equal to the quantity ordered? If so, how many? Hint: Subtract quantity ordered from quantity received look for value not equal to 0.Why is this a problem?
  5. What might two vendors at the same address indicate?
  6. Are we using the lowest priced vendor most frequently? Please report the detailed information. Hint: use pivot table.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Q:

Using Excel to test controls in PO Data Obtain data file "AnyCO-C13 Excel Problem" from "name of site". Do any of the following activities to test the controls you have learned in this chapter 1....

Q:

1.Is it inherently a control failure to have a GAP in sequence number? What could reasonably account for a gap? Why might a GAP indicate a control problem? 2. Were any POs issued to vendors not on...

Q:

Is it inherently a control failure to have a GAP in sequence number? What could reasonably account for a gap? Why might a GAP indicate a control problem? Were any POs issued to vendors not on the...

Q:

Test the PO number sequence for out of sequence PO numbers (use sheet 1: AnyCO-POs). Hint: First make sure data is sorted in PO number order, add a column and use the Excel IF function (e.g., If...

Q:

0405441 Human Factors and Ergonomics Assignment 1 1. Summarise the events of Piper Alpha disaster based on the two articles found on the BB (in less than 500 words). 2. What were the causes of this...

Q:

This question makes reference to the audit report of Truscreen Limited, available at this link: TruScreen-audit report 2019.pdf Required: (e) Recent changes to the standard audit report were intended...

Q:

Required: (e) Recent changes to the standard audit report were intended to address the problem of the audit expectation gap. What component of the audit expectation gap is the audit report likely to...

Q:

There are two problems due this week (each worth 35 points) as follows. Problem 1.6 (page 20) In comprehensive paragraphs, answerrequirements a to e. You will have 5 paragraphs total of four to five...

Q:

-read chapter 5 1. Summarize Sackett v. EPA at the end of the chapter. 2. Choose any government agency (CIA, FCC, FDA, SEC, DEA etc. ) a. Describe the agency's function. b. When was it established...

Q:

can i get a solution to this question please. Value: Document (include your file name) 15% of final grade How to complete: 1. Read the following Anniversary Party scheduling problem: As the project...

Q:

Yachting in Paradise, Inc., was founded late in 2007 by retired Admiral Andy Willits to pro- vide executive retreats aboard a luxury yacht with ports of call scattered around the South Pacific....

Q:

Give a detailed explanation of abstract and virtual classes. How are they used and why? c#

Q:

10.3 A loan firm is being charged with discrimination in their policy on loan interest. (a) What hypothesis is being tested if a jury commits a type I error by finding the firm guilty? (b) What...

Q:

1. Buying groceries at the supermarket. 2. Selling a house 3. Getting married out of community of property. 4. Starting a new cellphone contract. 5. Arranging monthly instalments to pay for the car...

Q:

10. Using a conflict in your local community as your starting point, discuss how conflicts can be resolved using the following strategies: a) Making the cake bigger b) Providing compensation that is...

Q:

9. What is meant by the statement, the context is only relevant to us if we understand what it is trying to say?

Q:

7. What does it mean when we say that the words we use to denote a situation set limits on the solutions we can create at a later point?