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 Help

Background and Facts

Advanced Logic Functions In Microsoft Excel a workplace products store for tiny as well as average sized organisations has lately been associated with preparing for a merger with its competitor Home Deport, which has actually affected performance levels in departmentswith the elderly supervisor involved in lawful difficulties put forth by the government Profession Payment. With the Marketing Head putting forward the information of his departure from the business in one year, Jeannie Lewis, the current head of operations has been asked to take the duty in the near future. With challenges in the kind of a prospective social adjustment as well as low staff member spirits, the organization is in need of a full reengineering initiative at the marketing department.

Problem Declaration
Porter's 5 Forces Analysis
The possible social modification at the advertising and marketing department of Advanced Logic Functions In Microsoft Excel is increasing uncertainty in the working environment causing numerous obstacles for the Jeannie Lewis that would certainly be replacing the head of the division in one year. nalysis

PEST analysis

Political Factors: Political factors play a major role in influencing critical choices because Stapes Inc. had to desert its strategies of combining with Office Deport after the Federal Profession Compensation's intervention while doing so. Offered the fact that the shop has a worldwide visibility with branches in UK, USA, Canada and also Germany, political consider each of these countries might be able to affect performance or calculated goals. Federal Trade Commission's antitrust match versus the merging took up valuable time of the company's elderly management suggesting that 'political' factors can have serious implications for a global service.

Economic Factors: Financial factors such as the introduction of small companies in the worldwide scenario recommend that Advanced Logic Functions In Microsoft Excel is flourishing in an atmosphere where there is possible growth of services. Along with this, truth that shop clients are mainly looking for office products for home offices recommends that the marketplace has a climbing pattern of entrepreneurs as well as home based businesses.

Social factors: Social patterns in the economic situation show that clients are seeking ease in addition to attractive rates. Market research shows how the customer for Advanced Logic Functions In Microsoft Excel does not have awareness about discovering remedies which can use a mix of benefit as well as inexpensive.

Technological factors: Innovation plays an essential role in Advanced Logic Functions In Microsoft Excel's business strategy especially as the organization is piloting Modern technology facilities which would use technology sales and also assistance in the form of memory upgrades, outer installments. (Summary of PARASITE in appendix 2).

OB Issues and Effects.

A number of underlying Organizational Habits concerns can be seen in Advanced Logic Functions In Microsoft Excel's case as highlighted in this section.

Worries regarding cultural modification: There is worry concerning a social change that would certainly take place when Todd Krasnow leaves from his placement as the Executive Vice President of Advertising And Marketing with the majority of the personnel currently showing unhappiness over this prospective relocation. This expected modification has actually created stress and anxiety in the work environment which has been combined with the past stress of preparing the company for a potential merging with Home Deport.
Pest Analysis
Difficult Job Atmosphere for Newcomers: There is scarcity of personnel that can match the stressful environment of a hectic company. Not only does this lead to difficulty in locating the right people, it puts stress and anxiety on new hires as can not hold up against the rate and also stress that the company anticipates them to bear.

Twin Reporting Lines: Newbies discover this organizational society troublesome as well as difficult to deal with specifically as dotted line connections are meant to be weaker as a whole and objective setup and also efficiency analysis is still done by the solid line manager. This means that newbies could shed clarity concerning their particular roles and goals especially as dotted line reporting does not maintain them in straight interaction with the solid 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 actually been hypothesized that the latter would certainly take Krasnow's placement came as an impact to her morale. Lewis may have been qualified and also suitable for the task but the fact that Kransnow's separation would certainly make Coles a straight report to Lewis may have been the factor for Coles' resignation from solutions.

Anxiety & Job Insecurity: Anxiety and instability can be identified as two major concerns that Lewis would be dealing with particularly as the merging has actually now be terminated and two senior execs of the advertising department would certainly be leaving. The entire obligation of the division would be falling on Lewis's shoulders who would certainly not just be in charge of brining about a social adjustment yet would certainly additionally have to confirm herself in her brand-new function.

Incompatible Monitoring Style of Leader: Lewis's management design and its incompatibility with the marketing department's role can additionally be seen as an OB difficulty specifically as she has been utilized to taking care of issues in the operations division where workers are taught to concentrate on procedures and obtain them right. The marketing division on the other hand can be viewed as a team of people that are utilized to being supported by Krasnow who concentrated more on output than processes.

Interdepartmental Arguments: Interdepartmental disputes between 3 departments, advertising, merchandizing and operations respectively over the allocation of the advertising mix can be determined as another OB issue. Although the advertising and marketing department does not share the exact same vision as the various other two departments pertaining to the aloocation of the advertising and marketing mix twoards promotions as well as advertsing, the merchandizing and also operations divisions do not agree over the advertising and marketing mix allocation among each other either.

Fragmentation in Advertising And Marketing Department: Fragmentation between the advertising and marketing divisions can be determined as another OB concern which can need additional interest. The truth that the marketing and advertising areas in the advertising division are separated is protecting against both divisions from getting from each various other's experience and proficiency. Integration of advertising with retailing as well as procedures would certainly come to be harder if the advertising department itself is degenerated which can be an additional prospective OB issue.

Advanced Logic Functions In Microsoft Excel Analysis

Various theories have actually been used to clarify the circumstances to obtain further quality regarding the situation available.
Swot Analysis
McGregor's Theory X & Y: According to Douglas McGregor's Theory X, most managers believe that juniors are passive as well as lazy, have little passion and also withstand adjustment. The hard variation of this theory highlighted browbeating, limited controls, risks and penalties. Gradually it generates reduced performance, refined sabotage and also competition (Offer, 2003). Although the situation at Advanced Logic Functions In Microsoft Excel is not totally following Theory X, it can be seen that new hires are locating this atmosphere instead stressful which might ultimately lead to a higher disposition of the management towards Concept X. As per McGregor's advocated sight, which he called Theory Y, the crucial task of the monitoring is to arrange business conditions to make sure that people can attain their very own objectives best by routing their initiatives towards organizational rewards. If people discover no complete satisfaction in their work, the administration would have little choice however to count on theory X and also external control (Offer, 2003). Also while examining Lewis's monitoring style, concept X may have appropriated in the procedures department somewhat however the Marketing division would need dependence on Theory Y in order to get the creativity as well as originality from the groups.

Tuckman's Synergy Concept: As far as Lewis's problem concerning bringing consistency in between the marketing and advertising division is concerned, this would at first lead to conflict as reviewed by Bruce Tuckman in his 'Synergy Concept'. By combining the marketing and marketing department's job, there might be the exact same first separate which can lead to the second stage of 'storming' where the groups test one another.

Bridges' Shift Design: As per William Bridge's theory (appendix 4), people are fairly uncomfortable with modification, which is evident by the circumstance at Advanced Logic Functions In Microsoft Excel The situation can be viewed as a typical training course of life if is examined according to Bridge's theory where he explains that people experience three stages of transition when they experience modification. 'Closing, losing as well as Letting go', The Neutral Zone and 'The New Beginning' (Bridges, 2004). When individuals exist with modification, they enter phase one therefore there may be feelings like unhappiness, unpredictability, disappointment, rage, fear, denial as well as disorientation.The scenario at the marketing division of Advanced Logic Functions In Microsoft Excel is comparable so Lewis can obtain comfy with the suggestion that it is not phenomenal habits. In the 2nd phase, there may be a need to bridge the void in between the new and old culture so Lewis may have to encounter this experience when Krasnow leaves. There might be low spirits and reduced efficiency at this stage which ought to not be taken as an obstacle. It is throughout this phase that Lewis will certainly need to give support to the department to make sure that they can discover a sense of direction. It can be seen just how Krasnow has actually already made this shift easier by making Lewis obtain involved in the department a year before his real separation. Based on Bridges' Version, stage 3 will produce openness to understanding, High power as well as dedication as individuals will certainly accept the adjustment (Bridges, 2004).
Vrio Analysis
Maslow's Requirement pecking order: The OB problem related to insecurity at the office has actually been caused first of all by the change in administration and secondly by the reality that the merger will no more be started. Abraham Maslow in his Concept of 'Requirements Hierarchy' (appendix 5) has discusses the relevance of 'safety needs as being a lower degree demand of a human for triggering motivation. As seen in the pyramid shared in appendix 3, we can see exactly how 'the demand to feel secure and out of danger' is at the 2nd level of needs. Before a worker can be made to establish emotionally, he requires to have his 'Physical 'as well as 'Safety' needs satisfied. This suggests that unless the personnel are made to feel safe and secure regarding their existing work status in Advanced Logic Functions In Microsoft Excel they may not get to 'Self-Fulfillment'. (King, 2009).

SWOT Analysis for Advanced Logic Functions In Microsoft Excel Case Study

Effects of Analysis.

The OB analysis has actually considered various theories to recognize how to deal with the present situation at hand. The following three choices have actually been proposed to help Lewis deal with the organizational difficulties in the advertising department. Each of these alternatives has actually been proposed for reducing the change needed to bring the advertising division in accordance with the requirements of the market as well as for making the cultural modification that would adhere to when the present leader leaves.

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

Evaluation of Alternatives.

Combination of Marketing & Marketing Functions: The in-house marketing firm of Advanced Logic Functions In Microsoft Excel is currently stamina for the company in regards to conserving up on expenses connected to advertising and marketing and promotion. Given that no brand-new employment has been done after Bridget Cole's departure with the coverage line being directly designated to Krasnow for the marketing function, this is a favorable possibility for integrating the marketing and advertising functions. Judith Shapiro that has earlier been talked to by Lewis throughout the earlier merger days has experience in business-to-business advertising and marketing together with company and also retail advertising experience. When Krasnow leaves, Lewis can work with Shapiro as an EVP for advertising and marketing to take care of both advertising and marketing functions.

The benefit of this strategy is that it will certainly incorporate both features while decreasing the requirement for hiring an additional resource for marketing. In addition to this, Lewis would be heading the advertising and marketing department as well as regardless her substitute would certainly be needed for the present function that she is doing. The downside of this alternative is that external hiring might cause animosity from internal employees who might be looking at the position of EVP after Lewis takes control of Krasnow's placement.

Dividing Adverting and Production: Offered the affordable pressures as well as high top quality work called for from the advertising company, it is recommended that Lewis needs to allow the production system to be a different function from the advertising and marketing unit. Considering that the majority of marketing companies had these two features as different devices, it makes even more sense to follow the standard.

Assimilation of Advertising And Marketing with Operations: Given that Lewis is already looking after the advertising and marketing and also operations divisions simultaneously; it makes sense to integrate the two features because she has been efficiently looking after both ends. The fact that both divisions currently have significant differences over allotment of sources recommends that this combination might be able to cause harmony especially as Lewis would be heading both ends.However there are numerous downsides of this action particularly as it would certainly place too much burden over Lewis's shoulders. The truth that Lewis has to adjust her management design for the marketing division suggests that these two divisions would be culturally varied. Lewis might not be able to use one kind of leadership style to both departments which could result in inadequacy in either one of the two features.


An examination of the 3 options suggests that integration of advertising and marketing and also operations would not be a feasible move due to the substantial differences between both departments although that currently Lewis is handling both. While separation of the manufacturing function may have been a favorable step for the advertising and marketing division, the reality that it would certainly indicate positioning a 3rd feature under Lewis's wing suggests this need to be prevented. The combination of the advertising division is the most effective choice in regards to getting the optimum arise from the department. An action plan for this alternative is talked about below.

Activity Strategy.
Lewis will take over the function of EVP Marketing after Krasnow leaves.

Advertising and Marketing functions would certainly be merged.

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

Manufacturing feature will remain component of marketing under marketing function.

Lewis will divide herself from operations.

A democratic management style with employee empowerment will be utilized in advertising division.

Open door plan as well as focus on cross department interaction will certainly be targeted at getting rid of dissonance.

Contingency plan.

If the combination does not work out as prepared, a contingency plan would certainly follow which would certainly divide the manufacturing feature from the marketing feature to decrease the tons on the SVP of marketing and advertising. In case Judith Shapiro does not obtain worked with, Lewis will certainly be heading the advertising and marketing division without an SVP. Because case the manufacturing function will definitely be divided by putting it under an SVP production.