Sunday, June 29, 2014

1-888-JUNK-VAN Reflection


RKR group’s presentation clarified our alternatives for which IT system will work for our company. Microsoft access, Google docs, custom application, ERP and PaaS are all great systems that offer viable options. The question is which one is the best fit for our company, 1-888-Junk-Van.

1-888-Junk-Van has been lacking efficiency for some time and with our growing business and goal to franchise the company, it’s crucial we implement a new system quickly. RKR group clearly identified which system is right for our business. Their diligent analysis of each alternative offered great insight to the pros and cons. In our business it’s the small things that matter. Customer satisfaction and word of mouth is what drives our growth. As clearly outlined in the consultants presentation, inefficiency in our current system is jeopardizing our reputation and causing lost sales of $42,000. In such a competitive market with low entry barriers, every aspect of our business is crucial in sustaining growth. There are great opportunities lost with inefficiency. Implementing the PaaS system will help us stay competitive in this market and reduce cost in the long term. The system provides exactly what we need for our expected growth and goal to franchise. Along with a greater efficiency process, PaaS offers scalability, which is exactly what we need. The incremental cost as our business grows makes sense for our type of business. Eliminating a data clerk’s salary by implementing this process will help us allocate money in different areas such as marketing. It will also help us offset the cost of initial set up. The 3-day launch time means productivity loss is minimal. PaaS does not require a contract with our company and therefore, allows our company to change systems if ever there’s a need that arises and PaaS can not offer.

The consultant’s weight analysis or point breakdown made it clear the right choice for our company is PaaS. A combined assessment of the cost, applications offered, enhanced efficiency and the small time frame for launching makes it an attractable option. By implementing the Paas system, an increase in net revenue of 35.57%. This will give us a clear avenue to our goal of franchising the business. 

Wednesday, June 25, 2014

IPAD for Pharma Sales Rep


My analysis on the benefits of replacing our laptops to iPads for our pharmaceutical sales rep concluded the following:

A typical day for our pharma sales representative requires traveling and visiting up to 10 physicians a day. Their most valued resource is not just the laptop but also their time. Why not ease their mobility by replacing their laptop with an iPad, it helps ease them from hassles, storage and the bulky inconvenience. The usability of the iPad has added value, it’s easier, faster and convenient for their everyday task. It enhances their ability to demonstrate organizational ideas.

There are many apps available for the iPad that are very effective in delivering sales messages. Our sales rep could have a wealth of information at the touch of a finger. They can easily open an app and provide the physician with stats, research or side effects of a drug. If a physician has a question, a sales rep can have an answer in seconds. Apps are easily accessed on an iPad, which again saves the rep time.

There is quality physician interaction and engagement. The iPad has the ability to easily demonstrate video, animations and anatomical or product images to physicians at any place or time. Specialty detailing, in particular, would be greatly enhanced by using the iPad with its sharp visual display and advanced processor capabilities.

An iPad can facilitate the CRM system, pharma sales reps can record the information that forms the direction of business and establish plans for the next call, almost immediately, either directly after a sales call, in the hallway or in the waiting room. Information on products or physician orders is captured through easy drop-down menus that limit the amount of text entry required.

The few minutes a pharma sales rep has with a physician is important. The information exchanged is extremely valuable for both parties.





My recommendation is to stay ahead of the curve and convert to iPads for our sales rep team. The long-term advantage is worth the expense.


http://www.cognizant.com/InsightsWhitepapers/How-to-Properly-Deploy-the-iPad-Within-the-Pharma-Sales-Force.pdf 

Monday, June 23, 2014

Prep 1-888-JUNK-VAN




Problem/Issue Statement
  • What is the problem?
Marcus Kingo, the sole proprietor of 1-888-JUNK-VAN, has a goal of expanding the business by franchising while preserving its virtual business model. As the business is vastly growing, his current process of daily operations is lacking efficiency. This is causing a loss of customers and damaging the business’s reputation. Kingo is in search of an IT system that can be quickly implemented, inexpensive and easily accessible by his employees. To create long-term sustainability, Kingo must choose an IT system that is suitable for the current business objectives and viable for foreseeable growth.

  • What is the distinction between the problems and the symptoms?
The problem is the operational inefficiency caused by the current procedures in place. The symptoms begin with the complaints from frustrated customers due to billing errors, clerical errors, driver miscommunication, and loss of business. Clerical error causes the most critical impact, there are major delays in booking reservations because of only one live version of the database. This causes the company to lose customers and jeopardize their reputation.

  • What is the scope of the problem?
The scope of the problem lies in the communication process of its current daily business process. As the company’s business grows, the harder it is to ensure that information is shared and that different functions work together effectively.

Situation Assessment
  • What is the context of the problem?
Within the environmental and facilities service industry, the waste collection segment was a lucrative business and low entry barriers created a competitive market. Taking into account, a study published by Icon Group International, between 2009-2014, Canada was expected to represent the demand of 1.9% of the $129 billion latent demand for was collection. Therefore, the IT infrastructure implemented is a critical component in ensuring the capability of growth and efficiency. Competition within this market was mainly based on price. Therefore to keep internal cost down 1-888-JUNK-VAN has to implement an IT system that will facilitate the business operations and help employees do their jobs effectively all at a low cost.

  • What are the decision criteria?
Central database with remote access: all employees should have access to a central database to      reduce confusion and errors
User-friendly system: Staff did not have high IT skills and Marcus Kingo did not have an IT background.
Cost: Business was too small to justify hiring an IT worker, the system had to be easy to implement, operate and mainly affordable.
Vendor support: This was important and necessary for as long as the company used the system.
Flexibility and vitality: The ability to handle the evolutionary changes in the market was essential.
Quick implementation: In a growing business time was of essence.

List of Plausible Alternative Courses of Action
  • What are the alterative courses of action?
1) Microsoft Office Database:
Pros:
Implemented in a short time
Required a small budget
Option A: installing on a centralized server to be accessed remotely through a secure VPN
(OR) Option B: of local installations, which Kingo himself could easily install
Cons:
Option A: Kingo could not implement himself and might require IT help; cost of hosting the shared server
Option B: This option does not allow for remote access; daily manual updates needed

2) Custom Application:
Pros:
Build time approximately 4 weeks
Upfront cost is $2,000
Cons:
Upfront cost did not include any changes or adjustments that might be required
Maintenance cost was unpredictable
Quotes did not include data migration cost
Custom-made software could not be seen beforehand
Uncertainty of needs being met by product could increase cost
Support for custom applications were billed by the hour

3) Google Docs:
Pros:
Allowed remote access
Quickly implemented and easy to use
Online applications could be used to create essential documents
Forms could be quickly created and shared with employees
Users could work simultaneously on the same file
Email distribution was supported
Free for up to 10 user accounts with a small fee of $5 per user a month or a $50/user a year
Cons:
Spreadsheets could not be cross-referenced; Spreadsheet would be a single file and could cause confusion
Lack of formal customer support
Confidentiality issues
Uncertainty of Google’s action: what if they decided to cancel or suspend the service

4) Platform as a Service:
Pros:
Users could utilize common applications and build their own unique applications
Abiltiy to share computing platform that was provided and hosted by a third party
Implementation and data migration would only take about 3 days
Customization required more time and money; hourly charge
Long term contracts were not required
Kingo could scale the service up or down at any point or even cancel the service with a month’s notice

Cons:
Service package ranged from $300-$600 monthly depending on storage space and user licenses and applications needed
Kingo would need to know how much of a platform he needed or how much he would be willing to pay

Enterprise Resource Planning (ERP) System
Pros:
Remotely accessible
Integrates business processes (purchasing, sales, customer service, etc.)
System targets small and medium sized enterprises
Cons:
System package options were costly
Package mainly focused on modules Kingo had no need for, such as finance and production
20-25 users cost about $2,500 per user per year (license prices higher for companies with fewer users)

  • How does each of these address the key problem?
-Microsoft Office Database would provide the option of installing a shared server so that remote access is available.
-Custom Application would allow Kingo to be specific about the features needed and the system could provide a central database, remote access and mainly user friendly.
-Google Docs had a low cost for small businesses, migration would be done in a couple of weeks and forms could be created quickly and shared simultaneously
-Platform as a Service allowed users to utilize common applications, remote access accessible, service could be scaled up or down at any point, and users could share files
-Enterprise Resource Planning System is remotely accessible, integrated business processes

Evaluation of Alternatives

As the company’s business grows, different issues require different solutions. What worked a year ago might not work for the company’s current growth. By expanding the business Kingo is relying on large volumes of database, billing information, contacts information for customers and employee payroll logs. There’s a lot of information to keep track of, use effectively and utilizing the right system is essential. Kingo’s goal of franchising the business requires an IT system that can be easily transferred and facilitate the internal processes. The right system will create the infrastructure needed to meet Kingo’s goal.

Recommendation
  • What is a quality recommendation?
A quality recommendation would be to implement the PAAS system. The system, despite the cost meets every criteria Kingo is looking for. Long contracts were not required and the system could easily adapt to a growing business.

·       What is a logical recommendation?
A logical recommendation would be to implement a Microsoft Access Database. The reality is 1-888-JUNK-VAN consisted of 9 employees and the owner Marcus Kingo. Access to the central database would mainly be the 2 call center operators, 1 data clerk, 3 drivers and Kingo. The system is user friendly and as employees become familiar with the program, more intricate components can be added if needed. It may be necessary to purchase more sophisticated software as the business grows, and those businesses have an advantage if all of their data is stored in access. Many other programs can accommodate data exported from access, making it easier to migrate information when the time comes. The cost of hosting the shared server would be a fixed cost and therefore can be properly budgeted.
Presentation
  • If I were presenting, how would I sum up the case?
      I would sum up the case by highlighting all the benefits this system provides and it’s quick    migration.


  • What key visual aids would I present?
I would present with ppt and create a chart with all the pros and cons of each option.

  • How would I “sell” the recommendation?
I would sell the recommendation by analyzing an assumption of cost and demonstrating the    simplicity of using access.

  • What other delivery considerations should I keep in mind?     
Delivery considerations would also be diagrams on how this system works and how easy it would be to migrate within a short time.

P&G Reflection


Our main concern here at P&G is to decide whether we should implement a new process of data capture which would create greater efficiency and reduce the lag time of our clinical trials. Our current paper-based method is effective but causes loss of sales due to the delay of market entry. It’s imperative that we address this issue now because our market position is critical when competing with large pharmaceutical companies because as we all know, early entry to the market provides a significant and sustained market-share advantage.

The presentation by the American “A” Experts consultants was very compelling. They offered 3 alternatives and clearly outlined the pros and cons of each.
Do we enhance our paper-based method? Implement digital imaging? Or adapt Web enabled EDC? Each alternative method provided a reduction in time and the concern then is feasibility and cost.

To summarize their presentation;
The first alternative, enhancing the paper-based method would require incurring the cost of daily express mail shipments and hiring more staff. This doesn’t create a solution for increasing efficiency it only helps facilitate the process and reduce lag time.

Second alternative implementing digital imaging allows documents to be electronically sent and stored digitally increases efficiency but doesn’t reduce significant time in the process of capturing data.

The third alternative, web enabled EDC is the right choice for P&G. It creates efficiency and significantly reduces our market entry time. The weighted requirement analysis presented by the consultants reaffirms this option is the best fit for our need. The assumption of estimated savings outlined by the consultants are substantial and very close to our own projection. This system will not compromise our data but provide added security and back up. The system is feasible with training and technological assistance.

My recommendation would be to move forward in implementing the web enabled EDC. It will have a long-term effect in the financial aspect and clearly addresses our issues. The consultants did a great job in their analysis which clearly concluded this is the best option.