3.10 (continued)
c. A customer places an online order to purchase merchandise. The order is
approved, filled, and sent to the customer with an invoice.
Context
Customer Order Entry
System
Purchase Order
Invoice
Merchandise
Level 0
Customer
1.0
Receive
Order
2.0
Approve Order
Purchase Order
4.0
Prepare
Invoice
Invoice
Open Orders
3.0
Fill and Ship
Order
Approved
Orders
Shipped Orders
Sent Invoice
Copies
3.10 (continued)
d. An inventory request is received by the purchasing department. The purchasing
department prepares and sends a purchase order to the appropriate vendor.
Context
Inventory
Department
Purchasing
System Vendor
Inventory Request
Purchase Order
Level 0
Inventory
Department
1.0
Record
Purchase
Request
Open Purchase
Requests
2.0
Prepare
Purchase
Order
Approved
Vendor List
Vendor
Inventory Request Purchase Order
Inventory
3.10 (continued)
e. A vendor invoice is received, reviewed, and compared against the appropriate
purchase order, then paid and filed.
Context
Vendor Cash
Disbursements
Invoice
Payment
Level 0
Vendor
1.0
Receive
Invoice
Open
Invoices
2.0
Approve
Invoice
Open
Purchase
Orders
Invoice
3.0
Prepare
Payment
Payment Payment approval
3.10 (continued)
f. A bill of lading for ordered inventory is received from a vendor, recorded,
checked against the appropriate purchase order, and filed.
Context
Vendor Receiving
System
Bill of Lading
3 .11 Prepare a program flowchart to help Melanie program this process.
Start
Input Weight
(W), Height (H)
Body Mass Index (BMI) = W/H^2
3.12
DFD’s
1. Statements are prepared and sent to customers from data contained in
the accounts receivable data store.
B
2. A vendor sends a sales invoice to the accounts payable process.
C
3. The cash receipt process updates the cash receipts data store.
A
FLOWCHARTS
4. A check is manually prepared from data on a vendor invoice.
G
5. The system prepares a check that is mailed to the customer.
I
6. A report is prepared from data stored on magnetic tape.
F
7. Billing data are entered into a system and used to update both the sales
order data base and the customer data base.
D
8. Data from a cancelled paper invoice are used to update the cash
disbursements file.
J
9. The system prepares two copies of a sales order; one copy is sent to the
customer and the other is filed.
H
10. An accounts receivable aging report is prepared from the accounts
receivable master file and the cash receipts master file.
E
3.13 Students are to replicate the flowchart presented in the problem using documentation software
such as Visio, Microsoft Word, Microsoft Excel, etc.
3.14 Students are to replicate the data flow diagram presented in the problem using documentation
software such as Visio, Microsoft Word, Microsoft Excel, etc.
SUGGESTED ANSWERS TO THE CASES
3-1 You are the systems analyst for the Wee Willie Williams Widget Works (also known as Dub
5, which is a shortened version of 5 Ws). Dub 5 produces computer keyboard components.
It has been producing keyboards for more than 20 years and has recently signed an
exclusive 10-year contract to provide the keyboards for all Dell personal computers. As the
systems analyst, you have been assigned the task of developing a level 0 DFD for Dub 5’s
order processing system. You have finished gathering all the information you need to
develop the first-pass DFD and now want to complete the diagram.
Level 0 DFD for Dub 5:
Customer 1.0
Credit
Review
2.0
Enter
Credit file
Order
Approved
orders
Order Rejection
3-1 Level 1 DFD for Dub 5:
1.1
Check Credit
1.2
Check Current
Order against
Credit Limit
1.3
Prepare Credit
Application
Customer
Credit File
Customer
Account
Approved Order
Rejected Order
Rejected Order
Lacking Credit
Approval
Over Credit Limit
Notice
Credit Application
Customer Order
Case 3-1 Dub 5 Business Processing Diagram
Employee
Activities Performed
Order
Processing
Clerk
From Customer No
No
Credit Debt
Yes
No
Yes
Warehouse
Billing
Accounting
Receive
Customer
Order
Customer
not
approved
for credit:
OR order
exceeds
credit limit
Enter
Custome
r Order;
Update
Custome
r File
Sufficie
nt
Inventor
y
Prepare Packing Slip
Notify
customer of
insufficient
inventory
File Invoice
Custome
r
Approve
d for
Credit?
Send customer credit
application, notify
order shipped when
credit approved
Notify customer: order
shipped when payment
received
Ship goods to
customer
Prepare customer invoices;
send copies to customer, order
processing, accounting
Place notice in file:
customer invoice
sent
Update Accounts
Yes