Kế toán, kiểm toán - Chapter 8: Integrated project

Chapter 8Integrated ProjectCopyright © 2014 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill Education.Learning Objectives8-2LO#1 Plan and manage a business analysis projectLO#2 Develop an integrated UML Class Diagrams for a businessLO#3 Develop activity models of multiple business processes and use those models to assess potential risks and opportunities for process improvements LO#4 Use the UML Class Diagram to design and implement a relational database system in Microsoft Access™ LO#5 Employ the relational database to answer a variety of business performance questionsSy’s Fish Company8-3Sy’s Fish Company owns a chain of wholesale fish stores. The company has grown rapidly over the last few years and now operates eight different stores. The company is poised to expand further, but first needs to develop a better accounting information system. This project involves a thorough analysis of Sy’s Fish Company business processes to assess opportunities for improvement and implementation of a prototype integrated database to provide financial and management information.  The Sy’s Fish Project is based on a project developed by Bill McCarthy, Professor, Michigan State University.LO# 1Sy’s Fish Company OverviewYou will focus on five processesSelling fish Purchasing fish Paying employees Purchasing miscellaneous supplies and services Providing refunds to customers8-4LO# 1Sy’s Fish Company InformationSummary of interviews with key employees available separatelyEXCEL spreadsheet with all necessary data available separatelySy’s Fish uses accrual accountingSy’s Fish uses a calendar fiscal year8-5LO# 1Suggested Project Steps8-6LO# 1Project DeliverablesProject Plan Integrated UML Class Diagram encompassing the five processesBPMN Activity Model for each of the five processesAccess database with all tables efficiently organized, relationships set to match your UML diagram, and referential integrity enforcedQueries to address Sy’s requirementsReport8-7LO# 2, 3, 4, 5Query RequirementsCompany income statement for 1st quarterCompany balance sheet at the end of the 1st quarterStores’ income statements for 1st quarterAccounts receivable for each customer (showing all customers)Each of these may require several queries, but the final query in each set should show the information required8-8Report RequirementsFinancial performance evaluation for 1st quarterRisk assessment and recommendations for risk management based on the BPMN activity diagramsAssessment of potential benefits of the use of information technologyRefer to BPMN activity diagramsConsider costs and benefitsAddress report to Sy, CEO of Sy’s Fish CompanyUse executive summary style, including tables and charts to summary relevant information 8-9LO# 2, 3, 4, 5Good luck!8-10