Required information Chapter 08, Integrated Project 2: Y Not Flowers [The following information applies to the questions displayed below.] Background Forrest runs Y Not Flowers, Inc. (YNF), a wholesale flower distributor with stores in several major metropolitan areas of the U.S. He is considering expanding his business, but he thinks his current accounting and financial systems are restricting that expansion. He also worries that YNF is not adequately prepared to face expected business risks. He has come to you for assistance. Instructions Your supervisor met with Forrest and discussed his requirements in detail. At that meeting, they agreed on the following deliverables for your project. 1. Document process activity using BPMN. After gaining an understanding of YNF's business processes, you will document current processes using business process modeling notation (BPMN). This involves documenting at least five current business processes. These diagrams will serve multiple purposes. YNF expects to use them to train new employees. Plus, they will provide information about potential improvements to those processes by the efficient use of information technology. Additionally, they will also highlight areas where YNF is exposed to unnecessary risks in his business. 2. Prepare an integrated data model using UML class diagrams and the REA framework. This data model will serve as the blueprint for YNF's prototype database that you will also develop. Also, prepare a corresponding table listing for recommendations for changes in field names. 3. Prepare a prototype database for YNF. Forrest has agreed to provide financial data from his business for the 1st quarter of his fiscal year. That data will be in Excel format. You will move the data into Access, structure it appropriately, and set relationships consistent with your data model. Make changes as necessary in file structures to implement efficient tables and eliminate duplication. 4. Prepare financial reports using your database. You will prepare queries as necessary to provide the following reports and management information: a. YNF income statement for the 1st quarter. b. YNF balance sheet as of the end of the 1st quarter. C. Income statements for each YNF stores for the 1st quarter. d. Other performance measures that you believe YNF should adopt. 5. Evaluate the financial performance of YNF for the 1st quarter. Use your Access queries to also prepare formal financial statements and compute appropriate ratios to evaluate performance against the industry and past performance. Clearly explain what those ratios mean for Mr. Z's business. 6. Assess the business case for use of information technology in the business. Y Not Flowers wants to move to a cloud-based accounting system, such as Netsuite or QuickBooks Online. Your assessment should identify the costs of the change in technology, while also specifying which business processes would change and how they would change in as much detail as possible. 7. Recommend changes to YNF business processes to make it more effective and efficient. Project Resources You will need to make use of the following files as you work through the project: Summary of Y Not Flowers interviews Excel spreadsheet of Y Not Flowers' current data . List of modeling software List of project management software Requirements Complete the Y Not Flowers project using the instructions and resources listed above. For your Connect assignment, Sections 1 and 2 should be attempted after you have completed Project Deliverable 2 listed above. Section 3 should be attempted after you have completed Project Deliverable 3. Section 2 Section 2 Required: Review the Excel data, prepare the UML class diagram (REA) for Y Not Flowers and then choose the correct fields to complete the Y Not Flowers table listing below: Resources Cash = Flower inventory = Stores = account# (PK), bank, description, balance Jan 01, 2022 Inventory# (PK), flower name, , unit, expected cost store# (PK), phone, address, state, zip, original purchase price, acquired year, life, annual dep vehicle identification number (VIN) (PK), acquired year, make, mileage Jan 01, 2022, original cost, useful life, estimated value end of life, store# (FK) Trucks = 3 Events Cash disbursements to growers = Cash receipts = (PK), check date, grower# (FK), cash disbursement emp# (FK), account# (FK), check amount, (FK) receipt# (PK), customer# (FK), receipt date, cash receipt emp# (FK), (FK), account# (FK), (PK), order date, customer# (FK), order emp# (FK), truck vin (FK), cash receipt# (FK), (FK) pay to emp# (FK), account# (FK), payroll Orders and sales = Payroll = |(PK), Payroll = Purchases of flowers = (PK), , pay to emp# (FK), account# (FK), payroll emp# (FK), timecard# (FK), store# (FK), gross pay, employee FICA, employer FICA, employee Medicare (mc) contribution, employer Medicare (mc) contribution, federal (fed) tax withholding (wh), state tax withholding (wh), net pay to employee purchase# (PK), purchase date, grower# (FK), purchasing emp# (FK), truck VIN (FK), store# (FK), PO# (PK), purchase date, vendor# (FK), ordering emp# (FK), expense amount, reason, store# (FK), notes, check#, check date, cash disbursement emp# (FK), (FK) (PK), timecard date, regular time hours, overtime hours, emp# (FK), supervisor emp# (FK), store# (FK) Purchases of miscellaneous = Timecards = Agents Customers = customer# (PK), name, contact, street, city, state, zip, employee# (PK), social security number, Last Name, first name, wage rate per hour, Employees Growers = grower# (PK), name, phone number, city, state, store# (FK) vendor# (PK), name, address, city, state, zip, phone, fax, email, website Vendors miscellaneous = Linking Tables Orders and sales items = (PK), purchase# (FK), quantity (qty) ordered, quantity (qty) sold, sale price D. mohanaa lawama itama - nurobanti Inventamtt (DV Antitu lat nurobonnd nurobonenrinn Agents Customers = customer# (PK), name, contact, street, city, state, zip, employee# (PK), social security number, Last Name, first name, wage rate per hour, Employees Growers = grower# (PK), name, phone number, city, state, store# (FK) vendor# (PK), name, address, city, state, zip, phone, fax, email, website Vendors miscellaneous = Linking Tables Orders and sales items = (PK), purchase# (FK), quantity (qty) ordered, quantity (qty) sold, sale price purchase# + Inventory# (PK), Purchases of flowers items = quantity (qty) purchased, purchase price Required information Chapter 08, Integrated Project 2: Y Not Flowers [The following information applies to the questions displayed below.] Background Forrest runs Y Not Flowers, Inc. (YNF), a wholesale flower distributor with stores in several major metropolitan areas of the U.S. He is considering expanding his business, but he thinks his current accounting and financial systems are restricting that expansion. He also worries that YNF is not adequately prepared to face expected business risks. He has come to you for assistance. Instructions Your supervisor met with Forrest and discussed his requirements in detail. At that meeting, they agreed on the following deliverables for your project. 1. Document process activity using BPMN. After gaining an understanding of YNF's business processes, you will document current processes using business process modeling notation (BPMN). This involves documenting at least five current business processes. These diagrams will serve multiple purposes. YNF expects to use them to train new employees. Plus, they will provide information about potential improvements to those processes by the efficient use of information technology. Additionally, they will also highlight areas where YNF is exposed to unnecessary risks in his business. 2. Prepare an integrated data model using UML class diagrams and the REA framework. This data model will serve as the blueprint for YNF's prototype database that you will also develop. Also, prepare a corresponding table listing for recommendations for changes in field names. 3. Prepare a prototype database for YNF. Forrest has agreed to provide financial data from his business for the 1st quarter of his fiscal year. That data will be in Excel format. You will move the data into Access, structure it appropriately, and set relationships consistent with your data model. Make changes as necessary in file structures to implement efficient tables and eliminate duplication. 4. Prepare financial reports using your database. You will prepare queries as necessary to provide the following reports and management information: a. YNF income statement for the 1st quarter. b. YNF balance sheet as of the end of the 1st quarter. C. Income statements for each YNF stores for the 1st quarter. d. Other performance measures that you believe YNF should adopt. 5. Evaluate the financial performance of YNF for the 1st quarter. Use your Access queries to also prepare formal financial statements and compute appropriate ratios to evaluate performance against the industry and past performance. Clearly explain what those ratios mean for Mr. Z's business. 6. Assess the business case for use of information technology in the business. Y Not Flowers wants to move to a cloud-based accounting system, such as Netsuite or QuickBooks Online. Your assessment should identify the costs of the change in technology, while also specifying which business processes would change and how they would change in as much detail as possible. 7. Recommend changes to YNF business processes to make it more effective and efficient. Project Resources You will need to make use of the following files as you work through the project: Summary of Y Not Flowers interviews Excel spreadsheet of Y Not Flowers' current data . List of modeling software List of project management software Requirements Complete the Y Not Flowers project using the instructions and resources listed above. For your Connect assignment, Sections 1 and 2 should be attempted after you have completed Project Deliverable 2 listed above. Section 3 should be attempted after you have completed Project Deliverable 3. Section 2 Section 2 Required: Review the Excel data, prepare the UML class diagram (REA) for Y Not Flowers and then choose the correct fields to complete the Y Not Flowers table listing below: Resources Cash = Flower inventory = Stores = account# (PK), bank, description, balance Jan 01, 2022 Inventory# (PK), flower name, , unit, expected cost store# (PK), phone, address, state, zip, original purchase price, acquired year, life, annual dep vehicle identification number (VIN) (PK), acquired year, make, mileage Jan 01, 2022, original cost, useful life, estimated value end of life, store# (FK) Trucks = 3 Events Cash disbursements to growers = Cash receipts = (PK), check date, grower# (FK), cash disbursement emp# (FK), account# (FK), check amount, (FK) receipt# (PK), customer# (FK), receipt date, cash receipt emp# (FK), (FK), account# (FK), (PK), order date, customer# (FK), order emp# (FK), truck vin (FK), cash receipt# (FK), (FK) pay to emp# (FK), account# (FK), payroll Orders and sales = Payroll = |(PK), Payroll = Purchases of flowers = (PK), , pay to emp# (FK), account# (FK), payroll emp# (FK), timecard# (FK), store# (FK), gross pay, employee FICA, employer FICA, employee Medicare (mc) contribution, employer Medicare (mc) contribution, federal (fed) tax withholding (wh), state tax withholding (wh), net pay to employee purchase# (PK), purchase date, grower# (FK), purchasing emp# (FK), truck VIN (FK), store# (FK), PO# (PK), purchase date, vendor# (FK), ordering emp# (FK), expense amount, reason, store# (FK), notes, check#, check date, cash disbursement emp# (FK), (FK) (PK), timecard date, regular time hours, overtime hours, emp# (FK), supervisor emp# (FK), store# (FK) Purchases of miscellaneous = Timecards = Agents Customers = customer# (PK), name, contact, street, city, state, zip, employee# (PK), social security number, Last Name, first name, wage rate per hour, Employees Growers = grower# (PK), name, phone number, city, state, store# (FK) vendor# (PK), name, address, city, state, zip, phone, fax, email, website Vendors miscellaneous = Linking Tables Orders and sales items = (PK), purchase# (FK), quantity (qty) ordered, quantity (qty) sold, sale price D. mohanaa lawama itama - nurobanti Inventamtt (DV Antitu lat nurobonnd nurobonenrinn Agents Customers = customer# (PK), name, contact, street, city, state, zip, employee# (PK), social security number, Last Name, first name, wage rate per hour, Employees Growers = grower# (PK), name, phone number, city, state, store# (FK) vendor# (PK), name, address, city, state, zip, phone, fax, email, website Vendors miscellaneous = Linking Tables Orders and sales items = (PK), purchase# (FK), quantity (qty) ordered, quantity (qty) sold, sale price purchase# + Inventory# (PK), Purchases of flowers items = quantity (qty) purchased, purchase price