Company Background:

Jameson Medical Supply is a privately owned distributor of medical supplies and hardgoods to the nursing home and assisted care facility industry. The company was established in 1993 by three brothers in the lowcountry of South Carolina. The companys operating revenue is approximately $3.5 million from a single distribution center and a fleet of ten trucks. Their customer base of approximately 180 facilities range from Murrells Inlet, SC to Brunswick, GA.

Purchase to Pay Processes:

Goods and supplies are ordered using a purchase order (PO) by the procurement manager based on standard reorder points for stock inventory items and special orders for custom ordered items. The purchasing manager has PO level authority for up to $10,000. Any POs over $10,000 require the approval of the owner responsible for oversight of purchasing and inventory control.

The goods are received by the receiving department, which consists of two employees. The employees use a scanner to scan the purchase order number from a three-ring binder containing bar-coded POs with the line item also barcoded, but without an order quantity. The employees inspect and count the goods, using the bar-coded receiver document to process the orders. Individual bar-code labels are printed and applied to larger items, whereas a single label is printed and attached to boxes, and cartons with larger quantities of small items. Any damaged goods are isolated for return to the vendor. They typically return only the damaged goods to the vendor with a return-to-vendor document.

The warehousing group receives the goods that the receiving group processed and puts them away according to the standard aisle and bin for that item. If a bin is full, then an overflow bin is used to store the goods until the bin has available space. The warehouse is cycle counted such that each month 1/12th of the aisles are counted, except for certain high value items that are counted every month.

Accounts Payable receives the vendor invoices and enters them in the system against the POs for matching. Any line variances greater than $1 or invoice variances greater than $5 are reviewed and approved by the accounting manager. Payment batches are created every two weeks by the accounts payable clerk. All invoices due before the next two-week cycle and any with payment discounts are selected. A pre-check register is created, and the accounting manager reviews. Any payment adjustments or drops are made by the accounting manager. The accounts payable clerk gets the pre- printed check stock from the controller. The accounts payable clerk prints the checks and gives them to the controller for review and signature, comparing the checks to the pre-check register. The signed checks are compared to the pre-check register by the owner overseeing accounting, then mailed by the administrative assistant.

3. Create a List of Tables and Attributes, including any relationship tables required to bridge any many-to-many classes identified in the UML model. Identify any primary and foreign keys. Each table requires at least five fields.