Sunday, February 17, 2013

1-888-Junk-Van Case Proposal


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