Project Assignment Description

$$

Y Not Flowers Project Description and Requirements

$$

$$

$$

Background

$$

Tony Green 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. Additionally, he knows that YNF is not using data to make important business decisions. He has come to you for assistance.

$$

Instructions

$$

Your supervisor met with Tony 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 four 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 a structure $($data$)$ model using UML class diagrams. This data model will serve as the blueprint for YNF$$s prototype database that you will also develop. Also, think about a corresponding table listing for the prototype database.

$$

$3.$ Forrest has agreed to provide financial data from his business for the $1$st quarter of $2025.$ That data is 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.

$$

Using MS Access, prepare financial reports using the database. You need to prepare queries as necessary to provide the following reports.

a$.$ Income statements for each YNF stores for the $1$st quarter.

b$.$ YNF income statement for the $1$st quarter.

$$

You can use these columns$/$fields as a reference

$$

Store#

Store Location

Revenue

COGS

Gross Profit

Payroll Expense

Administrative Expense

Quarterly Truck Dep.

Quarterly Store Dep.

Total SG&A Expense

Income before Tax

FS$001$

$$

$$

$$

$$

$$

$$

$$

$$

$$

$$

FS$002$

$$

$$

$$

$$

$$

$$

$$

$$

$$

$$

FS$003$

$$

$$

$$

$$

$$

$$

$$

$$

$$

$$

FS$004$

$$

$$

$$

$$

$$

$$

$$

$$

$$

$$

FS$005$

$$

$$

$$

$$

$$

$$

$$

$$

$$

$$

FS$006$

$$

$$

$$

$$

$$

$$

$$

$$

$$

$$

FS$007$

$$

$$

$$

$$

$$

$$

$$

$$

$$

$$

FS$008$

$$

$$

$$

$$

$$

$$

$$

$$

$$

$$

FS$009$

$$

$$

$$

$$

$$

$$

$$

$$

$$

$$

FS$010$

$$

$$

$$

$$

$$

$$

$$

$$

$$

$$

FS$011$

$$

$$

$$

$$

$$

$$

$$

$$

$$

$$

FS$012$

$$

$$

$$

$$

$$

$$

$$

$$

$$

$$

Total

$$

$$

$$

$$

$$

$$

$$

$$

$$

$$

$$

$$

Prepare a report for YNF regarding financial performance and Internal Control

$$ Use YNF $2025$ Q$1$ Income Statement, Sales History, and Interviews

$$

The report should include

$2025$ Q$1$ revenue and income $($before tax$)$ for each YNF store $($you need to choose a proper chart$)$

Changes$/$Trends of Q$1$ revenue and quantity sold for YNF $($not each store$)$ over time by using the $2025$ and historical data $($choose a proper chart$)$

Store analysis to show each store's performance $($you do not need to include all $12$ stores$)-$ Find any interesting stories$/$comparisons$.$

Potential risks$/$threats of employees$$ fraud or errors & possible Control Activities mitigating them $($Risk analysis begins with stating what the goals$/$objectives are $$ COSO framework$).$ You need to include the goals$/$objectives of YNF$.$

$$