YNF Project Description and Requirements
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. (10 points) Document process activity using BPMN. 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. [hint: read “Summary_of_YNF_Interviews.docx” to
understand business process]
1.1. (2.5 points) YNF Sales:
1.2. (2.5 points) YNF Flower Purchases:
1.3. (2.5 points) YNF Miscellaneous/Administrative Purchases:
1.4. (2.5 points) YNF Timekeeping and Payroll:
2. (5 points) 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. [hint: each spreadsheet in “YNF_data.xlsx” represents one class]
3. (2 points) Prepare a prototype database for YNF. Forrest has agreed to provide financial data
from his business for the 1st quarter of his fiscal year in EXCEL format. Move the data into
Access, structure it appropriately, and set relationships consistent with your data model.
[hint: refer to “Guide_to_Importing_EXCEL_data_into_Access.docx”]
5. (4 points) Evaluate YNF’s financial performance for the 1st quarter, and explain those ratios.
Also, evaluate performance against the past performance in “YNF_Financial_History.xlsx”.
6. (4 points) Recommend changes to YNF business processes to make it more effective and
efficient