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 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 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 customer’s 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 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. 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.

Narrative 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.

Narrative 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.

Precision Industries, Inc., is a manufacturer of electronic components. When a purchase order is received from a customer, a sales clerk prepares a serially numbered sales order and sends copies to the shipping and accounting departments. When the merchandise is shipped to the customer, the shipping department prepares a serially numbered shipping advice and sends a copy to the accounting department. Upon receipt of the appropriate documents, the accounting department records the sale in the accounting records. All shipments are FOB shipping point. Assume that all shipments for the first five days of the following year were recorded as occurring in the current year. If not corrected, what effect will this cutoff error have upon the financial statements for the current year?

ABC 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?

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…

Following describes the credit sales procedures for clothing wholesaler that sells name-brand clothing to department stores and boutique dress shops. The company sells to both one-time and recurring customers. A flowchart of the system is provided in the figure labeled Problem 5: Internal Control. Customer orders are received by fax and e-mail in the sales department. The sales clerk, who works on commission, approves the credit sale, calculates com- missions and discounts, and records the sale in the sales journal from the PC in the sales department. The clerk then prepares a sales order, a customer invoice, and a packing slip, which are sent to the accounting department for processing. The accounting clerk updates the AR subsidiary ledger and sends an invoice to the customer. The clerk then forwards the sales order and packing slip to the warehouse- shipping department. The warehouse-shipping clerk picks the items from inventory and sends them and the packing slip to the carrier for…

Create 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.

The following is a description of manufacturing com-pany’s purchasing procedures. All computers in the com-pany are networked to a centralized accounting system sothat each terminal has full access to a common database.The inventory control clerk periodically checks in-ventory levels from a computer terminal to identifyitems that need to be ordered. Once the clerk feels in-ventory is too low, he chooses a supplier and creates apurchase order from the terminal by adding a record tothe purchase order file. The clerk prints a hard copy ofthe purchase order and mails it to the vendor. An elec-tronic notification is also sent to accounts payable andreceiving, giving the clerks of each department accessto the purchase order from their respective terminals.When the raw materials arrive at the unloading dock,a receiving clerk prints a copy of the purchase orderfrom his terminal and reconciles it to the packing slip.The clerk then creates a receiving report on a computersystem. An electronic…

SpeeDIY Sdn. Bhd. is an online Do-It-Yourself (DIY) store located in Sintok that provides home delivery of DIY products purchased via the Internet. SpeeDIY uses a fully integrated accounting system and practices automated Economic Order Quantity (EOQ) model in managing its inventory. For each registered item in the inventory database, the system specifies quantity on hand and a desired quantity on hand. When the quantity on hand falls below the desired quantity on hand, a notification automatically pops up on the purchasing clerk's computer screen, alerting the clerk to reorder the item. The purchasing clerk can proceed with the reordering of items simply by checking the acceptance box. When the acceptance box is checked, the purchase order transaction file is created. In addition, the vendor is notified electronically through a transmission from the purchasing system. The purchasing clerk prepares a purchase summary report to his manager at the end of the day. SpeeDIY warehouse has…

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?

Videos

Want to see the full answer?

Chapter 4 Solutions