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
- Arcontica 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_forwardArcontica Classic Furniture (ACF) manufactures a range of rustic chairs, lawn furniture, and interior furnishing including lamps, desks, and bed frames. ACF's customer base comprises both private customers and retail outlets. Consumer's sales are for cash or by credit card, but business customers are for cash or by credit card, but business customers are extended 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, prepares a sales order, and sends the 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 updates the sales journal and sends an invoice to the customer. The clerk then sends the shipping notice to the AR…arrow_forwardJC 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_forward
- QT, Inc. and Elppa Computers, Inc. compete with each other in the personal computer market. QT assembles computers to customer orders, building and delivering a computer within four days of a customer entering an order online. Elppa, on the other hand, builds computers for inventory prior to receiving an order. These computers are sold from inventory once an order is received. Selected financial information for both companies from recent financial statements follows (in millions): QT ElppaSales $56,940 $120,357Cost of goods sold 44,754 92,385Inventory, beginning of period 1,382 6,317Inventory, end of period 1,404 7,490a. Determine for both companies (1) the inventory turnover and (2) the…arrow_forwardREA Model—Adirondacks Classic Furniture Adirondacks Classic Furniture (ACF) manufactures a range of rustic chairs, lawn furniture, and interior furnishing including lamps, desks, and bedframes. ACF’s customer base comprises both private consumers and retail outlets. Consumer’s sales are for cash or by credit card, but business customers are extended 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, prepares a sales order, and sends the 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 updates the sales journal and sends an invoice to the customer. The clerk then sends the shipping notice to the AR department, where…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
- REA model -- adirondacks classic furniture adirondacks classic furniture (ACF) manufactures a range of rustice chairs, lawn furniture, and interior furnishing including lamps, desks, and bedframes. ACF's customer base comprises both private consumers and retail outlets. Consumer’s sales are for cash or by credit card, but business customers are extended 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, prepares a sales order, and sends the 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 updates the sales journal and sends an invoice to the customer. The clerk then sends the shipping notice to the AR department,…arrow_forwardThe A-to-Z Office Supply Company Christine Yamaguchi is the manager of the A-to-Z Office Supply Company in Charlotte. The company attempts to gain an advantage over its competitors by providing quality customer service, which includes prompt delivery of orders by truck or van and always being able to meet customer demand from its stock. To achieve this degree of customer service, A-to-Z must stock a large volume of items on a daily basis at a central warehouse and at three retail stores in the city and suburbs. Christine maintains these inventory levels by borrowing cash on a daily basis from the First Piedmont Bank. She estimates that for the coming fiscal year, the company’s demand for cash to pay for inventory will be $17,000 per day for 305 working days. Any money she borrows during the year must be repaid with interest by the end of the year. The annual interest rate currently charged by the bank is 9%. Any time Christine takes out a loan to purchase inventory, the bank charges…arrow_forwardIris Plant owns and operates three floral shops in Magnolia, Texas. The accounting functions are performed manually. Each of the shops has a manager who oversees the cash receipts and purchasing functions for the shop. A clerk at the central shop pays all the bills and also prepares payroll checks and maintains the general journal. Iris is seriously considering switching to a computerized system. With so many information system packages on the market, Iris is overwhelmed. Advise Iris as to which business modules you think her organization could find beneficial. Discuss advantages, disadvantages, and internal control issues.arrow_forward
- QT, Inc., and Elppa Computers, Inc., compete with each other in the personal computer market. QT assembles computers to customer orders, building and delivering a computer within four days of a customer entering an order online. Elppa, on the other hand, builds computers for inventory prior to receiving an order. These computers are sold from inventory once an order is received. Selected financial information for both companies from recent financial statements follows (in millions): QT Elppa Sales $56,940 $120,357 Cost of merchandise sold 44,754 92,385 Inventory, beginning of period 1,382 6,317 Inventory, end of period 1,404 7,490 a. Determine for both companies (1) the inventory turnover and (2) the number of days' sales in inventory. Round your calculations and answers to one decimal place. Assume 365 days a year. QT Elppa 1. Inventory turnover fill in the blank 1 fill in the blank 2 2. Number of days' sales in inventory…arrow_forwardQT, Inc., and Elppa Computers, Inc., compete with each other in the personal computer market. QT assembles computers to customer orders, building and delivering a computer within four days of a customer entering an order online. Elppa, on the other hand, builds computers for inventory prior to receiving an order. These computers are sold from inventory once an order is received. Selected financial information for both companies from recent financial statements follows (in millions): QT Elppa Sales $56,940 $120,357 Cost of merchandise sold 44,754 92,385 Inventory, beginning of period 1,382 6,317 Inventory, end of period 1,404 7,490 a. Determine for both companies (1) the inventory turnover and (2) the number of days' sales in inventory. Round your calculations and answers to one decimal place. Assume 365 days a year. QT Elppa 1. Inventory turnover fill in the blank 1 fill in the blank 2 2. Number of days' sales in inventory…arrow_forwardThe Crane Appliance Store is an experienced home appliance dealer. Crane also offers a number of services together with the home appliances that it sells. Assume that Crane sells dishwashers on a standalone basis. Crane also sells installation services and maintenance services for dishwashers. However, Crane does not offer installation or maintenance services to customers who buy dishwashers from other vendors. Pricing for dishwashers is as follows. Dishwasher only $1,264 Dishwasher with Installation service 1,397 Dishwasher with maintenance services 1,530 Dishwasher with installation and maintenance services 1,600 In each instance in which maintenance services are provided, the maintenance service is separately priced within the arrangement at $266. Additionally, the incremental amount charged by Crane for installation approximates the amount charged by independent third parties. Dishwashers are sold subject to a general right of return. If a customer…arrow_forward
- 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 PubPkg Acc Infor Systems MS VISIO CDFinanceISBN:9781133935940Author:Ulric J. GelinasPublisher:CENGAGE L
- Financial Reporting, Financial Statement Analysis...FinanceISBN:9781285190907Author:James M. Wahlen, Stephen P. Baginski, Mark BradshawPublisher:Cengage Learning