Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1.Prepare a PERT chart for the Z-Cheddr project. Use the software we downloaded in class to prepare your diagram. State the expected business value to

1.Prepare a PERT chart for the Z-Cheddr project. Use the software we downloaded in class to prepare your diagram. State the expected business value to be derived from investing in the project and any critical points along the project pathway.

2.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 three current business processes. 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.

3.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.

4.Prepare a prototype 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.

5.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.

6.Evaluate the financial performance of Z Cheddr for the 1st quarter. Use your Access queries but also prepare formal financial statements and appropriate ratios to evaluate performance against the industry and past performance.

7.Assess the business case for use of information technology in Z's business (see chapters 13 and 14 in the text). Mr. Z wants to move to a cloud-based accounting system, such as Netsuite. He wants to upload transactions daily from new smart cash registers in each store. Submit all the deliverables in one report to Mr. Z at the end of the project. You will also submit your prototype Access database with all the queries along with that report. The report should be professionally prepared in an executive summary style and not longer than 6 pages not counting any appendices or attachments. The appendices or attachments should include financial statements, data model and activity diagrams, and other information necessary to support your analyses and conclusions. The content of the report should be clear to an accounting novice such as Mr. Z. Most of the content should be presented using tables, charts, and bullet points. In all cases, you should avoid long paragraphs. Specific content of the report should include:

Financial performance evaluation as outlined in 4 and 5 above.

Business case for technology as outlined in 6 above.

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

Fundamentals of Cost Accounting

Authors: William N. Lanen, Shannon Anderson, Michael W Maher

6th edition

1259969479, 1259565408, 978-1259969478

More Books

Students also viewed these Accounting questions

Question

Please help me evaluate this integral. 8 2 2 v - v

Answered: 1 week ago