Compulsive Accessories, Inc. (Billing Process) Compulsive Accessories manufactures and sells speakers, headphones, and related items to retail stores. Completed orders (goods and attached sales order) are received in the shipping department from the factory floor. The shipping clerk keys the sales order number into the computer in the shipping department. The computer accesses the sales order on the sales order master data and displays the open sales order. After determining that the correct sales order has been displayed, the shipping clerk keys in the items and quantities being shipped. The clerk reviews the shipment data and, if correct, accepts the input. (Note: the remainder of the shipment process is beyond the scope of this case narrative.) After the shipment data has been accepted, the computer updates the sales order master data to reflect the shipment, creates and record an invoice on the accounts receivable master data, and prints an invoice, in 3 parts, on the printer in the billing office. A billing clerk signs the invoice, mails copies 1 and 2 to the customer, and files copy 3 by customer name. 1. Prepare a table of entities and activities. 2. Draw a physical data flow diagram 3. Draw a systems flowchart, annotated with both present and missing controls 4. Prepare a completed control matrix. Make sure to assign controls to specific goals.   5. Provide a 1-page analysis of the case. This analysis should include a conclusion on whether the process, as described, is efficient and effective. Use the results of steps 1-4 to support your conclusions.

Oracle 12c: SQL
3rd Edition
ISBN:9781305251038
Author:Joan Casteel
Publisher:Joan Casteel
Chapter10: Selected Single-row Functions
Section: Chapter Questions
Problem 3HOA
icon
Related questions
Question

Compulsive Accessories, Inc. (Billing Process)

Compulsive Accessories manufactures and sells speakers, headphones, and related items to retail stores. Completed orders (goods and attached sales order) are received in the shipping department from the factory floor. The shipping clerk keys the sales order number into the computer in the shipping department. The computer accesses the sales order on the sales order master data and displays the open sales order. After determining that the correct sales order has been displayed, the shipping clerk keys in the items and quantities being shipped. The clerk reviews the shipment data and, if correct, accepts the input. (Note: the remainder of the shipment process is beyond the scope of this case narrative.)

After the shipment data has been accepted, the computer updates the sales order master data to reflect the shipment, creates and record an invoice on the accounts receivable master data, and prints an invoice, in 3 parts, on the printer in the billing office. A billing clerk signs the invoice, mails copies 1 and 2 to the customer, and files copy 3 by customer name.

1. Prepare a table of entities and activities.

2. Draw a physical data flow diagram

3. Draw a systems flowchart, annotated with both present and missing controls

4. Prepare a completed control matrix. Make sure to assign controls to specific goals.  

5. Provide a 1-page analysis of the case. This analysis should include a conclusion on whether the process, as described, is efficient and effective. Use the results of steps 1-4 to support your conclusions.

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 3 images

Blurred answer
Knowledge Booster
Keywords
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Oracle 12c: SQL
Oracle 12c: SQL
Computer Science
ISBN:
9781305251038
Author:
Joan Casteel
Publisher:
Cengage Learning
Enhanced Discovering Computers 2017 (Shelly Cashm…
Enhanced Discovering Computers 2017 (Shelly Cashm…
Computer Science
ISBN:
9781305657458
Author:
Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell
Publisher:
Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage