Advanced Logic Functions In Microsoft Excel Case Study Help

Case Study Solution And Analysis

Home >> Kelloggs >> Advanced Logic Functions In Microsoft Excel >>

Advanced Logic Functions In Microsoft Excel Case Study Solution

Business is currently one of the biggest food chains worldwide. It was established by Henri Advanced Logic Functions In Microsoft Excel in 1866, a German Pharmacist who initially launched "FarineLactee"; a mix of flour and milk to feed infants and reduce mortality rate.
Business is now a global company. Unlike other multinational business, it has senior executives from various nations and attempts to make choices thinking about the entire world. Advanced Logic Functions In Microsoft Excel currently has more than 500 factories worldwide and a network spread across 86 countries.


The function of Business Corporation is to boost the quality of life of people by playing its part and providing healthy food. While making sure that the company is prospering in the long run, that's how it plays its part for a much better and healthy future


Advanced Logic Functions In Microsoft Excel's vision is to provide its consumers with food that is healthy, high in quality and safe to eat. Business pictures to develop a well-trained labor force which would help the company to grow


Advanced Logic Functions In Microsoft Excel's mission is that as presently, it is the leading business in the food industry, it believes in 'Great Food, Good Life". Its objective is to offer its customers with a range of choices that are healthy and best in taste. It is concentrated on providing the very best food to its customers throughout the day and night.


Advanced Logic Functions In Microsoft Excel has a large range of products that it offers to its clients. In 2011, Business was listed as the most rewarding organization.

Goals and Objectives

• Bearing in mind the vision and objective of the corporation, the company has actually laid down its goals and goals. These goals and objectives are noted below.
• One goal of the company is to reach zero garbage dump status. (Business, aboutus, 2017).
• Another goal of Advanced Logic Functions In Microsoft Excel is to waste minimum food throughout production. Most often, the food produced is lost even before 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 problems and would also ensure the delivery of high quality of its items to its clients.
• Meet worldwide standards of the environment.
• Develop a relationship based on trust with its consumers, service partners, workers, and government.

Critical Issues

Recently, Business Company is focusing more towards the strategy 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 method. The target of the company is not attained 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 Exhibition H.

Situational Analysis.

Analysis of Current Strategy, Vision and Goals

The current Business method is based upon the principle of Nutritious, Health and Wellness (NHW). This technique deals with the concept to bringing modification in the consumer choices about food and making the food stuff healthier worrying about the health concerns.
The vision of this method is based upon the key approach i.e. 60/40+ which simply means that the items will have a score of 60% on the basis of taste and 40% is based upon its dietary value. The products will be made with additional dietary worth in contrast to all other products in market gaining it a plus on its dietary content.
This method was adopted to bring more tasty plus healthy foods and beverages in market than ever. In competition with other companies, with an intention of maintaining its trust over clients as Business Company has acquired more relied on by customers.

Quantitative Analysis.

R&D Spending as a percentage of sales are declining with increasing actual amount of spending reveals that the sales are increasing at a greater rate than its R&D costs, and enable the business to more spend on R&D.
Net Earnings Margin is increasing while R&D as a percentage of sales is declining. This indicator also reveals a thumbs-up to the R&D costs, mergers and acquisitions.
Financial obligation ratio of the business is increasing due to its costs on mergers, acquisitions and R&D development instead of payment of debts. This increasing financial obligation ratio pose a risk of default of Business to its financiers and could lead a decreasing share prices. For that reason, in regards to increasing financial obligation ratio, the firm should not spend much on R&D and ought to pay its current financial obligations to decrease the risk for financiers.
The increasing danger of financiers with increasing financial obligation ratio and declining share rates can be observed by huge decrease of EPS of Advanced Logic Functions In Microsoft Excel stocks.
The sales development of company is also low as compare to its mergers and acquisitions due to slow perception structure of customers. This sluggish development also hinder business to more spend on its mergers and acquisitions.( Business, Business Financial Reports, 2006-2010).
Note: All the above analysis is done on the basis of computations and Graphs given up the Exhibitions D and E.

TWOS Analysis

2 analysis can be utilized to obtain various strategies based upon the SWOT Analysis provided above. A short summary of TWOS Analysis is given in Exhibition H.

Strategies to exploit Opportunities using Strengths

Business should present more innovative items by big amount of R&D Spending and mergers and acquisitions. It might increase the marketplace share of Business and increase the revenue margins for the business. It might also offer Business a long term competitive advantage over its competitors.
The international expansion of Business should be focused on market catching of developing nations by expansion, drawing in more customers through consumer's commitment. As establishing nations are more populated than developed nations, it might increase the client circle of Business.

Strategies to Overcome Weaknesses to Exploit Opportunities

Swot AnalysisAdvanced Logic Functions In Microsoft Excel must do mindful acquisition and merger of organizations, as it might affect the consumer's and society's understandings about Business. It ought to get and combine with those business which have a market credibility of healthy and healthy business. It would enhance the understandings of customers about Business.
Business ought to not only invest its R&D on innovation, instead of it needs to likewise concentrate on the R&D spending over assessment of expense of various nutritious items. This would increase expense performance of its products, which will result in increasing its sales, due to decreasing prices, and margins.

Strategies to use strengths to overcome threats

Business ought to relocate to not just establishing however likewise to developed nations. It should widens its geographical growth. This large geographical growth towards establishing and established nations would reduce the threat of potential losses in times of instability in various nations. It needs to broaden its circle to different nations like Unilever which runs in about 170 plus nations.

Strategies to overcome weaknesses to avoid threats

Advanced Logic Functions In Microsoft Excel needs to sensibly manage its acquisitions to avoid the risk of mistaken belief from the consumers about Business. It needs to acquire and combine with those nations having a goodwill of being a healthy company in the market. This would not just improve the perception of customers about Business but would also increase the sales, revenue margins and market share of Business. It would also enable the business to use its prospective resources effectively on its other operations instead of acquisitions of those organizations slowing the NHW method growth.

Segmentation Analysis

Demographic Segmentation

The group division of Business is based on four elements; age, gender, income and occupation. For example, Business produces numerous products related to babies i.e. Cerelac, Nido, and so on and related to grownups i.e. confectionary products. Advanced Logic Functions In Microsoft Excel products are quite cost effective by practically all levels, but its significant targeted consumers, in regards to earnings level are middle and upper middle level consumers.

Geographical Segmentation

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

Psychographic Segmentation

Psychographic division of Business is based upon the character and life style of the customer. Business 3 in 1 Coffee target those customers whose life design is rather busy and do not have much time.

Behavioral Segmentation

Advanced Logic Functions In Microsoft Excel behavioral division is based upon the mindset knowledge and awareness of the consumer. For example its extremely healthy items target those customers who have a health conscious mindset towards their intakes.

Advanced Logic Functions In Microsoft Excel Alternatives

In order to sustain the brand in the market and keep the client intact with the brand name, there are two alternatives:
Alternative: 1
The Business needs to spend more on acquisitions than on the R&D.
1. Acquisitions would increase overall possessions of the company, increasing the wealth of the company. Costs on R&D would be sunk cost.
2. The company can resell the gotten units in the market, if it fails to implement its technique. Quantity invest on the R&D could not be revived, and it will be considered completely sunk cost, if it do not give potential results.
3. Spending on R&D provide sluggish growth in sales, as it takes very long time to present a product. Nevertheless, acquisitions provide quick results, as it provide the business currently established item, which can be marketed soon after the acquisition.
1. Acquisition of company's which do not fit with the business's values like Kraftz foods can lead the business to deal with misconception of customers about Business core worths of healthy and nutritious products.
2 Large spending on acquisitions than R&D would send a signal of business's ineffectiveness of developing innovative items, and would outcomes in consumer's dissatisfaction.
3. Big acquisitions than R&D would extend the line of product of the company by the products which are already present in the market, making company not able to present brand-new innovative items.
Alternative: 2.
The Company ought to spend more on its R&D instead of acquisitions.
1. It would make it possible for the company to produce more innovative items.
2. It would offer the company a strong competitive position in the market.
3. It would enable the company to increase its targeted consumers by presenting those products which can be offered to an entirely brand-new market section.
4. Ingenious products will offer long term benefits and high market share in long run.
1. It would reduce the revenue margins of the company.
2. In case of failure, the whole spending on R&D would be considered as sunk cost, and would affect the company at big. The danger is not when it comes to acquisitions.
3. It would not increase the wealth of business, which could supply an unfavorable signal to the investors, and could result I decreasing stock prices.
Alternative 3:
Continue its acquisitions and mergers with substantial costs on in R&D Program.
Vrio AnalysisPros:
1. It would permit the company to present new ingenious items with less risk of transforming the spending on R&D into sunk expense.
2. It would offer a positive signal to the investors, as the overall assets of the business would increase with its substantial R&D spending.
3. It would not affect the revenue margins of the company at a large rate as compare to alternative 2.
4. It would offer the company a strong long term market position in terms of the company's total wealth along with in regards to ingenious products.
1. Risk of conversion of R&D spending into sunk cost, greater than alternative 1 lower than alternative 2.
2. Danger of misunderstanding about the acquisitions, higher than alternative 2 and lower than option 1.
3. Introduction of less number of innovative items than alternative 2 and high number of innovative products than alternative 1.

Advanced Logic Functions In Microsoft Excel Conclusion

RecommendationsBusiness has stayed the top market player for more than a years. It has institutionalized its methods and culture to align itself with the market changes and consumer habits, which has actually eventually enabled it to sustain its market share. Though, Business has actually developed substantial market share and brand identity in the city markets, it is recommended that the business must focus on the backwoods in terms of developing brand commitment, awareness, and equity, such can be done by creating a particular brand name allotment technique through trade marketing strategies, that draw clear difference in between Advanced Logic Functions In Microsoft Excel items and other rival items. Advanced Logic Functions In Microsoft Excel needs to utilize its brand image of safe and healthy food in catering the rural markets and likewise to upscale the offerings in other categories such as nutrition. This will enable the business to establish brand equity for freshly introduced and currently produced items on a higher platform, making the reliable usage of resources and brand image in the market.

Advanced Logic Functions In Microsoft Excel Exhibits

PESTEL Analysis
Governmental assistance

Changing requirements of international food.
Improved market share.
Altering assumption in the direction of healthier items
Improvements in R&D and QA divisions.

Intro of E-marketing.
No such impact as it is favourable.
Worries over recycling.

Use of resources.

Competitor Analysis
Business Unilever PLC Kraft Foods Incorporation DANONE
Sales Growth Greatest given that 6000
Highest possible after Organisation with less development than Business 6th Least expensive
R&D Spending Greatest since 2005 Highest after Business 8th Cheapest
Net Profit Margin Highest possible considering that 2009 with fast growth from 2002 to 2011 Because of sale of Alcon in 2017. Practically equal to Kraft Foods Incorporation Nearly equal to Unilever N/A
Competitive Advantage Food with Nourishment and also wellness variable Highest possible variety of brands with lasting methods Biggest confectionary and refined foods brand in the world Biggest milk products as well as mineral water brand name worldwide
Segmentation Center and upper middle level consumers worldwide Specific clients in addition to house group All age and Revenue Customer Teams Center and also top middle level customers worldwide
Number of Brands 4th 6th 3rd 3rd

Quantitative Analysis​
Analysis of Financial Statements (In Millions of CHF)
2006 2007 2008 2009 2010
Sales Revenue 92824 319511 411818 863776 793279
Net Profit Margin 7.43% 7.13% 12.66% 7.53% 22.53%
EPS (Earning Per Share) 29.52 6.65 3.85 6.95 76.45
Total Asset 357478 986535 483283 732616 75895
Total Debt 81464 38588 84465 54816 42668
Debt Ratio 13% 65% 66% 16% 49%
R&D Spending 3127 9128 7317 3519 7497
R&D Spending as % of Sales 3.65% 7.11% 8.58% 1.67% 3.17%

Advanced Logic Functions In Microsoft Excel Executive Summary Advanced Logic Functions In Microsoft Excel Swot Analysis Advanced Logic Functions In Microsoft Excel Vrio Analysis Advanced Logic Functions In Microsoft Excel Pestel Analysis
Advanced Logic Functions In Microsoft Excel Porters Analysis Advanced Logic Functions In Microsoft Excel Recommendations