Supply Chain Modeling On Excel

Chapter 2: Introduction to Spreadsheet Modeling: Case 2.1 Project Selection at Ewing Natural Gas Book Title: Practical Management Science Printed By: Alixen Sanchez ([email protected]) © 2019 Cengage Learning, Cengage Learning

Chapter Review

Case 2.1 Project Selection at Ewing Natural Gas

Ewing Natural Gas is a large energy company with headquarters in Dallas, Texas. The company offers a wide variety of energy products and has annual revenues of approximately $50 billion. Because of the diverse nature of the company, its Manager for Project Development, Cliff Erland, is under continual pressure to manage project proposals from the functional areas of the company. At any point in time, there might be dozens of projects at various stages requiring a wide variety of capital expenditures, promising widely varying future revenue streams, and containing varying degrees of risk. Cliff has a difficult balancing act. The company’s CEO, J.R. Bayer, is very concerned about keeping capital expenditures within a fixed budget and managing risk. The heads of the company’s functional areas are less worried about budgets and risks; they are most concerned that their pet projects are approved. Cliff also knows that many of the proposed projects, especially those requiring large capital expenditures, must be led by senior project managers with the appropriate experience and skills, and he is keenly aware that the company has only a limited supply of such managers.

Cliff is currently about to meet with all parties involved to discuss project proposals for the next three years. He has proposals from the various functional areas for projects they would like to undertake. Each of these is accompanied by a schedule of capital expenditures over the next three years and a financial analysis of the expected revenue streams. These lead to an NPV for each proposal, using the company’s discount rate of 12%. (See Table 2.2.) J.R. Bayer has stated in no uncertain terms that the total of capital expenditures for the approved projects can be no more than $10 billion and that no more than $4 billion should be spent in any single year. Unfortunately, the capital expenditures for the potential list of projects is well over $10 billion, so Cliff knows that some of these very promising projects will not be approved.

Table 2.2

Financial Estimates for Potential Projects (in $ millions)

Project Index

Functional Area (FA)

Partnership Percentage

Capex Year 1

Capex Year 2

Capex Year 3

NPV

1 FA1 100% 250 100 100 60

2 FA1 33% 500 300 300 180

javascript://
javascript://
Project Index

Functional Area (FA)

Partnership Percentage

Capex Year 1

Capex Year 2

Capex Year 3

NPV

3 FA1 50% 100 200 400 80

4 FA1 100% 750 500 300 310

5 FA1 75% 200 400 800 220

6 FA2 50% 1000 300 300 180

7 FA2 100% 750 750 300 410

8 FA2 100% 800 700 600 280

9 FA2 67% 400 600 800 380

10 FA3 100% 100 200 400 100

11 FA3 50% 700 500 300 260

12 FA3 100% 1500 400 400 340

Before the big meeting, Cliff wants to be thoroughly prepared to answer all of the questions he knows he will be asked by the CEO, the functional heads, and other interested parties. As a first step, he wants you to develop an Excel spreadsheet model that provides the following. (You will be asked to extend this analysis in cases in later chapters.)

The model should list the given financial information for all potential projects.

The model should associate with each proposed project a cell that is 1 if the project is approved and 0 if it is not approved.

Several of the projects, if approved, must be undertaken in joint partnership with another company. For example, if project 3 is approved (see Table 2.2), Ewing will take a 50% share in the project, and the other 50% will be shared by a partner. In this case, Ewing incurs only 50% of the expenditures and receives only 50% of the revenues.

Each functional area wants as many of its projects to be approved as possible, but it certainly does not want to be shut out altogether. The model should indicate each of the following: the number of approved projects for each functional area and whether each functional area gets at least one approved project. The latter should be indicated by a 0/1 value: 0 if the functional area is shut out and 1 if it gets at least one.

The model should find the sum of capital expenditures for all approved projects, both by year and by the total over all three years. It should also address J.R. Bayer’s

javascript://
concerns by indicating whether the total for all three years exceeds $10 billion and, for each year, whether that year’s total expenditures exceed $4 billion. As in the previous bullet, these should be indicated by 0/1 values. (Hint: For this bullet and the next one, you might want to avoid complex formulas by creating a table for the company as a whole and for each functional area separately, where each table shows the capital expenditure for each project for each year.)

The model should find the sum of capital expenditures for all approved projects, by year, for each functional area.

Recognizing that the NPVs in the table are probably optimistic estimates, the model should include another input, the possible percentage decrease in each original NPV. Then, there should be a new NPV column that reflects this percentage decrease.

The model should list the ROI (return on investment) for each project, defined as the NPV as a percentage of the total capital expenditure for the project. Each ROI should be based on the adjusted NPV from the previous bullet. (Note: The ROI for any project is the same, regardless of whether Ewing undertakes it at the 100% level or in a partnership.)

The model should include a one-way data table in which the column input is the common percentage decrease in each NPV mentioned previously, varied from 0% to 30% in increments of 5%. The outputs in the data table should include the following statistics for the ROIs of undertaken projects: the average; the minimum; and the maximum. Of course, the results in this data table should update automatically if the 0/1 values in the second bullet are changed. (Note: Excel has an AVERAGEIF function you can use to find the requested average, but it does not have corresponding MINIF or MAXIF functions. Finding formulas for the requested minimum and maximum is more difficult than it sounds, so you can consider this part a bonus, and you can omit it if necessary.)

The model should be accompanied by a line chart of total capital expenditures for all approved projects by year and a separate such line chart for each functional area.

Chapter 2: Introduction to Spreadsheet Modeling: Case 2.1 Project Selection at Ewing Natural Gas Book Title: Practical Management Science Printed By: Alixen Sanchez ([email protected]) © 2019 Cengage Learning, Cengage Learning

© 2021 Cengage Learning Inc. All rights reserved. No part of this work may by reproduced or used in any form or by any means – graphic, electronic, or mechanical, or in any other manner – without the written permission of the copyright holder.

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Business Ethics Now 50 MCQs

All of the following are sources of individuals’ moral standards except: A) Family B) Religion C) Government D) Friends 2 What is it that makes the study of ethics so complex? A) Constant change B) The grey area C) Differing religions D) Black and white decisions 3. Which of the following faces the problem that societies can place different emphases on different virtues? A) Normative ethics B) Utilitarianism C) Virtue ethics D) Universal ethics 4. All of the following are questions identified by Arthur Dorbin to resolve an ethical dilemma except: A) What do your feelings tell you? B) What are the alternatives? C) What are the facts? D) What will you think of yourself if you decide one thing or another? 5. How many stages are in Lawrence Kohlberg’s stages of ethical reasoning? A) 3 B) 5 C) 6 D) 7 1 Instrumental value is pursued for its own sake, whether anything good comes from the pursuit or not. A) True B) False 2 Simple truth is one of the four basic categories of ethics and can be expressed simply as doing the right thing. A) True B) False 3 Utilitarianism is a belief in the ethical choices that offer the greatest good for the greatest number of people. A) True B) False 4 The final step in solving an ethical dilemma is to evaluate the results of your decision. A) True B) False 5 Kohlberg stated that it would be impossible for a person to comprehend the moral issues and dilemmas at a level so far beyond his or her life experience and education. A) True B) False 1. All of the following are stakeholders except: A) customers B) federal government C) competitors D) community 2 A(n) _______ is the combination of two contradictory terms. A) oxymoron B) synonym C) antonym D) metaphor 3 According to the text, which of the following is not an ethical cliché? A) Do what’s legal B) Consult the company code of ethics C) Do what I do D) Do what you think is best 4 In which type of conflict would you face the following question: Do you perceive the issue as a question of dispensing justice or dispensing mercy? A) Short-term versus long-term B) Truth versus loyalty C) Individual versus community D) None of these 5 Every unethical act that goes undiscovered reinforces which of the following: A) A belief that the activity is “safe” because it will never be discovered or publicized B) A belief that the activity is within reasonable ethical and legal limits C) A belief that the activity is in the individual’s or the corporations’ best interest D) A belief that because the activity helps the company, the company will condone it and even protect the person who engages in it 1 All of the following are key functions of an organization except: A) Sales B) Information systems C) Marketing D) R&D 2 What is the real ethical dilemma faced by the R&D department? A) Product costs B) Product quality C) Production time D) Product originality 3 Ideally, the human resources function within an organization should be directly involved in all of the following except: A) the creation of a career development program for the employee B) the creation of the job description for the position C) the marketing of the organization’s products D) the documentation of periodic performance reviews 4 Advocates of ethical business conduct argue that the HR department needs to ensure that all of the following critical areas are addressed except: A) HR must keep track of all of the company’s financial transactions B) HR professionals must help ensure that ethics are a top priority C) HR is responsible for ensuring that the right programs and policies are in place D) HR must stay abreast ethical issues 5 What is the number one reason explaining why employees stretch the truth in the workplace? A) Acceptance by co-workers B) Profits C) Investor relations D) Stakeholder relations 1 Which approach to corporate management states that the only obligation of a corporation is to maximize profits for its shareholders? A) Shareholder approach B) Social contract approach C) Economic approach D) Instrumental approach 2 Which approach to corporate management is considered simplistic because it assumes that there are no external consequences to the actions of the corporation? A) Shareholder approach B) Social contract approach C) Economic approach D) Instrumental approach 3 All of the following are major trends behind the CSR phenomenon except: A) sustainability B) globalization C) the failure of the private sector D) knowledge 4 Corporations pursue operational efficiency through detailed monitoring of their bottom line in all of the following areas except: A) ethical activities B) financial performance C) social activities D) environmental activities 5 Which of the following is one of the newest and increasingly questionable practices in the world of CSR? A) Risk management and emergency preparedness B) Water conservation C) Greenhouse gas conscience D) “Carbon neutral” operations 1 The owners of a corporation are typically a fragmented group consisting of all of the following, except: A) individual public shareholders B) the government C) employees D) other companies 2 Who is responsible for overseeing the financial reporting process of an organization? A) The board of directors B) The audit committee C) The frontline managers D) The compensation committee 3 What would be a negative consequence of merging the roles of the chief executive officer and the board of directors? A) Extensive company knowledge B) Efficiency C) Ethical reasoning D) Effectiveness 4 All of the following personalities received media coverage for corporate scandals, except: A) Wagoner at General Motors B) Lay at Enron C) Scrushy at HealthSouth D) Rigas at Adelphia Cable 5 Which of the following is NOT a question on Walter Salmon’s checklist to assess the quality of an organization’s board? A) Are the insiders limited to the CEO, the COO, and the CFO? B) Is your board the right size (15 to 20 members)? C) Do you take the right measures to build trust among directors? D) Are there three or more outside directors to every insider? 1 Under which area does the FCPA require corporations to fully disclose any and all transactions conducted with foreign officials and politicians, in line with the SEC provisions? A) Prohibition B) Disclosure C) Exclusion D) Prevention 2 All of the following are principles included in the DII, except: A) Each company will have and adhere to a written code of business ethics and conduct B) Each company will create a free and open atmosphere that allows and encourages employees to report violations of its code to the company without fear of retribution for such reporting C) Each company has the responsibility to live by the standards to increase investors’ confidence in the defense industry D) Each company must have public accountability for its commitment to these principles 3 Which of the following is NOT a step in calculating a fine sentenced by the FSGO? A) The culpability score B) The total fine amount C) The determination of the base fine D) The determination of the mitigating factors 4 An effective compliance program includes all of the following, except: A) Management oversight B) Consistent discipline C) Coercive action D) Compliance with standards and procedures 5 All of the following are covered under Title II: Auditor Independence, except: A) prohibits specific “nonaudit” services of public accounting firms as violations of auditor independence B) requires the external auditor to report to the client’s audit committee on specific topics C) requires auditors to disclose all other written communications between management and themselves D) requires audit committees to be independent and undertake specified oversight responsibilities 1 Who was the CEO of Enron when Sherron Watkin’s blew the whistle? A) Joseph Berardino B) Jeffery Skilling C) Bernard Ebbers D) Kenneth Lay 2 Whistle-blowing is ethical under all of the following conditions, except: A) when the motivation is financial gain B) when the employee identifies a serious threat of harm C) when the company will cause serious and considerable harm to the public D) when the employee’s immediate supervisor does not act, and the internal procedures and chain of command have been exhausted 3 All of the following women were recognized by Times magazine as a “Person of the Year,” except: A) Martha Jenkins B) Cynthia Cooper C) Coleen Rowley D) Sherron Watkins 4 Congress took an integrated approach to the matter of whistle-blowing by prohibiting retaliation against whistleblowers and encouraging the act of whistle-blowing under which act? A) The Sarbanes-Oxley Act B) The Whistleblower Protection Act of 1989 C) False Claims Act of 1963 D) Federal Sentencing Guidelines Act 5 Given the new legal environment surrounding whistleblowers, employers would be wise to put all of the following mechanisms in place, except: A) a detailed report of all investigations, documenting all corporate officers involved and all actions taken B) a well-defined process to document how such complaints are handled C) an employee hotline to file such complaints D) a prompt and thorough investigation of serious complaints 1 Which of the following has NOT changed with our work environment over the last two decades? A) Desktop computers B) Instant messaging C) The World Wide Web D) Face-to-face communication 2 Why has arriving at a satisfactory resolution of the opposing arguments surrounding electronic monitoring proven to be difficult? A) Both sides are unwilling to negotiate the issue B) Employers view electronic monitoring as a necessity to preserve the interests of their stakeholders C) Employees feel their corporate culture will be negatively impacted D) It has become increasingly difficult to determine precisely where work ends and where an employee’s personal life begins 3 Which of the following describes an “outbound telesales agent?” A) Employees who phone other company employees at work to explain and offer their company’s services. B) Employees who visit customers at their home with the aim of selling the company’s services. C) Employees who phone customers at home with the aim of selling the company’s services. D) Employees who visit large corporations with the goal of selling the company’s services. 4 What type of liability implies that a party may be held responsible for injury or damage even thought it was not actively involved in the incident? A) Cyber B) Vicarious C) Associative D) Mutual 5 All of the following are invasive tools used to monitor employees at the workplace, except: A) keystroke loggers B) GPS micro-chips C) “smart” ID cards D) video surveillance 1 Which of the following companies have NOT been in hot water for relying on the assumption that “what works here works there?” A) E*Trade B) Coca-Cola C) Bacardi D) Pepsi 2 All of the following are arguments advocates use to promote the downside of globalization, except: A) developing countries are ravaged for their raw materials B) globalization brings unprecedented improvements in wealth and standards of living C) workers are exploited D) corporations are free to take full advantage of less-restrictive legal environments 3 In the pursuit of profit and expansion, MNCs have been guilty of all of the following, except: A) bribery B) pollution C) the promotion of human rights D) questionable product quality 4 All of the following are principles of the Global Compact under the area of environment, except: A) businesses should support a precautionary approach to environmental challenges B) businesses should undertake initiatives to promote greater environmental responsibility C) businesses should encourage the development and diffusion of environmentally friendly technologies D) businesses should work against all forms of corruption 5 The OECD guidelines promote principles and standards of behavior in the all of the following areas, except: A) finance B) human rights C) labor relations D) consumer protection 1 Which of the following is NOT a stage in creating a long-lasting ethical culture? A) Follow the competitors B) Establish a code of ethics C) Hire an ethics officer D) Promote your organizations commitment to ethical behavior 2 Which of the following is NOT a consideration in creating a code of ethics from scratch? A) Get endorsement from management from various levels B) Find a champion C) Pick a well-tested model D) Try it out first 3 According to the Ethics and Compliance Officers Association survey, which of the following did not rank in the top five as the main responsibilities of an ethics officer? A) Training design B) Organization-wide communications C) Oversight of hotline/guideline/internal reporting D) Conducting investigations of wrongdoing 4 All of the following are examples of rewards for successful behavior, except: A) awarding prizes for ethical behavior, which the employee chooses B) celebration of good ethical behavior in the company newsletter C) declaration an Ethics Day and allowing every department to share their success D) awarding prizes to any employee who finds unethical behavior within the organization 5 Which of the following terms describes the characteristic of public commitment to the highest level of professional standards and then sticking to that commitment? A) Organizational integrity B) Business ethics C) Utilitarianism D) Proactive ethics

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

International Business – Global Expansion

Overview

Blogs, LinkedIn articles, and other online publications are channels of communication through which people can share their experience, perspectives, and expertise directly with readers—and readers can respond via electronic comments. While these electronic channels are usually not as credible as scholarly publications, they are a great way for readers to learn about new topics and for writers to share their insight and expertise with a virtual audience. They are also often supported with references to case studies, reports, and other research.

In this assignment, you will share your knowledge of what globalization is and why organizations consider global expansion by writing an article intended for a virtual, professional audience.

Prompt

Create an article that could be shared online that defines key terms, explains fundamental concepts, and shares relevant examples as to why domestic businesses should consider expansion into global markets. The article should have a brief introduction that explains what readers will gain from the post, a body that provides content supported with textual evidence from the course resources, and a conclusion that summarizes key takeaways for the reader.

Specifically, you must address the following rubric criteria:

  • Types of Business Environments: Differentiate between domestic and international business environments by defining and providing key characteristics of each type, using supporting evidence.
  • Example Organizations: Identify examples of domestic and international organizations and explain how they meet the criteria for each type of organization, using supporting evidence.
  • Benefits of Expansion: Explain the key benefits of international and global expansion for domestic businesses, providing specific examples and using supporting evidence.
  • Ethical Considerations: Explain the role of ethics in making business decisions regarding expansion to a new market and how ethical decision-making frameworks can be used to help make these decisions. Use supporting evidence as appropriate.

Guidelines for Submission

Submit your article as a Word document between 350 and 500 words in length. Use APA formatting and cite your sources according to APA style.

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Case Study: GE Healthcare

Need a 4 page APA format paper based on the case study below. Need by 2/3/16 @13:00 EST

 

Read the case study titled “GE Healthcare (A): Innovating for Emerging Markets” located in the XanEdu case pack (Below)

 

Write a four (4) page paper in which you:

1.       Determine two (2) emerging trends in the external environment that prompted General Electric (GE) Healthcare to develop a new strategy for the production and marketing of a low cost Electroencephalography (EEG) machine in bottom of the pyramid markets (BOP).

2.       Examine two (2) internal barriers GE Healthcare faced when developing its BOP market in India and determine the manner in which they hindered GE Healthcare’s growth in this market segment.

3.       Analyze two (2) of the significant external barriers that GE Healthcare faced when trying to meet its marketing goals in the Indian market. Propose two (2) ways to address these barriers.

4.       Analyze the specific steps GE took in developing its strategy to grow its BOP market. Determine the manner in which those actions apply to the principles of strategic thinking and strategic planning.

5.       Determine the manner in which GE Healthcare’s strategy to improve its position in BOP markets contributed to the organization’s value chain in both emerging and developed markets.

Your assignment must follow these formatting requirements:

·         Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.

·         Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.

GE Healthcare

As of 2010, GE Healthcare was a $17 billion division of the $180 billion giant General Electric, employing over 46,000 people worldwide. It was created in 2004 after GE Medical Systems was merged with British bioscience/medical imaging firm Amersham and several healthcare IT firms as a part of CEO Jeffrey Immelt’s increased emphasis on R&D.2

GE Healthcare had a strong track record in selling high-end medical imaging and diagnostic products globally. It operated in India as Wipro GE Healthcare, a 51:49 joint venture with Wipro. Partnering with a leading Indian company had helped GE address the regulatory constraints and institutional complexities of operating in India as a foreign multinational.3

India as a Base for Global R&D

GE had four major sites for its R&D efforts: the U.S. (Niskayuna), India (Bangalore), China (Shanghai) and Europe (Munich). Additional research centres in Brazil (Sao Paulo) and the U.S. (Detroit) were also being considered. In locating R&D overseas its chief considerations were availability of talent and being close to important markets.

The John F. Welch Technology Centre (JFWTC) in Bangalore was GE’s largest R&D centre outside the U.S. Opened in 2000, the $175 million centre had grown to about 4,300 technologists (about 1,100 in Healthcare) by 2010.4 India was an attractive base not just for cost reasons but also for an ample supply of world-class talent and the presence of some well-known educational and research institutions in an otherwise relatively less developed country.

JFWTC carried out R&D for GE businesses in areas as diverse as healthcare, energy, aviation and transportation. Its traditional focus had been addressing the needs of developed market customers. However, there was now an increasing emphasis also on products tailored for emerging markets like India, including those developed specifically for particularly low-income customers (the so-called “bottom of the pyramid” or BOP).5

India as a Healthcare Market

As of 2010, India’s healthcare industry was worth about $30 billion and was expected to double in size in the next five years. Estimates put the medical devices market segment somewhere in the $3 billion to $6 billion range, with growth of between 10% and 15% a year.

Of the 700 domestic healthcare device makers in India, most only made low-value products such as needles and catheters. Of the few that did produce more sophisticated equipment, few could match international players in terms of quality or performance. Nevertheless, they typically had a significant cost advantage, which made them formidable competitors in mass markets where customers had limited purchasing power and were highly price sensitive.

High-quality specialist products came mainly from MNCs like GE, Siemens and Philips, with GE being the #1 provider of diagnostic equipment like ECG, MRI, CT and ultrasounds. Given the price points, however, most of the $400-500 million annual revenue of GE Healthcare in India had come from sales to large hospitals.6

GE Healthcare had recently launched a global $6 billion “Healthymagination” campaign, with stated goals of reducing the cost, increasing access and improving the quality of healthcare around the world. This included significant investment in solutions for BOP patients.7 In addition to providing growth opportunities and building new capabilities for emerging markets, this was expected to be good for GE’s corporate social responsibility (CSR) image.

GE Organization in India

In 2005, GE had set a revenue goal for India of $5 billion across all businesses by 2010. But it had actually realized less than $3 billion by 2010. Within the Healthcare division, India still accounted for less than 2% of revenues. Recognizing that this fell far short of potential, Immelt set an ambitious 30% annual growth target for GE India over the next five years in order for the Indian business to cross the $10 billion mark by 2015.8

A key barrier to GE’s growth in India had been its inability to fully tap into the mass market. Since sales from India comprised a tiny fraction of overall sales, the idiosyncratic needs of the Indian market did not get much attention in the highly centralized global organization. As a result, even R&D initiatives carried out in India had a tendency to gravitate towards meeting the needs of the relatively high-end segments that resembled GE’s developed market customers. A senior leader at GE Healthcare summarized the problem: “We were selling what we were making [rather than] making what the customers here needed.”9

To overcome the above challenges, GE introduced a new “in country, for country” strategy for India. This involved two key changes in the organizational structure. First, on the geographic dimension of the organizational matrix, India was now to be treated as an independent region (on a par with the U.S. and China). As a former GE Healthcare employee put it, “In our global meetings, India overnight went from getting only two slides in the GE International presentation to getting a whole presentation on its own.”

The second organizational change was that GE India was the first country to be made a profit and loss centre on its own. The Indian business heads were to now report primarily to the country CEO, with only a dotted-line link to the global business heads. Immelt said: “We will treat GE India just as we would any other GE business with its own growth strategy, leadership development and budgeting processes.” Managing the entire local value chain from India itself was expected to improve local adaptation and speed up decision-making. 10

The 39-year old T.P. Chopra – an Indian who had been the country CEO in the old organization – was replaced by John Flannery, a senior vice-president from GE’s global leadership team. With the new CEO being well-connected with GE’s global business heads, it was hoped that decentralization of decision-making would not compromise on global integration of strategy and knowledge exchange would still take place across boundaries.

Rather than making development of “value-for-money” products targeting low-income markets also a responsibility for existing R&D teams, GE set up new product teams specifically for developing and commercializing such solutions. The local boost for R&D was complemented by enhanced efforts in local marketing, sourcing, manufacturing and service. Aggressive growth targets were set for adapting better to the Indian market, while also cutting costs drastically and achieving speedier decision-making through decentralization.11

A New ECG Device for India?

GE’s Healthcare division was an early adopter of the new “in India, for India” approach, with several new initiatives in this spirit having been started even before the new organization was fully in place, as was illustrated by GE’s efforts to develop inexpensive electrocardiogram (ECG) products specifically with the Indian market in mind.

A major cause of death in India is heart disease, making ECG testing of tremendous value in early detection. But as mainstream ECG machines (such as the MAC 5500 machine shown in Exhibit 1, priced at over $10,000) were designed to meet the needs and budgets of large modern hospitals, they only skimmed the top of the Indian market.

With per capita income just over $1,000 per annum, few Indians could afford expensive testing using high-end machines. However, affordability was not the only issue. People living in small towns and rural areas lacked easy access to hospitals. Simply producing stripped-down versions of GE’s existing products would therefore not suffice. There were unique challenges of the BOP to bear in mind.

The MAC 400 ECG

GE management assigned the task of designing an ECG solution for India to the JFWTC. Using local R&D turned out to have three benefits. First, the team had a better knowledge of Indian customers. Second, it had greater awareness of off-the-shelf components available locally. Third, development costs were much lower than for an equivalent project in the U.S.

An ECG device targeting the BOP – called the MAC 400 (see Exhibit 2) – was developed in just 22 months, with development costs of about $500,000. (A similar global product development effort could have taken twice as long and cost several million dollars.) The device was small enough to fit in a backpack. At 1.3kgs it was much lighter than conventional models, which often weighed over 7kgs. It had rechargeable batteries that could be charged in three hours and allowed over 100 ECGs, or a week of operation, between charges.

The expensive printer typical of classic ECG machines was replaced by a small printing gadget adapted from a model used for portable ticket machines. The traditional 12-channel printer output in high-end ECGs was replaced by a three-channel output in the MAC 400. The full-scale keyboard was replaced by just four buttons, and the large graphical colour display by a small text-only display used for set-up. The machine had a simple one-touch operation, with embedded software interpreting the ECG data to print out a simple easy-to-read intuitive report. This eliminated the need for a cardiologist to tell whether a patient had a heart condition and needed to see a specialist.

Importantly, the relentless focus on eliminating non-core features found in high-end ECG machines (such as on-screen display, advanced analysis, full network connectivity and interoperability, barcode and magnetic card scanning, data storage and export, security, etc.) did not mean that the development team compromised on the core functionality. Employing the industry-standard Marquette 12SL algorithm that all GE’s ECG machines used, the analysis performed by the MAC 400 was as reliable as that of a full-scale ECG device.12

The MAC 400 was priced around $1,000, a third of the price of medium-sized conventional devices and under a tenth of many full-size models.13 The effective cost of a single electrocardiogram turned out to be less than $1, which was considered low enough for widespread adoption. Although the margins in selling MAC 400 were smaller than those on high-end equipment, GE hoped that the sales volume would justify the product nevertheless.

Some cost reductions naturally resulted from making a smaller size device with limited features, but savings also resulted from the creative use of standard parts available locally. Instead of using a customized processing chip, the R&D team came up with a clever solution relying upon a commercial chip that cost only a quarter of the price. Similarly, rather than developing a customized printer the team adapted one widely used in bus terminal kiosks.

As the MAC 400 was being developed, the local R&D team had access to all of GE’s accumulated knowledge. For example, by borrowing a process originating elsewhere for building fast plastic-mould prototypes, the team was able to avoid costly changes later by getting early feedback from doctors. Similarly, it was able to take GE’s past experience in developing printers for dusty conditions and fine-tune the printer’s suitability for ECG.

Describing the full potential of ultra-portable ECG devices like the MAC 400, a senior official at the JFWTC said, “It will become the stethoscope of cardiologists.”14 According to another official, “The dream would be to sell at least one device to each GP (general practitioner).”15

For cost-effective distribution, GE hoped to rely not just upon the network from its JV with Wipro but also to explore novel partnerships with pharmaceutical companies, surgical companies and large pharmacies. To educate potential customers it conducted courses on the technical aspects of using an ECG device as well as making the business case for investing in one. To help potential buyers overcome financing constraints, it tied up with State Bank of India, whose extensive rural network was used to arrange no-interest loans for buyers.

At the time when the MAC 400 project was initiated, GE had limited market research and distribution channels in place for the new customers it was trying to reach. Therefore, rather than evaluating the project purely on a financial basis, the company viewed it also as an experiment into the BOP opportunity more broadly and as a way to build resources and capabilities for the future. Other product categories where GE Healthcare was similarly trying to tap into low-income markets included baby warmers, X-ray and ultrasound systems.

As an experiment, the MAC 400 turned out to be a success not only in India but also in numerous countries worldwide where it was in fact often sold at higher price points. Even commercially, MAC 400 became a reasonable success by generating $20 million in revenues within the first two years. This was still a small fraction of the revenues for GE Healthcare as a whole, no surprise given that it was an early foray for GE into an unfamiliar market and that the entire ECG category anyway was a small part of the overall healthcare portfolio.

While GE’s long-term vision was to use products like the MAC 400 to create new markets, practical constraints in terms of channels meant that a significant fraction of the initial sales actually took place within the traditional customer segments. It became clear that realizing the full potential of the BOP opportunity would depend not just on having the right product but also continuing to build appropriate sales, distribution and service networks. Also, a truly mass-market product would have to be even cheaper than the MAC 400 in order to compete against current and future offerings from low-cost Indian manufacturers like BPL Healthcare.

Relying upon the MAC 400 experience and extensive market research, GE subsequently came up with a cheaper ECG device, the MAC i (“i” standing for India), that weighed less than 1kg, used a single-channel printer output and eliminated even PC connectivity. Launched in November 2009, it was priced at just $500. Like its predecessor, MAC i was manufactured locally using local components, while continuing to use reliability, user friendliness and interpretation software as differentiating elements.16Early market indications were that MAC i would do quite well commercially.

The MAC 800 ECG

While the MAC 400 was being developed in India, GE’s R&D personnel in China built upon the idea to develop another portable ECG – the MAC 800 (see Exhibit 3). The new product targeted not only remote locations but also the typical clinics and hospitals in China.

Weighing 3kg, the MAC 800 was larger than the MAC 400, though still much smaller than GE’s high-end ECG machines. Recognizing China’s familiarity with SMS-texting, it incorporated a telephone-style keypad to allow users to input data. It included a full-size colour display (with multiple language options) based on an intuitive Windows-based platform, offering a preview of ECG results. It also allowed ECG data to be stored and sent.

The product design, the pricing strategy and the channels GE Healthcare relied upon to distribute MAC 800 exploited the fact that higher local income levels as well as greater involvement of the government in healthcare standard-setting and purchasing decisions led to lower price sensitivity in China than in India and opened up a different kind of opportunity.

Costing around $2,500, the MAC 800 was over twice as expensive as the MAC 400, but still less than one third of GE’s high-end ECGs.17 Early indications were that it was selling well, exceeding 20,000 installations in more than 50 countries as of 2010.18

“Reverse Innovation”

In an interesting development, GE started selling the MAC 800 even in developed markets. While it held a 34% share of the U.S. mainstream ECG market, GE saw an opportunity to use the MAC 800 to expand the ultrasound market to include primary care doctors, rural clinics, emergency rooms and accident sites.19 Market studies revealed that U.S. physicians found the device user-friendly, and considered its SMS texting-style keypad acceptable.20 The U.S. market was found to have greater connectivity requirements than those offered by the Chinese prototype, but GE was able to address that through adaptations like USB and Ethernet ports.

For a company that primarily sold products developed for developed economies in emerging markets, this exemplified a reversal in the direction in which innovation flowed. The phenomenon was labelled “reverse innovation” by Immelt, who considered such an approach critical to the very survival of Western multinational fighting the threat of emerging market companies going global with their own disruptive business models. 21

The Right Global Strategy?

Although GE earned favourable press coverage and several awards for its innovative BOP products, it was too early to declare its BOP initiatives a big commercial success because the revenues generated were still small by GE standards, margins were thinner than GE was used to, and the competition was starting to heat up.

Sceptics wondered whether GE really had a sound long-term strategy, especially as the competitive advantage in serving BOP markets was unclear. Past successes had come from delivering standardized products globally, relying upon scale to drive down costs and tight organization to ensure control. For the company to move towards an “in country, for country” approach for specific countries seemed far from the obvious direction to take.

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"