Menu

Descriptive Statistics In Microsoft Excel Case Study Analysis

Case Study Solution And Analysis


Home >> Kelloggs >> Descriptive Statistics In Microsoft Excel >>

Descriptive Statistics In Microsoft Excel Case Study Solution

Business is currently one of the greatest food chains worldwide. It was founded by Henri Descriptive Statistics In Microsoft Excel in 1866, a German Pharmacist who first launched "FarineLactee"; a mix of flour and milk to feed babies and reduce mortality rate.
Business is now a global company. Unlike other multinational companies, it has senior executives from different countries and attempts to make choices considering the entire world. Descriptive Statistics In Microsoft Excel currently has more than 500 factories around the world and a network spread across 86 nations.

Purpose

The function of Descriptive Statistics In Microsoft Excel Corporation is to boost the quality of life of people by playing its part and offering healthy food. It wishes to help the world in forming a healthy and much better future for it. It also wants to motivate people to live a healthy life. While ensuring that the company is succeeding in the long run, that's how it plays its part for a better and healthy future

Vision

Descriptive Statistics In Microsoft Excel's vision is to supply its consumers with food that is healthy, high in quality and safe to eat. It wishes to be ingenious and at the same time comprehend the needs and requirements of its customers. Its vision is to grow fast and provide products that would please the needs of each age. Descriptive Statistics In Microsoft Excel pictures to establish a trained workforce which would help the business to grow
.

Mission

Descriptive Statistics In Microsoft Excel's objective is that as currently, it is the leading business in the food market, it believes in 'Great Food, Excellent Life". Its mission is to offer its customers with a range of options that are healthy and finest in taste also. It is concentrated on offering the best food to its customers throughout the day and night.

Products.

Descriptive Statistics In Microsoft Excel has a large range of items that it provides to its clients. In 2011, Business was noted as the most gainful company.

Goals and Objectives

• Remembering the vision and mission of the corporation, the business has put down its goals and goals. These objectives and objectives are listed below.
• One objective of the business is to reach absolutely no garbage dump status. (Business, aboutus, 2017).
• Another objective of Descriptive Statistics In Microsoft Excel is to squander minimum food during production. Most often, the food produced is lost even prior to it reaches the consumers.
• Another thing that Business is dealing with is to enhance its packaging in such a method that it would help it to lower those complications and would also ensure the delivery of high quality of its products to its consumers.
• Meet global standards of the environment.
• Construct a relationship based on trust with its customers, business partners, employees, and government.

Critical Issues

Recently, Business Business is focusing more towards the method of NHW and investing more of its revenues on the R&D innovation. The country is investing more on acquisitions and mergers to support its NHW technique. The target of the business is not accomplished as the sales were expected to grow higher at the rate of 10% per year and the operating margins to increase by 20%, offered in Display H.

Situational Analysis.

Analysis of Current Strategy, Vision and Goals

The existing Business strategy is based upon the principle of Nutritious, Health and Health (NHW). This technique handles the concept to bringing change in the customer choices about food and making the food stuff much healthier concerning about the health issues.
The vision of this strategy is based on the secret method i.e. 60/40+ which just implies that the products will have a score of 60% on the basis of taste and 40% is based on its dietary worth. The products will be produced with extra nutritional value in contrast to all other items in market gaining it a plus on its dietary material.
This method was adopted to bring more yummy plus healthy foods and beverages in market than ever. In competitors with other business, with an intent of retaining its trust over consumers as Business Company has gained more relied on by costumers.

Quantitative Analysis.

R&D Spending as a portion of sales are declining with increasing actual amount of spending reveals that the sales are increasing at a higher rate than its R&D spending, and permit the company to more invest in R&D.
Net Profit Margin is increasing while R&D as a portion of sales is decreasing. This sign also reveals a green light to the R&D costs, mergers and acquisitions.
Financial obligation ratio of the business is increasing due to its spending on mergers, acquisitions and R&D advancement rather than payment of financial obligations. This increasing financial obligation ratio position a danger of default of Business to its investors and could lead a declining share prices. In terms of increasing debt ratio, the company needs to not spend much on R&D and should pay its present financial obligations to reduce the threat for financiers.
The increasing danger of investors with increasing debt ratio and declining share rates can be observed by big decrease of EPS of Descriptive Statistics In Microsoft Excel stocks.
The sales development of company is also low as compare to its mergers and acquisitions due to slow perception building of consumers. This sluggish growth also impede business to additional invest in its mergers and acquisitions.( Business, Business Financial Reports, 2006-2010).
Note: All the above analysis is done on the basis of calculations and Graphs given in the Displays D and E.

TWOS Analysis


2 analysis can be used to obtain various strategies based upon the SWOT Analysis given above. A short summary of TWOS Analysis is given up Exhibit H.

Strategies to exploit Opportunities using Strengths

Business should introduce more innovative items by large quantity of R&D Spending and mergers and acquisitions. It might increase the marketplace share of Business and increase the earnings margins for the company. It might also offer Business a long term competitive benefit over its competitors.
The worldwide growth of Business must be concentrated on market catching of developing nations by growth, drawing in more customers through consumer's loyalty. As developing countries are more populous than industrialized countries, it could increase the client circle of Business.

Strategies to Overcome Weaknesses to Exploit Opportunities

Swot AnalysisDescriptive Statistics In Microsoft Excel needs to do cautious acquisition and merger of companies, as it could affect the customer's and society's perceptions about Business. It should get and merge with those business which have a market track record of healthy and nutritious business. It would improve the understandings of consumers about Business.
Business needs to not just spend its R&D on development, rather than it needs to also concentrate on the R&D spending over examination of expense of different nutritious products. This would increase expense effectiveness of its items, which will result in increasing its sales, due to decreasing costs, and margins.

Strategies to use strengths to overcome threats

Business needs to move to not only developing but also to developed nations. It must expand its circle to numerous nations like Unilever which operates in about 170 plus nations.

Strategies to overcome weaknesses to avoid threats

It needs to obtain and combine with those countries having a goodwill of being a healthy business in the market. It would also make it possible for the company to use its prospective resources effectively on its other operations rather than acquisitions of those companies slowing the NHW technique growth.

Segmentation Analysis

Demographic Segmentation

The market division of Business is based upon four factors; age, gender, earnings and profession. For instance, Business produces a number of items connected to babies i.e. Cerelac, Nido, and so on and associated to grownups i.e. confectionary products. Descriptive Statistics In Microsoft Excel products are quite inexpensive by almost all levels, but its significant targeted clients, in terms of income level are middle and upper middle level clients.

Geographical Segmentation

Geographical division of Business is made up of its existence in practically 86 countries. Its geographical division is based upon two main aspects i.e. typical income level of the consumer in addition to the climate of the region. Singapore Business Business's segmentation is done on the basis of the weather of the region i.e. hot, warm or cold.

Psychographic Segmentation

Psychographic segmentation of Business is based upon the personality and life style of the customer. Business 3 in 1 Coffee target those clients whose life style is rather busy and don't have much time.

Behavioral Segmentation

Descriptive Statistics In Microsoft Excel behavioral segmentation is based upon the mindset understanding and awareness of the client. Its highly nutritious products target those consumers who have a health mindful mindset towards their usages.

Descriptive Statistics In Microsoft Excel Alternatives

In order to sustain the brand name in the market and keep the customer intact with the brand, there are two choices:
Option: 1
The Company should invest more on acquisitions than on the R&D.
Pros:
1. Acquisitions would increase overall properties of the business, increasing the wealth of the business. However, spending on R&D would be sunk cost.
2. The company can resell the gotten units in the market, if it stops working to execute its method. Amount invest on the R&D could not be revived, and it will be considered entirely sunk expense, if it do not provide potential results.
3. Spending on R&D supply sluggish growth in sales, as it takes long time to present a product. However, acquisitions supply fast outcomes, as it offer the business currently established item, which can be marketed right after the acquisition.
Cons:
1. Acquisition of company's which do not fit with the company's values like Kraftz foods can lead the company to face misconception of consumers about Business core worths of healthy and healthy items.
2 Large spending on acquisitions than R&D would send a signal of company's inefficiency of establishing ingenious products, and would results in consumer's discontentment.
3. Large acquisitions than R&D would extend the line of product of the company by the items which are already present in the market, making company not able to present new ingenious products.
Option: 2.
The Company should invest more on its R&D instead of acquisitions.
Pros:
1. It would allow the company to produce more innovative items.
2. It would supply the company a strong competitive position in the market.
3. It would make it possible for the company to increase its targeted customers by introducing those products which can be used to a completely brand-new market segment.
4. Innovative items will provide long term benefits and high market share in long run.
Cons:
1. It would decrease the earnings margins of the business.
2. In case of failure, the entire costs on R&D would be considered as sunk expense, and would impact the company at big. The threat is not in the case of acquisitions.
3. It would not increase the wealth of company, which might provide a negative signal to the financiers, and might result I decreasing stock prices.
Alternative 3:
Continue its acquisitions and mergers with significant spending on in R&D Program.
Vrio AnalysisPros:
1. It would allow the business to present new ingenious items with less threat of converting the costs on R&D into sunk cost.
2. It would supply a positive signal to the financiers, as the total properties of the business would increase with its significant R&D costs.
3. It would not affect the earnings margins of the company at a large rate as compare to alternative 2.
4. It would provide the company a strong long term market position in terms of the company's general wealth in addition to in terms of innovative items.
Cons:
1. Threat of conversion of R&D spending into sunk cost, higher than alternative 1 lesser than alternative 2.
2. Risk of misunderstanding about the acquisitions, higher than alternative 2 and lower than option 1.
3. Intro of less number of innovative products than alternative 2 and high variety of ingenious items than alternative 1.

Descriptive Statistics In Microsoft Excel Conclusion

RecommendationsIt has actually institutionalized its techniques and culture to align itself with the market modifications and client habits, which has ultimately permitted it to sustain its market share. Business has developed significant market share and brand name identity in the metropolitan markets, it is recommended that the business must focus on the rural areas in terms of establishing brand loyalty, awareness, and equity, such can be done by developing a particular brand name allotment technique through trade marketing tactics, that draw clear difference in between Descriptive Statistics In Microsoft Excel items and other rival items.

Descriptive Statistics In Microsoft Excel Exhibits

PESTEL Analysis
P
Political
E
Economic
S
Social
T
Technology
L
Legal
E
Environment
Governmental assistance

Altering requirements of international food.
Enhanced market share. Changing perception towards healthier products Improvements in R&D as well as QA divisions.

Intro of E-marketing.
No such effect as it is good. Worries over recycling.

Use resources.

Competitor Analysis
Business Unilever PLC Kraft Foods Incorporation DANONE
Sales Growth Highest because 4000 Highest possible after Service with much less development than Company 7th Most affordable
R&D Spending Highest since 2008 Greatest after Business 7th Lowest
Net Profit Margin Highest possible given that 2001 with rapid growth from 2007 to 2013 As a result of sale of Alcon in 2013. Nearly equal to Kraft Foods Unification Almost equal to Unilever N/A
Competitive Advantage Food with Nutrition and wellness element Highest possible variety of brands with sustainable techniques Largest confectionary as well as refined foods brand name on the planet Biggest dairy products as well as mineral water brand in the world
Segmentation Middle and also upper middle level consumers worldwide Specific clients in addition to family team Every age and also Earnings Client Groups Center and also top center degree consumers worldwide
Number of Brands 7th 6th 2nd 4th

Quantitative Analysis​
Analysis of Financial Statements (In Millions of CHF)
2006 2007 2008 2009 2010
Sales Revenue 45367 623841 945223 544327 372288
Net Profit Margin 1.58% 6.65% 64.45% 6.14% 84.51%
EPS (Earning Per Share) 68.75 1.81 4.39 6.39 98.84
Total Asset 258744 644989 226466 413313 83523
Total Debt 29255 76471 24723 34643 67465
Debt Ratio 63% 66% 86% 52% 85%
R&D Spending 2518 3455 5264 7328 4253
R&D Spending as % of Sales 6.35% 5.97% 6.83% 4.43% 6.82%

Executive Summary Swot Analysis Vrio Analysis Pestel Analysis
Porters Analysis Recommendations