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


Historically, the company's core consumers include the Original Equipment Manufacturers (OEMs), which used to sell Loops And Arrays In Excel Vba 2 Case Study Analysis items withtheir own brand name. Its client circle consists of Original Devices Manufacturers (OEMs), who used to sell Corporation items with their own brand name. He rearranged Org as a worldwide brand name and educated his divisional managers to understand marketing and its significance.

Issue Statement

Company's transition from an item based to a marketing business is not going as smoothly as planned.Overcoming the unwillingness of divisional managers to integrate marketing effectively is still a major obstacle. Creating a constant brand identity throughout the whole world and using marketing strategies that best fits the local culture is no easy job.
Executive Summary
Situational Analysis

Yun had a quite clear image in his mind about how Loops And Arrays In Excel Vba 2 Case Study Help can change from a low end to a high end product supplier. He knew that transformation can only be done through placing Organization as a business offering high-end products and this could only be done through high level of marketing.

In spite of having a clear vision about how to develop Corp brand name, with a prospective support of its executives, Yun faced several marketing challenges in early years of its efforts.

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

As stated above, marketing focus was really low in previous practices, for that reason there were no appropriate marketing budgets for each of the product on the portfolio. There was no marketing planning done for the existing products. Along with it the item variety of the company was increasing with the ripening of brand-new product concepts by the R&D sector of Business. Yun had a challenge to perform marketing preparation and to produce marketing spending plans for existing in addition to for brand-new products from the very beginning, and this would take a huge time.

A huge shift would be needed in current marketing expenditures to develop the Loops And Arrays In Excel Vba 2 Case Study Solution brand name. This would result in increased marketing expenditures for Company and could interrupt the administration regarding increased expenses, as they hesitated to marketing expenditures formerly and an unexpected big shiftwould make them disrupt. This might lead to decreasing executive support for worldwide marketing. In this situation, Yun faces a challenge for justifying increased marketing costs by demonstrating the long term value of huge marketing expenditures.

Internal Analysis
SWOT Analysis

Corp strengths lie in its big product portfolio. Org has biggest variety of patents in the industry with overall number of 15499 patents granted in United States( USP). Large quantity of R&D costs has actually made it possible for the business to grow its item portfolio at a greater rate than its rivals. Loops And Arrays In Excel Vba 2 Case Study Solution spent about $13.079 billion on its R&D sector in 2016, which is 7.3% of its overall earnings.

Another strength of Loops And Arrays In Excel Vba 2 Case Study Help is its capability to establish innovative items at a constant rate. It significant proves for the development and product designing of Corp is that the company has received many awards for its innovation and product design.

Unlike Apple and other competitors, Enterprise is focused on producing devices which can be quickly integrated with any type of open source Operating System (OS) and software. This offers Org an edge over Apple gadgets.
Porter's 5 Forces Analysis
Business's capability to produce high-end products at low cost of production is also among the significant strength of Organization as it makes it possible for the business to record more market by providing quality products with expense control.

Weak points

Corporation's weaknesses are concealed in the business's dependence on outsourcing software for its gadgets due to company's inability in developing software application, unlike Sony. Loops And Arrays In Excel Vba 2 Case Study Analysis likewise has low profit margins as compare to Apple due to substantial distinction in the prices of Apple and Company with a much lower distinction in quality.


Opportunities for Loops And Arrays In Excel Vba 2 Case Study Analysis lie in the growing Mobile phone market and the business's performance in the market. Venture currently runs in about 80 countries and the business has an opportunity to increase its geographical expansion by moving towards more emerging markets outside Asia.


The vibrant market environment of technology market posture a severe danger on Corp's survival and require the business to spend much of its profits share on R&D in order to survive in the long run. The market saturation in industrialized nations i.e. saturation of mobile business is also a huge danger for the company's development in the existence of strong competitors like Apple.

4 P's of Marketing
Swot Analysis

Loops And Arrays In Excel Vba 2 Case Study Solution uses quality products and has a rather abundant portfolio which deals with various sectors. Most of the products are in the top 3 of their respective industries. LCD and cellphones are the greatest items of Corp, whereas DRAM is also not far behind in contrast of them. Following is the product line of Business:

• Laptops.
• Cellphone.
• A/c.
• Computer.
• Hard drives.
• Washing machines.
• Refrigerators.
• Electronic cameras.
• Microwaves.
• Flash memory.


Loops And Arrays In Excel Vba 2 Case Study Help utilizes both market competitive and market skimming prices methods for its wide array of products. In competitive prices it changes the cost according to the competition in order to gain benefit, whereas, it utilizes market skimming strategy where the item has an included value and by offering a few items it can reach break-even.


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

Vrio Analysis
It uses both offline & online channels of promotion to market their products. Paid product ads, social promotion and digital ads are utilizes to develop awareness about Business items.

Value Chain Analysis.

It's an analytical structure for determining company activities that include worth or competitive advantage for the business.

Inbound Logistics.

It has one of the most efficient and reliable supply chain network and has over 2700 suppliers across various industries around the world. Nearly 80% of which is based in Asia and the remaining all over the world. For its incoming logistics it owns various logistics firms as it subsidiaries. It cares for its suppliers and creates an unified relationship with them and even lowered their payment cycles to enhance this relationship even more which adds value to their chain network.


Corporation's core competency is its mass manufacturing it produces 90% of its items internal. Divided into three various departments its operations are namely IT & Mobile Communications, Device Solutions and Customer Electronic Devices. It is keeping operation centers worldwide to further include value to its value chain network.

Outbound Logistics.

Its outbound logistics system performance is one of the primary factors Loops And Arrays In Excel Vba 2 Case Study Analysis is able to compete with Apple. Org's own Electronic Logitec system plays a significant function in the outgoing logistics operations. It even performs the jobs of collection of payment, settling insurance coverage claims, etc. on behalf of Corporation.

Marketing and Sales.

Drawing in target customer attention towards the item is done through marketing and sales to interact with them the value and competitive advantage the product offers. Loops And Arrays In Excel Vba 2 Case Study Help marketing budget plan is constantly rising given that they began their rearranging globally and will continue to do so as they are continually seeking to invest and broaden in high prospective growth markets. The budget is invested in events, print and media advertisements, public relations etc.

Venture Service. Organization put their consumers on top and continuously strive to deliver unmatchable customer support requirements. As after sales service is ending up being extremely crucial to keep consumers pleased and engaged, they even conduct surveys through third parties to find out their consumer's feedback and implement it in the favorable method to decrease or if possible totally eliminate their client problems. By adding a direct assistance line to call them 24 hours they have actually further increased the added worth of Loops And Arrays In Excel Vba 2 Case Study Help service.


Loops And Arrays In Excel Vba 2 Case Study Analysis has actually diversified market division, based upon its provision of vast array of products to a great deal of customers. Business target consumer sectors can be divided into 3 categories i.e. Loops And Arrays In Excel Vba 2 Case Study Solution IT and Mobile Communications, Company Consumer Electronic Devices and Corp Gadget options.


Loops And Arrays In Excel Vba 2 Case Study Solution geographic segmentation is based upon two criteria i.e. area and density. Corporation serves about 80 nations worldwide with its products offered to Urban as well as Backwoods of the nation. The Corp is likewise growing its worldwide presence and the business's versatility in finding its plants encourages international expansion of Business.


Corporation produces items that can be used by both males and females. The target consumers for Business IT and mobile communication items have an age range of 18-65 with majority at a young or newly married life cycle phase. Apart from it, Venture Consumer Electronic devices are targeted to a client sector with an age variety of 25-65.


The psychographic division of Loops And Arrays In Excel Vba 2 Case Study Analysis s based upon the social class and the life style of the customer. Corporation target consumers on the basis of social class are generally upper middle, middle and working class customers, as Business offer products like cellular phone not much more affordable i.e. Motorola along with not much expensive i.e. Apple. It provides quality items to middle level customers at a slightly high rate than others targeting the exact same segment.


Loops And Arrays In Excel Vba 2 Case Study Analysis majority target customers have unique behavioural attributes. It has customers with an ambitious, fashionable and identified character with moderate level of loyalty towards the brand name. Its customers have some degree of shift towards other renowned brand names i.e. Apple. Most of Business consumers want quality in addition to cost control. They are attracted towards Org since of its moderate prices with a level of quality.

Quantitative analysis.

Sales of Loops And Arrays In Excel Vba 2 Case Study Analysis has actually increased remarkably from 16 billion $ in 1997 to 44.6 billion $ in 2002, and the net profit of.48 billion $ to 5.9 billion $. Digital media is the biggest selling category of Company with sales of 13.9 billion $, whereas, Telecommunication and Semiconductors sectors both reached 11 billion $ in sales.

Qualitative analysis.

Whereas, the core strength of the business is currently manufacturing but long gone are those days when good items were selling themselves. Kim has actually already started to reinforce the marketing activities of Org and really quickly it will become one of its core strength like producing if not much better.



Corp operates designs, produces and sell a huge portfolio of customer electronics. It runs in an extremely competitive environment and has effectively placed 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 Analysis operates in a highly competitive environment, which indicates all the companies have similar items. The answer for rarity is no.


Due to the nature of the market, it is really simple for competitors to understand the performance of the items and easily make their own designs. Yes, Enterprise is just behind IBM in registering brand-new patents annually, however the benefit is extremely short-term in this industry.


Chairman Lee has entirely turnaround Organization, from going nearly bankrupt during the Asian financial crisis of 1997 to the leading 25 business in the world. Certainly yes there is proper organization in the company and the results speak for themselves.

External Ecological Analysis

PESTLE Analysis


Being a multinational brand spread nearly in every country worldwide, majority of the environments like U.S.A., Europe, China and so on, are really conductive for its operations. It faces some political pressures in less industrialized countries where law and order circumstance is not excellent. Latin American, African and some Asian countries fall in this category, where political instability do have a result on Loops And Arrays In Excel Vba 2 Case Study Solution operations.


Buying power of customers is important for business like Venture to be successful and grow. Emerging markets like India, middle-eastern nations etc. provide development chances, whereas, due to economic crisis even the customers of developed nations suffer severely. Thus it is very crucial for the business to watch on the continuous economic situation of the nation before going into the market.


International companies need to deal with various social and cultural problems during its operations in a foreign country. Company has also dealt with numerous problems but have embraced to the regional environments of the majority of the countries extremely well. It has customized its items, practices, policies etc. accordingly in order to succeed.


With a yearly expenditure of 2.4 billion dollars in Research & Advancement, and with constant innovative product launches, Loops And Arrays In Excel Vba 2 Case Study Help is one of the top innovative companies of the world. With a clear mission to be ahead of the rest when it pertains to technological developments, Org has actually risen to the no 25 of the top effective companies of the world.


Each country has their own laws and policies, being a multinational business Org need to strictly follow those laws in their jurisdictions. Failure to do so, will result in major legal effects. So, it needs to study or hire a regional law professional prior to beginning its operations in a particular country.


With the rising awareness amongst customers about the ethical & ecological offenses of companies, Company has to make sure that it follows all the security guidelines. Environmental damages, ethical misconducts are not acceptable and in some countries the effects can be extremely serious. On the other hand it needs to do some Business Social Obligation practices to show the locals that it cares about their environment and individuals.

Porter's Five Forces

Danger of Substitution

Danger of substitution for Venture's each item classification is rather significant. Elements for high danger of alternative 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 industrialized nations, which make the expense of switching for consumers almost no. Along with it, Company printing services products are threatened by the increasing attraction of consumers towards cloud storage.

Rivalry Amongst Existing Companies:

The rivaly among Business and its close rivals is extreme. The major reason behind this is the approach of market saturation in numerous number of product categories, forcing Org to present more innovative functions in existing items and new ingenious products to preserve its growth. Other element for the extreme rivalry amongst the competitors is the little item differentiation amongst the products. The prominent gamers in the technology market are rather knowledgeable about the importance of R&D costs for their survival and are running into a race of marketing and R&D costs, to catch the marketplace. The major competitors for Loops And Arrays In Excel Vba 2 Case Study Help samrtphones include Apple, Motorola, LG, Nokia, Huawei, OPPO etc. High competitors rivalry leads to the changing market shares which can be seen in Display F.

Bargaining Power of Providers:

( Enterprise Sustainability Report, 2016) Supplier's bargaining power for Company is low as Org 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 Help to build its own software application, it has to outsource its software application development to Google, which ends up being a potential supplier of software for Enterprise, resulting in high bargaining power of Google.

Bargaining Power of Buyers:

Haggling power of purchasers for various variety of product classifications of Business is extreme. Among the aspect resulting in the extreme bargaining power is the schedule of large number of competitors in almost each item classification i.e. competitors of Corp Smart device, with a really little differentiation. The high availability of suppliers of Smartphones with minimum distinction, make the switching expense for purchasers practically no, hence increasing the bargaining power of buyers. Market saturation in the majority of the item classifications also make the bargaining power of buyers more extreme in for Loops And Arrays In Excel Vba 2 Case Study Help. In spite of igh bargaining power Corporation is quite capable of selling its items at a greater price than much of its competitors, due to high-end quality product and a reasonable brand image.

Hazard of New Entrants:

Danger of brand-new entrants for Loops And Arrays In Excel Vba 2 Case Study Solution is quite low. Along with it, requirement of substantial expertise and research and advancement expenditures for survival in the industry also make brand-new entrants hesitant to go into in the market. Market saturation is likewise one of the barrier of entry in technology industry.

Competitive Analysis

Business's high product diversity provides it distinction from its rivals. It is among the 3 top brand names by market share. Unlikely to its close rivals including Sony, Intel and Nokia, who focus bulk on a single product classification with Sony concentrating on consumer electronic devices, Nokia on mobile phone and Intel on chips, Enterprise had a substantial R&D spending on all of its item classifications which allow the business to make possible revenue from sales of practically all of its products. (See Exhibition) Nevertheless, due to the wide product range the business faces high number of rivals.

The company ranks initially in 4 product classifications i.e. DRAM Chips, LCD Displays, Cinema TVs and Microwave, in regards to worldwide market share, among 8 various product classifications. Corp was the global leader in making DRAM, SRAM and NAND flash chips. Venture earnings from chips was less than Intel but its earnings from chips was growing faster than Intel and has actually grown close to the profits levels of Intel, as offered in the case Exhibit 2.

Along with the chips Business mobile market was likewise flourishing at a high rate than its competitors i.e. Motorola and Nokia. Enterprise's cell phone's sales growth was 51% as compare to Motorola with just 4% and Nokia with zero sales growth. The significant reson behind Organization's high growth despite of greater costs than Nokia and Motorola was the business's high-end quality cellular phone.

Venture was also reaping the benefits from increasing market share of luxury LCDs as given in case Display 3. The major reason, making the company make it possible for to obtain the opportunity is its mass production at low cost. Sony was the most significant rival for Loops And Arrays In Excel Vba 2 Case Study Analysis in LCD market, however, it had also begun joint endeavor with Org in 2003 for LCD manufacturing, minimizing the competitors for Enterprise.

Porter's Competitive Technique

Low Cost Management strategy of porter is fully carried out by Org the way they achieve economies of scale by strengthening their core competencies of manufacturing. They always bring something new and innovative whether it's an item or a service.


Alternative Service 1

The Chief Marketing Officer (CMO) of Loops And Arrays In Excel Vba 2 Case Study Analysis would create a new brand name image by targeting the more youthful generation of the specific nation. As, especially smart phones of Organization are incredibly popular among the more youthful market.


1. It is the very best technique to construct Client Life time Worth (CLV) by creating a long-lasting relationship with clients. Build commitment through providing worth and profit for long-term, as research study has showed it is more affordable to maintain present clients than to bring in new ones.
2. Another pro of this alternative is that word of mouth spread more quickly amongst younger individuals and which in turn will generate new customers for my items.


1. Old customers who were related to Venture prior to might not like this brand-new image the business is trying to portray.
2 It will incur additional expenditures to reposition some items and it might not even bring success as the patterns change really quickly among the younger group.

Alternative option 2.

It would be done by setting up training workshops throughout which importance of marketing will be taught and numbers will be given. Marketing environment should be produced internally initially as genuine marketing starts inside the corporation.


1. Its pro will be that all the marketing method fans will come out and also the opposite ones.


2. Its con can create a really unhealthy environment in the work environment, as individuals often withstand modification since they fear it.

Determine the best alternative

First option is the very best as it plainly has more pros because when a Customer Life time Worth is developed the company will benefit from it till that consumer lives and has acquiring power as well. Plus, our target consumers are the younger generation which are bound to live longer than the existing old age people. Venture's main objective is to produce loyalty amongst its consumers and make them redeemed it from them and even buy their various items.

Implementation Plan

• Targeting younger generation through social marketing, producing a link with them like Pepsi finish with music. And set the expectations achievable and reasonable.
• A group consisting of best marketing and sales professionals must be assemble, and both views should be considered before securing the resources required to implement the plan.
• Thorough communication of the plan need to be done as it is extremely important for everyone to be on the exact same page to make it work.
• Tasks and timelines must be build and interacted appropriately to each person accountable.
• The manager ought to utilize a dashboard which reveals the development of all the tasks which have actually been done or about to be done and by whom.
• The supervisor must keep an eye on and keep a continuous look at the total and individual efficiency.
Due to the fact that any brand-new trend or policy may come in due to which all the things currently planned have to be adjusted, • Everyone must be prepared to adapt midway. It's much better to have contingency strategies currently prepared.
• At the end of the project the supervisor need to communicate the results and if effective must commemorate with the group.

Spending plan

This change the budget allowance of various nations and many supervisors were dissatisfied and argued however the analysis done by the program was precise and showed figures like North America and Russia growth prospective merited a 35% allotment while they were receiving 45%. It truly helped to fairly disperse the resources and catch more clients by investing more on ads on the high growth capacity areas of the world.

Its continuous financial investment in R&D and ingenious practices have moved them to brand-new heights however for them its' only the start and they want to be amongst the top 3 brands in the world. Their marketing efforts ought to be directed towards more youthful group amidst the internal arguments about marketing and ought to create Customer Lifetime Worth as it will not only offer them benefits now but will continue to gain it till the customer lifetime. As the expense of maintaining the customer is much cheaper than bring in a new one.