Accounting Information Systems
11th Edition
ISBN: 9780357156032
Author: Ulric J. Gelinas; Richard B. Dull; Patrick Wheeler
Publisher: Cengage Limited
expand_more
expand_more
format_list_bulleted
Question
Chapter 4, Problem 8P
Summary Introduction
Narrative summary:
Company G sells consumer products online. The website will consist of front-end web server that helps for the interaction of customer and back-end server. The narrative further explains the activities involved in the process of receiving the order to delivering the order.
To prepare: The system flowchart of the process.
Introduction:
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Given the following business rules, construct an ER diagram so each rule is captured for the database. Presume each rule is to be treated individually. Construct an ER diagram for each rule.a. A retail sales company prepares sales orders for its customers’ purchases. A customer can make many purchases, but a sales order is written for a single customer.b. A retail sales company orders inventory using a purchase order. An inventory item may be ordered many times, and a purchase order may be created for more than one inventory item.c. A company that sells antique cars prepares a sales order for each car sold. The inventory for this company consists of unique automobiles, and only one of these automobiles may be listed on a sales order.d. A grocery store identifies returning customers via a plastic card that the clerk scans at the time of each purchase. The purpose of this card is to track inventory and to maintain a database of customers and their purchases. Obviously, a customer may…
OLTP VERSUS OLAP SERVERS
For each of the following processes, state whether OLTP or OLAP is appropriate, and why.
An order entry system that retrieves customer information, invoice information, and inventory information for local sales.
An order entry system that retrieves customer information, invoice information, inventory information, and several years of sales information about both the customer and the inventory items. An order entry system that retrieves customer information, invoice information, inventory information, and information to compare the current sale to sales across several geographic regions.
An order entry system that retrieves customer information, invoice information, inventory information, and accounts receivable information for sales within one marketing region.
An insurance company requires a system that will allow it to determine total claims by region, whether a relationship exists between claims and meteorological phenomena, and why one region seems to be…
Sawicki Music Supply is a mail-order business that accepts merchandise orders by telephone and mail. All payments must be prepaid with a major credit card. Once an order is received, either the item is found in inventory and shipped immediately, the item is not found in inventory and is ordered from the manufacturer, or a notice is sent to the customer indicating that the item is no longer stocked. Required Prepare a context, intermediate, and elementary-level data flow diagram for Sawicki Music Supply. For the elementary-level diagram, explode the inventory function.
Chapter 4 Solutions
Accounting Information Systems
Ch. 4 - Prob. 1RQCh. 4 - Prob. 2RQCh. 4 - Describe each symbol used in constructing DFDs.Ch. 4 - Prob. 4RQCh. 4 - Prob. 5RQCh. 4 - Prob. 6RQCh. 4 - What is a logical DFD?Ch. 4 - Prob. 8RQCh. 4 - When is a set of DFDs balanced (i.e., leveled)?Ch. 4 - Prob. 10RQ
Ch. 4 - Prob. 11RQCh. 4 - Prob. 12RQCh. 4 - Prob. 13RQCh. 4 - Prob. 14RQCh. 4 - Prob. 15RQCh. 4 - Prob. 16RQCh. 4 - How will systems documentation differ between...Ch. 4 - Prob. 1DQCh. 4 - Prob. 2DQCh. 4 - Prob. 3DQCh. 4 - Prob. 1SPCh. 4 - Prob. 2SPCh. 4 - Narrative 1: Freshplace Grocery At Freshplace...Ch. 4 - Prob. 4SPCh. 4 - Narrative 1: Freshplace Grocery At Freshplace...Ch. 4 - Prob. 6SPCh. 4 - Prob. 1PCh. 4 - Prepare a narrative to describe the system...Ch. 4 - Prob. 3PCh. 4 - Narrative 1: Good Buy, Inc (good-buy.com) Good...Ch. 4 - Prob. 5PCh. 4 - Prob. 6PCh. 4 - Narrative 1: Good Buy, Inc (good-buy.com) Good...Ch. 4 - Prob. 8P
Knowledge Booster
Similar questions
- Good Buy, Inc. (good-buy.com) Good Buy, Inc. (a fictitious company) sells a variety of consumer products through its Web site, good-buy.com. Good Buys IT infrastructure consists of a front-end Web server that interacts with customers and a back-end ERP system that manages the inventory and performs other typical ERP functions. The sales order process begins when a customer logs on to the good-buy.com Web site. The Web server requests the current Good Buy online catalog from the ERP system, which sends the catalog to the Web server, and the server displays it to the customer. The customer selects the items and quantities that he wants to purchase; the Web server edits the customer input for accuracy (e.g., ensures that all required fields have been selected or filled in) and sends this list on to the ERP system, where the requested quantities of inventory are allocated for the sale. The ERP sends back to the Web server the quantities that have been allocated, and the Web server displays this information on the customers screen. The customer verifies that the order is correct and completes the sale by entering his shipping and credit card information. The Web server edits this data for accuracy (e.g., ensures that all required fields have been selected or filled in and that the length of the entered credit card number is correct) and sends the credit card information and amount of the sale on to the credit card company. The credit card company sends back a verification number, and the Web server notifies the customer that the sale has been completed by displaying a confirmation number on the customers screen. The Web server also notifies the ERP system that the sale has been completed, and the ERP system changes the status of the inventory from allocated to sold, prints a picking ticket or packing slip in the warehouse, and records (on the enterprise database) a sale and an account receivable from the credit card company. a. Prepare an annotated table of entities and activities based on the output from Problems 4-4 and 4-5. Indicate on this table the groupings, bubble numbers, and bubble titles to be used in preparing a level 0 logical DFD. b. Prepare a logical DFD (level 0 only) based on the table you prepared in part (a). Use Microsoft Visio or other diagraming software.arrow_forwardNarrative 1: Good Buy, Inc (good-buy.com) Good Buy, Inc. (a fictitious company) sells a variety of consumer pro-ducts through its Web site, good-buy.com. Good Buy's IT infrastructure consists of a front-end Web server that interacts with customers and a back-end ERP system that manages the inventory and performs other typical ERP functions. The sales order process begins when a customer logs an to the good-buy.00m Web site. The customer requests the company catalog and the Web server obtains the current Good Buy online catalog fmm the ERP system, which sends the catalog to the Web server, and the server displays it to the customer. The customer selects the items and quantities that he or the wants to purchase; the Web server edits the customer input for accuracy (e.g, ensures that all required fields have been selected or frilled in) and sends this list on to the ERP system, where the requested quantities of inventory are allocated for the sale. The ERP sends back to the Web server the quantities that have been allocated, and the Web serverdisplays this information on the customer's semen. The customer verifies that the order is correct and completes the sale by entering his or her shipping and credit card information. The Web server edits this data for accuracy (e.g, enmra that all required fields have been selected or filled in and that the length of the entered credit card number is correct) and sends the credit card information and amount of the sale on to the credit card company. The credit card company sends back a verification number, and the Web server notifies the customer that the sale has been completed by displaying a confirmation number on the customer's screen. The Web server also notifies the ERP system that the sale has been completed, and the ERP system changes the status of the inventory from allocated to sold, prints a pick-ing ticket or packing slip in the warehouse, and records (on the enterprise database) a sale and an account receivable from the credit card company. Use the narrative(s) as selected by your instructor, to prepare a table of entities and activities.arrow_forwardNarrative 1: Good Buy, Inc (good-buy.com) Good Buy, Inc. (a fictitious company) sells a variety of consumer pro-ducts through its Web site, good-buy.com. Good Buy's IT infrastructure consists of a front-end Web server that interacts with customers and a back-end ERP system that manages the inventory and performs other typical ERP functions. The sales order process begins when a customer logs an to the good-buy.00m Web site. The customer requests the company catalog and the Web server obtains the current Good Buy online catalog fmm the ERP system, which sends the catalog to the Web server, and the server displays it to the customer. The customer selects the items and quantities that he or the wants to purchase; the Web server edits the customer input for accuracy (e.g, ensures that all required fields have been selected or frilled in) and sends this list on to the ERP system, where the requested quantities of inventory are allocated for the sale. The ERP sends back to the Web server the quantities that have been allocated, and the Web serverdisplays this information on the customer's semen. The customer verifies that the order is correct and completes the sale by entering his or her shipping and credit card information. The Web server edits this data for accuracy (e.g, enmra that all required fields have been selected or filled in and that the length of the entered credit card number is correct) and sends the credit card information and amount of the sale on to the credit card company. The credit card company sends back a verification number, and the Web server notifies the customer that the sale has been completed by displaying a confirmation number on the customer's screen. The Web server also notifies the ERP system that the sale has been completed, and the ERP system changes the status of the inventory from allocated to sold, prints a picking ticket or packing slip in the warehouse, and records (on the enterprise database) a sale and an account receivable from the credit card company. Use the narrative(s) as selected by your instructor, to prepare a table of entities and activities. Annotate the table of entities and activities to indicate on this table the groupings, bubble numbers, and bubble titles to be used in preparing a level 0 logical DFD. Prepare a logical DFD (level 0 only) based on the table you prepared. If you completed any of the previous problems, use that information to help you construct the diagram. a. Use Microsoft Visio, any other diagramming software or another Microsoft office product such as Excel to create the diagram you drew in SP 4-7.arrow_forward
- Sunset Graphics often buys inventory after receiving a sales order from the customer. Suppose you are asked to prepare one UML class diagram that combines both the sales and collection process and the purchases and payments process. What would be shared among those processes? What would be unique to each process? Why?arrow_forwardCreate a flowchart for the following telephone-ordering process at a retail chain that specializes in selling books and music CDs. It provides an ordering system via the telephone to its time-sensitive customers besides its regular store sales. The automated system greets customers, asks them to choose a tone or pulse phone, and routes them accordingly. The system checks to see whether customers have an existing account. They can wait for the service representative to open a new account. Customers choose between order options and are routed accordingly. Customers can cancel the order. Finally, the system asks whether the customer has additional requests; if not, the process terminates.arrow_forwardABC Company is using the inventory system managed by the vendor. The product is owned and managed by the vendor until it is delivered from ABC's distribution center to the stores. What do you think will be the problems that ABC will encounter in its purchases and payments process?arrow_forward
- Required: A sales invoice typically includes the date of sale, salesperson, customer data, items included in the sale, and amount. Which foreign keys should be added to the following table to link all of these data elements? (You may select more than one answer. Single click the box with the question mark to produce a check mark for a correct answer and double click the box with the question mark to empty the box for a wrong answer. Any boxes left with a question mark will be automatically graded as incorrect.) Sales Table Invoice# Date Amount S-101 10/05/2021 2549.90 S-105 11/01/2021 949.95 S-107 11/02/2021 1209.70 S-108 11/06/2021 699.90 ?Salesperson # ? Customer # ? Receipt # ? Inventory # ? Remittance Advice # ? Sales # ?Cashier # ?Casharrow_forwardAll of the following are examples of sales order entry system controls except? Digital signatures/written signatures Credit Limits Approving invoices before paying Trainingarrow_forwardPrepare a narrative to describe the system depicted in the physica larrow_forward
- 12.1 Match the term in the left column with its definition in the right column. 1. CRM system a. Document used to authorize reducing the balance in a customer account 2. Open-invoice method b. Process of dividing customer account master file into subsets and preparing invoices for one subset at a time 3. Credit memo C. System that integrates EFT and EDI information 4. Credit limit d. System that contains customer-related data organized in a manner to facilitate customer service, sales, and retention 5. Cycle billing e. Electronic transfer of funds 6. FEDI f. Method of maintaining accounts receivable that generates one payment for all sales made the previous montharrow_forwardCreate a flowchart for the following telephone-ordering process at a retail chain that specializes in selling books and music CDs. It provides an ordering system via the telephone to its time-sensitive customersbesides its regular store sales. First, the automated system greets customers and identifies whether they have a tone or pulse phone. Customers choose 1 if they have a tone phone; otherwise, they wait for the first available service representative to process their request. If customers have a tone phone, they complete their request by choosing options on the phone. First, the system checks to see whether customers have an existing account.Customers choose 1 if they have an existing account or choose 2 if they want to open a new account. Customers wait for the service representative to open a new account if they choose 2. Next, customers choose between the options of making an order, canceling an order, or talking to a customer representative for questions and/or complaints. If…arrow_forwardIf one of NetSolution's customers returns some merchandise that had been purchased on account (accounts receivable), NetSolutions will inform the customer that the return has been authorized as indicated by a _______ memo. Group of answer choices credit memo debit memo sales return memo sales memoarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Accounting Information SystemsFinanceISBN:9781337552127Author:Ulric J. Gelinas, Richard B. Dull, Patrick Wheeler, Mary Callahan HillPublisher:Cengage Learning
Pkg Acc Infor Systems MS VISIO CDFinanceISBN:9781133935940Author:Ulric J. GelinasPublisher:CENGAGE L
Auditing: A Risk Based-Approach to Conducting a Q...AccountingISBN:9781305080577Author:Karla M Johnstone, Audrey A. Gramling, Larry E. RittenbergPublisher:South-Western College Pub
Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
College Accounting, Chapters 1-27AccountingISBN:9781337794756Author:HEINTZ, James A.Publisher:Cengage Learning,
Accounting Information Systems
Finance
ISBN:9781337552127
Author:Ulric J. Gelinas, Richard B. Dull, Patrick Wheeler, Mary Callahan Hill
Publisher:Cengage Learning
Pkg Acc Infor Systems MS VISIO CD
Finance
ISBN:9781133935940
Author:Ulric J. Gelinas
Publisher:CENGAGE L
Auditing: A Risk Based-Approach to Conducting a Q...
Accounting
ISBN:9781305080577
Author:Karla M Johnstone, Audrey A. Gramling, Larry E. Rittenberg
Publisher:South-Western College Pub
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
College Accounting, Chapters 1-27
Accounting
ISBN:9781337794756
Author:HEINTZ, James A.
Publisher:Cengage Learning,