Operational and Managerial Reports for Sales Data | ACS 1803 Assignment 2

Running head: ACS 1803 ASSIGNMENT 2
ACS 1803 Assignment 2
Name of the Student
Name of the University
Author’s note:

1ACS 1803 ASSIGNMENT 2
Question 1:
1.1 Report:
Operational Report:
Managerial Report:
1.2 Description:
In case of the operational report, the data is presented based on the sales of the products.
The orders are the main concern in the operational report. A derived column is created for
deciding how much cost of product is purchased for each order. The order data, customer name

2ACS 1803 ASSIGNMENT 2
and product number decides the specific order made by the customer. The total charge for each
order is determined by the unit of products bought and how much the product costs. The SQL
query is created for being the base of the operational report. The reports helps the operation
manager to determine specific products a customer has bought. Moreover, it provides accurate
information regarding each order.
The managerial report shows that manager can decide how much purchase a specific
customer has made for each product. The report is created based on the customer name and
product name. This report could be provided based on how much purchase a customer has made.
However, this would have been provided only insight of customer purchase. If the manager
needs information on the customer purchasing the products then second proposed report will be
of no use. The provided report consist of more information in a very simple form. The total
charge for each order is determined by the unit of products bought and how much the product
costs.
1.3 Significance of Reports:
The provided reports will be capable of answering queries like what customer is most
profitable, which product is most sold, the orders that made most sales, how much total sales has
been made and many more. The additional insights that can be taken from these reports are
product capability, customer loyalty, purchase frequency and more. The soft data is the total
charge per order and hard data is all the order data available in the report.
Question 2:
Business Process Map Organizer
Activity Gateway (Decision) Swim lane Data Store