Question
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
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started