REA Process Modeling Question: Repair Part Ordering System Spurgeon Tire and Auto Repair LLC operate thirty auto repair facilities (locations) in Iowa City, Coralville, and other cities in Iowa and Illinois. Spurgeon uses one automated system that is shared across all locations. Their repair part ordering process works as follows. Commonly used repair parts are purchased on a regular basis (minimum QOH level is established) to keep them in stock at this minimum baseline level. Repair parts that are infrequently used are ordered as needed. Technicians working on a vehicle often need to order repair parts that are not kept in stock. To do so, the Technician enters a purchase requisition on the shop floor computer requesting the part(s) and the quantities necessary. Each line item on the requisition also specifies the date needed by. The technician can specify a vendor to order the part(s) from although this is not required. A purchasing agent reviews purchase requisitions throughout the day that have been submitted to the system. Most requisitions are converted into purchase orders by an agent but for various reasons some are not. Often times, requisitions need to be split across multiple orders and vendors because all of the parts on the requisition cannot be ordered from the same vendor. Often times, multiple requisitions can be combined into one order because multiple requisitions would use the same single vendor. Repair parts can be purchased from any approved vendor in the system that happens to stock the part. Purchasing agents will call approved vendors and negotiate a purchase price for each repair part on the order. The system can also automatically generate purchase orders for common repair parts that fall below the minimum required QOH level. These automatic orders do not require a purchase requisition. Many different parts can be ordered on one automatically created PO although they must be from the same vendor. Automatic orders are automatically assigned a purchasing agent by the system and the order must approved by that purchasing agent prior to being submitted to the vendor. The order is also automatically assigned a Vendor by the system. Purchasing agents can alter the initial items and quantities ordered as necessary and can also assign the order to a different vendor. Purchasing agents will call the vendor and negotiate a purchase price for each repair part on the order. The system records the order quantity, purchase price, and date needed for each line item on the order. Occasionally, extra common repair parts are needed before automatic orders are created. In this case, the purchasing agent can manually enter purchase orders in the system. Upon receipt of parts at the receiving dock, receiving clerks inspect all packages for signs of physical damage. Any packages that display signs of damage are further inspected and if the condition of the contents is suspect, the package is returned to the vendor in its entirety. If the package is in suitable condition, the receiving clerk creates a new receiving report. Each receiving report must be matched against an open PO. Since some POs have line items with different required delivery dates, a purchase order can be received against many times but each receiving report will be for one order. The receiving clerk counts the items in the delivery and enters the quantities into the System. Once the receiving report is completed, the receiving clerk transfers the parts inventory for stocking in the appropriate bins. The system does not require vendor invoices for payments to vendors. Each evening, the system retrieves all receiving report quantity details. It then matches on the corresponding PO quantity and price details and calculates a total amount due for each receiving report and oks it for payment. Each morning, one of Spurgeons cashiers issues one check for payment in full for the items on a receipt of goods. Often, if multiple purchases have been made from the same vendor within the same day, Spurgeon pays for those purchases with just one check. Spurgeon is allowed to make installment payments to certain vendors. There are some cash accounts from which checks are never written. Information concerning employees and resources is put into the database as soon as it is known without waiting for any transactions to take place. Data Attributes Inventory Item # Inventory QOH Inventory Min QOH Cash Disbursement # Check # Check $ Amount $ Amount Applied to a Goods Receipt Quantity Requested Quantity Ordered Unit purchase price for an item on a PO Required Delivery Date for an item on a PO PO# Vendor Current AP balance Quantity Received for an item Total $ amount for a Receipt Receiving Report # Design proper tables, and REA Process Model with correct entities, relationships, and cardinalities.