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…
A 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…
K Cannon, Inc., is a manufacturer of portable CD players. The company purchases raw materials such as plastics and computer chips for its conversion cycle. The following describes K Cannon’s purchases and payments procedures. John, the purchasing department clerk, monitors raw materials inventory levels and prepares a purchase requisition when purchases are necessary. These are sent to the purchasing agent, who prepares six copies of a purchase order. Two purchase orders are sent directly to the vendor. One is placed in an open purchase order file in the purchasing department, and one is used to post to the purchases journal. Each week the purchasing department clerk prepares a journal voucher from the purchases journal and sends it to the general ledger department for posting. The AP and the receiving departments also each receive a copy of the purchase order, which they file temporarily. Upon receiving the raw materials, the receiving department clerk creates five copies of the…
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
- 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.…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_forwardConsider 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_forward
- Paul 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_forwardCase analysis 2 FTW corporation sells computer peripherals and related devices, such as printers, ink, flash drives and cables. FTW has a staff of three purchasing agents, each of whom oversees a specific set of inventory items. Each purchasing agent uses his/her discretion in making decisions about when to order inventory, how much inventory to order, and which vendor to purchase from. When ordered inventory arrives at FTW, one of two receiving clerks matches the items, quantities, and vendors against a copy of the purchase order, then either stocks the merchandise on the shelves or puts it in the storeroom. FTW's accountant receives a copy of the invoice from the vendor, as well as an e-mail from one of the receiving clerks indicating that merchandise has been received. The e-mail also includes the relevant purchase order number. The accountant files the invoice by date in a filing cabinet; once a week, the accountant removes invoices from the filing cabinet and pats them by…arrow_forwardThe 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…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_forwardUnilever ltd is a company that manufactures and sells various consumer products in Kenya. The Company performs its purchasing transaction cycle activities using its integrated ERP system as follows:Employees in any department can prepare purchase requisitions for items they note as being either out of stock or in small quantity. Each day, employees in the purchasing department process all purchase requests from the prior day. To the extent possible, requests for items available from the same supplier are combined into one larger purchase order in order to obtain volume discounts. Purchasing agents use the Internet to compare prices in order to select suppliers. If an Internet search discovers a potential new supplier, the purchasing agent enters the relevant information in the system, thereby adding the supplier to the approved supplier list. Purchase orders above 10,000,000 must be approved by the purchasing department manager. Paper purchase orders are printed and mailed to…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. 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?arrow_forward
- The following describes the revenue cycle procedures for a hypothetical company.The sales department clerk receives hard-copy customer orders and manually prepares a six-part hardcopy sales order. Copies of the sales order are distributed to various departments as follows: Copies 1, 2, and 3 go to the shipping department, and Copies 4, 5, and 6 are sent to the billing department where they are temporarily filed by the billing clerk.Upon receipt of the sales order copies, the shipping clerk picks the goods from the warehouse shelves and ships them to the customer. The clerk sends Copy 1 of the sales order along with the goods to the customer. Copy 2 is sent to the billing department, and Copy 3 is filed in the shipping department. When the billing clerk receives Copy 2 from the warehouse, she pulls the other copies from the temporary file and completes the documents by adding prices, taxes, and freight charges. Then, using the department PC, the billing clerk records the sale in the…arrow_forwardTIGHT LINES FISHING AND CAMPING SUPPLIES (NETWORKED COMPUTER SYSTEM AND MANUAL PROCEDURES) Tight Lines Fishing and Camping Supplies is a New York–based wholesaler of fishing and camping equipment that serves fishing and camping retailers throughout the north east. Tight Lines uses a centralized accounting system with networked terminals in the departments. You have been hired by Tight Lines to evaluate their processes, risks, and internal controls. The following paragraphs describe Tight Lines payroll and fixed asset systems. Payroll System Each day Tight Lines employees record their hours worked on time cards, which their supervisors review for correctness and submit to the payroll department at the end of the workweek.Using a terminal connected to the central payroll system, which is located in the data processing department, the payroll clerk inputs the time-card data, prints hard copies of the paychecks, prints two copies of the payroll register, and posts to digital employee…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_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
Financial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher: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
Financial Accounting: The Impact on Decision Make...
Accounting
ISBN:9781305654174
Author:Gary A. Porter, Curtis L. Norton
Publisher:Cengage Learning
Pkg Acc Infor Systems MS VISIO CD
Finance
ISBN:9781133935940
Author:Ulric J. Gelinas
Publisher:CENGAGE L