Accounting Information Systems
11th Edition
ISBN: 9781337552127
Author: Ulric J. Gelinas, Richard B. Dull, Patrick Wheeler, Mary Callahan Hill
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 6, Problem 5SP
Examine Figure 6.18, which contains the REA model for Hera Industrial Supply (HIS). The model is partially completed; it includes all entities and relationships, but it does not include cardinalities or descriptions of the relationships (which would appear in diamonds on the connecting lines between entities). HIS sells replacement parts for packaging machinery to companies in several states. HIS accepts orders via telephone, fax, and mail. When an order arrives, one of the salespersons enters it as a sales order. The sales order includes the customer’s name and a list of the inventory items that the customer wants to purchase. This inventory list includes the quantity of each inventory item and the price at which HIS is currently selling the item. When the order is ready to ship, WIS completes an invoice and records the sale. Sometimes, inventory items that a customer has ordered are not in stock. In those cases, HIS will ship partial orders. Customers are expected to pay their invoices within 30 days. Most customers do pay on time; however, some customers make partial payments over two or more months. List each entity in the REA model, and identify it as a resource, event, or agent. Using Microsoft Visio, redraw the REA model to include the diamonds for each relationship and include an appropriate description in each diamond.
FIGURE 6.18 Partially Completed REA Model of the Hera Industrial Supply Sales Business
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Based on the following small extract from Polis Grocers Inc, fill in the missing activities in the table of entities and activities presented below.
Alanco, Inc. manufactures a variety of products and is currently manufacturing all of its own component parts. An outside supplier has
offered to sell one of those components to Alanco. The Controller has asked you to help evaluate this offer to determine if the
company should make or buy the component.
Here are some tips for using Excel:
• Cell Reference: Allows you to refer to data from another cell in the worksheet. If you entered "=B5" into a blank cell, the formula
would output the value from cell B5.
Basic Math Functions: Allow you to use the basic math symbols to perform mathematical functions. You can use the following keys:
+ (plus sign to add), - (minus sign to subtract), * (asterisk sign to multiply), and / (forward slash to divide). For example, if you entered
"=B4+B5" in a blank cell, the formula would add the values from those cells and output the result.
●
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…
Chapter 6 Solutions
Accounting Information Systems
Ch. 6 - What is business intelligence (BI)?Ch. 6 - Prob. 2RQCh. 6 - Prob. 3RQCh. 6 - Prob. 4RQCh. 6 - What is a relationship?Ch. 6 - Prob. 6RQCh. 6 - Prob. 7RQCh. 6 - Prob. 8RQCh. 6 - How can an REA model help an organization improve...Ch. 6 - Prob. 10RQ
Ch. 6 - Prob. 11RQCh. 6 - Prob. 12RQCh. 6 - What is a foreign key? How are foreign keys...Ch. 6 - Prob. 14RQCh. 6 - Prob. 15RQCh. 6 - Prob. 1DQCh. 6 - What is a model? How is modeling a database or...Ch. 6 - Prob. 3DQCh. 6 - Prob. 4DQCh. 6 - Prob. 5DQCh. 6 - Prob. 6DQCh. 6 - Although todays enterprise systems incorporate...Ch. 6 - Prob. 8DQCh. 6 - Prob. 1SPCh. 6 - Prob. 2SPCh. 6 - Examine Figure 6.18, which contains the REA model...Ch. 6 - Prob. 6SPCh. 6 - Prob. 7SPCh. 6 - What SQL command(s) would you use to add the date...Ch. 6 - Prob. 2P
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.Similar questions
- 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_forwardJohn’s Custom Computer Shop (JCCS) assembles computers for both individual and corporate customers. The company is organized into two divisions: Personal and Business. Once a computer is built, it is shipped to the customer. Billing for all customers is handled by the corporate Accounts Receivable Department. Accounts Receivable performs two major activities: billing and dispute resolution. Billing refers to preparing and sending the bills as well as processing the payments. Dispute resolution occurs when a customer refuses to pay, usually due to an error in billing. The costs of the Accounts Receivable Department are allocated to the two divisions based on the number of bills prepared. Kyle, the manager of the Business division, has complained that the allocated costs from Accounts Receivable are beginning to make the business division look unprofitable and has asked you to recommend some changes to the allocation system. If he agrees with your recommendation, he will pass them on…arrow_forwardNetbooks Inc. provides accounting applications for business customers on the Internet for a monthly subscription. Netbooks customers run their accounting system on the Internet; thus, the business data and accounting software reside on the servers of Netbooks Inc. The senior management of Netbooks believes that once a customer begins to use Netbooks, it is very difficult to cancel the service. That is, customers are “locked in” because it isdifficult to move the business data from Netbooks to another accounting application even though the customers own their own data. Therefore, Netbooks has decided to entice customers with an initial low monthly price that is half the normal monthly rate for the first year of services. After a year, the price will be increased to the regular monthly rate.Netbooks management believes that customers will have to accept the full price because customers will be “locked in” after one year of use.a. Discuss whether the half-price offer is an ethical…arrow_forward
- Feinman Computers sells desktop computer systems that it manufactures from parts and software that thirdparty vendors provide. Customers are both private consumers and small businesses. Consumers pay cash or by credit card, but business customers buy on credit. A credit check is made of all new business customers before approving a line of credit. Sales are made online or by a hard-copy order document that customers mail or fax to the company.When a credit order is received, the sales clerk verifies inventory availability, prepares a sales order and sends the stock release copy to Willy, a warehouse employee who picks the goods and arranges shipment. Willy then prepares the bills of lading and shipping notices. Barb in the billing department receives the shipping notice from Willy and updates the inventory subsidiary ledger to account for the reduction in inventory. Barb files the stock release, prepares the invoice, and mails a copy of it to the customer. Barb then updates the sales…arrow_forwardThe 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…arrow_forwardThe 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…arrow_forward
- I have a few questions from the last chapter that still don't understand can i get help.arrow_forwardWhich of the following are common use cases for VLOOKUP? (Check all that apply) Check All That Apply Finding a customer's name based on their ID Calculating the total sales of a specific product Looking up a product's price in a price list Retrieving an employee's phone number from a database Returning values from a different sheet in the same workbook.arrow_forwardXYZ Company has two business units selling two different products. Business unit A produces and sells sprinkler heads and requires customers to pay for their purchase prior to the production of the sprinkler heads. Business unit A recognizes revenue at the time of payment. Business unit B produces and sells household faucets and allows customers to pay for their faucets after they are delivered to the customer. Business unit B recognizes revenue when the customer receives the product. What is the likely effect that will occur by management in measuring and comparing the performance of each business unit? A Business unit A will have overstated revenue in comparison to business unit B. B Business unit A and business unit B can be effectively compared. C Business unit A will have understated revenue in comparison to business unit B. D Management cannot effectively compare the business units.arrow_forward
- The sales department receives the unstandardised sales order since customer orders are mailed, e-mailed or faxed to the sales department. The sales clerk first converts the unstandardised sales order into the standardised sales order. For this purpose, the sales representative requests the missing information, if any. When the order is received, the sales clerk checks the customer’s creditworthiness of the customer from his computer terminal. Three years ago, the sales clerk requested the accounting department to provide him with a list of customers whose account receivables are written off. The sales clerk is still using this information to check the creditworthiness of the customers. The sales clerk is using the same procedure to check the creditworthiness of the new customers.The customer’s order is rejected if the customer’s credit is not verified. The sales order processing is started after the credit verification. In particular, the sales clerk records the approved standardised…arrow_forwardThe sales department receives the unstandardised sales order since customer orders are mailed, e-mailed or faxed to the sales department. The sales clerk first converts the unstandardised sales order into the standardised sales order. For this purpose, the sales representative requests the missing information, if any. When the order is received, the sales clerk checks the customer’s creditworthiness of the customer from his computer terminal. Three years ago, the sales clerk requested the accounting department to provide him with a list of customers whose account receivables are written off. The sales clerk is still using this information to check the creditworthiness of the customers. The sales clerk is using the same procedure to check the creditworthiness of the new customers.The customer’s order is rejected if the customer’s credit is not verified. The sales order processing is started after the credit verification. In particular, the sales clerk records the approved standardised…arrow_forwardABC Co. has a contract with Xero, a cloud-based accounting software platform for small- and medium-sized businesses. As the accountant of ABC, you use Xero to record transactions and generate reports. How would you account for the payments made to Xero?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
Essentials of Business Analytics (MindTap Course ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
Business Its Legal Ethical & Global EnvironmentAccountingISBN:9781305224414Author:JENNINGSPublisher:Cengage
Auditing: A Risk Based-Approach to Conducting a Q...AccountingISBN:9781305080577Author:Karla M Johnstone, Audrey A. Gramling, Larry E. RittenbergPublisher:South-Western College Pub
Financial AccountingAccountingISBN:9781305088436Author:Carl Warren, Jim Reeve, Jonathan DuchacPublisher:Cengage Learning
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Essentials of Business Analytics (MindTap Course ...
Statistics
ISBN:9781305627734
Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
Business Its Legal Ethical & Global Environment
Accounting
ISBN:9781305224414
Author:JENNINGS
Publisher:Cengage
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
Financial Accounting
Accounting
ISBN:9781305088436
Author:Carl Warren, Jim Reeve, Jonathan Duchac
Publisher:Cengage Learning
Revenue recognition explained; Author: The Finance Storyteller;https://www.youtube.com/watch?v=816Q6pOaGv4;License: Standard Youtube License