Document flowchart for the order processing system

Assignment Help Database Management System
Reference no: EM13490816

Queensland Fruit Growers distribute fresh fruit juices throughout Australia. The systems and procedures in the company have evolved over many years. A recent Performance Audit has highlighted deficiencies in the company systems and procedures. The Board of Directors have employed a consultant to document the current systems starting with the order processing system.
The customer orders, which are all credit sales, arrive by email or phone and in the processing of an order several other documents are created.
The documents created are:
• A packing slip which is used by the warehouse to fill the order.
• A customer invoice which is sent after the fruit juice has been shipped.
• When the order is not accepted an order rejection note is forwarded to the customer.
• A receivable notice, which is a copy of the customer invoice, is forwarded to the accounting department so that the accounts receivable records can be updated.

The consultant reviewed the facts he had collected and prepared the following narrative summary:
When an order is received by the order processing clerk they check the customer's credit file to confirm credit approval and to ensure that the order amount is within the agreed credit limit. If neither of these conditions is met then the order is forwarded to the credit control department. If the order meets both conditions the order processing clerk enters the details into the system using a standard order form. This information is used to update the customer file which contains name, address and other data. The form is then put in the open order file.
When the credit department receives a rejected order the credit clerk determines why the order has been rejected. If the credit limit has been exceeded the customer is informed that their credit limit has been exceeded and that the fruit juice can only be delivered after a payment is received to bring the account back into agreed limits. If the customer does not have an agreed credit limit then a credit application is forwarded to the customer with a notification that the produce will be delivered as soon as credit is approved.
When an order is received the system checks the inventory levels to determine if the fruit juice is available. If the fruit juice is available a packing slip is prepared and sent to the warehouse.
When notification of despatch of fruit juice is received from the warehouse, an invoice is prepared. One copy is filed in the order processing department and a second copy is forwarded to the customer and a third copy is forwarded to the accounting department to update the accounts receivable. A note is placed in the customer file to confirm that an invoice has been sent.

• Requirement 1:
o From the information presented in the case above complete the following
- document flowchart for the order processing system, and
- data flow diagram DFD at Level 0 for the order processing system.
• Requirement 2:
o Identify any deficiencies in system (if any) and the information needs for effective management of the order processing system in particular and the revenue cycle in general.
• Requirement 3:
o Make recommendations and suggestions to management to make the system more efficient and/or make improvements you see as appropriate. In doing so, you should consider adopting recent (since 2008) advances in information systems in one or two (but no more than two) of the following technologies
- EDI/EDNIT
- EFT/FEDI
- RFID
- ERP
In making recommendations, you need to justify them using a literature search that must include sources outside your set text and readings such as journal articles, business press, web sites making sure you cite all references used.
• Requirement 4:
o Highlight to management the complementing features of narrative descriptions and diagramming tools.

Reference no: EM13490816

Questions Cloud

How long does it take him to catch his opponent : A hockey player is standing on his skates on a frozen pond when an opposing player, moving with a uniform speed of 4.0 m/s, How long does it take him to catch his opponent
Discuss the changes made in sfas 158 and sfas 132 : corporate income tax is an expense, not a distribution of the profits to the government - company should report changes in the deferred tax asset and liability accounts as footnotes in 10-k
Holmes institute faculty of higher education : You are required to read the following statement issued by ICAA (Institute of Chartered Accountants in Australia and provide an essay of between 1,000-1,500 words (being the minimum and maximum). It should be properly referenced and must be primar..
What is the period of swing from the watch : Johnny Thunder is swinging a watch from a 20.0 cm chain. What is the period of swing from the watch
Document flowchart for the order processing system : document flowchart for the order processing system, and data flow diagram DFD at Level 0 for the order processing system.
How accounting can be used in a more transformative capacity : Identify and discuss the arguments presented by Chwastiak (1999) in her critique of the assumptions of positive accounting theory, and in her vision for a more transformative role of accounting.
List and discuss briefly three standards of accountability : Why will there frequently be a difference between the budgeted cost of material in the material purchases budget and the budgeted cash disbursement for material in the cash budget?
How far west of her starting point is she : A girl walks 26 meters at an angle of 39° west of south. How far west of her starting point is she
Traditional system to an activity based cost system : Will the coming years EVA be greater than, less than, or equal to the current year's EVA and effect of changing to the ABC systeman increase in EVA, a decrease in EVA, or neither? Why?

Reviews

Write a Review

Database Management System Questions & Answers

  Write select statement that returns two columns

Write a SELECT statement that returns two columns: VendorName and PaymentSum, where PaymentSum is the sum of the PaymentTotal column.

  Write down a 350-word summary explaining two of the most

write a 350-word summary describing two of the most popular database vendors in the marketplace. answer the following

  Create a corresponding xmlschema file

A simple database with a single table contains data concerning car registration. The table contains four fields that store data relating to registration number (unique), make of car, year of manufacture and car colour

  Create link list in adt to maintain employee information

Create a link list in ADT c to maintain employee information like name,empid,basic salary and address.1.add employee info to the list if the empid is valid.

  Requirementscreate a database from scratch that contains at

requirementscreate a database from scratch that contains at a minimum the elements listed below. the type of database

  Imagine that you have been assigned as a project manager to

imagine that you have been assigned as a project manager to manage your companys e-commerce website where customers can

  Question 1 consider the relational schemapartpart-id name

question 1. consider the relational schemapartpart-id name costsubpartpart-id subpart-id counta tuple p1 p2 3 in the

  I describe the application that you would like to design

i. describe the application that you would like to design. this should include the purpose of the application and an

  Produce an entity-relationship diagram

Produce an Entity-Relationship diagram which represents the above activities of the insurance company. Indicate the names and degrees of all the relationships. Give appropriate attributes for each entity shown, and identify the primary key for eac..

  Describe the benefits and present trends of data

your database has been a hit. you have been called back to the customers headquarters and they want a detailed report

  Create a database design - relational data model

Create a database design specification Enhanced Entity Relationship Diagram (EERD) and Relational Data Model from the given business description - Database Management System

  Create class diagram

Draw a UML class diagram that models the aspects of job agencies that are described below.

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