ITT Trip Scheduling Essay, Research Paper
ITT Trip Scheduling
The Information, Tours and Tickets (ITT) office could use a system to assist
them in creating trip schedules. In this paper I will outline a plan for a
Decision Support System (DSS) that will assist ITT in creating schedules for
their tours. This system will also track customer surveys and hold data about
all of ITTs trips. They already have some computer systems, a spread sheet
program and a data base management system (DBMS) which can all be used to build
a small DSS. Using the DBMS and the spread sheet software I have designed a
system to assist them in making decisions about scheduling trips. This system
also allows them access to information about all of ITTs trips and the feedback
from customers about each trip. In the next few paragraphs I go through the
major steps in developing a system of this nature. A system of this type goes
through several phases in its development. I start with the planning phase and
go on to discuss research, analysis and conceptual design. Then I talk a little
about the models used in this system. I finish by talking about the actual
design, the construction, and the implementation of the new ITT system. I
finish the paper with a discussion of maintaining the system.
The first step in building any DSS is planning. Planning is basically defining
the problem. The planning also involves an assessment of exactly what is needed.
In this case I deal with trip scheduling. In the case description this would
include: How many trips to offer, the days of the week to have particular trips,
and when to cancel trips. Obviously the scheduling ties to other information
such as profit and participation, but for this paper I will only cover the
scheduling portion of ITTs problem. Therefore I have defined the problem as a
basic scheduling problem. I see a need for ITT to better schedule trips using
the information they have and using the information they collect from customer
surveys. With the problem defined we can now look at what information is needed
to further analyze the problem.
After a problem is defined, information must be collected. The research phase
of system development is just that, collecting information. The information
collected will be used in the next phase of development to further analyze the
problem and it will be used in this case to build the databases. The databases
will then be used with decision support system (DSS) models to assist ITT in
making scheduling decisions. Information in this case can come from their
current schedules and trip description fliers. Also during this stage of
development the current resources are assessed. This would include ITTs current
information systems and their current budget. And, information such as Navy or
ITT policies are collected as a reference. Once all the information is
collected than the system can move to the next stage of development, analysis.
With all the data and information collected analysis of it begins. In this
stage we determine what needs to be done to solve the problem. No work, on a
new system, is started yet, but a system is conceptualised and possible
solutions are identified. Also in this stage a final solution to the problem is
chosen and system passes through another stage of development. For the ITT
problem I have chosen a simple Management Information System (MIS) with small
decision support models to aid in creating schedules. This system will provide
ITT with the information they need to make decisions about scheduling their
trips as well as allow them to create the schedules directly from computer
models. I will discuss the models in the next paragraph. The system would not
draw conclusions, but simply show the pros and cons to certain choices. The MIS
portion of the system will simply provide information to the users and to the
DSS. The DSS portion of the system will allow a schedule to be created using
resources in an optimum manner. I decided to go with a small and simple system
because of ITTs limited resources and because of a high employee turn-over. A
complicated system would not be feasible in such an environment where new
employees are constantly having to be trained to use it.
In this paragraph I side step from the development a little to talk about the
models used in the system. As stated earlier the models used in this system
should be kept simple and small if possible. Using standard spread sheet
software, models can be created that will show the optimal schedule for trips.
The basic information required for these models should include bus schedules,
reservation requirements, customer satisfaction information, and cost data.
Other data can also be added to assist in decisions. The models would first
approximate the participation for each proposed trip. Then another model would
determine if the trip is feasible given the costs involved. The next model
would determine if the trip is even possible considering what is required as far
as reservations and transportation. Another model could also determine if the
trip would be able satisfy the customers given the past customer inputs.
Finally after determining whether each trip is worth offering the ITT employees
could use the computer to generate a new schedule. Now that we know what the
system should do we can turn our attention to the design of the system.
In the design phase of DSS development the new system is designed to solve the
problem. Here the information collected and the resources identified are
examined to decide exactly what must be done and in what manner to solve the
problem. Diagrams may be drawn to show how the components will fit together.
Also the ground work is laid for the construction phase. In the ITT case I
designed a database that contains information on all their trips along with
information obtained from the customer surveys. This information is then
combined with bus and reservation data in a standard spread sheet where it is
manipulated to optimize the trip schedule. A manager or an employee can then
use the information and the data in the database to create a calendar of events
using an inexpensive program ?Calendar Creator.’ Which is what ITT currently
uses to create schedules manually.
The construction of a system is the bringing together of all the required parts
and making the system do what it’s supposed to do. In this case the system I
have designed will only require a minimum of additional resources. I designed
the system to work on their existing computers using their existing software.
The databases and the spreadsheet models could be built by knowledgeable
employees with minimal outside help. Once constructed the system could be run
and results compared with the old system to determine if it is functioning
properly. The results could also tell if the system is optimizing the schedule
or just speeding up what is already done manually.
Implementing any system is the process of putting it into use. In this project
the implementation phase should be a fairly easy conversion. The old way of
manually deciding on trips and putting the results into Calendar Creator is
simply replaced with an automated selection of trips that the employee can use
to create a calendar. When the system is operating normally it should improve
the way ITT does business.
After implementing this system it will have to be maintained. New models will
have to be added and old models will have to be changed or removed. With the
simple models used in this system that should not be difficult. The hardest
component in this system to maintain will be the databases. They will have to
contain the most current data in order for the system to operate properly. I
suggest a data checking module be added at some point in order to maintain data
consistency. Inconsistent data is something that can degrade the system
performance and cause it to give inaccurate or incorrect information. A data
checking module will insure that the information entered into the system is
accurate and consistent with the rest of the system.
There could be many solutions to this problem, but given the limited budget most
are not feasible. The system I have designed should be more than sufficient to
assist them in creating schedules faster and more efficiently. Also it will
give customers more of what they want and should improve repeat business.