Descriptive Statistics In Microsoft Excel Case Study Analysis


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

Descriptive Statistics In Microsoft Excel Case Study Solution

Background and Facts

Descriptive Statistics In Microsoft Excel a workplace products retailer for little and also average sized services has actually just recently been associated with preparing for a merger with its competitor House Deport, which has influenced efficiency degrees in departmentswith the elderly supervisor associated with legal issues put forth by the government Trade Commission. With the Marketing Head putting forward the news of his departure from the company in one year, Jeannie Lewis, the current head of procedures has been asked to take the function in the near future. With challenges in the form of a possible social change and also low staff member morale, the company needs a full reengineering effort at the advertising division.

Trouble Statement
Porter's 5 Forces Analysis
The possible social change at the marketing division of Descriptive Statistics In Microsoft Excel is raising unpredictability in the working environment resulting in different difficulties for the Jeannie Lewis that would be changing the head of the division in one year. nalysis

PEST analysis

Political Factors: Political factors play a major function in influencing strategic decisions given that Stapes Inc. had to abandon its strategies of merging with Office Deport after the Federal Trade Commission's intervention at the same time. Provided the reality that the shop has a global existence with branches in UK, UNITED STATES, Canada and also Germany, political consider each of these nations may be able to impact efficiency or tactical goals. Federal Profession Commission's antitrust suit against the merging took up valuable time of the company's senior administration recommending that 'political' factors can have severe ramifications for a global organisation.

Economic Factors: Economic factors such as the emergence of small companies in the international scenario recommend that Descriptive Statistics In Microsoft Excel is growing in an atmosphere where there is prospective development of businesses. Along with this, fact that shop consumers are mostly searching for office materials for home offices recommends that the marketplace has an increasing fad of entrepreneurs and online services.

Social factors: Social trends in the economic climate show that clients are seeking ease as well as eye-catching costs. Market research demonstrates how the client for Descriptive Statistics In Microsoft Excel does not have understanding regarding discovering services which can supply a mix of comfort as well as low costs.

Technical factors: Modern technology plays a crucial function in Descriptive Statistics In Microsoft Excel's service approach specifically as the company is piloting Technology facilities which would offer modern technology sales and support in the form of memory upgrades, peripheral installations. (Summary of INSECT in appendix 2).

OB Issues and Effects.

A number of underlying Business Habits problems can be seen in Descriptive Statistics In Microsoft Excel's case as highlighted in this section.

Concerns regarding cultural adjustment: There is worry concerning a social modification that would occur as soon as Todd Krasnow leaves from his setting as the Executive Vice Head Of State of Advertising And Marketing with a lot of the staff members currently showing unhappiness over this potential move. This expected modification has actually created anxiety in the office which has actually been paired with the past stress of preparing the firm for a prospective merger with Home Deport.
Pest Analysis
Demanding Work Environment for Newcomers: There is shortage of workers that can match the demanding setting of a busy company. Not just does this lead to difficulty in discovering the ideal people, it puts anxiety on new hires as can not endure the rate and pressure that the company expects them to birth.

Dual Coverage Lines: Novices locate this organizational culture cumbersome as well as challenging to deal with particularly as dotted line relationships are suggested to be weaker in general and also unbiased setting and efficiency examination is still done by the solid line supervisor. This means that novices could shed clarity about their respective functions and also purposes especially as dotted line coverage does not keep them in straight communication with the solid line managers.

Bitterness From Cross Departmental Hiring: Krasnow's choice to make Lewis his follower as opposed to Bridget Coles although it had been speculated that the last would take Krasnow's setting came as an impact to her morale. Lewis might have been capable and also proper for the work yet the reality that Kransnow's separation would make Coles a direct record to Lewis may have been the factor for Coles' resignation from services.

Fear & Work Instability: Fear and also instability can be determined as two significant concerns that Lewis would be dealing with especially as the merging has now be terminated as well as 2 elderly execs of the advertising and marketing division would certainly be leaving. The whole responsibility of the division would be falling on Lewis's shoulders who would certainly not just be in charge of brining regarding a social change but would certainly also have to show herself in her new function.

Inappropriate Administration Design of Leader: Lewis's monitoring style as well as its incompatibility with the advertising department's duty can also be seen as an OB difficulty especially as she has been utilized to taking care of concerns in the operations division where workers are taught to concentrate on processes as well as obtain them. The advertising department on the various other hand can be seen as a team of people that are used to being nurtured by Krasnow that focused a lot more on outcome than processes.

Interdepartmental Disputes: Interdepartmental disputes in between three departments, marketing, merchandizing and procedures specifically over the allowance of the advertising mix can be identified as an additional OB problem. Although the marketing department does not share the very same vision as the various other 2 divisions pertaining to the aloocation of the advertising mix twoards promotions and advertsing, the merchandizing and also procedures departments do not agree over the advertising mix allowance amongst one another either.

Fragmentation in Advertising And Marketing Division: Disintegration in between the advertising and marketing divisions can be identified as an additional OB concern which could need further interest. The reality that the marketing and advertising sections in the advertising and marketing department are detached is protecting against both divisions from gaining from each various other's experience as well as proficiency. Assimilation of marketing with merchandising and also operations would come to be more difficult if the advertising and marketing division itself is degenerated which can be one more prospective OB worry.

Descriptive Statistics In Microsoft Excel Analysis

Numerous theories have actually been used to describe the situations to get further clarity regarding the circumstance handy.
Swot Analysis
McGregor's Theory X & Y: According to Douglas McGregor's Concept X, many managers believe that subordinates are easy and lazy, have little ambition and also withstand change. The difficult variation of this concept highlighted browbeating, tight controls, dangers as well as penalties. Gradually it generates reduced efficiency, refined sabotage and competition (Offer, 2003). Although the scenario at Descriptive Statistics In Microsoft Excel is not totally following Theory X, it can be seen that brand-new hires are locating this atmosphere rather stressful which may at some point cause a higher disposition of the administration towards Theory X. As per McGregor's advocated sight, which he called Theory Y, the vital task of the management is to prepare business conditions to ensure that individuals can accomplish their own objectives best by routing their initiatives towards organizational rewards. If individuals locate no satisfaction in their work, the administration would have little option however to count on theory X as well as external control (Deal, 2003). Also while examining Lewis's management design, concept X may have been suitable in the operations division to some extent however the Advertising and marketing division would call for reliance on Concept Y so as to get the imagination and originality from the groups.

Tuckman's Synergy Theory: As for Lewis's problem regarding bringing consistency between the marketing and advertising department is concerned, this would originally lead to contrast as gone over by Bruce Tuckman in his 'Teamwork Concept'. (Tuckman, 1965). Based on Tuckman's concept shown in appendix 3, during the preliminary phase of group growth, people might not bond, as they are hectic locating their area in the group. By integrating the marketing and advertising division's job, there may coincide preliminary separate which might result in the 2nd stage of 'storming' where the teams test one another. However, it is only during the 3rd phase or 'norming' when they would certainly collaborate to share ideas prior to the team can cause harmony in the fourth stage 'carrying out'.

When people are presented with change, they enter phase one and also so there might be emotions like unhappiness, uncertainty, aggravation, anger, concern, rejection and disorientation.The scenario at the advertising and marketing division of Descriptive Statistics In Microsoft Excel is similar so Lewis can obtain comfortable with the suggestion that it is not phenomenal habits. It is throughout this phase that Lewis will have to offer guidance to the division so that they can find a feeling of direction. It can be seen just how Krasnow has currently made this shift much easier by making Lewis obtain included in the department a year before his actual departure.
Vrio Analysis
Maslow's Need power structure: The OB concern pertaining to instability at the workplace has been set off firstly by the change in administration and second of all by the fact that the merging will no longer be initiated. Abraham Maslow in his Theory of 'Requirements Pecking order' (appendix 5) has goes over the significance of 'safety and security needs as being a reduced degree need of a human for causing inspiration. As seen in the pyramid shared in appendix 3, we can see exactly how 'the need to feel safe and secure and out of danger' is at the 2nd level of requirements. Prior to a worker can be made to establish mentally, he requires to have his 'Physiological 'and also 'Safety and security' requires fulfilled. This indicates that unless the workers are made to really feel protected concerning their present employment status in Descriptive Statistics In Microsoft Excel they may not get to 'Self-Fulfillment'. (King, 2009).

SWOT Analysis for Descriptive Statistics In Microsoft Excel Case Study

Effects of Analysis.

The OB analysis has actually looked at various theories to recognize exactly how to deal with the current situation available. The following 3 alternatives have been suggested to help Lewis manage the business obstacles in the marketing department. Each of these options has actually been recommended for relieving the transition needed to bring the marketing department in accordance with the requirements of the market and also for making the cultural change that would certainly adhere to once the existing leader leaves.

Assimilation of marketing and advertising features. Dividing Adverting and also Manufacturing functions. Assimilation of Marketing with Workflow.

Examination of Alternatives.

Integration of Marketing & Advertising And Marketing Functions: The internal advertising agency of Descriptive Statistics In Microsoft Excel is currently toughness for the organization in regards to saving up on overheads associated with advertising as well as promo. Given that no brand-new employment has been done after Bridget Cole's separation with the reporting line being directly assigned to Krasnow for the advertising function, this is a positive possibility for integrating the advertising and marketing functions. Judith Shapiro that has actually earlier been spoken with by Lewis during the earlier merger days has proficiency in business-to-business advertising in addition to agency and retail marketing experience. When Krasnow leaves, Lewis can employ Shapiro as an EVP for marketing to handle both advertising and marketing features.

The benefit of this approach is that it will certainly integrate the two functions while lowering the demand for hiring an additional resource for marketing. Lewis would be heading the marketing department and also in any kind of case her substitute would be required for the present duty that she is executing. The disadvantage of this alternative is that outside hiring might cause animosity from internal employees that may be looking at the setting of EVP after Lewis takes control of Krasnow's setting.

Dividing Adverting and also Manufacturing: Provided the competitive stress and high quality job called for from the advertising firm, it is suggested that Lewis needs to enable the production system to be a different function from the marketing system. Because the majority of advertising and marketing firms had these two features as separate devices, it makes even more sense to follow the standard.

Combination of Advertising And Marketing with Workflows: Because Lewis is currently taking treatment of the advertising and marketing and procedures divisions concurrently; it makes sense to integrate the 2 functions considering that she has been efficiently taking care of both ends. The truth that Lewis has to adapt her monitoring style for the advertising and marketing department recommends that these two divisions would certainly be culturally varied.


An evaluation of the 3 alternatives suggests that integration of advertising as well as operations would certainly not be a viable step because of the substantial differences in between the two divisions although that presently Lewis is handling both. While splitting up of the manufacturing feature may have been a desirable move for the advertising department, the fact that it would certainly indicate positioning a 3rd function under Lewis's wing implies this ought to be prevented. The integration of the advertising department is the very best option in terms of obtaining the optimum arise from the division. An activity plan for this choice is discussed below.

Action Strategy.
Lewis will certainly take over the duty of EVP Advertising after Krasnow leaves.

Marketing and advertising features would certainly be merged.

Judith Shapiro will be worked with to take Lewis's place as SVP of advertising and marketing.

Manufacturing function will certainly continue to be part of advertising under advertising function.

Lewis will certainly separate herself from operations.

An autonomous management design with staff member empowerment will be used in advertising division.

Open door policy as well as focus on cross departmental communication will be targeted at eliminating discord.

Backup strategy.

If the combination does not exercise as planned, a contingency strategy would certainly adhere to which would divide the manufacturing feature from the advertising and marketing feature to lower the tons on the SVP of marketing and advertising. In case Judith Shapiro does not obtain employed, Lewis will certainly be heading the advertising and marketing department without an SVP. In that case the production feature will most definitely be divided by positioning it under an SVP production.