Asset Tracking and Management System for R&S Entertainment

This project analyzes the need for an asset tracking and management system for R&S Entertainment Services, a company facing challenges in managing its growing inventory and preventing theft. The company, owned by Reid Lewis, operates in the entertainment machine business and has expanded over several decades. The current system, using outdated technology like Windows 95, struggles to support modern asset tracking. The project identifies the problem, explores various alternatives such as data integration and processing functions, and recommends implementing a new information system with modern devices and software. The proposed solution involves a centralized database and distributed system to manage the company's three branches and their assets effectively. The project emphasizes the importance of asset management for long-term financial benefits, improved efficiency, and enhanced security, concluding with recommendations for implementation and the potential for securitization of roadway framework to support the initiative. The project highlights the need for modern technology adoption to overcome the limitations of the existing outdated systems.

Running Head: Asset Tracking And Management System
Asset Tracking & Management System
Professors Name
Affiliate Institution
Date

Asset Tracking And Management System 2
Introduction
Asset tracking system is a software product developed so that it can be used to trace the firm or
organizational inventories. Inventories are all the items contained in the inventory management
system. These items are used by the firm to carry out daily activities by the firm. The system is
implemented so that it can help to reduce the cases of the security issues within the company.
Our customer, Reid Lewis, is the proprietor of R and S Entertainment Services. In 1947, Mr.
Lewis got engaged with the entertainment machine business; Coll, & Ouellette, (1996). He
maintained this business while likewise being the proprietor of a Marathon corner store.
Not long subsequent to beginning his delight machine business, Mr. Lewis could move his
corner store; from that point, he could run R and S Entertainment Services full time. Through the
span of 71 years, from 1947 to 2018, his business has developed into an exceptionally fruitful
association. R and S Entertainment Services is the biggest diversion machine administrator in
North Central Indiana. The organization has thirty five workers, their titles go from; Technician,
to Site manager, and up to Business Operations Manager.
The company has grown bigger and bigger overtime with entries of many clients day in day out.
In this case the company will find it difficult to manage and prevent its properties from being
stolen. The firm discovers that this was the major problem they are facing, they bought used
machines which were not very reliable as such. This made the management to rethink of other
devices which may help them to process services faster than usual.
Problem statement
After 1953 the company began to purchase new machines. The machines which were bought by
the R & S Entertainment services were a bit faster in terms of processing data. But still this

Asset Tracking And Management System 3
machines were not supporting the modern software programs like the modern Asset Tracking
Management Systems Hornick, (1993).
However, R & S Entertainment had up to this far gain many customers to use their services. The
company expanded to come up with three branches whereby the headquarters Lafayette and the
other two branches include Indiana; Fort Wayne.
The main problem which the company, is facing currently is how they can keep track of its
properties. The management decided to come up with a tracking system which will enable them
to manage their properties from theft.
In 90s the company uses the Windows 95. This kind of operating system which was used by the
R and S Entertainment services which does not support so many things.
Now the company is still naïve since it does not change anything. They are still in their 90s
where they are still using Windows 95 which is an obsolete software in this days. This operating
system does not support modern application like the Asset Tracking System.
The owner of the company is called Reid Lewis who is the chief executive officer of the firm.
Lewis is in his 90s and the guy used to run a gas station. In the gas station Reid bought pin ball
operators for operator routes
In this regard it comes up a problem that the firm is not able to support its branches with easy.
The properties are getting lost overtime hence making the company management costly. The
company had decided to come up firstly with an integrated asset tracking management system to
help in the management of tools and products.
Security threats
The proposed software to be used in the firm asset management, is a product to be deployed in
the organization. The product will use modern computers for it to function as expected. Now it is

Asset Tracking And Management System 4
the work of the company to purchase these machine so that the information system can be
implemented successfully. The system will enhance authentication to the users for its security
reasons.
Assets management system will gap the act of stealing of company’s inventories and will
enhance the productivity within the company.
Lewis Reid own two companies which are the R and S Entertainment services and Marathon gas
station. The two companies are having several inventories. These inventories can be well
protected by employing the software within the industry. The software can be integrated to
manage all the inventories for the two companies. Tersine, (1994).
Alternatives
1. Integrate data into databases- the data which are placed in a number of files which are not
related, the data can be kept in an organized fashion in order to help in quick retrieval of
the data. Data are stored so that redundancy can be reduced and maintenance is as well
facilitated. This kind of data storage technique enhanced reduced cost of storage.
Integrating the data to a database ensures that the outputs available to the user are
integrated. Hence user can retrieve all the data needed from the databases. He does not
need to look for files from different locations but will just have to such for several files
stored inside one database.
2. Integrating the data processing functions- As an alternative, the programs are put in place
so that so that the functions can be performed by a group of functional-oriented modules.
The functions which may be access in common include inquiry display, output generation
and terminal management.

Asset Tracking And Management System 5
3. Data flow integration- for the tracking system that needs to be implemented is that there
is a natural flow of information. This flow of information can be integrated together so
that information which are supposed to be shared can be shared within the information
system provided that security and privacy is considered.
4. Integrate data into databases and also integrate data processing functions- databases and
data processing functions are integrated together. This will make it possible for the
information system to be more accurate and reliable to the users.
5. Integrating both data into databases and the data flows together- in the new information
system both the databases and data flow can be integrated together so that it can help to
reduce redundancy within the information system. Giovanelli, (1998).
6. Integrate both data processing functions and data flows- both data processing systems can
be integrated together with the data flows so that the information can be processed as fast
as possible. This will make the company’s service delivery faster and inventory tracking
tools very reliable.
7. Integrate data into databases, integrate data processing function, and integrate data flows-
the database can be an integration of all the information system resources. When this data
are entered into the system, the users can extract them after it has been stored in the
databases using appropriate query languages.
8. Integrate the outputs. All the outputs produce are integrated together within the
information system. As compared to the old system, data was stored on files which are
not organized and duplicates of data can happened. This data may get lost and will never
be recovered.

Asset Tracking And Management System 6
9. Perform no integration- another alternative is to perform no integration in the information
system. This is a scenario where each department will be using their own individual
modules.
Recommendation
It is highly recommended that the R & S entertainments services to manage its operation using
the new information. The information system will employ modern devices and software for the
asset tracking which will help the firm to grow its business to a better level. Asset tracking tool
services can only be enhanced in modern devices and computers which uses modern operating
system but not Windows 95. These kind of applications are outdated, and does not support so
many end to end desktop application. Muckstadt, (1973).
Changes are recommended so that the firm can have a distributed system to manage all the three
branches together with its inventories and can be able to store them in a central database
management system. R $ S entertainments uses a file based system which is much disorganized.
If files are lost it will be so difficult to be retrieved the data. When a central repository is used,
data can be retrieved within seconds because they are well organized in specific folders.
Solution. Schmerer, & Weiand, (1994).
After the management had discussed on the ways to improve the way in which the firm deliver
its services to the client. They came up with the idea of implementing a new information system.
The system will be able to enhance R $ S entertainment efficiency and performance. R $ S
entertainment services has grown over time. New techniques need to be implemented so that
easier ways to manage the organization are enhanced.
The information management system to be implemented involves introducing modern devices
and technologies into the firm. Modern devices include modern computers and network devices

Asset Tracking And Management System 7
like services to allow a central distribution system. New technologies implies the new software
modules which will be integrated together to allow reliable communication within the
organization.
Conclusion
As of now a lot of out in the open framework are not reflected in the fiscal reports of any
organizations. Therefore, these advantages are viewed as sunk costs whose just money related
importance is the deplete they speak to on the upkeep spending plans of the organization
foundation offices. Customary thruway financing plans have favored capital consumptions for
new development by leaving support subsidizing duties to organizations. The accessibility of
generally less expensive capital assets from the Federal government has unintentionally
supported Lewis firm to concede upkeep on their thruway frameworks in the course of recent
years. This has created higher life-cycle costs for interstate framework when contrasted with
appropriate resource conservation.
The two company resources ought to be seen as substantial resources whose inborn esteem can
be utilized to animate further monetary movement, rather than just sunk expenses. Resource the
board gives the firm a chance to exhibit stewardship of their expressway foundation. Resource
the board likewise gives an impulse to building up creative techniques for financing expressway
advancement, conservation, and documentation.
Supporting the idea of benefit the board, the framework announcing necessities of both the
Marathon gas station and R and S entertainment services to speak to a noteworthy driving force
for change in the manner in which open foundation is financed, created, oversaw, and recorded
These incorporate fund, building, upkeep, and activities staff, which have generally worked
autonomously of one another.

Asset Tracking And Management System 8
They incorporate huge decreases in long haul expenses of thruway programs, open doors for
creative financing of benefit the executives and expressway framework recharging, and
utilization of revealing data to build up national spatial databases for Lewis Reid Company. How
state and neighborhood wards react to these new revealing necessities will decide their
accomplishment in utilizing the rare assets accessible for gas station improvement and
protection. Those that look for only to follow the base necessities of marathon gas station and R
and S entertainment services will profit little from the activity. Those that structure their reaction
around the requirements of both framework chiefs and clients will receive noteworthy rewards as
far as broadened application benefit lives, decreased substitution expenses, and better data with
which to deal with these basic resources.
On account of the long time span expected to exhibit the advantages of benefit the board and
safeguarding, numerous leaders might be hesitant to grasp its inhabitants and standards. This is
especially valid for chosen and designated authorities of state and neighborhood governments,
whose terms of office limit their capacity to concentrate on long haul outcomes. This is the
reason it is fundamental that some way be found to understand the long haul advantages of
thruway resource the board temporarily. Baker, & Urban, (1988). Securitization of roadway
framework gives such an instrument by utilizing the assets of the private back network to give in
advance assets to pay for the expenses of creating and actualizing resource the board
methodologies and frameworks, restoring expressway resources that could be more expense
adequately safeguarded whenever recharged, and reacting to Marathon gas station and R and S
entertainment services. Expressway securitization bond financing speaks to a win-win
circumstance for state and neighborhood authorities, specialized staffs, contractual workers,

Asset Tracking And Management System 9
development laborers, and people in general by empowering roadway supervisors to end up
better stewards of their advantages.
Expanding the dimension of interests in thruway foundation requires extending the span of the
venture pool. Financing systems that expansion the sources and dimensions of company
information system venture are required and the private part speaks to a noteworthy provider of
these assets. Be that as it may, certain conditions should be met before private part speculation
incomes stream into open roadway framework. Creative financing approaches that depend on
private segment venture will require watchful thought and adjusting of the chaperon dangers and
returns. Securitization of expressway framework without a characterized positive income source,
(for example, a toll or duty) will require both the private back network and the mindful locales to
rethink how they see foundation resources. Shadow tolling gives a conceivable instrument to
creating the positive income stream expected to help interstate securitization bonds.
The developing ability of the private division to go into organizations with general society area
to speed up the advancement or extension of required roadway offices is a vital improvement.
Sustaining open private associations to address the difficulties confronting our country's
expressway framework will require coordinated and aggregate endeavors that go past
conventional ways to deal with foundation subsidizing and advancement.
Closing
The hierarchical data flow
The owner of the company is the overall decision maker within the company. He is at the top/
tactical level. Lewis follows the unstructured decision making processes since he is the overall
person. MISRA, (1975). The tracking system will be able to have Lewis approval when an

Asset Tracking And Management System 10
employee is assigned an item. Therefore without Lewis response, no item will be given out until
the approval of Lewis.
However the company consists of three branches where each branch is assigned a manager to be
the overall person in every branch. Each of the Lewis’ employee is assigned a role to play using
the tracking system. Lewis company structure is in this format below.
Company layout
Lewis Company is structured in such a way that the inventories are located in special rooms for
easy tracking of these materials. Therefore in the system, one should be able to understand what
kind of inventories are found in a specific room. In this report the asset tracking and management
tool will be able to show all the properties of the organizational structures like the length and
width of the buildings and offices
Also the asset can be used to manage the roles of the company employees. Therefore the
software is so much very important to the company growth and productivity.

Asset Tracking And Management System 11
Data Flow Diagram
Entity Relationship Diagram

Asset Tracking And Management System 12
Entity Relationship Tables