< < Background Information ABC Co. sells various furniture purchased from manufacturers to retailers across Canada. Purchases When employees from various departments need to purchase something, they fill in a purchase requisition form and send it to their supervisors for approval. Approved purchase requisition forms are sent to the purchasing department. If an approved vendor exists on the approved vendors list, the purchasing clerk will initiate a purchase order to that vendor, otherwise, the purchasing clerk will search for a vendor for goods or services requested. The purchasing clerk runs an inventory report everyday to identify the items that should be purchased based on the reorder point of each inventory item. ABC Co. creates a purchase order for each purchase of inventory items, office supplies, or services. A new purchase order is required for back-order items, so that one receiving report is created for each purchase order and one purchase order only. All the vendors are required to create one invoice for each purchase order after goods are delivered and received in good condition. Accounts Payable The accounts payable clerk prepares checks for payments to various vendors. All payments need to be approved by the Finance Manager before a cheque is prepared. The manager examines the company's financials and decide on whether a vendor's invoice should be paid. Some invoices are paid within their discount periods so that the company can take advantage of the early payment discounts. Some vendors are paid on monthly basis. If an invoice is received from these vendors after the checks are prepared, ABC will hold it until the end of the following month before sending payment. If multiple purchases from the same vendor were made, the accounts payable clerk will combine payments. However, each purchase invoice is either unpaid or paid in full. Once an invoice is paid, the accounts payable clerk stamps the invoice with the check number, the check amount, and the date paid. After the check is prepared and sent out to the vendor, they package all of the source documents and file them. Some cash disbursements involve parties other than vendors (e.g. employee reimbursements). Sales Each type of furniture inventory is given a unique identification number and a suggested selling price. Each sale includes one or more pieces of furniture and can be paid for in one of the following four ways: (1) immediately in cash; (2) on the invoice due date: (3) over the period of six months; (4) at the end of the following month. When a salesperson is hired, he or she is immediately assigned to a group of customers. No more than one salesperson participates in making a particular sale. A salesperson may negotiate with a customer and agree on a selling price that is lower than that furniture's suggested selling price, especially if the customer is a high-volume customer or if that furniture is a slow seller (ie., it has been in stock for a long time). Salesperson commission rate is determined per contractual arrangement with each salesperson and, for a particular salesperson, it is the same percentage rate no matter what items he or she sells. Salespersons" responsibilities include determining whether credit card sales are approved, approving credit sales, and approving sales returns. Cash Receipts Although the vast majority of cash receipts come from customers (any particular cash receipt would be from only one customer) for sales, some cash receipts come from other sources (e.g. interests received from banks). Every cash receipt is processed by exactly one of ABC's several cashiers. At the end of each day, one of the cashiers deposits the cash collected during the day into one of the company's bank accounts. Other Information about furniture, employees, and customers often needs to be entered into the database before any transactions involving them have occurred. Ignore purchase discounts and HST. Phase I Instructions Phase I Instructions Based on the information given above, prepare an integrated UML class diagram for ABC Co. with a MS Office application (e.g. PowerPoint, Word etc.). Use the REA model to help you determine the entities. Assign each of the following attributes to the appropriate class and include them in your UML class diagram: Sale_Inv_Num Reorder Point AR_Balance Cust_Address Vendor Num Cust Postal Code Inventory Num Empl First Name Cust City Empl DOB PO Date Bank Type Vendor Address Actual Sale Price PO Num Bank Balance Amount Applied Empl SIN Sale Date Actual Purchase Qty Inventory Category Sale Amount Commission Rate Bank Name Qty On Hand Bank Acct Num Cust Num PO_Amount Bank Location Cust Name Purchase Description Item Unit Cost Ven Name CR Date Empl Position CD_Date Item Description Suggested Selling Price Ven City CR_Amount CD_Amount Actual Sale Qty Cust_Province Empl Num Empl Last Name Vendor Province CD Num CR_Num AP Balance Actual Purchase Price Submission: Upload your UML class diagram Make sure to include the following in your UML class diagram: 1. Classes 2. Associations 3. Multiplicities: ask the following questions to help you determine the multiplicity for Class A Minimum: for each instance of Class A, what is the minimum number of times it must be related to Class B Maximum: for each instance of Class A, what is the maximum number of times it may be related to Class B 4. Attributes: You may present the attributes in one of the following ways: a. Attach the attributes to the corresponding class in your UML class diagram b. List the attributes for each class in a separate table and submit it together with your UML class diagram c. Create a list of schemas for all the classes and submit it together with your UML class diagram Notes: CD: cash disbursements CR: cash receipts Empl: employee Cust: customer Background Information ABC Co. sells various furniture purchased from manufacturers to retailers across Canada. Purchases When employees from various departments need to purchase something, they fill in a purchase requisition form and send it to their supervisors for approval. Approved purchase requisition forms are sent to the purchasing department. If an approved vendor exists on the approved vendors list, the purchasing clerk will initiate a purchase order to that vendor; otherwise, the purchasing clerk will search for a vendor for goods or services requested. The purchasing clerk runs an inventory report everyday to identify the items that should be purchased based on the reorder point of each inventory item. ABC Co. creates a purchase order for each purchase of inventory items, office supplies, or services. A new purchase order is required for back-order items, so that one receiving report is created for each purchase order and one purchase order only. All the vendors are required to create one invoice for each purchase order after goods are delivered and received in good condition. Accounts Payable The accounts payable clerk prepares checks for payments to various vendors. All payments need to be approved by the Finance Manager before a cheque is prepared. The manager examines the company's financials and decide on whether a vendor's invoice should be paid. Some invoices are paid within their discount periods so that the company can take advantage of the early payment discounts. Some vendors are paid on monthly basis. If an invoice is received from these vendors after the checks are prepared, ABC will hold it until the end of the following month before sending payment. If multiple purchases from the same vendor were made, the accounts payable clerk will combine payments. However, each purchase invoice is either unpaid or paid in full. Once an invoice is paid, the accounts payable clerk stamps the invoice with the check number, the check amount, and the date paid. After the check is prepared and sent out to the vendor, they package all of the source documents and file them. Some cash disbursements involve parties other than vendors (e.g. employee reimbursements). Sales Each type of furniture inventory is given a unique identification number and a suggested selling price. Each sale includes one or more pieces of furniture and can be paid for in one of the following four ways: (1) immediately in cash; (2) on the invoice due date; (3) over the period of six months; (4) at the end of the following month. When a salesperson is hired, he or she is immediately assigned to a group of customers. No more than one salesperson participates in making a particular sale. A salesperson may negotiate with a customer and agree on a selling price that is lower than that furniture's suggested selling price, especially if the customer is a high-volume customer or if that furniture is a slow seller (i.e., it has been in stock for a long time). Salesperson commission rate is determined per contractual arrangement with each salesperson and, for a particular salesperson, it is the same percentage rate no matter what items he or she sells. Salespersons responsibilities include determining whether credit card sales are approved, approving credit sales, and approving sales returns. Cash Receipts Although the vast majority of cash receipts come from customers (any particular cash receipt would be from only one customer) for sales, some cash receipts come from other sources (e.g. interests received from banks). Every cash receipt is processed by exactly one of ABC's several cashiers. At the end of each day, one of the cashiers deposits the cash collected during the day into one of the company's bank accounts. Other Information about furniture, employees, and customers often needs to be entered into the database before any transactions involving them have occurred. Ignore purchase discounts and HST. A Phase I Instructions Phase I Instructions Based on the information given above, prepare an integrated UML class diagram for ABC Co. with a MS Office application (e.g. PowerPoint, Word etc.). Use the REA model to help you determine the entities. Assign each of the following attributes to the appropriate class and include them in your UML class diagram: Sale_Inv_Num Reorder_Point AR_Balance Cust_Address Vendor Num Cust Postal Code Inventory Num Empl_First Name Cust City Empl_DOB PO_Date Bank Type Vendor Address Actual_Sale_Price PO_Num Bank Balance Amount Applied Empl SIN Sale_Date Actual_Purchase_Qty Inventory Category Sale Amount Commission Rate Bank Name Qty On Hand Bank Acct Num Cust_Num PO_Amount Bank Location Cust_Name Purchase_Description Item Unit Cost Ven_Name CR Date Empl Position CD_Date Item Description Suggested Selling Price Ven City CR_Amount CD_Amount Actual Sale Qty Cust Province Empl Last Name Vendor Province CD Num CR_Num AP Balance Empl Num Actual Purchase Price Submission: Upload your UML class diagram to the "Term Project Phase I" under the "Assignments" module on Sakai by 11:59 p.m on Sunday, November 13, 2022. Make sure to include the following in your UML class diagram: 1. Classes 2. Associations 3. Multiplicities: ask the following questions to help you determine the multiplicity for Class A Minimum: for each instance of Class A, what is the minimum number of times it must be related to Class B Maximum: for each instance of Class A, what is the maximum number of times it may be related to Class B 4. Attributes: You may present the attributes in one of the following ways: a. Attach the attributes to the corresponding class in your UML class diagram b. List the attributes for each class in a separate table and submit it together with your UML class diagram c. Create a list of schemas for all the classes and submit it together with your UML class diagram Notes: CD: cash disbursements CR: cash receipts Empl: employee Cust: customer