Introduction To Microsoft Excel Case Study Analysis


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

Introduction To Microsoft Excel Case Study Help

Background and Facts

Introduction To Microsoft Excel an office products retailer for little and also medium sized services has actually recently been involved in preparing for a merging with its competitor Home Deport, which has actually affected performance degrees in departmentswith the senior manager involved in legal problems presented by the government Profession Compensation. With the Advertising Head putting forward the news of his departure from the firm in one year, Jeannie Lewis, the existing head of procedures has actually been asked to take the duty in the future. With difficulties in the form of a possible social modification and low worker morale, the company wants a total reengineering effort at the advertising and marketing division.

Issue Declaration
Porter's 5 Forces Analysis
The prospective cultural modification at the marketing division of Introduction To Microsoft Excel is increasing unpredictability in the workplace leading to numerous difficulties for the Jeannie Lewis who would be replacing the head of the division in one year. nalysis

PEST analysis

Political Factors: Political factors play a significant function in affecting calculated choices considering that Stapes Inc. needed to abandon its plans of merging with Workplace Deport after the Federal Profession Compensation's intervention at the same time. Offered the fact that the store has a global existence with branches in UK, UNITED STATES, Canada and also Germany, political consider each of these countries might have the ability to influence performance or tactical objectives. Federal Profession Commission's antitrust suit versus the merger used up important time of the company's elderly management suggesting that 'political' factors can have severe implications for a worldwide company.

Economic Factors: Financial factors such as the development of small companies in the worldwide situation recommend that Introduction To Microsoft Excel is flourishing in an environment where there is potential development of businesses. In addition to this, reality that shop clients are mainly seeking office products for office recommends that the market has a rising pattern of entrepreneurs and also home based services.

Social factors: Social fads in the economic situation reveal that consumers are trying to find convenience along with attractive costs. Market research shows how the customer for Introduction To Microsoft Excel lacks awareness concerning finding services which can provide a combination of comfort as well as low costs.

Technical factors: Technology plays a crucial function in Introduction To Microsoft Excel's business approach specifically as the company is piloting Modern technology centers which would offer innovation sales and also assistance in the kind of memory upgrades, outer installations. (Recap of PEST in appendix 2).

OB Issues and also Effects.

Numerous underlying Business Actions problems can be seen in Introduction To Microsoft Excel's case as highlighted in this section.

Uneasiness concerning social modification: There is worry about a cultural modification that would certainly take place when Todd Krasnow leaves from his position as the Executive Vice President of Advertising And Marketing with a lot of the personnel already revealing unhappiness over this prospective move. This anticipated modification has produced stress and anxiety in the work environment which has been paired with the past tension of preparing the company for a prospective merging with Residence Deport.
Pest Analysis
Difficult Work Atmosphere for Newcomers: There is lack of employees that can match the stressful setting of a busy organization. Not only does this cause problem in locating the best people, it places stress and anxiety on brand-new hires as can not withstand the speed and also stress that the organization expects them to birth.

Dual Coverage Lines: Beginners discover this organizational society troublesome and also challenging to handle especially as populated line relationships are meant to be weak in general and also objective setup and efficiency examination is still done by the strong line manager. This suggests that beginners can shed clarity about their corresponding roles and also objectives particularly as populated line reporting does not maintain them in straight communication with the solid line supervisors.

Bitterness From Cross Departmental Hiring: Krasnow's decision to make Lewis his successor as opposed to Bridget Coles even though it had actually been hypothesized that the last would take Krasnow's placement came as a blow to her morale. Lewis might have been qualified and ideal for the task but the truth that Kransnow's separation would certainly make Coles a straight record to Lewis may have been the factor for Coles' resignation from solutions.

Concern & Work Insecurity: Concern as well as instability can be identified as two significant problems that Lewis would certainly be dealing with particularly as the merger has now be terminated and also two senior executives of the advertising and marketing department would certainly be leaving. The entire duty of the department would certainly be dropping on Lewis's shoulders that would not just be in charge of brining regarding a cultural adjustment but would certainly likewise have to prove herself in her new role.

Incompatible Management Design of Leader: Lewis's management style as well as its incompatibility with the advertising and marketing division's role can additionally be seen as an OB difficulty specifically as she has actually been used to handling issues in the operations division where employees are educated to concentrate on procedures and also obtain them. The advertising and marketing division on the other hand can be seen as a group of individuals who are utilized to being nurtured by Krasnow who focused much more on output than procedures.

Interdepartmental Arguments: Interdepartmental disputes in between three departments, advertising, merchandizing and operations respectively over the appropriation of the marketing mix can be identified as another OB problem. Although the marketing division does not share the very same vision as the various other 2 departments pertaining to the aloocation of the advertising and marketing mix twoards promotions as well as advertsing, the merchandizing and also procedures departments do not concur over the advertising mix appropriation amongst one another either.

Disintegration in Advertising And Marketing Department: Fragmentation between the marketing and advertising divisions can be identified as one more OB problem which can require additional interest. The fact that the marketing and advertising sections in the advertising and marketing division are disconnected is protecting against both departments from acquiring from each other's experience and knowledge. Integration of advertising with retailing as well as procedures would become harder if the advertising department itself is disintegrated which can be another possible OB worry.

Introduction To Microsoft Excel Analysis

Various concepts have actually been used to explain the scenarios to get additional quality regarding the circumstance available.
Swot Analysis
McGregor's Concept X & Y: According to Douglas McGregor's Theory X, many supervisors think that staffs are easy and also lazy, have little aspiration and also withstand modification. The difficult variation of this theory stressed browbeating, tight controls, dangers as well as penalties. Gradually it generates low productivity, refined sabotage and rivalry (Deal, 2003). The circumstance at Introduction To Microsoft Excel is not completely following Concept X, it can be seen that brand-new hires are discovering this atmosphere instead demanding which may eventually lead to a better inclination of the management in the direction of Theory X. Based on McGregor's promoted sight, which he called Concept Y, the necessary task of the management is to organize organizational conditions to make sure that individuals can attain their very own objectives best by routing their efforts in the direction of organizational rewards. If individuals discover no complete satisfaction in their work, the administration would have little option however to rely upon concept X as well as exterior control (Offer, 2003). Even while assessing Lewis's administration style, theory X might have appropriated in the procedures department to some extent but the Marketing department would certainly need reliance on Theory Y so as to get the creativity and also creativity from the teams.

Tuckman's Teamwork Theory: As much as Lewis's problem about bringing consistency in between the advertising as well as marketing division is concerned, this would initially lead to contrast as discussed by Bruce Tuckman in his 'Synergy Theory'. By combining the marketing as well as marketing division's work, there may be the exact same initial detach which could lead to the 2nd stage of 'storming' where the groups challenge one an additional.

When individuals are offered with change, they get in stage one and also so there may be feelings like unhappiness, uncertainty, irritation, rage, fear, denial and also disorientation.The scenario at the advertising and marketing department of Introduction To Microsoft Excel is similar so Lewis can obtain comfy with the idea that it is not remarkable behavior. It is throughout this phase that Lewis will certainly have to give advice to the department so that they can find a sense of direction. It can be seen just how Krasnow has currently made this shift less complicated by making Lewis obtain included in the division a year before his actual separation.
Vrio Analysis
Abraham Maslow in his Concept of 'Needs Power structure' (appendix 5) has goes over the value of 'protection needs as being a reduced level requirement of a human for causing inspiration. As seen in the pyramid shared in appendix 3, we can see how 'the requirement to feel protected and also out of risk' is at the 2nd level of requirements. Prior to a staff member can be made to develop emotionally, he requires to have his 'Physical 'and 'Safety and security' needs satisfied.

SWOT Analysis for Introduction To Microsoft Excel Case Study

Effects of Analysis.

The OB analysis has looked at numerous concepts to recognize how to deal with the present situation available. The following 3 alternatives have actually been proposed to assist Lewis manage the business difficulties in the advertising and marketing division. Each of these alternatives has actually been suggested for relieving the shift needed to bring the advertising and marketing division in line with the requirements of the marketplace and also for making the cultural adjustment that would certainly follow as soon as the present leader leaves.

Integration of marketing and advertising functions. Separating Adverting and also Production functions. Combination of Advertising And Marketing with Workflow.

Analysis of Alternatives.

Combination of Marketing & Advertising Functions: The internal advertising agency of Introduction To Microsoft Excel is currently toughness for the company in terms of conserving up on overheads connected to advertising and promo. Because no new employment has been done after Bridget Cole's separation with the reporting line being directly appointed to Krasnow for the marketing function, this is a positive possibility for integrating the marketing and advertising functions. Judith Shapiro who has actually earlier been interviewed by Lewis during the earlier merger days has expertise in business-to-business marketing in addition to company as well as retail advertising experience. Once Krasnow leaves, Lewis can hire Shapiro as an EVP for advertising and marketing to handle both advertising and marketing features.

The benefit of this strategy is that it will certainly incorporate the two functions while reducing the demand for employing an additional source for marketing. Lewis would certainly be heading the advertising department and in any kind of case her replacement would certainly be needed for the current role that she is performing. The negative aspect of this choice is that outside hiring might bring about resentment from internal employees that may be looking at the position of EVP after Lewis takes control of Krasnow's setting.

Separating Adverting as well as Manufacturing: Provided the affordable stress and also high quality work called for from the ad agency, it is recommended that Lewis must permit the manufacturing unit to be a different feature from the marketing device. Since many advertising agencies had these two functions as separate devices, it makes more sense to comply with the norm. Both features might be able to concentrate on their core turns on extra efficiently. The drawback of this method would be that added expenses would certainly have to be borne for establishing up different production features. A manufacturing head may have to be employed which might boost overheads for the organization.

Assimilation of Advertising And Marketing with Procedures: Given that Lewis is currently taking care of the advertising and also procedures departments concurrently; it makes feeling to integrate the 2 features considering that she has actually been efficiently taking care of both ends. The truth that Lewis has to adapt her administration style for the marketing department suggests that these 2 divisions would certainly be culturally varied.


An evaluation of the three options suggests that integration of marketing and also procedures would not be a viable move due to the large differences in between the 2 divisions regardless of the truth that presently Lewis is handling both. While separation of the manufacturing feature might have been a beneficial relocation for the marketing department, the reality that it would indicate putting a 3rd feature under Lewis's wing implies this need to be avoided.

Action Strategy.
Lewis will certainly take control of the role of EVP Advertising after Krasnow leaves.

Marketing and advertising features would be merged.

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

Manufacturing feature will remain part of advertising and marketing under marketing feature.

Lewis will certainly divide herself from procedures.

An autonomous management style with employee empowerment will certainly be used in advertising department.

Open up door plan as well as focus on cross departmental interaction will be aimed at getting rid of discord.

Backup plan.

If the assimilation does not work out as prepared, a contingency plan would certainly comply with which would separate the production feature from the marketing function to reduce the lots on the SVP of advertising and marketing. In case Judith Shapiro does not get hired, Lewis will be heading the advertising division without an SVP. In that case the production function will absolutely be divided by positioning it under an SVP production.