Accounting and IT 2e Donna Kay Ali Ovlia
Active Review ww
1.1 Refer to the chapter opener, Meet Business Intelligence. In your opinion, how can business i
ww ww ww ww ww ww ww ww ww ww ww ww ww ww
ntelligence create value using the accounting system?
ww ww ww ww ww ww
Students’ opinion may differ. However, their opinion should include: Increase profitability, impr
ww ww ww ww ww ww ww ww ww ww ww
ove customer relationship, increase sales by targeting the right customer category, and in general
ww ww ww ww ww ww ww ww ww ww ww ww ww w
improving all aspects of business activities.
w ww ww ww ww ww
1.2 Refer to the chapter opener, Meet Business Intelligence. Discuss the importance of sal
ww ww ww ww ww ww ww ww ww ww ww ww
es data in creating business intelligence for an organization.
ww ww ww ww ww ww ww ww
Business intelligence allows organization to continuously monitor their sales transaction. By mo
ww ww ww ww ww ww ww ww ww ww ww
nitoring sales, enterprise can fine-
ww ww ww ww
tune other business processes such as purchasing, production, advertising, and customer servic
ww ww ww ww ww ww ww ww ww ww ww
e.
1.3 Pick your favorite Accounting Insight from Chapter 1. Discuss why it’s your favorite.
ww ww ww ww ww ww ww ww ww ww ww ww
The answer to this question depends on the student selection and his/her reason for selecting it.
ww ww ww ww ww ww ww ww ww ww ww ww ww ww ww
1.4 What are the modules in the baseline accounting system model? Discuss the purposes and tr
ww ww ww ww ww ww ww ww ww ww ww ww ww ww
ansactions associated with each module.
ww ww ww ww
1 . Vendors. This module encapsulates all data and business processes related to vendors. The tra
ww ww ww ww ww ww ww ww ww ww ww ww ww
nsactions associated with Vendors module are: Create purchase Order, Receive Items, and Ent
ww ww ww ww ww ww ww ww ww ww ww ww
er Bills.
ww
2 . Customers. This module encapsulates all data and business processes related to customers. The
ww ww ww ww ww ww ww ww ww ww ww ww
processes associated with Customers module are: Create Invoice, and Receive Customer Pay
w w ww ww ww ww ww ww ww ww ww ww ww
ments.
3 . Employees. This module encapsulates all data and business processes related to employees. Th
ww ww ww ww ww ww ww ww ww ww ww ww
e processes associated with Vendor module are: Enter Time and Calculate Payroll.
ww ww ww ww ww ww ww ww ww ww ww
4 . Banking. This module encapsulates all data and business processes related to organization ban
ww ww ww ww ww ww ww ww ww ww ww ww
king. The processes associated with Banking module are: Pay Bills, Make Deposit, Pay Empl
ww ww ww ww ww ww ww ww ww ww ww ww ww
oyees, and Pay Payroll Liabilities.
ww ww ww ww
5 . Financials. This module encapsulates all data and business processes related to the organizatio
ww ww ww ww ww ww ww ww ww ww ww ww
n financials. The processes associated with Financial module are: Adjusting Entries, Correcting
ww ww ww ww ww ww ww ww ww ww ww
Entries, Closing, and ad-hoc financial activities.
ww ww ww ww ww ww
6 . Reports. This module encapsulates all data and business processes related to the accounting re
ww ww ww ww ww ww ww ww ww ww ww ww ww
ports. The processes associated with Reports module are: Management Reports, Tax Reports,
ww ww ww ww ww ww ww ww ww ww ww ww
External Financial Reports, and Sustainability Reports.
ww ww ww ww ww
1.5 Discuss how the features of a spreadsheet and a database are similar and how they are different.
ww ww ww ww ww ww ww ww ww ww ww ww ww ww ww ww
A spreadsheet shows rows and columns of a table and that is same as database table’s recor
ww ww ww ww ww ww ww ww ww ww ww ww ww ww ww ww
ds and fields features. Actually, a spreadsheet row is a record and a column is a field in a
ww ww ww ww ww ww ww ww ww ww ww ww ww ww ww ww ww ww
database table
ww ww
1.6 Discuss the potential risks if a company’s accounting system is not well secured.
ww ww ww ww ww ww ww ww ww ww ww ww
Unauthorized access to the accounting data and software could result in valuable information bei
ww ww ww ww ww ww ww ww ww ww ww ww ww
ng stolen or damaged and virus or other malicious software damage accounting systems softw
ww ww ww ww ww ww ww ww ww ww ww ww ww
are.
1.7 Discuss the benefits of an integrated enterprise system.
ww ww ww ww ww ww ww
,An integrated enterprise system allows data to be shared among various enterprise departments.
ww ww ww ww ww ww ww ww ww ww ww ww
For example, an advertising department can use data collected about sales to cluster customers
ww ww ww ww ww ww ww ww ww ww ww ww ww ww w
into categories and target customers-categories with different adverting methods.
w ww ww ww ww ww ww ww ww
1.8 Discuss how value chain activities are related to accounting transaction cycles.
ww ww ww ww ww ww ww ww ww ww
The value chain facilitates coordination of activities with suppliers and customers, including purch
ww ww ww ww ww ww ww ww ww ww ww ww
asing and sales transactions.
ww ww ww
1.9 Discuss the significance of information technology to the accounting professional.
ww ww ww ww ww ww ww ww ww
Today, most accounting systems are computerized systems. These accounting systems are installe
ww ww ww ww ww ww ww ww ww ww ww
d on the enterprise computers and used on the enterprise internal networks as well as the Inte
ww ww ww ww ww ww ww ww ww ww ww ww ww ww ww ww
rnet. To effectively work with computers and use accounting systems, accountants must know
ww ww ww ww ww ww ww ww ww ww ww ww ww
enough about computers and networks to be able to use computerized accounting systems.
ww ww ww ww ww ww ww ww ww ww ww ww
1.1 0 Discuss problems that enterprises may experience with shadow data.
ww ww ww ww ww ww ww ww
Shadow data little or lack of documentation and lack or inadequate security and control are two
ww ww ww ww ww ww ww ww ww ww ww ww ww ww ww
major problems experienced by enterprises.
ww ww ww ww ww
Key Terms Check ww ww
d 1. An organizing framework for business process
1.1 1 Match the following terms and definiti
w w w w ww ww ww ww ww ww
ww ww ww ww ww
es, beginning with vendors and ending with custome
ww ww ww ww ww ww ww
ons. rs
a. enterprise system ww w wh 2. Exchanges or transactions between an enterpris
w w ww ww ww ww ww ww
b. integrated enterprise system ww ww e and its customers
ww ww ww
c. business processes ww w we 3. Accounting transactions related to specific bus
w w ww ww ww ww ww ww
d. value chain ww iness processes ww
e. transaction cycles ww w wb 4. Shares data across functional areas within the
w w ww ww ww ww ww ww ww
f. purchasing cycle ww wwenterprise
g. payroll cycle ww w w g 5. Transactions with employees
w w ww ww ww
h. sales cycle ww w wc 6. Related activities performed by an enterprise
w w ww ww ww ww ww ww ww
i. baseline accounting system ww ww to create value by transforming input into output
ww ww ww ww ww ww ww
w wa 7. A system that supports business activities thro
w w ww ww ww ww ww ww ww
ughout the enterprise, including inputs, processing, a
ww ww ww ww ww ww
nd outputsww
w wf 8. Transactions related to purchasing items from
w w ww ww ww ww ww ww w
wvendors
w wi 9. A model that provides an enterprise-
w w ww ww ww ww ww ww
wide view of the firm’s accounting system
ww ww ww ww ww ww
, f 1. A module that relates to output from the ac
1.1 2 Match the following terms and definiti
w w w w ww ww ww ww ww ww ww ww ww ww
ww ww ww ww ww
counting system. ww
ons. w we 2. A module that includes adjusting and correct
w w ww ww ww ww ww ww ww ww
a. vendors module
ww ing entries.
ww
b. customers module ww w w a 3. A module related to purchasing goods and services.
w w ww ww ww ww ww ww ww ww ww
c. employees module ww w wd 4. A module that involves cash received and cash paid.
w w ww ww ww ww ww ww ww ww ww ww
d. banking module
ww w w c 5. A module related to the payroll cycle.
w w ww ww ww ww ww ww ww ww
e. financial module
ww w wb 6. A module related to selling the customer a
w w ww ww ww ww ww ww ww ww ww
f. reports module
ww wwproduct or service.ww ww
g. adjusting entriesww w wm 7. Reports used to evaluate an enterprise’s sus
w w ww ww ww ww ww ww ww ww
h. correcting entriesww tainability performance. ww
i. closing entries
ww w wk 8. Reports used when filing federal, state, and
w w ww ww ww ww ww ww ww ww w
j. financial reports
ww wlocal returns.
ww
k. tax reports
ww w wl 9. Reports prepared to assist managers in maki
w w ww ww ww ww ww ww ww ww
l. management reports ww ng decisions.
ww
m. sustainability reports ww w w j 10. Reports that include a company’s income
w w ww ww ww ww ww ww ww w
wstatement, balance sheet, and statement of cash flows.
ww ww ww ww ww ww ww
w wg 11. Entries to bring accounts up to date at year end.
w w ww ww ww ww ww ww ww ww ww ww ww
w wi 12. Zeros out income and expense accounts at
w w ww ww ww ww ww ww ww ww
wwyear end. ww
w w h 13. Entries to correct errors.
w w ww ww ww ww ww
, c 1. A unique identifier for each record.
1.1 3 Match the following terms and definiti
w w w w ww ww ww ww ww ww ww
ww ww ww ww ww
g 2. An online application that permits users to
w w w w ww ww ww ww ww ww ww ww w
ons. wview data in a multidimensional way.
ww ww ww ww ww
a. field w wb 3. A collection of related database fields.
w w ww ww ww ww ww ww ww
b. record f 4.Data analytics and predictive modeling used
w w w w ww ww ww ww ww ww ww
c. primary key ww to gain insights from data to improve the quality o
ww ww ww ww ww ww ww ww ww
d. relational database ww f business decisions.
ww ww
e. operational database ww w wa 5. A piece of information.
w w ww ww ww ww ww
f. business intelligence
ww e 6. A database that stores transactions related t
w w w w ww ww ww ww ww ww ww ww
g. OLAP cubesww o business operations.
ww ww
w wd 7. A collection of related database tables.
w w ww ww ww ww ww ww ww
g 1. A framework for organizing the complex,
1.1 4 Match the following terms and definiti
w w w w ww ww ww ww ww ww ww ww
ww ww ww ww ww
multifaceted undertaking of developing a system.
ww ww ww ww ww
ons. w wk 2. Includes testing databases and computer prog
w w ww ww ww ww ww ww ww
a. people rams for the new system.
ww ww ww ww
b. processes w wh 3. Includes scheduling, budgeting, and staffing
w w ww ww ww ww ww ww ww
c. technology a project.
ww
d. information technology (IT) ww ww w w i 4. Includes evaluating new system requirements.
w w ww ww ww ww ww ww
e. IT architecture
ww w wm 5. Using the new system on an ongoing basis
w w ww ww ww ww ww ww ww ww ww w
f. IT infrastructure
ww wand maintaining and updating it as necessary.
ww ww ww ww ww ww
g. system development life cycle (SDLC)
ww ww ww ww w wl 6. Setting up new IT hardware, software, and
w w ww ww ww ww ww ww ww ww w
h. plan wdatabases.
i. analyze w wj 7. Prepare models for business processes and d
w w ww ww ww ww ww ww ww ww
j. design atabases for the new system.
ww ww ww ww
k. build/buy w wb 8. One of the three keys of opportunity that f
w w ww ww ww ww ww ww ww ww ww ww
l. install ocuses on how business activities are impacted.
ww ww ww ww ww ww
m. deploy w wc 9. One of the three keys of opportunity that f
w w ww ww ww ww ww ww ww ww ww ww
ocuses on software, hardware, and networks.
ww ww ww ww ww
w w a 10. One of the three keys of opportunity that
w w ww ww ww ww ww ww ww ww ww
wwfocuses on how employees, customers, and vendors
ww ww ww ww ww ww ww
are impacted.
ww
w wd 11. Consists of software, hardware, and networ
w w ww ww ww ww ww ww ww
k technology used by an organization.
ww ww ww ww ww
w wf 12. How specific software, hardware and netwo
w w ww ww ww ww ww ww ww
rks are used to build IT architecture for an enterpri
ww ww ww ww ww ww ww ww ww
se.
w we 13. The design or blueprint for an enterprise’s
w w ww ww ww ww ww ww ww ww w
winformation technology . ww
Practice Test ww
1.1 5 In addition to accounting systems, which of the following are member of enterprise systems?
ww ww ww ww ww ww ww ww ww ww ww ww ww
a. SCM and OPS
ww ww
b. CRM and SCM
ww ww
c. HRM and Financial
ww ww
d. SCM, OPS, CRM, and HR (Correct Answer)
ww ww ww ww ww ww
1.1 6 The value chain is useful for:
ww ww ww ww ww
a. Coordinating accounting system activities.
ww ww ww
b. Coordinating activities with suppliers and customers (Correct Answer)
ww ww ww ww ww ww ww