ACS 1803 Assignment 2: Operational & Managerial Reports Design

This assignment presents an operational and managerial report designed for PowerSalesCo, a wholesale power equipment company. The operational report focuses on sales data and order specifics, enabling the operation manager to understand customer purchases and order details. The managerial report allows managers to assess customer purchase behavior for each product. Additionally, the assignment includes a business process map illustrating a new hiring process incorporating a computer system for efficient data tracking and management, replacing traditional paper and spreadsheet methods to reduce data redundancy and errors. The proposed system automates notifications to HR assistants upon position confirmation.

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

3ACS 1803 ASSIGNMENT 2
Identifies need for
new position
Hiring Manager
Write position
description and level
position
HR Manager
Verify position
approval
Hiring Manager
Get approval from
division management
Hiring Manager
Get Signatures HR Assistant Advertise HRIS
Develop recruiting
plan
Recruiter
Post position on
internal website
HR Assistant Advertise HRIS
Verify recruiting plan Hiring Manager
Post position on
external sites
Recruiter Advertise HRIS
Search for suitable
applications
Recruiter
Candidates apply Candidate
Review resume Hiring Manager
Set appointment for
phone screening
HR Assistant

4ACS 1803 ASSIGNMENT 2
Do phone screening Hiring Manager
Select and interview
candidates for face to
face interview
Hiring Manager
Tell recruiter about
finalist choices
Hiring Manager
Enter applicants into
HR system
HR assistant Screen & Interview
HRIS
Do reference checks Hiring Manager
Prepare pre-work
paperwork
Recruiter
Construct offer
package
HR Manager
Make offer Recruiter
Accept offer and
confirm new hire
Candidate and HR
assistant
Hire HRIS

5ACS 1803 ASSIGNMENT 2
Figure 1: New Process
(Source: Created by Author)
The main change in the process is done by proposing a computer system. This system can
store and track activities done by the staff of Recruiting and Hiring staff. First of all, the use of
the paper and spreadsheet is altered with a system that has easy to understand user interface. The
staff can easily store every data regarding recruitment into the system. This system will have a
database that stores all the information in a central location. The staff will also store their
decisions into the system so that every action can be tracked efficiently.
The main advantages that can be obtained from these changes are as following.
i. The first advantage is efficient data tracking. This will allow the management to
track which client has submitted application. The progress of the application can

6ACS 1803 ASSIGNMENT 2
also be identified easily. Any authorized personnel can track whether a position is
confirmed or not.
ii. The second advantage is data management. In terms of paper and spreadsheet
solutions, the data redundancy and data error was common issue. On the other
hand, the dedicated system for data management will handle the data redundancy.
This will also reduce the issue of having different data for different staff.
The key automated process is notifying the HR assistance of vacant position as soon as
HR manager confirm the position. The system will store the position confirmation and trigger a
process that will notify the HR assistant to approve the position.

7ACS 1803 ASSIGNMENT 2
Bibliography:
Lewis, K. A., Tzilivakis, J., Warner, D. J., & Green, A. (2016). An international database for
pesticide risk assessments and management. Human and Ecological Risk Assessment: An
International Journal, 22(4), 1050-1064.
Kralj, D., & Hren, N. (2018, January). Framework project of database development: Record
keeping of protective equipment. In 7. Međunarodni stručno-znanstveni skup" Zaštita na radu i
zaštita zdravlja"/7th International Professional and Scientific Conference" Occupational safety
and health".