Loops And Arrays In Excel Vba 2 Harvard Case Study Help

Home >> Hrm >> Loops And Arrays In Excel Vba 2

Loops And Arrays In Excel Vba 2 Case Study Solution & Analysis


Loops And Arrays In Excel Vba 2 Case Study Analysis is a popular global brand in technology market, founded in 1938 by Lee Byung Chul, in South Korea. Loops And Arrays In Excel Vba 2 deals in large number of product categories consisting of Semiconductors, Telecom, Digital Media, Digital Appliances and many more other electronic items. Historically, the company's core customers include the Original Equipment Manufacturers (OEMs), which utilized to offer Corp items withtheir own trademark name. Till early 1990s, the core proficiency of Organization lie in its low rate offerings than its rivals by producing existing products at economies of scale. Its client circle includes Original Devices Manufacturers (OEMs), who used to sell Loops And Arrays In Excel Vba 2 Case Study Help items with their own brand. Organization was not simply known outside Korea. There were also no or little interest in building the brand internationally. Marketing budget plan was managed by production department with a prime focus on offering low-cost products.During the 1997 Asian Financial Crisis the business almost got insolvent, but with the Vision of Chairman Lee it totally turn its fortune around and in 2002 was noted the leading 25 most valuable business on the planet. When Kim was employed as a Chief Marketing Officer in 2000 the business was not even listed. He rearranged Business as a global brand name and educated his divisional supervisors to understand marketing and its significance. Now their objective is to arrive 10 by 2005.

Problem Statement

Venture's transition from a product based to a marketing business is not going as smoothly as planned.Overcoming the reluctance of divisional supervisors to include marketing efficiently is still a major difficulty. Creating a consistent brand identity across the whole world and using marketing methods that best fits the local culture is no easy task. The M-net program analysis have been really helpful in determining the high and less prospective growth areas, however allotment of resources appropriately is not well received among the supervisors. There is no agreement among the hierarchy concerning the best suited future method.
Executive Summary
Situational Analysis

Yun had a quite clear image in his mind about how Loops And Arrays In Excel Vba 2 Case Study Analysis can transform from a low end to a high end product service provider. He understood that improvement can only be done through positioning Corp as a company providing high-end products and this might just be done through high level of marketing.

In spite of having a clear vision about how to build Business brand, with a possible support of its executives, Yun faced numerous marketing challenges in early years of its efforts.

Among the marketing difficulties for Yun was the perceptions of executives about the worth of marketing. They thought about marketing and selling as exact same tools and thought that quality products do not required marketing for increasing sales. As their focus towards marketing was rather low in their previous service practices, and the existing marketing requirement was excessive high, the space was too broader and to fill this space with incorrect perceptions about marketing was quite tough for Yun.

As stated above, marketing focus was really low in previous practices, therefore there were no correct marketing budgets for each of the product on the portfolio. There was no marketing planning provided for the existing items. Together with it the product series of the company was increasing with the ripening of new item ideas by the R&D sector of Business. Yun had a difficulty to perform marketing preparation and to create marketing budgets for existing along with for brand-new products from the very start, and this would take a huge time.

A substantial shift would be required in present marketing expenses to develop the Loops And Arrays In Excel Vba 2 Case Study Solution brand. This would lead to increased marketing expenses for Corp and might interrupt the administration relating to increased expenditures, as they hesitated to marketing expenses previously and a sudden big shiftwould make them disrupt. This could lead to declining executive support for international marketing. In this scenario, Yun deals with an obstacle for justifying increased marketing costs by demonstrating the long term value of big marketing expenses.

Internal Analysis
SWOT Analysis

Corporation strengths lie in its big product portfolio. Business has largest number of patents in the market with total variety of 15499 patents granted in US( USP). Big amount of R&D costs has actually enabled the business to grow its product portfolio at a higher rate than its rivals. Loops And Arrays In Excel Vba 2 Case Study Help spent about $13.079 billion on its R&D sector in 2016, which is 7.3% of its overall incomes.

Another strength of Loops And Arrays In Excel Vba 2 Case Study Analysis is its capability to establish ingenious products at a continuous rate. It significant proves for the innovation and item creating of Corporation is that the business has actually received many awards for its development and product design.

Unlike Apple and other rivals, Business is concentrated on producing devices which can be quickly integrated with any type of open source Operating System (OS) and software. This provides Corp an edge over Apple devices.
Porter's 5 Forces Analysis
Corp's capability to produce luxury items at low expense of production is also one of the major strength of Org as it makes it possible for the company to catch more market by offering quality products with cost control.


Enterprise's weaknesses are hidden in the company's dependence on outsourcing software application for its gadgets due to business's inability in establishing software application, unlike Sony. Loops And Arrays In Excel Vba 2 Case Study Help also has low revenue margins as compare to Apple due to huge distinction in the costs of Apple and Company with a much lower difference in quality.


Opportunities for Venture lie in the growing Smartphone market and the business's efficiency in the market. It can increase its market share and earnings from cellular phone as the company is quite effective in smart phone market. Corp currently runs in about 80 countries and the business has a chance to increase its geographical expansion by moving towards more emerging markets outside Asia. Enterprise can move towards acquisitions to obtain patents. It would make it possible for the business to increase its item portfolio with an increase in its wealth.


The vibrant market environment of innovation market position a serious danger on Organization's survival and require the business to spend much of its revenues share on R&D in order to survive in the long run. The marketplace saturation in industrialized nations i.e. saturation of mobile company is also a huge hazard for the business's development in the existence of strong competitors like Apple.

4 P's of Marketing
Swot Analysis

Venture offers quality products and has a rather rich portfolio which caters to various segments. LCD and mobile phones are the biggest items of Corp, whereas DRAM is likewise not far behind in comparison of them.

• Laptops.
• Cellphone.
• Air conditioner.
• Desktop computer.
• Hard disks.
• Washing machines.
• Refrigerators.
• Video cameras.
• Microwaves.
• Flash memory.


Loops And Arrays In Excel Vba 2 Case Study Solution utilizes both market competitive and market skimming prices methods for its variety of products. In competitive rates it adjusts the price according to the competitors in order to gain advantage, whereas, it uses market skimming technique where the product has actually an added worth and by selling a few items it can reach break-even.


It has one of the best supply chain networks, with retail suppliers, their own sole suppliers, E commerce channels like Amazon and so on. All its products are timely provided to the selling location/ delivered to the consumers directly in case of online order.

Vrio Analysis
It wasn't a widely known company outside of Korea until 1993. However the management effort taken by their CEO has actually pushed them to market more efficiently outside the borders and now it has gone into the league of top 25 business in the world in simply 9 years. This is a remarkable accomplishment in spite of the continuous arguments amongst the supervisors about embracing marketing practices. It utilizes both offline & online channels of promo to market their items. Paid product ads, social promotion and digital ads are uses to produce awareness about Organization products.

Worth Chain Analysis.

It's an analytical framework for recognizing business activities that include worth or competitive benefit for the company.

Inbound Logistics.

It has among the most reliable and effective supply chain network and has over 2700 suppliers throughout various markets around the globe. Nearly 80% of which is based in Asia and the remaining around the globe. For its incoming logistics it owns various logistics firms as it subsidiaries. It takes care of its suppliers and develops a harmonious relationship with them and even decreased their payment cycles to boost this relationship even more which adds value to their chain network.


Enterprise's core proficiency is its mass producing it produces 90% of its items internal. Divided into three various divisions its operations are particularly IT & Mobile Communications, Gadget Solutions and Consumer Electronic Devices. It is preserving operation hubs worldwide to further include worth to its worth chain network.

Outbound Logistics.

Its outgoing logistics system efficiency is among the main factors Loops And Arrays In Excel Vba 2 Case Study Solution has the ability to take on Apple. Venture's own Electronic Logitec system plays a significant function in the outbound logistics operations. It even performs the tasks of collection of payment, settling insurance claims, etc. on behalf of Organization.

Marketing and Sales.

Attracting target customer attention towards the product is done through marketing and sales to communicate with them the value and competitive advantage the item provides. Loops And Arrays In Excel Vba 2 Case Study Help advertising budget is constantly on the rise given that they started their rearranging worldwide and will continue to do so as they are constantly looking to broaden and invest in high possible development markets. The budget is spent on occasions, print and media ads, public relations etc.

Venture Service. Business put their customers on top and continually make every effort to provide unmatchable client service requirements. As after sales service is ending up being incredibly essential to keep consumers delighted and engaged, they even conduct studies through 3rd parties to discover their consumer's feedback and implement it in the positive way to decrease or if possible totally remove their consumer concerns. By adding a direct assistance line to call them 24 hr they have actually even more increased the included worth of Loops And Arrays In Excel Vba 2 Case Study Solution service.


Loops And Arrays In Excel Vba 2 Case Study Analysis has diversified market segmentation, based upon its provision of large range of products to a great deal of customers. Org target client segments can be divided into 3 categories i.e. Loops And Arrays In Excel Vba 2 Case Study Analysis IT and Mobile Communications, Org Customer Electronics and Corporation Gadget solutions.


Loops And Arrays In Excel Vba 2 Case Study Analysis geographical division is based upon two criteria i.e. region and density. Business serves about 80 countries worldwide with its items offered to Urban as well as Rural areas of the country. The Enterprise is likewise growing its international existence and the company's flexibility in finding its plants motivates global expansion of Venture.


Organization produces items that can be used by both females and males. The target consumers for Corp IT and mobile communication products have an age range of 18-65 with majority at a young or newly wed life cycle stage. Apart from it, Organization Consumer Electronics are targeted to a consumer segment with an age variety of 25-65.


The psychographic segmentation of Loops And Arrays In Excel Vba 2 Case Study Solution s based upon the social class and the lifestyle of the consumer. Corporation target clients on the basis of social class are mainly upper middle, middle and working class customers, as Org sell items like cellular phone very little more affordable i.e. Motorola as well as not much pricey i.e. Apple. It offers quality products to middle level customers at a slightly high price than others targeting the same section.


Loops And Arrays In Excel Vba 2 Case Study Help bulk target customers have distinct behavioural attributes. They are attracted towards Business since of its moderate rates with an extent of quality.

Quantitative analysis.

Sales of Org has increased remarkably from 16 billion $ in 1997 to 44.6 billion $ in 2002, and the net revenue of.48 billion $ to 5.9 billion $. It has actually also minimized its financial obligation from 15 billion $ to 4.6 billion $. Digital media is the largest selling category of Organization with sales of 13.9 billion $, whereas, Telecommunication and Semiconductors sectors both reached 11 billion $ in sales. Incomes/ sales are increasing but net revenue is not increasing accordingly due to the fact that of the high overhead cost. New growths and employing's were the main factor of the boost in the overhead expenses, with china currently not supplying any revenue to Corp, but there is a lot capacity in the current market with 75 % yet to be checked out.

Qualitative analysis.

Yes, this choice is based upon the objective of Kim to target the more youthful audience and develop an international brand image of the business. Whereas, the core strength of the business is presently manufacturing however long gone are those days when excellent products were selling themselves. In the present age marketing is very important and business can not succeed without it. Kim has actually already started to strengthen the marketing activities of Organization and very soon it will turn into one of its core strength like producing if not better.



Venture operates designs, produces and sell a huge portfolio of customer electronics. It runs in an extremely competitive environment and has actually effectively positioned itself as the maker of quality products. So, the answer is yes.


As, said earlier that Loops And Arrays In Excel Vba 2 Case Study Solution runs in a highly competitive environment, which suggests all the companies have similar items. So, the response for rarity is no.


Due to the nature of the industry, it is really simple for rivals to understand the performance of the products and quickly make their own designs. Yes, Company is only behind IBM in signing up new patents annually, but the advantage is really short term in this market.


Chairman Lee has entirely turn-around Org, from going practically bankrupt during the Asian financial crisis of 1997 to the leading 25 company in the world. Definitely yes there is proper company in the company and the outcomes speak for themselves.

External Environmental Analysis

PESTLE Analysis


Being an international brand spread almost in every country worldwide, majority of the environments like USA, Europe, China etc., are really conductive for its operations. It deals with some political pressures in less industrialized nations where law and order scenario is not excellent. Latin American, African and some Asian nations fall in this category, where political instability do have an effect on Loops And Arrays In Excel Vba 2 Case Study Analysis operations.


Buying power of customers is essential for companies like Org to be successful and grow. Emerging markets like India, middle-eastern countries and so on supply development chances, whereas, due to recession even the customers of developed nations suffer terribly. Thus it is very important for the business to keep an eye on the continuous economic circumstance of the nation before getting in the market.


International companies have to face numerous social and cultural concerns throughout its operations in a foreign nation. Corp has actually likewise faced lots of concerns but have actually embraced to the regional environments of most of the countries exceptionally well. It has actually customized its products, practices, policies etc. accordingly in order to achieve success.


With a yearly expense of 2.4 billion dollars in Research study & Advancement, and with continuous ingenious product launches, Loops And Arrays In Excel Vba 2 Case Study Solution is one of the top innovative companies of the world. With a clear objective to be ahead of the rest when it comes to technological improvements, Enterprise has increased to the no 25 of the top successful companies of the world.


Each nation has their own laws and policies, being a multinational business Corp need to strictly follow those laws in their jurisdictions. Failure to do so, will result in serious legal consequences. It has to study or employ a regional law expert prior to starting its operations in a particular nation.


With the increasing awareness amongst consumers about the ethical & environmental infractions of business, Org needs to make sure that it follows all the security standards. Ecological damages, ethical misconducts are not acceptable and in some countries the effects can be extremely severe. On the other hand it needs to do some Corporate Social Obligation practices to show the locals that it cares about their environment and people.

Porter's 5 Forces

Hazard of Replacement

Hazard of substitution for Venture's each item classification is quite significant. Aspects for high hazard of replacement for Loops And Arrays In Excel Vba 2 Case Study Help Smart device consist of the existence of high number of suppliers and Market saturation in developed nations, which make the cost of changing for consumers nearly no. Along with it, Organization printing options items are threatened by the increasing attraction of clients towards cloud storage.

Competition Among Existing Firms:

The rivaly amongst Business and its close competitors is intense. The major factor behind this is the technique of market saturation in different number of item categories, forcing Organization to present more innovative functions in existing products and brand-new innovative products to preserve its growth. The significant competitors for Loops And Arrays In Excel Vba 2 Case Study Help samrtphones include Apple, Motorola, LG, Nokia, Huawei, OPPO etc.

( Corporation Sustainability Report, 2016) Supplier's bargaining power for Org is low as Company runs economies of scale and its orders are of prospective size and worth. Due to incapability of Loops And Arrays In Excel Vba 2 Case Study Analysis to build its own software, it has to outsource its software development to Google, which ends up being a prospective supplier of software application for Business, resulting in high bargaining power of Google.

Bargaining Power of Purchasers:

Market saturation in many of the product classifications likewise make the bargaining power of purchasers more intense in for Organization. In spite of igh bargaining power Venture is rather capable of offering its items at a greater cost than much of its competitors, due to high end quality item and a fair brand image.

Threat of New Entrants:

Threat of new entrants for Corp is quite low. Among the major element for low hazard of new entrants is the high competitors in the market. The requirement of huge quantity of capital to enter in the market is likewise one of the prospective barrier to entry. Along with it, requirement of big knowledge and research study and development expenses for survival in the industry likewise make new entrants hesitant to go into in the market. Market saturation is likewise among the barrier of entry in technology market. High bargaining power of providers require the gamers in the market to charge as low prices as possible and this can only be accomplished by production performance. Brand-new firms, in bulk cases, lack the production performance, hence increasing the threats for entrance in the technology industry.

Competitive Analysis

Corporation's high product diversity provides it distinction from its competitors. Unlikely to its close competitors consisting of Sony, Intel and Nokia, who focus majority on a single product classification with Sony focusing on consumer electronics, Nokia on cell phones and Intel on chips, Loops And Arrays In Excel Vba 2 Case Study Help had a big R&D costs on all of its product classifications which make it possible for the company to make potential profits from sales of nearly all of its items.

The business ranks first in 4 item classifications i.e. DRAM Chips, LCD Displays, Cinema Televisions and Microwave, in regards to international market share, amongst 8 various item categories. Company was the international leader in producing DRAM, SRAM and NAND flash chips. Corporation revenues from chips was less than Intel but its profits from chips was growing much faster than Intel and has grown close to the earnings levels of Intel, as provided in the case Exhibit 2.

Together with the chips Enterprise mobile market was likewise thriving at a high rate than its rivals i.e. Motorola and Nokia. Enterprise's cellular phone's sales development was 51% as compare to Motorola with just 4% and Nokia with absolutely no sales growth. The significant reson behind Corporation's high development despite of higher rates than Nokia and Motorola was the business's high-end quality mobile phone.

Company was likewise profiting from increasing market share of high end LCDs as given in case Exhibit 3. The significant reason, making the business allow to obtain the chance is its mass production at low expense. Sony was the most significant competitor for Loops And Arrays In Excel Vba 2 Case Study Analysis in LCD market, nevertheless, it had likewise begun joint endeavor with Corporation in 2003 for LCD producing, decreasing the competitors for Business.

Porter's Competitive Technique

Low Cost Leadership method of porter is fully implemented by Organization the way they achieve economies of scale by strengthening their core competencies of production. They always bring something new and ingenious whether it's a service or a product.


Alternative Solution 1

The Chief Marketing Officer (CMO) of Loops And Arrays In Excel Vba 2 Case Study Analysis would produce a new brand name image by targeting the younger generation of the particular country. As, especially smart phones of Corporation are incredibly popular amongst the younger demographic.


1. It is the very best method to develop Client Life time Worth (CLV) by creating a long-term relationship with consumers. Build loyalty through providing value and reap the benefits for long-lasting, as research has revealed it is more affordable to maintain current consumers than to attract brand-new ones.
2. Another pro of this alternative is that word of mouth spread more quickly amongst more youthful people and which in turn will bring in new consumers for my products.


1. Old customers who were connected with Corporation prior to might not like this new image the business is attempting to depict.
2 It will incur more expenses to rearrange some products and it might not even bring success as the patterns change extremely rapidly among the younger group.

Alternative solution 2.

Corporation has actually made making its core competency for the many part of their company and due to which its supervisors are not afraid to fully step out of their comfort zone. It would be done by organizing training workshops throughout which significance of marketing will be taught and numbers will be given. Failure to get the passing ratings will get benched. Marketing environment should be created internally initially as real marketing begins inside the corporation.


1. Its pro will be that all the marketing approach supporters will come out and likewise the opposite ones.


2. Its con can create a very unhealthy environment in the workplace, as individuals often withstand modification because they fear it.

Determine the very best alternative

First alternative is the very best as it plainly has more pros since when a Customer Lifetime Worth is built the business will make money from it till that customer lives and has purchasing power also. Plus, our target consumers are the more youthful generation which are bound to live longer than the existing aging people. Corporation's primary objective is to create commitment amongst its consumers and make them bought it from them and even buy their different products.

Execution Plan

• Targeting younger generation through social marketing, producing a relate to them like Pepsi do with music. And set the expectations sensible and attainable.
• A team consisting of best marketing and sales specialists ought to be put together, and both views ought to be taken into consideration prior to securing the resources required to implement the plan.
• Thorough interaction of the strategy need to be done as it is extremely crucial for everybody to be on the exact same page to make it work.
• Tasks and timelines must be build and interacted accordingly to each individual accountable.
• The manager need to use a control panel which reveals the development of all the jobs which have been done or about to be done and by whom.
• The manager should keep track of and keep a consistent examine the specific and overall efficiency.
Because any new trend or policy may come in due to which all the things currently planned have actually to be adjusted, • Everyone should be willing to adapt midway. It's better to have contingency plans currently prepared.
• At the end of the campaign the supervisor should communicate the results and if successful must commemorate with the team.

Budget plan

The M-net program exposed compelling analysis about the low and high development prospective locations and how much marketing spending plan must be designated accordingly. This change the spending plan allotment of many supervisors and different nations were dissatisfied and argued but the analysis done by the program was precise and showed figures like The United States and Canada and Russia development possible warranted a 35% allowance while they were getting 45%. Whereas, China and Europe should be getting 42% however were rather given 31%. It really assisted to relatively disperse the resources and record more clients by spending more on advertisements on the high growth capacity regions of the world.

Its constant financial investment in R&D and innovative practices have actually propelled them to brand-new heights but for them its' just the start and they want to be among the top 3 brand names in the world. Their marketing efforts need to be directed towards younger demographic amid the internal arguments about marketing and should develop Customer Lifetime Worth as it will not only give them benefits now but will continue to enjoy it till the customer lifetime. As the expense of keeping the customer is much cheaper than drawing in a brand-new one.