In this case, students gather data to perform an internal audit of travel expenses for Fairfield Inc. Employees have submitted trips for reimbursement that include the address from which the employee left, the address to where they traveled and the employee’s self-reported mileage for the trip. Students will manually perform the task of mapping the distances using a commercial mapping service (Google Maps). Students will then write a bot that automates this process and then calculates the difference between the distance the bot collected and the employee self-reported distances.

Note that the EYARC Analytics mindset case study, Fairview Inc Case 2. travel expense audit, asks students to perform audit analytics procedures on the data this bot is designed to collect. A demonstration video of this bot is available. This case can be used in addition to (or independently of) this case.

Suitable courses: AIS, Audit, Data Analytics

Link to download files (requires login)