Accounting Information Systems A Business Process Approach Chapter

Accounting Information Systems: A Business Process Approach Chapter Twelve: Using Technology to Enhance Business Processes

Tables: 12. 1 - 12. 5

Table 12. 1 Examples of Value Activities for ELERBE, Inc. Primary Value Activities Marketing Demonstrate products to faculty Outbound logistics Obtain orders Pick goods Ship goods Support Value Activities______________ Human Technology Resources Acquisitions Developm Hire salespeople Acquire supplies, Develop marketing Train salespeople laptops, and products Assign salespeople for marketing including IT Calculate and pay salaries/commissions Hire and train order Acquire supplies, Develop technologie entry clerks, packaging warehouse, and materials, and including I shipping personnel technology for on-line order Process payroll outbound logistics processing)

Table 12. 2 Examples of Tags Category Tag Description Formatting <B> </B> Information between these two tags appears in bold (e. g. , the book title). <P> Starts a new paragraph. < BR > Line break. Creates a space between lines. Tables < Table > < /Table > Starts and ends a table. < TR > < /TR > Starts and ends a row in a table. You see two sets of < TR > and < /TR > tags since there are two rows. < TD > < /TD > Starts and ends each data item in a row. After each < TR > tag, you see two sets of < TD > </TD > tags since there are two columns and thus two data items in each row. Links < A > < /A > < A HREF 5“chapter 1. html” >. The HREF attribute is used to specify which file is being linked to. If a student clicks this link, the Chapter 1. html file will be displayed.

Table 12. 3 Tables Used in ELERBE’s Order Processing Application Inventory Table ISBN 0 -256 -12596 -7 0 -127 -35124 -8 Author Barnes Cromwell 0 -135 -22456 -7 Cromwell 0 -146 -18976 -4 0 -145 -21687 -7 Johnson Platt Title Introduction to Business Building Database Applications Management Information Systems Principles of Accounting Introduction to E-Commerce Price $78. 35 $65. 00 $68. 00 $70. 00 $72. 00

Table 12. 4 Tables Stored On-Line in a Sales Application Customer# Last Name First Name ST Zip 2003 Sales Type Street 307 308 309 Smith Clarke Garcia John Lee John Retail Whol. Retail 43 Main St. Lupo 25 Blue St. Balto 35 Lilly St. L. A. TX MD CA 88010 21247 80105 10, 700 3, 000 4, 500 Transaction# Date Customer# Product# Quantity Price Salesperson# 1034 1035 1036 12/18/03 12/20/03 307 308 309 5005 6500 5005 10 20 20 $12 $20 $12 348 344 348 1037 12/20/03 308 5703 10 $16 344 City

Table 12. 5 Records Stored in a Data Warehouse Type Retail Wholesale 3, 000 Date Product# Quantity Price 12/18/03 5005 10 $12 12/18/03 6500 20 Zip 88010 $20 2003 Sales 10, 700 21247 12/20/03 5005 20 12/20/03 5703 80105 $16 4, 500 21247 $12 10