GREEN POND NURSERY (STANDALONE PC-BASED ACCOUNTING SYSTEM)
Green Pond Nursery Supply (GPNS) is a garden center wholesaler in eastern Pennsylvania that sells and distributes a wide range of garden products and equipment including organic fertilizers, premium flower and grass seeds, organic pesticides, and garden spreaders. GPNS’s customers are primarily small garden centers and landscape companies in the Mid-Atlantic States. Sales are on credit.
GPNS’s current information system includes manual procedures supported by independent (non-networked) PCs in each department Communications between departments are entirely through hard-copy documents. Recently, GPNS has been receiving complaints from suppliers regarding payment errors. Management believes that these complaints stem, in part, from their antiquated computer system. You have been hired to assess GPNS’s procedures and internal controls. The following is a description of GPNS’s expenditure cycle.
Purchasing Process
The purchasing agent receives an inventory status report from the inventory control department, which identifies the items that need to be reordered. The agent selects the suppliers, enters this information into the computer terminal to create a digital purchase order, and then prints three hard copies of the purchase order. He sends one copy to the supplier; one copy to the AP department, where it is filed temporarily, and files the third copy in the purchasing department.
When the goods are received, the receiving department inspects and verifies them using the packing slip, which is attached to the goods. The receiving clerk manually prepares two hard copies of a receiving report. One copy accompanies the goods to the warehouse for storage. The receiving clerk sends the second copy to the purchasing agent who closes the open purchase order. The purchase agent then forwards the receiving report to the inventory control clerk.
The inventory control clerk receives the receiving report and updates the inventory subsidiary. At the close of business, the clerk prepares an inventory summary, which he sends to the general ledger clerk.
Accounts Payable and Cash Disbursements Procedures
The AP clerk receives the supplier’s invoice and reconciles it with the purchase order in the temporary file. From her computer terminal, the clerk records the purchase in the purchases journal and records the liability by adding a record to the AP subsidiary ledger. The purchases order and invoice are then filed in the department.
Each day, the AP clerk visually searches the AP subsidiary ledger from her terminal for invoices that are due to be paid. The clerk prepares the check and records it in the digital check register. The negotiable portion of the check is mailed to the vendor, and a check copy is filed. The clerk then closes the liability in the AP subsidiary ledger and prepares a journal voucher, which she sends to the general ledger clerk.
Upon receipt of the inventory summary and journal voucher, the general ledger clerk updates the inventory control, AP control, and cash accounts.
Required
- a. Create a data flow diagram of the current system.
- b. Create a system flowchart of the existing system.
- c. Analyze the physical internal control weaknesses in the system.
- d. (Optional) Prepare a system flowchart of a redesigned computer-based system that resolves the control weaknesses that you identified. Explain your solution.
Trending nowThis is a popular solution!
Chapter 5 Solutions
Accounting Information Systems
- 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…arrow_forwardArcontica Classic Furniture manufactures a of rustic chairs, lawn furniture, and interior purnishing including lamps, desks and bed frames. AFC's customer base comprises both private customers and retail outlets. consumer's sales are for cash or by credit card, but business costumers are for cash or by credit card, but business costumers are extended by a line of credit. New business customers undergo a credit check before receiving a credit line. All sales are made online by fax or mailed in hard copy order. When a credit order is received, the sales clerk verifies inventory availability, prepare a sales order, and sends stock release copy to the warehouse clerk who picks the goods and arranges shipment. He then prepares the bills of lading and sends copies of the shipping notices to the billing department and inventory control. The billing department update the sales journal and sends an invoice to the customer. The clerk then sends the shipping notice to the AR department where…arrow_forwardGREEN PRODUCTS GARDENSUPPLY (STAND-ALONE PC-BASEDACCOUNTING SYSTEM)Green Products Garden (GPG) Supply sells and distributesa wide range of garden products and equipmentincluding organic fertilizers, premium flowerand grass seeds, organic pesticides, and gardenspreaders. GPG’s headquarters and warehouse islocated in Hopewell, Virginia. Their customers areprimarily small garden centers and landscape companiesin the Mid-Atlantic States. Sales are oncredit.GPG’s current information system includes manualprocedures supported by independent (nonnetworked)PCs in each department. Communicationsbetween departments is entirely through hardcopydocuments. Recently, GPG has been receivingcomplaints from customers and suppliers about billing,shipping, and payment errors. Managementbelieves that these complaints stem, in part, fromtheir antiquated computer system. You have beenhired to assess GPG’s procedures and internal controls.The following is a description of GPG’s revenue cycle. Sales…arrow_forward
- The following narrative describes the processing of customer mail orders at Eye- Dee- A- Pet, Inc.: Eye- Dee- A- Pet, Inc. is a small manufacturing operation engaged in the selling of digital identification chips that can be implanted into household pets, such as cats and dogs. Customers (e. g., veterinary clinics, animal hospitals) send orders by mail to the sales order department, where sales order clerks open the orders and review them for accuracy. For each order, the clerks enter the customer number, and the computer displays the customer record. The clerk matches the customer information on the screen with the customer order. Assuming that they match, the clerk enters the items and quantities being ordered. The computer edits the order by comparing the input data to customer and inventory master data. Assuming that the order passes the edits, the computer records the order on the sales event data and the sales order master data and then updates the inventory to allocate the…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_forwardThe Cullumber Appliance Store is an experienced home appliance dealer. Cullumber also offers a number of services together with the home appliances that it sells. Assume that Cullumber sells dishwashers on a standalone basis. Cullumber also sells installation services and maintenance services for dishwashers. However, Cullumber does not offer installation or maintenance services to customers who buy dishwashers from other vendors. Pricing for dishwashers is as follows. Dishwasher only $1,378 Dishwasher with Installation service 1,523 Dishwasher with maintenance services 1,668 Dishwasher with installation and maintenance services 1,738 In each instance in which maintenance services are provided, the maintenance service is separately priced within the arrangement at $290. Additionally, the incremental amount charged by Cullumber for installation approximates the amount charged by independent third parties. Dishwashers are sold subject to a general right of…arrow_forward
- 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_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 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_forwardSaurez Company, your client, manufactures paint. The company’s president, Maria Saurez, has decided to open a retail store to sell Saurez paint as well as wallpaper and other supplies that would be purchased from other suppliers. She has asked you for information about the conventional retail method of pricing inventories at the retail store. Instructions Prepare a report to the president explaining the retail method of pricing inventories. Your report should include the following points. a. Description and accounting features of the method. b. The conditions that may distort the results under the method. c. A comparison of the advantages of using the retail method with those of using cost methods of inventory pricing. d. The accounting theory underlying the treatment of net markdowns and net markups under the method.arrow_forward
- JC Company sells various merchandize ( building materials, stationery, house hold goods, and assortd groceries) to the general public and government workers on both cash and credit basis. You are a student at one of the universities and the sole trader for JC Company approaches you to write a company profile for him.arrow_forwardSMITH’SMARKET (SMALL BUSINESS POS ACCOUNTING SYSTEM) In 1989, Robert Smith opened a small fruit and vegetable market in Bethlehem, Pennsylvania. Originally Smith sold only produce grown on his family farm and orchard. As the market’s popularity grew, however, he added bread, canned goods, fresh meats, and a limited supply of frozen goods. Today Smith’s market is a full range farmers’ market with a strong local customer base. Indeed, the market’s reputation for low prices and high quality draws customers from other Pennsylvania cities and even from the neighboring state of New Jersey. Currently Smith’s market has 40 employees. These include sales staff, shelf stockers, farm laborers, shift supervisors, and clerical staff. Recently Smith has noticed a decline in profits and sales, while his purchases of products for resale have continued to rise. Although the company does not prepare audited financial statements, Robert Smith has commissioned your public accounting firm to assess his…arrow_forwardThe Appliance Store is an experienced home appliance dealer. Appliance Store also offers several services together with the home appliances that it sells. Assume that Appliance Store sells dishwashers on a standalone basis. Appliance Store also sells installation services and maintenance services for dishwashers. However, Appliance Store does not offer installation or maintenance services to customers who buy dishwashers from other vendors. Pricing for dishwashers is as follows. Dishwasher only $1,140 Dishwasher with Installation service (+$120) 1,260 Dishwasher with maintenance services (+$240) 1,380 Dishwasher with installation and maintenance services 1,450 In each instance in which maintenance services are provided, the maintenance service is separately priced within the arrangement at $240. Additionally, the incremental amount charged by Appliance Store for installation approximates the amount charged by independent third parties. Dishwashers are sold…arrow_forward
- Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,Pkg Acc Infor Systems MS VISIO CDFinanceISBN:9781133935940Author:Ulric J. GelinasPublisher:CENGAGE L