Fellow executives,
The
growth and viability of our small business has become plagued by errors related
to data processing coupled with operational inefficiencies. These symptoms are byproducts of the severely
constrained data infrastructure our operations utilize. A key
weakness of the current system is that it requires all customer and even
payroll related data to be received, interpreted, updated and transferred in an
entirely manual fashion. This convention
readily invites informational errors affecting our job orders, scheduling, staffing,
invoicing and billing and even employee compensation. This problem is further compounded by the limitation
that information cannot be stored in or accessed from a central database. From origin to final destination, data slowly
flows sequentially along a cumbersome chain of employees. In most cases the information is manually handled
by call multiple center operators, a data clerk and drivers more than once by each in the process. This virtual game of telephone is causing
such an array of errors it is driving the quality of our customer service and
our reputation straight into the ground.
This is completely unacceptable for the standards to which we claim to
hold our company! We market and model our
business on the premise of providing quality, timely and professional waste
removal services. Our inadequate
information systems are spawning operational inefficiencies. We are not processing data in a way that
would allow us to optimize our delivery loads to recycling centers. We are paying centers to accept small
drop-offs of recyclable waste that if disposed of in bulk we would be paid for. The
excessive time and manual effort drivers must spend sorting and transmitting receipts
and invoices. To complete a cash order our drivers must double-back
to the locations they already finished at to collect payments. In this competitive commodity business we
cannot afford to waste money on gas and driver hours for the purposes of
billing transactions. We must improve
our information systems. Otherwise, we not only won’t grow—we won’t last.
I’ve
scrutinized six available options for improving our informational
infrastructure for the purposes recommending a selected course of action. The options consisted of Microsoft Access Database
(either installed locally or on a centralized server), Custom Application,
Google Docs, Platform as a Service, and ERP.
I rigorously evaluated each option according to the following eight key
criteria; power and reliability of the central database, automation, remote
access, ease of use, flexibility, customer support, time to implement, and
price. To organize this array of feedback
and help streamline my results I constructed an option evaluation matrix. The matrix presents the scores each option was
assigned for each criterion (1 being the lowest to 5 the highest). I included this visual aid for you. As you can see, none of the options attained
high marks across all categories.
Before I discuss these options and provide my recommendation I want you
to be keenly aware that each alternative carries a degree of risk, uncertainty and
cost that may offset and even potentially outweigh their expected benefits.
The first two options I evaluated were Microsoft Access
Database installed locally on several computers versus installed on a
centralized server to that could be accessed remotely via the internet and secure
virtual private network. Both of these
options would provide a reliable and powerful centralized database. The local installation could be installed in
as little as few as two weeks and is relatively easy to use and inexpensive —at
$179 per PC it would likely keep the total investment under $1000. The drawbacks are that it’s neither remotely
accessible nor automated, meaning the database would still need to be manually
updated and transmitted every day. This is
a deal-breaker. MS Access installed on a
central server would provide automation and remote access. This option would likely require the added
expense of hired technical support and could take double the time to implement. A more complex system, this would require
extensive employee training. It would also
carry additional costs for hosting a shared server and user licenses.
The
custom application option involves having a third party build a completely
customized system for our business. Upsides
include remote accessibility and a reasonable cost of $2,000 to implement. This would hopefully
meet most of our power, reliability, automation, ease of use and flexibility
requirements. I emphatically stress the word
“hopefully” because this option requires upfront payment before we have the
ability to see the finished product.
While we could do our best to communicate our requirements there is no guarantee
those needs would be met. I risk adjusted
most of the criteria rankings for this option.
Another drawback is it would take approximately 4 weeks to
implement. Also, the $2000 price tag
does not include maintenance costs at $60 per hour and there is no way to approximate
the amount of maintenance. Customer
support is available—also at an hourly rate.
The high degree of risk associated with this option regarding both quality
and price is very alarming.
Google Docs is the most cost
efficient option. It is free of charge
for the first 10 user accounts and carries only a $50 per year charge for additional
accounts. Google Docs would only take 2
weeks to implement and is very user friendly.
It supports basic automation and email distributions with links to
forms. Google Docs is severely limited
in the power and reliability department.
It cannot utilize cross referencing between tables which is fundamental to
relational databases. All data is inefficiently
displayed on single large form. Google
Docs provides no tangible hardware or software because everything is processed and
stored by means of Cloud Computing. This
invokes risks related to confidentiality concerns and could leave us extremely vulnerable
in the event Google discontinued its service.
Enterprise Resource Planning
(ERP) systems such as SAP Business One and Sage ERP are best in class for the
power and reliability, automation and remote access criteria. They are also highly complex and inflexible
platforms requiring considerable implementation time and extensive employee development. They are also astronomically priced. The Business One “starting pack” consisting
of 4 licenses prices at $12,000. And
there are likely steep maintenance and customer service charges that
follow. Not to mention additional licenses
for all users. What bothers me about
this option is not simply the substantial price tag, but that we might be
investing in some services not applicable to our business like production and
finance platforms.
The last option is Platform as a
Service (PaaS), which utilizes cloud computing through the internet. It allows users to access common applications
and build their own custom applications using a shared computing platform
provided and hosted by a third party.
PaaS is powerful, flexible and user friendly. It allows users to build unique applications
and link tables with relative ease. I
slightly downgraded the reliability rating for the fact that it requires cloud
computing and carries the risks previously mentioned. PaaS is best in class for time to implement,
requiring only 3 days inclusive of data migration. This quality product is not cheap as it can
cost between $300 to $600 per month depending on storage and licensing
requirements. This investment is well balanced
by low risk. There’s no requirement for
long-term contracts and the service can be canceled with 30 days’ notice. The system features and capabilities are incredible
flexible in that they can easily be scaled up or back depending on our requirements. Customization costs $180 per hour, but may be
worthwhile.
While there does not exists a
clearly obvious choice, PaaS garnered the highest total score on the option
evaluation matrix. Receiving a 30 (out
of a possible 40) PaaS was a full 5 points ahead of any of the next highest ranked
options. PaaS scored consistently high
on all key criteria with the exception of price. Again,
this substantial investment is largely mitigated by the lower associated risk
and commitment. Considering the
available options I am confident PaaS is the best course of action. It provides the most balanced solution in
terms of meeting our spectrum needs. It
is also devoid of deal-breaker characteristics.
As we make this decision I urge you all to examine the evaluation matrix.
The numbers do not lie.
Bobby

No comments:
Post a Comment