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