Introduction To Microsoft Excel Case Study Help


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

Introduction To Microsoft Excel Case Study Solution

Background and Facts

Introduction To Microsoft Excel an office materials merchant for small as well as medium sized organisations has just recently been involved in planning for a merger with its rival House Deport, which has actually influenced efficiency levels in departmentswith the elderly supervisor associated with lawful difficulties presented by the federal Trade Commission. With the Advertising and marketing Head putting forward the news of his departure from the firm in one year, Jeannie Lewis, the current head of operations has actually been asked to take the duty in the future. With obstacles in the form of a potential cultural modification and also low employee morale, the company is in need of a full reengineering initiative at the advertising and marketing department.

Issue Declaration
Porter's 5 Forces Analysis
The possible social change at the advertising and marketing department of Introduction To Microsoft Excel is enhancing uncertainty in the workplace resulting in different obstacles for the Jeannie Lewis who would be replacing the head of the department in one year. nalysis

PEST analysis

Political Factors: Political factors play a significant function in impacting calculated choices considering that Stapes Inc. needed to desert its plans of combining with Workplace Deport after the Federal Trade Commission's treatment in the process. Offered the truth that the shop has an international existence with branches in UK, USA, Canada and also Germany, political consider each of these countries might be able to impact performance or strategic goals. Federal Trade Commission's antitrust fit versus the merger occupied important time of the company's elderly monitoring suggesting that 'political' factors can have major ramifications for a worldwide company.

Economic Factors: Economic factors such as the appearance of small businesses in the worldwide situation recommend that Introduction To Microsoft Excel is prospering in an atmosphere where there is prospective growth of businesses. Along with this, fact that store consumers are mostly trying to find office products for home offices suggests that the market has a rising trend of entrepreneurs as well as online businesses.

Social factors: Social fads in the economic situation show that clients are looking for convenience in addition to eye-catching rates. Market research demonstrates how the client for Introduction To Microsoft Excel does not have understanding regarding discovering solutions which can supply a mix of ease and low costs.

Technological factors: Technology plays an important duty in Introduction To Microsoft Excel's organisation method especially as the organization is piloting Technology facilities which would offer modern technology sales as well as assistance in the type of memory upgrades, outer installments. (Summary of PARASITE in appendix 2).

OB Issues as well as Manifestations.

Several underlying Business Behavior concerns can be seen in Introduction To Microsoft Excel's case as highlighted in this area.

Apprehensions regarding social modification: There is apprehension about a cultural modification that would occur when Todd Krasnow leaves from his placement as the Executive Vice Head Of State of Advertising with most of the employee already revealing unhappiness over this prospective move. This predicted modification has created anxiety in the office which has been paired with the previous stress of preparing the company for a potential merging with House Deport.
Pest Analysis
Demanding Work Setting for Newcomers: There is shortage of workers that can match the demanding atmosphere of a hectic organization. Not just does this result in problem in locating the best individuals, it places tension on new hires as can not endure the pace as well as stress that the company anticipates them to bear.

Dual Reporting Lines: Newcomers find this organizational society troublesome and also hard to manage especially as populated line connections are indicated to be weak as a whole and unbiased setup as well as performance assessment is still done by the solid line manager. This indicates that beginners could lose quality concerning their particular duties as well as goals particularly as dotted line coverage does not maintain them in direct interaction with the solid line supervisors.

Bitterness From Cross Departmental Hiring: Krasnow's choice to make Lewis his follower instead of Bridget Coles even though it had been guessed that the latter would certainly take Krasnow's setting came as a blow to her morale. Lewis may have been capable and proper for the job however the fact that Kransnow's separation would certainly make Coles a straight report to Lewis might have been the factor for Coles' resignation from services.

Worry & Work Instability: Fear as well as instability can be identified as 2 major concerns that Lewis would be managing specifically as the merging has currently be terminated and also two senior execs of the advertising department would certainly be leaving. The whole responsibility of the division would certainly be dropping on Lewis's shoulders that would certainly not simply be in charge of brining about a social modification but would certainly also have to show herself in her brand-new duty.

Inappropriate Monitoring Design of Leader: Lewis's management design as well as its incompatibility with the advertising department's duty can additionally be seen as an OB difficulty particularly as she has actually been used to managing problems in the procedures division where personnel are taught to concentrate on processes as well as obtain them. The advertising and marketing division on the various other hand can be seen as a group of individuals that are made use of to being nurtured by Krasnow that concentrated extra on result than procedures.

Interdepartmental Differences: Interdepartmental disagreements between three departments, advertising and marketing, merchandizing as well as procedures respectively over the allocation of the advertising and marketing mix can be determined as another OB issue. The advertising department does not share the exact same vision as the various other two divisions pertaining to the aloocation of the advertising mix twoards promotions as well as advertsing, the merchandizing and procedures departments do not concur over the advertising and marketing mix appropriation among one another either.

Fragmentation in Advertising Department: Fragmentation in between the advertising and marketing departments can be determined as an additional OB issue which might require more focus. The reality that the marketing and advertising sections in the marketing division are separated is stopping both departments from getting from each other's experience and also proficiency. Assimilation of advertising with retailing and operations would become harder if the advertising and marketing department itself is broken down which can be one more prospective OB concern.

Introduction To Microsoft Excel Analysis

Different concepts have been made use of to clarify the conditions to obtain further clarity concerning the scenario available.
Swot Analysis
McGregor's Concept X & Y: According to Douglas McGregor's Theory X, many managers think that subordinates are easy and also careless, have little passion and withstand modification. The situation at Introduction To Microsoft Excel is not entirely following Concept X, it can be seen that new hires are finding this atmosphere instead stressful which might ultimately lead to a higher inclination of the administration towards Theory X. Also while assessing Lewis's management style, concept X might have been appropriate in the procedures department to some extent but the Marketing division would need dependence on Theory Y in order to obtain the imagination as well as creativity from the groups.

Tuckman's Team effort Concept: As much as Lewis's problem concerning bringing harmony between the advertising as well as advertising and marketing department is concerned, this would originally lead to conflict as discussed by Bruce Tuckman in his 'Synergy Theory'. By incorporating the advertising and marketing and also marketing division's work, there might be the very same initial disconnect which could lead to the second stage of 'storming' where the groups challenge one another.

When individuals are offered with modification, they get in phase one as well as so there may be feelings like despair, uncertainty, frustration, anger, concern, denial and also disorientation.The circumstance at the advertising division of Introduction To Microsoft Excel is comparable so Lewis can obtain comfortable with the concept that it is not phenomenal behavior. It is throughout this stage that Lewis will certainly have to give guidance to the division so that they can locate a sense of instructions. It can be seen how Krasnow has actually currently made this shift less complicated by making Lewis obtain entailed in the division a year prior to his actual separation.
Vrio Analysis
Abraham Maslow in his Concept of 'Requirements Pecking order' (appendix 5) has discusses the significance of 'safety requires as being a reduced level demand of a human for activating inspiration. As seen in the pyramid shared in appendix 3, we can see just how 'the requirement to feel secure as well as out of risk' is at the 2nd degree of needs. Before a staff member can be made to develop psychologically, he requires to have his 'Physiological 'and 'Safety and security' requires met.

SWOT Analysis for Introduction To Microsoft Excel Case Study

Implication of Analysis.

The OB analysis has actually checked out different theories to comprehend just how to handle the current scenario at hand. The following three alternatives have actually been suggested to help Lewis take care of the business difficulties in the advertising division. Each of these alternatives has been suggested for easing the shift required to bring the advertising department according to the needs of the marketplace and also for making the cultural modification that would follow as soon as the existing leader leaves.

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

Evaluation of Alternatives.

Assimilation of Advertising & Advertising Functions: The internal advertising and marketing agency of Introduction To Microsoft Excel is already strength for the company in regards to saving up on expenses related to marketing and also promo. Since no brand-new employment has actually been done after Bridget Cole's departure with the reporting line being straight designated to Krasnow for the marketing function, this is a favorable chance for integrating the marketing and advertising functions. Judith Shapiro who has actually earlier been spoken with by Lewis during the earlier merger days has experience in business-to-business advertising and marketing along with agency and also retail marketing experience. As soon as Krasnow leaves, Lewis can hire Shapiro as an EVP for advertising and marketing to manage both marketing and advertising functions.

The advantage of this technique is that it will certainly incorporate the two functions while lowering the demand for working with an additional resource for advertising and marketing. In addition to this, Lewis would certainly be heading the advertising department as well as all the same her substitute would be required for the present role that she is carrying out. The drawback of this option is that external hiring may bring about resentment from internal employees that might be considering the placement of EVP after Lewis takes control of Krasnow's position.

Dividing Adverting and also Manufacturing: Given the affordable pressures and also premium quality work needed from the advertising agency, it is recommended that Lewis should permit the production device to be a different feature from the advertising device. Because many advertising agencies had these 2 functions as separate devices, it makes even more sense to comply with the norm. In addition to this, both functions might be able to focus on their core activates extra successfully. However, the negative aspect of this technique would be that added expenses would certainly have to be birthed for setting up separate production functions. Along with this, a production head may have to be worked with which could enhance overheads for the company.

Integration of Marketing with Procedures: Considering that Lewis is currently taking care of the advertising and procedures departments simultaneously; it makes feeling to integrate the 2 functions given that she has been effectively taking care of both ends. The reality that Lewis has to adjust her monitoring design for the marketing department suggests that these two departments would certainly be culturally varied.


An assessment of the three alternatives shows that integration of advertising and operations would not be a viable move as a result of the vast distinctions between the two departments although that currently Lewis is handling both. While splitting up of the production function may have been a beneficial action for the marketing division, the truth that it would mean putting a third function under Lewis's wing suggests this need to be prevented. The combination of the advertising division is the best choice in terms of getting the ideal arise from the department. An activity prepare for this alternative is discussed below.

Activity Plan.
Lewis will take over the role of EVP Advertising after Krasnow leaves.

Advertising and Marketing functions would certainly be merged.

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

Manufacturing feature will continue to be component of advertising under advertising and marketing function.

Lewis will certainly separate herself from procedures.

A democratic management design with employee empowerment will be utilized in advertising and marketing division.

Open up door plan as well as focus on cross departmental communication will certainly be focused on eliminating disharmony.

Contingency plan.

If the integration does not exercise as intended, a contingency strategy would certainly comply with which would separate the production function from the advertising function to reduce the load on the SVP of advertising and marketing. In case Judith Shapiro does not get hired, Lewis will certainly be heading the marketing division without an SVP. In that case the manufacturing function will most definitely be divided by putting it under an SVP manufacturing.