Advanced Logic Functions In Microsoft Excel Case Study Help


Home >> Kelloggs >> Advanced Logic Functions In Microsoft Excel >>

Advanced Logic Functions In Microsoft Excel Case Study Analysis

Background and Facts

Advanced Logic Functions In Microsoft Excel a workplace materials seller for small and medium sized companies has just recently been involved in planning for a merging with its competitor Residence Deport, which has influenced effectiveness levels in departmentswith the elderly supervisor associated with legal difficulties put forth by the federal Trade Compensation. With the Advertising and marketing Head advancing the news of his separation from the firm in one year, Jeannie Lewis, the existing head of procedures has been asked to take the function in the future. With difficulties in the kind of a possible cultural modification as well as low staff member morale, the company wants a complete reengineering initiative at the marketing department.

Trouble Statement
Porter's 5 Forces Analysis
The prospective cultural modification at the marketing division of Advanced Logic Functions In Microsoft Excel is increasing uncertainty in the working environment causing various challenges for the Jeannie Lewis that would certainly be changing the head of the department in one year. nalysis

PEST analysis

Political Factors: Political factors play a significant duty in affecting calculated choices considering that Stapes Inc. needed to abandon its plans of combining with Office Deport after the Federal Profession Payment's intervention in the process. Given the truth that the store has a worldwide existence with branches in UK, U.S.A., Canada and Germany, political factors in each of these countries might be able to influence performance or critical goals. Federal Trade Commission's antitrust fit versus the merging took up important time of the organization's senior management suggesting that 'political' factors can have major ramifications for a worldwide service.

Economic Factors: Economic factors such as the development of small businesses in the global circumstance recommend that Advanced Logic Functions In Microsoft Excel is growing in an atmosphere where there is possible growth of services. Along with this, fact that store customers are mainly trying to find workplace materials for office suggests that the market has a rising pattern of business owners and home based businesses.

Social factors: Social fads in the economy reveal that clients are searching for comfort along with attractive rates. Marketing research demonstrates how the customer for Advanced Logic Functions In Microsoft Excel does not have recognition regarding locating remedies which can offer a combination of convenience and also affordable.

Technological factors: Modern technology plays a vital duty in Advanced Logic Functions In Microsoft Excel's company approach particularly as the company is piloting Technology facilities which would certainly offer modern technology sales and support in the form of memory upgrades, peripheral installments. (Recap of PEST in appendix 2).

OB Issues and also Effects.

Several underlying Organizational Habits concerns can be seen in Advanced Logic Functions In Microsoft Excel's case as highlighted in this area.

Uneasiness about social modification: There is apprehension regarding a social modification that would take place once Todd Krasnow leaves from his position as the Executive Vice Head Of State of Marketing with the majority of the staff members currently showing discontent over this possible move. This anticipated modification has developed tension in the workplace which has actually been coupled with the previous anxiety of preparing the firm for a prospective merger with House Deport.
Pest Analysis
Stressful Task Atmosphere for Newcomers: There is lack of workers that can match the stressful environment of a busy company. Not just does this result in difficulty in discovering the ideal people, it puts stress and anxiety on brand-new hires as can not stand up to the pace as well as stress that the organization anticipates them to bear.

Dual Reporting Lines: Beginners find this organizational culture troublesome as well as hard to deal with particularly as dotted line connections are implied to be weaker as a whole as well as objective setup and efficiency evaluation is still done by the strong line supervisor. This implies that novices could lose quality regarding their corresponding functions as well as goals particularly as dotted line coverage does not maintain them in straight communication with the strong line managers.

Bitterness From Cross Departmental Hiring: Krasnow's choice to make Lewis his follower instead of Bridget Coles although it had actually been speculated that the last would take Krasnow's setting came as a blow to her morale. Lewis might have been capable and also proper for the task yet the reality that Kransnow's separation would certainly make Coles a straight report to Lewis might have been the reason for Coles' resignation from solutions.

Worry & Work Insecurity: Anxiety and also insecurity can be identified as two significant concerns that Lewis would certainly be managing specifically as the merger has actually now be terminated and also 2 senior executives of the advertising division would be leaving. The entire obligation of the division would certainly be falling on Lewis's shoulders who would certainly not simply supervise of brining regarding a cultural adjustment yet would certainly additionally have to verify herself in her new role.

Inappropriate Monitoring Design of Leader: Lewis's administration design as well as its conflict with the marketing department's duty can also be viewed as an OB obstacle particularly as she has actually been used to handling issues in the operations department where workers are educated to concentrate on procedures and also obtain them right. The advertising division on the other hand can be seen as a team of individuals who are utilized to being nurtured by Krasnow that concentrated more on result than procedures.

Interdepartmental Differences: Interdepartmental disagreements in between three departments, advertising, merchandizing and operations specifically over the allowance of the advertising and marketing mix can be recognized as an additional OB problem. The advertising division does not share the same vision as the various other 2 departments relating to the aloocation of the marketing mix twoards promotions and also advertsing, the merchandizing and also procedures departments do not concur over the advertising and marketing mix appropriation among one an additional either.

Fragmentation in Advertising And Marketing Division: Fragmentation in between the marketing and advertising divisions can be determined as one more OB issue which could require additional interest. The fact that the advertising and marketing areas in the marketing division are detached is protecting against both departments from obtaining from each various other's experience and know-how. Assimilation of advertising with merchandising and also procedures would certainly come to be more difficult if the advertising and marketing department itself is disintegrated which can be an additional prospective OB problem.

Advanced Logic Functions In Microsoft Excel Analysis

Different concepts have been used to explain the scenarios to obtain further clarity concerning the scenario available.
Swot Analysis
McGregor's Concept X & Y: According to Douglas McGregor's Concept X, many managers think that juniors are passive as well as careless, have little aspiration and withstand modification. The difficult version of this theory stressed coercion, limited controls, threats as well as penalties. Over time it produces low productivity, subtle sabotage and competition (Bargain, 2003). Although the scenario at Advanced Logic Functions In Microsoft Excel is not completely following Theory X, it can be seen that brand-new hires are discovering this environment rather demanding which may ultimately lead to a higher inclination of the monitoring towards Concept X. As per McGregor's supported view, which he called Theory Y, the essential job of the administration is to organize business problems to ensure that people can achieve their own goals best by directing their efforts towards organizational rewards. If people discover no complete satisfaction in their work, the management would have little option yet to count on theory X and also exterior control (Bargain, 2003). Also while examining Lewis's management style, concept X might have appropriated in the operations department somewhat however the Advertising division would certainly need dependence on Concept Y to get the creativity and creativity from the groups.

Tuckman's Team effort Theory: As far as Lewis's issue concerning bringing harmony in between the advertising and marketing as well as advertising division is concerned, this would at first lead to contrast as talked about by Bruce Tuckman in his 'Synergy Concept'. By integrating the advertising as well as marketing division's job, there might be the same first separate which can lead to the 2nd phase of 'storming' where the groups test one an additional.

When individuals are presented with change, they get in phase one and so there might be feelings like unhappiness, unpredictability, irritation, temper, worry, denial and disorientation.The circumstance at the advertising and marketing department of Advanced Logic Functions In Microsoft Excel is comparable so Lewis can obtain comfortable with the idea that it is not remarkable behavior. It is during this stage that Lewis will certainly have to give support to the division so that they can locate a sense of direction. It can be seen how Krasnow has already made this shift simpler by making Lewis obtain included in the department a year prior to his actual separation.
Vrio Analysis
Abraham Maslow in his Theory of 'Demands Power structure' (appendix 5) has reviews the significance of 'safety requires as being a reduced level requirement of a human for triggering inspiration. As seen in the pyramid shared in appendix 3, we can see how 'the requirement to feel protected as well as out of risk' is at the 2nd degree of needs. Before a staff member can be made to create emotionally, he needs to have his 'Physiological 'and also 'Safety and security' needs fulfilled.

SWOT Analysis for Advanced Logic Functions In Microsoft Excel Case Study

Implication of Analysis.

The OB analysis has checked out different theories to recognize exactly how to deal with the present circumstance at hand. The complying with 3 choices have actually been proposed to help Lewis take care of the organizational difficulties in the advertising and marketing department. Each of these options has been suggested for relieving the shift required to bring the advertising division in line with the needs of the marketplace and for making the social change that would comply with as soon as the present leader leaves.

Integration of advertising and marketing functions. Dividing Adverting as well as Manufacturing functions. Combination of Advertising And Marketing with Workflow.

Evaluation of Alternatives.

Integration of Advertising And Marketing & Marketing Functions: The in-house advertising and marketing firm of Advanced Logic Functions In Microsoft Excel is currently stamina for the organization in regards to conserving up on overheads related to advertising and marketing and promotion. Because no brand-new employment has been done after Bridget Cole's departure with the coverage line being straight appointed to Krasnow for the advertising and marketing feature, this is a positive chance for integrating the marketing and advertising features. Judith Shapiro that has actually earlier been spoken with by Lewis throughout the earlier merging days has proficiency in business-to-business advertising along with firm and also retail advertising and marketing experience. As soon as Krasnow leaves, Lewis can hire Shapiro as an EVP for marketing to take care of both advertising and marketing features.

The benefit of this approach is that it will integrate the two features while lowering the requirement for employing an extra source for advertising. In addition to this, Lewis would be heading the advertising and marketing division and also in any case her substitute would certainly be needed for the current function that she is performing. The downside of this alternative is that outside hiring may produce animosity from internal personnel that might be looking at the position of EVP after Lewis takes control of Krasnow's position.

Separating Adverting and also Manufacturing: Given the affordable pressures and top quality work required from the ad agency, it is advised that Lewis should permit the manufacturing device to be a different feature from the advertising system. Given that a lot of advertising agencies had these two features as separate units, it makes more feeling to comply with the standard. In addition to this, both functions may be able to focus on their core turns on a lot more successfully. Nevertheless, the negative aspect of this method would certainly be that additional costs would have to be borne for setting up separate manufacturing features. A production head might have to be employed which might raise overheads for the company.

Assimilation of Marketing with Workflows: Because Lewis is already caring for the marketing as well as procedures departments at the same time; it makes good sense to integrate the two features considering that she has actually been effectively looking after both ends. The reality that both departments already have significant distinctions over appropriation of resources suggests that this assimilation may have the ability to produce harmony specifically as Lewis would certainly be heading both ends.However there are numerous disadvantages of this move especially as it would place too much concern over Lewis's shoulders. The truth that Lewis has to adjust her administration design for the advertising division suggests that these two divisions would certainly be culturally varied. Along with this, Lewis might not have the ability to apply one sort of leadership design to both departments which might lead to inefficiency in either among both functions.


An assessment of the 3 choices indicates that combination of advertising and procedures would not be a practical relocation due to the large distinctions between the 2 divisions in spite of the reality that currently Lewis is managing both. While separation of the manufacturing feature might have been a favorable relocation for the advertising and marketing department, the fact that it would suggest placing a third function under Lewis's wing implies this should be stayed clear of.

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

Marketing and advertising features would certainly be merged.

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

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

Lewis will divide herself from operations.

A democratic leadership style with employee empowerment will certainly be used in advertising division.

Open up door plan and emphasis on cross department interaction will certainly be targeted at eliminating dissonance.

Contingency strategy.

If the integration does not exercise as planned, a backup strategy would comply with which would separate the manufacturing feature from the marketing function to lower the tons on the SVP of advertising and marketing. In case Judith Shapiro does not obtain worked with, Lewis will be heading the advertising department without an SVP. In that case the production feature will most definitely be separated by putting it under an SVP manufacturing.