Green Products Garden Supply (Stand-Alone PC-Based Accounting System)
Green Products Garden (GPG) Supply sells and distributes a wide range of garden products and equipment including organic fertilizers, premium flower and grass seeds, organic pesticides, and garden spreaders. GPG's headquarters and warehouse is located in Hopewell, Virginia. Their customers are primarily small garden centers and landscape companies in the Mid-Atlantic States. Sales are on credit.
GPG's current information system includes manual procedures supported by independent (non-networked) PCs in each department. Communications between departments is entirely through hard-copy documents. Recently, GPG has been receiving complaints from customers and suppliers about billing, shipping, and payment errors. Management believes that these complaints stem, in part, from their antiquated computer system. You have been hired to assess GPG's procedures and internal controls. The following is a description of GPG's revenue cycle.
Sales Procedures
The revenue cycle begins when a customer places an order with a sales representative by phone or fax. A sales department employee enters the customer order into a standard sales order format using a word processor installed on a PC to produce: three sales order copies, a stock release document, a shipping notice, and a packing slip. The accounting department receives a copy of the sales order, the warehouse receives the stock release and a copy of the sales order, and the shipping department receives a shipping notice and packing slip. The sales clerk files a copy of the sales order in the department.
Upon receipt of the sales order, the accounting department clerk manually prepares an invoice and sends it to the customer. Using data from the sales order, the clerk then enters the sale in the department PC and records the sale in the sales journal and in the AR subsidiary ledger. At the end of the day the clerk prepares a hard-copy sales journal voucher, which is sent to the general ledger department.
Upon receipt of the sales order and stock release the warehouse clerk picks the products and sends them to the shipping department, along with the stock release. The warehouse clerk then updates the inventory records on the warehouse PC and files the sales order in the warehouse. At the end of the day the clerk prepares a hard-copy inventory account summary and sends it to the general ledger department. The shipping department clerk receives a shipping notice and packing slip from the sales department. The clerk files the shipping notice and holds open the packing slip until he receives the stock release and products from the warehouse. Upon receipt of the stock release, the shipping clerk prepares the two copies of a BOL using a word processor. The bills of lading and the packing slip are sent with the product to the carrier. The clerk then files the stock release in the department. The general ledger clerk posts the journal voucher and inventory summary to the general ledger, which is stored on the department PC, and the clerk then files these documents in the general ledger department.
Cash Receipts Procedures
Mail room employees open cash receipts from customers and reconcile the amounts on the checks and remittance advices. The remittance advices are sent to the accounting department, where a clerk records each remittance advice on a remittance list. The remittance list is then sent to the cash receipts department. Using the remittance advices, the accounting clerk updates the customer AR on the department PC and files the advice in the department. At the end of the day the clerk prepares an AR summary on the PC. A hard copy of the summary is sent to the general ledger department.
The mail room clerk sends the checks to the cash receipts department, where a clerk endorses each check with the words "For Deposit Only." Next, the clerk reconciles the checks with the remittance list and records the cash receipts in the cash receipts journal on the department PC. Finally, the clerk prepares a deposit slip and sends it and the checks to the bank.
The general ledger clerk posts the AR summary to general ledger and files it in the general ledger department.
Required:
b. Create a system flowchart of the existing system.
c. Analyze the physical internal control weaknesses in the system.
The weakness in the current system are:
answer to point 1:
As per the existing system, the process has been defined as under:
Green Products Garden Supply (Stand-Alone PC-Based Accounting System) Green Products Garden (GPG) Supply sells and distributes...
Sales Order Processing System The customer sales order is received via phone or through the mail. Gus Grinwich, the sales clerk, receives the sales order and checks the customer’s credit record. Once Grinwich checks the customer’s credit record, he prepares the sales order. From this sales order, Grinwich prepares a customer copy, stock release, shipping notice, two copies of the invoice, ledger copy, packing slip, and the file copy. One of the invoice copies, the ledger copy, and the file...
The Internal Audit Director has asked you to document the cash receipts system (which includes updating of A/R) at FreeFall, Inc A narrative of the system follows: FreeFall, Ine sells parachutes. An individual may come into the office and buy directly. When the customer comes to the office, they pay at time of purchase by cash or check. Other orders are made by mail and receipts come into the mailroom. Only checks are received by mail. In most cases, a...
Reference the narrative for Figure 3-12(picture 1) to complete picture 2 the missing labels and data flows. 3.12 Charting, Inc., a new audit client of yours, processes its sales and cash receipts documents in the following manner: 1 Payment on account. Each morning a mail clerk in the sales department opens the mail. The mail clerk prepares a remittance advice (showing customer and amount paid) if one is not received. The checks and remittance advices are then for warded to...
The Internal Audit Director has asked you to document the cash receipts system (which includes updating of A/R) at FreeFall, Inc A narrative of the system follows: FreeFall, Ine sells parachutes. An individual may come into the office and buy directly. When the customer comes to the office, they pay at time of purchase by cash or check. Other orders are made by mail and receipts come into the mailroom. Only checks are received by mail. In most cases, a...
At Kingston 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: The sales clerk receives customer orders by phone. She prepares a four‐copy 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. After receiving a sales...
At Kingston 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 four-copy 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...
Mail is delivered every day by noon to the mail room of Alex Corp, a privately-owned manufacturer. Customer payments are by check are enclosed in distinctive blue envelopes. The mail clerk separates those envelopes from all other mail. The clerk sends the unopened envelopes to the treasurer’s office. The treasurer opens the envelopes and compares the check amounts with the enclosed remittance advice. The treasurer endorses all checks, “For deposit”, prepares a 2-part list of all payments from customers, The...
The following describes the dales procedures for a hypothetical company. All procedures are manual and use hard-copy documents. The sales department clerk receives a customer orders from the customers and prepares a three-part sales order. The three copies are sent to the credit department for approval, where the clerk reviews the Customer Credit Records. After approval, the credit department clerk returns one copy of the sales order to the Sales Department, where it is reviewed and filed. The remaining two...
Merchandise Sales and Shipping Process • A customer at Budget Electronics submits an order to the Marketing Department, where the sale clerk enters it into the sales order system. Three copies of the sales order are produced, one is mailed to the customer and the two copies are sent to the Warehouse for processing. • The Credit Department checks credit for new customers only. If credit is approved, the master customer file is updated for credit limits. • First, the...
FIXED ASSETS SYSTEM CASE STUDY OUTDOOR ADVENTURE: WHITE WATER AND CAMPING SUPPLIES ================================================================================================= Outdoor 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 Outdoor Adventure to evaluate its processes, risks and internal controls. The following paragraphs describe Outdoor Adventure’s fixed asset system. Fixed asset acquisition begins with the departmental manager recognizing the need to obtain a new asset or replace an existing one. The manager...