20170609002911week_5_writing_assignment1 xweek_5_ais_powerpoint.pptx
I attached the powerpoint of the lecture and towards the end are more instructions on how to answer the questions. I also attached the microsoft word doc with the questions. I did a few of the questions, I just need help with the rest.
the powerpoint is just the lecture from my professor about the chapter and the assignment. The word document is what i need to turn in.
Chapter 5 Discussion Questions
1. The sales and collection process generates revenue accounts receivable, and cash flow information for a firm’s financial statements. What other information do you think managers would like to collect?
2. What kinds of businesses collect cash before recording the corresponding sales? How would that different sequence affect internal control requirements?
3. Draw a basic sales activity model using BPMN for a fast-food restaurant. Draw a second basic sales activity model using BPMN for a traditional restaurant. Discuss similarities and differences. How would you add taking reservations to the second model?
7. From your experience, think about the sales process for an online or brick-and-mortar store. Describe some business rules that help provide internal controls over the process.
8. What classes and associations would be included in a model that describes the information needed for a query that calculates the accounts receivable balance for each customer? Describe differences in the information for the open-invoice method, where customers pay according to specific invoices, versus the balance-forward method, where customers pay balances on monthly statements?
Chapter 5
Sales and Collection Business Process
Copyright © 2018 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill Education.
1
Agenda
Welcome and Introduction
Sales and Collection Business Process
Midterm Exam
Week 5 Homework
Questions
2
Copyright © 2018 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill Education.
Learning Objectives
Describe the business activities that comprise the sales and collection process
Develop an activity model of the sales and collection process
Understand and apply different activity modeling options
Develop business rules to implement controls for the sales and collection process
Develop UML Class Diagrams for the sales and collection process
Implement a relational database from the UML Class Diagram of the sales and collection process
Use multiplicities to implement foreign keys in relational tables
5-3
Copyright © 2018 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill Education.
Credit Sales System Flowchart
1 1-4
Copyright © 2018 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill Education.
Review of Sales and Collections Accounting
5-5
LO# 1
Copyright © 2018 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill Education.
Sunset Graphics
6
Copyright © 2018 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill Education.
Sunset Graphics Continuing Example
Sunset graphics design and sell
signs and banners,
lettering and vinyl graphics for vehicles and boats,
corporate promotional items, and
silk-screened t-shirts and embroidered gear, among other products.
5-7
LO# 2
Copyright © 2018 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill Education.
Sunset Graphics Sales Process Description
Sunset prepares a quote that carefully describes the products and services to be provided to the customer
Customer places the order for all or part of the quoted products and services
Sunset orders any products not in inventory from their suppliers (outside the sales process)
Sunset applies graphics
Sunset delivers the products to the customer
Sunset bills the customer and collects payment
5-8
LO# 2
Copyright © 2018 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill Education.
Basic BPMN activity model
5-9
LO# 2
Copyright © 2018 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill Education.
BPMN Model Refinement
5-10
Collaboration Sales Activity Model
LO# 3
Copyright © 2018 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill Education.
Further BPMN Model Refinement
5-11
Collaboration Sales Activity Model emphasizing the CHOREOGRAPHY – message flows between pools, since Sunset is not interested in the Customers activities. To clarify the diagram, the message flows should be labeled, e.g., “quote information” for the first message flow.
LO# 3
Copyright © 2018 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill Education.
More BPMN Model Refinement
5-12
Considering EXCEPTIONS to the process. Shows the process flow when the supplier does not have the products necessary to fulfill the customer’s order. Sub-process represents the PURCHASING activities without the detail; the INTERMEDIATE ERROR EVENT shows exception flow.
LO# 3
Copyright © 2018 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill Education.
Business Rules
Business rules help ensure that information systems operate in a consistent and effective manner to achieve organizational objectives.
Business rules are constraints on the process.
Business rules implement control activities, such as
Approvals, authorizations, verifications, and reconciliations
Reviews of operating performance
Security of assets and segregation of duties
5-13
LO# 4
Copyright © 2018 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill Education.
Establishing Business Rules for Sunset’s Sales
Define objectives for each important business event
Use the BPMN activity diagram to identify important business events
Define constraints on each event
What people/employees can do.
What information is available and not available
What the information system should do
5-14
LO# 4
Copyright © 2018 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill Education.
Sample Business Rules
5-15
Process Steps Intention Partner Authority/Action Access Controls Application Controls
Provide Quote Provide quotes promptly and accurately Partner must provide quote within 1 business day of request; Manager must approve quotes > $5,000 Partners preparing quotes cannot modify established product and service prices System must provide quote number control, default values, range and limit checks, and create audit trail
Receive Order Record order promptly and accurately; ensure customer credit is authorized Partner must record order within one hour of receipt; Manager must approve orders > $5,000; Credit manager must approve credit order > $1,000 Partners accepting orders cannot modify established product and service prices; Partners accepting orders cannot approve request for customer credit > $1,000. System must provide order number control, default values, range and limit checks, and create audit trail; system links quote to order
Copyright © 2018 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill Education.
Sunset Graphics Structure Models
The primary purpose of an UML model of the sales and collection process is to create a blueprint for the development of a relational database to support the collection, aggregation, and communication of process information.
To develop UML class diagrams, the REA framework (resources, events, and agents) is a proven approach to describing business processes in a way that meets both accounting and broad management information requirements.
5-16
LO# 5
Copyright © 2018 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill Education.
The quotation process
17
Copyright © 2018 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill Education.
Sunset’s Quotes – Defining Business Relationships
Each Sunset Partner may participate in a minimum of zero Quotes and a maximum of many Quotes, but each Quote involves only one Sunset Partner
Each Customer may participate in zero to many Quotes and each Quote is prepared for only one Customer
Each Quote specifies prices and quantities for at least one product
5-18
LO# 5
Copyright © 2018 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill Education.
Adding the Order Event
5-19
4. Each quote can result in a minimum of 0 orders and a maximum of many orders. Each order may related to 0 or 1 quote (some orders don’t have quotes).
LO# 5
Copyright © 2018 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill Education.
Adding Cash Receipts
5-20
Each order can be either paid or unpaid.
Each cash receipt is deposited into one bank account
LO# 5
Copyright © 2018 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill Education.
Ask students when Sunset might model sales separately. In this case, each order results in one sale and each sale is ordered first, so the orders and sales can be modeled as one event.
20
Type Images for Categorical Information
Type images apply guidelines, constraints, and descriptive information to their resources, events, and agents to help manage the business process
Type images also support summarization of the economic activity to support management’s information requirements
For Sunset Graphics, type images allow
Product categorization
Order status summary
Assignment of partners to manage product categories
5-21
LO# 5
Copyright © 2018 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill Education.
Adding Type Images to the Model
5-22
Orders (and Sales) can be summarized by product category.
Sunset partners can be assigned to manage on or more product categories.
LO# 5
Copyright © 2018 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill Education.
UML Class Models Support DB Planning
The database will contain one table for each class plus one table to support each many-to-many relationships
Multiplicities indicate location of foreign keys
Multiplicities indicate linking tables
5-23
LO# 6
Copyright © 2018 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill Education.
5-24
This model would result in a database with 9 tables for classes and 2 linking tables.
Associations that will be implemented with Linking Tables
LO# 6
Copyright © 2018 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill Education.
Posting Foreign Keys Example
5-25
Customer Number is posted in the Quote table as a foreign key.
Customer Number is posted in the Order table as a foreign key.
Quote Number is posted in the Order table as a foreign key.
LO# 7
Copyright © 2018 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill Education.
Rule of thumb – post the foreign key toward the MANY side of the one-to-many relationships (look at maximum multiplicities only).
25
Rule of Thumb
5-26
POST TOWARD THE * and AWAY FROM THE 1
The primary key of Customer should be a foreign key in the Sale Table!
LO# 7
Copyright © 2018 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill Education.
26
Resulting DB Tables and Relationships
5-27
LO# 6
Copyright © 2018 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill Education.
5-28
This model would result in a database with 9 tables for classes and 2 linking tables.
Associations that will be implemented with Linking Tables
LO# 6
Copyright © 2018 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill Education.
Generic Sales and Cash Receipts Model
29
Each customer participates in a minimum of zero and a maximum of many sales.
Each sale involves a minimum of one and a maximum of many inventory items.
Each cash receipt (e.g., one check from a customer) is deposited into one and only one account, and each account is associated with a minimum of zero cash receipts and a maximum of many cash receipts. These multiplicities reflect typical business practices.
These multiplicities depend on the nature of the business. Some businesses require payment at the time of the sale. Some allow payment terms. Some provide revolving accounts for their customers. Some collect payments in advance of the sale (e.g., magazine subscriptions). So, there are no typical multiplicities for this association.
LO# 5
Copyright © 2018 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill Education.
29
homework
30
Copyright © 2018 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill Education.
Week 5 Assignment 1
Please complete the homework in McGraw-Hill connect for Week 5.
Due Date: Sunday June 11th at midnight your local time.
31
Copyright © 2018 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill Education.
Week 5 Assignment 2
Complete discussion questions from your textbook, page 145, 1, 2, 3, 7, and 8.
Due Date: Sunday June 11th at midnight your local time. Upload to the assignment dropbox.
The sales and collection process generates revenue accounts receivable, and cash flow information for a firm’s financial statements. What other information do you think managers would like to collect?
How to approach: Think of the other information that is generated and used when there is a sale. How would an organization use that information and what information would help manage the business?
32
Copyright © 2018 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill Education.
Week 5 Assignment 2
2. What kinds of businesses collect cash before recording the corresponding sales? How would that different sequence affect internal control requirements.
Think of businesses that collect cash before delivery of goods and services.
For internal controls, does cash collection represent the recognition of revenue? What is the implication of that on internal controls in the sales to cash transaction cycle?
3. Draw a basic sales activity model using BPMN for a fast-food restaurant. Draw a second basic sales activity model using BPMN for a traditional restaurant. Discuss similarities and differences. How would you add taking reservations to the second model?
How to approach: List the steps for each activity model – fast-food restaurant and traditional restaurant. The convert that to a BPMN for each one. Make sure that you use the correct notation symbols.
33
Copyright © 2018 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill Education.
Week 5 Assignment 2
7. From your experience, think about the sales process for an online or brick-and-mortar store. Describe some business rules that help provide internal controls over the process.
List business rules that online or brick-and-mortar stores use to provide controls over the process and explain how they do that.
34
Copyright © 2018 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill Education.
Week 5 Assignment 2
8. What classes and associations would be included in a model that describes the information needed for a query that calculates the accounts receivable balance for each customer? Describe differences in the information for the open-invoice method, where customers pay according to specific invoices, versus the balance-forward method, where customers pay balances on monthly statements?
Create a UML class diagram for the classes and associations that are involved in the accounts receivable process. Then, explain how the queries would work:
Calculates the accounts receivable balance for each customer.
What are the differences between the open-invoice method and the balance forward method?
35
Copyright © 2018 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill Education.
QUESTIONS
36
Copyright © 2018 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill Education.
Sunset
Partner
Quote
Products
Customer
1..1
1..1
0..*
0..*
1..*
0..*
Order
1..*
0..*
0..*
0..*
1..1
1..1
0..*
0..1
Cash Receipt
Cash
0..*
0..*
1..1
1..1
0..1
1..*
0..*
1..1
Product
Categories
1..1
0..*
Order Status
1..1
0..*
1..1
0..*
Quote
Customer
1..1
0..*
Order
0..*
0..*
1..1
0..*
0..1
1
2
3
Sale Cust
1..1
0..*
Employees
Inventory
Customers
1..1
Sales
1..*
0..*
0..*
0..*
1..1
1..1
Cash Receipts
Cash
0..*
0..*
1..1
0..*1..1
?..?
?..?
1
2
3
4
