Introduction To Microsoft Excel Case Study Help


Home >> Kelloggs >> Introduction To Microsoft Excel >>

Introduction To Microsoft Excel Case Study Help

Background and Facts

Introduction To Microsoft Excel an office materials merchant for tiny as well as medium sized services has lately been involved in planning for a merging with its competitor Residence Deport, which has actually impacted effectiveness levels in departmentswith the senior supervisor involved in legal problems presented by the federal Profession Commission. With the Advertising Head advancing the news of his separation from the business in one year, Jeannie Lewis, the present head of operations has actually been asked to take the duty in the future. With challenges in the type of a potential cultural modification and also low staff member morale, the organization needs a total reengineering initiative at the advertising and marketing department.

Problem Statement

The possible social adjustment at the advertising and marketing division of Introduction To Microsoft Excel is boosting uncertainty in the working environment leading to different difficulties for the Jeannie Lewis who would be changing the head of the department in one year. nalysis

PEST analysis

Political Factors: Political factors play a significant function in influencing critical choices given that Stapes Inc. had to desert its plans of combining with Workplace Deport after the Federal Profession Payment's treatment in the process. Offered the fact that the shop has a global visibility with branches in UK, U.S.A., Canada and also Germany, political factors in each of these countries might have the ability to impact performance or tactical objectives. Federal Trade Payment's antitrust suit versus the merging took up valuable time of the organization's elderly management recommending that 'political' factors can have severe ramifications for an international service.

Economic Factors: Financial factors such as the emergence of small businesses in the worldwide circumstance recommend that Introduction To Microsoft Excel is prospering in a setting where there is possible growth of organisations. In addition to this, truth that store customers are mainly looking for office products for office suggests that the market has an increasing fad of entrepreneurs and also online companies.

Social factors: Social trends in the economic climate reveal that clients are searching for comfort in addition to eye-catching costs. Market research shows how the client for Introduction To Microsoft Excel lacks recognition regarding locating remedies which can supply a mix of benefit and inexpensive.

Technological factors: Technology plays an important role in Introduction To Microsoft Excel's business method especially as the company is piloting Modern technology centers which would certainly supply technology sales as well as support in the kind of memory upgrades, outer installments. (Summary of PEST in appendix 2).

OB Issues and also Effects.

A number of underlying Business Behavior issues can be seen in Introduction To Microsoft Excel's case as highlighted in this area.

Uneasiness about social change: There is concern regarding a cultural adjustment that would take place once Todd Krasnow leaves from his setting as the Exec Vice Head Of State of Advertising with most of the team member already revealing discontent over this potential move. This expected adjustment has actually developed stress and anxiety in the office which has been paired with the previous stress of preparing the firm for a possible merging with Residence Deport.

Demanding Task Atmosphere for Newcomers: There is scarcity of workers that can match the demanding setting of a busy company. Not only does this cause difficulty in discovering the best individuals, it puts stress and anxiety on brand-new hires as can not hold up against the speed as well as pressure that the organization expects them to bear.

Twin Reporting Lines: Beginners locate this business society troublesome as well as difficult to cope with specifically as dotted line partnerships are indicated to be weaker in general as well as objective setting as well as performance examination is still done by the solid line supervisor. This indicates that novices can shed quality concerning their respective functions and also purposes specifically as populated line coverage does not maintain them in straight interaction with the solid line managers.

Bitterness From Cross Departmental Hiring: Krasnow's choice to make Lewis his follower rather than Bridget Coles even though it had actually been hypothesized that the latter would certainly take Krasnow's setting came as an impact to her spirits. Lewis might have been capable and appropriate for the task but the truth that Kransnow's departure would certainly make Coles a straight report to Lewis might have been the factor for Coles' resignation from solutions.

Anxiety & Work Instability: Concern and also instability can be recognized as two major problems that Lewis would certainly be handling especially as the merging has actually currently be terminated and 2 senior execs of the advertising division would be leaving. The whole obligation of the division would certainly be falling on Lewis's shoulders that would not just supervise of brining regarding a social adjustment but would likewise need to verify herself in her brand-new role.

Incompatible Administration Design of Leader: Lewis's management style and its conflict with the marketing department's role can also be seen as an OB obstacle especially as she has been used to taking care of issues in the operations division where personnel are instructed to concentrate on procedures as well as obtain them. The advertising and marketing department on the various other hand can be seen as a group of people that are made use of to being supported by Krasnow that concentrated more on outcome than processes.

Interdepartmental Disagreements: Interdepartmental differences between three divisions, advertising and marketing, merchandizing as well as operations respectively over the allowance of the advertising mix can be recognized as an additional OB concern. Although the marketing division does not share the exact same vision as the other two divisions pertaining to the aloocation of the advertising and marketing mix twoards promotions as well as advertsing, the merchandizing and also operations departments do not agree over the advertising and marketing mix allocation amongst each other either.

Fragmentation in Advertising Department: Disintegration between the advertising and marketing divisions can be recognized as an additional OB problem which could need additional focus. The reality that the advertising and marketing areas in the advertising division are disconnected is preventing both departments from obtaining from each other's experience as well as know-how. Combination of advertising and marketing with retailing and also procedures would come to be more difficult if the advertising and marketing department itself is broken down which can be another possible OB concern.

Introduction To Microsoft Excel Analysis

Various theories have been used to explain the situations to get additional quality concerning the circumstance available.

McGregor's Concept X & Y: According to Douglas McGregor's Concept X, many managers think that juniors are easy and also lazy, have little aspiration as well as resist adjustment. The scenario at Introduction To Microsoft Excel is not completely complying with Theory X, it can be seen that new hires are finding this environment rather stressful which might ultimately lead to a better inclination of the administration towards Concept X. Even while examining Lewis's administration design, theory X might have been appropriate in the operations department to some level but the Advertising department would certainly call for dependence on Theory Y in order to obtain the creative thinking and also originality from the groups.

Tuckman's Teamwork Concept: As for Lewis's concern regarding bringing harmony in between the advertising and marketing division is worried, this would at first bring about contrast as gone over by Bruce Tuckman in his 'Teamwork Concept'. (Tuckman, 1965). Based on Tuckman's concept shown in appendix 3, throughout the first phase of team growth, people might not bond, as they are hectic finding their area in the team. By incorporating the marketing and advertising department's work, there may coincide initial separate which can result in the second stage of 'storming' where the groups challenge one another. Nonetheless, it is just throughout the 3rd stage or 'norming' when they would certainly integrate to share ideas before the group can cause harmony in the 4th phase 'carrying out'.

When people are offered with change, they get in stage one and so there might be emotions like despair, unpredictability, frustration, anger, anxiety, rejection as well as disorientation.The circumstance at the marketing division of Introduction To Microsoft Excel is similar so Lewis can obtain comfy with the suggestion that it is not extraordinary habits. It is during this stage that Lewis will have to offer guidance to the department so that they can locate a sense of instructions. It can be seen just how Krasnow has actually currently made this change much easier by making Lewis get entailed in the department a year before his real departure.

Abraham Maslow in his Concept of 'Needs Pecking order' (appendix 5) has goes over the value of 'protection needs as being a lower degree demand of a human for causing inspiration. As seen in the pyramid shared in appendix 3, we can see just how 'the need to feel protected and out of danger' is at the 2nd degree of needs. Prior to a staff member can be made to develop psychologically, he needs to have his 'Physiological 'as well as 'Security' requires met.

SWOT Analysis for Introduction To Microsoft Excel Case Study

Effects of Analysis.

The OB analysis has considered numerous concepts to understand just how to deal with the current scenario available. The adhering to three choices have actually been proposed to assist Lewis manage the business difficulties in the marketing division. Each of these alternatives has been proposed for alleviating the transition needed to bring the advertising department in accordance with the needs of the market and for making the cultural change that would certainly comply with when the present leader leaves.

Combination of advertising and marketing functions. Separating Adverting and also Manufacturing functions. Combination of Marketing with Workflow.

Assessment of Alternatives.

Assimilation of Advertising And Marketing & Advertising Functions: The in-house advertising and marketing firm of Introduction To Microsoft Excel is currently toughness for the organization in regards to saving up on expenses associated with marketing and promotion. Because no new employment has actually been done after Bridget Cole's separation with the coverage line being directly appointed to Krasnow for the marketing function, this is a favorable opportunity for incorporating the marketing and advertising features. Judith Shapiro who has actually earlier been talked to by Lewis during the earlier merging days has expertise in business-to-business marketing together with firm as well as retail advertising experience. As soon as Krasnow leaves, Lewis can employ Shapiro as an EVP for advertising to handle both marketing and advertising functions.

The benefit of this method is that it will certainly incorporate the two functions while lowering the requirement for employing an added resource for advertising and marketing. Lewis would be heading the advertising department and also in any case her substitute would certainly be required for the present duty that she is carrying out. The disadvantage of this choice is that external hiring may cause animosity from inner employees who may be looking at the placement of EVP after Lewis takes over Krasnow's placement.

Dividing Adverting and Production: Given the competitive pressures and high quality work needed from the advertising firm, it is recommended that Lewis needs to enable the production system to be a separate function from the advertising unit. Because a lot of advertising and marketing companies had these 2 features as different devices, it makes more sense to comply with the standard.

Combination of Marketing with Operations: Given that Lewis is currently taking care of the advertising and marketing and operations divisions concurrently; it makes sense to incorporate the two features since she has actually been effectively taking treatment of both ends. The fact that Lewis has to adjust her administration design for the advertising division recommends that these two divisions would be culturally varied.


An analysis of the 3 options indicates that integration of marketing and operations would not be a feasible action due to the substantial differences in between the two divisions despite the reality that presently Lewis is taking care of both. While splitting up of the production feature may have been a beneficial move for the advertising and marketing division, the truth that it would certainly mean placing a 3rd function under Lewis's wing suggests this ought to be avoided.

Action Plan.

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

Marketing and advertising features would certainly be combined.

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

Manufacturing feature will stay component of advertising under advertising and marketing feature.

Lewis will certainly divide herself from operations.

An autonomous leadership design with staff member empowerment will be utilized in advertising and marketing division.

Open up door policy and also focus on cross departmental interaction will be aimed at eliminating disharmony.

Backup strategy.

If the combination does not exercise as intended, a contingency plan would certainly comply with which would certainly separate the production feature from the marketing feature to decrease the load on the SVP of advertising and marketing. In case Judith Shapiro does not get worked with, Lewis will be heading the advertising division without an SVP. Because case the production feature will absolutely be separated by positioning it under an SVP manufacturing.