Create a data flow diagram of the current system

Assignment Help Managerial Accounting
Reference no: EM132418561

GREEN PRODUCTS GARDEN SUPPLY (STAND-ALONE PC-BASED ACCOUNTING SYSTEM)

Green Products Garden 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. The 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.

The 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, the company 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 the company's procedures and internal controls.

The following is a description of the company'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  eceives 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 bill of lading 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. 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 accounts receivable summary to general ledger and files it in the general ledger department.

Required

Question 1: Create a data flow diagram of the current system.

Question 2: Analyze the physical internal control weaknesses in the system.

Reference no: EM132418561

Questions Cloud

How did managers explain the importance of given kpis : Application Analysis: Total Rewards and Compensation, What are some key performance indicators that are used by organizations in which you have been employed?
Powerpoint presentation - Project to eradicate an ism : Powerpoint presentation-Each Slide Represents Information You'll Need For Your Final Project Presentation and the "ism" you set out to help eradicate
What is the margin of safety in dollars : The breakeven sales in units is 2,000 and budgeted sales in units is 4,200. What is the margin of safety in dollars?
Is team supervision valid approach in world of corrections : Do you feel that the Model Case Management System established in 1981 by the National Institute of Corrections is effective based upon today's offenders?
Create a data flow diagram of the current system : Create a data flow diagram of the current system. Analyze the physical internal control weaknesses in the system.
Explain decision using the ethical system : Your first big case is a multiple murder. As the defense attorney, you have come to the realization that your client really did break into a couple's home.
Describe ethical models to the potential problem of judges : Apply ethical models to the potential problem of judges disciplining attorneys. Do these models support the continued paradigm of judges disciplining lawyers?
CSE1OOF Object-Oriented Programming Fundamentals Assignment : CSE1OOF Object-Oriented Programming Fundamentals Assignment Help and Solution, La Trobe University - Assessment Writing Service - writing a program that totals
How effective are us fusion centers : In the wake of the terrorist attacks in September 2001, the 9/11 Commission recommended that the U.S. Intelligence Community (USIC) find a way to improve.

Reviews

Write a Review

Managerial Accounting Questions & Answers

  Manage budgets and financial plans

Explain the budgeting process and its importance to a business, identifying the components of different budgets, forecast estimates for inclusion in the budgets.

  Prepare a retained earnings statement

Prepare a retained earnings statement for the year and Prepare a stockholders' equity section of given case.

  Prepare a master budget for the three-month period

Prepare a master budget for the three-month period.

  Construct the companys direct labor budget

Construct the company's direct labor budget for the upcoming fiscal year, assuming that the direct labor workforce is adjusted each quarter to match the number of hours required to produce the forecasted number of units produced.

  Evaluate the predetermined overhead rate

Evaluate the Predetermined Overhead Rate

  Determine the company''s bid

Determine the company's bid if activity-based costing is used and the bid is based upon full manufacturing cost plus 30 percent.

  Compute the pool rates for the different activities

Complete the schedule to compute the pool rates for the different activities.

  Prepare Company financial statements

Prepare Company financial statements

  Prepare an analysis of terracycles

This individual assignment is based on the TerraCycle Inc.

  Discuss the ethical issues

Discuss the ethical issues

  Political resources in emerging markets

Calculate the GDP in Income Approach  and Expenditure Approach

  Management accounting - ehsan electronics company

A new plant accountant suggested that the company may be able to assign support costs to products more accurately by using an activity based costing system that relies on a separate rate for each manufacturing activity that causes support costs.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd