Tuesday, April 2, 2013

MS Project: A Business Partner for Exelis


Ray,

As you requested, I have researched MS Project in regards to its possible use at Exelis.   MS Project is a project management software with many uses and capabilities which would be beneficial to any project management team.  With MS Project, one is able to manage project schedules and finances, communicate and present project information/ status and organize resources to ensure deadlines and commitments are met.  MS Project enables simplified project management by providing tools and resources which will facilitate project planning, resource allocation, financial management as well as collaboration among project teams. 

Given our organizational structure, Exelis should invest in the MS Project software for our Program Management center of excellence as well as our XLSS center of excellence.  Both teams are focused on managing multiple projects simultaneously and would greatly benefit from this software.   MS Project would allow our program managers to efficiently manage their resources and budgets across their span of control.  Our Program Management and XLSS teams currently use MS Excel, PowerPoint and Visio for all project planning needs but are limited to their knowledge with these programs in order to provide useful summaries for our leadership teams as well as for effective project management.   These programs are not designed to aide in project management whereas MS Project is designed to provide a project manager full access to the project design, status, resources and related tasks. 

I would consider an initial investment in 60 MS Project Standard licenses at $589.99 for a total investment of $35,399.40.  I would recommend we provide licenses to each of our four business areas proportionately to their program management (PM) headcount.  For instance, our XYZ Business Area should receive ½ of the licenses that we procure as they have the largest PM Team.  Their portfolio is much more diverse and as a result they have more Program Managers.  While the PMs are responsible for multiple programs, they can use their license to manage all their programs.  MS Project would facilitate the program management process as it would provide PMs with the tools necessary to effectively and efficiently manage their resources, timeline and budget related to their multiple programs.  Additionally, I would recommend an investment in 10 MS Project Standard for our XLSS team to facilitate Six Sigma project design and implementation.  MS Project would be a great tool for our XLSS team as they are constantly working on multiple Green Belt projects at one time and would be able to use MS Project to plan and implement these projects simultaneously.  Investing in 10 licenses for our XLSS team would remove a vast majority of the administrative effort from our XLSS Black Belts and Mentors which could in turn focus on more Green Belt projects to generate additional cost savings for Exelis.   

Ray, as you can see, I am recommending an overall investment of $41,299.30 in MS Project for our Program Management and XLSS teams.  This investment would be an added value for both teams as it would enable effective and efficient project/ program management to coordinate resources and budget wisely from start to finish.  With MS Project, starting a project is as easy as entering tasks and assigning the related duration and start and finish times.  You can include as little or as much detail as needed for each task.  As you enter this data, a Gantt chart is generated.  MS Project will also allow our Program Managers to allocate their resources appropriately to ensure the right team members are assigned to the program.  It even allows you to enter the cost associated to each team member to be able to track budget.  MS Project would also allow Program Managers to share all program related details with the team via PDF reports.  Overall, the investment for Exelis would be minimal compared to the benefits that would be gained through the implementation of MS Project.  The cost can easily be absorbed with the implementation of two Green Belt projects which average about $20k per project. 

Thank you for your time and consideration.  Please advise if you have any additional questions, I would be glad to further discuss with you at your convenience.

 Jackie

Tuesday, March 26, 2013

Bombardier: Case Prep/ Updated with Reflection

Problem/Issue Statement
Bombardier was a key player in the transportation industry which entered the rail transportation market in 1974 and also entered the aerospace industry in 1986.  In an effort to increase its market share, Bombardier continued to acquire several corporations, including Canadair, the leading Canadian aircraft manufacturer, Lear Jet Corporation and Havilland Company.  Bombardier reported revenues of $14.8 Billion in 2007.  Revenues were evenly split between the aerospace and transportation industries. 

While the company was profitable and competitive, it faced several challenges related to the size of the business and its acquisitions.  Bombardier’s growth by acquisition generated some challenges for the business.  The multiple acquisitions resulted in various simultaneous systems for Bombardier.  As a result of the various acquisitions, Bombardier inherited the data, processes and systems of each company it acquired.  These inheritances created inefficiencies and problems for Bombardier.  The various systems did not communicate or integrate with one another, therefore, resulting in difficulties for the business. 

The standalone systems made it difficult given the various differences.  It was difficult for the systems to share data and analytics were also challenging.  Additionally, the upkeep and maintenance of the systems was costly.  Costs were multiplied by the number of systems given the lack of standardization.  These inefficiencies resulted in process delays, sequential activities, low inventory turns as well as multiple bills of material.  Most importantly, Bombardier’s most challenging task at hand was low visibility of inventory and lack of integration between its legacy systems.   

In an effort to strategically align the company, Bombardier took several steps in addressing the issues at hand.  They implemented common roles and responsibilities as well as common company values.  They also used Six Sigma tools for the evaluation of processes.  Bombardier’s desired outcome was an integrated organization where company data could be shared across the company using a single set of processes and systems.  The implementation of an ERP (Enterprise Resource Planning) system was considered the most beneficial in attaining the company’s goal.

Situation Assessment
Bombardier has gone through two implementation phases of the ERP system. The first ERP implementation was discontinued mid-project.  Some of the factors that contributed to its failure were focus on inappropriate business processes, an outdated company vision, a weak sponsorship model, and insufficient involvement of internal employees.  The second ERP implementation went live on the planned date and there were no significant disruptions to normal operations.    There were no real problems during Go Live and a high rate of accuracy was achieved.  However, employees provided feedback post Go-Live after being able to “live” with the system for some time.  They were able to share feedback which would facilitate further implementation and increase the value obtained from the system. 

In order to fully integrate the business and accomplish its “One Company” goal, Bombardier is rolling out a third phase of the ERP implementation.  During this third phase, Bombardier hopes to accomplish a full business integration as well as efficiency and effectiveness throughout their operations.  Given Bombardier’s prior experience with the ERP implementation, they hope to utilize lessons learned and results from the previous two phases in order to achieve their desired results during this phase. 

List of Plausible Alternative Courses of Action
In order for Bombardier to successfully implement the third phase of the ERP implementation, I would offer the following recommendations:
·        Secure Top Management and Leadership endorsement - By obtaining top leadership’s endorsement, the project’s importance and relevance will be reflected to employees.  An approach similar to the VP of Operations and Project Sponsor which believed that “we all have a pay cheque that says the word Bombardier on it and shouldn’t forget that.”  This message should be emphasized throughout the project to ensure employees understand that they are critical to the success of the ERP which in the end which benefit all, not just management and leadership. 

·        Assign a full-time project manager – By assigning a full-time project manager, the ERP implementation would be more effective and smooth.  A dedicated employee would be focused in the success of this rollout and would be able to gather ongoing feedback and work to resolve any issues that arise.  The project manager can also be in charge of continuously providing updates, resolutions and recommendation based on the overall business needs. 

·        Engage end users frequently – It is imperative that all involved parties are represented and empowered throughout the process.  End users know their job best and can provide useful and beneficial information that will decrease the risk of failure throughout the project.  Having representation is important to be able to understand all aspects of the business.

·        Provide on-going communication – Communication should be prioritized during all implementations.  It is extremely important to keep all involved parties up to date as related to project status, issues, risks, observations and overall progress to ensure the team is kept informed of all relevant data related to the project.  

·        Obtain representation from all functional areas – Given the various roles throughout the company, it would benefit the company to obtain representation from the various sites/ functions that will be impacted by the ERP implementation.  It is important to ensure all business needs are understood and planned for to avoid any hiccups in the long run. 

·        Provide training throughout the implementation – Training is a critical component of the success of any new implementation.  It will be useful to provide ongoing training to the involved parties to ensure the system is understood and aligned to business needs.  Training should be provided to the project to ensure they understand the capabilities of the ERP system.  An understanding of the system will allow them to make informed decisions for the success of the ERP rollout.   

Recommendation
Overall, Bombardier has the necessary tools, most importantly experience gained firsthand, to accomplish its goal.  The third phase of the ERP implementation should take into consideration lessons learned from the first two phases as well as the recommendations provided above.  In doing so, Bombardier will be able to establish a new baseline for the company.  In order to successfully implement phase three of the ERP, Bombardier should strive for ongoing communication, involvement and integration to ensure its benefits are maximized and well received.

Post-Presentation Reflection


 I have reflected on the consultant’s presentation over the past few days and I have come to a conclusion for our team going forward.  The consultant’s presentation was insightful and thought provoking.  I really valued their analysis of the 12 best practices.  It was definitely interesting to see how their scored our team as related to the 12 best practices.  There were some instances in which agreed with their scoring while there were also some that I disagreed with – especially the one related to the reassignment of our project team member’s full time responsibilities.  After our discussion with the consultants on this topic, I believe that this is easier said than done.  Our project team members would not be able to reassign their daily responsibilities, this would have to be worked out to ensure we provide the team members with the support needed in order to fulfill their duties. 

The recommendations provided by the consultants were thoroughly presented and discussed for our understanding.  After considering the information provided to us by the consultants, I would recommend that our team focus on best practices #3 and #6 to ensure inclusion and cohesiveness during the ERP implementation as well as best practice #9 to ensure SAP is developed and maintained in-house.  To address best practices #3 and #6, I would suggest our team go for recommended course of action #1: functional specialists included in project management team.  Following this course of action would benefit our team and allow us to ensure collaboration and diversification in our project.  By including functional specialists in our project team, our implementation would be aligned and structured for success by allowing all functional areas a voice in the project.  With respect to best practice #9, I believe recommended course of action would suggest a blend of options 2 and 3.  Option #2 relates to securing access to the SAP knowledge base for SAP developers and Option #3 relates to hiring 3 SAP SMEs.  I believe that we must provide our project with access to the knowledge base regardless of any other actions we take.  Access to the SAP knowledge base will be a valuable resource for our team and should be provided to at least one functional representative at each site.  SAP SMEs would also be valuable as they would provide our team with internal expertise and knowledge to ensure SAP is aligned to our business processes and needs. 

Overall, the information provided will be useful in ensuring the success of our next ERP implementation.  A combination of the recommended courses of actions will provide our team with quantifiable benefits which will result in success and overall savings for our team.  I look forward to working with you on our next ERP implementation, please advise if you would like to further discuss and review next steps for our team.  

Monday, March 4, 2013

Ubuntu: Worth the Savings for Exelis, Inc?


Ray,

I heard the buzz about Ubuntu during my Strategic Information Systems MBA course and was very eager to research to understand its features and specs.  The Ubuntu website provides useful information regarding the operating system.  First and foremost, Ubuntu is free.  Think about the cost savings related to the implementation of Ubuntu.  Exelis would save a generous amount of money which could be used for other initiatives or increase our operating income.  Ubuntu is fast and secure, built-in firewall and virus protection are available to ensure our data remains secure.  Additionally, it only takes a few seconds to load in comparison to Windows. 

Some of Ubuntu’s best features are as follows: 

·     Web-browsing:  FireFox is the default web browser for Ubuntu.  As you know, most of our employees prefer FireFox over Internet Explorer so I am certain this would be taken well.

·     Office Applications:  LibreOffice is Ubuntu’s version of MS Office and is also free.  Again, think of the cost savings for Exelis.   As you know, we have an MS license (approx. $150 per license) for all employees, multiply that (20,000) for a total cost of $3 Million.  This money can be added to our operating income or invested elsewhere if we switched to Ubuntu.  I believe it would be a smooth transition for our employees as the applications are very similar to the Microsoft suite.  Once you begin to work, it comes to you naturally.  It would only take a little while to get used to and let the savings begin.  Best of all, LibreOffice is compatible with Microsoft, therefore, employees would be able to retain any old documents or view documents from customers/ business contacts. 

·       Email:  Ubuntu’s email provider is Mozilla Thunderbird which is also safe and secure.  Again, switching to Mozilla Thunderbird would be seamless given the similarities to Outlook. 

Ray, as you can see, there are many benefits to making the switch to Ubuntu.  The most appealing feature is definitely the fact that it is free to use. By implementing Ubuntu, we would save money and would be able to invest in other revenue-generating opportunities.  While it all seems great, I would not recommend making the switch yet.  Given the complexity/ security concerns related to our business processes, I believe that Microsoft will continue to be our best option for many more years.  There are many applications, software, and programs that our employees use to complete their day-to-day responsibilities that we must ensure would be compatible with Ubuntu.  In addition, as you know, we use MS SharePoint for documents as well as policies and procedures.  I would want to review whether or not Ubuntu offers a similar application.  However, it would not simply be whether or not it offers something similar but also if there would be any additional effort/ cost required to transfer our documents/ policies and procedures to the Ubuntu version of MS SharePoint.  If so, it would definitely not be worth it since the cost would outweigh the benefit of Ubuntu.

Ray, I look forward to partnering with you to further review/ analyze Ubuntu for Exelis.

Thanks for your time.
Jackie 

Tuesday, February 26, 2013

ZARA: IT for Fast Fashion


 

        I.            Problem/Issue Statement


a)      Xan Salgado Badas and Bruno Sanchez are discussing the POS terminals used by Zara’s, Inditex’s largest chain of stores.  Inditex is a multinational clothing retailer and manufacturer headquartered in La Coruña, Spain.  Salgado was the head of IT for Inditex and Sanchez was the technical lead for the POS system.  They cannot agree on whether or not to change their POS terminals.  Both have strong opinions regarding their position on the debate and are not going to give in to the other’s opinion.  Salgado believes it is time to upgrade the POS application while Sanchez believed that there wasn’t a need to fix what wasn’t broken as the POS application was working just fine for them.


b)      The problem that is being discussed is whether or not to change the POS terminals used by Zara.  Salgado believes it is time to upgrade them as it is risky to let them get so far behind current technology.  Sanchez, on the other hand, believes it is riskier to change them as the software works just fine. 
 

The symptoms that have brought up this discussion are as follows:

 
o   Per Salgado: There is a need to upgrade the POS as they currently run on DOS, which is no longer supported by Microsoft.  He believes there is a possibility that the hardware vendor could upgrade their machines and could potentially change it so that it would no longer be compatible with DOS.  Salgado also pointed out that managers were asking for the change.  They (managers) wanted to be able to look up inventory balances in their stores and other stores.  An upgrade would allow them to have a well-rounded system which would allow them to interconnect/ change with other stores. 

 
o   Per Sanchez:  There are no symptoms that warrant the need to upgrade Zara’s POS terminals.  The software is working for Zara and there is no need to change it. 
 

c)      This problem involves all Zara stores, approximately 550.  The resolution to this problem will impact all operations related to the Zara stores.  If Sanchez gets Salgado to agree with him, the POS terminals at the stores would have to be upgraded. 

 
      II.            Situation Assessment

a)      In order to decide which alternative is most suitable for the company, Sanchez and Salgado must consider the following:

o   Cost of both alternatives

   §  Software

   §  Support

   §  Training

o   Risks associated to the alternatives

   §  Risk of continuing to run on DOS, which is no longer supported by Microsoft

   §  Risk of data loss

   §  Risk of messing up a process that is currently seamless

o   Benefits of each alternative

   §  No change:

     ·         Maintaining a process that is currently working

   ·         Cost savings – no added cost/ effort

   ·         Employee knowledge of the current DOS terminals

   ·         No IT involvement when new stores are opened

   §  Upgrading:

   ·         Added functionality such as real-time inventory across all locations

   ·         Networking capability

o  
Changes related to each alternative:

    §  Training required

    §  Process modification


    III.            Alternatives

a)      There are two options for Zara at this point.  It would be to either upgrade Zara’s POS terminals or keep everything status quo.

Per Sanchez:  He recommends keeping everything status quo at this point without making any changes.  Given Salgado’s concern related to DOS compatibility, Sanchez recommends purchasing a bunch of the current terminals which would provide them with breathing room should such a case arise. 

 Per Salgado:  He recommends upgrading to a modern operating system.  An upgrade would allow them to add functionality and networking capability for all the Zara stores.  By upgrading, store managers would be able to look up inventory for their stores as well as other stores in the comfort of their own store.  They would not have to call anyone – they would simply be able to do a quick search on their terminal.

 
b)      The alternatives address the problem at hand as follows:

Upgrade:  A software upgrade for Zara’s POS terminals would enable the company and stores to interact with one another.  It would also facilitate the store operations, particularly the ordering process.  Store managers would be able to process orders online versus having to use the digital handheld.  Having the form available online would facilitate the process as they would be able to see the pictures of the garments more clearly.  As reflected in Exhibit 8, the handhelds currently being used are very compact and do not provide the same level of display as a computer would if the POS terminals went through an upgrade.  The upgrade would also allow managers to look up their inventory on the computer without having to do a visual inspection.  I would visualize the ordering process as follows if the upgrade is implemented: 

            o   Current inventory available on terminals

            o   Ordering window announced and form is made available

                §  Provide the store managers with the same data currently being provided

            o   Order approved/ modified at La Coruña

            o   Inventory automatically updated after order had been finalized/ order received

Status Quo: By keeping everything intact, Zara would continue to operate using their basic POS application.  Zara’s would save money and would be able to invest money in new locations as opposed to new software/ training related to upgrading the POS terminals.  By continuing operations as currently in place, IT’s involvement would not be required when opening new stores and in-house support would be available for any IT issues that arise related to the DOS terminals.

    IV.            Recommendation

Given the insight on Zara’s operations, I believe it would be best for Zara’s to continue using their current POS terminals and forego the upgrade.  I agree with Sanchez, it is not worth fixing what is not broken.  The implementation of an upgrade would be added cost for Zara’s at this point.  It would also be added effort to designate a team dedicated to this upgrade.  The upgrade would require the team to collaborate to understand what changes would be needed and what would work best for Zara’s. After deciding and implementing the changes, they would also have to roll out training to introduce the new software.  All these added costs are not necessary at the time and this money would be better spent with other initiatives that require Zara’s attention at this time. 

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.