Accounting Information Systems
10th Edition
ISBN: 9781337619202
Author: Hall, James A.
Publisher: Cengage Learning,
expand_more
expand_more
format_list_bulleted
Question
Chapter 5, Problem 6ICC
a.
To determine
Prepare a data flow diagram of the current system.
b.
To determine
Prepare the system flowchart of the existing system.
c.
To determine
Explain the internal control weaknesses in the system and discuss the risks associated with internal control weaknesses.
d.
To determine
Create a system flowchart of a redesigned computer-based system that resolves the control weaknesses identified.
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 describes the purchases and cash disbursements procedures for a lawn and garden supply wholesaler that uses central computer system terminals with in departments.
The inventory control clerk visually reviews inventory levels from his computer terminal to identify items that need to be ordered. He then prints and sends a hard copy purchase requisition for the needed items to the purchasing agent. Based on the requisi- tion, the purchasing agent selects a vendor and adds a digital record to the purchase order file from terminal in the purchasing department. The clerk then prints a hard copy of the purchase order and mails it to the vendor. Finally, the purchasing agent destroys the purchase requisition, which it is no longer niceded since the relevant details are on the PO.
When the materials arrive at the receiving department a receiving clerk prints a copy of the purchase order from his terminal and reconciles to the packing slip. The clerk then manually creates wo-part…
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…
Chapter 5 Solutions
Accounting Information Systems
Ch. 5 - Prob. 1RQCh. 5 - What purpose does a purchasing department serve?Ch. 5 - Prob. 3RQCh. 5 - Prob. 4RQCh. 5 - Prob. 5RQCh. 5 - Prob. 6RQCh. 5 - Prob. 7RQCh. 5 - Prob. 8RQCh. 5 - Prob. 9RQCh. 5 - Some organizations do not use an AP subsidiary...
Ch. 5 - What is the purpose of the blind copy of a PO?Ch. 5 - Prob. 12RQCh. 5 - Prob. 1DQCh. 5 - Prob. 2DQCh. 5 - Prob. 3DQCh. 5 - The level of day-to-day department activity in...Ch. 5 - Prob. 5DQCh. 5 - What is central to a successful EDI...Ch. 5 - Discuss the objective of eliminating the receiving...Ch. 5 - What purpose does multilevel security control play...Ch. 5 - Prob. 9DQCh. 5 - Prob. 10DQCh. 5 - Which of the following statements is correct? a....Ch. 5 - Which of the following represents incompatible...Ch. 5 - Prob. 3MCQCh. 5 - Prob. 4MCQCh. 5 - Prob. 5MCQCh. 5 - Prob. 6MCQCh. 5 - Prob. 7MCQCh. 5 - Which of the following tasks should the cash...Ch. 5 - Which ledger can be updated solely from the...Ch. 5 - Prob. 10MCQCh. 5 - Prob. 1PCh. 5 - INVENTORY ORDERING ALTERNATIVES The flowchart for...Ch. 5 - Prob. 3PCh. 5 - Prob. 4PCh. 5 - Prob. 5PCh. 5 - Prob. 6PCh. 5 - Prob. 7PCh. 5 - Prob. 8PCh. 5 - Prob. 9PCh. 5 - Prob. 10PCh. 5 - Prob. 11PCh. 5 - UNRECORDED LIABILITIES You are auditing the...Ch. 5 - SMITHS MARKET (SMALL BUSINESS ACCOUNTING SYSTEM)...Ch. 5 - POSAVEK REMODELING AND BUILDING SUPPLY COMPANY...Ch. 5 - GREEN POND NURSERY (STANDALONE PC-BASED ACCOUNTING...Ch. 5 - Prob. 4ICCCh. 5 - Prob. 5ICCCh. 5 - Prob. 6ICCCh. 5 - Prob. 7ICCCh. 5 - Prob. 8ICC
Knowledge Booster
Similar questions
- SYSTEM DOCUMENTATION- REVENUE CYCLE (MANUALAND COMPUTER PROCESSES)The following describes the revenue cycle procedures for a hypotheticalcompany. The sales department clerk receives hard-copy customer orders andmanually prepares a six-part hard-copy sales order. Copies of the salesorder are distributed to various departments as follows: Copies 1, 2, and3 go to the shipping department, and Copies 4, 5, and 6 are sent to thebilling department where they are temporarily filed by the billing clerk. Upon receipt of the sales order copies, the shipping clerk picks the goodsfrom the warehouse shelves and ships them to the customer. Theclerk sends Copy 1 of the sales order along with the goods to thecustomer. Copy 2 is sent to the billing department, and Copy 3 is filed inthe shipping department. When the billing clerk receives Copy 2 from the warehouse, she pulls theother copies from the temporary file and completes the documents byadding prices, taxes, and freight charges. Then, using the…arrow_forwardWhen Legacy Co. receives telephone and fax orders, the billing department prepares an invoice. The invoice is mailed immediately. A copy of the invoice serves as a shipping notice. The shipping department removes inventory from the warehouse and prepares the shipment. When the order is complete, the goods are shipped. The clerk checks the customer’s credit before recording the sale in the general journal and the account receivable subsidiary ledger. The receptionist opens the mail and lists all payments. The receptionist also handles all customer complaints and prepares sales return forms for defective merchandise. The cashier records all cash receipts in the general journal and makes the appropriate entry in the accounts receivable subsidiary ledger. The cashier prepares the daily bank deposit. Describe at least four internal control weaknesses at Legacy Co.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_forward
- The 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_forwardPaul Williams recently joined XYZ2 Limited as the head of the accounting department. Williams spent the first few weeks analysing the account information system. Based on this analysis, Williams is concerned about the purchase system of XYZ2 Limited. Here are the details of the purchase system. The purchasing agent of XYZ2 Limited periodically checks inventory levels from a computer terminal connected to a central accounting system. The agent searches the inventory file for items that need to be ordered. He then selects a supplier, prints a hard copy of the purchase order, and mails it to the vendor. The clerk files one copy of the PO in the department and sends a second copy to the AP Clerk. When the inventories arrive at the receiving department, a receiving clerk reconciles the items with the packing slip, inspects them for condition, and manually prepares a three-part receiving report. The clerk sends one copy to the purchasing department to close out the open PO, files one copy…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
- 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…arrow_forwardA CPA’s client, Boos & Baumkirchner, Inc., is a medium-sizemanufacturer of products for the leisure-time activities market (camping equipment,scuba gear, bows and arrows, and so forth). During the past year, a computer system wasinstalled and inventory records of finished goods and parts were converted to computerprocessing. The inventory master file is maintained on a disk. Each record of the filecontains the following information:• Item or part number • Total value of inventory on hand at cost• Description • Date of last sale or usage• Size • Quantity used or sold this year• Unit-of-measure code • Economic order quantity• Quantity on hand • Code number of major vendor• Cost per unit • Code number of secondary vendorIn preparation for year-end inventory, the client has two identical sets of preprintedinventory count cards. One set is for the client’s inventory counts, and the other is for theCPA’s use to make audit test counts. The following information is on each card:• Item or…arrow_forwardPaul Williams recently joined XYZ2 Limited as the head of accounting department. Williams spent the first few weeks to analyse the account information system. Based on this analysis, Williams is concerned about the purchase system of XYZ2 Limited. Here is the details of purchase system. The purchasing agent of XYZ2 Limited periodically checks inventory levels from a computer terminal, which is connected to a central accounting system. The agent searches the inventory file for items that need to be ordered. He then selects a supplier, prints a hard copy of the purchase order, and mails it to the vendor. The clerk files one copy of the PO in the department and sends a second copy to the AP Clerk. When the inventories arrive at the receiving department, a receiving clerk reconciles the items with the packing slip, inspects them for condition, and manually prepares a three-part receiving report. The clerk sends one copy to the purchasing department to close out the open PO, files one copy…arrow_forward
- 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 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_forwardMartin 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.…arrow_forwardThe following is a description of manufacturing company’s purchasing procedures. All computers in the company are networked to a centralized accounting system so that each terminal has full access to a common database. The inventory control clerk periodically checks inventory levels from a computer terminal to identify items that need to be ordered. Once the clerk feels inventory is too low, he chooses a supplier and creates a purchase order from the terminal by adding a record to the purchase order file. The clerk prints a hard copy of the purchase order and mails it to the vendor. An electronic notification is also sent to accounts payable and receiving, giving the clerks of each department access to 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 order from his terminal and reconciles it to the packing slip. The clerk then creates a receiving report on a computer system. An…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
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