Accounting Information Systems
10th Edition
ISBN: 9781337619202
Author: Hall, James A.
Publisher: Cengage Learning,
expand_more
expand_more
format_list_bulleted
Question
Chapter 12, Problem 6P
To determine
Explain the differences that can be problematic in transferring information.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
The purchase order for one firm is the source document for the sales order of another firm. Consider the following purchase order and sales order data elements stored for two firms. Discuss any differences that may be problematic in transferring information between the two firms.Purchasing Firm:GH BETTISA Division of Galveston-Houston Corp.1200 Post Oak Blvd.P.O. Box 4768Houston, TX 77637-9877Data ElementsVendor NumberVendor NameVendor AddressVendor CityVendor StateVendor CountryVendor Zip CodePurchase Order No.DateShipment Destination CodeVendor Part No.Item DescriptionQuantity OrderedUnit PriceTotalSelling Firm:Oakland Steel Company469 Lakeland Blvd.Chicago, IL 60613-8888Data ElementsCustomer NumberCustomer NameCustomer AddressCustomer CityCustomer StateCustomer CountryCustomer Zip CodePurchase Order No.Sales Order No.DateShipping CompanyVendor Part No.Item DescriptionQuantity OrderedUnit PriceTotalDiscount OfferedTaxFreight Charges
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…
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…
Chapter 12 Solutions
Accounting Information Systems
Ch. 12 - Prob. 1RQCh. 12 - Prob. 2RQCh. 12 - Prob. 3RQCh. 12 - Prob. 4RQCh. 12 - Prob. 5RQCh. 12 - Prob. 6RQCh. 12 - Prob. 7RQCh. 12 - Prob. 8RQCh. 12 - Prob. 9RQCh. 12 - Prob. 10RQ
Ch. 12 - Prob. 11RQCh. 12 - Prob. 12RQCh. 12 - Prob. 13RQCh. 12 - Prob. 14RQCh. 12 - Prob. 15RQCh. 12 - Prob. 16RQCh. 12 - Prob. 17RQCh. 12 - Prob. 18RQCh. 12 - Prob. 19RQCh. 12 - Prob. 20RQCh. 12 - Prob. 21RQCh. 12 - Prob. 22RQCh. 12 - Prob. 23RQCh. 12 - Prob. 1DQCh. 12 - Prob. 2DQCh. 12 - Prob. 3DQCh. 12 - Prob. 4DQCh. 12 - Prob. 5DQCh. 12 - Prob. 6DQCh. 12 - Prob. 7DQCh. 12 - Prob. 8DQCh. 12 - Prob. 9DQCh. 12 - Prob. 10DQCh. 12 - Prob. 11DQCh. 12 - What is a digital envelope?Ch. 12 - Prob. 13DQCh. 12 - Prob. 14DQCh. 12 - Prob. 15DQCh. 12 - Prob. 16DQCh. 12 - Prob. 17DQCh. 12 - Prob. 18DQCh. 12 - Prob. 19DQCh. 12 - Prob. 1MCQCh. 12 - Prob. 2MCQCh. 12 - Prob. 3MCQCh. 12 - Prob. 4MCQCh. 12 - Prob. 5MCQCh. 12 - Prob. 6MCQCh. 12 - Prob. 7MCQCh. 12 - A system of computers that connects the internal...Ch. 12 - Prob. 9MCQCh. 12 - Prob. 10MCQCh. 12 - Prob. 1PCh. 12 - Prob. 4PCh. 12 - Prob. 5PCh. 12 - Prob. 6PCh. 12 - VIRTUALIZATION Virtualization technology is...Ch. 12 - Prob. 8P
Knowledge Booster
Similar questions
- Choose a company and describe how a specific issue, policy, or procedure (for example, granting merchandise returns, establishing sales prices) might look if the business is structured as a centralized business.arrow_forwardA company is trying to set up proper internal controls for their accounts payable/inventory purchasing system. Currently the purchase order is generated by the same person who receives the inventory. Together the purchase order and the receiving ticket are sent to accounts payable for payment. What changes would you make to improve the internal control structure? A. No changes would be made since the person paying the bills is different from the person ordering the inventory. B. The person in accounts payable should generate the purchase order. C. The person in accounts payable should generate the receiving ticket once the invoice from the supplier is received. D. The responsibilities of generating the purchase order and receiving the inventory should be separated among two different people.arrow_forwardManagement of Green Peak Tea Company has asked you, the controller, to develop a transfer pricing system for the company. The Brewing Department of the company sells all of its product to the Bottling Department of the company. Thus the Brewing Departments sales become the Bottling Departments cost of goods sold. In order to determine an optimal transfer pricing system, management would like you to demonstrate what an income statement would look like under a cost, market, and negotiated transfer pricing structure. These various transfer prices are listed as follows. Prepare an income statement for each of the transfer prices by filling in the missing numbers in the provided income statement based on each transfer price (thus four different income statements) and calculate the operating income/loss percentage. Prepare a brief summary of the results.arrow_forward
- The Mega Supply Corporation has three divisions: Commercial Products, Consumer Products, and Corporate Offices, which are located in Hatfield, South Carolina; Palo Alto, California; and Tulsa, Oklahoma, respectively. The Commercial Products division deals exclusively in sales of industrial products and supplies to business organizations. The Consumer Products division sells nonindustrial products to private consumers. Both divisions have dedicated inventory warehouses at their respective locations in Hatfield and Palo Alto. Because of the dissimilar nature of the commercial and consumer division product lines, they do not share customers or vendors. Currently Mega Supply uses a centralized database, which is located at their Corporate Division in Tulsa. Some relevant database tables and attributes are presented in the figure designated Problem 1. When customers contact their respective sales division, the sales clerk logs into the corporate database, checks credit, determines product availability, and creates a sales invoice. The corporate office typically bills the customer within 3 or 4 days and extends terms of net 30. Inventory control, AR processing, cash receipts, purchases from vendors and AP processing, and cash disbursements are performed by the corporate office. Due to Megas rapid growth, the company has seen a significant increase in sales and purchase transactions, which has resulted in excessive delays in processing transactions from the central database. Since customer service, including rapid response to customer inquiries and sales order processing, is a cornerstone of Megas business model, these delays are unacceptable. Required Mega wants to improve response time by distributing some parts of the corporate database while keeping other parts of it centralized. (A) Develop a schema for distributing Mega Supply Corporations database. Add new tables and attributes as needed but limit the schema to the tables needed to support sales, cash receipts, purchases/AP, and cash disbursements. In your schema, indicate whether tables are centralized, replicated, or partitioned. (B) Explain how the new system will operate.arrow_forwardSilver Limited is a manufacturing company that produces furniture. To improve efficiency and usefulness, Silver Limited is constantly incorporating advanced, information technology into its business information systems. When Silver Limited does not have available production capacity, sometimes it purchases furniture from outside suppliers to fulfill customer orders. First, Inventory Control prepares a purchase requisition when inventory approaches the reorder point and sends it to Purchasing and Accounts Payable. Then, Purchasing locates the authorized vendor in the vendor file, prepares a purchase order, and updates the purchase order file. Purchasing then sends the purchase order to Vendor, Receiving, and Accounts Payable. Accounts Payable prepares a summary of all purchase orders issued that day and forwards the total to General Ledger for posting to the GL file. Goods arrive at Receiving with a packing slip. Receiving prepares a receiving report and forwards it with the goods to…arrow_forwardSilver Limited is a manufacturing company that produces furniture. To improve efficiency and usefulness, Silver Limited is constantly incorporating advanced, information technology into its business information systems. When Silver Limited does not have available production capacity, sometimes it purchases furniture from outside suppliers to fulfill customer orders. First, Inventory Control prepares a purchase requisition when inventory approaches the reorder point and sends it to Purchasing and Accounts Payable. Then, Purchasing locates the authorized vendor in the vendor file, prepares a purchase order, and updates the purchase order file. Purchasing then sends the purchase order to Vendor, Receiving, and Accounts Payable. Accounts Payable prepares a summary of all purchase orders issued that day andforwards the total to the General Ledger for posting to the GL file. Goods arrive at Receiving with a packing slip. Receiving prepares a receiving report and forwards it with the goods to…arrow_forward
- Silver Limited is a manufacturing company that produces furniture. To improve efficiency and usefulness, Silver Limited is constantly incorporating advanced, information technology into its business information systems. When Silver Limited does not have available production capacity, sometimes it purchases furniture from outside suppliers to fulfill customer orders. First, Inventory Control prepares a purchase requisition when inventory approaches the reorder point and sends it to Purchasing and Accounts Payable. Then, Purchasing locates the authorized vendor in the vendor file, prepares a purchase order, and updates the purchase order file. Purchasing then sends the purchase order to Vendor, Receiving, and Accounts Payable. Accounts Payable prepares a summary of all purchase orders issued that day and forwards the total to General Ledger for posting to the GL file. Goods arrive at Receiving with a packing slip. Receiving prepares a receiving report and forwards it with the goods to…arrow_forwardSilver Limited is a manufacturing company that produces furniture. To improve efficiency and usefulness, Silver Limited is constantly incorporating advanced, information technology into its business information systems. When Silver Limited does not have available production capacity, sometimes it purchases furniture from outside suppliers to fulfill customer orders. First, Inventory Control prepares a purchase requisition when inventory approaches the reorder point and sends it to Purchasing and Accounts Payable. Then, Purchasing locates the authorized vendor in the vendor file, prepares a purchase order, and updates the purchase order file. Purchasing then sends the purchase order to Vendor, Receiving, and Accounts Payable. Accounts Payable prepares a summary of all purchase orders issued that day and forwards the total to General Ledger for posting to the GL file. Goods arrive at Receiving with a packing slip. Receiving prepares a receiving report and forwards it with the goods to…arrow_forwardSilver Limited is a manufacturing company that produces furniture. To improve efficiency and usefulness, Silver Limited is constantly incorporating advanced, information technology into its business information systems. When Silver Limited does not have available production capacity, sometimes it purchases furniture from outside suppliers to fulfill customer orders. First, Inventory Control prepares a purchase requisition when inventory approaches the reorder point and sends it to Purchasing and Accounts Payable. Then, Purchasing locates the authorized vendor in the vendor file, prepares a purchase order, and updates the purchase order file. Purchasing then sends the purchase order to Vendor, Receiving, and Accounts Payable. Accounts Payable prepares a summary of all purchase orders issued that day andforwards the total to the General Ledger for posting to the GL file. Goods arrive at Receiving with a packing slip. Receiving prepares a receiving report and forwards it with the goods to…arrow_forward
- ABC Company is a manufacturing company that produces furniture. To improve efficiency and usefulness, ABC Company is constantly incorporating advanced, information technology into its business information systems. When Silver Limited does not have available production capacity, sometimes it purchases furniture from outside suppliers to fulfill customer orders. First, Inventory Control prepares a purchase requisition when inventory approaches the reorder point and sends it to Purchasing and Accounts Payable. Then, Purchasing locates the authorized vendor in the vendor file, prepares a purchase order, and updates the purchase order file. Purchasing then sends the purchase order to Vendor, Receiving, and Accounts Payable. Accounts Payable prepares a summary of all purchase orders issued that day and forwards the total to General Ledger for posting to the GL file. Goods arrive at Receiving with a packing slip. Receiving prepares a receiving report and forwards it with the goods to…arrow_forwardSunset 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_forwardNTERNAL CONTROLThe 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.…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Principles of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax CollegePrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax CollegeFinancial AccountingAccountingISBN:9781305088436Author:Carl Warren, Jim Reeve, Jonathan DuchacPublisher:Cengage Learning
- Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,Auditing: A Risk Based-Approach (MindTap Course L...AccountingISBN:9781337619455Author:Karla M Johnstone, Audrey A. Gramling, Larry E. RittenbergPublisher:Cengage LearningCollege Accounting, Chapters 1-27AccountingISBN:9781337794756Author:HEINTZ, James A.Publisher:Cengage Learning,
Principles of Accounting Volume 1
Accounting
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax College
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
Financial Accounting
Accounting
ISBN:9781305088436
Author:Carl Warren, Jim Reeve, Jonathan Duchac
Publisher:Cengage Learning
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Auditing: A Risk Based-Approach (MindTap Course L...
Accounting
ISBN:9781337619455
Author:Karla M Johnstone, Audrey A. Gramling, Larry E. Rittenberg
Publisher:Cengage Learning
College Accounting, Chapters 1-27
Accounting
ISBN:9781337794756
Author:HEINTZ, James A.
Publisher:Cengage Learning,