Friday, May 31, 2013

Bombardier’s ERP Implementation

Bombardier is a key player in the transportation industry. Not only is the company successful with their rail transportation but also their ventures into the aerospace industry. Bombardier even diversified into manufacturing civil and military aircraft and acquiring large organizations like Havilland Company from Boeing over its lifetime. Throughout the company’s existence, they have been committed to updating their legacy information system, the Bombardier Manufacturing System (BMS), which is based on a MACPAC platform. Although the system satisfied their business needs it was not evolving to changes and faced many challenges that needed improvement. The Vice-President of Operations and Project Sponsor had a vision of ingratiating the organization into one, “One Company.” The system, which was more of a business transformation than a technology implementation would share common data across sites and products using a single set of unified systems and processes. The transition became known as the BMIS Project which entailed an Enterprise Resource Planning (ERP) system. Bombardier’s first implementation failed and was discontinued mid-project in 2000 after $130 million was spent. The reasons that contributed to the first implementations failure were:
  1. Focusing the implementation on inappropriate business processes
  2. An outdated company vision
  3. A weak sponsorship model
  4. Insufficient involvement of internal employees
  5. Too many third-party consultants
2001, one year after the first failed attempt of the ERP system implementation, a group of senior managers from Bombardier Aerospace’s Irish facilities established a new integrated manufacturing system. This project focused on a wider ERP strategy and the vision of “One Company,” an integrated organization. The system planned to support Bombardier’s Aerospace operation and focus on the processes that support manufacturing, procurement, finance and the engineering data required to support these processes. $363 million was the budgeted amount to implement the BMIS system across all facilities and it would support 9,500 users over seven sites. This implementation would require 400 people but if successful would result in $1.171 billion in savings for Bombardier and a one-time reduction of $219 million in material inventory. One primary objective for the BMIS implementation was that manual tasks would give their jobs a more analytical focus as it would reduce clerical tasks performed by the employees. This implementation would also reduce the amount of paper used which was an ultimate goal, being a paperless workplace.
The BMIS implementation was not seamless and contained challenges that could certainly aid the company in future implementations. For starters, an original thought during this implementation was the “to-be” processes designed by the project team that were presented to the relevant functional councils for approval. The intent for this was that the project would be organized according to processes but this was abandoned during the blueprint phase and was reverted to a functional organization. Learning from the past allows the company to not waste time on trial and error when for example, they already know the implementation would not be affective if organized according to processes. Other challenges that could be identified from the BMIS implementation and not repeated for any future implementations are:
  1. Lack of communication as some managers made no effort to ensure employees were informed of the implantation progress even though the Senior Project Manager emphasized to the Business Process Managers that communication was 80% of their job during this implementation
  2. Design workshops were held during the design phase to assist in the implantation of the ERP system but managers were unable to attend due to scheduling difficulties and pressure in the business environment (unrelated to the project)- this caused issued for the project team in confirming the appropriateness of their design decisions
  3. Reluctance to take ownership during the design phase- managers were not committed 100% of the time
  4. Absence of strong business employees who constancy had to go back to the business in order to validate their decisions
  5. Hazy answers were received from the BMIS team when they were asked to provide documentation illustrating the high-level processes included in the system
  6. Overlapping of the realization and integration testing activities because the design phase ran over schedule
  7. Total acquisition costs not being considered when making purchasing decisions
  8. Training
    1. training material did not reflect an understanding of the business
    2. not user friendly
    3. descriptions and exercises were too detailed and difficult to follow
  9. Going Live
    1. ensured the August 4th, 2004 deadline was not pushed back sacrificed the deployment as they were not ready
    2. focusing on new roles and responsibilities rather than how to complete transactions
    3. power users stayed on site temporarily however challenges began to surface months after implementation, after power users left the site
    4. frustrated users when support staff could not solve their problems
    5. continued use of legacy system
    6. technical issues- Finance employees were making manual corrections to the general ledger if materials were issued incorrectly
    7. delays in Bill of Materials
    8. managers failed to use reporting functionality that was available in the system
Success factors and ideas of the ERP implementation that should be repeated for any future implementations are:
  1. Implementing one plant at a time
  2. A “vanilla” approach system design- minimal modifications or enhancement be made to processes in SAP
  3. Procurement function- moving toward a policy of global strategic sourcing, eliminate all clerical activities, automate as many processes as possible and improve supplier compliance
  4. Power users and super users made significant efforts to adapt the training material in order to bring it to satisfactory standard
    1. internal training supplements
    2. additional courses and training material provided
    3. information focused on roles
  5. After going live, at least one power user should always be available on site to act as a link between the business and technical support staff
  6. Not disrupting production schedules
The BMIS implementation contributed to a reduction in inventories of $1.2 billion across Bombardier Aerospace less than one year after the Go Live. This demonstrates that even with a large amount of challenges the implementation can still be successful including the facts that the deadline was met, the project was below budget and the Bombardier Aerospace delivered one more plane than scheduled during the implementation process of BMIS. Executing the same ideas, applying the best practices and critiquing the challenges the company faced with the Mirabel implementation of BMIS, Bombardier can be even more effective in their next implementation. 

Thursday, May 30, 2013

Ubuntu Whobuntu?

Ubuntu is a free computer operating system that can be downloaded and installed with one easy click. The following are just a few advantages that Ubuntu can provide a company:
  • It’s FREE!
  • Over 1,000 applications available for purchase and download
  • Free storage on its cloud platform
  • User friendly
  • Ability to scroll through all open windows
  • Mobile capabilities
  • Compatibility with Microsoft programs
  • Security
  • Social media all in one
As great as Ubuntu sounds, is it right for every company? My current company relies on Microsoft programs, especially Microsoft Excel. Even though the Ubuntu website and many other sources state the LibreOffice Suite (the Linux version of Microsoft Office) is compatible with Windows infrastructure, I would still be hesitant to make the switch. My main concern for this is that we interact with clients on a daily basis and exchange file that are almost always Microsoft Word or Microsoft Excel files. Will those files always be compatible? It would be complete shame to lose clients and revenue they bring in just because we have repeat issues with compatibility due to an operating system. Is it truly worth sacrificing clientele for a new operating system when our current Windows operating system works? Window has not failed us and we have had no issues with sharing documents and files with clients as we run on the same operating system and have no concern or worry about compatibility.

However, after a little research I found that Microsoft Office Suite 2010 can be installed on Linux systems like Ubuntu. The common trend I found while researching was that the installation and use of Microsoft Office on Ubuntu is “not perfect, but good and can get the job done.” There is also a large chance of damaging your system during the installation. Also, it takes a lot of background work through PlayOnLinux to actually download the software and then associate the file to Ubuntu. So is Ubuntu truly worth the switch? 

Now as great as all the features are on Ubuntu and as exciting and interesting as it would be to use a new operating system that largest downfall can truly jeopardize my company. Would Microsoft Office outweigh a social net app that allows my company to manage all our social networks in one location? Or would the use of Microsoft Office make the new feature of scrolling through open windows seem less efficient even thought my co-workers constantly work in multiple windows? To answer both of those questions, the answer is yes! We rely too much on Microsoft files to send to clients and sacrificing that would hurt our business and our bottom line. We cannot lose high volume accounts because clients have issues opening our files. While Ubuntu is a wonderful alternative to an operating system it truly is not the right answer for my company at this point in time.    

Thursday, May 23, 2013

iPads for Success

To:                        Bill and Tom
From:                    Ria
Subject:                iPad Case for Success
Date:                    May 23, 2013

Good Afternoon Bill and Tom,

I am writing to follow up with your recent inquisition of transitioning from laptops to iPads for your sales department. As iPads are certainly a tool of today’s digital world it is important to measure the advantages and disadvantages before making such a large investment for your company. After further researching and evaluating your information technology, sales and finance department, I have gathered the following:

Laptop Advantages
iPad Disadvantages
1
Exclusive programs
Programs are not compatible
2
Renew lease
New lease for iPads
3
Secure VPN and firewalls
Lack of security
4
Networking files, documents, etc.
All information on only 1 cloud
5
Easy daily access (keyboard, mouse)
Would only rely on iPad (no laptop)
6
Few hours for set up
6 to 9 months to create and build applications with compatible software
7
Much easier and effective to work on laptops
New trainings for iPads



Laptop Disadvantages
iPad Advantages
1
Large and bulky
Convenient for traveling (lightweight)
2
Battery needs additional charging, especially when out on the field
Better battery life
3
Challenges of finding power outlet to charge laptop
Better battery life
4
Need to find connectivity through Wi-Fi or hotspots
3G capability and Wi-Fi
5
Less efficient while presenting to doctors
Better speed and efficiency while presenting to doctors
6
Difficult note taking when standing in the hallway
Easy note taking during quick conversations
7
Limited storage/memory  space, must be connected to network
Cloud for organization, unlimited storage/memory, access anywhere
8
Less team members want laptop
Sales team wants iPads
9
Costly leasing fees
Less cost for leasing
10
Total cost of ownership is $9,000
Total cost of ownership is less than $9,000
11
Routine training on new equipment/software
Trainings will be integrated into regional meetings
12
Standard routine for doctors
Better perception to doctors, wow factor!
13
Nothing new and exciting or interesting
Increase of sales due to client interest
14
Lease is up in a year and half
Have time to finance, purchase and set up iPads within a year and half
15
Norm, following standard
Breaking the norm, adapting with technology
The iPads would certainly be the best option for detailers to use out in the field where they can have easy access, a lightweight device to present information to doctors, effortless internet capabilities, great battery life and many more benefits as demonstrated above. As seen from the tables, transitioning to iPads will provide your company with more than double the advantages than continuing the use of laptops. After further researching and analyzing the important information provided by your departments, I feel that it is in the best interest of your company to lease iPads for your sales detailers. This alteration in the sales department should begin once your leases on the current laptops expire, roughly in a year and a half. Leasing iPads for the detailers will have a significant effect not only on your sales department but your company as a whole. You will be making new strides in today’s technological world and improve services with your clients in more ways than one.  

Please let me know if you have any questions or concerns.
Thank you for your time.
Ria

Tuesday, May 21, 2013

Reflecting on Zara

The globally recognized clothing store, Zara is a retailer that functions on an outdated DOS system and management is beginning to question their information technology (IT) systems. After carefully analyzing the company and the functions of organization, four alternatives have been given to Zara to implement as one of their solutions. The following are the four alternatives:
  1. Discard making any changes to Zara’s current systems and let the company continue to run as it has been on the older DOS system.
  2. Continue using Zara’s current systems but purchasing many extra POS terminals from their vendor to ensure they have for future use in case their vendor stops the selling the older system.
  3. Upgrade Zara’s current POS terminals to build new capabilities into the software and a more customized system.
  4. Update Zara’s current POS terminals and software system to Windows, UNIX or Linux.
After the first evaluation of Zara’s IT procedures and processes the fourth alternative appeared as the best option for the company to adapt. This is because switching to Windows, UNIX or Linux will give the company updated and current software to utilize and will allow all platforms to communicate with each other. This alternative would also provide Zara with efficient service to allow stores to perform at a higher level by adding functionality and networking capabilities. However, after the consultation with Fast Solution Consultants this alternative may benefit Zara but alternative three, of updating the POS terminals to a new operating system would certainly have a larger effect on the company. Alternative three would have the same benefits as the fourth alternative but as the consultants mentioned this alternative fulfills all of Zara’s requirements for their IT system. A new operating system would have the follow advantages as well:
  1. Be independent from the POS vendor
  2. Stores would have accessibility to inventory look up
  3. Real time inventory updates
  4. Networking within the stores
  5. Easily transmitted data to HQ
  6. Easy installation
  7. Digital receipts
  8. Investigations of chargeback situations by credit card companies
  9. Online interaction
  10. Enhanced traceability of goods
  11. Inventory management
  12. Retail transaction interface         
Not only will alternative three bring about these great benefits, it will also generate a great deal of savings for Zara. Taking all the advantages into account and Fast Solution Consultants conclusion that “upgrading to a modern technology system will allow Zara to improve efficiency in the ordering, fulfillment and manufacturing process, thereby increasing  efficiencies in operations, product development, information and communication and also reduce cost of production, marketing and advertising” alternative three is the best recommendation for Zara.

Friday, May 17, 2013

Visio for Websites...

Microsoft Office includes four basic programs (1) Microsoft Office Word, (2) Microsoft Office PowerPoint, (3) Microsoft Office Excel and (4) Microsoft Office Outlook but what about Microsoft Visio? Microsoft Visio is a diagramming program that allows one to create professional diagrams to simplify complex information with shapes, collaboration tools and data-linked diagrams. Originally, my first thought of Microsoft Visio was “it creates a diagram, that’s simple; you can do that on Microsoft Word or Microsoft PowerPoint.” But after a little research and some experimenting, Microsoft Visio does more than that! The following is a simple swimlane created to show the Meeting Planner Process starting from when the client gives the meeting logistics to the meeting planner all the way till when the client makes their payment to the meeting planning company.  Notice the extra details in each aspect and the complicated process that is easily clarified with a simple flow chart.
Microsoft Visio could be a successful contribution to my company. We specialize in website registrations where we design websites for clients and track attendee registration through the website. Adding diagrams and flow charts to our websites can certainly have a great impact as it could emphasize important information in a simple image. A diagram is definitely easier to show complex or large amounts of material in a professional and simple manner. Having Microsoft Visio flow charts on client websites would keep the information neat, enhanced and impressive. Also, seeing as we use Microsoft Excel for many daily projects and reports we can import information from the spreadsheets into Microsoft Visio and create seamless diagrams. This would be a great added feature for our client websites and one I am sure our clients would always request. A perfect example would be expressing the travel process to our attendees. As many times as we explain the process in detail on the website attendees are always confused. Adding a simple diagram like the one below would avoid frustrated attendees, aggravated phone calls and irritated emails. And the best part about the illustration below is that it only took about fifteen minutes to create! That includes adding color and pictures.
Adding such a feature as Microsoft Visio diagrams to our services would benefit especially since the majority of our services are based on a la carte pricing. The price range could be anywhere from $150 to $800 depending on the level and simplicity of the diagram. This would be additional revenue added just for a diagram. That could be an extra $450 more to the client’s total charges and $450 more in revenue. Microsoft Visio would be a great addition to our company and would have positive effects and advantages. The thought of just adding diagrams to client websites is just one step to improve our services. We could create diagrams about our company and display them at tradeshows to better explain our company process and how we work to create great service for our clients. We can use them internally for training new hires about the how to’s of our business or express sales trends to the marketing team. The opportunities are endless with Microsoft Visio. 

Thursday, May 16, 2013

Zara Being Left Behind

Zara, a globally recognized clothing retailer that actualized $502 million in net income and $4,554 million in revenues for its 2002 fiscal-year, is finding information technology (IT) challenges within their company. Why is such a successful company affected by IT issues? Xan Salgado Badas, head of IT for Inditex is now questioning Zara’s current processes and equipment. Zara, Inditex’s largest chain of stores still runs on a Disk Operating System (DOS) which is not even supported by Microsoft any more. DOS is a widely installed operating system in personal computers, it was originally known as Microsoft’s MS-DOS (Microsoft Disk Operating System) and was replaced in 1985 with Windows OS. Zara has been working with their POS terminals to continue the use of the DOS system. The DOS system provides Zara with the basic IT applications of inventory control, ordering, purchasing, returning, etc. The system though has its disadvantages as it runs on a modem and all the software and programs do not communicate with each other. Also, store employees cannot view their inventory or other store inventories; they need to call stores when looking for a specific item. The store managers need to walk around the store and determine what to order as replenishment quantities when it comes time to purchasing. These are just a few setbacks that Zara is encountering that has made Salgado rethink their IT components. Salgado even says store managers are asking for their POS application to include more and he is reconsidering their current contracts with their vendor. Even though Zara’s vendor reveals Zara as their biggest customer, they made it clear that Zara is its only customer using the outdated DOS system.  The vendor reassures Zara that they will not be making drastic changes but that has not been confirmed in any written documentation.

Salgado has found four alternatives to solving his IT problem within the company.
  • Discard making any changes to Zara’s current systems and let the company continue to run as it has been on the older DOS system.
  • Continue using Zara’s current systems but purchasing many extra POS terminals from their vendor to ensure they have for future use in case their vendor stops the selling the older system.
  • Upgrade Zara’s current POS terminals to build new capabilities into the software and a more customized system.
  • Update Zara’s current POS terminals and software system to Windows, UNIX or Linux.

The first alternative to Zara’s IT is a good for the company as they do not have to worry about changes or adapting to new systems because their current DOS system is certainly stable. Another benefit for their current system is that the software is easy to install and opening a new store involves no IT assistance as store manages simply insert a disk and allow the installation to begin. However, this alternative has a very large disadvantage that will affect Zara in the future when their vendor stops producing the POS terminals with the older DOS system. Even though the vendor promises there will be no changes, the day will come when Zara needs to upgrade to a new version of software. In addition, the current DOS software is not even supported by Microsoft any longer as it has become outdated. Alternative two follows the same advantages and disadvantages as the first but has additional factors to consider. With alternative two the company can continue to keep their current processes and purchase more POS terminals before their vendor stops selling the older DOS system. This however, will cause a financial burden on Zara. Instead of the company allocating such expenses to an older system that will eventually need to be upgraded, why not use the money to invest in a system that will allow Zara to progress and move forward in future endeavors. Holding off on such an upgrade is in inevitable as it will eventually need to occur and Zara will need to find a modernized and accepted software. Alternative three is fantastic and it will give Zara a customized feature. This is exactly what store managers are looking for, more options. Zara can duplicate the system process that already works for their company and in addition add features that will not only benefit them but expand their services. This option will also allow for more quick and efficient services for the stores when inventory records are updated and purchasing becomes improved. This alternative though will entail experienced IT professionals. As Salgado’s technical lead for the POS system expresses, he knows the current system very well and IT is not involved in many store openings as the software is that easy to install. This alternative will require IT assistants to open stores and to troubleshoot all the custom features. This alternative will also come as a pricy option with all those customized features. The fourth alternative is surely the best option for Zara. Zara switching to Windows, UNIX or Linux will give the company an updated and current software to use, unlike the current DOS system that is not even supported by Microsoft. The modernized version will give way to efficient service and allow stores to perform at a higher level by adding functionality, networking capability and more. This alternative will allow all platforms to communicate with each other and be in sync. Switching to Windows, UNIX or Linux will definitely come at a price and will involve IT assistance but will certainly benefit Zara in the future. Zara will stay current with technology, give store managers the right tools to provide much more quality service to their consumers, improve the overall operation and positively increase revenue. 

Friday, May 10, 2013

Reflecting on Junk Van


Marcus Kingo has found his company lacking the key services it once provided to their customers and the overall management and organization of his company, Junk Van. He needs to find a solution that is cost effectibe, can be established in a short time, simple to manage, remotely accessible to all employees especially drivers, user friendly and most importantly organized to keep all the components of his operation under control. The five alternatives Kingo has are upgrading his current program, Microsoft Access, a custom application, Google Docs, Platform as a Service (PaaS) or Enterprise Resource Planning (ERP). The Consultants did an incredible presentation on Junk Van and were very convincing about the Stage 50 program. Their presentation had all the key components and demonstrated how Junk Van can prosper and improve. 4e Consultants provided Junk Van with a good list of five software options Junk Van can use to flourish their company. After narrowing the choices down to ERP they provided the top ERP alternative that would work best for Junk Van, Stage 50.

The original analysis of Junk Van revealed the advantages and disadvantages of all five alternatives. It concluded that the fourth alternative, PaaS was the best option for Kingo as it suits all of his requirements. However, 4e Consultants provided respectable reasons as to why PaaS is not the better option for Junk Van. The drawbacks of this alternative are expensive cost for a small business like Junk Van, the software must be purchased and built with additional costs, customization comes at a fee as well and there is uncertainty as to how much platform is actually needed for the company. These shortcomings were certainly overlooked in the first analysis and need to be revaluated. The cost factor is an enormous disadvantage, especially for Kingo, as he cannot afford to pay $600 a month, not including extra charges for purchasing software, building programs and customization.

After viewing the presentation it is clear that ERP is the best alternative for Kingo. ERP is affordable, facilitates future growth, includes reliable communication, offers simultaneous access, and performs automatic updates in real time. 4e Consultants took their presentation a step further and offered a specific ERP solution that would be appropriate for Kingo and his company. As good as SAP Business One and Microsoft Dynamics are their software comes at a very high cost, about $20K-$50K. SAP Business One also requires about 18-20 months for installation and Microsoft Dynamics provides average customer service to their customers. Sage 50 though, gives Kingo the answer to all his problems. Sage 50 is designed for small businesses that allow the company to expand and the software grows with the company giving future opportunities to upgrades as Junk Van succeeds. The software creates customer listing, includes payroll functionality and provides good customer service and training capabilities. Stage 50 also eliminates frustrations like daily emails to drivers about reservations, manual inputting for drivers, paper invoices, revisiting customer sites, outside bookkeeping, manual payroll and data clerks. After further evaluation and viewing the presentation by 4e Consultants it is time to consider the ERP system for Junk Van and stress to Kingo how well Sage 50 will do for his company. 

Wednesday, May 8, 2013

Reflecting on P&G

The consultants did a great job at presenting their case and showing that the third alternative, Web-Enabled EDC system would certainly be the best option for P&G. They explained that the problem for P&G is to find a solution that would add the most value to the company. The consultants illustrated the risks and disadvantages of the first two problems very well. It was very convincing to see how the first alternative, updating the paper-based process and the second alternative, digital imaging would sacrifice time, cost and quality for P&G.

The consultants brought up a few very good points to keep in mind about the Web Enabled EDC system. P&G would be the first in its industry to implement this type of design, giving them a competitive advantage against their competitors. This alternatives would also speed up the process and reduce the length of time it takes for their company to complete clinical trials for prescription drugs. Another reward is that P&G would save over $590 million with this new technology based process. The consultants demonstrated many other great advantages when explaining how the Web Enabled EDC system would enhance the company’s time management that were overlooked in the first analysis of P&G. Real-time study progress for relevant items like patient compliance data, reduced investigation burden for monitoring and data management, less data entry for site coordinators and eliminating discrepancies in queries are just a few of those benefits. As the consultants explained Web-Enabled EDC would improve P&G’s software, provide a more efficient workforce and investigators would have immediate access to the database.

As mentioned, in the first analysis of P&G and as the consultants recommended, the Web Enabled EDC would be the better solution for the company to reduce the length of time it takes to complete clinical trials for prescription drugs. It does not only improve the timing of clinical trials but has a positive effect on cost management and quality work for P&G. It also allows the company to venture into the digital era of experiencing new technologies. Overall, the Web Enabled EDC alternative would certainly improve the efficiency of P&G’s current data management system.      

Friday, May 3, 2013

Junk Van or No Van

Entrepreneur, Marcus Kingo invested himself in his company, took pride in his work and looked for success in creating a franchise company. Kingo’s fast-growing waste collection business has become a challenge ever since inefficiency and errors came knocking on his door. As his business is expanding operational challenges are emerging due to his custom-built MS-Works® database. Customer service is being sacrificed, the operation is negatively impacted and expenses are increasing because Junk Van’s data processing system is lacking in performance. Kingo has been left with a difficult decision of improving his virtual business model by finding the right information technology (IT) tool for his company. The right solution needs to be cost effective, established in a short time, simple to manage, remotely accessible to all employees especially drivers, use friendly and most importantly organized to keep all the components of his operation under control. The components Kingo’s operation consists of are the clerk’s database and bookkeeping, the driver’s itineraries, customer billing, payments and reservations, driver’s updates on performed jobs and staff payroll.

Kingo found five possible solutions for his business problem. The first option is to upgrade his MS- Works® to MS- Access® which can be done in a short time and at a low price. Converting his system will also fulfill his needs of hosting multiple computers and remote access. However, in order for the system to have remote access capabilities it must be hosted by a shared server which would require outside assistance as Kingo is unable to perform the set up. He is qualified enough to perform the upgrade on the local computers but that scenario would not allow for remote access. Adding the shared server would not only require professional assistance but also require additional user licenses for every employee. The licenses are priced at $179 per a computer. Kingo’s second option is to customize his own application. This would involve an IT specialist to build a custom system specifically for Kingo that would include all the necessary features to fit his virtual business model. Although, a custom system would be built to satisfy the central database with remote access per Junk Van’s needs, it would be costly and take up to four weeks to have the system operating. The upfront cost would be $2,000 plus $60 per hour per developer for maintenance support would be needed. It is difficult to estimate the cost of maintenance as Kingo could not predict how much maintenance would be needed for his custom-made software. Other downfalls with this alternative would be extra costs for data migration, not being able to approve the application or even see it before hand and support for this customized software would be billed by the hour. Google Docs would be Kingo’s third alternative and would certainly fulfill his price conscious factor as the program is free for up to ten user accounts and small businesses are only charged $5 per user per month or $50 per use per year. It would be implemented rather quickly as Kingo already created a free account to learn more, it is certainly user friendly and Kingo can migrate the system himself in a short amount of time. Although, Google Docs requires the company to input all their data on the online spreadsheet, it would cause issues for the call center operators who would need to work off a very extensive form. Inputting confidential customer and company information on this online application also raises confidentiality issues that Kingo may have to deal with in the future. Google Docs even lacks customer support and Kingo would be forced to use online blogs and forums for assistance with the program. A fourth alternative for Kingo’s Junk Van Company is called Platform as a Service (PaaS). This system is similar to Google Docs, as it delivers on a cloud-computing infrastructure but has the ability to provide users with a build your own application and common applications with a shared computing platform through a third party. Kingo witnessed this program in action when a sales representative performed an on-site trial and found that the system was straightforward. He could build forms and connect tables just as the agent did with the tasks. Another positive factor about this program is that it would take about three days to implement and migrate all of the company’s data. However, this software comes at a cost of $300 to $600 a month depending on the storage space, user licenses and amount of applications. For Kingo to customize the program further he would need to invest more time and money, the quoted amount for additional support would cost him $180 per hour. Seeing as price is a set back with this option, the advantages would be that no long-term contracts are required, monthly service amounts can be changed at any time and canceling the service only requires one month’s notice. A fifth alternative for Kingo would be the Enterprise Resource Planning (ERP) System that is built around a central database, designed for accessible remote access and allows for integrated business procedures. This alternative comes at a high cost of $2,500 per user per year with an expected user amount of 20-25. Seeing as Junk Van had fewer than 20-25 users the license prices would likely be higher at an estimated amount of $12,000 in lieu of four licenses. The ERP system also focused on finance and manufacture structures of a business; sections of the business Kingo did not need to invest time or money on since it is not relevant to what he needs. The system not only emphasizes on production but appears static and not as flexible to benefit Kingo’s virtual business model.

Kingo must make an important decision for his company in order to remain successful and escalate Junk Van to the next level of franchise. Junk Van is currently struggling to reduce inefficiencies, improve customer service, staying organized, keeping costs low and managing software that will enable important features like remote access and user friendly forms. Kingo hopes to keep his virtual business model idea and find the right software for his company. The fourth alternative, Platform as a Service (PaaS) is a logical opportunity for Kingo to choose as it provides all the right answers for him. It is cost effective as he is able to scale the service up or down at any point. This allows him to test packages and find the right one along with the right cost that suits his company best. In addition there are no long-term contracts to consider and cancellation of the software is simple. The program is user friendly to the point that Kingo can perform tasks himself and still have the ability to rely on their support system if needed. It also allows Kingo to build his own customizable application if he chooses. Best of all, the set up time only requires three days!

Thursday, May 2, 2013

P&G…Upgrading for the Better?

Procter & Gamble (P&G) loses millions of dollars each day a prescription drug is delayed to enter the market. In order for a new prescription drug to enter the market it must pass IV Phase trials, cost a company over $125 million and be approved by the FDA. During each of those phases, there is an average percentage of drugs that are tested and do not follow through to the next phase. For example, only 30% of the drugs that enter Phase II move onto Phase III. As anyone can imagine the other 70% of drugs that cannot move on to the next phase cause the company to lose roughly $15 million. With large dollar amounts like that, it is no wonder why P&G is looking for a solution to reduce the length of time it takes for their company to complete clinical trials for prescription drugs.

P&G currently manages their procedure through a typical paper-based trial that involves three phases: trial preparation, data collection and verification and data management and review. The scope of this procedure is that it works for P&G as they are accustomed to this process and know their financial budget for this method. However, with this process the lead times are excessive, causing the company to suffer in delays of introducing a new drug. P&G can turn to three respectable alternatives that will prevent delays in completing clinical trials for new prescription drugs. The important factor for P&G is to solve their problem by finding an alternative that will ultimately reduce the length of time it takes to complete clinical trials. For starters, P&G can improve their familiar paper-based system by speeding up the data management process. This alternative would entail an increase of staff and express mail shipments. Seeing as P&G currently has an extended process in site monitoring and source-data verification, added staff would decrease the time allowed for these two stages. Express mail shipments would also reduce the length of time during the paper-based process by delivering at a fast speed. Although, these two improvements would hurry the familiar system P&G uses they would still have to rely on the other stages of the paper-based process that create delays. A second alternative for P&G is the use of digital imaging, which follows the same procedure of the paper-based system except when transmitting data from investigator sites to the pharmaceutical sponsors. This method like the first alternative reduces the length of time but does not provide a significant decrease because delays occur in several stages of the process before and after the digital imaging period. For instance, investigative sites allow for CRF’s to pile up before faxing them into the system. Also, the time it takes to review the CRF images still create delays in the process. A third alternative for P&G is the use of Web-enabled EDC. This process truly diminishes the time it takes to complete a clinical trial as data is entered into the data management system, records are immediately applied, potential errors are identified during the entry process and all the data is available to sponsors immediately. With this option, there are fewer visits to the sites are required to perform source data verification. This reduction will help decrease the delays caused in the paper-based process. As Ray D’Alonzo, Associate Director for Clinical Data Management at Proctor & Gamble explains in the case study, Procter & Gamble: Electronic Data Capture and Clinical Trial Management the Web-enabled EDC is “a no-brainer.” This solution could speed up the process of clinical trials and allow the company to advance their methods through the latest technology.

This third alternative is allows the company to challenge their time constraints and complete clinical trials at a faster speed but are they considering costs? How much will the Web-enabled EDC system cost for P&G and will it pay itself off in the future? This is an important question to ask since technology is improving and changing every day. Will this system be outdated in a few years? Technology is constantly changing and asking these types of questions can really help P&G find the best option for reducing the time it takes for clinical trials. One can see that P&G’s paper-based system is certainly obsolete and improving this system will still leave the company behind in today’s digital era, making this not the most logical alternative. Also, the cost perspective for this alternative would result in higher expenses when hiring additional staff and paying for express shipment. Digital imaging is not a rational choice for P&G either as it still relies on their old school paper-based process to complete clinical trials and it will affect the company’s overhead. Web-enabled EDC is allowing P&G to enter a more technological stage by advancing their equipment. New technology does not come free and usually has high price tags but it will truly be worth P&G’s investments. Staying current with technology is significant to a company like P&G because any new products delivered today are already ancient history tomorrow due to new advancements being made in such a tech based world. Alternative three is certainly staying current and allows P&G to enter the digital era by using Web-enabled EDC. This option answers P&G’s problem of reducing the time it takes to complete clinical trials. It also allows for extra benefits that include less visits to sites, potential errors being identified and up to date records.