Background 

Mr. Z (real name Josh Zubkoff) runs a successful chain of cheese (and wine) shops in Oregon that specialize in Oregon artisan cheeses. He also sells his cheeses 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 at least five current business processes (Retail Sales, Wholesales, Internet Sales, Payroll, Inventory Purchases). These diagrams will serve multiple purposes. Mr. Z 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 Mr. Z is exposed to unnecessary risks in his business. Due April 10, 2019.

2.            Prepare an integrated data model using UML class diagrams and the REA framework. This data model will serve as the blueprint for Z’s prototype database that you will also develop. Due April 17, 2019

3.            Prepare an Access relational database for Mr. Z. He has agreed to provide financial data from his business for the 1st quarter of his fiscal year. That data will be in EXCEL format. You will move the data into Access, structure it appropriately, and set relationships consistent with your data model. Due April 24, 2019

4.            Prepare financial reports using your database. You will prepare queries as necessary to provide the following reports and management information.

a.            Z Cheddr income statement for the 1st quarter. Remember that Z uses accrual accounting.

b.            Z Cheddr balance sheet as of the end of the 1st quarter.

c.             Income statements for each Z Cheddr store for the 1st quarter.

d.            Analysis of product sales and profitability for the 1st quarter. Determine product turnover and profitability for each inventory item. Due May 1, 2019.