You are auditing FloorMart, a retailer with 200 stores around the country. It has two basic sizes of stores—minimarts with 3,000 square feet and maxim arts with 7,500 square feet. Both types of stores carry the same types of products. The client has provided an Excel file with the square feet, sales, and inventory at each store. This file must be downloaded from the web site thomsonedu.com/accounting/rittenberg under the tab “Student Resources.” It is labeled “Floor mat Data.”

Required

a. Using either Excel or ACL, identify the stores for which sales appear to be out of line with the other stores and will require additional evidence.

b. What procedures would the auditor use to gather the additional evidence?