I dont know how to draw REA model for this assignment
ACCT-361: Assignment #3 - Spring 2012 Business Process Modeling: Prototyping an Event-Driven System (40 points) Give yourself enough time to complete this assignment. I estimate about four hours to complete. Feed My Starving Children Feed My Starving Children (FMSC) is a non-profit organization committed to feeding hungry children around the world. Their approach includes the development of a food mixture that is easy and safe to transport, simple to make with only boiling water and culturally acceptable worldwide. The basic dry food mixture includes rice, high protein soy nuggets, vegetables, vitamins and flavoring. The following describes the company's acquisition/payment business process. Description of the Acquisition/Payment Process The FMSC acquisition/payment process begins when a food production manager reviews inventory records. When it is determined that inventory is needed for production of the food mixture, the manager manually prepares a purchase requisition. A carbon copy of the requisition is filed in the production department numerically. The original purchase requisition is forwarded to the purchasing department. After receiving the requisition, a purchase order clerk inputs the information into the computer. The computer process accesses the vendor and inventory master files and updates the purchase order transaction file. Three copies of the purchase order are subsequently printed. One copy is sent to the vendor. Note that vendors permit back-orders. One copy is filed in the Purchase Order file numerically along with the purchase requisition. The last copy is forwarded to the accounts payable department and filed in the Accounts Payable Pending temporary file numerically. An important part of FMSC operations are the warehouse captains who monitor incoming goods. Warehouse captains are located at the receiving dock. Captains are responsible for receiving, inspecting and recording each delivery for correct items, quantity and quality. When a delivery comes in, a captain reviews the goods and manually creates a receiving report. The captain prints a copy of the related purchase order from the purchase order transaction file and compares the receiving report to the purchase order for quantity or item differences. If there is a difference the captain works with the department manager to resolve the discrepancy. When no differences exists, the captain stamps the original receiving report approved and keys the data into the system to update the inventory master file. The general ledger is automatically updated when changes are made to these records. The approved receiving report and the purchase order print out are sent to the accounts payable department. When the approved receiving report and purchase order are received in the accounts payable department, it is filed in the Accounts Payable Pending file by vendor name with the original copy of the purchase order. When the invoice is received from the supplier, the matching documents are pulled from the Accounts Payable Pending file. The purchase order, receiving report, and invoice are filed in the Open Accounts Payable file by payment date. Vendors allow FMSC to pay by the 20th of each month for all deliveries made during the preceding month. Vendors do not allow partial payments from FMSC. Using the Open Accounts Payable file, a clerk in the cash disbursements department searches for accounts coming due. When payments are due, the clerk removes the purchase orders, receiving reports, and invoices from the file to prepare the checks manually. The checks are used to subsequently update the check register and accounts payable subsidiary ledger electronically. The general ledger is automatically updated. The checks are sent to be signed by the supervisor. A copy of the check is filed with the purchase order, receiving report, and invoice in the Closed Accounts Payable file by vendor name. The supervisor then mails the checks to the suppliers. Because inventory items are perishable, vendors do not accept returns. Required: 1. Conceptual Model: Draw an REA model with cardinalities for the operating events in FMSC's acquisition/payment process. Remember to distinguish between operating events and information events. The REA model does not need to be completed using a computer graphics program - that is, it can be hand-drawn -- but neatness is required. 2. Logical Model: List each database table required, complete with key attributes (primary keys), foreign keys, and non-key attributes. Use proper notation. This part of the requirement needs to be typewritten using word processing software, such as Microsoft Word. It is not completed in Microsoft Access. RECEIVE ORDER COLLECT PAYMENT PACKING TRANSFER STORE PICK UP SALE ASSOCIATE