Part I (70%): Jay and June’s Market is a local grocery store in Hoover, Alabama. The market uses a small office network of PCs to document their inventory and accounting transactions.
When goods arrive from the suppliers, the stockroom clerk reviews the packing slips, compares them to the open purchase order file on her PC, and restocks the stockroom shelves if the goods received agree with the purchase orders (don’t worry about showing any exception routines on your flowchart). During this process, she makes updates to the stock records and the open purchase order files via her PC to reflect the new items received. She then makes a photocopy of each packing slip and sends the original to the accounting clerk. She files the copy in the stockroom by date.
The suppliers’ invoices are mailed directly from the supplier to the accounting clerk, who matches them with the packing slips that he received from the storeroom clerk and examines them for correctness (again, don’t worry about showing exception routine for invoice/packing slip discrepancies). He updates the general ledger program stored on his PC to reflect the amounts owed to the suppliers, then he files the matched documents in a temporary file that is organized by due date. As bills come due each week, he removes the matched invoice and packing slip from the temporary file and forwards them to the store manager for payment.
The store manager approves the bills for payment and manually prepares a two-part check for the total amount due to each supplier. He sends the original check to the supplier by mail, and the copy back to the accounting clerk. The accounting clerk uses the check copy to update the general ledger via his PC to reflect the decrease in amounts due to suppliers (i.e., accounts payable). The accounting clerk then prints out a summary of cash disbursements for the day. He files both the summary and all check copies by date.
Required: (a) Prepare a table of entities and activities for the above narrative (see pp. 114- 115 in text for example) (20%)
(b) Using part (a)’s table, prepare a system flowchart. (50%)
Part II (Not related to the narrative in Part I) (30%): Convert the Level 0 logical data flow diagram (DFD) shown below into a narrative (i.e., a description of what is going on in paragraph form). • You should assume that the name of the company is “Jamey’s Apparel”, and the expenditure process is being diagrammed. • Your goal should be to create a narrative from which the following diagram could have been drawn. • All information presented below MUST be included in your description. • Be sure to add “who”, “how” and “where” details to make the narrative flow properly even though they are not distinguishable from the logical DFD.