Accounting Information Systems: Excel and Case Study Analysis

This document presents a comprehensive solution to an Accounting Information Systems assignment, addressing two key questions. The first part focuses on practical scenarios using Excel, including an employee pay schedule with calculations for regular and overtime hours, base amounts, and total pay. The second part involves a research report exploring the impact of emerging technologies, such as Business Intelligence and Cloud Computing, on accounting and business decisions. The report highlights features of Business Intelligence Tools, including Location Intelligence, Executive Dashboards, and Interactive Reports, emphasizing their role in decision-making processes. The assignment demonstrates data analysis, data manipulation, and information presentation skills using Excel, as required by the course ACC202.

Running head: ACCOUNTING INFORMATION SYSTEM
Accounting Information System
Name of the Student:
Name of the University:
Author’s Note:

1ACCOUNTING INFORMATION SYSTEM
Answer to Question 1:
Requirement 2:
Employee Pay Schedule:
Employee Name Hours Worked Regular Hours Overtime Hours Hourly Pay Base Amount Over-Time Total Pay
Jennifer Leepoz 41 36 5 $40.00 $1,440.00 $425.00 $1,865.00
Kath Hudson 52 36 16 $80.00 $2,880.00 $1,360.00 $4,240.00
Lara Bangle 40 36 4 $50.00 $1,800.00 $340.00 $2,140.00
Novak Djoker 37 36 1 $30.00 $1,080.00 $85.00 $1,165.00
Paris Holton 45 36 9 $70.00 $2,520.00 $765.00 $3,285.00
Rafael Nooderly 44 36 8 $60.00 $2,160.00 $680.00 $2,840.00
Ricky Mortini 52 36 16 $60.00 $2,160.00 $1,360.00 $3,520.00
Russell Creak 34 34 0 $80.00 $2,720.00 $0.00 $2,720.00
Selina Geemak 30 30 0 $40.00 $1,200.00 $0.00 $1,200.00
Willard Smith 39 36 3 $30.00 $1,080.00 $255.00 $1,335.00
TOTAL 414 352 62 $19,040.00 $5,270.00 $24,310.00
Maximum Overtime Earned: Kath Hudson
Ricky Mortini
Requirement 3:
There are several functions that can be included within such scenarios in order to assist
the decision making process. In this manner, it is seen that scenario like employees who are
putting in long hours need to be taken into account in the process of decision making. It is due to
this fact that the decisions related to the employees putting in longer hours has to be taken into
account so that it motivates them and they receive the fruit for working longer for the company.
The next aspect that needs to be taken into account has been a model to forecast the
demand for the next quarter. In this manner, an idea can be attained and plans and policies with
respect to the manufacturing process for the next quarter can be taken into account with the help
of which better operational activities can be ascertained.

2ACCOUNTING INFORMATION SYSTEM
Answer to Question 2:
Introduction
There are two commonly used Business Intelligence Tools that are helpful in extracting
the intelligence from the business information which supports decision making with the help of
analysis and modelling. In this report, an explanation of the features of the commonly used
Business Intelligence Tools will be taken into account that assists in the decision making
process.
Body
The main aspect that would be addressed in this paper has been explaining the three
features that are available in the commonly utilised Business Intelligence Tools. It is seen that
there are several features that are related to the Business Intelligence Tools and out of the same
three of the features have been explained as follows:
Location Intelligence
Location Intelligence has been the capability to visualize and map the data in the formats
that are geographical in nature. The exploration and the visualization of the data sets on the basis
of the spatial components assists the companies to understand their business activities from a
newer point of view which can be considered as the sales per region (Wittwer et al. 2016).
Executive Dashboards
The personalised dashboards provide precise, easily understood real time data to the
leaders of the business that enables better and faster decision making process while reducing the
time of response to the external and the internal events (Alpar and Schulz 2016). Executives has

3ACCOUNTING INFORMATION SYSTEM
to access to the dashboards that are personalised that provide easy to understand KPIs and an
overview of the information in a scheduled and regular basis. Furthermore, the process of
exception reporting will be able to alert the executives towards any kind of unprecedented
scenarios and events that are in need of taking any actions. Customised delivery of data refers
that the executives are able to construct decisions faster, without making any guesses and
without looking to wade through the information that are irrelevant.
Interactive Reports
Interactive reports are helpful for the users in transfiguring the data into knowledge. They
permit the users to understand the assessments within the reports and the data that is underlying
on which the data are reliant on, which assists in the process of effective decision making
process (Shukla and Dhir 2016). The users need to be able to:
 Drill down and within the reports
 Undertake slice and dice of the OLAP assessment
 Incorporate evaluation like the moving averages and regression in order to address the
patterns in the data
 Utilise time series zooming in order to scan the large data sets in order to understand the
anomalies within their data
 Make use of conditional formatting to create data alerts which limelight the data
exceptions
Conclusion
The report therefore has been able to address three features that are available within the
Business Intelligence Tools with the help of which better decision making processes can be

4ACCOUNTING INFORMATION SYSTEM
attained. It is seen that these features play a vital role and these features of Business Intelligence
Tools have made these Business Intelligence Tools essential in the current time period.

5ACCOUNTING INFORMATION SYSTEM
Reference List
Alpar, P. and Schulz, M., 2016. Self-service business intelligence. Business & Information
Systems Engineering, 58(2), pp.151-155.
Shukla, A. and Dhir, S., 2016. Tools for data visualization in business intelligence: Case study
using the tool qlikview. In Information Systems Design and Intelligent Applications (pp. 319-
326). Springer, New Delhi.
Wittwer, M., Reinhold, O., Alt, R., Jessen, F. and Stüber, R., 2016, July. Social Media Analytics
Using Business Intelligence and Social Media Tools–Differences and Implications. In
International Conference on Business Information Systems (pp. 252-259). Springer, Cham.