Mason Motors

Mason Motors sells auto parts at five stores in Northern Virginia and through its on-line storefront. The Fairfax store location manages the inventory needs for the on-line business. The following describes the business processes Mason Motors uses for the acquisition of inventory items.

Mason Motors has a purchasing department centrally located at company headquarters in Fairfax, VA. The acquisition/payment process begins when a store manager determines a need for inventory at his/her location. The manager enters the requested items directly into the ERP system to generate a purchase requisition form.

A purchasing clerk at corporate headquarters checks the system for open requests. Based on the systems purchase requisitions, the purchasing clerk prepares each purchase order using the ERP system. A request may need to be split into more than one order as not all vendors supply every item. To obtain volume discounts, the clerk combines all requests for similar items into one purchase order. Each purchase order instructs the vendor to ship the inventory items directly to the appropriate stores. The computer process accesses the vendor and inventory master files and updates the purchase order transaction file. One copy of the purchase order is subsequently printed and forwarded to receiving.

Each store has a receiving dock manned by warehouse workers. When a delivery comes in from a vendor, a warehouse worker inspects the items and manually creates a receiving report. The employee compares each receiving report to the corresponding purchase order for quantity or item differences. If there is a difference, the employee works with a store manager to resolve the discrepancy. The employee subsequently signs the receiving report and purchase order and keys the data into the system to update the receive goods transaction file. The signed receiving report and purchase order are then filed in the department numerically.

Mason Motors has good relationships with some vendors who allow installment payments for all deliveries within the last 60 days. Other vendors will require payment in full for each delivery. All payments are handled by the cashier in the payments department.

The following business rules apply:

• Inventory items can be backordered
• Vendors accept returns from the warehouse worker
• Inventory items are not unique

Required:

Cover page with full name, class and Assignment title, a page with the REA model not hand drawn, a page with the logical model not hand drawn, stapled. Professional presentation counts.

1. Conceptual Model: Draw an REA model with cardinalities for the operating events, resources and agents in the Mason Motors inventory acquisition/payment process. The REA cannot be hand-drawn , neatness is required.

2. Logical Model: Using the format below, list each database table required, complete with key attributes (primary keys), foreign keys, and non-key attributes. Use proper notation as described in class and noted below. typewritten.

Table Name	Primary Key	[Foreign Key]	Non-Key Attribute