Lecture Accounting information systems: Chapter 8 - Richardson, Chang, Smith
Bạn đang xem bản rút gọn của tài liệu. Xem và tải ngay bản đầy đủ của tài liệu tại đây (495.76 KB, 10 trang )
Chapter 8
Integrated
Project
Copyright © 2014 McGrawHill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGrawHill Education.
Learning Objectives
•
•
•
•
•
LO#1 Plan and manage a business analysis project
LO#2 Develop an integrated UML Class Diagrams for a
business
LO#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 questions
8-2
LO# 1
Sy’s Fish Company
Sy’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
2)
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
1)
State University.
8-3
LO# 1
Sy’s Fish Company Overview
•
You will focus on five processes
1.
Selling fish
2.
Purchasing fish
3.
Paying employees
4.
Purchasing miscellaneous supplies and services
5.
Providing refunds to customers
8-4
LO# 1
Sy’s Fish Company Information
•
•
Summary of interviews with key
employees available separately
EXCEL spreadsheet with all necessary
data available separately
•
Sy’s Fish uses accrual accounting
•
Sy’s Fish uses a calendar fiscal year
8-5
LO# 1
Suggested Project Steps
Prepa re
Activity
Diagram s
Prepare
Project Plan
Determ ine
Requirem ents
I m port Data
into Access
Cre ate Tables
a nd Establish
Re lations
Prepare
Queries
Prepa re
Structure
Diagram s
8-6
Prepare
Report
Project Deliverables
•
•
•
•
LO# 2, 3,
4, 5
Project Plan
Integrated UML Class Diagram
encompassing the five processes
BPMN Activity Model for each of the five
processes
Access database with all tables efficiently
organized, relationships set to match your
UML diagram, and referential integrity
enforced
8-7
Query Requirements
•
•
•
•
•
Company income statement for 1st
quarter
Company balance sheet at the end of the
1st quarter
Stores’ income statements for 1st quarter
Accounts receivable for each customer
(showing all customers)
Each of these may require several
8-8 set
queries, but the final query in each
Report Requirements
•
•
•
LO# 2, 3,
4, 5
Financial performance evaluation for 1st
quarter
Risk assessment and recommendations
for risk management based on the BPMN
activity diagrams
Assessment of potential benefits of the
use of information technology
–
Refer to BPMN activity diagrams
–
Consider costs and benefits
8-9
Good luck!
8-10
