University Accounting Information System: Data Analysis Assignment

This document presents a comprehensive solution to an Accounting Information System (AIS) assignment. The assignment involves detailed payroll analysis, including calculations of regular and overtime hours, hourly pay, and total pay for multiple employees. The solution utilizes pivot tables to analy...Read More

Running head: ACCOUNTING INFORMATION SYSTEM
Accounting information system
Name of the University
Name of the student
Authors note

1
ACCOUNTING INFORMATION SYSTEM
Table of Contents
Answer to Question 1:.....................................................................................................................2
Answer to Question 1.a:..............................................................................................................2
Answer to Question 1.b:..............................................................................................................2
Answer to Question 2:.................................................................................................................3
Answer to Question 3.a:..............................................................................................................3
Answer to Question 3.b:..............................................................................................................3
Answer to Question 4.a:..............................................................................................................3
Answer to Question 4.b:..............................................................................................................4
Answer to Question 2:.....................................................................................................................4
Answer to question 1:..................................................................................................................4
Answer to question 2:..................................................................................................................6
References:......................................................................................................................................8

2
ACCOUNTING INFORMATION SYSTEM
Answer to Question 1:
Answer to Question 1.a:

3
ACCOUNTING INFORMATION SYSTEM
Answer to Question 1.b:
Answer to Question 2:
Employee Name
Hours
worked
Regular
Hours
Overtim
e Hours
Hourly
Pay
Base
Amoun
t
Over-
Time
Total
Pay
Selina Geemak 30 30 0 40 1200 0 1200
Russell Creak 34 34 0 80 2720 0 2720
Ricky Mortini 52 30 22 60 1800 1980 3780
Rafael Nooderly 44 30 14 60 1800 1260 3060
Paris Holton 45 30 15 70 2100 1350 3450
Novak Djoker 37 36 1 30 1080 90 1170
Lara Bangle 40 30 10 50 1500 900 2400
Kath Hudson 52 30 22 80 2400 1980 4380
Jennifer Leepoz 36 30 6 80 2400 540 2940
Willard Smith 39 30 9 30 900 810 1710
Total 409 310 99 580 17900 8910 26810

4
ACCOUNTING INFORMATION SYSTEM
Answer to Question 3.a:
Row Labels
Sum of Over-
Time
Kath Hudson 1980
Ricky
Mortini 1980
Grand Total 3960
Answer to Question 3.b:
Employee Name
Total
Pay
Ricky Mortini 3780
Answer to Question 4.a:
Along with the stated functions, Pivot table can also be very useful for decision making
in this context.
Answer to Question 4.b:
By using pivot tables, it has determined that Simple Contracts Ltd. should charge $20330
to ABL Construction for hiring all the employees at level 4 and above in this week.
Employees at Level 4 and Above:
Values
Row Labels
Sum of Hourly
Pay
Sum of Total
Pay
Jennifer
Leepoz 80 2940
Kath Hudson 80 4380
Paris Holton 70 3450
Rafael
Nooderly 60 3060
Ricky Mortini 60 3780
Russell Creak 80 2720
Grand Total 430 20330

5
ACCOUNTING INFORMATION SYSTEM
Answer to Question 2:
Answer to question 1:
Business intelligence growth in past decades:
Business intelligence term was invented in early 1990’s and over the past few decades,
business intelligence has evolved to rely increasingly on real time. A dramatic shift has been
experienced over the past few years that helps in identifying the self-service importance in
business intelligence concepts. Much popularity was gained relating to Business intelligence
during year 1995. Growth of BI tools and revenue generated resulting from their implementation
has been constantly rising. BI is a growing filed and it is further expects that it will continue to
grow in future. There has been explosive growth in BI over the past two decades in terms of
services and numbers adopted and offered by technologies within different industries. Growth in
the adoption of BI tools is fueled by declining cost of storing and acquiring large amount of data
(Sauter2014). Technology of BI is used in different organizations. In manufacturing
organizations, tools of BI is used for customer support and order shipment. Retail organization
make use of such tools for targeting grocery coupons. Financial services relies on such tools for
fraud detection and claim analysis.
Business intelligence is a system and tool that assist corporation in their process of
strategic planning. It can be defined as the wider collections of application technologies,
software programs that is aimed at effective and efficient performance of decision makers. In the
implementation project plan of companies, business intelligence is considered as prevailing
software application strategy. Strategic decision making in organization facilitates empowered

6
ACCOUNTING INFORMATION SYSTEM
customers and increasing market volatility. It is the key factor in attaining competitive advantage
and is composed of methodologies, theories, architectures, processes and technologies that helps
in transformation of raw data into useful and meaningful information for business purposes. It
becomes important for organizations to consider the improved overall business process,
efficiency and business benefits when analyzing the solution to business intelligence (Richards et
al. 2017).
As per depiction of current statistics, total revenue generated for business intelligence on
worldwide is $ 23.1 billion (Işıket al. 2013). It is said by organizations that the factor that are
driving their competitive advantage position is that they need to be more analytics. Across the
globe, there has been increasing demand of technologies, approaches and tools of business
intelligence. Business decision making is enhanced by emergence of applications of business
intelligence.
Answer to question 2:
Commonly used business tools in decision-making and their two features:
Business intelligence tools are regarded as the type of software’s that is designed to
analyze, retrace and report the data. Enterprise of all sizes are effectively managed by analysis
and easy access of various data. Business decision are further enhanced by emergence of tool of
business intelligence by improving feature of data analysis, providing business with interface
that are user friendly.
SAP Business Intelligence- SAP is a tool of business intelligence that focuses on
providing organizations with useful form of representing data that would assist them in decision-
making and analysis purposes. SAP is considered as the effective tool of BI because it has single

7
ACCOUNTING INFORMATION SYSTEM
point of access and single place would enable access of multiples data sources. Some key
functionality of tool involves the capability to perform the multidimensional data sources
analysis. Various forms of data collected are able to present in report form that helps in
analyzing data efficiently at high level. Little administration is required for dealing with this
particular tool of BI and its query performance is well-defined (Wixom et al. 2017).
Oracle Hyperion system-This tool of BI offers a centralized budgeting, planning and
forecasting solutions that helps in integration of operational and financial planning processes. It
intends to improve the predictability capacity of business. It is a web-based application that helps
in improving and reporting of data. Some of the features of this particular tool of BI involves
improving forecasting and plan accuracy, reducing cost ownership through deployment of
application, packaged data integration and tools of management. It leverages the Microsoft office
based interface that assist in dwindling the learning curve. Furthermore, external and internal
transparency of organization is improved by delivering a single truth version and compliance
cost reductions. It helps in improving the financial results confidence by maintaining a regulatory
filing made to audit trial of general ledger. An in depth analysis of operational and key
performance indicators are easily conducted using this BI tool (Lim et al. 2013).

8
ACCOUNTING INFORMATION SYSTEM

9
ACCOUNTING INFORMATION SYSTEM
References:
Işık, Ö., Jones, M.C. and Sidorova, A., 2013. Business intelligence success: The roles of BI
capabilities and decision environments. Information & Management, 50(1), pp.13-23.
Kulkarni, U.R., Robles-Flores, J.A. and Popovič, A., 2017. Business Intelligence Capability: The
Effect of Top Management and the Mediating Roles of User Participation and Analytical
Decision Making Orientation. Journal of the Association for Information Systems, 18(7).
Lim, E.P., Chen, H. and Chen, G., 2013. Business intelligence and analytics: Research
directions. ACM Transactions on Management Information Systems (TMIS), 3(4), p.17.
Richards, G., Yeoh, W., Chong, A.Y.L. and Popovič, A., 2017. Business Intelligence
Effectiveness and Corporate Performance Management: An Empirical Analysis. Journal of
Computer Information Systems, pp.1-9.
Sauter, V.L., 2014. Decision support systems for business intelligence. John Wiley & Sons.
Vukšić, V.B., Bach, M.P. and Popovič, A., 2013. Supporting performance management with
business process management and business intelligence: A case analysis of integration and
orchestration. International journal of information management, 33(4), pp.613-619.
Wixom, B., Ariyachandra, T., Douglas, D.E., Goul, M., Gupta, B., Iyer, L.S., Kulkarni, U.R.,
Mooney, J.G., Phillips-Wren, G.E. and Turetken, O., 2014. The current state of business
intelligence in academia: The arrival of big data. CAIS, 34, p.1.