Attached is a narrative describing a processes in a company. Complete 2 flow charts, Level 0 DFD, and Context DFD for the processes. Only the DFDs are due during Spring Break. The entire 10 points will come from the DFD portion of this assignment. Please use Excel to complete the assignment. You will use the Insert tab and then the Shapes little drop down. The Shapes dropdown (little diamond, square, and circle overlapping) will have an option for FLOWCHART symbols. You will want to use the flowchart symbols when possible as the text will automatically be an option in the symbol. Please try to format your flowcharts nicely. We will only grade the DFD - as the snow day prevents us from covering flowcharting prior to spring break.

Narrative: Crushing Metals, Inc., is a manufacturer of aluminum parts for the healthcare industry. Crushing purchases aluminum and other raw materials from several vendors. The purchasing process at Crushing occurs as follows: When inventory of any raw material seems low, a purchasing agent examines the records to determine the vendor who supplied the last purchase of that raw material. The purchasing agent prepares a three copy purchase order and mails the top copy to the vendor. One copy is filed in the purchasing department, and one copy is forwarded to the inventory control department. Inventory control personnel update the inventory subsidiary ledger and file the purchase order by number in the inventory control files. When the goods arrive at the receiving dock, a receiving report is prepared from information on the packing slip. One copy of the receiving report is filed in the receiving department, and one copy is forwarded to purchasing so that the purchasing department is informed of the receipt of goods. The vendor mails an invoice for the raw materials directly to the accounts payable department. When the invoice is received, accounts payable personnel prepare a cash disbursement voucher to approve payment. The voucher is forwarded to the cash disbursements department. The accounts payable department also updates the accounts payable subsidiary ledgers and files the invoice by invoice number. Upon receiving the cash disbursement voucher, and employee in the cash disbursements department prepares a two-copy check. The top copy of the check is mailed to the vendor, and the second copy is forwarded to the general ledger department. The cash disbursement voucher is stamped "paid" and returned to the accounts payable department. The voucher is filed with the invoice in the accounts payable department. The general ledger department records the check in the general ledger and returns the check copy to the cash disbursements department where it is filed. Your Assignment: Create two document flowcharts to reflect the records and reports used by the processes at Crushing. One flowchart should depict the purchasing processes and the second flowchart should depict the cash disbursements process. Then, create 2 Data Flow diagrams for the processes at Crushing. One DFD should be a Context level diagram and the second DFD should be a Level-0 Diagram.