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.

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. Read and study the Summary of YNF Interviews. 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) (you can do it manually [very neatly!] or use a free trial version of BPMN software [preferred]). This involves documenting at least five current business processes.

2. create an integrated data model using UML class diagrams and the REA framework. You can perform this manually (very neatly!) or use a free trial version of modeling software (preferred). This data model will serve as the blueprint for YNF's prototype database that you will also develop. Also, make a corresponding table listing for the prototype database. Identify where different fields/attribute names provide the same information and develop recommendations for changes in field names.

3. also 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. Here is a Financial History of YNF.

4. Prepare financial reports using your database. You will prepare queries as necessary to provide the following reports and management information.

2. YNF balance sheet as of the end of the 1st quarter. 3. Income statements for each of the YNF stores for the 1st quarter. 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.

Also, make sure to answer connected questions 20,21,22,23, about the records in the query:

-Join the Orders and Sales table with the Orders and Sales Items table. Limit sales to the first quarter of 2018 beginning on January 1 and ending on March 31. How many records are there in your query?

- Join the Purchase Flowers table with the Purchase Flowers Items table. Limit purchases to the first quarter of 2018 beginning on January 1 and ending on March 31. How many records are there in your query?

- Join the Timecards table with the Payroll table. Limit timecard records to the first quarter of 2018 beginning on January 1 and ending on March 31. How many records are there In your query?