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?

Collepals.com Plagiarism Free Papers

Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.

Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS

Why Hire Collepals.com writers to do your paper?

Quality- We are experienced and have access to ample research materials.

We write plagiarism Free Content

Confidential- We never share or sell your personal information to third parties.

Support-Chat with us today! We are always waiting to answer all your questions.