The following is a list of 12 control plans from this chapter or from Chapters 8, 9, 10, 11, and 12. These are followed by a list of 10 system failures that have control implications. Match the 10 system failures with a control plan that would best prevent the system failure from occurring. Because there are 12 control plans, you should have two letters left over. Control Plans Digital signature Tickler file of open POs and receiving reports Procedures for rejected inputs Compare input data with master data (e.g., vendor master data) Segregate duties among purchasing, receiving, and accounts payable Program change controls Reconcile bank account Reconcile run-to-run totals Review of a cash planning report Match invoice, PO, and receiving report Access control software Segregate duties between accounts payable and cashier System Failures Wilson Inc. ordered 30 circuit breakers from Elon Electric. Only 25 breakers were received; the other five were on back order at Elon. An invoice for 30 breakers was received at Wilson, recorded, and eventually paid. Trent Company often does not receive invoices in a timely manner and cannot record them in time to take advantage of payment discounts. Norma, the cashier at Scarsdale Company, has been writing checks to herself. This fraud has gone undetected for years. At East Bend Company, all incoming invoices are matched against open POs and receiving reports. When Juan, the purchasing manager, is performing this match, he sometimes can’t find a PO, and so he prepares a PO to cover the invoice. India Company receives batches of vendor invoices once each day via an EDI feed from a VAN. Some of these invoices are from vendors that do not do business with India. Westover Corp. often loses discounts on payments to vendors because of cash flow problems. Allie, the AP clerk at Fuller Company, has grown tired of resolving discrepancies among vendor invoices, POs, and receiving reports. To make his life easier and to reduce rejects, she changed the AP invoice program to allow large variances. Twice each week, Nellie, the AP clerk at Zagreb Company, selects a batch of vendor invoices and sends them to Gary, the clerk in cash disbursements. Occasionally, after Gary makes the electronic payments, it is discovered that not all the payments were made or that some were made incorrectly. Searcy, Inc. receives electronic invoices through a Web portal hosted by a third party. Some of these invoices are not correct. After investigation, it is discovered that the invoices were altered in transit from the vendor. Gary, the cashier, looks over the invoices that he has received and makes payments as needed. Some of those payments are to bogus vendors who Gary knows have not provided any goods or services to Rainbow.

The following is a list of 12 control plans from this chapter or from Chapters 8, 9, 10, 11, and 12. These are followed by a list of 10 system failures that have control implications. Match the 10 system failures with a control plan that would best prevent the system failure from occurring. Because there are 12 control plans, you should have two letters left over. Control Plans Digital signature Tickler file of open POs and receiving reports Procedures for rejected inputs Compare input data with master data (e.g., vendor master data) Segregate duties among purchasing, receiving, and accounts payable Program change controls Reconcile bank account Reconcile run-to-run totals Review of a cash planning report Match invoice, PO, and receiving report Access control software Segregate duties between accounts payable and cashier System Failures Wilson Inc. ordered 30 circuit breakers from Elon Electric. Only 25 breakers were received; the other five were on back order at Elon. An invoice for 30 breakers was received at Wilson, recorded, and eventually paid. Trent Company often does not receive invoices in a timely manner and cannot record them in time to take advantage of payment discounts. Norma, the cashier at Scarsdale Company, has been writing checks to herself. This fraud has gone undetected for years. At East Bend Company, all incoming invoices are matched against open POs and receiving reports. When Juan, the purchasing manager, is performing this match, he sometimes can’t find a PO, and so he prepares a PO to cover the invoice. India Company receives batches of vendor invoices once each day via an EDI feed from a VAN. Some of these invoices are from vendors that do not do business with India. Westover Corp. often loses discounts on payments to vendors because of cash flow problems. Allie, the AP clerk at Fuller Company, has grown tired of resolving discrepancies among vendor invoices, POs, and receiving reports. To make his life easier and to reduce rejects, she changed the AP invoice program to allow large variances. Twice each week, Nellie, the AP clerk at Zagreb Company, selects a batch of vendor invoices and sends them to Gary, the clerk in cash disbursements. Occasionally, after Gary makes the electronic payments, it is discovered that not all the payments were made or that some were made incorrectly. Searcy, Inc. receives electronic invoices through a Web portal hosted by a third party. Some of these invoices are not correct. After investigation, it is discovered that the invoices were altered in transit from the vendor. Gary, the cashier, looks over the invoices that he has received and makes payments as needed. Some of those payments are to bogus vendors who Gary knows have not provided any goods or services to Rainbow.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

Control Plans

Digital signature
Tickler file of open POs and receiving reports
Procedures for rejected inputs
Compare input data with master data (e.g., vendor master data)
Segregate duties among purchasing, receiving, and accounts payable
Program change controls
Reconcile bank account
Reconcile run-to-run totals
Review of a cash planning report
Match invoice, PO, and receiving report
Access control software
Segregate duties between accounts payable and cashier

System Failures

Wilson Inc. ordered 30 circuit breakers from Elon Electric. Only 25 breakers were received; the other five were on back order at Elon. An invoice for 30 breakers was received at Wilson, recorded, and eventually paid.
Trent Company often does not receive invoices in a timely manner and cannot record them in time to take advantage of payment discounts.
Norma, the cashier at Scarsdale Company, has been writing checks to herself. This fraud has gone undetected for years.
At East Bend Company, all incoming invoices are matched against open POs and receiving reports. When Juan, the purchasing manager, is performing this match, he sometimes can’t find a PO, and so he prepares a PO to cover the invoice.
India Company receives batches of vendor invoices once each day via an EDI feed from a VAN. Some of these invoices are from vendors that do not do business with India.
Westover Corp. often loses discounts on payments to vendors because of cash flow problems.
Allie, the AP clerk at Fuller Company, has grown tired of resolving discrepancies among vendor invoices, POs, and receiving reports. To make his life easier and to reduce rejects, she changed the AP invoice program to allow large variances.
Twice each week, Nellie, the AP clerk at Zagreb Company, selects a batch of vendor invoices and sends them to Gary, the clerk in cash disbursements. Occasionally, after Gary makes the electronic payments, it is discovered that not all the payments were made or that some were made incorrectly.
Searcy, Inc. receives electronic invoices through a Web portal hosted by a third party. Some of these invoices are not correct. After investigation, it is discovered that the invoices were altered in transit from the vendor.
Gary, the cashier, looks over the invoices that he has received and makes payments as needed. Some of those payments are to bogus vendors who Gary knows have not provided any goods or services to Rainbow.

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 3 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.