Tuesday, February 19, 2013

Junk Van Case



Problem/Issue Statement
I.        Mr. Kingo established a waste collection business, 1-888-JUNK-VAN, in 2008.  He took an uncommon approach when establishing his business; it was not the common brick and mortar business.  Instead, he ventured and created a virtual business model.  As the business was growing, he started to face increasing challenges. 

1-888-JUNK-VAN revolved around virtual communication.  As the business did not have a physical office, all communication and information transmission was electronic.  The company’s success highly depended on the ability of the company to keep up with the increasing jobs.  Accuracy was very important in order to be able to satisfy all customer jobs.

As the business started to grow, so did the complexity of the business model.  Given this complexity, Mr. Kingo started to notice inefficiencies and errors which caused losses to the business.  The problem that Mr. Kingo faces is the need to maintain his virtual business model.  Therefore, he is in need of a better operational system for his business which will help the business meet customer expectations and provide its customers with quality service. 

II.        The problem is the need for a better operational system which will allow Mr. Kingo to strengthen its business operations.  By doing so, 1-888-JUNK-VAN will be able to better serve its customers. 

The symptoms which have led to the problem are that 1-888-JUNK-VAN was losing customers given lack of customer satisfaction.  A few examples are errors in customer contact information, forgotten emails, manual calculations, and billing mistakes. 

III.        The problem involves the entire business model for 1-888-JUNK-VAN.  The current business model heavily relied on electronic transmission of data whereas Mr. Kingo believes that it is time to establish a database which will facilitate business expansion. 
       

Situation Assessment
I.        Mr. Kingo is searching for a tool which will allow 1-888-JUNK-VAN to maintain its virtual business model while allowing the business to grow. 

II.        In order to solve Mr. Kingo’s problem, the best alternative would provide ease of use, accessibility, reliability, and flexibility.  Mr. Kingo is considering franchising the business which would increase the number of users.  Therefore, the best alternative would be one that is easy to implement and adapt to. 

List of Plausible Alternative Courses of Action

I.        Mr. Kingo is considering the following alternatives in order to solve the issue at hand and enable business growth:
o    Microsoft Access Database
o    Custom Application
o    Google Docs
o    Platform as a Service (PaaS)
o    Enterprise Resource Planning (ERP) System

II.        Each alternative addresses the problem differently; the following provides a brief analysis of each one:
o    Microsoft Access Database: Implementing an MS Access Database to manage the business would only require a short period of time.  MS Access affords Mr. Kingo flexibility; they can either install the software on multiple computers or on a centralized server which would allow access to the entire team via a virtual private network (VPN).  MS Access does not require a lot of investment; each license only cost $179 per computer. 
Mr. Kingo would potentially be able to find time to create the database within a couple of weeks.  Access would be beneficial as it is user friendly and would not require much to implement.  With MS Access, Mr. Kingo would be able to create a record for each customer, job, and can even create a job catalog. MS Access is both affordable and easy to implement.

o    Custom Application: Another option would be to hire someone to create a custom application for 1-888-JUNK-VAN.  A custom application would provide a web based system which could be accessed remotely.  As with any custom application, the greatest advantage was that the application was specifically designed for your business with your specifications and requirements in mind.    
A custom application would only require an initial investment of approximately $2,000 and could be implemented within 4 weeks.  Other costs that are associated with the implementation of a custom application were maintenance costs which averaged $60 per hour as well as data migration costs, which could not be estimated at the time.  A custom application would solve Mr. Kingo’s problem because he would be involved in the design.  He could also pull in his team which would know the requirements best, together they would be able to determine what would work for the business.  

o    Google Docs: Google Docs offered multiple applications that could tackle the problem at hand.  Similar to MS Works, one was able to create presentations, spreadsheets, text documents, and forms.  Google Docs was free of charge and could be accessed remotely.  An advantage of Google Docs was that users could access documents simultaneously.  User privileges could be modified based on the employee’s role in the business. For example, drivers would probably only need view-only access while data clerks would require update capability.  Google Docs also integrated email and facilitated emailing documents/ forms links to customers.  Implementation of Google Docs would not require much time and could be done within a couple of weeks. 
Some of the disadvantages associated with the implementation of Google Docs were the loss of functionality such as cross-reference available with databases.  Additionally, customer support was not accessible.  Most of the support would be found via online forums and blogs.  Overall, Google Docs was a possibility that afforded Mr. Kingo easy and free access to a range of applications.  Google Docs is user friendly, accessible, and would have a quick turnaround.  The spreadsheets and forms applications would allow Mr. Kingo to collect data accurately for all customer accounts and jobs. 

o    Platform as a Service (PaaS): PaaS was another alternative, similar to Google Docs.  PaaS was cloud computing based and provided resources on demand through the Internet.  While Paas utilized common applications, it also provided the opportunity to build custom applications via a third party.  While PaaS was a little more technical, Mr. Kingo felt that he could perform some of the functionalities himself after watching a demo.  Again, PaaS could be used to build forms and tables which were essential at 1-888-JUNK-VAN.      
PaaS required a bit more of investment.  Service packages costs varied, approximately $300 to $600 per month, depending on the amount of storage and user licenses that would be required.  PaaS could be implemented in as little as three days, including data migration.  An advantage of PaaS was that it could be customized at an additional cost of $180 per hour required for the customization.  While customization may not be required, it was helpful to have this option down the road.  PaaS offered flexibility, long term contracts were not required and service could be cancelled with as little as a month’s notice. 

o    Enterprise Resource Planning (ERP) Solutions: An ERP system is built around a central database and can be accessed remotely.  An ERP is an all-inclusive system as it integrates all business processes, including sales, purchasing, human resources and finance. An ERP would be beneficial for 1-888-JUNK-VAN as it would allow the business to grow by integrating the critical business processes.  However, the ERP is the most costly tool.  It would require about $2,500 per user per year.    While there are several out of the box systems available, the majority of the systems included functionalities that did not interest Mr. Kingo at the moment.  He was simply interested in the improvement of the data errors and increasing customer satisfaction by increasing data accuracy.


Recommendation

Given the focus on time and adaptability for Mr. Kingo, I would recommend he implement a custom application at 1-888-JUNK-VAN.  As previously mentioned, Mr. Kingo and his team would be involved in the design of the application.  Their involvement in the design would enable the team to make decisions and design the best tool for the business. They know the business needs better than anyone else and their input would be valuable in the success of the application.  A custom application would also afford them the opportunity to make improvements down the road.  For example, if after a year or so, they notice that they need an additional application, they would be able to work with the developer to make the changes to adjust the application for them.

No comments:

Post a Comment