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:a. Sales & Cash Receiptsb. Flower Purchases & Payments c. Other Purchases & Paymentsd. PayrollThese 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. Recommend changes to YNF business processes to make it more effective and efficient.
3. Analyze store and flower sales over five years, including the current year, using Excel. Tony is interested in knowing:a. Which stores are selling more flowers.
   b. Which flower is most popular and does that change depending on the month.
   c. Which flowers are most popular at which store.
   d. Which stores have grown the most/least since 2020.
   e. Which flower’s sales have increased/decreased the most since 2020.
   f. Other trends that can help evaluate store performance and potential pricing decisions.

Requirements: using bpmn for question 1 and excel for question