Create a UML Class diagram that integrates the sale cycle and the expenditure cycle related to the main business. $($Hints: your diagram should $($at a minimum$)$ include the following classes: Orders$/$Sales$,$ Customers, Cash Receipts, Cash, Stores, Flowers $($inventory$),$ Flower Purchase, Flower Items Purchase, and Grower$)(30$ Points$).$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.

Requirements for the project $($Submit your answers in Word with question #$,$ supported by screenshot

of your ACCESS and$/$or EXCEL data for each question. Submit your Word file as PDF and ACCESS$/$EXCEL

file separately in Canvas$)$:

Create a UML Class diagram that integrates the sale cycle and the expenditure cycle related to

the main business. $($Hints: your diagram should $($at a minimum$)$ include the following classes:

Orders$/$Sales$,$ Customers, Cash Receipts, Cash, Stores, Flowers $($inventory$),$ Flower Purchase,

Flower Items Purchase, and Grower$)|(30$ Points$).$

Analyze your data in MS ACCESS and answer the following questions $($Show each answer with

support in Word$)$:

a$.$ Report Sales, Cost of Sales, and the Gross Margin by store for Q$1,2022(30$ Points$).$

$($Hints: Gross Margin $=$ Sales $-$ Cost of Sales$)$

b$.$ Create a dashboard, including a chart and table, that allows your CFO to dynamically see

the revenue, cost of sales, and gross margin by Store, individually or collectively for Q$1,$

$($Hints: you need a slicer$)(40$ points$)$