Creating a Business Process Diagram and Database Queries to Detect Billing Errors and Analyze Calling Patterns for Cell Phone Service
Authors:
- 1 March 2007
- journal article
- Published by American Accounting Association in Journal of Information Systems
- Vol. 21 (1) , 107-122
Abstract
In this case, students develop a business process diagram to understand the business situation and create database queries to detect billing discrepancies and manage costs for corporate cell phone service. Using a database query tool or audit software, students query a database with tables for call details, invoices, invoice details, plan rates, and users on plan. The queries are representative of those that accountants could develop to analyze transaction-level data to detect errors and develop insights about business operations. Query-based approaches to analyzing transaction data can enable businesses to make sense of their operations and ensure that they and their trading partners comply with their mutual agreements. The case is appropriate for students with rudimentary database querying proficiency, e.g., at the level developed by Borthick et al.'s (2001) case on assuring compliance for responses to website referrals. No auditing expertise is needed. The case is appropriate for database analysis in accounting systems courses, compliance auditing in auditing courses, and cost analysis in managerial courses. The database is supplied in the form of a Microsoft Access® database.Keywords
This publication has 10 references indexed in Scilit:
- Analyzing a Potential Warranty Call Center Budget Overrun: Using Database Queries to Solve Business ProblemsJournal of Information Systems, 2005
- The Influence of Query Interface Design on Decision-Making Performance1MIS Quarterly, 2003
- Twenty-First Century AssuranceAUDITING: A Journal of Practice & Theory, 2002
- Developing Database Query Proficiency: Assuring Compliance for Responses to Web Site ReferralsJournal of Information Systems, 2001
- Language comprehension: Archival memory or preparation for situated action?Discourse Processes, 1999
- Situation models in language comprehension and memory.Psychological Bulletin, 1998
- DISCOURSE COMPREHENSIONAnnual Review of Psychology, 1997
- Two decades of structure buildingDiscourse Processes, 1997
- EDITORIAL Helping Users Get the Information They Want, When They Want It, In the Form They Want It: Integrating the Choice and Use of Information.Journal of Information Systems, 1992
- Degree of causal relatedness and memoryJournal of Memory and Language, 1987