Reference no: EM131010983

Green Mountain Coffee Roasters, Inc., was founded in 1981 and began as a small cafe in Waitsfield, Vermont, roasting and serving premium coffee on the premises. Green Mountain blends and distributes coffee to a variety of customers, including cafes, delis, and restaurants, and currently has about 6,700 customer accounts reaching states across the nation. As the company has grown, several beverages have been added to their product line, including signature blends, light and heavy roasts, decaffeinated coffee and teas, and herbal teas. Green Mountain Coffee Roasters, Inc., has been publicly traded since 1993. Green Mountain Coffee has a warehouse and manufacturing plant located in Wilton, Vermont, where it presently employees 250 full-time and part-time workers. The company receives its beans in bulk from a select group of distributors located across the world, with their largest supplier being Columbia Beans Co. Green Mountain Coffee also sells accessories that complement their products, including mugs, thermoses, and coffee containers that they purchase from their supplier, Coffee Lovers, Inc. In addition, Green Mountain purchases paper products such as coffee bags, coffee cups, and stirrers, which they distribute to their customers. Green Mountain's accounting system consists of manual procedures supported by stand-alone PCs located in various departments. Because these computers are not networked they cannot share data digitally, and all interdepartmental communication is through hard-copy documents. Green Mountain is a new audit client for your CPA firm and as manager on the assignment you are examining their internal controls. The revenue cycle is described in the following paragraphs. Sales Order System The sales process begins when a customer sends a customer order to the sales clerk who does a credit check by manually reviewing the hard-copy customer sales history records. From the approved customer order, the sales clerk then manually prepares several hard copies of a sales order. These include a customer copy, a stock release, two file copies, a packing slip, an invoice, and a ledger copy. The invoice, ledger copy, and a file copy are sent to the billing department. The second file copy and the stock release are sent to Sara in the warehouse. The packing slip is sent to the shipping department. The clerk files the approved customer order in the department. The billing department clerk reviews the source documents that she received from sales and adds prices to the invoice. Using the department PC, the clerk then enters the billing information into the computer to record the sale in the sales journal. The invoice is mailed to the customer, the ledger copy is sent to the accounts receivable clerk in the accounting department, and the file copy is filed in the billing department. At the end of the day a journal voucher is printed from the PC and sent to Vic, the general ledger clerk. Sara in the warehouse uses the stock release and file copies to pick the goods from the shelf. She files the file copy in the warehouse. Guided by the information on the stock release copy, she then updates the digital inventory subsidiary ledger from the warehouse PC. Next, she sends the stock release copy, along with the goods, to the shipping department. At the end of the day, Sara prepares a journal voucher from the PC and sends it to the general ledger clerk. The shipping clerk reconciles the stock release copy with the packing slip from sales. The clerk then manually prepares a hard-copy bill of lading and records the shipment into the hard-copy shipping log. The bill of lading, packing slip, and goods are sent to the carrier and the stock release copy is filed in the shipping department. In the accounting department, relevant information taken from the ledger copy (sent from billing) is entered into the computer to update the accounts receivable records. A summary (end of day) is sent to Vic. The ledger copy is then filed in the accounting department. Vic reconciles the accounts receivable summary with the journal vouchers and then updates the digital general ledger from the department PC. All documents are then filed. Cash Receipts System The mail room clerk receives the checks and remittance advices from the customer. He reconciles the checks with the remittance advices and prepares two copies of a remittance list. The checks and a remittance list are then sent to John, in the accounts receivable department. John uses a PC to process the cash receipts, update the cash receipts journal, and prepare a journal voucher and three deposit slips. The journal voucher is sent to Vic, the general ledger clerk. The checks and two deposit slips are sent to the bank to be deposited into Green Mountain Coffee's account. The third deposit slip and the remittance list are filed. The second remittance list and the remittance advices are sent to Mary, another accounts receivable clerk who, using the same PC, updates the accounts receivable subsidiary ledger and prepares an account summary, which is sent to Vic. The remittance list and the remittance advice are then filed. Vic uses the journal voucher and the account summary to update the general ledger. These two documents are then filed.

Required

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. Model your response according to the six categories of physical control activities specified in SAS 78/COSO.

d. Prepare a system flowchart of a redesigned computer-based system that resolves the control weaknesses you identified. Explain your solution