Survival Analysis in Microsoft Excel without Add-ins SWOT Analysis / TOWS Matrix / Weighted SWOT Analysis
Global Business
Strategy / MBA Resources
Case Study SWOT Analysis Solution
Case Study Description of Survival Analysis in Microsoft Excel without Add-ins
Survival analysis refers to a collection of statistical techniques used to analyze the occurrence and expected timing of events. Survival analysis can provide not only the probability of an event of interest occurring, but also the time at which the event is likely to occur. A particularly useful application of survival analysis is in the area of "customer churn"-the loss of clients or customers-which is a major concern in many industries. This note introduces survival analysis and discusses two approaches to examine customer churn: the Kaplan-Meier estimator and the Cox proportional hazards model. Instructions are provided on how to build these models in Microsoft Excel, without add-ins.
Swot Analysis of "Survival Analysis in Microsoft Excel without Add-ins" written by Gregory S. Zaric, Matthew Lui includes – strengths weakness that are internal strategic factors of the organization, and opportunities and threats that Survival Churn facing as an external strategic factors. Some of the topics covered in Survival Analysis in Microsoft Excel without Add-ins case study are - Strategic Management Strategies, Financial analysis and Global Business.
Some of the macro environment factors that can be used to understand the Survival Analysis in Microsoft Excel without Add-ins casestudy better are - – wage bills are increasing, increasing commodity prices, central banks are concerned over increasing inflation, increasing transportation and logistics costs, technology disruption, geopolitical disruptions, challanges to central banks by blockchain based private currencies,
there is backlash against globalization, increasing energy prices, etc
Introduction to SWOT Analysis of Survival Analysis in Microsoft Excel without Add-ins
SWOT stands for an organization’s Strengths, Weaknesses, Opportunities and Threats . At Oak Spring University , we believe that protagonist in Survival Analysis in Microsoft Excel without Add-ins case study can use SWOT analysis as a strategic management tool to assess the current internal strengths and weaknesses of the Survival Churn, and to figure out the opportunities and threats in the macro environment – technological, environmental, political, economic, social, demographic, etc in which Survival Churn operates in.
According to Harvard Business Review, 75% of the managers use SWOT analysis for various purposes such as – evaluating current scenario, strategic planning, new venture feasibility, personal growth goals, new market entry, Go To market strategies, portfolio management and strategic trade-off assessment, organizational restructuring, etc.
SWOT Objectives / Importance of SWOT Analysis and SWOT Matrix
SWOT analysis of Survival Analysis in Microsoft Excel without Add-ins can be done for the following purposes –
1. Strategic planning using facts provided in Survival Analysis in Microsoft Excel without Add-ins case study
2. Improving business portfolio management of Survival Churn
3. Assessing feasibility of the new initiative in Global Business field.
4. Making a Global Business topic specific business decision
5. Set goals for the organization
6. Organizational restructuring of Survival Churn
Strengths Survival Analysis in Microsoft Excel without Add-ins | Internal Strategic Factors
What are Strengths in SWOT Analysis / TOWS Matrix / Weighted SWOT Analysis
The strengths of Survival Churn in Survival Analysis in Microsoft Excel without Add-ins Harvard Business Review case study are -
Learning organization
- Survival Churn is a learning organization. It has inculcated three key characters of learning organization in its processes and operations – exploration, creativity, and expansiveness. The work place at Survival Churn is open place that encourages instructiveness, ideation, open minded discussions, and creativity. Employees and leaders in Survival Analysis in Microsoft Excel without Add-ins Harvard Business Review case study emphasize – knowledge, initiative, and innovation.
High switching costs
– The high switching costs that Survival Churn has built up over years in its products and services combo offer has resulted in high retention of customers, lower marketing costs, and greater ability of the firm to focus on its customers.
Strong track record of project management
– Survival Churn is known for sticking to its project targets. This enables the firm to manage – time, project costs, and have sustainable margins on the projects.
Diverse revenue streams
– Survival Churn is present in almost all the verticals within the industry. This has provided firm in Survival Analysis in Microsoft Excel without Add-ins case study a diverse revenue stream that has helped it to survive disruptions such as global pandemic in Covid-19, financial disruption of 2008, and supply chain disruption of 2021.
Successful track record of launching new products
– Survival Churn has launched numerous new products in last few years, keeping in mind evolving customer preferences and competitive pressures. Survival Churn has effective processes in place that helps in exploring new product needs, doing quick pilot testing, and then launching the products quickly using its extensive distribution network.
Superior customer experience
– The customer experience strategy of Survival Churn in the segment is based on four key concepts – personalization, simplification of complex needs, prompt response, and continuous engagement.
Effective Research and Development (R&D)
– Survival Churn has innovation driven culture where significant part of the revenues are spent on the research and development activities. This has resulted in, as mentioned in case study Survival Analysis in Microsoft Excel without Add-ins - staying ahead in the industry in terms of – new product launches, superior customer experience, highly competitive pricing strategies, and great returns to the shareholders.
Ability to recruit top talent
– Survival Churn is one of the leading recruiters in the industry. Managers in the Survival Analysis in Microsoft Excel without Add-ins are in a position to attract the best talent available. The firm has a robust talent identification program that helps in identifying the brightest.
Highly skilled collaborators
– Survival Churn has highly efficient outsourcing and offshoring strategy. It has resulted in greater operational flexibility and bringing down the costs in highly price sensitive segment. Secondly the value chain collaborators of the firm in Survival Analysis in Microsoft Excel without Add-ins HBR case study have helped the firm to develop new products and bring them quickly to the marketplace.
High brand equity
– Survival Churn has strong brand awareness and brand recognition among both - the exiting customers and potential new customers. Strong brand equity has enabled Survival Churn to keep acquiring new customers and building profitable relationship with both the new and loyal customers.
Digital Transformation in Global Business segment
- digital transformation varies from industry to industry. For Survival Churn digital transformation journey comprises differing goals based on market maturity, customer technology acceptance, and organizational culture. Survival Churn has successfully integrated the four key components of digital transformation – digital integration in processes, digital integration in marketing and customer relationship management, digital integration into the value chain, and using technology to explore new products and market opportunities.
Training and development
– Survival Churn has one of the best training and development program in the industry. The effectiveness of the training programs can be measured in Survival Analysis in Microsoft Excel without Add-ins Harvard Business Review case study by analyzing – employees retention, in-house promotion, loyalty, new venture initiation, lack of conflict, and high level of both employees and customer engagement.
Weaknesses Survival Analysis in Microsoft Excel without Add-ins | Internal Strategic Factors
What are Weaknesses in SWOT Analysis / TOWS Matrix / Weighted SWOT Analysis
The weaknesses of Survival Analysis in Microsoft Excel without Add-ins are -
Ability to respond to the competition
– As the decision making is very deliberative, highlighted in the case study Survival Analysis in Microsoft Excel without Add-ins, in the dynamic environment Survival Churn has struggled to respond to the nimble upstart competition. Survival Churn has reasonably good record with similar level competitors but it has struggled with new entrants taking away niches of its business.
Compensation and incentives
– The revenue per employee as mentioned in the HBR case study Survival Analysis in Microsoft Excel without Add-ins, is just above the industry average. Survival Churn needs to redesign the compensation structure and incentives to increase the revenue per employees. Some of the steps that it can take are – hiring more specialists on project basis, etc.
Low market penetration in new markets
– Outside its home market of Survival Churn, firm in the HBR case study Survival Analysis in Microsoft Excel without Add-ins needs to spend more promotional, marketing, and advertising efforts to penetrate international markets.
Skills based hiring
– The stress on hiring functional specialists at Survival Churn has created an environment where the organization is dominated by functional specialists rather than management generalist. This has resulted into product oriented approach rather than marketing oriented approach or consumers oriented approach.
Lack of clear differentiation of Survival Churn products
– To increase the profitability and margins on the products, Survival Churn needs to provide more differentiated products than what it is currently offering in the marketplace.
High dependence on existing supply chain
– The disruption in the global supply chains because of the Covid-19 pandemic and blockage of the Suez Canal illustrated the fragile nature of Survival Churn supply chain. Even after few cautionary changes mentioned in the HBR case study - Survival Analysis in Microsoft Excel without Add-ins, it is still heavily dependent upon the existing supply chain. The existing supply chain though brings in cost efficiencies but it has left Survival Churn vulnerable to further global disruptions in South East Asia.
Slow to strategic competitive environment developments
– As Survival Analysis in Microsoft Excel without Add-ins HBR case study mentions - Survival Churn takes time to assess the upcoming competitions. This has led to missing out on atleast 2-3 big opportunities in the industry in last five years.
Increasing silos among functional specialists
– The organizational structure of Survival Churn is dominated by functional specialists. It is not different from other players in the Global Business segment. Survival Churn needs to de-silo the office environment to harness the true potential of its workforce. Secondly the de-silo will also help Survival Churn to focus more on services rather than just following the product oriented approach.
Products dominated business model
– Even though Survival Churn has some of the most successful products in the industry, this business model has made each new product launch extremely critical for continuous financial growth of the organization. firm in the HBR case study - Survival Analysis in Microsoft Excel without Add-ins should strive to include more intangible value offerings along with its core products and services.
Aligning sales with marketing
– It come across in the case study Survival Analysis in Microsoft Excel without Add-ins that the firm needs to have more collaboration between its sales team and marketing team. Sales professionals in the industry have deep experience in developing customer relationships. Marketing department in the case Survival Analysis in Microsoft Excel without Add-ins can leverage the sales team experience to cultivate customer relationships as Survival Churn is planning to shift buying processes online.
Workers concerns about automation
– As automation is fast increasing in the segment, Survival Churn needs to come up with a strategy to reduce the workers concern regarding automation. Without a clear strategy, it could lead to disruption and uncertainty within the organization.
Opportunities Survival Analysis in Microsoft Excel without Add-ins | External Strategic Factors
What are Opportunities in the SWOT Analysis / TOWS Matrix / Weighted SWOT Analysis
The opportunities highlighted in the Harvard Business Review case study Survival Analysis in Microsoft Excel without Add-ins are -
Lowering marketing communication costs
– 5G expansion will open new opportunities for Survival Churn in the field of marketing communication. It will bring down the cost of doing business, provide technology platform to build new products in the Global Business segment, and it will provide faster access to the consumers.
Developing new processes and practices
– Survival Churn can develop new processes and procedures in Global Business industry using technology such as automation using artificial intelligence, real time transportation and products tracking, 3D modeling for concept development and new products pilot testing etc.
Manufacturing automation
– Survival Churn can use the latest technology developments to improve its manufacturing and designing process in Global Business segment. It can use CAD and 3D printing to build a quick prototype and pilot testing products. It can leverage automation using machine learning and artificial intelligence to do faster production at lowers costs, and it can leverage the growth in satellite and tracking technologies to improve inventory management, transportation, and shipping.
Use of Bitcoin and other crypto currencies for transactions
– The popularity of Bitcoin and other crypto currencies as asset class and medium of transaction has opened new opportunities for Survival Churn in the consumer business. Now Survival Churn can target international markets with far fewer capital restrictions requirements than the existing system.
Identify volunteer opportunities
– Covid-19 has impacted working population in two ways – it has led to people soul searching about their professional choices, resulting in mass resignation. Secondly it has encouraged people to do things that they are passionate about. This has opened opportunities for businesses to build volunteer oriented socially driven projects. Survival Churn can explore opportunities that can attract volunteers and are consistent with its mission and vision.
Harnessing reconfiguration of the global supply chains
– As the trade war between US and China heats up in the coming years, Survival Churn can build a diversified supply chain model across various countries in - South East Asia, India, and other parts of the world. This reconfiguration of global supply chain can help, as suggested in case study, Survival Analysis in Microsoft Excel without Add-ins, to buy more products closer to the markets, and it can leverage its size and influence to get better deal from the local markets.
Reforming the budgeting process
- By establishing new metrics that will be used to evaluate both existing and potential projects Survival Churn can not only reduce the costs of the project but also help it in integrating the projects with other processes within the organization.
Changes in consumer behavior post Covid-19
– Consumer behavior has changed in the Global Business industry because of Covid-19 restrictions. Some of this behavior will stay once things get back to normal. Survival Churn can take advantage of these changes in consumer behavior to build a far more efficient business model. For example consumer regular ordering of products can reduce both last mile delivery costs and market penetration costs. Survival Churn can further use this consumer data to build better customer loyalty, provide better products and service collection, and improve the value proposition in inflationary times.
Buying journey improvements
– Survival Churn can improve the customer journey of consumers in the industry by using analytics and artificial intelligence. Survival Analysis in Microsoft Excel without Add-ins suggest that firm can provide automated chats to help consumers solve their own problems, provide online suggestions to get maximum out of the products and services, and help consumers to build a community where they can interact with each other to develop new features and uses.
Building a culture of innovation
– managers at Survival Churn can make experimentation a productive activity and build a culture of innovation using approaches such as – mining transaction data, A/B testing of websites and selling platforms, engaging potential customers over various needs, and building on small ideas in the Global Business segment.
Using analytics as competitive advantage
– Survival Churn has spent a significant amount of money and effort to integrate analytics and machine learning into its operations in the sector. This continuous investment in analytics has enabled, as illustrated in the Harvard case study Survival Analysis in Microsoft Excel without Add-ins - to build a competitive advantage using analytics. The analytics driven competitive advantage can help Survival Churn to build faster Go To Market strategies, better consumer insights, developing relevant product features, and building a highly efficient supply chain.
Creating value in data economy
– The success of analytics program of Survival Churn has opened avenues for new revenue streams for the organization in the industry. This can help Survival Churn to build a more holistic ecosystem as suggested in the Survival Analysis in Microsoft Excel without Add-ins case study. Survival Churn can build new products and services such as - data insight services, data privacy related products, data based consulting services, etc.
Low interest rates
– Even though inflation is raising its head in most developed economies, Survival Churn can still utilize the low interest rates to borrow money for capital investment. Secondly it can also use the increase of government spending in infrastructure projects to get new business.
Threats Survival Analysis in Microsoft Excel without Add-ins External Strategic Factors
What are Threats in the SWOT Analysis / TOWS Matrix / Weighted SWOT Analysis
The threats mentioned in the HBR case study Survival Analysis in Microsoft Excel without Add-ins are -
Consumer confidence and its impact on Survival Churn demand
– There is a high probability of declining consumer confidence, given – high inflammation rate, rise of gig economy, lower job stability, increasing cost of living, higher interest rates, and aging demography. All the factors contribute to people saving higher rate of their income, resulting in lower consumer demand in the industry and other sectors.
Capital market disruption
– During the Covid-19, Dow Jones has touched record high. The valuations of a number of companies are way beyond their existing business model potential. This can lead to capital market correction which can put a number of suppliers, collaborators, value chain partners in great financial difficulty. It will directly impact the business of Survival Churn.
Shortening product life cycle
– it is one of the major threat that Survival Churn is facing in Global Business sector. It can lead to higher research and development costs, higher marketing expenses, lower customer loyalty, etc.
New competition
– After the dotcom bust of 2001, financial crisis of 2008-09, the business formation in US economy had declined. But in 2020 alone, there are more than 1.5 million new business applications in United States. This can lead to greater competition for Survival Churn in the Global Business sector and impact the bottomline of the organization.
Environmental challenges
– Survival Churn needs to have a robust strategy against the disruptions arising from climate change and energy requirements. EU has identified it as key priority area and spending 30% of its 880 billion Euros European post Covid-19 recovery funds on green technology. Survival Churn can take advantage of this fund but it will also bring new competitors in the Global Business industry.
Increasing international competition and downward pressure on margins
– Apart from technology driven competitive advantage dilution, Survival Churn can face downward pressure on margins from increasing competition from international players. The international players have stable revenue in their home market and can use those resources to penetrate prominent markets illustrated in HBR case study Survival Analysis in Microsoft Excel without Add-ins .
Easy access to finance
– Easy access to finance in Global Business field will also reduce the barriers to entry in the industry, thus putting downward pressure on the prices because of increasing competition. Survival Churn can utilize it by borrowing at lower rates and invest it into research and development, capital expenditure to fortify its core competitive advantage.
Backlash against dominant players
– US Congress and other legislative arms of the government are getting tough on big business especially technology companies. The digital arm of Survival Churn business can come under increasing regulations regarding data privacy, data security, etc.
High level of anxiety and lack of motivation
– the Great Resignation in United States is the sign of broader dissatisfaction among the workforce in United States. Survival Churn needs to understand the core reasons impacting the Global Business industry. This will help it in building a better workplace.
Technology disruption because of hacks, piracy etc
– The colonial pipeline illustrated, how vulnerable modern organization are to international hackers, miscreants, and disruptors. The cyber security interruption, data leaks, etc can seriously jeopardize the future growth of the organization.
Barriers of entry lowering
– As technology is more democratized, the barriers to entry in the industry are lowering. It can presents Survival Churn with greater competitive threats in the near to medium future. Secondly it will also put downward pressure on pricing throughout the sector.
High dependence on third party suppliers
– Survival Churn high dependence on third party suppliers can disrupt its processes and delivery mechanism. For example -the current troubles of car makers because of chip shortage is because the chip companies started producing chips for electronic companies rather than car manufacturers.
Technology acceleration in Forth Industrial Revolution
– Survival Churn has witnessed rapid integration of technology during Covid-19 in the Global Business industry. As one of the leading players in the industry, Survival Churn needs to keep up with the evolution of technology in the Global Business sector. According to Mckinsey study top managers believe that the adoption of technology in operations, communications is 20-25 times faster than what they planned in the beginning of 2019.
Weighted SWOT Analysis of Survival Analysis in Microsoft Excel without Add-ins Template, Example
Not all factors mentioned under the Strengths, Weakness, Opportunities, and Threats quadrants in the SWOT Analysis are equal. Managers in the HBR case study Survival Analysis in Microsoft Excel without Add-ins needs to zero down on the relative importance of each factor mentioned in the Strengths, Weakness, Opportunities, and Threats quadrants.
We can provide the relative importance to each factor by assigning relative weights. Weighted SWOT analysis process is a three stage process –
First stage for doing weighted SWOT analysis of the case study Survival Analysis in Microsoft Excel without Add-ins is to rank the strengths and weaknesses of the organization. This will help you to assess the most important strengths and weaknesses of the firm and which one of the strengths and weaknesses mentioned in the initial lists are marginal and can be left out.
Second stage for conducting weighted SWOT analysis of the Harvard case study Survival Analysis in Microsoft Excel without Add-ins is to give probabilities to the external strategic factors thus better understanding the opportunities and threats arising out of macro environment changes and developments.
Third stage of constructing weighted SWOT analysis of Survival Analysis in Microsoft Excel without Add-ins is to provide strategic recommendations includes – joining likelihood of external strategic factors such as opportunities and threats to the internal strategic factors – strengths and weaknesses. You should start with external factors as they will provide the direction of the overall industry. Secondly by joining probabilities with internal strategic factors can help the company not only strategic fit but also the most probably strategic trade-off that Survival Churn needs to make to build a sustainable competitive advantage.