Dissertation for PhD Degree in Information Systems: Facilitating Technology Adaptation in a Small
Company with Limited Resources
by David Barth, written in 1995
KW
Kennedy-Western University
Park Center Pointe
1459 Tyrell Lane
Boise, Idaho 83706
208/375-4542
800/635-2900
Fax: 208/375-5402
EXECUTIVE INDEPENDENT STUDY
FINAL PROJECT PROPOSAL
SECTION TWO
NAME: David V. Barth
Student I.D.# N11147
ADDRESS:
CITY: Lakewood
STATE: Colorado
POSTAL CODE: 80226-3047
COUNTRY: USA
TELEPHONE:
DEGREE: PhD
TITLE OF PROJECT: Facilitating Technology Adaptation in a Small Company with Limited Resources.
STATEMENT OF THE PROBLEM: A small company's increased business requires that it transition from a manual
invoicing system to one that is automated. The issue is how to accomplish this with limited financial and
personnel resources.
IMPORTANCE AND SIGNIFICANCE OF THE PROBLEM:
My topic is significant for many small companies who operate on manual systems, as did the one in this study, and
who do not appreciate the benefits of a suitable computer system nor know the challenges of installing such a
system.
SOURCE MATERIAL:
- Fortune Magazine
- Byte
- Datamation
- Compute
- PC World
- PC Today
- PC Computing
- Home PC
- Information Week
My Final Project Proposal is hereby submitted.
__________________________________________
Student's Signature
__________________________________________
Date: June 1995
Chapter 1
INTRODUCTION
Statement of the Problem
Many small businesses barely survive because their overhead costs require a major portion of their gross income.
In some cases, especially for start-up companies, the overhead costs may exceed the gross income during the early
part of the company's existence. To survive, small companies have to carefully manage their expenses, keeping
them as low as practicable while maintaining a sufficient level of customer service.
Solving the problem of expense reduction is usually an ongoing challenge for a company manager. He must think
in terms of how to keep costs low without causing the company harm. The employee morale, including that of his
own as well as his family's, must be maintained while, at the same time, the level of customer satisfaction must
be kept at a sufficiently high level to maintain loyalty. Company creditors must be kept happy by paying them on
time.
So, to keep a small company running smoothly, the manager must walk a tightrope, maintaining a balance between
the level of customer support and the cost of running the operation.
This is not easy for most small business managers. The successful approach often requires innovative solutions
and attention to detail. Often, business managers lack the required knowledge to implement modern solutions to
solve their business problems, and they can neither afford to pay consultants to provide the necessary expertise,
nor take the time to learn about them. Sometimes they do not know of the existence of a solution that is readily
available.
Of all the hurdles that businesses must overcome, this study addresses the possibility of enhancing a company's
information systems. Every business must maintain information systems. Examples include information used to
satisfy customer's needs; data to support federal, state, and local tax requirements; bookkeeping records to track
company performance; payroll information; accounts payable and receivable accounting; marketing information;
competitive data; and inventory tracking.
The media used for information storage may vary between systems depending on their size, their importance to the
operation of the company, how frequent the information is accessed, and the level of the manager's expertise.
The two primary types of data storage for the small business are paper and the computer. Prior to 1981, before
the advent of a reasonably priced computer, most small businesses had to rely solely upon paper-based systems such as
accounting ledger sheets to maintain their information systems.
Larger companies have benefited from a wider spectrum of data storage media including large (mainframe) computers,
mini-computers, networked computers, time-shared computer services, microfiche, microfilm, and various specialized
equipment such as proof machines and tabulating equipment. These companies have also used manual paper systems
and have embraced the small computer revolution as well.
Options for the small business are more limited than for larger, established organizations, and therein lies the
problem of introducing automated information systems. Initially, a small business may start out with all of its
data on paper or in the head of the manager. After operations have begun, that information is usually placed in
a formal system to meet various needs, for example, payroll. At some time after the company has been established,
automated data processing may be an attractive option to replace the manual information systems. It should be
noted that not all information systems should be converted to a computer. Depending on the usefulness of
information and the way it is used, it may properly and efficiently reside in the head of the manager or on
paper in accounting ledgers. It doesn't make much sense to place the names and addresses of a handful of
suppliers into a computer if that information can be more easily kept on a slip of paper. In the same way,
if a company has but one or two employees, the payroll data may be most conveniently kept on a ledger than
in a computer.
However, it is important for small businesses to be able to transition from manual, paper-based systems to a
computer when the advantages of automating are compelling.
Concept of the Study
This study was conceived to investigate the possibility of empowering the employees of a small business to automate
a manual system. The assumption is that there are many small businesses that could benefit by automating a manual
system, and their employees are the most knowledgeable and best qualified persons to evaluate and implement a
computer system to replace the manual system they have been using.
The benefits of converting a manual system could include fewer person-hours required to run the system, more
complete information, more accurate data, and faster processing of required reports. The positive aspects of
allowing company employees to implement the system themselves could be increased self-satisfaction derived
from having control over the selection and implementation of the system, a sense of ownership in the system
which could translate into a more proactive approach to solving its problems, higher morale as a result of
having more input to the operations of the company, and money saved that ordinarily would have to be spent
on consultants or the hiring of information system experts.
Better information could be provided by an automated system. An example is information provided by a manual
pay system compared to that shown by an automated payroll system. A manual payroll system might provide some
hand-written information regarding deductions from a pay check, but an automated system could give the employee
a neater accounting of pay history including an accurate breakdown of all deductions, year-to-date totals, and,
possibly, even a track of vacation and sick days used and available.
An example of cost reduction for the company would be increased efficiency found in running a system on a
computer as opposed to doing it manually. The payroll system can serve as an example. If a manual payroll
requires two hours per pay period of the manager's time, and an automated system cuts the time in half, a
time savings results, freeing the manager to address other concerns.
This study was designed to choose one manual system in one example company to determine if the assumptions
above are correct and find out if the process would be simple and straight-forward enough that it might be
replicated by other small businesses.
Importance of the Study
By using the procedures developed herein as a guide, it should be possible for many small companies with
limited financial resources and little computer hardware or software expertise, to achieve similar success
in automating manual systems. For small businesses that continue to use manual systems which could be
converted to a more efficient computer system, the results of this study may be a way to improve their
operation by helping them become more profitable and achieve improved customer service.
The positive affect on a company's operation includes a reduction in manpower required to operate the application
that is converted. This can translate to a reduction in overall expense to the company. If the result of
automation is fewer man hours required to run the converted application, that relieves manpower for use in other
areas that may benefit from extra help.
If the automated system provides more timely, more accurate, or better information for customers, then it can be a
positive advance for the company's level of customer service.
This study provided some outside assistance to the subject company to prime its employees to undertake the project,
but the approach was intended to be straight-forward and simplistic so that the results could be duplicated by other
companies with a minimal effort. The intent was to develop a cookbook approach to computer system
implementation.
Scope of the Study
The scope of this study considers the following areas, discussed in detail in chapter three, "Method."
- The selection of a subject company that is appropriate for the study was made. Although this project involves
only one company, it is hoped that the results will indicate some degree of applicability to many other small
businesses.
- The study of the company's existing manual information systems was made to be determine which one was a
candidate for automating. If none had been found, a different company would have to have been selected for
the study.
- The selection of computer hardware to support the conversion and implementation was made prior to the
selection of
software because hardware is more generic than software. While software functionality and capability may be highly
variable from product to product, hardware must adhere to rigid standards, and there are only two primary types:
IBM (and IBM compatibles) and Apple. Although hardware selection was an important element for this company,
businesses that already have a computer available will not require this step.
- The selection of software to automate the application followed hardware selection. To keep the study as simple
as possible, it addressed only off-the-shelf software, to be installed as written, and not modified or customized in
any way. Although the way the application was implemented might be modified, the actual software itself could not
because this study addresses how a small company can improve its information systems in an inexpensive way, and
changing programs or writing new ones can be very costly.
- After a candidate application software package had been identified, it was tested to determine if it operated
in such a way to accomplish the company's needs for the application. The selection of software and the subsequent
testing continued until a suitable package was found.
Had no suitable computer package been found, a different application would have had to be identified for conversion,
or another company would have to be selected for the study.
- The selected software was then implemented under the direction of company employees. If this had been
unsuccessful, the study would have had to be terminated with the results documented.
- The impact of the new software on the company was reported, from positive and negative viewpoints.
- The possible transference of the results of the study to other companies was addressed. Since the objective
of the study was to determine if a small company could move from a manual system to a computer system, with
resulting enhancements in performance and reductions in cost, the impact of the results on other small organizations
was considered.
- Finally, suggestions were made regarding possible future studies that would supplant this one by gathering
data about the information system situation in other small companies.
Hardware Trends
The following discussions of hardware and software trends provide general background for the study.
Since the advent of Apple Computer's first production personal computer in the late 1970s, desk top computers
have become less expensive and more powerful. The first IBM personal computer, introduced in 1981, had a CPU
that operated at a clock speed of 4.7 MHZ (4.7 million hertz, or cycles per second). It cost $5,000. Today,
computers running the CPU at 100 MHZ cost under $2,000.
The clock speed is the "ticks" or cycles that the CPU uses to perform whole or parts of instructions, measured
in millions of cycles (hertz) per second. Simple instructions require only a few clock cycles. The higher the
frequency at which the CPU operates, the more instructions that can be executed in a given period of time.
However, there is a physical limit to the frequency that a CPU chip will operate in the current technology,
just as there is a physical limit to the rpms that an automobile engine will turn. A racing engine might run
at ten or twelve thousand RPM, but forget about fifty thousand.
Whether the CPU limit is 500 MHZ or 1 GHz (one gigahertz, or a billion cycles per second), technology will
probably take a different approach to increasing computer processing speed. This approach will probably
involve an increase in "parallelism," the method of using two or more logic circuits to execute two or more
instructions simultaneously (Coffee, 1994). If it sounds complicated to imagine a program running, wherein
two instructions are being done at the same time by the CPU, it is. The logic of the computer must somehow
look ahead in the program and determine what instructions can be done at the same time, then set them up so
when it comes time to execute them, they are ready. The Intel Pentium chip does this on a small scale, but
the future will bring great advances in this area.
Theoretically, if enough CPUs were ganged together, say, one CPU for each instruction in the program, and the
instructions of a program were set up, ready for the CPU to execute them, a program could run in just a few
clock cycles, or in a 100 MHZ computer, it would be finished in only five or ten millionths of a second. This
is only an illustrative example. The attempt to bring many processors together to perform faster processing
was done long ago, in the mid-1970s when the University of Illinois, under a government contract, connected 64
Burroughs computers together to run in parallel, ostensibly, to run programs that were to compute one of the
most complex applications: weather modeling.
The PC owes its existence to one technological advance: Large Scale Integration (LSI), which is the ability to
mass produce small silicon chips, ranging in size from that of a fingernail to those larger than an Oreo cookie,
containing thousands or millions of transistors. The first commercially produced chips were designed to take the
place of thousands of transistors that constitute the CPU in a computer. (See "Hardware Historical Perspectives"
in Chapter 2).
The CPU is the section of the computer that consists of many transistors, and reducing the logic components to a
small size facilitated the development of the first PCS. The magnitude of this compression could be illustrated
by imagining thousands of separate transistors, each the size of the eraser on the end of a pencil, distributed
across two hundred circuit boards fitted into slots in a computer cabinet. The whole CPU assembly might require
twenty or thirty cubic feet of space. In addition, each board had to be connected to others by many wires. This
is the configuration that 1960s vintage mainframe computers used, and each computer was nearly hand-built, and the
manufacture of boards was largely done by hand on production lines staffed by assemblers. The construction of
just one mainframe computer might require many weeks. The resulting cost of such a computer was in the millions
of dollars.
Not only has the CPU circuitry been compressed into chip form, other logic circuits in the computer have also been
redesigned into chips, so that most transistors in current PCS reside inside either the CPU or some other chip.
These non-CPU chips are usually smaller than the CPU. Chips will be found on the main board, as the CPU is, on
controller boards that plug into the main board, and on various hardware components themselves, such as hard disk
drives, floppy drives, CD ROM (compact disk, read only memory) drives, and other components.
The original chip design used metal connectors protruding that looked like legs, giving them the look of short
centipedes. The metal "legs" fit into small sockets mounted on the board by pressing the chip down into the
socket. The advantage of this approach was that the chips could be easily pulled out and replaced. This
advantage was particularly important in the days when even non-CPU chips were expensive, sometimes costing
hundreds of dollars, and their reliability was not what it is today.
In the mid 1980s, the chip mounting technology changed to "surface mounting." The surface mount chips are
flatter, usually square, and their legs are small wires that come out all four edges of the chip. The chip
is mounted flat on the board with the wires soldered to the appropriate junctions on the circuit board.
Surface mounting technology lends itself to automation, and most boards are mass produced on robotic assembly
lines.
As a result of mass production feeding an ever growing market, instead of a production run of a few thousand
circuit boards in the early 1980s, now, many boards have runs of several million. The impact of these large
runs is that, although the first board to come off the assembly line may cost many millions of dollars, the
average board price for the entire run puts the price in the tens of dollars, effectively making the board
disposable.
No longer do computer technicians repair a circuit board at the component or chip level. They go only to the board
level, simply throwing away a board that tests bad, even if it is a main board. It is less expensive to replace a
board than spend money on parts and labor to try to repair it. In addition, the new board will have a new warranty
and all new parts, a situation that one would not have with a repaired board.
The future of the personal computer has been discussed by computer experts for years. When IBM designed the first
PC, it only allowed for one million bytes (characters) of addressable memory. This was done for marketing reasons.
IBM's marketing philosophy in mainframe computers extended to their PC. More powerful and more expensive lines were
planned, but clone makers jumped into the market, developing "work-arounds" for the deficiencies of the PC,
increasing the allowable memory to 64 MB or more. The first PC had standard memory of 64 KB, expandable up to 640
KB of user memory, and, with control memory, the total was 1 MB.
PC memory, as with most computer memory in mainframe and minicomputers, loses the data stored when the power is
cut off. Computer memory exists only by virtue of the power supplied to it. Technology is attempting to find a
way for data to be retained in a memory chip when the power is cut off. This advance will cause a giant leap in
computer operating speed, because it will open the door to replacing the relatively slow hard drive with much
faster memory. Imagine removing the mechanical hard drive that contains spinning disks, and replacing it with a
block of memory that has no moving parts and operates hundreds of times faster than the hard drive.
The first PC didn't have a hard drive for storing data. Data was stored only on floppy drives. The "extended
technology" XT was simply a PC with a hard drive added to it. Early hard drives could hold only 5 MB and they
cost more than $1,000. Large modern hard drives have a capacity exceeding two GB (gigabytes, two billion
characters), and the cost is around fifty cents per megabyte, or around $500 per GB.
The trend in main board size is to continue combining and shrinking components so that main boards are becoming
smaller. In addition, add-on boards that plug into the main board are shrinking, too, and some add-on boards are
being built with multiple functions such as combining hard drive, floppy drive, and CD ROM drive electronics on
one add-on controller board.
This down-sizing has paved the way for the lap top computer. Lap top computers are the future. They will not be
able to compete with desk top PCS until they can do several additional things:
- Lap tops need a fold-out, full-size keyboard. Keys can get smaller and more densely arranged on a keyboard,
but fingers cannot get smaller to accommodate them. Lap tops usually have a plug so that a full-size keyboard may
be attached, but that is a poor solution. The need is for a big keyboard that folds up.
- Lap tops need to have at least eight slots available to plug in various add-on cards, just like desk tops
have. The PCMCIA card (the latest model is called "CardBus") technology uses credit card-sized add-on boards,
but these have not been well developed yet, and there aren't enough types available (Seymour, 1994). This
technology is improving, however. Examples of add-on cards that are available for desk top PCS that should
be available for lap tops are sound cards, CD ROM cards, fax/modem cards, video cards, drive controller
cards, etc.
- The monitor situation with lap tops has always been a problem. The most expensive lap tops costing more than
$4,000 have good color monitors. A standard monitor can be plugged into most laptops, but, like plugging in a
full-size keyboard, that is a poor solution. The best solution would be a folding monitor that could present a
large viewing area.
- Lap tops need to have commonality of peripherals so that a hard drive, floppy drive, or CD ROM drive can
be purchased from any computer store and slipped into the unit, much as is done with desk top computers
today.
As for the desk top PC, monitor technology is moving toward flat screens, similar to those used in lap tops.
Cost is holding them back, but some day, the heavy, power-hungry, bulky monitor will be replaced by a thin,
lightweight, large monitor that looks like a picture and can sit on the desk or hang on the wall.
The physical size of the desk top computer will shrink, too. Originally, diskette drives used eight-inch diskettes.
Then came the 5 1/4 inch diskette drives, and the current standard is the 3.5 inch diskette drive. Consumers seem
to do funny things at times, but there is always logic behind their actions. For example, the two-inch diskette
drive was introduced several years ago, but it never became popular. The reason is that it is so much like the 3.5
inch drive, only a bit smaller. The change from the 5 1/4 inch drive to the 3.5, was much more significant. The
5 1/4 diskette is flexible and easily damaged. The improvement in the 3.5 inch diskette is that it is encased in
a hard plastic case and is small enough to slip into a shirt or pants pocket without worry of damaging it. The
advent of the 2 inch floppy was no great improvement over the 3.5 inch model because it was simply smaller,
without any other great advances. So, the 2 inch drive has not become common.
Multimedia computers are now the rage. They are the same as any other PC except that they have a CD ROM drive, a
sound card, and a pair of external speakers. PCS have an internal speaker built in to the case, but it is small
and does not provide high-quality sound.
The CD ROM drive came about as an off-shoot of the music compact disks where the data was stored in very high
density, in digital form, on disks that are not easily damaged.
Computer manufacturers began building CD ROM drives that could use the CD technology. Instead of storing music
on the disks, computer manufacturers digitally store data such as encyclopedias, text from books, educational
information accompanied by video pictures and speech and music, some of which are animated, and groups of
programs that, otherwise, would require storage on dozens of diskettes. Many CD ROM drives will play audio
compact disks, and the latest models are compatible with the photographic compact disk technology that Kodak
has developed.
The future will bring more compact, faster CD ROM drives and the ability to write and delete, just as can be
done with diskettes. Eventually, CD ROM disks will replace diskettes. They will come in the current size and
a smaller size, both compatible with the same drive unit, and they will have read and write capability.
The advantage of CD ROM is its great capacity. CD ROM disks currently hold around 650 MB of data compared to a
maximum of 1.2 MB for 5 1/4 inch floppy and 1.44 MB on a 3.5 inch diskette. Future technology will provide at
least one smaller size of CD ROM, and higher density storage is probably coming soon.
As for a major philosophical design change, that is probably not likely within the next ten years. When IBM
came out with the original PC, it planned to bring out newer technology computers to follow it, if their marketing
strategy in the mainframe world is any guide. However, there is always a conflict between new hardware architecture
and the software that has been running on the old architecture machines. For IBM, that was never a consideration.
IBM was big enough to simply change the hardware and let the software houses convert their old software to fit the
new computer. When the clone makers entered the market in the mid-1980s, a power shift occurred. IBM was no
longer the dominant force in the PC industry. Software to run on the open architecture IBM computer was easy to
write because IBM had made the internal logic operation public so that a plentiful supply of software would become
available for IBM computers, making them more desirable. This ploy backfired when the IBM compatible manufacturers
jumped into the market.
There are many small companies and few larger ones, like Compaq and Packard Bell, manufacturing IBM compatibles.
However, no one manufacturer has the power to introduce a new architecture that would require the software makers
to redo their programs to run on it.
The hardware makers have simply taken the old 1981 PC technology and produced faster, higher capacity computers,
using work-arounds to address architectural shortcomings like the above-mentioned 1 MB limit. There are newer
technology computers, called workstations, that use RISC (reduced instruction set) technology, made by Sun,
Hewlett Packard, IBM, and others, that won't run PC software. These computers are much more powerful than
any PC in use today, but they cost five to ten times as much, and the fact that they won't run popular software
has left the public uninterested in them. These workstations are in use by companies and computer centers that
need a lot of computer power for a network of computers. They are sometimes used as terminals for mainframe
computers. So, RISC workstations have a place, but for now, it isn't with the general public because it desires
computers that will run the many thousands of software programs on the market. (Coffee, 1994).
The only thing the hardware manufacturers have been able to do is to continue increasing the power of the PC.
It is possible its power will eventually supersede that of the RISC workstations. Prices continue to plummet
as the cost of compute power halves every eighteen months (Spears, 1995).
Software Trends
With the future of IBM compatible technology expected to remain unchanged for the foreseeable future, the software
houses are continuing to turn out software for PCS. There are changes in the overall "look and feel,"
however.
When Microsoft introduced Windows to compete with the graphical user interface (GUI) that Apple had pioneered, many
computers were too slow or lacked sufficient capacity to run it well. Many computer programs designed to operate
with Windows ran slowly. Users who wanted a speedy program often chose standard "DOS" programs that ran with the
DOS operating system instead of with Windows. (See "Software Historical Perspectives" in Chapter 2).
This situation was simply that software development had gotten ahead of computer power, and it helped spur the
demand for more powerful computers. Most users like Windows because it provides a standardized way that programs
interface to the user. The "look and feel" that Windows programs provide, enables users to more quickly use Windows
programs because they work in a similar way to other programs that run under Windows.
Before the development of Windows, all programs ran under DOS, and most were "text-based" in that they interfaced
with the computer user through statements or questions printed on the screen. With Windows, however, programs
communicate with small "windows" that pop onto the screen to guide the user when it is necessary to obtain some
input. The use of these small "windows" is where Windows got its name.
Windows and the programs that run with it use graphics instead of lines of text. The colorful graphics are often
little pictures of functions that can be accomplished by the user, and other pictures like slide switches for
adjusting mouse sensitivity, for example, radio buttons that resemble push buttons on a car radio, and other
graphical devices that help the user understand the application better.
Some software houses have elected to develop their software for DOS, and in doing so, provide some graphical
pictures and little windows in the DOS environment. The trend is for DOS programs to be written for Windows
because more users are running other applications in Windows. Some software is available in two versions: one
for DOS and one for Windows.
Another trend is larger programs and more of them within an application. For example, Novell WordPerfect 6.1 for
Windows requires 32 MB to be available on a user's hard drive before it can be installed. With DOS and Windows
requiring close to 30 MB, the need for larger hard drives is obvious. No longer can a user that has DOS and
Windows get by with a 40 MB hard drive if he wants to run many software programs. His hard drive will simply
run out of space. This is causing an increase in demand for larger hard drives, and prices for them are
currently less than fifty cents per MB, and likely to fall as more of them reach the market.
Software prices are dropping as competition heats up between software providers. There are a limited number of
types of business applications, but more come on the market each year.
Larger software packages are now coming out on a single CD ROM disk instead of several 3.5 inch floppy diskettes.
This makes it much easier to load large programs because one CD ROM disk may be loaded instead of having to load
and unload many floppies.
Commercial Software houses are beginning to compete with each other by offering lower prices for "competitive
versions" and "upgrade" versions. Often the same program is used for both the competitive version and the upgrade
version. The way this marketing approach works is that a person who uses an older version of the new product or
is using some other vendor's software, can purchase the upgrade version for a lower price than the buyer who
isn't using an old version of the same product or a competitor's software.
With the introduction of computer viruses in the mid-1980s, software houses changed their approach to packaging.
Now, all software comes out of the factory shrink-wrapped to attempt to foil persons who might be tempted to
introduce an infected diskette into a commercial software package.
Software that is provided on CD ROM drives is not susceptible to tampering because it is read-only, and cannot
be written upon. It isn't possible to add a virus to a CD ROM disk. However, it is possible to create a new
CD ROM disk, copying the programs from the original disk along with the virus, but the effort and cost to
accomplish that task would seem to reduce the probability of someone attempting it.
Software viruses are still a worry for the computer user. The vulnerability increases when the user downloads
software from a bulletin board or loads a floppy diskette that is not an original, but a copy of an original
diskette. In these circumstances, it is possible that someone may have infected the program with a virus that
can cause the machine to act strangely, or, at worst, render it inoperable until a technician eradicates the
virus.
Most shareware vendors, bulletin board operators, and commercial software houses run virus checks on all software
before allowing it to be distributed. Windows and Norton Utilities now come with a virus check program that
alerts the user if a virus is found. There are also companies that specialize in virus protection and removal.
The trend toward larger software packages is driving the power of computers. As software developers add more
functions to their packages, users are forced to upgrade or acquire a more powerful computer.
Games are some of the fastest growing software packages. They have gone from text-based, monochrome software to
those featuring color, sound, full-motion graphics with 360 degree viewing capability. This trend continues as
new games are coming out with three-dimensional graphics displayed through a head-mounted viewing device.
Eventually, virtual reality will provide the capability for a user to simulate a realistic impression of a far
away or imaginary locale by software that requires a very powerful computer.
Definition of Terms
The following terms have been defined to attempt to reduce obfuscation common in technical discussions, particularly
those in information systems. An effort was made to present all computer-specific terms used in this study as well as
some that might be useful to the reader.
To keep the flow of the text smooth, the traditional masculine form is used throughout, but it is intended to pertain
to both sexes.
Adapter Card. An auxiliary logic board that plugs into the main board of a computer. Also referred to as
"Add-on Board" (Sachs, 1984). (See Main Board).
Application. A specific information system, be it manual or computerized, that performs a function. Examples of
business applications are Invoicing, Accounts Payable, Accounts Receivable, General Ledger, Fixed Assets, and
Inventory.
Assembly Language. Also known as "Assemblers." A language used by a computer programmer to create instructions
for a computer to operate. Assembly languages are manufacturer-specific and cannot be used on another
manufacturer's computer. Assemblers are a higher level language than machine language because they use mnemonic
symbols (ADD A, 9) instead of binary codes (1011100000001001). Also, one assembler statement may generate many
machine language statements.
Assembler languages have been superseded by higher level, more productive languages such as compilers which allow
the programmer to write fewer instructions. Although used little at the present, the advantage that assemblers
have over compilers is that programmers can use them to eliminate non-essential instructions that compilers
sometimes generate, speeding up the operation of a computer for critical applications such as those used in
airline reservation systems where thousands of transactions are processed each second.
In the hierarchy of languages, assemblers fit between machine languages and compilers (Claus & Schwill, 1992).
(See Machine Language and Compiler).
AT. A computer designation that represents "advanced technology." (See XT and PC).
Byte. The storage space required in a computer to hold one character of information. For example, "A," "1," "%,"
"$," and "q" each require one byte of storage. (See KB, MB, GB).
CPU. Central Processing Unit: the "brain" of the computer that controls all operations. Until the development
of the first large scale integrated circuits, called "chips," consisting of thousands of transistors, the central
processing unit consisted of individual components (Claus & Schwill 1992).
Until 1958, these components were vacuum tubes (Forkner & McLeod, 1973). Between 1958 and 1975, thousands of
individual transistors were assembled on many plastic boards, sometimes numbering in the hundreds, to make up the
CPU. This architecture was very expensive to produce, requiring a large computer unit with a lot of wiring between
the boards, prohibiting most individuals from owning a computer.
In the mid-1970s, engineers developed a way of putting thousands of transistors into a "chip" slightly smaller than
a package of Lifesavers. Advances in technology have resulted in the Pentium CPU chip containing ten million
transistors.
CD ROM. This is an acronym for "compact disk, read-only memory." It is the computer version or the music
variety of compact disks except that data is stored on the disk which has a capacity of 650 MB. CD ROM disks
require a CD ROM drive. Many new CD ROM disks are being introduced because this technology is the core of
"multi-media" computers. (See Multi-media).
Clone. (See Compatible).
Commercial Software. This software consists of one or more computer programs that are copyrighted and sold through
retail outlets instead of being distributed free of charge as are shareware programs. Unlike shareware, commercial
software cannot legally be copied and redistributed by anyone except the manufacturer and its licensees. Some
commercial software is copy-protected to thwart unauthorized distribution of the product.
Stringent laws protect the copyrights of commercial software houses just as they protect authors of works written
in other media such as books (Stagner, 1988). (See Giftware, Public Domain Software, and Shareware).
Compatible. A computer that operates like a computer built by an original manufacturer (e.g. IBM or Apple). That
means it will operate like the original computer and will run the same software. For example, there are IBM
compatibles and Apple compatibles. The term "compatible" generally refers to IBM compatibles.
In the early to mid-1980s when true IBM Personal Computers were in short supply, IBM compatibles came on the
market to satisfy the demand (Dodge, 1994).
Packard Bell and Compaq are companies who manufacture name-brand computers that are compatible with IBM personal
computers. Many foreign manufacturers, particularly in Asia, build generic IBM compatibles that may not even
have a name plate on them.
In the mainframe computer environment, Amdahl manufactures compatibles for large scale IBM computers. This term
can also apply to computer peripherals that are compatible with an original manufacturer's equipment such as
printers and disk drives (Claus & Schwill, 1992).
Compiler. A high-level computer language used by programmers to write computer programs. Compilers are generally
platform independent in that they can usually be run on computers of a variety of manufacturers. Examples are
Cobol, Fortran, C++, Basic, Pascal, and newer, highly developed compilers called Fourth Generation Languages
(4GL).
Each compiler statement generates many machine language instructions. In the hierarchy of languages, compilers
rank at the top of the list, above assemblers and machine language. Compilers allow the programmer to write fewer
instructions because they are able to generate the necessary machine language instructions from one compiler
instruction (Claus & Schwill, 1992). (See Machine Language and Assembler Language).
Context Sensitive. This usually applies to help information or documentation that is specific to the location in the
program where additional information was requested. For example, if a person is entering a date into a field in an
input screen and wishes to know what the format of the date should be, if the program can provide context sensitive
information, a request for additional help can show the format in which the date should be entered.
Cybernetics. The broad meaning refers to the study of systems: organic and man-made. In data processing circles it
means the study of computers (Claus & Schwill, 1992).
Database. A group of files that may have some common fields between them for reference purposes. For example, a
customer file may have links to an inventory file so that each customer record is not required to hold repetitive
inventory information such as the description of the item.
To go a bit farther, a customer record may have inventory part numbers that refer to parts in the inventory file.
If a person desires to list the customers and a complete description of the inventory ordered during the past month,
he may simply instruct the Database to print the customer information, then take each part number on the customer's
record and print the associated inventory descriptions. In this way, duplication of information is reduced because
each customer record does not need to carry a duplicate of the full description of each inventory item ordered, only
the part numbers.
A Database program usually provides a variety of ways of selecting and sorting records to be displayed or printed
(Claus & Schwill, 1992).
Disk Drive. (See Floppy Drive and Hard Drive).
Floppy Drive. A mechanical device that reads and writes information to a removable floppy diskette by spinning it
next to sensitive read/write heads that transfer information between the computer and the diskette. Two drive sizes
are common: 5 1/4 inches and 3.5 inches. Maximum capacity varies according to the type of drive, with capacities at
1.2 MB for 5 1/4 inch drives and 1.44 MB for 3.5 inch drives. Drives are usually capable of reading and writing
diskettes with a lower capacity, but not those with a capacity higher than the capacity at which the drive is rated
(Connell, 1987).
Freeware. (See Shareware).
GB. This is the abbreviation for gigabyte, or billion bytes. (See KB, MB, and BYTE).
Giftware. Giftware is the term for free sample demonstration software that has one or more features removed compared
to the full-featured commercial version. Duplication and distribution are authorized. Giftware is usually accompanied
by an offer to purchase the complete commercial software package (Stagner, 1988).
Graphical User Interface. Abbreviated "GUI" (pronounced "gooey"), it is a means of showing program options on a
computer terminal screen as pictures (icons) that may be selected using a pointing devices such as a mouse.
(See Icon).
GUI. (See Graphical User Interface).
Hard Drive. A mechanical device that is sealed, typically containing one or more non-removable disks inside.
Similar in concept to a floppy drive, a hard drive uses read/write heads to transfer information between the
computer and the drive. Hard drive capacities vary with the number of internal disks (sometimes called "platters"),
the density at which data is written on them, and whether both sides of the disks are used. Current capacities
vary from 40 MB to more than 4 GB (gigabytes or billion bytes) (Glass, 1991). (See Byte, KB, MB, and GB).
Hardware. This is the computer "machinery" that runs the software programs. It includes the computer and any
peripherals connected to it such as a printer (Claus & Schwill, 1992). (See Software and Peripherals).
IBM Compatible. (See Compatible).
IS. This is the common abbreviation for "Information Systems," which often refers to the department in a large
company charged with managing and supporting its computer and information assets.
Icon. A picture that represents a program function used to select the activity by clicking a pointer such as that
provided by a mouse or track ball. Icons are usually associated with graphical user interfaces (GUI) that attempt
to make a program easier to use by presenting options with the use of pictures (Glass, 1991). (See Graphical User
Interface).
IDE. This is the abbreviation for "integrated drive electronics." It is the most common technology for hard
drives and provides much of the control circuitry to be mounted on the hard drive itself instead of having all
of it mounted on the controller board as it was in older technology. (See Hard Drive).
Information System. This is a generic noun referring to any system, manual or computerized, that is used to
process an application or provide information. "Information system" is sometimes used interchangeably with
"application" and "software." (See Application and Software) (Claus & Schwill, 1992).
KB. This is the abbreviation for kilobyte, or thousand bytes. (See MB, GB, and Byte).
LAN. (See Local Area Network).
Local Area Network (LAN). A physical connection between two or more computers located near each other, one of
which acts a server or host (a "master" personal computer that is more powerful and possesses enough memory and
disk storage capacity to meet the needs of the network). The server contains the files used by all of the
computers on the LAN so that each computer won't be updating independent files that will have to be merged
later to create a master file. A LAN is applicable where several users need to operate a single software
system at the same time, using different computers. LAN hardware consists of an adapter card that fits
into each computer, the wire that connects all of the adapter cards, and the software to operate it.
(See Server).
Machine Language. A language written in binary code, used directly by a computer to execute instructions such as
"move" and "add." Consisting of strings of ones and zeros, these instructions are the lowest level instruction
type because the computer executes them directly.
Higher level languages, assemblers and compilers, allow for greater programmer productivity because the assembler
or compiler generates many machine language instructions for each instruction written by the programmer. For
example, the single compiler statement written by a programmer, "Write Record to Disk," might result in the
compiler generating ten or more machine language statements to accomplish the task of writing a record. A
compiler statement is written using more meaningful codes such as "ADD" or "MOVE."
Machine languages are manufacturer-specific and cannot be used by another manufacturer's computer (Claus & Schwill,
1992). (See Assembler Language and Compiler).
Main Board. The primary circuit board in a computer into which adapter boards plug. The main board is often
called "mother board." It usually contains the primary computer logic, control circuits, CPU, and memory.
(See CPU and Adapter Card).
Mainframe Computer. The largest, most powerful type of computer. Originally created in the 1940s, as
miniaturization improved, it was joined by the minicomputer in the late 1960s and the personal computer
in the late 1970s. (See Personal Computer and Minicomputer).
MB. This is the abbreviation for Megabyte, or million bytes. A byte represents one character (Connell, 1987).
(See KB, GB, and Byte).
Memory. Typically, temporary storage in a computer. Random access storage (RAM) loses its data when the power
is removed. It is the fastest means of storing and retrieving information, and program instructions may be
executed from memory (Claus & Schwill, 1992).
Microcomputer. (See Personal Computer).
Minicomputer. Smaller and, in general, less powerful than a mainframe computer, it became feasible as a result
of efforts in computer component miniaturization during the late 1960s. In the hierarchy of computer size,
minicomputers are between mainframes and personal computers. (See Mainframe and Personal Computer).
Mother Board. (See Main Board).
Multi-media. Typically, a computer that has a CD ROM drive, a sound card, and speakers. The CD ROM titles that
fall into the category of multi-media often display pictures, sound, or moving picture clips with or without sound.
The term "multi-media" refers to the ability of a computer to show motion pictures, still photographs, and sound, as
well as text. (See CD ROM).
NCR forms. "No Carbon Required" multi-part forms that are designed to cause an image formed by pressure on the
front form to be duplicated through subsequent forms.
Network. (See LAN).
PC. A computer designation that represents "personal computer." It is a generic term as well as the model of the
first IBM computer introduced in 1981 (Connell, 1987). (See AT, XT, and Personal Computer).
Peripherals. Strictly speaking, any computer component used as an input device or output device, including
keyboard, monitor, hard drive, floppy drives, pointing device (mouse, track ball, joy stick, light pen), printer,
CD ROM drive, speakers, and scanner, to name most of the popular peripherals (Claus & Schwill, 1992).
Personal Computer. Personal computers became feasible in the mid 1970s, when technology was advanced to the stage
that the "brain" of the computer, the central processing unit (CPU), consisting of thousands of transistors, could
be combined into a single unit. The unit became known as a CPU "chip," and current models are about the size of an
Oreo cookie. This giant step in miniaturization allowed for the computer's logic assembly to be sized to fit on a
plastic sheet or "board" slightly larger than a foot square.
This advance meant that a low-powered computer, built around this small main board (also called "mother" board),
could fit into a small cabinet that could sit on a desk. The CPU chip, model number 8086 (and subsequently, the
8088), was developed by a small organization that became Intel, the world's largest CPU chip manufacturer. This
development, alone, made the personal computer possible. As had been done with the CPU, other logic circuits were
converted to chips (Claus & Schwill, 1992). (See CPU and Main Board).
Pixel. Modified abbreviation for "picture element." A pixel is a dot on a computer monitor screen. The
definition that a screen can provide is determined, in part, by the density of the dots. Current technology
provides the highest definition of .26 mm. The average monitor has .28 mm between dots (Claus & Schwill,
1992).
Program. A group of computer language instructions that accomplish one or more tasks. Programs vary in size from
a few instructions to many thousands. Programs may be grouped together to form a system, although the following
terms are often used interchangeably: program, system, package, and application. These terms may be preceded by
the word "software" (Claus & Schwill, 1992). (See Application and System).
Public Domain Software. The author of this software has released the copyright for it. Copying and distributing
it are allowed. Any costs involved are to cover the copying, shipping, and handling, not the software itself
(Stagner, 1988). (See Shareware, Commercial Software, and Giftware).
RAM. Acronym for "random access memory" that is the primary memory in a computer. Typically, it loses its
storage ability when power is removed (the computer is turned off). Computer programs are executed from RAM
(Claus & Schwill, 1992). (See Memory).
Server. A "master" computer that forms the central part of a Local Area Network (LAN). Because the files used by
the other computers on the LAN reside on the server, it must possess enough speed and capacity to send, receive,
and process data between it and the other computers on the LAN. (See LAN).
Servomotor. The main component of an analog computer. Properly "ganged" together, servomotors can do the two
basic arithmetic functions of a digital computer: addition and subtraction. (In both analog and digital
computers, multiplication is simply a function of many additions and division is accomplished through many
subtractions.)
Analog computers are now used only in very specific applications requiring their specialized capabilities.
They have lost desirability as general purpose computers because, unlike digital computers, they are less
accurate, require periodic alignment, are prone to mechanical failure, are bulky and heavy, and require much
more energy to operate, given the same assignment.
Shareware. "Free" programs, usually written by individuals or small groups who request a voluntary payment
if the user decides to use the software. Sometimes incorrectly called "Freeware," shareware exists because
of the monetary support provided by users to developers.
Some shareware programs are a sample of the full-function commercial software package that may be purchased
from the shareware vendor. Less than fully-functional shareware is sometimes irreverently referred to as
"crippleware." Most shareware is fully functional. The authors encourage duplication of the software and
rely on the honesty of the user to forward payment, which typically ranges from $10 to $50, if he elects to
use the product.
Shareware provides the user a chance to try out programs for a small fee of a few dollars to cover copying and
distribution costs (Stagner, 1988). (See Commercial Software, Public Domain Software, and Giftware).
Software. A generic term that is applies to computer programs, systems, packages, and applications. The word
"software" often precedes these terms. These terms are often used interchangeably to refer to the computer
instructions that enable the computer to accomplish tasks (Claus & Schwill, 1992). (See Shareware, Public
Domain Software, Giftware, Commercial Software, Program, System, and Application).
Transistor. Developed in the late 1950s, the transistor replaced the vacuum tube in digital computers and became the
primary basic unit in computers, heralding the second generation in cybernetics (Forkner & McLeod, 1973). Originally,
transistors were mounted singly on computer boards, but technology eventually enabled them to be grouped together in a
single block of silicon, forming a large scale integrated (LSI) unit or "chip" (Bentley, 1984). (See Personal
Computer and CPU).
Vacuum Tube. Vacuum tubes were predecessors to transistors in digital computers. They look like large light bulbs
and can achieve the two states required by digital computer logic circuits: "on" and "off."
Computers built using vacuum tubes required a large room, had thousands of them, required massive air conditioners to
keep the components cool, and needed constant attention to replace them when they burned out (Forkner & McLeod 1973).
(See Transistor and CPU).
Virus. Instructions deliberately inserted into a program to make the computer act strangely or disable it
altogether.
XT. A computer designation that represents "extended technology." The XT was introduced in 1985 and is now
obsolete. (See AT and PC).
Chapter 2
REVIEW OF RELATED LITERATURE
Introduction
The literature survey concentrated on approaches to implement a computer system and associated software. The
writings of primary interest related to smaller companies and the potential problems they face. Additional
topics that gained attention included involvement of users in implementation efforts and the relationship
between project success and their taking ownership in the system.
After it was determined that there was a manual system in the company that could be converted to a computer
system, the hardware and software aspects were considered. Historical perspectives that have made computing
power available to small businesses were researched to add background to the study. A logical extension of
the historical look was reviewing prognostications of near-term advances, important in order to make a good
decision on the type of hardware and software to acquire.
Attention was paid to sources of computer definitions to provide documentation of some of the common technical
terms related to the study. Although technical terms are used in this text, an attempt has been made to make
the meaning of the ideas understood in the context of the discussion. The inclusion of a broad scope of
technical definitions is provided as an aid to readers who might benefit from a ready reference of terms
related to the subject of the study.
Personnel Considerations
In an article in PC Week entitled, "Don't Underestimate the PC Kitchen Cabinet," the author says the general
attitude of information systems (IS) managers is changing in regard to users of personal computers. In the
early days of small computers, corporate users of PCs were nearly ignored by their information system departments.
The current trend is to invite them to join the software selection team (Seymour, 1992).
Seymour recommends that the software selection group resemble the "kitchen cabinet" of friends and advisors
whom President Jackson brought together informally in 1829 to work on problems and discuss ideas. He says
users are the most knowledgeable about the software they need to do their jobs. They can provide a means of
building consensus within the company. Instead of the selection process taking place wholly within the IS
department, by bringing in users, the process is opened to the mainstream of the company, providing a more
open forum and resulting in a better choice of software.
By bringing users into the process, they become engaged in the purchase, testing, implementation, and support
of the system. They receive a sense of importance and they become the eyes and ears of management as well as
its voice for the merits of it (Seymour, 1992).
In his book, Office Automation: The Productivity Challenge, Chorafas (1982) has a section addressing "The
Cultural Perspective." He contends that with sufficient attention to the personnel factor, a conversion from a
manual to an automated system does not have to be traumatic and that reducing resistance by the user staff is
very critical if the software is to be accepted by the establishment. The truth of this assertion is paramount
for this study.
Richard Sharland (1991) writes that users should be involved during all aspects of requirements definition. Their
association with the development of the framework of the new system will provide the company with specific needs to
be met by the new system. Another objective is that the users will begin to take ownership of the system as it is
designed and built.
A key observation that Shamlin makes is the importance of user involvement in the selection, acquisition, testing,
and implementation process. She says that if they are involved, workers begin to take ownership of the software
early and help insure its success. Her view on user involvement agrees with Chorafas' (1982) view which supports
the need for user involvement in bringing a new software package to a small company.
A contrasting viewpoint presented in "Management evaluation of software packages" (1985) (no author listed) is that
users need not take part in the selection, evaluation, or development of software packages. Instead, users should
be trained to accept and use the new package. This book observes that, initially, some employees will accept the
new software and some will not. It asserts that one of the primary objectives of the training is to answer employee
concerns regarding the new package so they will accept it.
This view is of interest because it highlights the difference between information system facilities in large
companies to those in small companies. In the era prior to the advent of small, inexpensive computers, mainframe
computers were the common means of accomplishing automation within a company. Typically, users were not involved
in all aspects of designing, implementing, or testing a software package. Instead, that was the role of the
information systems department. If any users did not readily accept the new package following its implementation,
and training was not successful in changing their attitude, then they were either made to work with the new package,
or they were transferred to another area within the company, they were terminated.
A major assertion of this study is that due to limited manpower and financial resources, a small company must involve
the users from the beginning of a project through the final implementation to try to guarantee success. This is in
contrast to the approach proposed in "Management Evaluation of Software Packages," discussed above. Such a philosophy
may work in large organizations where employees are plentiful and easily replaced, but not in a small organization
where knowledge of an area in the company is critical to its operation and trained employees are not easily
replaced.
In Connell and Shafer's "The Professional User's Guide to Acquiring Software" (1987), the viewpoint is from that of
a medium to large organization that writes its own software. This approach is interesting because, if read and
believed by the manager of a small company, there would seem to be no possibility of obtaining a personal computer
package without a great expense. It describes software for personal computers in the same context as that written
and maintained for mainframe computers: that an in-house staff of information technology professionals is necessary.
To make matters appear even less tenable for the small business, Connell and Shafer assert that the skills of each
professional should include expertise in the following areas:
- Advanced networking
- Sophisticated hardware communications
- Knowledge about personal computers manufactured by many companies
- Background in operating system administration of many companies
- Knowledge of consulting
- The ability to quickly learn new computer languages
In defense of this view, it was developed before the flood of excellent and inexpensive software packages.
A small company should not need personnel who have the above qualifications to implement a successful software
package.
For example, advanced networking expertise is needed only if a company desires to install a local area network
(LAN) that connects one or more personal computers to a server (a "master" personal computer that is more powerful
and possesses enough memory and disk storage capacity to meet the needs of the network). And even if a small
company does desire to set up a network of two or three computers, modern, easy-to-use LAN software for small
installations is available. In most cases a user can be educated to administer the LAN simply by reading the
instruction book that is provided with the kit. Difficult problems must be referred to an expert, but, again,
for simple installations, problems rarely arise.
Knowledge of "sophisticated hardware communications" might be necessary in an organization that has a mainframe
computer, but for a small company, even if it uses a small LAN, such knowledge is not necessary. For companies
that choose to set up a LAN, a source of expert assistance should be identified so that a consultant can be called
to handle difficult problems if they do arise.
Knowledge about computers manufactured by many companies isn't necessary. Knowing enough about the selected
hardware to get a software package up and running should be sufficient. This basic knowledge is available from
many sources including local colleges, adult education centers, and many computer stores. Most cities have one
or more training companies dedicated exclusively to teaching the basics of computers.
If a company develops a relationship with a computer store, that store may provide answers that eliminate the need
to hire an expert consultant. By the same token, expertise in operating many different computers is not needed.
If the purchaser of software needs to know enough to get started, that information is usually provided with the
general information about the hardware.
If consulting expertise is applicable in any organization that does not do consulting itself, it is for larger
companies that want members of the information systems staff to interact with users as though they were consulting.
Generally speaking, knowledge of consulting is not necessary except where that line of work is the purpose of the
company.
The ability to learn new languages quickly probably only applies to consultants. For the purposes of this study,
a small business will have no need to know any languages. Employees of a software house or a larger company that
has the resources to write its packages in-house, will want to hire people who are literate in the languages the
company uses to develop its software, but the need to be able to learn other languages quickly is rarely necessary
except, once again, in a firm that specializes in software consultation.
Breslin (1986), in his book "Selecting and Installing Software Packages," states that when a company decides to
convert to a new software package it must involve users to "minimize disruption and foster a proprietary attitude"
toward the new software. He says that the benefits of the new package must be communicated to all employees to
reassure them in areas of concern that they may have, including the possibility of having to work longer hours,
the fear of the unknown, and job security issues.
Breslin contends that one of the reasons for the lack of user acceptance of a new package is inadequate user training.
With the proper education and involvement, he says users will even embrace a deficient package. If users fail to
fully accept a new package, it will likely fail. When users take ownership for a new package, their relationship
to it changes from "their" package to "our" package. He says training plays an important role in user
acceptance.
The training strategy Breslin suggests has four elements.
- The company should assign responsibility for training. The most inexpensive approach is to "train the
trainer." This trained person or group of persons can train other employees within the company.
- The training syllabus should include the entire system, not just those areas that the users need to
know, to provide an understanding of the relationship of the package to the various areas within the
organization.
- The training should sell the system to the users by discussing why it is needed and what benefits it
will provide to the company.
- Breslin's final element is the ongoing reevaluation of the training process to ensure that it is
accomplishing the desired objectives.
In essence, the installation of a new package should be a positive experience for everyone involved with it,
including the users. This premise of Breslin's is a key element in this study for the success of a new package
brought into a small organization.
In summary, five authors, Seymour, Chorafas, Sharland, Shamlin, and Breslin recognize the importance of user
involvement when introducing a new package to a company. The work entitled "Management Evaluation of Software
Packages" and Connell and Shafer do not emphasize the importance of user involvement. In this study, the value
and success of user involvement is tested.
Selection of Hardware
The approach of selecting hardware before selecting software, is supported by Mick (1984) who says that it is a
myth that a computer purchaser should select the software first, then choose the hardware platform on which to
run it. His contention is based on the idea that the things the computer will be used for will expand during its
life, so the buyer doesn't have a firm idea of exactly what he will be doing with the computer.
He says the primary deciding factor should be that the chosen computer is flexible. In regard to hardware selection,
price, performance, and the availability of software to run on the hardware are important factors. Although he
doesn't name a computer type, Mick's comment about price, performance, and software availability supports the
selection of an IBM-type computer instead of one manufactured by Apple.
In Cloning Around: A Guide to PC Compatibles, Stagner (1988) states that the success of the IBM PC product family
as a whole has resulted in two important factors: 1) IBM compatibles have become the de facto standard, and, 2)
this has resulted in an abundance of IBM PC-compatible software.
Apple Computer has incorporated IBM compatibility into its computer architecture, but the price/performance of a
generic IBM compatible has made it the computer of choice for a small business of the type this study addresses.
This isn't to say that an Apple Computer wouldn't be an acceptable choice for small company computing. If a
company already had an Apple computer and were comfortable with the operation of it, it would be a viable
alternative if suitable software could be found. The best approach in such a situation would probably be to
investigate Apple-compatible software packages. If none were found that met the company's requirements, then
the acquisition of an IBM compatible could be made to select a package.
An IBM compatible is a commonly available computer that can run most readily obtainable software packages.
Sullivan (1991) points out that seventy-five percent of the personal computers in use are IBM or
IBM-compatibles.
A cursory look at the software sold by computer shops, shareware providers, software speciality shops, office
supply chain stores, and other sources shows that most of the programs are written for
IBM-compatible computers.
However, if a company already has an Apple computer, software for most applications is usually available,
although not in the quantity and diversity of titles compatible with IBM equipment. Sullivan says the decision
regarding whether to buy an Apple or an IBM compatible computer is based on the preferences of the user.
Stagner (1988) addresses the possibility of purchasing a computer by mail order. He says that a person considering
such an acquisition method should know how long the vendor has been in business, if the vendor can ship within
forty-eight hours, and if it has an 800 phone number for technical support. Stagner suggests that the purchaser
not buy unassembled components, but get the computer already assembled and tested. The problem with mail order
computers is that if hardware problems occur, it is usually necessary to return the computer or parts of it to
the vendor for replacement. Even the fastest turnaround may take two days, and a small company often cannot
afford to have its computer down for that length of time.
Based on these comments, for this study, an IBM compatible was the computer of choice, purchased from a local
vendor who could provide immediate support in case it were needed.
Selection of Software
Mick (1984) states there are four ways to obtain software: Buy a full software package, buy a function-specific
module, write the system using a high-level development tool, or write the program from scratch using a traditional
programming language.
Beizer comments on the write versus buy decision saying that the virtue of purchased software is that it tends to
be better in most respects compared to software written in-house. He doesn't consider the cost aspect of writing
software. Because writing a software package is beyond the capability of most small companies, this study focuses
on purchased programs.
In an article entitled, "Selecting Software," Hollander (1992), says time, cost and availability are the major
considerations to be made when deciding whether to buy or write software. He points out that more companies are
choosing to purchase software instead of write it in-house because of the high costs and long lead time required to
bring up home-grown systems.
Hollander contends that most companies do not know how to purchase software, and purchasing the wrong package can be
costly and result in a lowering of employee morale. His solution is to put together a software selection team,
then take time to define the system requirements.
Hollander's approach appears to have merit, although he doesn't specify whom should make up the selection team.
Other authors have emphasized the importance of placing users of the new system on the selection team because they
are the most knowledgeable in the operation of the existing system.
In his chapter "Buying Software," in Working Smart, Mick (1984) compares purchasing hardware and buying
software:
Buying software is more difficult and frustrating than buying hardware. Software products are less well described
than hardware products and tend to be more complex, making evaluation and comparison extremely difficult
(P. 130).
Balzer provides another viewpoint in the difference between software and its relationship to hardware, contending
that hardware capabilities have improved greatly during the past decade, but software productivity has lagged,
resulting in much less relative improvement than hardware has experienced. Software development is an activity
that is labor-intensive and not formalized (Balzer, 1989).
The selection of a software package begins, according to Carolyn Shamlin (1989) in her book, The Other Side of
Software, with three tasks: 1) the needs assessment, 2) goals based upon those needs, and 3) objectives that
achieve the goals. Her attitude toward software is that it should be as simple as possible, not grandiose, and
meet the following criteria:
- Have well-defined benefits.
- Perform a function that is already well-organized and understood.
When buying software, Mick suggests the following guidelines: buying software for long-term use (with sufficient
capabilities to serve the needs of the purchaser now and in the foreseeable future), making sure that good
documentation is included with the purchase, insuring the software house is reliable, talking to other users,
and trying the software prior to purchase.
Addressing Mick's first suggestion, for the purpose of this study, purchasing software with long-term use as a
primary consideration isn't critical because outgrowing the software is not an immediate factor in a small
company whose plan is to automate a manual system and not go beyond that objective for the near future. In
addition, purchasing a complicated system could hinder implementation as observed by several authors: Shamlin,
Mick, and Sullivan, discussed in the section entitled "Pitfalls in System Development."
Mick's second comment is that good documentation is important. However, for the purposes of this study, the
selected program should be easy enough to use that extensive studying of a manual is not necessary. Furthermore,
software writers often include documentation internal to the application program so that it may be consulted
while the application is running. Even more advanced internal documentation methodologies include
"context-sensitive" documentation in which a request for help results in documentation that is specific
to the function currently being performed by the user.
Another disagreement with one of Mick's assertions is that the software house must be reliable. The
reliability of the software house is not so important as the reliability of the software itself. Since
many software houses go out of business, are purchased by another company, or drop product lines, it
would be difficult to guarantee continued support for the product over a period of more than a few years,
if that long. It is important to consider what situation the company would be in if the software house
were unable to provide support. Could the company's application continue to function? This answer is
difficult to answer. The approach to software selection should be to test the program enough to show that
it is basically sound and will provide the same functionality as the manual system being replaced.
Mick's third point reviewed here is the suggestion that other users of the application be consulted regarding
their problems and solutions. Discussions with other users is sometimes possible, especially with more popular
software systems. Although some small businesses may be reluctant to discuss their software for fear of
divulging competitive secrets, an attempt at finding out what works and what doesn't is important when
selecting a package. Sometimes a software vendor may have a list of customers who can be contacted to
discuss their experience with the software. A list of customers provided by the software vendor should be
viewed with reservation because it may represent only satisfied customers and not a cross section.
The suggestion Mick makes for measuring and selecting software is for the purchaser to try it out. That
activity is most important because not only does it provide verification of capabilities of the software,
but it gives the employee who will ultimately use it the chance to determine how well it will replace the
manual system.
Nixon's (1990) review of the development of farm-related software from a company called Farmplan is an interesting
study in problems faced by uninitiated farmers when they convert from manual to computer systems to help them run
their businesses.
Nixon notes that there is a wide gulf between the farmer and the software writer. The farmer has a general feel
for his information needs but has no idea of how software should be written to meet them. The software writer
knows how to provide an information system but does not have a good understanding of the farmer's problems.
Previous to Farmplan's software, farmers in the UK who could afford it, purchased time on mainframe computers and
used computer service bureaus. The drawbacks to this approach were that the farmers had to entrust their data to
an outside company and that these methods are expensive.
The advent of the personal computer enabled farmers to employ spreadsheets to track critical data. Some
farm-specific programs became available in the 1980s, but they were too sophisticated and complex for the
average farmer to successfully use.
Nixon describes how Farmplan was formed to solve these problems through the following approaches:
- Provide software training to farmers to build their confidence in the programs.
- Set up an advice hotline to address bookkeeping and accounting problems presented by farmers.
- Periodically update the software to keep it timely and improve it.
- Provide a hardware problem-solving service.
The Farmplan software was successful because of the provision of these concepts.
Nixon says the general characteristics of successful software are that it is menu-driven, and has data entry and
report sections, input error checking, utility routines, and online help information.
These attributes can be easily verified during program testing. Nixon explains that the four criteria for program
evaluation are its ease of data entry, the usefulness of its output, the effectiveness of error handling routines,
and the quality of the documentation.
These items present a good guide for evaluation. The average user who tests a system should compare its
functionality with that of the manual system with which he is familiar and draw conclusions from his experience
running the program without specifically addressing each of these points.
In his section on evaluating computer software, Sachs (1984) says that choosing software is more difficult than
selecting hardware because of the variety of software packages available and the multiplicity of features in
each of them. His selection criteria are in question format:
- Will the package solve the problem?
- Will the program fit the current operational habits of the organization?
- Is the program compatible with the hardware?
- Is it compatible with the computer's operating system?
- Does it have the capability to pass data to other programs?
- Is the software house reputable?
- Is it easy to use?
- Is it reliable?
- Is it flexible?
- Is the user manual sufficient?
- Is there manufacturer support for the package?
- Is there a toll-free support number provided?
- Is training available?
- Is it part of a family of software?
Concerns one, two, seven, and nine ("will the package solve the problem?," "will the program fit the current
operational habits of the organization?," "is it easy to use?," and "is it flexible?") can be identified by
the user when testing begins. Either the program will work the way the user understands and considers
acceptable; or it will do the job, but in a different way that may or may not be acceptable to the user;
or it will not provide the desired functionality. Depending on the user's attitude toward the package, it
may be accepted or rejected.
"Flexibility" is a vague term that doesn't have much significance in a discussion of software unless it
addresses specific issues. Examples include the ability of the software to print to a dot matrix printer as
well as a laser printer and, the ability to use pre-printed forms, the capability to use blank paper. Flexibility
should be determined during the testing phase as program capabilities are investigated.
The third and fourth questions ("is the program compatible with the hardware?" and "is it compatible with the
computer's operating system?") can be investigated prior to purchase by reading the program description which
should provide a list of minimum system requirements. If the hardware lacks the necessary capabilities, either
the software package should be rejected or the hardware upgraded to provide the needed power. Some software
vendors, notably Software Etc., provide a money-back warranty on their software. A purchaser may return software
purchased at Software Etc. within thirty days if unsatisfied for any reason.
If the software is loaded onto the system and fails to run, even after checking to determine that the correct
procedures have been followed, if the user has had no problems testing other packages, perhaps it is a poor
package in the first place or it is so complex that it requires expert knowledge that is absent in most small
businesses. In any case, software that acts poorly during installation or start-up probably should be discarded
unless there are other internal company reasons that it is needed (such as it interfaces with a currently-used
package that runs well).
The sixth question ("does it have the capability to pass data to other programs?") probably isn't a concern
because nearly all software packages lack this capability unless they are part of a group of applications from
the same software house. There may be exceptions, but they are very rare. Data stored by package "X" is almost
never capable of being fed directly to package "Y" of a different software manufacturer. For example, the accounts
receivable information from an invoicing package called "Invoice-It" can't be fed directly to Medlin's accounting
package. However, the invoicing data in Peachtree's invoicing system may be fed directly into Peachtree's
accounting package because they have been designed to do that, and when a change is made to the data configuration
in the invoicing program, the same change is made to the accounting package to insure compatibility.
Compatibility between the software systems of competing software houses is nearly non-existent. It would be
like trying to fit a windshield made for a Ford into a Chevrolet. The designs are different, and they probably
always will be. If a user wants inter-system compatibility, then an integrated system such as Peachtree should
be selected, but that raises the problem of complexity.
Software house reputability, as raised by question six, is a moot concern because, as observed above, the
continuous turnover and shake out in the software industry indicates that stability is not an attribute to be
expected. If a package performs well and the user learns to understand and use it, that is more important than
the viability of the software house. In the early phase of software testing and implementation there may be times
when the software house would be consulted, but the company should realize that the software house may cease to
exist at any time in the future and take that possibility into account when selecting a package. This is a
negative point for very complex packages that might require a significant degree of assistance from the software
house.
The reliability issue presented by question eight is difficult because unreliability in a program may show up
immediately or later on. The term "software reliability" can have many meanings, but the primary concern is how
the software treats the integrity of the data and if it operates in a consistent manner. For example, if a program
tends to "lock up" the computer, making it necessary to restart the computer, it is unreliable. If data is somehow
lost or corrupted, the program may be unreliable. These problems may not be the fault of the program. It may be
incompatible with the hardware, there may be power surges that cause the computer to fail, there may be a hardware
component that is operating intermittently, or the operator may be operating the system improperly (such as turning
off the computer in the middle of a data entry session). If this software is set aside and a different package
fails in the same manner, then the hardware or the operator may be suspect. However, if the new package works fine,
then the failing package that was set aside may be the culprit and probably should be rejected.
A serious situation exists if the reliability problems occur infrequently. In such a case, it is more difficult
to pin down the source of the problem. To prove reliability of a package, Sullivan (1991) suggests that the manual
system should be run along with the new software for six months before stopping the manual one. Unfortunately, it is
usually unreasonable for most small companies to run two systems in parallel for that length of time because they lack
the manpower.
Question ten ("is the user manual sufficient?") also applies to on-line documentation because software houses are
providing fewer manuals and more computer-based help information. This reduces the cost of printing manuals which,
in general, are expensive to produce and keep updated compared to documentation that resides in the software itself.
This question should be answered during the user testing phase.
In some cases, software is written to be so self-evident that reference to a manual or an on-line help facility is
almost never necessary. The user will probably need to refer to some sort of printed instructions to get the program
installed and to start it. From that point, most of the information should be on the screen or accessible from it.
The usual help screen trigger in programs written for IBM-compatibles is the F1 (function one) key on the
keyboard.
The chairman of IBM, Louis Gerstner, contends that the computer industry is very "unfriendly" from the viewpoint of
easy-to-use software and hardware. He says, "This is an ego-driven industry that is in love with its own technology,"
a surprising statement coming from the top man at IBM ("IBM's chief," 1995). Competitive pressures are forcing
software houses to improve their software so that it can be implemented, maintained, and run more easily by lay
users.
In his chapter entitled "User Friendly - Buzzword or Breakthrough?," Glass (1991) says, "software engineers have
begin to ‘think user'." He cites Xerox's Palo Alto Research Center (PARC) that developed the graphical user
interface (GUI), first used in the Apple Macintosh and later in Microsoft's "Windows" program written for IBM and
IBM-compatible computers. "Graphical user interface" is a big name for little pictures (icons) displayed on the
screen. To start a program or a function, the user merely positions the mouse so that the pointer on the screen
is touching the appropriate picture, then presses a button on the mouse. This replaces the earlier need to type a
text command to start a function.
Questions eleven, twelve, and thirteen ("is there manufacturer support for the package?," "is there a toll-free
support number provided?," and "is training available?" are similar questions that have been addressed, above, in
the discussion of software house viability. Manufacturer support is nice to have in the beginning. If there is
none, then the software should be very easy to use and the user doing the testing should have no problems
implementing and running the package.
However, if no vendor support exists and the user has difficulty running the package, one of two situations
may exist: either the user has little ability to run an office computer, or the package is not written well
enough to provide operational answers within itself. If the user has had success testing another package,
then he is probably capable enough to test any but the most complex program, and, as observed above, complex
packages should be avoided for an initial conversion unless specific circumstances mandate their use.
The existence of a toll-free support number usually isn't an important issue in itself. First, if heavy
support is required, either the user is incapable of running office equipment or the package is complex and
deficient in easily available documentation. If the user's ability is the problem, that becomes a personnel
concern of the company. Modern software packages are being written to be run by nearly anyone who can turn on
a computer and is willing to learn. However, if the software is complex and difficult to understand, it should be
rejected. Small companies usually don't have the fiscal resources to hire experts to run their software.
As for a toll-free number, the software purchaser pays for user support in one way or another. A software house
cannot afford to provide free support. That cost is usually passed on to buyers of their products as a higher
purchase price for the software or an annual support charge. The existence of a toll-free phone number with no
per-minute charge for calls usually means that the costs of such support have been paid for by some other means.
Like most businesses, software houses must keep their prices competitive and, at the same time, derive enough
income to keep themselves financially viable.
Training is normally only necessary for the most complex packages. If a complex package must be acquired, then the
availability of training is a concern. For software packages that address only one common business functions such as
inventory control, invoicing, accounts receivable, accounts payable, general ledger, fixed assets, tax accounting, or
point of sale, to name a few, training shouldn't be needed for a user who is familiar with the operation of the manual
system being replaced.
Sachs' fourteenth question, "is it part of a family of software?" is a decision the company must make regarding the
type of package it wants to install. In most cases, especially for the first or second package installed by a
company, the package should be "stand-alone" software that is designed to address only one reporting issue. Later
on, after a company has developed extensive expertise running several stand-alone packages, a complicated, integrated
family of software may be considered.
Converting to a full-featured system can be a challenge because the individual programs often require one or more
of the other programs to be functioning. For example, if the company purchases a fully-integrated package that
consists of invoicing, accounts receivable, accounts payable, and general ledger, bringing up the accounts
receivable part of the system may require the general ledger part to be brought up at the same time because
accounts receivable transactions will be sent to it to keep all of the modules in balance with each other. So,
the company may have to bring up several applications within the group, simultaneously.
This is a larger project than that of converting one manual system to a computer, and it is outside the scope of
this study. However, with experience, a company should be able to pull off conversion to an integrated reporting
system.
Referring to a May 1984 article in "Harvard Business Review" written by F. W. McFarlan and entitled "Information
Technology Changes the Way You Compete," Sharland (1991) has developed four categories of software
applications.
- "Strategic" applications are those that enable a company to compete better. He says these are custom
packages,
traditionally developed internally. Examples of applications that fall into this category are material requirements
planning (MRP), sales forecasting, and applications written to interface with suppliers.
- "High potential" applications are less specific to the company, but normally not available from an
outside source, so they are written in-house. Sharland cites manpower planning and decision support as
examples.
- "Factory" applications support common business functions such as accounts receivable, accounts payable,
inventory management, and invoicing. These are commonly available off-the-shelf from software houses.
- "Support" applications are not critical to businesses, Sharland says, but improve performance. Examples
he gives are payroll, word processing, and database systems.
Sharland indicates that, of the above types of application software, only factory and support applications are
candidates for consideration of being obtained from outside the company. These two types of packages are the subject
of this study because they are easily purchased. However, they must be thoroughly evaluated to determine if they meet
minimum acceptance criteria.
Sharland's analysis continues by describing four methods of package evaluation that would apply to "factory" and
"support" applications.
- The picture comparison method uses pictures from sales brochures, advertisements, technical manuals, and other
literature. The pictures are assembled on story boards to illustrate the features of the product.
- A detailed evaluation is based on questions about candidate packages written on an evaluation sheet.
Weights are placed on the response of each question, then the answers to the questions are collected and the
weighted calculations for each package compared to the others to make a selection of the best one. Software
suppliers can be evaluated using the same method, according to Sharland.
- An implemented evaluation is used for low-cost packages whereby the package is acquired and tested to
determine if it is acceptable by creating and evaluating a list of deficiencies. Sharland makes some key
observations regarding this method. He says testing must be done by those who will ultimately use the system
because they know what the required functions are, and many of these may not be written, but, instead, a part of
user knowledge. Sharland observes that the primary difficulty with low-cost packages for common applications is
that there is a large number from which to choose.
- The last method is package led evaluation, used when user knowledge of the business area for which the
package is developed is limited. This evaluation uses a list of as many requirements that the users can generate,
although it will certainly be incomplete in the beginning and may have to be enhanced as more is learned about the
needs of the business area. The abbreviated requirements list is used to identify potential packages. Advice from
software suppliers can be requested and site visits can be made at other companies using the package or to the
software house to see demonstrations of the product. If the package can be acquired, at least on a provisional
basis, experiments can be made with it to see how it meets the requirements.
Since this study will focus on converting a manual application that the users know, and the application to be
converted will solve a single business problem, Sharland's "implemented evaluation" will be the method of choice.
His 1991 book, "Package Evaluation," sums up this procedure that best fits small companies. This approach calls
for the organization to obtain a likely software package and allow the users to test it to develop a list of
deficiencies. Based on tests of several packages, the best one is selected.
A comment regarding the picture comparison method is that it seems unlikely that such a process would result in
the collection of sufficient information to enable a company to choose one without the additional use of one of
the other evaluation methods.
Another writer says the trend in software information representation on the screen is away from text-based data
that requires the user to respond to text displayed on the screen by entering text to instruct the program
(Dickinson, 1992). His view is that text is being replaced by graphical user interface (GUI) displays of
pull-down "windows," "buttons," "icons," and other presentation devices that enable the user to navigate
though an application using the on-screen pointer provided by a mouse, for example. He states that the trend
is away from DOS-based applications which usually use text toward Windows-based applications which conform to
the graphical user interface methodology. His contention is that the GUI format provides easier use of a
product.
Although his premise has general merit, the ease of use depends more on the way a package is written and not
the method of display. There are many examples of GUI software that is not easy to use for the uninitiated,
for example, the database program FoxPro. A graphic presentation on the screen looks nice, but it is no
guarantee that the average employee will be able to run it successfully without specific, in-depth
training.
Smith and Tweney (1992) have some suggestions for general operation of invoicing software. It should have the
ability for the user to add customers on the fly, while creating an invoice, instead of requiring that the invoice
function be closed and then the customer add function be entered.
In addition, they recommend a package have the ability to print a message on the invoice such as "We appreciate
your business." The configuration set up of the software should have built-in printer drivers to allow for the
use of various printers, including a Hewlett Packard laser printer which is a de facto standard in the industry
for laser printers. Most laser printers will print if the information they receive is formatted for an HP
laser.
Smith and Tweney also mention that many invoicing systems will print only on pre-printed forms, often only
available from the software house. Their advice is to look for a system that will print on plain paper which
is much cheaper than printed forms.
Finally, the writers advise looking for software that provides for various statistical reports. Since the
information will reside in the database, it would be convenient if it could be shown in various ways.
From the literature, the best suggestions regarding software selection are to buy, not to write; choose a
manual application to convert that is well-organized and understood and is a relatively simple concept as
opposed to an integrated family of interdependent modules; determine the acceptability of a package based
upon the results of user testing; look for a package that can update other files on the fly, such as a
customer file; seek one that will print on various printers and can use plain paper; and one that provides
a selection of useful reports.
Determination of Common Themes
The primary common themes presented by authors that apply to small companies considering converting a manual system
to a computer system are two. First, the purchase of a software package, instead of having a custom system written,
was a consideration. Second, involving the users in the entire software selection and implementation process was
presented by several authors. A third theme that is discounted by this study is the need for training, discussed
later.
Shamlin (1989), Sharland (1991), and Mick (1984) each assert that, for a small organization, there are advantages
to purchasing software as opposed to having the software written in-house by one or more employee-programmers, or
having it written by outside consultants. Shamlin points out that purchased software is likely to be much less
expensive, be thoroughly tested, may have a broad range of features in order to meet the needs of a wide group of
clientele, is already in use by other businesses who might be sources of information about the product, and may
have an on-going product enhancement program.
For the objectives of this study, in a small business, if an inexpensive package can be found that achieves the
necessary functionality provided by a manual system, then implementation of it may yield positive results in the
form of better customer service, more timely reports, a savings in labor, and better overall operating
efficiency.
As for involvement of users, several authors held this concept to be of great importance to the success of a
computer system implementation, specifically, Seymour, Chorafas, Feynman, Sharland, Shamlin, and Breslin.
Although his situation was unusual, Feynman (1985) illustrates that the success of his project hinged on the
involvement of the staff. In this case, it was solving the complex calculations supporting the development of
the atomic bomb during the mid 1940s. After he took over the computer center at Los Alamos, New Mexico and
arranged for the workers to be told top secret information about what they were doing, their problem solution
rate soared.
Shamlin, Chorafas, Sharland, Seymour, and Breslin are in agreement with the concept of involving users from the
beginning of a conversion project. Each of them note that the success of the project may depend on user
involvement.
No author discredited the idea of involving the user, but Bentley (1984) recognizes that a new package results
in human problems attributed to change. He suggests there are three primary effects to humans when they are
faced with change, and for a project to be successful, they must be addressed.
- Physical (relocating work areas)
- Psychological (concerns regarding layoffs, over-time work, responsibilities)
- Social (the framework of an individual's relationship with others)
Although Bentley's three effects may carry importance in a large organization, for the purposes of this study
of a small company, such concerns would probably be solved in an ad-hoc, informal manner.
Nixon (1990) and the book entitled "Management Evaluation of Software Packages" (1985), consider that proper
user training is the key to the successful implementation of software. These sources do not address the
possibility of user involvement in a project. For the purposes of this study, training is not considered a
paramount requirement for successful package implementation.
Although training is important in some situations, only minor familiarization with the use of a computer is
necessary to get a simple package up and running. In fact, users of the manual system are usually knowledgeable
of its functions and its relationship to other areas within the company. They will be the best qualified to
evaluate a computer package to take its place. This is why the concept of user involvement is considered one
of the most important themes provided by the authors studied here.
For the small company, where one or two people can make or break a conversion project, it seems to be very
important that the staff be involved from the beginning. This study will investigate the value of involving
the employees in the project from its inception.
Hardware Historical Perspectives
This is an overview of the evolution of computers to illustrate the technological changes that have resulted in an
inexpensive computer that small businesses use to solve many of their data processing and reporting
requirements.
During the 1940s computers were developed primarily for research purposes in universities. A few private companies,
such as IBM, did research and development too, but computers were so expensive to build that very few private persons
or small companies could afford to own a computer until the late 1960s.
The military was one of the largest customers for computers, especially during World War II. One major application
for military computers was calculation of fire control solutions for radar directed guns (Feynman, 1985).
There are two basic types of computers: analog and digital. Analog computers became popular in the late 1930s,
followed by the digital computer in the late 1940s. Analog computers are mechanical, most often using servo
motors to do addition and subtraction to achieve the desired solution. A mechanical input to a servo motor shaft
(for example, turning it by hand), that causes it to rotate two tenths of one rotation, results in an electrical
output representing that much rotation. If a second servo shaft is rotated three tenths of one full rotation, and
its output signal is sent to a third servo along with that of the first servo, the sum of these two inputs causes
the third servo to rotate five tenths of a full rotation. The result may be mechanically displayed by an
odometer-type mechanical readout. A negative number may be represented by reverse rotation. In the above example,
if the value from the first servo represented a rotation of minus two tenths of a rotation, the sum of its output
and that of the second servo would result in the third servo turning only one tenth of a full rotation. In this
manner, addition and subtraction are accomplished, and multiplication and division are simply a string of additions
and subtractions, respectively.
Analog computers have survived only in very specialized applications because they are not accurate, require a lot of
maintenance and periodic realignment, are very bulky, and are relatively slow (Forkner & McLeod, 1973).
Although there were experimental mechanical digital computers using ganged electrical switches in the early
Twentieth Century, they did little useful work. In the early 1940s IBM built punch card tabulating machines
that were used to solve a single mathematical function at a time, such as multiplying numbers on two punch cards
and creating a third card with the result. IBM machines like this were used to do calculations required to
develop the first atomic bomb at Los Alamos, New Mexico (Feynman, 1985).
With funding provided by IBM, Harvard developed the Mark I computer, a step beyond the punch card tabulator
technology, and considered the first real computer, even though it was based on existing electromechanical
technology.
It was in 1946 that two University of Pennsylvania engineers, Mauchly and Eckert, built the first vacuum tube
computer, ENIAC (Electrical Numerical Integrator And Computer), considered the first electronic computer
(Bentley, 1984). It used 19,000 vacuum tubes (called "valves" by the British who invented them), weighed thirty tons,
and was housed in a large room (Forkner & McLeod, 1973). Even though it was crude by today's standards, ENIAC was one
thousand times faster than any calculating device before that time (Bentley, 1984).
Vacuum tubes in computers operated in one of two states: either "on" or "off," to represent "one" or "zero,"
respectively. Transistors in computer chips work the same way. Strings of ones and zeros are numbers in base
two and can be mathematically manipulated to achieve great accuracy. Vacuum tube computers provided a vast
improvement in accuracy over analog computers, but tubes were prone to burning out, much the same as a light
bulb, requiring replacement. A 1940s vintage vacuum tube computer had much less power than a modern calculator
and was much more bulky.
In 1949 The University of Cambridge developed a computer called EDSAC (Electrical Delay Storage Automatic Calculator).
The University of Pennsylvania followed with EDVAC (Electrical Discrete Variable Automatic Computer). EDSAC and EDVAC
were unique in that they were the first computers capable of storing instructions and data and to use modifiable
instructions (Bentley, 1984).
The first generation of machines considered true computers began in 1951 with the first commercial computer
installation, and extended through 1958, when Sperry Rand announced the first transistorized computer, heralding
the second computer generation, lasting until 1964. The third generation, beginning in 1964, featured a leap in
computer power made possible by miniaturized transistor circuits, thin film memories, and the introduction of
high-level languages such as Algol, Fortran, and Cobol (Bentley, 1984).
The milestones of subsequent computer generations are blurred because advancements were less revolution and more
evolution (Forkner & McLeod, 1973).
Until the introduction of the minicomputer in the late 1960s, computers were of the "mainframe" variety.
Minicomputers provide slightly less power with an excellent price/performance ratio, compared to mainframes.
As miniaturization continued, by the late 1970s, small "personal" computers, in kit form, were available for
hobbyists to build and program. In the late 1970s Apple Computer began production of a complete, ready-to-run,
personal computer that became popular with businesses, schools, and individuals. For the first time, the
non-technical person could purchase and use a computer.
The computer industry giant, IBM, decided to meet Apple's personal computer challenge head-on by introducing its
own entry, the IBM PC, into the personal computer marketplace in 1981 (Stagner, 1988). To motivate software
developers to create programs to run on its computer, IBM elected to present its offering with "open architecture,"
meaning that the internal design was available to anyone so that software development would be easier. As a result
of open architecture, availability of software to run on IBM exceeded that available for Apple computers.
However, the open architecture philosophy backfired on IBM as other manufacturers began building computers based on
the IBM architecture. They are called "IBM compatibles" because they are designed to use the same software as IBM
computers (Dodge, 1994). The resulting competition caused IBM-type computer prices to plummet. As performance
increased and prices dropped, sales skyrocketed.
Traditionally, computer power has increased each year, and the price per unit of compute power keeps falling. That
tradition continues today. The first IBM PC, introduced in 1981, cost $5,000 (Stagner, 1988). It was configured
with one megabyte (MB) of random access memory (RAM), two floppy drives, a monochrome monitor, and a printer. Its
oscillator speed, a measure of how fast a computer can execute instructions, was 4.77 megacycles (MHz). It had no
hard drive because there were none commercially available for the PC at that time.
By comparison, in 1995, $2,500 would purchase a computer with 8 MB RAM, two floppy drives, a color monitor, a printer,
a 540 MB hard drive, and a clock speed of 90 MHz.
The adaptation of a hard drive to the PC resulted in the PCXT, introduced in 1984 (Stagner, 1988). "XT" is an
acronym for "Extended Technology." In 1985 the PCAT came out. "AT" stands for "Advanced Technology," and this
machine was a departure from the earlier IBM design in that the logic circuits had been reworked to improve
performance. The first model of the AT is also commonly referred to as the 286 because it uses the Intel CPU
chip with the designation "80286." Subsequent models of IBM and IBM compatible computers are still referred to
as "AT," even Pentiums, because they adhere to the basic architecture pioneered by the 80286.
It is this computer evolution that ultimately enabled small businesses to purchase computers to take over many of
their reporting and operational tasks.
Software Historical Perspectives
In this study "software" refers to application programs, as opposed to system software that constitutes operating
systems such as DOS and Windows.
The early software for PCs was text-based. Programs displayed instructions and information on the screen in text
format. Screens were all monochrome, so programs didn't need to provide color displays. As programs became more
sophisticated, they began using graphical displays. These were an improvement over text-based displays because
they could be more easily understood through the use of icons providing information that pure text could not.
From a software perspective, improvements have kept up with hardware advancements. In fact, to some extent,
software has pushed hardware development because more advanced programs require faster computers with more storage
capacity.
The first stored computer programs were written in machine language, represented by ones and zeros. Machine
languages continued to be used into the late 1950s when assembler languages were developed to make computer
programming more efficient. One statement in assembler language can generate several machine language statements,
improving programmer productivity. The problem with assembler languages is that they are specific to a manufacturer's
equipment, a problem that was resolved with the advent of compiler languages which can run on a variety of computers.
Programming efficiency was again improved since one compiler statement can generate many machine language statements,
the equivalent of many assembler statements (Forkner & McLeod, 1973).
Technology produced the color terminal, which enabled additional information to be made available to the user. For
example, warning message might be shown in red letters to attract attention. In response to Apple's graphical user
interface (GUI), Microsoft developed a GUI for IBM computers and called it "Windows." Early versions are not true
operating systems, but a collection of graphics displays that allow the computer to launch programs. Windows
programs are characterized by "pull-down windows" that are information boxes allowing complex selections and
decisions to be easily made by the user. The easiest method of interfacing with Windows is by a pointing device,
such as a mouse or track ball. By manipulating the cursor around the screen, the user can point to the selection
that he wishes to activate.
Programs written for IBM and IBM compatible computers are of one of two types: DOS or Windows. A DOS program runs
using the DOS operating system and does not need Windows. A Windows program requires Windows to be running before
it can be started. A program that runs only with DOS will run faster than the same program that is written for
Windows because Windows is an additional series of programs that must be run, requiring additional hardware
resources.
Faster, more powerful computers have accommodated larger, more complex programs that older computers built a few
years ago cannot run.
If a program is well written, it doesn't matter whether it runs under DOS or under Windows. It should be easy
to use and provide the necessary information in a clear manner. For this study, an easy-to-use, highly functional
software package was sought, regardless of whether it was DOS-based or required Windows.
Pitfalls in Conversion Projects
Shamlin (1989) observes that if the users aren't involved in the project, they won't take ownership of the
system to insure its success. When an individual is invited to participate in testing and implementing a software
product, he becomes an integral part of the process. When that person helps select and test the system, it is
hoped that he will become a supporter of it and take a certain amount of pride and ownership in it. This ownership
attitude motivates the user to try to overcome system deficiencies, causing him to find ways to work around problems
that would frustrate and alienate someone who has not developed a sense of "ownership" of the project. If this
attitude can be instilled in key users of the system, they will do all they can to insure that the system
works.
Feynman's (1985) experience running the computer center at Los Alamos during World War II is probably the first
recorded example of a computer room staff doing as little as possible until given "ownership" and a sense that
they were an important part of the project.
Feynman took over the computer center after the first manager got sidetracked investigating the computer's
capabilities instead of using it to solve the complex mathematical problems the scientists needed to build the
first atomic bomb. The group of people running the computer had only solved three problems in nine months.
Feynman describes the situation when he took over:
. . . although they had done only three problems in nine months, I had a very good group. The real trouble
was that no one had ever told these fellows anything. The army had selected them from all over the country
for a thing called Special Engineer Detachment - clever boys from high school who had engineering ability.
They sent them up to Los Alamos. They put them in barracks. And they would tell them nothing. (p. 110).
The staff came to work each day, punched numbers into cards, and ran them through the IBM computers, but for
what purpose, they didn't know. Feynman's approach was to have Oppenheimer get permission from the security
people for Feynman to give the men a lecture on what the Los Alamos project was all about and the significance of the
computations they were doing.
After the lecture, the men were very excited. They felt involved. Now they understood that they, too, were helping
win the war and their work was of utmost importance to national security. Their efforts in the computer lab rose
considerably, and they began to invent ways of doing the computations better. They began working three shifts, and
they didn't need supervision. In fact, they invented some additional programs to supplement those that the scientists,
like Feynman, had developed. During the next three months they solved nine problems, a productivity increase by a
factor of nine!
Converting a manual system to a computer should only be done if the manual application operates well (Bentley, 1984).
The basis for this assertion is that automating a poorly running system won't make it better. It may actually cause a
degradation in performance. In a small-company environment, the solution would be to choose a different system to be
converted or take the time to iron out the problems in the manual system before attempting to migrate it to a
computer.
As mentioned previously, in the section entitled "Selection of Software," Shamlin states that only a manual system
that is well understood should be converted to a computer.
Computers can be a boon to small businesses, but they have weaknesses that have to be considered (Bentley, 1984).
Computers, small or large, are hardware devices that are susceptible to failure. Although it is uncommon, they are
essentially electromechanical devices, and, as such, can cease operation for a variety of reasons including power
surges, sharp jolts, over-heating, and component age.
Program failure is another hazard of computerized applications (Bentley, 1984). Not every program is perfect in
every way. A section of code that has not been tested well and is infrequently used, may not exhibit a problem
until some time after the program has been working. A small company that lacks computer experts who can
immediately address and fix the offending code, must rely on support of the software house or a consultant to repair
the problem.
Operator failure is another potential area of trouble, but it is usually corrected by using the proper operating
procedure. However, human errors can do harm to a computer system if a file is accidently deleted or harmfully
altered. In situations like this, a company must call in a software professional. Assuming the mistake was an
honest accident, the blame really cannot be placed on the operator. A well-written computer program will have
safe-guards to prevent accidental destruction by an inept user.
Other potential pitfalls described by Bentley include improper control procedures (e.g.: failing to back up files),
program rigidity that prevents any program changes, system complexity, poor staff training, and output that is
improper for the use intended such as a report that goes to the screen, but cannot be directed to a printer or a
program that allows for printing to a dot matrix printer but not to a laser printer. Many of these potential
problems can be identified during the investigation of the product before it is implemented simply by testing the
features of the system as they will be used after installation.
Shamlin says it is a mistake to try to install a large, complex system that is grandiose because it will require
much longer to install and increase the cost of the software (1989). Mick (1984) agrees, stating that it is
difficult to make a very complex system successful in a reasonable period of time, compared to a more simple one.
He says that a simple system is a better candidate for a company's first conversion than a complex one because it is
more easily implemented, can be put in place in a shorter period of time, the users are provided earlier use of the
software, and it is less costly than spending additional manpower trying to put in a system with a broader
capability. Although a simpler system may have less functionality than a more complicated one, unless there are
mandatory features that are lacking in the simpler system, it is usually the most economical choice.
Sullivan (1991) concurs with the concept of starting small when it comes to converting from a manual system.
He contends that implementing a program that is too big for the business's current needs is a waste because
unneeded information must be created and entered into the new system to set it up. He says that a company
may eventually choose to migrate to a larger computer system, but that it is best for the company and its
employees to become familiar with the computerization of the system first, then advance to a more complex
system later, after a high comfort level has been achieved with the computer and the way information is
processed by the new application.
Sullivan also states that if a computer system chosen to replace a manual operation is compatible with a more
powerful system that could be installed in the future, the existing data files could be transferred directly
to the new system. However, this advantage shouldn't be counted on because upgrading to a more capable package
usually means that the data in the old package must be manually transferred from the old to the new. This is
usually accomplished by printing the contents of the old system to paper, then entering that information into
the new system in the format required by it.
For the small business to avoid pitfalls, the authors cited agree that user involvement is important to the
success of a new system and that simplicity is best for the first computer system that replaces a manual one.
The study was begun with these concepts in mind.
Testing
Testing is an important aspect of choosing a software package. The testing process should thoroughly check all
of the functions that the company considers necessary for its operation. Testing should also provide a good feel
for the overall characteristics of the package.
Although the thought of testing software that has never been seen before may be a daunting prospect, testing a new
package can be accomplished without having detailed knowledge of how it works (Beizer, 1984). Knowing the
principles of the operation of the application is sufficient. A significant determination of the success of a
package is how easy it is to begin using.
Beizer states that it is impossible to prove that a program is error-free or perfect. He says that a realistic
goal of testing is to provide a "suitably convincing demonstration" that provides the user with a comfortable
feeling for the operation of the software.
A user contemplating testing a program for the first time may find solace in the findings of Goodell (1989), that
most commercial programs exhibit similar characteristics. This would lead a user who is about to test a package
to expect similar operational characteristics from packages designed to process the same application. Goodell
studied the functions of business programs and found that the great majority of them do similar things. The most
predominate action of business programs was printing a report, followed by file maintenance, file build/load/copy,
posting/updating, and sort. These were the functions most common in business software. He concludes that business
applications tend to be consistent in the things they do, largely attributable to common business and accounting
practices.
In an article in "Software Development," Gianturco (1994) describes several testing methods. Functional testing,
also called "black box" testing, is a procedure used to create test cases based on the program's functionality as
described by the program specifications. This testing method is not practical for verifying selected software
packages in this study because it requires analysis of software specification which are not available in most
packages.
Equivalence partitioning is another non-execution testing method in which program specifications are examined to
determine valid inputs to each program subroutine. For the same reason that functional testing is not viable for
this study, equivalence partitioning is not usable. It requires program specifications which are neither available
nor easy to analyze by a package purchaser.The third non-executional testing method Gianturco discusses is Boundary
Value Analysis. He characterizes it as usually augmenting equivalence partitioning. This method involves examining
program specifications to determine valid and invalid input values. In reality, a user will most often determine the
validity of input values by testing the program during execution.
Category-partition testing is the fourth non-execution testing method. It involves creating a list of items that can
vary for each input to the program, including data types, length of input data, and size of the data. It is used to
create test cases by choosing values based on classes of data. This method is more valuable to software designers
than users.
Structural testing, also called "white box" testing, includes several ways to confirm program viability. It uses
analysis of the program's structure (study of the program code) to design test cases. This is a different approach
from functional (black box) testing which uses program specifications.
Another structural testing approach is mutation testing, an execution-based method which requires several variations
of the program, referred to as "mutants," to compare their output for validation purposes.
Another testing method is called "Run-time assertions," wherein blocks of code are inserted into a program to test
its operation during execution.
"Data flow analysis" develops test sets by examining how variable values are defined and used by the program. It
is a non-execution test, and more valuable to the software house than the software purchaser.
"Multiple version testing" is an execution testing approach whereby several versions of the program are coded from
the program specifications. The output produced by the majority of the program variants is considered to be the
true output of the program.
Path testing, another execution-based testing method is probably the best approach to use by the user. The program
is tested during execution by entering various input values to determine how it reacts. Examples of path testing
include some methods (statement, branch, and condition coverage) that may or may not be suitable for a user to
employ in a testing program. "Statement coverage" insures that every statement is executed at least once. "Branch
coverage" insures that every program branch is executed at least once. These methods are more applicable to testing
by the software developer than the user. "Condition coverage" is the execution and subsequent evaluation of each
branch to determine if the input result is "true" or "false." Again, this is applicable to use by the software house.
"Extended branch coverage," also called "multiple condition coverage," checks a truth table (a true/false matrix of
results of entering various inputs) to test every variable. This is a very time-consuming testing method because of
the great number of possible input variables to a program or program routine.
"Code reading" is a thorough, non-executional testing method used by programmers to check their code by reading each
line to try to determine if the program is correct. A code walk-through is accomplished by one programmer who creates
specifications from reading the code. These specifications are then compared to the original specifications to see
if they match. Desk checks commonly employ three programmers analyzing the code to find logic faults (Gianturco
1994).
As noted above, the only testing method available to the small company is path testing, an execution-based testing
method in which the user enters various types of data and observes the system's reaction to it.
Summary
Two major ideas regarding the introduction of a new computer system have come forth from the literature. First,
if too much is attempted at any one time, it is possible to get bogged down in the myriad of details, causing the
project to get strung out for a long time, or dropped completely due to indecision and frustration. Even large
companies with many information system specialists can become overloaded working on a project that is too large,
too radical, or is changed too much during the implementation.
In selecting a more simple solution, desirable features may be given up, at least temporarily, but the objective
is to get the basic system up and running. After that, the extra functions can be addressed.
The second important observation the authors agree on is that, by involving the users at every stage of the process,
they will accept the project and make it their own, insuring its success. The authors studied consider this one of
the most important aspects of the process of putting in a new system because without user backing, it won't be as
successful, and could fail completely, causing a negative impact on efficiency and productivity as the company has
to back up to the original system or take some other recovery action.
Chapter 3
METHOD
Selecting the Subject Company for the Study
The objective of the study is to determine if a small company that does not have much computer expertise can improve
its information systems using its own resources. The conversion of a manual system to a computer-based system should
be inexpensive and have a positive impact on the company, its employees, and its customers.
A subject company might already have some of its reporting work done by computer, but it should have at least one
manual application that is a candidate for being automated. In addition, its management needs to be open-minded about
allowing a study to be undertaken on its premises, and if a candidate manual system is identified, allow it to be
converted to a computer.
The selection process was begun by talking with local small business owners to determine if they might be interested
in allowing their company become the subject for this study. The owner of a small wholesale office supply company
agreed to the study. He was planning to take his wife on a two-month vacation and, after becoming familiar with the
approach to the study, allowed it to commence in his absence. His daughter would manage the operation while he was
away, visiting the office each day for approximately one hour. She was agreeable to the concept of the study, would
monitor its progress, and make any required decisions.
One stipulation the owner made before allowing this study to be undertaken was that there be no risk to his company
or his employees. This was a fair requirement. It would be poor technique to enter a place of business and cause
it harm or distress.
To begin the study an assessment had to be made of the information systems his organization, The Ross Company, was
currently using. If there were no manual applications that were candidates for converting to a computer, his company
would not fit the selection criteria, and another subject company would have had to be found.
The company meets the criteria of being small, grossing about $170,000 per year. A billing system that was
implemented several years ago by a consultant is run on the owner's computer at his home. All other company
information systems were manual, including the invoicing, general ledger, accounts payable, inventory, customer
list, and pricing.
Since the owner of the company owns a computer, he is not averse to computers in general, but he lacks the
confidence and knowledge to try to implement any new systems at the company by himself. Until asked if he
would agree to free consulting, he was not interested in hiring a consultant to investigate the possibility
of improving his company's systems.
He started the company in 1950 with a partner who is no longer a member of the organization. Recently, due to
competitive pressure from the office supply chain stores, his company has been under severe economic pressure.
It barely breaks even during the year, making the issue of operational efficiency important.
Prior to the study, he had two employees, a half-time typist and a shipping clerk. The half-time typist planned
to retire in a few months, when she turned sixty-five. She would either have to be replaced, or the workload of
the shipping clerk would have to be increased to cover the additional duties of typing invoices and shipping
labels.
Neither prospect was encouraging because the wages paid by the company have not kept up with inflation. The
half-time typist, who worked twenty years for the company, received $6.80 per hour, and it is expected that a
replacement would have required $8.00 or more.
The shipping clerk, who is an eight-year veteran of the company, earns $7.25 per hour, and to place too much
more work on him might be cause for him to seek another job. Replacing him would probably require the company
to pay a higher wage to entice a new employee to take the position. The cost to the company of paying a higher
wage is not only the wage itself but the additional state and federal payroll taxes.
With the confirmation that the company met the criteria of a small business that has several manual systems,
the next step in the study was to determine if it had a manual system that could be converted to increase its
efficiency.
Selecting a Manual Application to be Converted
The manual systems identified as potential conversion candidates included general ledger, accounts payable, inventory,
invoicing, pricing, and customer list.
The general ledger, accounts payable, and inventory systems were manual, done by the owner at his home. Although they
are candidates for conversion, since he does them himself, they don't have a direct impact on company operations.
Therefore, they were rejected as potential applications to convert.
As for the pricing function, each quarter the company's major supplier sends it three price books, called "pricers."
They are one and a half inches thick, contain the item number for each of the 25,000 items represented in the annual
color catalog, a short description of the item, and four columns of pricing. The Ross Company pays the lowest printed
price, shown in the fourth column. Ross's customers, retail office supply stores, pay the first column price which is
typically between fifteen and twenty percent above Ross's cost. The end customer's cost at the retail stores is about
fifty percent higher than what Ross's customers pay.
Converting the pricer to the computer is beyond the company's needs for the following reasons. First, it would have to
be redone each quarter and would require each of its 900 pages to be scanned into a computer format. At this time, it
is not a good candidate for conversion because it wouldn't achieve a great deal of efficiency. Also, the likelihood
that a computer program could be found that would accommodate scanned pricer information is remote.
The same is true for the customer list. It is maintained on a Rolodex file. When an invoice is typed, the Rolodex
is consulted for the customer's address. The address is also typed on a shipping label using the Rolodex as a source
for the shipping address. Converting it, by itself, would not provide much advantage to the company.
Finally, the invoicing system was considered. After looking at all of the applications, this was the one that stood
out as having the potential to do the most to reduce costs. If it could be converted to a suitable software system
by the time the typist retired, the workload of the shipping clerk might not be increased too much so that he could
do both the invoicing and his regular job, packing and shipping orders. It became clear that the customer file and
the pricing information might be incorporated into a computer-based invoicing system, resulting in an overall
improvement in the company's information systems.
Shamlin's (1989) criteria for selecting a manual application to be converted are twofold. First, the object of the
conversion must have well defined benefits and, second, the manual system must be well organized and thoroughly
understood by the user.
The benefits to be derived from converting the manual invoicing system were well defined, predicted to be a majority
of the following items. Some of them raise questions which are addressed in a discussion of the manual system, in
the following section.
- A neater invoice would be produced.
- After the most active inventory items have been entered into the computer, the invoice creation process would
simply be a matter of selecting an item from the list in the computer, greatly accelerating the invoice preparation
process.
- The use of the price book to find the price of each item ordered would no longer be necessary because the
pricing information for every item would reside in the computer.
- If an invoice were lost or mutilated, it could simply be reprinted.
- Two different sizes of four-part invoice forms would no longer be needed. A cost savings would result
from using white, single-part stock paper instead of the forms.
- The existing disparity in invoice numbers on the two different sizes of invoice forms would be eliminated
by computer-generating the numbers.
- The Rolodex would no longer be needed to find a customer's name and address. The name and address would
automatically be printed on the invoice, and it could be read from the invoice to type the shipping label.
- Sales and inventory status reports would be available at any time to show current status or the status for
any given time period.
Shamlin's second requirement, that the user should understand the manual application, was satisfied. The invoice
typist and the shipping clerk knew the system very well.
The owner's daughter assented to further study of the invoicing system, followed by implementation of an automated
system if a suitable on could be found. The next step was an analysis of the manual invoicing system to determine
how it worked and what the key requirements were for a software replacement.
Operation of the Manual Invoicing System
Operation of the manual system began with the placing of an order by a customer. Orders are usually placed by phone,
but they may be faxed or arrive by mail. Both the half-time typist and the shipping clerk took orders during the
morning when the calls were heaviest. After the typist left at noon, the shipping clerk took the orders during his
work of packing orders and preparing them for shipment each afternoon.
Two phone lines are installed with a roll-over feature in the event the primary number is busy. This enables two
calls to be handled simultaneously, allowing both the typist and the shipping clerk to take orders at the same time.
In the afternoons orders were called in less frequently, so the shipping clerk was able to handle all of them
himself.
The manual invoicing system was item number-driven. When a Ross employee took an order, each item number was
written down on paper as the customer identified it. Most customers place orders by item numbers found in the
catalog. In cases where a customer can't find an item in the catalog, the person taking the order looks for it
either during the call or after the call, depending on the customer's preference. Once the item number was
located, it was added to the customer's order sheet.
After an order was written, each item was located in the price book and the price per unit was written on the paper.
If the number of units ordered was greater than one, then that number was multiplied by the unit cost to obtain the
extended cost.
During the morning, the typist typed the order on half-page, NCR (no carbon required), four-part forms. These had
pre-printed, consecutive invoice numbers. When the supply got low, they had to be reordered with the proper sequence
numbers.
Each page of the four-part form was a different color to make identification easy. Since the typing was less clear
on the back sheets, the customer received the front copy (the original), as a shipping list and invoice, packed with
the order. Another copy was filed alphabetically by customer name, one became the working copy that went home with
the owner so he could update the general ledger and accounts receivable books, and the fourth copy was an extra
packing slip in the event of a drop-ship. If the order was not a drop-ship, the fourth copy was thrown away.
The half-page form was supplemented by a full-page invoice form for orders that had more items than would fit on
the half-page form. The owner used the two types of forms because he wanted to cut costs. Since most orders
would fit on the smaller form, and it was less expensive than the full-page form, there was a small savings.
It was rare for an order to require more than one full page, but when that occurred, two full-page invoice forms
were used. A problem with using two sizes of invoice forms was that each size had a different invoice number
sequence. This made it more difficult to find an invoice within a customer's file because two numbering systems
were in use: one for short invoice forms and a different one for long invoice forms. If a customer's orders
rarely required a large form because his orders were usually small, they were more easily located in the file
than if his orders were a mix of large and small orders requiring large and small forms with two sets of invoice
numbers.
To type the invoice, the customer's name and shipping address were found on the Rolodex file. A pencil was stuck
between the cards to hold the place while the information was typed on the invoice. Additional heading information
included the date and Ross' address which was actually typed on each invoice. The owner's philosophy was that the
company's typed name and address looked neater than that of a stamp.
The body of the invoice was then typed, containing, from left to right, the item number, the number of units ordered.
a description of the item, the suggested list price, the wholesale cost to the customer, and the extended wholesale
cost.
During the typing process, errors that occurred were corrected using the correction tape mechanism built into the
typewriter. However, the three back pages were smudged by the correction. They were usually corrected after typing
was finished by penciling in the correct information. Since these pages were used internally, their appearance
wasn't as important as the customer's copy which was the original that was corrected with the lift-off tape.
However, there was a chance that the corrections would not be made correctly or would not be made at all.
There were times when an error was discovered after the invoice form had been pulled out of the typewriter. In
those instances, White Out was used to cover up the mistake before the information was re-typed.
Invoice forms often became ugly with painted-out errors, lift-off marks, and retyped areas. Sometimes the typist
elected to simply retype the entire invoice, a waste of time. After being re-typed, the smudged invoice was thrown
out. The problem was that a gap in the invoice numerical sequence resulted, preventing reconciliation of invoices
by their numbers. The owner reconciled by matching items received from Ross's suppliers with items shipped to
customers, researching disparities when the items ordered weren't shipped out or when items shipped were not shown
as having been ordered by Ross.
When the typist left at noon, the shipping clerk did the order taking, invoice typing, and order shipment. The most
time-consuming part of his job was, and still is, handling inventory and packing orders. Typing invoices was his next
most time-consuming duty.
Before sealing a box, a shipping label has to be typed. A standard, glue-backed label is stamped with the Ross return
address, then placed in the typewriter. The Rolodex customer file or the invoice was consulted for the shipping address
of the customer.
The final part of the shipping procedure requires wetting the back of the label, placing it on the box, weighing the
box, and writing the order information into the United Parcel Service (UPS) log.
Items ordered that are not be available for shipment the following day are written on a sheet of paper and placed in
a back order tray. Most items are available from Ross' main supplier, but if the local warehouse is temporarily out
of stock, they are ordered from one of the supplier's other warehouses, usually Salt Lake City, Los Angeles, or Dallas.
Since these items require two or three days to arrive, all available items are shipped upon receipt, the following day,
unless the customer specifies that he wants the shipment held until the entire order can be shipped to reduce his
shipping costs. When the items arrive, the back order sheet serves as a reminder of the customer who ordered
them.
Orders received during the day are ordered from Ross' primary supplier that afternoon if Ross doesn't have them in
stock. They arrive the following morning in time for the shipping clerk to box them for shipping by the time the
UPS truck arrives in the afternoon.
This completes the description of how the manual invoice system worked. Now the problem was to find a software
package that could take its place. But first, a discussion of hardware selection is undertaken.
The Selection of Computer Hardware
Selecting the computer to run software that has not yet been selected may seem to be a futile task because, without
knowing which software package is to be chosen, how can a computer to run it be identified? The response to this
apparent dichotomy is that the scope of the software to be used is known. It is a single, relatively simple
application instead of a group of interrelated accounting applications such as general ledger, accounts payable,
accounts receivable, and inventory control bound together in an integrated package.
Furthermore, the invoicing function, by itself, is not a huge, complex application. It must do a few specific
things that are currently accomplished manually, that is all. For example, it should allow order information to
be typed in and then printed on an invoice. There may be some additional requirements when the actual selection
is studied, but, for right now, a basic computer is all that is required. The software programs of an average
invoicing package might require five to ten megabytes (MB) of hard drive storage and, perhaps, another five to
ten MB for data storage.
A small businessman in search of a computer probably would not have a feel for these hardware requirements.
However, in his search for hardware, he could ask computer vendors questions regarding the type of package he
was thinking of installing and note the various answers. One certainly couldn't expect them all to be the same
since sales people often have their own axe to grind in the form of commissions and the occasional need to move
over-stocked merchandise. However, he should be able to get a general idea of the size and cost of the computer
needed to run the type of software package he has in mind.
Even if a businessman purchases a computer that is too small, most likely, it could be expanded to meet the needs
of a particular software package. The aim is to acquire a moderately-priced computer to run a moderate-size
application. In the case of The Ross Company, an inexpensive computer costing $700 was obtained to run the
invoicing system. Although the user, the full-time shipping clerk, was kept informed of the size of computer
required and the plans for its purchase, he did not actually participate in the acquisition.
Purchasing too much computer for this project would be undesirable because excess capacity that will never be
used is a waste. In addition, since prices on computers have continued to fall during the past ten years, there
is reason to believe they will drop in the future. Computer capacity that is not purchased today, but purchased
in the future, will cost less. That is the premise for purchasing a modest computer. Besides, two features that
constitute its power, the memory and the hard drive, could be upgraded, if necessary, to accommodate an unexpectedly
large invoicing package.
For the purposes of this study, only two major computer types were considered because they are proven business
machines, not simply computers used in game playing. They are IBM and Apple. Apple's current mainstay in the
market has excellent graphics capability and is easy to learn to use. A drawback with Apple computers is that,
compared to IBM compatibles, they are more expensive. There are fewer outlets for them, and, as a result, fewer
repair shops. There is less software available for Apple products, and modifying and upgrading them is not as
easy as it is with IBM compatibles. Finally, the IBM compatible line is broader, with many more choices of
computers, options, and peripherals.
Had The Ross Company already owned an Apple computer that could have been used for invoicing, then invoicing
software for it would have been acquired and tested. Since there was no computer at the Company's site, the
choice was an IBM compatible.
An option when considering modest cost computers is to buy new or used. Purchasing a used one is not a good
idea for someone who is not familiar with computers for a couple of reasons. If the used computer is of older
technology, it may be outdated, relatively low power, and less capable of being upgraded. Compatibility problems
could result when trying to install software on an old computer. Older technology used monochrome monitors, but
most software today can display pleasing colors. Older keyboards had fewer keys and no numeric keypad, and newer
keyboards are incompatible with old technology computers, called "PC" (IBM's original 1981 model designation that
stood for "personal computer") or "XT" (the mid-1980s improved design designation that represented "extended
technology.")
A warranty is a good idea in the event the computer has teething problems following purchase, and used computers
rarely carry more than a 90 day warranty on parts and labor. The warranty on new computers is often 90 days on
parts and two years for labor, although warranties vary widely due to competition. It would be a comfort to have
hardware support following purchase. No one in The Ross Company is familiar enough with computers to do any
trouble shooting or repair, so a warranty would be valuable.
The newest technology computer of the IBM type is designated "AT," for "advanced technology." The chosen
configuration included a color monitor, a mouse, a keyboard with a numeric key pad, and an extension cord with
multiple electrical outlets and surge protection in case there are power fluctuations that could damage the
computer.
The "AT" line constitutes a broad range of computers starting at 286 and going up to the Pentium P5 and P6 series.
A computer sales person would be able to sort out the details for a businessman interested in buying one. However,
it would be advisable to shop around and compare notes, just as when making an automobile purchase. For example,
the purchaser would soon find that the 286 is obsolete. The 386 series is about to become obsolete, the 486 is
current state-of-the art, and the Pentium is poised on the threshold to becoming the new de-facto standard.
Ignoring the 286, prices for the 386 are very reasonable, yet the 386 is still a very capable machine, especially
for running a relatively simple, stand-alone application such as invoicing.
To present some specifics about the computer obtained for The Ross Company, it is a generic IBM compatible (the
name plate has the name of the computer store that assembled the components), has an Intel 80386SX central
processing unit (CPU) chip on the main board (also called "mother board"), an oscillator speed of 33 MHZ, a 40
megabyte (MB) IDE (Integrated Drive Electronics) hard drive, a 1.44 MB floppy drive, and a 1.2 MB floppy
drive.
The 80386SX CPU is the less powerful version of the 80386DX. Note that the "80" in the designation is usually
dropped. The 80386SX central processing unit is a product of Intel Corporation, the world's largest manufacturer
of CPUs. Even computers that do not use an Intel CPU are identified by the Intel designation because it presents
a good measure of the power of a computer. (Intel elected to change the designation of the CPU that followed the
80486 from "80586" to "Pentium P5" so it could copyright the new name.)
When considering hard drives, the IDE type hard drive is a more modern drive than older drives manufactured a few
years ago (RLL and MFM). The electronics have been miniaturized to an extent that much of the circuitry that used
to be on the hard drive controller board is now mounted on the hard drive itself. This improves its performance
because the drive no longer must communicate to the controller board for everything it does. Instead, many of its
functions are managed by the electronics built right into it.
When considering the time lapse of sending a signal across a cable two feet long, having it decoded on the
controller board, and then getting it sent back over the cable to the hard drive, it is apparent that there is
a speed benefit if the hard drive has the control circuitry built right into it.
The access time of a hard drive is measured in milliseconds, and this particular computer came with a 17 millisecond
hard drive. Currently, drives with a transfer rate of 12 milliseconds or less are available, but the extra cost
for that speed isn't justified for this application.
A 40 MB hard drive was chosen because of its inexpensive price. A larger hard drive isn't necessary at this time
because the DOS (disk operating system) requires less than ten megabytes, leaving plenty of room for the invoicing
program.
The use of the Windows system is not contemplated at this time, but if it is needed, a larger hard drive will be
acquired to accommodate it. Some computer software requires the Windows graphical user interface (GUI) and some
requires only DOS. More modest, less expensive software requires only DOS to run, and it is anticipated that a
modestly-priced package that has the necessary functionality will be available.
The computer has a fourteen inch (measured diagonally as with televisions) color VGA (video graphics adaptor)
monitor with a 640 x 480 dot density. The pixels are .32 mm apart, providing a modestly-priced monitor that is
readable. Monitors that are larger, have a greater dot density, and will display many more colors, even millions,
are available, but the extra cost isn't justified for this application.
The electronics to run the floppy drives, the hard drive, the mouse, and the monitor reside on adapter boards that
fit into the six slots on the main board. The video adapter board to control the monitor has a memory chip on it
with a capacity of 256 kilobytes, enough to provide 16 colors and easy-to-read text on the screen. When the video
adapter board is plugged into the main board, an opening in the back of the computer case exposes a plug to which
the control cable from the monitor attaches. The computer has a parallel port for a printer, a serial port for a
mouse, a game port to accommodate a joy stick for playing games, and an additional serial port for some other
device, if needed.
Perusing computer magazines shows many mail-order companies that sell computers like this one, priced lower, but
the support issue is important for The Ross Company. Local support is preferred because it would be difficult for
Ross to operate if the computer had to be shipped somewhere for several days to be repaired.
The remaining component necessary to operate an invoicing application is a printer to print each invoice once the
order has been entered. The selection of a printer is a different matter from selecting the computer. Printers
are mechanical, and their compatibility is not a big concern because a ten-year old printer that attaches to the
parallel port on an old-technology PC or XT computer will run on the newer technology AT computer.
The selected printer, a 9-pin dot matrix type, is nearly disposable because the cost of repair usually exceeds the
cost to purchase a new one, especially if the print head requires replacement. The cost of a new print head, with
the additional labor to install it, can exceed $200, the cost of a new dot matrix printer.
Printers come in several designs, depending on the type of print required (letters formed by dots or fully-formed
characters like those produced by a typewriter), the speed at which it will print, and the width of the carriage
(80 or 132 column). The most inexpensive printers are dot matrix types. There are nine-pin and twenty-four pin
dot matrix printers, with the nine-pin units costing the least.
Nine-pin printers use a print head with a matrix of nine pins that are pushed through the head block by magnetic
coils, striking the ribbon which leaves the imprint of the pins when the ribbon hits the paper. The configuration
of the dots created by the pins forms the letters. The pins operate very fast so the head can move along the page
as the pins move in and out, hammering the ribbon to make the images on the paper. A close look at the paper reveals
the presence of the dots that form the letters.
The best paper to use in a dot matrix printer to print invoices is continuous form stock that is fed by pins
fitting into holes on the edges of the paper. For an invoice, the use of a nine-pin dot matrix printer should be
acceptable. A slow printer will be fine for The Ross Company because the invoices are not printed in
high-volume.
Ink jet printers are more expensive. They don't use a ribbon. Instead, their print head uses tiny nozzles to
spray ink on the page, eliminating the ribbon, but requiring ink refills. The print quality is better than that
of dot matrix printers because the images are fully-formed characters.
Laser printers use the most advanced print technology, operating much like a copy machine. Cut paper is placed
into the tray and the printer pulls the sheets into it, one at a time, transferring the image onto it by an
electrostatic process. Laser printers are expensive, costing upward from $400. They do require the occasional
addition of toner, usually by removing the old toner cartridge and replacing it with a new cartridge. A cartridge
may be capable of printing more than 15,000 pages and the cost of a new toner cartridge can range from $40 to $200,
depending on the printer and the number of copies that can be obtained from the cartridge. Some higher-priced
cartridges contain some of the mechanical devices used to transport the paper through the printer.
For The Ross Company, a used nine-pin dot matrix printer is inexpensive, almost disposable, costs under $60, and
should produce an acceptably readable invoice. If the need arises for a new printer in the future, that decision
can be made later.
Acquisition of the Selected Software
There are several ways to acquire software just as there are several different types of software. Commercial
software may be purchased from one of the large chain stores that carry computers, software, and other business
equipment; from a store that specializes in software; and from mail order houses.
Shareware may be downloaded from a BBS (Bulletin Board System), purchased from a mall software shop, purchased by
mail order from a shareware provider, bought from smaller computer shops, and obtained from individuals.
Information about various software packages can be found by researching magazines, browsing software stores,
and perusing direct mail brochures.
Commercial software is usually fully functional as purchased, unlike some shareware programs that are distributed
as demonstration packages. Commercial programs normally cost more than shareware, partly because of marketing
costs that shareware writers do not incur. Public domain software is free since its ownership has been given to
everyone.
The approach used for this study was the acquisition of both commercial and shareware software. Each package was
evaluated without regard to its source. Packages that did not meet the needs of the company were discarded.
The checks that need to be made at the time of purchase are two. The software must be specifically for invoicing.
It should not be part of an integrated system consisting of several other applications that need to be installed
simultaneously. This requirement helps keep the scope of the project narrowed to replacing the manual package,
keeping the size of the effort reasonable.
The other check that should be made at purchase time is that the software is compatible with the company's computer,
in the case of Ross, an IBM compatible. The software box usually indicates the minimum system requirements,
specifying the such factors as the memory requirement, hard drive space, the DOS version, and monitor
type.
Chapter 4
DATA ANALYSIS
Evaluation Criteria for the Selected Software Package
Selecting software requires a different approach from that used to select the hardware. First, to gather information
on invoicing systems in use, some local companies were casually interviewed regarding their invoicing system. These
systems ranged in complexity from a very simple type used to print a sales slip at the time of purchase to a full-blown
integrated commercial software system by Peach Tree that consisted of all the major accounting functions, including
invoicing. Because of its complexity, the Peach Tree user reported that it was difficult to learn.
These interviews confirmed the opinions of Mick (1984) and Shamlin (1989) that a simple system be chosen for the
conversion of a manual, stand-alone system. The reasoning is that the first conversion should be basic in order
to help insure the success of the project.
Shamlin (1989) provides a list of items that the selected software should meet. This list seems to represent the
general requirements for The Ross Company. Each of Shamlin's items is followed by a comment about how it relates
to Ross.
- It should be easy to install.
There are certainly excellent packages available that are difficult to install, but a package with this
characteristic illustrates that it may not be written for a novice user or it has not been well designed.
The package intended to replace a manual system, should be a simple package that emulates the manual system.
- Getting it running should be easy.
The comments observed above, in item 1, apply here. If it is difficult to get running, then it probably isn't a
desirable package for Ross.
- Menus should be available to guide the user.
A package should be easy to use by a person unfamiliar with computers. This could be accomplished by making the
program menu-driven so that the user could easily select functions. Menus eliminate the need to know specifically
what keys to press to get into a function.
- It should have a good data entry capability.
The user should be able to operate the package without having to learn a lot of special key strokes or function keys.
The necessity of a physical template taped to the keyboard to guide a user through a plethora of options is undesirable
because it requires the user to divert his attention away from the screen. An example of a package that required
the use of a template is WordPerfect, versions prior to 6.0. Version 6.0 dispensed with the obfuscating template,
replacing it with on-screen options and pull-down menus, making it much easier to use.
- The reports it generates should be sufficient.
This is important, especially for packages that lack another means of retrieving data from the data files. Since a
lot of information eventually resides in the files of a package, the ability to get to it is important. Not only
should it be viewable on the screen, there should be a capability to print it. Useful information that might be
provided by the reporting function of an invoicing system might include the following:
- A listing of the customers in the customer file.
- A listing of the items in the inventory file.
- A summary of items sold, by part number, for a user-specified period of time to analyze ordering
history.
- Total sales, in dollars, for a user-selected period.
- It should function like the manual system that it replaces.
The program should emulate the manual system's invoice format that shows both the suggested retail price as well as the
unit and extended item price the customer would have to pay Ross. This, then, would require three amount columns for
each item shown on the invoice: Suggested Retail; Unit Cost; and Extended Unit Cost. The general format of the invoice
should remain the same.
The importance of this requirement is that some customers might not be pleased if the invoices began to appear
different, and the learning curve for the Ross employees would be steep if the new system operated philosophically
similar to the manual system.
- It should have no weaknesses such as the requirement to use only special forms or a limited number of
printers.
Most weaknesses should be discovered during testing, including the need to purchase invoice forms from the software
house. The question of printer limitations would not come up unless the company elected to change to a different
printer and found that the package wouldn't support it.
A severe problem should disqualify a package. The worst time to discover a failing is after the package is in use.
Testing should be as thorough as possible, although it is nearly impossible to detect every possible negative aspect
in a package. In cases where a severe fault is discovered later, the option to investigate a replacement package
should be considered.
- It should work smoothly and switch easily between functions.
The package should be capable of updating the customer and inventory files "on the fly," during the invoicing function.
This would make invoice creation a seamless operation.
Although other authors cited similar criteria, Shamlin's list seemed to be most closely applicable to small businesses,
so it is covered in detail here.
Evaluating the Selected Application Software
Software evaluation is an important aspect of selecting a new software package. It must be proven that it meets
the Company's needs as well as being acceptable to those users who will be assigned to operate the software.
For this study, the evaluation phase began with a review of the functionality of the original manual system that
represented a benchmark against which to measure candidate software packages. Following the review of the manual
system, a replacement software package was acquired and installed on the computer. A preliminary check was made to
ensure that the package is compatible with the computer to make sure its disk and memory requirements did not exceed
those of the computer. The Ross computer's disk capacity is 40 MB and the installed memory is one MB. If the
software would operate with those limitations, then it was ready to be evaluated through user testing. If the
software failed to operate smoothly or exhibited incompatible behavior, it was discarded, and the search for another
package was begun.
User acceptance is the most critical part of the evaluation process because the user may disqualify the package at
any time if it fails to satisfy his requirements.
Software evaluation is divided into two basic types: execution-based and non-execution techniques. The software
house is responsible for non-execution program testing since the purchaser either does not receive the program source
code and program specifications or does not posses the time and expertise to do it. The sole means of user
verification, then, is execution testing. (Gianturco, 1994).
For the purposes of this study, path testing is the most suitable means of determining functionality of the selected
program. The user tests the program by executing it and analyzing its performance based on how it processes
input.
The first invoicing program was acquired and installed on the computer. Preliminary indications were that it
provided fully-functional capabilities. The user began the evaluation by entering the invoicing mode and putting
in a dummy invoice. The first problem that arose, since the customer file was empty, was that a customer had to be
added for the test invoice to be created. To the regret of the user, the program's structure required the user to
exit the invoice function altogether, enter the customer maintenance section of the application, and then enter the
customer information.
After all the customer information had been added, the user had to exit the customer maintenance function and
reenter the invoicing function. He had to locate the invoice he had been working on and then enter the customer
name, which enabled the program to fill in the customer information.
The next step in the test was to create an invoice by entering the items ordered by the customer. For inventory
items, the program operated in a like manner as it did for customer data. If an item was not on the program's
inventory file, the user was required to exit the invoicing function, enter the inventory part of the program,
and then enter the inventory items.
After the inventory items had been entered, the user had to return to the invoicing function and then begin
entering the items. If an item was inadvertently left off of the inventory file, the user had to back out of
the invoicing part and reiterate the process to get the item added to the inventory.
This was a time-consuming and inefficient process, but in defense of it, if a company had a list of inventory
items that it could enter completely before using the program, then it would have been a satisfactory application.
However, the user didn't want to enter all 25,000 items because it would be too large an effort, and not all 25,000
items would ever be ordered. The user decided that this package failed the evaluation because the interface between
the invoicing and customer and inventory functions was not was not smooth.
The user needed a software package that allowed entry of customers and inventory items "on the fly." With this
capability, the user could begin an invoice and temporarily go into the customer function to make an addition or
change, then immediately switch back to the invoice with a minimum of keystrokes. The same capability was needed
for inventory items. During the entry of items ordered by a customer, if an inventory item did not exist on the
inventory file, then the user could instantly switch to the inventory file and add the missing item, then immediately
switch back to the invoice, resulting in an efficient invoice entry process.
A week later, a second invoicing program was acquired through a local retail office supply store that was part of a
nationwide chain. The cost of the package was $17. It was installed and the preliminary investigation began.
Unfortunately, after the program was installed, it would not run, displaying a message indicating that the computer
lacked sufficient memory.
This problem was with the software itself. Only the first 640 KB of the one MB memory is "executable," meaning
that the extra memory is useful storage for an intelligently written program, but program instructions cannot be
executed in the area above 640 KB. The computer was set up to use some additional operating features which are
aids to operating the computer, but eat up some of the 640 KB of memory.
Although it would have been easy to cut out the few extra features to provide the full 640 KB of memory, it was
decided that since the software utilized poor memory management, it was very likely to fall short in other areas.
Besides, the company didn't want to have to give up additional features for the sake of an invoicing program.
In the event a suitable invoicing package could not be found, it would be possible to return to this package to
reevaluate it.
Modern, well-written programs are designed to manage computer memory so that they don't require the entire 640 KB.
For example, WordPerfect version 6.1 requires 32 MB of disk space for installation, but to run, it requires less
than 600 KB of memory. This is because the WordPerfect program manages the memory by loading in small parts of
the word processing program, bringing in additional parts to overlay the first part, as needed. In this way, it
is flexible enough to operate even if the available memory falls short of 640 KB.
The third program was purchased from another local retail software vendor that was part of a nationwide chain.
The cost of this program was $32.00. The program passed the initial inspection and went into the testing phase.
It soon became evident that this program had one insurmountable fault. It would not print a meaningful invoice on
plain paper, requiring pre-printed forms that could be ordered from the software house. Although this might have
been perceived by the software house as a clever marketing ploy that would bring in additional sales generated by
forms purchases, the user was not impressed. He did not wish to be committed to purchasing pre-printed forms from
a vendor whose life-expectancy was unknown, and for a cost that could escalate over a period of time.
Another factor that did not come to light at the time of the evaluation was whether forms could be purchased for laser
printers as well as dot matrix printers. Also, the information that was provided by the software house did not indicate
if the forms were multi-part or single sheet. In any case, the user rejected this package.
The user wanted to use white, stock paper and have the program print headings on each page. White, stock, continuous
paper is inexpensive and readily available. Also, the program should be capable of printing multiple copies of each
invoice to emulate the manual system that had used four parts.
The fourth program to be tested was shareware, obtained from a mail-order shareware vendor. Although shareware may
not seem to be a likely source for a company's software system, historically, there have been some excellent shareware
packages. Examples include Procomm, a superb communications package; PC-Write, an excellent, full-featured word
processor; Wampum, an easy-to-use, menu-driven database program; and Medlin, a very capable accounting package.
Top-grade commercial software is often marketed as shareware, just to get the user interested in it. The price for
the shareware diskette was a nominal $5 to cover duplication and shipping charges.
The shareware invoicing package is called "Invoice-It." This program was loaded onto the computer. Preliminary
evaluation indicated it would run in the available memory. It is menu-driven with attractive screens. Browsing
the menus showed that it can maintain the three major areas of an invoicing system: customer file, inventory file,
and invoice file. In addition, it has a basic reporting module that provides some statistical reports. One example
is a display of the total dollar amount that customers have ordered during a user-specified time period.
Evaluation proved that the program would allow the user to enter the invoicing function, then pop into the customer
or inventory areas to add or change information, as necessary. In addition, the system was easy to use and provided
clear menu selections, enabling the user to begin running it after only a few minutes of investigation.
Although this package was better than all of the previous programs tested, it wasn't perfect. It didn't allow for
three amount fields. It only had room for unit cost and extended unit cost. There was not column for suggested
retail price, a very useful item for customers to use to price the product for sale in their stores and to enable
them to determine their gross profit margin: the difference between unit cost and the suggested retail price,
assuming they planned to sell the item at the suggested retail price.
In the old manual system, the pre-printed four-part forms had three columns. However, the user, the shipping clerk,
liked the package, and he wanted to make it work, if at all possible. He provided the idea of placing the suggested
retail price in the item description line, to the far right, to look like this: LIST $XX.XX.
The user decided to use the word "List" on every item line because the invoicing program didn't have any means for
allowing a user-defined heading. The plan was implemented and is a success. The line provides enough room for the
item description as well as the list price. The shipping clerk began entering the list price whenever he added a
line item, and he even positioned it so the word "list" would line up evenly in a column on the invoice, resulting
in a neater look.
Another problem corrected by the user was that the quantity of each inventory had to be greater than zero or the
item could not be ordered due to insufficient stock. Since inventory control was not intended to be used as part
of the invoicing system, the user decided to enter all nines in the inventory quantity field. Each time an item
was ordered, the inventory quantity was reduced by one. Eventually, the user will have to go into the inventory
system and increase the quantity to all nines once again, but this will not be soon.
The user evaluation continued for another week, with no further problems. The used dot matrix printer had been
installed so that invoices could be printed. Although it printed slowly, and did not provide letter-quality
output due to the nine-pin print head, the user deemed the invoices satisfactory.
After two weeks of testing and loading inventory items and customers, the system was considered ready for live use,
and the switch was made from manually typing invoices to entering them on the computer. The timing was opportune
because the invoice typist retired two weeks after the system went live.
The user was sufficiently impressed with the package to order the commercial version of the software from the
software house, Future Systems, for $39.00. Future Systems sent the latest version of the software and a guide
booklet. The commercial version was the same as the shareware version with the exception that it was updated to
include the latest refinements and new statistical reports. Also, the purchase provided free client support by the
vendor, but toll-free calls to the Texas office were not provided.
After the cut over, the invoicing function was more time-consuming than typing would have been because, although
many inventory items had been entered, nearly each order included several items that had not yet been entered and
required the shipping clerk to add them during invoice creation. By the third week, the number of items that needed
to be entered had dropped to one or two per invoice, and the invoicing process began to speed up.
With a total of 25,000 items that could be ordered, it was not practical to enter them all into the system.
However, within a few weeks, all of the commonly ordered items had been entered on the computer, about 3,000.
The overall look of the invoices was much improved. Mistakes that had been manually corrected on the typewriter,
were simply corrected on the computer and the invoice reprinted. With the manual system, the cost extension for
each item was done using a calculator, and the invoices had to be double-checked because errors were not uncommon.
The new system accomplished it automatically. Adding up the extended cost column was another potential source of
errors, and, again, the computer eliminated mathematical anomalies.
After the automated system had been running four weeks, a new quarterly pricer was delivered. It contained a list
of all 25,000 items, and the prices had changed for some of them. Fortunately, it is an easy task to check the
items on the computer to those in the pricer because they are both in the same sequence: sorted by item number within
manufacturer.
By bringing up the inventory file on the computer and opening the pricer to the same manufacturer, it is possible to
simply go down the list in the pricer and look for items marked by an asterisk. An asterisk indicates that the item's
price has changed. When an item with an asterisk is found, the corresponding item in the computer is adjusted by the
user.
Three amounts have to be changed in the computer: the list price (in the description field), the cost to Ross (never
printed on invoices and only printed on in-house reports), and the unit cost to the customer. The suggested list
price and the cost to Ross are provided by the pricer. With a few exceptions, the cost to the customer is calculated
at twenty percent over the cost to Ross.
So, every quarter, when a new pricer comes out, the computer inventory file has to be updated. This is much less of
an effort than the requirement of the old, manual system, to look up the cost information for each item in each
invoice. The correction to all inventory file prices can be accomplished over a period of several days.
Thirty days following the installation of the commercial version of the software, it crashed. A call to the vendor
provided the answer to the problem. Each time the program was started, it had displayed a message suggesting that
the program be registered. The user incorrectly assumed that this message could be ignored because registration
was automatically accomplished through purchase of the software. What the message meant was that the user should
go into the setup part of the program and enter the number printed on the software diskette. This is Future System's
method of preventing a copy of the software from being illegally distributed. The number on the diskette was entered
into the system and it returned to normal operation.
The system performed very well under the operation by the shipping clerk. He handles the invoicing system entirely by
himself, takes orders over the phone and by fax, enters them into the computer, prints the invoices, and ships the
orders.
As noted previously, the invoicing program provides the user the opportunity to select a number of copies to be
printed. To emulate the old, manual system, the package was set up to print three copies of the invoice which
are distributed as follows: one that is sent with the order shipment, one to the customer file, and one to be
used for entering data into the accounts receivable system which is installed on the owner's home computer. The
four-part forms used with the manual invoicing system provided a means to identify the distribution of each page.
The white, original copy was sent to the customer with the shipment, the pink copy was filed in the customer file,
and the yellow copy was used to enter the order information into the accounts receivable system. The canary copy
was discarded except when an extra copy was needed for a drop shipment, in which case, it was sent with the order
to the drop ship location.
Since the new system prints invoices on white paper, a means was needed to indicate the disposition of the file copy.
The shipping clerk devised a solution. He ordered a rubber stamp, "FILE COPY." One of the three copies was stamped
with "FILE COPY," and filed in the customer file. One copy was placed in the shipping container, and one was used to
enter the accounts receivable information.
If a shipping copy is required for a drop-shipment, the program provides a shipping copy that omits all pricing
information except for the list price quoted in the description field. This shipping copy can be requested just
before the invoice is printed, or it can be printed after the three invoice copies have been printed.
With the old system, if a fifth copy was needed for any reason, or a replacement copy was needed to replace one that
was lost or mutilated, an existing copy had to be copied on a copier. There were instances where the in-house copies
were misplaced or lost. In such cases, there was not way to recover them. With the new system, extra copies may be
printed any time they are needed.
The Impact of the New Invoicing Software on the Company
The Ross Company was able to operate with only one full-time employee instead of one full-time shipping clerk and a
half-time typist. The cost of the computer and used laser printer, which ultimately replaced the dot matrix printer,
was about $1000. Two-months of wage-savings, approximately six hundred dollars a month resulting from the retirement
of the invoice typist, offset the cost of the computer system.
The use of plain paper in place of pre-printed four-part invoice forms resulted in an annual savings of
approximately $150. Although there was an increase in electricity usage, it was not judged significant,
especially considering that during the winter months, the elderly typist had used two electric heaters
beneath her desk, which the shipping clerk did not need.
One change that saved time and money was the elimination of mathematical errors that sometimes occurred with the old
system. The time required to produce an invoice was reduced. Approximately two minutes were required to look up the
item cost in the pricer and then type it on the four-part form, using the old system. The new system requires about
thirty seconds to key a line that has the item in the inventory file. Therefore, the estimated time savings for
producing an invoice line with the new system is approximately one and a half minutes.
The time required to add an occasional inventory item onto the new system's inventory file is offset by the time
savings provided by the automated calculation of the extended cost of an item and the addition of the unit cost
and extended cost fields. The overall time required to key an invoice into the new system is one-third of that
needed to type it in the old system. This time efficiency has allowed the shipping clerk to handle both the
invoicing and the shipping functions by himself.
A non-monetary impact on the company is a much better-looking invoice. Customers have complemented the company on
its clearer, more professional document.
Time Requirements for the Study
A discussion of the time required to accomplish the study is of interest because there should be some correlation
to the time requirement for other small businesses to do a conversion of similar scope (See the chart in Appendix
A).
The project began in early October with the search for a subject company. Of course, this part of the process is
specific to only this study. The subject company was identified and an agreement in place by mid-December. The
hardware selection process required the last two weeks of December, followed by hardware installation during the first
week in January.
A software package was selected in mid-January. It was installed and tested shortly after acquisition, and this
became a reiterative process as four packages are acquired, installed, and tested until the fourth one was deemed
satisfactory by the user in late March. This process is shown by three, nearly parallel, lines on the chart in
Appendix A, representing these concurrent activities.
Once the final package had been selected, the preliminary data had to be entered before going live. This consisted
of the printer set-up procedure and entry of the company's primary customers. A few inventory items were already on
the system because real items and prices had been used for test purposes. Additional items would be entered on the
fly as invoices were created for customer orders. As mentioned earlier, it required several months until all of the
commonly ordered items had been entered onto the Invoice-It database.
The entire length of the study required six months. For a similar conversion by another company, the project would
be shorter by two months because the selection of a subject company would not be part of an actual conversion effort.
The estimate for a small company to do a conversion like this one is four months, assuming it followed the approach
described herein and converted a similar manual system.
Chapter 5
SUMMARY, CONCLUSIONS, AND RECOMMENDATIONS
Uniqueness and Limitations of the Method
The method is unique in that instead of relying solely on literary sources, surveys, or a combination of both to
prove or disprove the theory, a company was chosen to be the subject of the study. The theory that a small company
could convert an application with little outside assistance was tested in a real-life situation.
This method does have a major limitation. What might be successful at one company may not work at another. In that
respect, perhaps the selection of The Ross Company caused the outcome to be positive, and the selection of other
companies might show negative results. If Ross is typical of small companies that are still using manual systems,
then this approach could have wide applicability.
Another limitation of the method is that it addresses only one company instead of a group. It would be difficult to
duplicate this particular study with several small companies. However, as described in the section on suggestions for
further research, a two-part study beginning with a survey and following up with guidelines for converting a manual
system.
Finally, this study method required intervention, evidenced by the presence of an observer who was doing the study.
In quantum physics, the "uncertainty principle" states that the act of observing a system or event causes the results
to change (Encyclopaedia Britannica, 1968). Although the study of human nature is far different from that of physics,
the effect of the presence of an observer is a concern because it could change the outcome of a project such as the one
undertaken in this study. The answer to this question shall have to await a future study that involves transference
and the success of a company to convert an application by itself without the presence of an observer.
Conclusions Related to User Involvement
One common theme that was stated by several authors was the importance of involving employees who would actually work
with the system after its installation. The authors agreed that without giving them knowledge about the project and
letting them participate in it, users would not readily take ownership, and, instead, might allow the system to fail
or run at a low level of effectiveness. This theme was tested by having the shipping clerk, the person who would
actually be responsible for running the system after it was live, to install, select, and test the invoicing
system.
The first invoicing program selected for testing was installed on the computer by the user after he read the
accompanying instructions. Then, when he had a half hour or so available, he started the invoicing system. With his
knowledge of the manual system, he noted potential problem areas and thought of ways around the problems. The first
three systems chosen for analysis were not successful in meeting Ross' needs. The fourth wasn't perfect, but a
modification to the way inventory is entered solved the problem. The shipping clerk suggested it and tested the
idea on the computer to insure that it would work.
It could be argued that he elected to use the system out of self-defense because he didn't have time to type the
invoices, but the situation during the first few weeks indicates that although he didn't like typing invoices, the
new system required that he spend more time with it than he would have typing them. For the first few weeks, he
had to learn the new system, and when he keyed an invoice into the computer, he had to put in everything, the
same as he would have had to do typing on the typewriter.
The user recognized that he would only have to enter a customer's mailing and shipping addresses once. Thereafter
when he needed to create an invoice for that customer, he needed only to press a few keys and it would pop up on the
screen, ready for him to enter the items ordered.
The same was true for inventory items. He had to learn how to enter them, and then enter each one according to the
way the system would work best. Entering an invoice item into the computer took much longer than it would have had
he typed it because the entry required more fields to be keyed. These included item cost to Ross, the number of
items in inventory, the manufacturer, and the supplier.
However, like the customer addresses, inventory items needed to be entered only once. After that, they were still
there, ready to be pulled up the next time a customer placed an order for them.
To further substantiate the idea that the shipping clerk had taken ownership of the system, in his spare moments he
would sit down at the computer and actually enter inventory items from the catalog that had not been ordered, but
that he knew were ordered frequently. In this way, he was spending the time to enter them before they actually
needed to be put in. The result is that he was accelerating the development and functionality of the system.
As had occurred in Feynman's (1985) experience in the Los Alamos computer lab during World War II, the shipping
clerk required no supervision for running the computer system. Not only did he make sure data was entered accurately,
he also decided to take responsibility for the hardware. He learned to adjust the dot matrix printer to provide the
best clarity, and he replaced the ribbon whenever it became worn. When the excess toner hopper filled up in a the
laser printer that replaced the dot matrix printer, he read the manual and found out how to open up the printer and
empty it. The shipping clerk was able to integrate the invoicing function into his own schedule and soon was
comfortable doing both jobs.
The conclusion is that by involving the user, he became the principal supporter of the new system and worked hard to
insure its success. It would be incorrect to assume that this approach would work for every small business because
too many variables are involved. Companies and the people and systems that are in them differ. The experience at
Ross could be an indicator that it is possible to get employees in a small company to convert to automated
systems.
Conclusions Related to Package Selection
Choosing a relatively simple, single-purpose system for converting a manual system was another common theme discussed
by several authors. The basis for this philosophy is that for conversion from a manual system, the new system is
probably not going to be the last, and trying to convert to a complex system is likely to bog down a first-time
conversion effort, putting the project in jeopardy. The change from a manual system to an automated one is usually
a difficult task for a small company that lacks extensive computer expertise. Also, because the change between the
manual and automated systems will be dramatic, a company should have the opportunity to get used to the change and
integrate its methodology into company operations before considering a complex package that might be much more
difficult to install and run.
This study showed that by taking a conservative approach to upgrading one manual system to a stand-alone
computer-based system, the user was able to successfully do the installation, testing, and eventual implementation
of the selected software. This plan could be followed by more challenging conversions in the future, using knowledge
learned by this first conversion as a basis.
Limitations of Program Capabilities
Although the selected invoicing program meets the basic requirements of emulating the functions of the manual system,
a month following implementation, further capabilities were investigated. A labor-intensive operation still carried
on in the company is the collection of copies of the invoices created by the new invoicing program followed by the
entry of them into the accounts receivable system on the owner's home computer.
The owner runs the accounts receivable system from his home because that allows him to work on it during evenings and
weekends. This operation requires the owner to collect a copy of each invoice, take the copies home, enter them into
his accounts receivable system, print the statements, stuff the statements into window envelopes, and mail
them.
The shipping clerk recognized that the invoicing system has a statement printing capability built in. However,
tests of it showed that it was only capable of applying the exact amount of payment to one invoice. The Ross
Company's customers send payments that cover one or more invoices, and the amount they send often does not exactly
equal that of a number of invoices. The owner's accounts receivable system, a shareware package called Medlin,
accommodates the receipt of any amount and carries the remainder until the next payment is received. It is suitable
for The Ross Company's needs, but it doesn't interface with the Invoice-It invoicing system, hence, the need to
enter invoice amounts manually. Medlin does not have an invoicing system built into it. It is an accounting
package that is directed toward accounting functions such as accounts receivable, accounts payable, fixed assets,
and general ledger.
The best situation for The Ross Company would be to have an invoicing system that interfaced directly to an accounts
receivable system. Upon receipt of a check, entering the name of the company would bring up an option to enter the
amount. The program would apply the amount of the check to the oldest invoice. If the invoice amount were larger
than the check, the program could determine how the user would wish to apply uneven amounts: either partially to an
invoice with a larger amount or disregard the invoice and check subsequent invoices. After applying amounts to
invoice amounts smaller than the original and resultant residual amounts, any remaining balance from the original
check would be held, to be added to the next check received. A report noting partially or wholly unpaid invoices
would be created, along with statements to be sent to customers.
The illustration of the lack of interface to another system is presented here to show that an information system
decision, in this case, the selection of a computer-based invoicing system to replace the manual system, did not
meet all invoicing, payment, and billing needs. This is not an untenable situation, however. The positive aspect
is that the implementation of the invoicing system was successful, and that was the desired outcome.
A new invoicing system with a built-in accounts receivable system or a satisfactory interface to an external
accounts receivable system would solve the problem of having to manually reenter the invoice information into an
accounts receivable system. This means that a new invoicing system that accommodates receivables eventually may
be selected. The necessity to do this is not immediate. The invoicing system has reduced the company overhead.
To further reduce the overhead by eliminating the need to manually enter invoice data into the accounts receivable
system requires a different approach, one that is beyond the scope of this study. It is discussed herein to present
the reality of information system challenges.
Suggestions for System Enhancement
At some time in the future, it is expected that the selected software may not be able to adapt to new requirements.
This should be an anticipated part of system evolution, and it will require decisions. The options would include some
of the following.
First, the selected software may be left as-is, for the near-term, with no further enhancements. This may be a good
solution. The new software has achieved the desired results. Further improvements may not be possible without
changing to a different software package.
Second, an entirely new software package could be selected with more functionality than the first. The knowledge
acquired from the experience getting the first package going may result in changed or expanded system requirements.
By selecting a new package based on these new parameters, the existing system could be replaced.
There are many other possibilities, but they would be expensive. For example, a consultant could be hired to write a
system that would be acceptable. Or, the consultant could write an interface between the existing invoicing system
and a new accounts payable system.
Although the implementation of the invoice system has been successful, the shipping clerk must still manually type
shipping labels for each order. The shipping clerk suggested that automating this function could further reduce the
time required to assemble an order for shipment.
Currently, the shipping clerk must pull a blank, two and one-half inch by three and one half inch, standard-form,
glue-backed shipping label from a pad. The company's return address is placed on it using a rubber stamp. Then
it is inserted into the typewriter. The shipping address is typed onto the label by referring to the shipping
address on the invoice.
The implementation of an automated print facility for shipping labels should enable one label to be printed at a time.
Since the existing laser printer won't accommodate forms the size of a single label, a multi-label form wouldn't
provide for printing one form at a time, and changing paper in the laser printer would require extra time, a dedicated,
inexpensive dot matrix printer would be the best choice for printing shipping labels.
The preferred label stock for printing in a dot matrix printer would be a one-up continuous form that could be torn
off the printer after one was printed. The label would be large enough to allow printing of the Ross's return address
followed by the customer's shipping address. Although printing the return address each time might be considered a
waste, it would allow for the purchase of generic, inexpensive labels that would not require the return address to
be pre-printed on them.
The invoicing program does have the option to print the customer's shipping address, but it is designed to use only
one specific label size, one by three and one half inches. This small a label would not have room for a return
address, even if the invoicing program could print it. However, a solution to the problem could be to use the rubber
stamp on the box or on another label that could be applied above the customer's shipping address label.
Both printers could be connected to the computer's single parallel port through a print select switch. This switch
could be a cause of inconvenience if it were left in the wrong position when printing. The result could be printing
a label on the plain paper in the laser printer or printing an invoice on the continuous-form mailing labels loaded
in the dot matrix printer. However, this problem would become rare with increased experience.
Another option would be to install a second parallel printer port in the computer and configure it as "LPT2." In this
manner, the label print program could direct labels to LPT2 and the invoicing program could send invoices to the
current printer port, LPT1.
The easiest approach to printing shipping labels seems to be to print them from the invoicing program and use a
separate, pre-printed label or a rubber stamp for the return address. By using the large labels that are currently
available, stamping them with the Ross return address as is currently done, and affixing the smaller, invoice-printed
label across the "ship to" portion of it, might provide the easiest solution. This would eliminate the need to
manually type each shipping label, but it wouldn't reduce the current workload in a significant way since the average
number of shipping labels used each day is ten to fifteen. On the positive side, the automated labels would be
consistent in their content with no typing errors or corrections, and they would look more professional. The
current shipping labels sometimes give the impression that the shipments are coming out of a "ma and pa" operation
(which they are).
The other areas that could be computerized are inventory control, general ledger, fixed assets, and accounts payable.
They could streamline the financial tracking and reporting systems, especially if a large, integrated package were
installed.
Transference of this Approach to Other Businesses
Because this study has shown that a small company can utilize its own personnel to bring up a new computer application
to replace a manual system, the suggestion is that other small companies might be able to do the same. A future study
could prove that supposition. (See "Recommendations For Further Research.")
The method used to transfer this information to other businesses is a problem for further research. However, by
following some simple guidelines developed in this study, a small company should be able to analyze its current
manual applications to determine if one is a candidate for conversion. If one is found, then the steps taken herein
can be a general guide for accomplishing the project.
Applicability for other businesses is one thing. Actually transferring that knowledge is quite another. Some
businesses would be able to accomplish such a project, but others would not. Although small businesses have a
lot in common, each one has slightly different ways of operating, different philosophies, and these differences
may make the use of a generic software package impossible. In cases like this, the company may have to resort to
hiring a professional software developer to obtain a custom package suitable for its operations. Such an approach
is outside the scope of this study.
The point made by this study is that for simple applications, transferability seems very likely, but the proof of
that will have to wait for a future study. However, a scenario that might work is described below.
After a candidate company that might benefit from converting a manual application to a computer has been identified,
an attempt to transfer the knowledge developed in this study could proceed.
The transference could take place using a cookbook approach, to be accomplished by the manager of the subject company
or someone he assigns, as follows:
- Write down the primary functions being accomplished in the company. First, review the duties of each employee,
including those of the company manager, and create a list of each employee's major duties with a corresponding
estimate of the average daily hours spent on each task. For example, the list might look like Table 1.
- Table 1
- Employee's Tasks List
- EMPLOYEE
- Manager - TASK: Payroll; AVERAGE HOURS PER DAY: 2
- Manager - TASK: Reconcile Accounts Receivable and Accounts Payable; AVERAGE HOURS PER DAY: 2
- Julie - TASK: Wait on Walk-In Customers; AVERAGE HOURS PER DAY: 1
- Julie - TASK: Take Phone Orders; AVERAGE HOURS PER DAY: 2
- Julie - TASK: Type Invoices; AVERAGE HOURS PER DAY: 3
- Matt - TASK: Pick (pull items from Inventory), Pack, and Ship Orders; AVERAGE HOURS PER DAY: 5
- Manager - TASK: Pay Bills; AVERAGE HOURS PER DAY: 1/2
- Matt - TASK: Inventory Control; AVERAGE HOURS PER DAY: 1
- Now reduce the list to the tasks that are most likely to be accomplished by a computer. Matt's picking,
packing, and shipping task requires manual labor that couldn't be replicated by a computer using today's technology.
The same is true for Julie's duty of waiting on customers and taking phone orders. These two items should be
crossed off of the list because they could not be automated on a computer.
- The remaining items can be prioritized by their potential for benefiting the company if they are
converted to a computer. Those that would provide the most benefit go to the top of the list. Those that would
benefit it the least go to the bottom of the list. One way to prioritize the remaining items is by using the
average number of hours per day the employees spend doing each task. The activity that requires the most time each
day could provide the most benefit if converted from a manual system to a computer. The prioritized list might look
like Table 2.
- Table 2
- Employee's Tasks by Hours
- EMPLOYEE: Julie - Task: Type Invoices; AVERAGE HOURS PER DAY: 3
- EMPLOYEE: Manager - Task: Payroll; AVERAGE HOURS PER DAY: 2
- EMPLOYEE: Manager - Task: Reconcile Accounts Receivable and Accounts Payable;
AVERAGE HOURS PER DAY: 2
- EMPLOYEE: Matt - Task: Inventory Control; AVERAGE HOURS PER DAY: 1
- EMPLOYEE: Manager - Task: Pay Bills; AVERAGE HOURS PER DAY: 1/2
Although there are other methods of determining which manual system could provide the most benefit if automated,
the average number of hours per day was used in this example. The table shows that the invoicing function would
provide the most benefit. Automating any of the other functions might be helpful, too, but converting them wouldn't
have as much impact as automating the invoicing system, based on the number of hours required to do each task.
- The next step would be for the manager to meet with the invoicing system user (Julie) and discuss the
possibility of converting the system to a computer. Getting her support in such a project is a key item and could
mean the difference between success and failure of the conversion effort. The manager could address the idea of
converting by bringing up the possibility that it would help Julie do her work and provide the company with better
information.
Depending on the relationship between the manager and Julie, the conversation could be tailored to elicit ideas from
Julie to get her involved in the decision-making process. This is the first step to her taking ownership for the
computer project and, ultimately, the new invoicing system. The process of involving the user might be best
accomplished by spreading it over a period of a few weeks with a couple of discussions with her each
week.
Several important aspects of the planned conversion should be addressed. Julie would need to be assured that her job
was not in jeopardy; that her position was more important than ever. She would need to feel like a key member of the
team.
- Once Julie had emerged as a member of the team (even though the team may consist of only the manager and her),
the details of the plan should be unfolded for her. The plan is basic: to find a representative package, install it on
a computer, and test it to determine if it will meet the company's needs. It would be hoped that the user, Julie in
this scenario, would take a major responsibility in the project, helping make the selection, doing the computer
installation by following the instructions provided with the software, and then running the package by keying in
representative data and analyzing the results and the performance of the package. Her job may have to be adjusted
so that she has sufficient time to work on the project.
The manager must keep himself informed of the progress and findings so that he may help guide the project. His input
regarding the acceptability of a package is very important because he represents the philosophy of the company.
This may be a reiterative process if the first package fails to live up to the expectations of the company. It may
have to be removed from the system and another package selected and installed for testing. This circular process may
continue until a satisfactory package is found or it is decided that no computer package will achieve the desired
results and the manual system will have to be continued.
Future Conversion Considerations
When the decision is made to convert the computer-based package to another application package, the approach to
converting depends on the design characteristics of the old and new programs.
Some applications, particularly fully-functional word processors, have a built-in conversion capability that allows
the user to select the name of the package that originally created the file, and it is converted from the old format
to the new.
If an invoicing program were discovered that could read the files created by the current Invoice-It invoicing program
and convert the data to its own format, that would solve the problem of how to get the information from the old system
to the new. It is unlikely that such a system exists for several reasons. There are many different invoicing programs
and not any that have captured enough of the market that competitive pressure requires them to provide conversion
utilities for competing systems. Unlike competing word processing systems that often have a need to pass text files
between themselves, invoicing programs do not have this capability.
Another approach to converting data where the old and new packages lack any conversion ability or don't share common
file formats is the method of programmatically extracting the data from the old system files and then feeding it into
the new system's files. The problem with this approach is that it requires a deep knowledge of computers. Since the
assumption of this study is that company employees have little computer knowledge, this method is eliminated as a
viable solution. Of course, a consultant could be called upon to provide the necessary technical expertise to convert
the data, but this would be expensive, and another assumption of this study is that the company's cash flow won't
accommodate such an expenditure.
A fourth approach is the simplest, but the most time-consuming. The user prints the contents of the old system then
keys the data into the new system. In the best scenario, the specific data requirements in both systems would be
similar, if not identical, requiring little or no modification or addition to the data in the old system prior to
entering it into the new system. In a less desirable framework, the data in the old system would have little
compatibility to the data requirements of the new system. In a case such as this, the old data must be modified
and often supplemented by additional data before being entered into the new system.
A worst-case scenario is where the data in the old system isn't easily printed. Such a system might provide a good
screen presentation of the data, but it might not be capable of spitting out all of the data to the printer. In any
case, the framework of this study didn't investigate the problem of converting from one computer system to another.
This discussion was deemed valuable to provide insight into possible situations that might be presented during the
system life cycle.
Recommendations for Further Research
One limitation of this study is that only one company was the subject. Further research could be aimed at a large
population of small companies. By some method, perhaps interviews or questionnaires, a group of small companies
could be investigated to determine those that might be candidates for implementation of a computer system.
The approach could begin by contacting small companies across a given geographic area, such as a state, group of
states, or, perhaps the entire country. Or businesses of a certain type could be contacted. Mailing lists for
businesses are available from list sellers shown in the Yellow Pages. The target companies could be reduced to a
manageable size by culling those that were less likely to be in the target groupings. For example, the study
could target dry cleaning establishments grossing less than $300,000 per year.
Using the final list, the selected companies could be sent a questionnaire that would attempt to determine if the
company already had a computer. It could ask if the company had any manual systems that might be candidates for
converting to an automated system. The development of the questionnaire would be a critical item in the study.
Not only would it have to be designed to increase the likelihood of receiving a response, but it would have to ask
the right questions so that valid conclusions could be drawn.
A generalized approach to computer solutions could be drawn up. Each group of companies that might be assisted by
one of the generalized solutions could be mailed an info packet.
- First, they could receive a note thanking them for their participation in the survey and the results
of the survey
showing all the company groupings, with their own group highlighted. The statistical analysis probably shouldn't
include specific company information such as name, address, or phone number for privacy reasons.
- Second, each respondent could receive a guide to the actions they might take to convert a manual
information system.
This information could be in a report format that would be a "free," unsolicited guide that the recipients could
accept or reject.
The interest to the researcher would be the survey information provided by the companies. Of interest would be the
percentage of types of companies that have computers and those that don't. It would be valuable to know the types
of applications in use, the models of computers used, etc.
For example, information derived from the questionnaire could possibly answer some of these questions:
- Does your company use a computer? _____________
- How many computers are in use? ________________
- What model computers are in use? (please be as specific as possible):
__________________________________
- CPU type: _____________________________________
- Number of monitor displays is in use:
- Number of Hard Disk Drives: ___________________
- Please list the applications you run on your computers:
- general ledger ______________
- accounts payable ____________
- accounts receivable _________
- inventory ___________________
- fixed assets ________________
- invoicing ___________________
- Spreadsheet _________________
- Word Processing _____________
- Others: _____________________
- Please list the applications you do manually:
- general ledger ______________
- accounts payable ____________
- accounts receivable _________
- inventory ___________________
- fixed assets ________________
- invoicing ___________________
- Spreadsheet _________________
- Word Processing _____________
- Others: _____________________
- In what State is your company located? _________________
- Comments: ______________________________________
Questions such as these could form an interesting group of statistics that could be manipulated in various ways to
draw conclusions based on many factors such as geographic, computer type, computer applications, and manual
applications, to name a few.
A subsequent study could arrange to send another survey to the original group of companies requesting information
on whether or not the company attempted to convert a manual system and the results of that attempt.
Summary
It is hoped that this study will add to the body of knowledge in such a manner that companies, like The Ross Company,
will be empowered to improve their operations, where feasible, through their own initiative, by moving away from
manual systems to more efficient computer solutions.
The success of this study relied upon the involvement of this author. However, an attempt was made to guide the user
toward implementing the computer system in a straight-forward, simplistic manner that could be followed by most
persons with a minimal knowledge of computers.
One fact that stands in the way of many companies converting to a computer is that the owner or manager in charge
often may lack the necessary experience to know where to begin. This situation will probably change as future
generations who are now learning about computers in school and at home enter the work force. At the present,
studies like this may be the catalysts to give the older generation managers the knowledge and confidence they
need to get started.
This study was undertaken to determine if a manual system could be automated by the staff of a small company.
It was determined that this is possible. To accomplish this objective, the user, the shipping clerk, was
encouraged to become involved with the project from the beginning, as soon as the prospect of converting to an
automated system was suggested. Although he was not computer literate, he managed to install and test various
packages using the instructions supplied with each package. In addition, a single application was selected for
conversion instead of an integrated group of packages.
When a package was obtained that he had difficulty loading onto the computer, it was discarded for the reason
that if it required a high degree of technical computer expertise to install, then a lot of expertise would
probably be required to run it. If the instructions were not clear, the package was discarded.
The shipping clerk's involvement reached a level where he was knowledgeable and interested enough in the success
of the project to suggest a way that the operating procedure could be changed to make it work like the manual
system.
Additional factors that will affect the outcome of a computer-related project are the differences between various
small companies. These differences will determine, to some extent, the success or failure of a conversion effort.
Some companies might achieve success and some might not.
Differences could include such things as management style, the attitude of the employees, the type of business the
company is involved in, the financial strength of the company, the interest of the management to improve information
systems, and management's attitude toward computers, to name a few. The study of these factors might be the subject
of future studies.
REFERENCES
- Balzer, R. (1989). A fifteen-year perspective on automatic programming. In T. J. Biggerstaff & A. J. Perlis
(Eds.), Software reusability, Volume II, Applications and experience, (pp. 289-311). New York: ACM Press.
- Beizer, B. (1984). Software system testing and quality assurance. New York: Van Nostrand Reinhold.
- Bentley, T. J. (1984). The computer: past, present, and future. London: Macmillan Press.
- Breslin, J. (1986). Selecting and installing software packages. Westport: Greenwood Press.
- Chorafas, D. N. (1982). Office automation: The productivity challenge. Englewood Cliffs: Prentice-Hall.
- Claus, V. & Schwill, A. (1992). Encyclopaedia of information technology. New York: Ellis Horwood.
- Coffee, P. (1994, October). Real-world trends now favor X86 development. PC Week, p. 36.
- Connell, J. L., & Shafer, L. (1987). The professional user's guide to acquiring software. New York: Van
Nostrand Reinhold.
- Dickinson, J. (1992, November). Radical shifts afoot in software distribution. Computer Shopper, p. 62.
- Dodge, J. (1994, October). PowerPC, Mac OS, PreP: Where do IBM, Apple go from here? PC Week, p. 1.
- Feynman, R. P. (1985). Surely you're joking, Mr. Feynman!. New York: Norton.
- Forkner, I. & McLeod, R. (1973). Computerized business systems. New York: Wiley.
- Gianturco, M. D. (1994, August). Testing techniques for quality software. Software Development. p. 45.
- Glass, R. (1990). Software conflict: essays on the art and science of software engineering.
Englewood Cliffs: Prentice-Hall.
- Goodell, M. (1989). What business programs do: Recurring functions in a sample of commercial
applications. In T. J. Biggerstaff & A. J. Perlis (Eds.), Software reusability, Volume II, Applications and
experience, (pp. 197-211). New York: ACM Press.
- Hollander, N. (1992, October). Selecting software. Software Magazine, p. 6. IBM's Chief: Stranger in a
Strange Land. (1995, February 2). Rocky Mountain News. P. 17.
- Management evaluation of software packages. (1985). Port Jefferson: Chantico Publishing Company.
- Meyer, B. (1989). Reusability: The case for object-oriented design. In T. J. Biggerstaff & A. J.
Perlis (Eds.), Software reusability, Volume II, Applications and experience, (pp. 1-33). New York: ACM Press.
- Mick, C. K. (1984). Working smart. New York: Macmillan.
- Nixon, J. (1990). Software for farmers in the United Kingdom. In W. Ehrenberger (Ed.), Approving software
products, (p. 343). Amsterdam: Elsevier Science Publishers.
- Sachs, J. (1984). Your IBM pc made easy. Berkeley: McGraw-Hill.
- Seymour, J. (1992, March). Don't underestimate the pc kitchen cabinet. PC Week, p. 81.
- Seymour, J. (1994, November). Can CardBus save the bacon for PCMCIA? PC Week, p. 48.
- Shamlin, C. (1989). The other side of software (2nd ed.). New York: AMACOM.
- Sharland, R. (1991). Package evaluation. Aldershot: Avebury Technical.
- Smith, J. & Tweney, D. (1992, February). Accounting software 101. PC-Computing, p. 252.
- Spears, G. (1995, June). Big ideas for a little money. Kiplinger's personal finance magazine, P. 46.
- Stagner, W. (1988). Cloning around: A guide to pc compatibles. Chesterland: Weber Systems.
- Sullivan, N. (1991). Computer power for your small business. New York: AMACOM.
- "Uncertainty Principle." Encyclopaedia Britannica. 1968 ed.