Problem 1

After reviewing a list of parties related to Roger Company, you notice that the customers with customer numbers 100180 and 100140 are related to the owners of the company. Please use the Roger Company Accounts_Receivable file to determine the amount of accounts receivable that relates to sales made to these related-party customers. What percent of total accounts receivable are made up of sales to these two related-party customers? Use the table provided to input your answers. (Hint: Find the Customer_Number you want, then right-click and select "Display All Records Containing...". Consider using Control Total to find total of invoices.)

100180

100140

Total

Number of sales transactions made with customer

Total amount of the transactions

Percentage of AR Transactions

Problem 2

As part of the audit of Accounts Payable, you want to identify all invoices (Invoice_Amount) greater than $50,000 so that you can vouch the transaction to original documentation (i.e., approved purchase order, receiving records). Using the Roger Company Accounts_Payable file identify the invoice numbers for all accounts payable invoices greater than $50,000 and compute the total value of those transactions. Why is it important for auditors to determine if large purchases are properly authorized?