ICT100 Assessment 2: XYZ Company Transaction Processing System Report

This report, prepared for the ICT100 Foundations of Information Systems course, analyzes the selection of a new Transaction Processing System (TPS) for XYZ company to gain a competitive edge. The report begins with an introduction highlighting the importance of information systems in achieving competitive advantage. It then presents a detailed analysis of four different TPS systems (TPS1, TPS2, TPS3, and TPS4) using data provided in an Excel sheet, evaluating them based on transaction processing speed, system errors, and profitability. The analysis includes graphical representations of the data to justify the selection of the most suitable TPS. Furthermore, the report emphasizes the importance of correct data representation for effective decision-making. The conclusion summarizes the findings and recommends a specific TPS for the company, considering the reduction in management complexity and cost savings through automation. The report also mentions the importance of following a system development lifecycle model to avoid errors and improve efficiency. Finally, it includes a bibliography of relevant sources.

Running head: ICT100 FOUNDATIONS OF INFORMATION SYSTEMS
ICT100 foundations of information systems
Assessment 2
Name of the student
Name of the university
Author’s note

1
ICT100 FOUNDATIONS OF INFORMATION SYSTEMS
Table of Contents
Introduction................................................................................................................................2
Transaction Processing System Selection..................................................................................2
Importance of Data Representation............................................................................................4
Conclusion..................................................................................................................................4
Bibliogarphy...............................................................................................................................5

2
ICT100 FOUNDATIONS OF INFORMATION SYSTEMS
Introduction
The report is prepared for the development of a new Transaction Processing System
(TPS) for XYZ company such that the company can gain competitive advantage in the
market. With the growth of the business the complexity for the management of the tasks
increases and with the development of the information system the complexity of the
management of the business process can be reduced. The information system can also help
the organization to gain cost leadership by reducing the cost of business operation. It can also
differentiate the business from its competitors with the implementation of differential
function for having direct conversation with the customers and providing different value
added service for the improvement of customer relationship.
Transaction Processing System Selection
The transaction processing system is used for management of the transaction and for
getting faster transaction. With the development of the transaction process system the
reliability of the transactions improves and consistency is maintained for each of the
transactions performed.
TPS1 TPS2 TPS3 TPS4 Total
Lowes
t
Highes
t Average
Transactions 1000 1200 1400 1800 5400 1000 1800 1350
Re-Entry Required
due to system
errors 77 3 135 25 239.7 2.7 135 59.925
Total Transactions 923 1197 1265 1775 5160.3 923 1775
1290.07
5
Blocks 18.46 23.946 25.3 35.5 103.206 18.46 35.5 25.8015
Blocks per hour (8
hr day)
2.307
5
2.9932
5
3.162
5
4.437
5
12.9007
5 2.3075 4.4375
3.22518
8
Profit
2215.
2
2873.5
2
3415.
5 5325
13829.2
2 2215.2 5325
3457.30
5
Last two digits of
Student ID 27

3
ICT100 FOUNDATIONS OF INFORMATION SYSTEMS
Blocks/
hr
Daily
Profit
1
$100.0
0
2
$120.0
0
3
$135.0
0
4
$150.0
0
With the development of the transaction processing system a real time information
can be fetched from the system. Here, the excel sheet can be used for getting the graph of the
total transactions based on the total processing system 1, total processing system 2, total
processing system 3, total processing system 4. The total, lowest, highest and average is also
demonstrated in the graph.
1 2 3 4 5 6 7 8
0
1000
2000
3000
4000
5000
6000
Total Records Entered
The pie chart is created for the identification of the system error for each of the
transaction processing system with the identification of the re entry required to be made due
to the system error. Thus the TPS2 is selected since it has less errors.

4
ICT100 FOUNDATIONS OF INFORMATION SYSTEMS
System Error
1 2 3 4
Importance of Data Representation
The correct representation of the data is important for reducing the error in the
information system and take effective decision according the data. The clarity in the
representation of data and the selection of the right data is important for the correlating it with
the other data that are needed to be analysed for getting the result. It helps in describing the
data using a finite set of values and it should be evenly distributed depending on its category.
Conclusion
From the above report it can be concluded that with the development of the
transaction processing system for the XYZ organisation the complexity in management of the
transaction can be reduced. The company can collect, modify, store or retrieve the transaction
of the enterprise for the management of the routine business transaction. It helps in reducing
the time and cost with the automation of the different repetitive operation for the management
of large volume of transactions. For the development of the information system a system
development lifecycle model should be followed that would help in development of the
information system following different phases such that there is no error in the final product.
It helps in increasing the efficiency of the current business process and reach more number of
people for management of the different service.

5
ICT100 FOUNDATIONS OF INFORMATION SYSTEMS
Bibliogarphy
Gualda, G.A. and Ghiorso, M.S., 2015. MELTS_Excel: A Microsoft Excel‐based MELTS
interface for research and teaching of magma properties and evolution. Geochemistry,
Geophysics, Geosystems, 16(1), pp.315-324.
Laudon, K.C. and Laudon, J.P., 2016. Management information system. Pearson Education
India.
Liu, D., Liang, D. and Wang, C., 2016. A novel three-way decision model based on
incomplete information system. Knowledge-Based Systems, 91, pp.32-45.
Tahri, M., Hakdaoui, M. and Maanan, M., 2015. The evaluation of solar farm locations
applying Geographic Information System and Multi-Criteria Decision-Making methods: Case
study in southern Morocco. Renewable and Sustainable Energy Reviews, 51, pp.1354-1362.