Chapter 08, Integrated Project 2: Y Not Flowers

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. 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. Prepare financial reports using your database. You will prepare queries as necessary to provide the following reports and management information:
   1. YNF income statement for the 1^st quarter.
   2. YNF balance sheet as of the end of the 1^st quarter.
   3. Income statements for each YNF stores for the 1^st quarter.
   4. Other performance measures that you believe YNF should adopt.

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
• Additional Excel spreadsheet of Y Not Flowers' historical data

Additionally, the following files have been provided for assistance:

• Instructions on how to move data from Excel to Access
• 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.