Accounting system excel

Background

Mr. Z (real name Zubkoff) runs a successful chain of cheese and wine shops (Z Cheddr) in Oregon that specialize in Oregon artisan cheeses and local wines. He also sells his products over the internet. He is considering expanding his business, but he thinks his current accounting and financial systems are restricting his ability to expand. He has come to you for assistance.

Instructions

Your supervisor met with Mr. Z 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 Z’s business processes, you will document current processes using business process modeling notation (BPMN). This involves documenting five current business processes:
   1. Sales (retail & wholesale) & Cash Receipts
   2. Internet Sales
   3. Payroll
   4. Inventory Purchases & Cash Disbursements
2. Analyze sales by store and product over the previous five years using Excel. The analysis should address the following questions and must be visualized in a chart or graph.
   1. Which stores are selling more wine and cheese?
   2. Which product is most popular?
   3. Which stores have grown the most/least since 2020?
   4. Which product’s sales have increased/decreased the most since 2020?
   5. Does the popularity of products vary according to the month of the quarter?