Descriptive Statistics In Microsoft Excel Case Study Analysis


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

Descriptive Statistics In Microsoft Excel Case Study Help

Background and Facts

Descriptive Statistics In Microsoft Excel an office supplies seller for tiny as well as average sized services has actually lately been associated with planning for a merging with its competitor Residence Deport, which has actually affected performance degrees in departmentswith the elderly manager involved in lawful difficulties presented by the government Profession Payment. With the Advertising Head putting forward the news of his departure from the business in one year, Jeannie Lewis, the present head of operations has actually been asked to take the role in the future. With obstacles in the form of a potential social change and also reduced employee spirits, the company needs a complete reengineering effort at the marketing division.

Trouble Statement
Porter's 5 Forces Analysis
The possible cultural modification at the advertising and marketing division of Descriptive Statistics In Microsoft Excel is boosting uncertainty in the workplace causing various obstacles for the Jeannie Lewis that would be changing the head of the department in one year. nalysis

PEST analysis

Political Factors: Political factors play a significant role in influencing calculated choices because Stapes Inc. needed to desert its strategies of combining with Office Deport after the Federal Profession Payment's treatment in the process. Offered the reality that the store has a worldwide existence with branches in UK, U.S.A., Canada and Germany, political factors in each of these nations may have the ability to impact performance or tactical objectives. Federal Trade Commission's antitrust suit against the merging used up useful time of the organization's elderly management recommending that 'political' factors can have serious ramifications for a global organisation.

Economic Factors: Financial factors such as the introduction of small companies in the global situation suggest that Descriptive Statistics In Microsoft Excel is growing in an atmosphere where there is prospective development of companies. Truth that shop clients are primarily looking for office products for house workplaces recommends that the market has a rising fad of entrepreneurs as well as house based organisations.

Social factors: Social fads in the economic situation show that consumers are seeking benefit in addition to eye-catching rates. Marketing research demonstrates how the client for Descriptive Statistics In Microsoft Excel lacks understanding regarding discovering services which can offer a combination of ease and inexpensive.

Technical factors: Modern technology plays an essential duty in Descriptive Statistics In Microsoft Excel's company strategy specifically as the organization is piloting Innovation centers which would use innovation sales and assistance in the kind of memory upgrades, outer installments. (Summary of PEST in appendix 2).

OB Issues and Manifestations.

A number of underlying Organizational Behavior issues can be seen in Descriptive Statistics In Microsoft Excel's case as highlighted in this section.

Apprehensions about cultural modification: There is concern regarding a cultural modification that would happen once Todd Krasnow leaves from his setting as the Exec Vice Head Of State of Advertising with the majority of the team member already showing discontent over this potential move. This anticipated change has developed stress in the workplace which has been coupled with the past tension of preparing the company for a possible merger with Residence Deport.
Pest Analysis
Difficult Job Atmosphere for Newcomers: There is scarcity of employees that can match the demanding setting of a fast-paced company. Not just does this lead to difficulty in locating the appropriate people, it puts tension on brand-new hires as can not stand up to the rate and pressure that the company expects them to bear.

Twin Reporting Lines: Beginners discover this business culture troublesome as well as hard to deal with specifically as dotted line relationships are suggested to be weak in general and unbiased setup and also efficiency evaluation is still done by the solid line supervisor. This means that newcomers could shed quality about their particular roles and goals particularly as populated line reporting does not maintain them in direct communication with the strong line managers.

Bitterness From Cross Departmental Hiring: Krasnow's decision to make Lewis his follower rather than Bridget Coles despite the fact that it had been speculated that the latter would take Krasnow's setting came as a strike to her spirits. Lewis might have been qualified and also ideal for the task but the fact that Kransnow's departure would certainly make Coles a straight report to Lewis may have been the reason for Coles' resignation from services.

Concern & Job Instability: Worry and instability can be determined as 2 significant issues that Lewis would be handling especially as the merging has actually now be terminated as well as 2 elderly execs of the advertising department would certainly be leaving. The whole responsibility of the department would certainly be dropping on Lewis's shoulders who would certainly not just supervise of brining about a social adjustment yet would certainly additionally have to show herself in her brand-new role.

Incompatible Management Design of Leader: Lewis's monitoring design and its conflict with the advertising division's duty can likewise be seen as an OB obstacle especially as she has actually been utilized to taking care of concerns in the operations department where employees are shown to focus on processes and also get them. The marketing department on the various other hand can be viewed as a team of individuals that are utilized to being nurtured by Krasnow who concentrated extra on result than processes.

Interdepartmental Arguments: Interdepartmental disagreements in between 3 departments, advertising and marketing, merchandizing and procedures specifically over the appropriation of the advertising mix can be recognized as another OB concern. Although the marketing division does not share the very same vision as the various other two departments relating to the aloocation of the advertising and marketing mix twoards promos and advertsing, the merchandizing and operations departments do not concur over the marketing mix allotment amongst each other either.

Fragmentation in Advertising Division: Disintegration between the advertising and marketing divisions can be determined as an additional OB issue which might require more interest. The reality that the advertising and marketing areas in the advertising and marketing division are detached is stopping both divisions from obtaining from each various other's experience as well as competence. Assimilation of marketing with retailing as well as operations would certainly become harder if the advertising division itself is broken down which can be another possible OB concern.

Descriptive Statistics In Microsoft Excel Analysis

Numerous concepts have actually been utilized to discuss the circumstances to obtain more quality regarding the situation handy.
Swot Analysis
McGregor's Theory X & Y: According to Douglas McGregor's Theory X, many managers think that staffs are easy as well as lazy, have little aspiration and resist modification. The situation at Descriptive Statistics In Microsoft Excel is not completely complying with Concept X, it can be seen that brand-new hires are discovering this atmosphere rather difficult which might eventually lead to a higher inclination of the monitoring towards Concept X. Also while assessing Lewis's monitoring design, concept X may have been ideal in the operations division to some level yet the Advertising department would call for dependence on Concept Y in order to get the creativity and also originality from the teams.

Tuckman's Team effort Theory: As far as Lewis's worry concerning bringing consistency in between the advertising and marketing department is worried, this would initially bring about conflict as discussed by Bruce Tuckman in his 'Synergy Theory'. (Tuckman, 1965). Based on Tuckman's theory shown in appendix 3, throughout the first stage of team development, people may not bond, as they are hectic finding their area in the team. By combining the marketing and advertising division's job, there might be the same first detach which might result in the 2nd stage of 'storming' where the teams test each other. It is just throughout the third phase or 'norming' when they would certainly come with each other to share concepts before the group can bring around harmony in the 4th stage 'carrying out'.

Bridges' Shift Model: Based On William Bridge's concept (appendix 4), individuals are quite uneasy with change, which is evident by the scenario at Descriptive Statistics In Microsoft Excel The situation can be viewed as a regular training course of life if is examined according to Bridge's concept where he describes that people go through three phases of transition when they experience adjustment. 'Ending, losing and also Releasing', The Neutral Zone and 'The New Starting' (Bridges, 2004). When people exist with adjustment, they go into stage one therefore there may be feelings like unhappiness, uncertainty, irritation, anger, anxiety, denial and disorientation.The circumstance at the marketing department of Descriptive Statistics In Microsoft Excel is similar so Lewis can obtain comfortable with the concept that it is not extraordinary behavior. In the second phase, there might be a need to connect the gap between the brand-new and also old society so Lewis might need to face this ordeal as soon as Krasnow leaves. There may be low spirits and low efficiency at this phase which should not be taken as a trouble. It is throughout this phase that Lewis will certainly need to give guidance to the division so that they can discover a sense of direction. It can be seen how Krasnow has actually currently made this transition simpler by making Lewis obtain involved in the division a year prior to his real separation. As per Bridges' Version, stage 3 will certainly cause visibility to understanding, High energy as well as dedication as people will certainly accept the change (Bridges, 2004).
Vrio Analysis
Maslow's Demand hierarchy: The OB issue related to instability at the workplace has been set off first of all by the modification in monitoring and second of all by the reality that the merging will certainly no longer be initiated. Abraham Maslow in his Concept of 'Demands Pecking order' (appendix 5) has discusses the value of 'protection needs as being a lower degree need of a human for causing motivation. As seen in the pyramid shared in appendix 3, we can see just how 'the demand to feel safe and secure and also out of danger' goes to the 2nd degree of requirements. Before a staff member can be made to create emotionally, he needs to have his 'Physiological 'and 'Safety and security' requires satisfied. This indicates that unless the workers are made to feel safe and secure about 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

Implication of Analysis.

The OB analysis has checked out various theories to understand how to handle the current situation handy. The complying with 3 choices have actually been suggested to aid Lewis deal with the business obstacles in the marketing department. Each of these options has actually been suggested for easing the change required to bring the marketing division in line with the requirements of the market and for making the cultural adjustment that would certainly follow when the current leader leaves.

Assimilation of marketing and advertising functions. Dividing Adverting and also Production features. Assimilation of Advertising And Marketing with Procedures.

Assessment of Alternatives.

Judith Shapiro that has actually earlier been interviewed by Lewis during the earlier merging days has expertise in business-to-business advertising along with firm as well as retail advertising and marketing experience. Once Krasnow leaves, Lewis can hire Shapiro as an EVP for advertising to handle both advertising and also marketing features.

The benefit of this method is that it will integrate both features while reducing the demand for working with an added source for marketing. Lewis would certainly be heading the advertising and marketing division and also in any case her substitute would certainly be needed for the current role that she is performing. The negative aspect of this alternative is that exterior hiring might bring about resentment from interior personnel who may be looking at the setting of EVP after Lewis takes over Krasnow's position.

Separating Adverting and also Production: Given the competitive stress as well as high top quality job required from the advertising firm, it is suggested that Lewis should permit the production device to be a separate feature from the advertising system. Because a lot of advertising and marketing agencies had these 2 functions as separate devices, it makes more feeling to adhere to the standard.

Combination of Advertising with Operations: Considering that Lewis is currently taking treatment of the advertising and operations divisions at the same time; it makes feeling to integrate the 2 features given that she has actually been effectively taking care of both ends. The reality that Lewis has to adapt her management style for the marketing department suggests that these 2 divisions would be culturally diverse.


An evaluation of the three choices shows that combination of advertising as well as operations would certainly not be a practical step due to the vast differences in between the two divisions although that currently Lewis is managing both. While separation of the manufacturing function might have been a favorable move for the advertising division, the fact that it would certainly imply placing a 3rd feature under Lewis's wing suggests this need to be prevented. The combination of the advertising and marketing division is the very best choice in regards to getting the ideal results from the division. An activity prepare for this option is reviewed listed below.

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

Marketing and advertising features would be combined.

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

Production function will stay part of marketing under advertising and marketing feature.

Lewis will certainly divide herself from procedures.

An autonomous management design with employee empowerment will be made use of in advertising and marketing division.

Open door plan and also emphasis on cross department communication will certainly be aimed at removing dissonance.

Backup strategy.

If the assimilation does not exercise as prepared, a backup strategy would follow which would separate the production function from the advertising and marketing feature to lower the lots on the SVP of advertising and marketing. In case Judith Shapiro does not get worked with, Lewis will be heading the advertising and marketing division without an SVP. Because case the manufacturing function will most definitely be separated by placing it under an SVP production.