Descriptive Statistics In Microsoft Excel Case Study Help


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

Descriptive Statistics In Microsoft Excel Case Study Analysis

Background and Facts

Descriptive Statistics In Microsoft Excel an office materials retailer for little as well as average sized services has actually recently been involved in planning for a merging with its competitor Residence Deport, which has affected performance degrees in departmentswith the senior supervisor involved in legal difficulties presented by the government Trade Commission. With the Marketing Head putting forward the news of his separation from the company in one year, Jeannie Lewis, the existing head of operations has actually been asked to take the duty in the near future. With challenges in the form of a prospective cultural change and low employee morale, the company requires a total reengineering initiative at the advertising and marketing department.

Issue Declaration

The possible social modification at the advertising division of Descriptive Statistics In Microsoft Excel is raising unpredictability in the working environment bring about various challenges for the Jeannie Lewis that would certainly be changing the head of the division in one year. nalysis

PEST analysis

Political Factors: Political factors play a significant function in influencing tactical decisions because Stapes Inc. needed to abandon its strategies of combining with Office Deport after the Federal Profession Payment's intervention at the same time. Provided the fact that the store has an international presence with branches in UK, USA, Canada and Germany, political factors in each of these nations may be able to influence efficiency or tactical objectives. Federal Trade Payment's antitrust fit against the merging took up beneficial time of the organization's senior management suggesting that 'political' factors can have major ramifications for a worldwide business.

Economic Factors: Financial factors such as the emergence of local business in the international situation suggest that Descriptive Statistics In Microsoft Excel is thriving in a setting where there is possible growth of organisations. Fact that store consumers are primarily looking for workplace supplies for residence workplaces suggests that the market has an increasing fad of entrepreneurs and also home based companies.

Social factors: Social trends in the economy show that clients are seeking ease along with appealing rates. Marketing research demonstrates how the customer for Descriptive Statistics In Microsoft Excel lacks understanding regarding finding remedies which can supply a mix of benefit as well as inexpensive.

Technical factors: Innovation plays an essential duty in Descriptive Statistics In Microsoft Excel's service technique particularly as the company is piloting Innovation centers which would certainly provide modern technology sales as well as assistance in the form of memory upgrades, peripheral installations. (Summary of INSECT in appendix 2).

OB Issues as well as Manifestations.

A number of underlying Business Actions concerns can be seen in Descriptive Statistics In Microsoft Excel's case as highlighted in this area.

Apprehensions regarding cultural adjustment: There is concern concerning a social adjustment that would certainly happen when Todd Krasnow leaves from his setting as the Executive Vice Head Of State of Advertising with the majority of the staff members already showing discontent over this potential action. This expected modification has actually created stress and anxiety in the office which has been paired with the past anxiety of preparing the company for a possible merger with House Deport.

Difficult Job Atmosphere for Newcomers: There is lack of employees that can match the stressful environment of a busy company. Not just does this cause difficulty in locating the appropriate people, it puts stress on brand-new hires as can not hold up against the speed as well as stress that the organization expects them to birth.

Twin Reporting Lines: Newcomers discover this business culture troublesome as well as difficult to manage specifically as dotted line connections are indicated to be weak as a whole as well as objective setting and also efficiency assessment is still done by the solid line manager. This implies that novices could lose quality regarding their respective duties and purposes particularly as dotted line coverage does not maintain them in direct communication with the solid line managers.

Animosity From Cross Departmental Hiring: Krasnow's choice to make Lewis his follower as opposed to Bridget Coles despite the fact that it had been guessed that the latter would certainly take Krasnow's position came as a blow to her spirits. Lewis might have been qualified as well as proper for the task however the truth that Kransnow's separation would make Coles a straight report to Lewis might have been the reason for Coles' resignation from services.

Fear & Work Instability: Fear as well as insecurity can be recognized as 2 significant concerns that Lewis would certainly be dealing with especially as the merging has now be cancelled and also two senior execs of the advertising department would certainly be leaving. The whole obligation of the division would be dropping on Lewis's shoulders who would not just supervise of brining about a social modification however would likewise need to show herself in her brand-new function.

Incompatible Management Style of Leader: Lewis's management style as well as its conflict with the marketing division's function can also be viewed as an OB challenge especially as she has actually been made use of to dealing with concerns in the procedures department where workers are instructed to focus on procedures as well as obtain them right. The marketing department on the various other hand can be viewed as a group of individuals that are utilized to being nurtured by Krasnow who concentrated a lot more on result than procedures.

Interdepartmental Differences: Interdepartmental differences between 3 divisions, marketing, merchandizing and procedures specifically over the allowance of the marketing mix can be identified as an additional OB issue. The marketing division does not share the exact same vision as the various other 2 divisions concerning the aloocation of the advertising mix twoards promos and advertsing, the merchandizing as well as operations departments do not concur over the advertising and marketing mix allowance among one an additional either.

Fragmentation in Advertising Department: Fragmentation in between the marketing and advertising divisions can be identified as another OB problem which could require more interest. The reality that the advertising and marketing areas in the advertising and marketing division are detached is protecting against both departments from acquiring from each other's experience and knowledge. Integration of advertising with merchandising and also procedures would end up being harder if the advertising department itself is degenerated which can be one more prospective OB worry.

Descriptive Statistics In Microsoft Excel Analysis

Different concepts have been made use of to describe the situations to get more quality concerning the circumstance available.

McGregor's Theory X & Y: According to Douglas McGregor's Concept X, the majority of managers believe that subordinates are passive and also lazy, have little aspiration as well as withstand change. The hard variation of this theory highlighted threat, tight controls, hazards as well as punishments. In time it generates reduced efficiency, subtle sabotage and also rivalry (Offer, 2003). Although the situation at Descriptive Statistics In Microsoft Excel is not totally complying with Theory X, it can be seen that brand-new hires are finding this environment instead stressful which may at some point result in a better inclination of the administration towards Theory X. As per McGregor's promoted view, which he called Theory Y, the necessary task of the management is to set up organizational conditions to ensure that people can accomplish their very own goals best by directing their initiatives towards organizational incentives. If people find no complete satisfaction in their job, the monitoring would certainly have little choice yet to depend on concept X and also outside control (Offer, 2003). Also while assessing Lewis's management style, concept X might have appropriated in the operations division to some extent yet the Advertising and marketing division would certainly call for dependence on Concept Y so as to get the imagination as well as creativity from the groups.

Tuckman's Team effort Theory: Regarding Lewis's concern concerning bringing harmony in between the marketing and advertising department is worried, this would originally bring about contrast as reviewed by Bruce Tuckman in his 'Team effort Theory'. (Tuckman, 1965). According to Tuckman's theory received appendix 3, throughout the first phase of team development, people may not bond, as they are hectic finding their area in the group. By incorporating the marketing and advertising division's work, there might be the same initial detach which could bring about the 2nd stage of 'storming' where the groups test one another. However, it is just throughout the 3rd stage or 'norming' when they would come together to share ideas before the team can bring about harmony in the 4th phase 'carrying out'.

Bridges' Transition Design: Based On William Bridge's theory (appendix 4), people are fairly uneasy with change, which is evident by the circumstance at Descriptive Statistics In Microsoft Excel The situation can be viewed as a regular training course of life if is studied as per Bridge's theory where he describes that people experience 3 phases of transition when they experience change. 'End, shedding as well as Releasing', The Neutral Zone as well as 'The New Starting' (Bridges, 2004). When people are presented with modification, they enter phase one and so there may be feelings like unhappiness, uncertainty, stress, rage, worry, rejection as well as disorientation.The scenario at the advertising and marketing division of Descriptive Statistics In Microsoft Excel is similar so Lewis can get comfy with the suggestion that it is not amazing actions. In the 2nd stage, there may be a requirement to connect the gap in between the new as well as old society so Lewis might need to face this experience when Krasnow leaves. There might be reduced morale and reduced performance at this stage which ought to not be taken as a trouble. It is throughout this stage that Lewis will need to offer advice to the department to ensure that they can discover an orientation. It can be seen how Krasnow has already made this shift less complicated by making Lewis obtain associated with the division a year before his actual departure. As per Bridges' Model, stage three will cause visibility to understanding, High power and also dedication as people will accept the modification (Bridges, 2004).

Maslow's Demand hierarchy: The OB problem related to insecurity at the work environment has been set off firstly by the adjustment in management as well as second of all by the reality that the merging will certainly no longer be started. Abraham Maslow in his Theory of 'Needs Hierarchy' (appendix 5) has talks about the value of 'security requires as being a lower level requirement of a human for causing motivation. As seen in the pyramid cooperated appendix 3, we can see exactly how 'the need to really feel secure and unharmed' is at the second degree of demands. Prior to an employee can be made to create emotionally, he needs to have his 'Physiological 'and also 'Security' requires satisfied. This indicates that unless the personnel are made to feel safe regarding their present work standing 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 numerous theories to comprehend how to cope with the present situation available. The complying with three options have actually been recommended to help Lewis handle the organizational difficulties in the advertising and marketing division. Each of these choices has been proposed for alleviating the change needed to bring the advertising and marketing department in line with the requirements of the marketplace and for making the social adjustment that would adhere to once the present leader leaves.

Combination of marketing and advertising functions. Dividing Adverting as well as Production functions. Combination of Advertising with Workflow.

Evaluation of Alternatives.

Assimilation of Advertising & Advertising Functions: The internal marketing firm of Descriptive Statistics In Microsoft Excel is currently strength for the organization in terms of conserving up on expenses related to marketing as well as promotion. Considering that no new employment has actually been done after Bridget Cole's separation with the coverage line being directly assigned to Krasnow for the advertising feature, this is a beneficial opportunity for incorporating the advertising and marketing functions. Judith Shapiro that has actually earlier been interviewed by Lewis during the earlier merger days has experience in business-to-business marketing in addition to agency as well as retail marketing experience. As soon as Krasnow leaves, Lewis can work with Shapiro as an EVP for advertising and marketing to handle both marketing and advertising features.

The benefit of this approach is that it will certainly incorporate both features while lowering the demand for working with an additional resource for advertising and marketing. In addition to this, Lewis would certainly be heading the marketing division as well as all the same her substitute would certainly be needed for the current function that she is carrying out. The disadvantage of this choice is that outside hiring might produce animosity from internal workers that may be eying the placement of EVP after Lewis takes control of Krasnow's position.

Separating Adverting and also Manufacturing: Provided the competitive stress and also top quality work needed from the ad agency, it is advised that Lewis must allow the production device to be a separate function from the marketing unit. Considering that the majority of ad agency had these 2 features as separate units, it makes even more feeling to comply with the norm. Both functions might be able to concentrate on their core turns on much more effectively. Nevertheless, the disadvantage of this technique would certainly be that additional costs would have to be birthed for setting up separate production functions. A production head may have to be worked with which might boost expenses for the company.

Assimilation of Advertising And Marketing with Operations: Because Lewis is currently looking after the advertising and marketing and also operations departments simultaneously; it makes sense to incorporate the two features since she has been successfully dealing with both ends. The reality that the two departments currently have major distinctions over allowance of resources recommends that this assimilation may be able to produce consistency particularly as Lewis would certainly be heading both ends.However there are different downsides of this relocation particularly as it would place excessive concern over Lewis's shoulders. The fact that Lewis has to adapt her management style for the marketing division suggests that these 2 departments would certainly be culturally diverse. In addition to this, Lewis may not have the ability to apply one kind of management style to both departments which might lead to inefficiency in either among both features.


An analysis of the 3 options suggests that integration of advertising and marketing as well as operations would certainly not be a possible action due to the large distinctions between the two departments in spite of the fact that presently Lewis is taking care of both. While splitting up of the manufacturing feature may have been a favorable relocation for the marketing division, the truth that it would certainly imply positioning a third function under Lewis's wing implies this ought to be avoided.

Action Plan.

Lewis will certainly take over the duty of EVP Advertising and marketing after Krasnow leaves.

Advertising and Marketing features would be merged.

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

Manufacturing function will stay part of advertising under advertising feature.

Lewis will certainly separate herself from procedures.

A democratic leadership style with staff member empowerment will be made use of in advertising and marketing division.

Open door plan as well as focus on cross department interaction will be aimed at removing discord.

Contingency strategy.

If the integration does not exercise as planned, a contingency strategy would adhere to which would certainly separate the production feature from the marketing feature to lower the tons on the SVP of marketing and advertising. In case Judith Shapiro does not obtain employed, Lewis will be heading the advertising division without an SVP. Because case the production feature will definitely be separated by putting it under an SVP manufacturing.