Question

DURAPLAST Company Ltd., opened its doors in 1979 as a wholesale supplier of plumbing equipment, tools,...

DURAPLAST Company Ltd., opened its doors in 1979 as a wholesale supplier of plumbing equipment, tools, and parts to hardware stores, home-improvement centers, and professional plumbers in the Accra-Tema Metropolitan area. Over the years they have expanded their operations to serve customers across the nation and now employ over 200 people as technical representatives, buyers, warehouse workers, and sales and office staff. Most recently DURAPLAST has experienced fierce competition from the large online discount stores such as Qualiplast and Interplast. In addition, the company is suffering from operational inefficiencies related to its archaic information system. DURAPLAST’s revenue cycle procedures are described in the following paragraphs.
Revenue Cycle
DURAPLAST’s sales department consists of 17 full-time and part-time employees. They receive orders via traditional mail, e-mail, telephone, and the occasional walk-in. Because DURAPLAST is a wholesaler, the vast majority of its business is conducted on a credit basis. The process begins in the sales department, where the sales clerk enters the customer’s order into the centralized computer sales order system. The computer and file server are housed in DURAPLAST’s small data processing department. If the customer has done business with DURAPLAST in the past his or her data are already on file. If the customer is a first-time buyer, however, the clerk creates a new record in the customer file. The system then creates a record of the transaction in the open sales order file. When the order is entered, an electronic copy of it is sent to the customer’s e-mail address as confirmation.
A clerk in the warehouse department periodically reviews the open sales order file from a terminal and prints two copies of a stock release document for each new sale, which he uses to pick the items sold from the shelves. The warehouse clerk sends one copy of the stock release to the sales department and the second copy, along with the goods, to the shipping department.
The warehouse clerk then updates the inventory subsidiary file to reflect the items and quantities shipped. Upon receipt of the stock release document, the sales clerk accesses the open sales order file from a terminal, closes the sales order, and files the stock release document in the sales department. The sales order system automatically posts these transactions to the sales, inventory control, and cost-of-goods sold accounts in the general ledger file.
Upon receipt of the goods and the stock release, the shipping department clerk prepares the goods for shipment to the customer. The clerk prepares three copies of the bill of lading. Two of these go with the goods to the carrier and the third, along with the stock release document, is filed in the shipping department. The billing department clerk reviews the closed sales orders from a terminal and prepares two copies of the sales invoice. One copy is mailed to the customer and the other is filed in the billing department. The clerk then creates a new record in the account receivable subsidiary file. The sales order system automatically updates the account receivable control account in the general ledger file.
DURAPLAST has hired you to review its sales order procedures for internal control compliance and to make recommendations for changes.
You are required to:
a. Create a data flow diagram of the current system. ;
b. Create a system flowchart of the existing system. ;
c. Analyze the internal control weaknesses in the system. ; and
d. Prepare a system flowchart of a redesigned computer-based system that resolves the control weaknesses that you identified. Explain your solution.

Homework Answers

Answer #1

ANSWER :

a),b) and d) - The Data Flowchart, System Flowchart and Redesigned System Flowchart attached.

c) Internal Control Deficiencies Identified:

1) The Credit worthiness and credit limit of the customers, whether new or existing is not checked before placing the sales order.

2) One copy of the Stock release statement is to be sent to the billing department also.

3) One copy of Sale order to be sent to billing department also.

4) Sales department must issue a Goods release order, only after which the shippin department must dispatch the goods.

5) A copy of the bill of lading must be sent to Warehouse department also.

Answer is very lengthy is unable to upload the same. sending it as an email.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
DURAPLAST Company Ltd., opened its doors in 1979 as a wholesale supplier of plumbing equipment, tools,...
DURAPLAST Company Ltd., opened its doors in 1979 as a wholesale supplier of plumbing equipment, tools, and parts to hardware stores, home-improvement centers, and professional plumbers in the Accra-Tema Metropolitan area. Over the years they have expanded their operations to serve customers across the nation and now employ over 200 people as technical representatives, buyers, warehouse workers, and sales and office staff. Most recently DURAPLAST has experienced fierce competition from the large online discount stores such as Qualiplast and Interplast....
DURAPLAST Company Ltd. DURAPLAST Company Ltd., opened its doors in 1979 as a wholesale supplier of...
DURAPLAST Company Ltd. DURAPLAST Company Ltd., opened its doors in 1979 as a wholesale supplier of plumbing equipment, tools, and parts to hardware stores, home-improvement centers, and professional plumbers in the Accra-Tema Metropolitan area. Over the years they have expanded their operations to serve customers across the nation and now employ over 200 people as technical representatives, buyers, warehouse workers, and sales and office staff. Most recently DURAPLAST has experienced fierce competition from the large online discount stores such as...
A. The following activities describe revenue and cash receipt systems of Kiara Outdoor Berhad. Kiara Outdoor...
A. The following activities describe revenue and cash receipt systems of Kiara Outdoor Berhad. Kiara Outdoor Berhad is a Sintok based wholesaler of rafting and camping equipment that serves outdoor sports camping retailers throughout the northern area of peninsular Malaysia. You have been hired by Kiara Outdoor Berhad to evaluate their processes, risks and internal controls. Below is the revenue cycle procedures of Kiara Outdoor Berhad. Sales Order Procedures Customer orders are mailed or emailed to the sales department. The...
Prepare a System flowchart to account for EVERY ACTIVITY described in the scenario below: A customer...
Prepare a System flowchart to account for EVERY ACTIVITY described in the scenario below: A customer sends a customer order document to a company. A clerk in the sales department enters the data from the customer order document into the computer system using a keyboard. After keying in the data, the customer order document is filed in the sales department by customer number. A computer program processes the entered data by checking customer’s credit by referring the customer file (online...
. Below is the extract of system for billing and recording accounts receivable which is in...
. Below is the extract of system for billing and recording accounts receivable which is in use at Point Cook Corporation Ltd (Point Cook), a manufacturer of desktop computers. All the sales are in credit. An incoming customer order is received in the order department by a clerk who prepares a company sales order form (3 copies). The sales order form, which is not pre-numbered, contains information such as the customer’s name and address, customer’s account number, quantity and items...
This company is flowcharting the steps in the order systems to evaluate for weaknesses and/or need...
This company is flowcharting the steps in the order systems to evaluate for weaknesses and/or need for additional internal controls.   The process of this business area is as follows: Company is called “I got this” (IGT). IGT has computerized part of the process for the computer center to read the Sales Order Database, and check the inventory master file for availability. It will then create the following documents: 1.a copy of each sales orders in the sales manager’s office computer,...
Narrative for Grant Black Company’s Order Entry Process The Grant Black Company sells medical supplies to...
Narrative for Grant Black Company’s Order Entry Process The Grant Black Company sells medical supplies to hospitals, clinics, and doctors’ offices. Customers places orders over the phone to the Grant Black customer fulfillment center. Grant Black uses an ERP system for all of its business processes. The sales process starts when the customer calls the Grant Black fulfillment center and gives his/her name to the customer service representative (CSR). The CSR keys the customer name into the ERP system, and...
Read the narrative below of an ordering process: The mailroom receives customer orders from customers, where...
Read the narrative below of an ordering process: The mailroom receives customer orders from customers, where clerks sort orders from the rest of the mail, group them into bathes, and forwards the orders to the order entry department. A clerk in the order entry department first checks that the batch is complete. The clerk looks up the customer number in a customer file and then keys the essential customer information into a network computer. The computer then checks the customer...
At Kornsen Industries, the revenue processes are conducted by five employees. The five employees are the...
At Kornsen Industries, the revenue processes are conducted by five employees. The five employees are the sales clerk, warehouse clerk, accountant 1, accountant 2, and the collection clerk. A description of their duties is as follows: a. The sales clerk receives customer orders by phone. She prepares a fourcopy sales order form. She files one copy, one copy goes to the warehouse clerk, one copy goes to accountant 1, and one copy is mailed to the customer. b. After receiving...
THIS IS THE ENTIRE QUESTION. THERE IS NO MORE!! IF YOU ARE THE ONE WHO KEEPS...
THIS IS THE ENTIRE QUESTION. THERE IS NO MORE!! IF YOU ARE THE ONE WHO KEEPS COMMENTING THEN PLEASE DO NOT ANSWER AND LET SOMEONE ELSE DO IT. I know the beginning would probably start at "Inventory Control" and one of the "2 part requisitions" would go to "Purchasing" while the other would be "filed somewhere."   SYSTEM DOCUMENTATION— EXPENDITURE CYCLE (MANUAL PROCEDURES) The following describes the expenditure cycle manual procedures for a hypothetical company. The inventory control clerk examines the...