Accounting Information Systems
10th Edition
ISBN: 9781337619202
Author: Hall, James A.
Publisher: Cengage Learning,
expand_more
expand_more
format_list_bulleted
Question
Chapter 4, Problem 6ICC
a.
To determine
Prepare the data flow diagram for the current system.
b.
To determine
Prepare the system flowchart for the existing system.
c.
To determine
Describe the physical internal control weaknesses and the risks.
d.
To determine
Prepare a system flowchart of a redesigned computer-based system which resolves the control weaknesses.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
MOUNTAIN ADVENTURE: WHITE WATER AND CAMPING SUPPLIES (NETWORKED COMPUTER SYSTEM AND MANUAL PROCEDURES)
MOUNTAIN ADVENTURE is a Montana-based wholesaler of rafting and camping equipment that serves outdoor sports camping retailers throughout the northwest. You have been hired by MOUNTAIN ADVENTURE to evaluate their processes, risks, and internal controls. The following paragraphs describe Outdoor Adventure’s revenue cycle procedures.
Revenue Cycle
SALES ORDER PROCESSING PROCEDURES.
Customer orders are mailed or e-mailed to the sales department. When the order is received the sales clerk checks the customer’s creditworthiness from a computer terminal by running a validation application. The credit-check program determines if the customer’s account is up-to-date regarding payments and the customer has not exceeded his or her credit limit. Computer controls in the application prevent further processing of any transactions that fails the credit check. Under certain extenuating…
The following narrative describes the processing of customer mail orders at Eye- Dee- A- Pet, Inc.: Eye- Dee- A- Pet, Inc. is a small manufacturing operation engaged in the selling of digital identification chips that can be implanted into household pets, such as cats and dogs. Customers (e. g., veterinary clinics, animal hospitals) send orders by mail to the sales order department, where sales order clerks open the orders and review them for accuracy. For each order, the clerks enter the customer number, and the computer displays the customer record. The clerk matches the customer information on the screen with the customer order. Assuming that they match, the clerk enters the items and quantities being ordered. The computer edits the order by comparing the input data to customer and inventory master data. Assuming that the order passes the edits, the computer records the order on the sales event data and the sales order master data and then updates the inventory to allocate the…
Martin Shoes, Inc. manufactures and distributes orthopedic footwear. To sell its products, the marketing department requires sales personnel to call on the shoe retailers within their assigned geographic territories. Each salesperson has a laptop computer, which he or she uses to record sales orders during the day and to send these sales orders to Martin’s network nightly for updating the company’s sales order file.
Each day, warehouse personnel review the current sales orders in its file, and where possible, pick the goods and ready them for shipment. (Martin ships goods via common carrier, and shipping terms are generally FOB from the shipping point.) When the shipping department completes a shipment, it also notifies the billing department, which then prepares an invoice for the customer. Payment terms vary by customer, but most are net 30. When the billing department receives a payment, the billing clerk credits the customer’s account and records the cash received.
Requirements
1.…
Chapter 4 Solutions
Accounting Information Systems
Ch. 4 - Prob. 1RQCh. 4 - Prob. 2RQCh. 4 - What function does the receiving department serve...Ch. 4 - Prob. 4RQCh. 4 - Prob. 5RQCh. 4 - Prob. 6RQCh. 4 - Prob. 7RQCh. 4 - Prob. 8RQCh. 4 - Prob. 9RQCh. 4 - Distinguish between an edit run, a sort run, and...
Ch. 4 - Prob. 11RQCh. 4 - Prob. 12RQCh. 4 - Prob. 13RQCh. 4 - Prob. 14RQCh. 4 - Prob. 15RQCh. 4 - Prob. 16RQCh. 4 - In a manual system, after which event in the sales...Ch. 4 - Prob. 18RQCh. 4 - What document initiates the billing process?Ch. 4 - Prob. 20RQCh. 4 - Prob. 1DQCh. 4 - Prob. 2DQCh. 4 - Prob. 3DQCh. 4 - Prob. 4DQCh. 4 - Prob. 5DQCh. 4 - Prob. 6DQCh. 4 - Prob. 7DQCh. 4 - Prob. 8DQCh. 4 - What financial statement misrepresentations may...Ch. 4 - Prob. 10DQCh. 4 - Prob. 11DQCh. 4 - Prob. 12DQCh. 4 - Prob. 13DQCh. 4 - Prob. 14DQCh. 4 - Prob. 15DQCh. 4 - How is EDI more than technology? What unique...Ch. 4 - Prob. 17DQCh. 4 - Prob. 1MCQCh. 4 - Prob. 2MCQCh. 4 - Prob. 3MCQCh. 4 - Prob. 4MCQCh. 4 - Prob. 5MCQCh. 4 - Prob. 6MCQCh. 4 - Prob. 7MCQCh. 4 - Prob. 8MCQCh. 4 - Prob. 9MCQCh. 4 - Prob. 10MCQCh. 4 - Prob. 1PCh. 4 - Prob. 2PCh. 4 - Prob. 3PCh. 4 - Prob. 4PCh. 4 - Prob. 5PCh. 4 - Prob. 6PCh. 4 - Prob. 7PCh. 4 - Prob. 8PCh. 4 - Prob. 9PCh. 4 - Prob. 10PCh. 4 - Prob. 11PCh. 4 - Prob. 12PCh. 4 - In 1989, Robert Smith opened a small fruit and...Ch. 4 - Posavek is a wholesale supplier of building...Ch. 4 - Prob. 3ICCCh. 4 - (Prepared by Will Richens and Michael Catchpole,...Ch. 4 - Prob. 6ICC
Knowledge Booster
Similar questions
- Wilson Petroleum is a local distributor of home heating oil. The firm also installs and services furnaces and heating systems in homes and small commercial buildings. The customer service department maintains sales and service records on current customers who number about 400. Detailed customer records are kept manually in file cabinets, and a small computer system holds all customer names and addresses for mailing and billing purposes. One full-time clerk maintains all the records and handles all billing and customer inquiries. Customers occasionally complain if delivery or service is late, but only one or two mild complaints are received each month. Delays are primarily a result of problems in the field rather than problems in assigning calls in the service department. A consultant has proposed a new computer system that will completely automate the customer service function. It will provide on-line billing and immediate access to all customer records. The cost of the…arrow_forwardThe accounting clerk for the Ram System company receives source documents such as purchase orders, sales invoices, and vendor invoices, which she uses to prepare journal vouchers to the general ledger for general ledger entries. Each day the clerk posts the journal vouchers to the general ledger and the related subsidiary ledgers. Each month the clerk reconciles the subsidiary accounts to their control accounts in the general ledger to ensure that they balance. Required: Discuss any control weaknesses and risks associated with this scenario.arrow_forwardThe accounting clerk for the RAM System Company receives source documents such as purchase orders, sales invoices, and vendor invoices, which she uses to prepare journal vouchers for general ledger entries. Each day the clerk posts the journal vouchers to the general ledger and the related subsidiary ledgers. Each month the clerk reconciles the subsidiary accounts to their control accounts in the general ledger to ensure that they balance. Discuss any control weaknesses and risks associated with this scenario.arrow_forward
- Lenter Supply Company is a medium-sized distributor of wholesale hardware supplies in the central Ohio area. It has been a client of yours for several years and has instituted excellent internal controls for sales at your recommendation. In providing control over shipments, the client has prenumbered “warehouse removal slips” that are used for every sale. It is company policy never to remove goods from the warehouse without an authorized warehouse removal slip. After shipment, two copies of the warehouse removal slip are sent to billing for the computerized preparation of a sales invoice. One copy is stapled to the duplicate copy of a prenumbered sales invoice, and the other copy is filed numerically. In some cases, more than one warehouse removal slip is used for billing one sales invoice. The smallest warehouse removal slip number for the year is 11741 and the largest is 34687. The smallest sales invoice number is 45302 and the largest is 65747. In the audit of sales, one of the…arrow_forwardLenter Supply Company is a medium-sized distributor of wholesale hardware supplies in the central Ohio area. It has been a client of yours for several years and has instituted excellent internal controls for sales at your recommendation. In providing control over shipments, the client has prenumbered “warehouse removal slips” that are used for every sale. It is company policy never to remove goods from the warehouse without an authorized warehouse removal slip. After shipment, two copies of the warehouse removal slip are sent to billing for the computerized preparation of a sales invoice. One copy is stapled to the duplicate copy of a prenumbered sales invoice, and the other copy is filed numerically. In some cases, more than one warehouse removal slip is used for billing one sales invoice. The smallest warehouse removal slip number for the year is 11741 and the largest is 34687. The smallest sales invoice number is 45302 and the largest is 65747. In the audit of sales, one of the…arrow_forwardYou are a member of the recently formed internal audit department of Hauz of Spinach. The company manufactures tinned vegetables which are supplied to hypermarkets. The management is concerned about the effectiveness of their sales and despatch system and have asked internal audit to document and review the system. Sales orders are mainly placed through Hauz of Spinach’s website but some are made via telephone. Online orders are automatically checked against inventory records for availability; telephone orders, however, are checked manually by order clerks after the call. A follow-up call is usually made to customers if there is insufficient inventory. When taking telephone orders, clerks note down the details on plain paper and afterwards they complete a three-part pre-printed order form. These order forms are NOT sequentially numbered and are sent manually to both despatch and the accounts department. As the company is expanding, customers are able to place online orders which will…arrow_forward
- Consider the following short case as you respond to the question:SPC Corporation sells computer security software. They maintain their AIS using general ledger software; data files are backed up twice a day. Sales staff can access the customer database, inventory files and general ledger, as well as sales-related documents such as invoices and sales orders. Newly hired sales staff members at SPC receive the company procedures manual which explains the process used to complete the steps in the sales/collection process. To minimize costs, SPC designates up to five sales staff members each month who can do credit checks for all new customers in addition to processing sales. SPC bills its clients monthly and uses the balance forward method of accounting for receivables; all cash receipts from clients are processed using a lockbox procedure. The lockbox firm's fee is 3% of all collections. SPC's accounting department estimates bad debts at the end of each fiscal year; they are normally…arrow_forwardEveryday Supplies Pty Ltd is a single-store retailer that sells a variety of tools, garden supplies, timber, small appliances, and electrical fixtures to the public, although about half of Everyday Supplies’ sales are to construction contractors on account.Retail customers pay for merchandise by cash or credit card at cash registers when merchandise is purchased. A contractor may purchase merchandise on account, if approved by the credit manager based only on the manager’s familiarity with the contractor’s reputation. After credit is approved, the sales associate files a prenumbered charge form with the accounts receivable supervisor to set up the receivable.The accounts receivable supervisor independently verifies the pricing and other details on the charge form by reference to a management - authorised price list, corrects any errors, prepares the invoice, and supervises a part-time employee who mails the invoice to the contractor. The accounts receivable supervisor electronically…arrow_forwardPrecision 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. How can the auditors determine whether Precision Industries, Inc., has made a proper year-end cutoff of sales transactions?arrow_forward
- Lamar LLC is in the process of updating its revenues and receivables systems with the implementation of new accounting software. James Loden, Inc. is an independent information technology consultant who is assisting Tamar with the project. James has developed the following checklist containing internal control points that the company should consider in this new implementation: Will customer orders be received via the Internet? Are all collections from customers received in the form of checks? Are product quantities monitored regularly?arrow_forwardYou are a member of the recently formed internal audit department of Hauz of Spinach. The companymanufactures tinned vegetables which are supplied to hypermarkets. The management is concernedabout the effectiveness of their sales and despatch system and have asked internal audit to documentand review the system. Sales orders are mainly placed through Hauz of Spinach’s website but some are made via telephone.Online orders are automatically checked against inventory records for availability; telephone orders,however, are checked manually by order clerks after the call. A follow-up call is usually made tocustomers if there is insufficient inventory. When taking telephone orders, clerks note down thedetails on plain paper and afterwards they complete a three-part pre-printed order form. Theseorder forms are NOT sequentially numbered and are sent manually to both despatch and theaccounts department. As the company is expanding, customers are able to place online orders which will exceed…arrow_forwardLamar LLC is in the process of updating its revenues and receivables systems with the implementation of new accounting software. James Loden, Inc. is an independent information technology consultant who is assisting Tamar with the project. James has developed the following checklist containing internal control points that the company should consider in this new implementation: Is the sales department separate from the credit office and the IT department?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,
Auditing: A Risk Based-Approach to Conducting a Q...AccountingISBN:9781305080577Author:Karla M Johnstone, Audrey A. Gramling, Larry E. RittenbergPublisher:South-Western College Pub
Auditing: A Risk Based-Approach (MindTap Course L...AccountingISBN:9781337619455Author:Karla M Johnstone, Audrey A. Gramling, Larry E. RittenbergPublisher:Cengage Learning
Pkg Acc Infor Systems MS VISIO CDFinanceISBN:9781133935940Author:Ulric J. GelinasPublisher:CENGAGE L
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
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
Auditing: A Risk Based-Approach (MindTap Course L...
Accounting
ISBN:9781337619455
Author:Karla M Johnstone, Audrey A. Gramling, Larry E. Rittenberg
Publisher:Cengage Learning
Pkg Acc Infor Systems MS VISIO CD
Finance
ISBN:9781133935940
Author:Ulric J. Gelinas
Publisher:CENGAGE L