Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

will evaluate whether the diagram accurately reects his business, and Prof. Smith will evaluate whether the diagram meets BPMN standards.) Prepare an integrated data model

image text in transcribed
image text in transcribed
will evaluate whether the diagram accurately reects his business, and Prof. Smith will evaluate whether the diagram meets BPMN standards.) Prepare an integrated data model using UML class diagrams and the REA framework. This data model will serve as the blueprint for Z CHEDDR's prototype database that you will also develop. Also, prepare a corresponding data listing1 for the prototype database. Identify where different eldsfattribute names provide the same information and develop recommendations for changes in eld names. Review the data model with both Mr. E and Prof Smith before working on developing your database. Prepare a prototype database for Z CHEDDR. Mr. Z has agreed to provide nancial data from his business for the 1St quarter of his scal 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. Make changes as necessary in le structures to implement efcient tables and eliminate duplication. Answer the Z Cheddr questions in CONNECT. Prepare nancial 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 1Slt quarter. b. 2 CHEDDR balance sheet as of the end of the ift quarter. c. Income statements for each 2' CHEDDR stores for the 15L quarter. d. Other performance measures that you believe 2 CHEDDR should adopt. Evaluate the nancial performance of 2 CH EDDR for the 1Ft quarter. Use your Access queries to also prepare formal nancial statements and compute appropriate ratios to evaluate performance against the industry and past performance. Also, use one of the analytics software products, Tableau or Power Bl, to compare results for the current quarter against historical performance and industry performance to the extent that you can nd comparable industry data. Clearly explain what those performance measures mean for Z CHEDDR

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Cost Management

Authors: Don R Hansen, Maryanne M Mowen, Dan L Heitger

5th Edition

357141091, 978-0357141090

More Books

Students also viewed these Accounting questions

Question

A greater tendency to create winwin situations.

Answered: 1 week ago

Question

Improving creative problem-solving ability.

Answered: 1 week ago