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.