![Page 1: Accounting Information Systems: Essential Concepts and Applications Fourth Edition by Wilkinson, Cerullo, Raval, and Wong-On-Wing Module 2: Decision Support](https://reader030.vdocuments.us/reader030/viewer/2022032516/56649c7b5503460f9492e6f5/html5/thumbnails/1.jpg)
Accounting Information Systems: Accounting Information Systems: Essential Concepts and ApplicationsEssential Concepts and Applications Fourth Edition by Wilkinson, Cerullo, Raval, and Fourth Edition by Wilkinson, Cerullo, Raval, and Wong-On-WingWong-On-Wing
Module 2: Decision Support and Expert Systems
Slides Authored by Somnath Bhattacharya, Ph.D.Florida Atlantic University
![Page 2: Accounting Information Systems: Essential Concepts and Applications Fourth Edition by Wilkinson, Cerullo, Raval, and Wong-On-Wing Module 2: Decision Support](https://reader030.vdocuments.us/reader030/viewer/2022032516/56649c7b5503460f9492e6f5/html5/thumbnails/2.jpg)
Decision Support Systems: Advantages
Improved effectiveness in making strategic and tactical decisions
Greater timeliness in collecting and processing the needed data that bear on unstructured and semi-structured decisions
Broader understanding by the decision makers of the array of factors involved in problems requiring complex decisions and their relationships to each other
![Page 3: Accounting Information Systems: Essential Concepts and Applications Fourth Edition by Wilkinson, Cerullo, Raval, and Wong-On-Wing Module 2: Decision Support](https://reader030.vdocuments.us/reader030/viewer/2022032516/56649c7b5503460f9492e6f5/html5/thumbnails/3.jpg)
Key Components of a Decision Support System
DSS data base DSS model base
DSS userinterface
Terminal ormicrocomputer
User
Figure M2-1
![Page 4: Accounting Information Systems: Essential Concepts and Applications Fourth Edition by Wilkinson, Cerullo, Raval, and Wong-On-Wing Module 2: Decision Support](https://reader030.vdocuments.us/reader030/viewer/2022032516/56649c7b5503460f9492e6f5/html5/thumbnails/4.jpg)
A Comprehensive Data Base that Spans a Firm’s Decision Needs
Environmental Data Internal Planning Data
Other Model Data Summaries
Chart of Accounts
CustomerData
InventoryData
SupplierData
EmployeeData
Property(plantassets)Data
Sales Order Production& ShippingRecords
PurchaseOrders
TimeRecords
DisbursementRecords
}
}*
**
* = Planning data base** = Operational data base
Figure M2-2
![Page 5: Accounting Information Systems: Essential Concepts and Applications Fourth Edition by Wilkinson, Cerullo, Raval, and Wong-On-Wing Module 2: Decision Support](https://reader030.vdocuments.us/reader030/viewer/2022032516/56649c7b5503460f9492e6f5/html5/thumbnails/5.jpg)
DSS Model Base
Decision Models Decision models Optimization models
Firm-wide Planning Models Corporate models Financial planning models
Modeling LanguagesModel Base Management Systems
![Page 6: Accounting Information Systems: Essential Concepts and Applications Fourth Edition by Wilkinson, Cerullo, Raval, and Wong-On-Wing Module 2: Decision Support](https://reader030.vdocuments.us/reader030/viewer/2022032516/56649c7b5503460f9492e6f5/html5/thumbnails/6.jpg)
A Variety of Models Used by Decision Support SystemsModel Description 1) Regression 2) Exponential smoothing 3) PERT 4) Linear programming 5) Line-of-balance 6) Economic order quantity 7) Supplier evaluation 8) Transportation 9) Discounted cash-flow 10) Production cost-variance 11) Cash-flow 12) Budget
13) Manpower planning
Typical Function Aided 1) Sales forecasting 2) Sales forecasting 3) Engineering design 4) Production scheduling 5) Production routing 6) Inventory control 7) Purchasing 8) Physical distribution 9) Investment planning 10) Cost analysis 11) Financing 12) Accounting control 13) Personnel planning
Figure M2-3
![Page 7: Accounting Information Systems: Essential Concepts and Applications Fourth Edition by Wilkinson, Cerullo, Raval, and Wong-On-Wing Module 2: Decision Support](https://reader030.vdocuments.us/reader030/viewer/2022032516/56649c7b5503460f9492e6f5/html5/thumbnails/7.jpg)
Model Manipulation Techniques Used with Financial Models
Time-Based Simulation
“What-If” Analysis
Sensitivity Analysis
Goal-seeking Analysis
Figure M2-4
![Page 8: Accounting Information Systems: Essential Concepts and Applications Fourth Edition by Wilkinson, Cerullo, Raval, and Wong-On-Wing Module 2: Decision Support](https://reader030.vdocuments.us/reader030/viewer/2022032516/56649c7b5503460f9492e6f5/html5/thumbnails/8.jpg)
More on Model-Base Management Systems
This is a modeling counterpart to a DBMSIts functions usually consist of providing
Links between models in a DSS A model definition language Mechanisms for modifying decision
models A user-friendly means of
executing and manipulating models
![Page 9: Accounting Information Systems: Essential Concepts and Applications Fourth Edition by Wilkinson, Cerullo, Raval, and Wong-On-Wing Module 2: Decision Support](https://reader030.vdocuments.us/reader030/viewer/2022032516/56649c7b5503460f9492e6f5/html5/thumbnails/9.jpg)
User Interfaces
Query Languages
Command language approach
Menu approach
GUI
![Page 10: Accounting Information Systems: Essential Concepts and Applications Fourth Edition by Wilkinson, Cerullo, Raval, and Wong-On-Wing Module 2: Decision Support](https://reader030.vdocuments.us/reader030/viewer/2022032516/56649c7b5503460f9492e6f5/html5/thumbnails/10.jpg)
Group Decision Support Systems
GDSSs allow for the rapid dissemination of information and support collaboration among group members Electronic mail software Lotus Notes
![Page 11: Accounting Information Systems: Essential Concepts and Applications Fourth Edition by Wilkinson, Cerullo, Raval, and Wong-On-Wing Module 2: Decision Support](https://reader030.vdocuments.us/reader030/viewer/2022032516/56649c7b5503460f9492e6f5/html5/thumbnails/11.jpg)
Expert Systems
An Expert System is a computerized software model that simulates the thinking process of one or more human experts in solving a complex problem or in making a decision.
![Page 12: Accounting Information Systems: Essential Concepts and Applications Fourth Edition by Wilkinson, Cerullo, Raval, and Wong-On-Wing Module 2: Decision Support](https://reader030.vdocuments.us/reader030/viewer/2022032516/56649c7b5503460f9492e6f5/html5/thumbnails/12.jpg)
Components of an Expert System
Knowledge BaseTask-specific Data BaseInference Engine
Forward chaining Backward chaining
Development Engine
![Page 13: Accounting Information Systems: Essential Concepts and Applications Fourth Edition by Wilkinson, Cerullo, Raval, and Wong-On-Wing Module 2: Decision Support](https://reader030.vdocuments.us/reader030/viewer/2022032516/56649c7b5503460f9492e6f5/html5/thumbnails/13.jpg)
Components of an Expert System
Inference Engine Knowledge Base
User Interface
Task Specific Data Base
Users
Figure M2-6
![Page 14: Accounting Information Systems: Essential Concepts and Applications Fourth Edition by Wilkinson, Cerullo, Raval, and Wong-On-Wing Module 2: Decision Support](https://reader030.vdocuments.us/reader030/viewer/2022032516/56649c7b5503460f9492e6f5/html5/thumbnails/14.jpg)
Decision Situations and DSSs
Complex
Simple
Expert Systems
Conventional Software Statistics
Neural Network Technology
Pro
ble
m C
omp
lexi
ty
Structured Semi-structured Unstructured Completely Random
Decision SituationFigure M2-7
![Page 15: Accounting Information Systems: Essential Concepts and Applications Fourth Edition by Wilkinson, Cerullo, Raval, and Wong-On-Wing Module 2: Decision Support](https://reader030.vdocuments.us/reader030/viewer/2022032516/56649c7b5503460f9492e6f5/html5/thumbnails/15.jpg)
Factors to Consider when Selecting Accounting ES Applications - I
Problems or decisions requiring judgment are moderately complex to very complex and well-defined
Operational and tactical problems are highly structured to somewhat semi-structured, recurring, and repetitive
Expertise is difficult to acquire. Human experts are expensive and in short supply. Non-human expertise is available in the form of authoritative pronouncements, such as APBs, FASBs, and IRS tax regulations
The accounting problem can be solved in a relatively short period of time
The accounting problem is rule-intensive and can be solved with “if-then” rules
Figure M2-8
![Page 16: Accounting Information Systems: Essential Concepts and Applications Fourth Edition by Wilkinson, Cerullo, Raval, and Wong-On-Wing Module 2: Decision Support](https://reader030.vdocuments.us/reader030/viewer/2022032516/56649c7b5503460f9492e6f5/html5/thumbnails/16.jpg)
Factors to Consider when Selecting Accounting ES Applications - II
Common sense or intuition is not required to solve the problems
The accounting problem cannot be solved efficiently with traditional or conventional computer software programs, such as COBOL or FORTRAN
The body of knowledge is being continually updated
The problem’s conversion to a computer-based expert system must result in a high payoff
The expert system must produce clearly identified solutions with which most experts must agree among themselves
Figure M2-8 Continued
![Page 17: Accounting Information Systems: Essential Concepts and Applications Fourth Edition by Wilkinson, Cerullo, Raval, and Wong-On-Wing Module 2: Decision Support](https://reader030.vdocuments.us/reader030/viewer/2022032516/56649c7b5503460f9492e6f5/html5/thumbnails/17.jpg)
Areas of Accounting Expert Systems: Auditing (Internal & External)
Deciding whether to accept a prospective auditeeEvaluating risks and the internal control structure
in computer systemsReviewing prior years’ working papersIssuing audit reports and forming audit opinionsWriting audit programsAssisting in making a going-concern judgmentScheduling audit personnelAnalyzing the adequacy of the allowance for
doubtful accountsAnalyzing unusual transactions
Figure M2-9
![Page 18: Accounting Information Systems: Essential Concepts and Applications Fourth Edition by Wilkinson, Cerullo, Raval, and Wong-On-Wing Module 2: Decision Support](https://reader030.vdocuments.us/reader030/viewer/2022032516/56649c7b5503460f9492e6f5/html5/thumbnails/18.jpg)
Areas of Accounting Expert Systems: Taxation
Advising on potential acquisitions and mergers
Claiming a dependentAuditing deferred tax accrualsDetermining corporate tax statusDetermining if a firm qualifies for
Subchapter S tax statusOffering personal and corporate tax
planning advice
Figure M2-9 Continued
![Page 19: Accounting Information Systems: Essential Concepts and Applications Fourth Edition by Wilkinson, Cerullo, Raval, and Wong-On-Wing Module 2: Decision Support](https://reader030.vdocuments.us/reader030/viewer/2022032516/56649c7b5503460f9492e6f5/html5/thumbnails/19.jpg)
Areas of Accounting Expert Systems: Cost/Managerial
Analyzing significant variances and explaining the variation
Assisting in monthly closingsAllocating revenue and expensesAnalyzing performance of projectsReviewing trial balances
Figure M2-9 Continued
![Page 20: Accounting Information Systems: Essential Concepts and Applications Fourth Edition by Wilkinson, Cerullo, Raval, and Wong-On-Wing Module 2: Decision Support](https://reader030.vdocuments.us/reader030/viewer/2022032516/56649c7b5503460f9492e6f5/html5/thumbnails/20.jpg)
Areas of Accounting Expert Systems: Financial Accounting
Accounting for non-monetary transactions (APB No. 29)
Accounting for contingencies (FAS No. 5)Purchasing vs. pooling (APB No. 16)Accounting for futures contracts (FAS No.
80)Developing expert systems for other
professional pronouncementsClassifying financial transactions correctlyEvaluating credit worthiness
Figure M2-9 Continued
![Page 21: Accounting Information Systems: Essential Concepts and Applications Fourth Edition by Wilkinson, Cerullo, Raval, and Wong-On-Wing Module 2: Decision Support](https://reader030.vdocuments.us/reader030/viewer/2022032516/56649c7b5503460f9492e6f5/html5/thumbnails/21.jpg)
Examples of ES in Accounting: Auditing
Name Purpose Developer
Loan Probe To assist banks inassessing commercialloan portfolios
KPMG PeatMarwick
Auditor To assist in evaluatingthe adequacy of theallowance for baddebts
Dungan(University ofSouth Florida)
EDP-XPERT To aid auditspecialists inevaluating thereliability of controlsin computer systems
Hansen andMessier(University ofFlorida)
GC-X To aid in makinggoing-concernjudgments
Biggs andSelfridge(University ofConnecticut)
Audit Planner To aid in makingmateriality judgments
Steinbart(Arizona State
Figure M2-10
![Page 22: Accounting Information Systems: Essential Concepts and Applications Fourth Edition by Wilkinson, Cerullo, Raval, and Wong-On-Wing Module 2: Decision Support](https://reader030.vdocuments.us/reader030/viewer/2022032516/56649c7b5503460f9492e6f5/html5/thumbnails/22.jpg)
Examples of ES in Accounting: Tax
Name Purpose Developer
TAXADVISOR To aid tax specialistsin rendering estateplanning advice
Michaelson(University ofNorth Texas)
ExperTAX To aid in tax planningand corporate taxaccruals
Coopers andLybrand
Taxpayer ServiceAssistant
To aid IRS agents inanswering taxpayerquestions on complextax issues
IRS
Figure M2-10 Continued
![Page 23: Accounting Information Systems: Essential Concepts and Applications Fourth Edition by Wilkinson, Cerullo, Raval, and Wong-On-Wing Module 2: Decision Support](https://reader030.vdocuments.us/reader030/viewer/2022032516/56649c7b5503460f9492e6f5/html5/thumbnails/23.jpg)
Emerging Developments
Intelligent Agent SoftwareIntegrating DSSs with other support
systemsFuzzy LogicDevelopments in Multimedia and
Hypertext
![Page 24: Accounting Information Systems: Essential Concepts and Applications Fourth Edition by Wilkinson, Cerullo, Raval, and Wong-On-Wing Module 2: Decision Support](https://reader030.vdocuments.us/reader030/viewer/2022032516/56649c7b5503460f9492e6f5/html5/thumbnails/24.jpg)
Copyright © 2000 John Wiley & Sons, Inc. All rights reserved. Reproduction or translation of this work beyond that permitted in Section 117 of the 1976 United States Copyright Act without the express written permission of the copyright owner is unlawful. Request for further information should be addressed to the Permissions Department, John Wiley & Sons, Inc. The purchaser may make back-up copies for his/her own use only and not for distribution or resale. The publisher assumes no responsibility for errors, omissions, or damages, caused by the use of these programs or from the use of the information contained herein.
Accounting Information Systems: Accounting Information Systems: Essential Concepts and ApplicationsEssential Concepts and Applications Fourth Edition by Wilkinson, Cerullo,Fourth Edition by Wilkinson, Cerullo,Raval, and Wong-On-WingRaval, and Wong-On-Wing