Advanced Logic Functions In Microsoft Excel Case Study Analysis


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 supplies seller for small and average sized companies has recently been involved in planning for a merging with its rival Residence Deport, which has influenced effectiveness levels in departmentswith the senior manager associated with lawful complications presented by the government Profession Commission. With the Marketing Head advancing the news of his departure from the company in one year, Jeannie Lewis, the current head of procedures has been asked to take the role in the future. With challenges in the form of a prospective cultural change and also low worker spirits, the organization needs a total reengineering initiative at the advertising division.

Issue Declaration

The potential social change at the advertising department of Advanced Logic Functions In Microsoft Excel is enhancing uncertainty in the workplace resulting in different 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 major role in affecting calculated choices given that Stapes Inc. had to abandon its plans of merging with Office Deport after the Federal Trade Payment's treatment at the same time. Provided the reality that the store has a global visibility with branches in UK, UNITED STATES, Canada and Germany, political consider each of these nations might be able to impact efficiency or tactical objectives. Federal Trade Compensation's antitrust fit versus the merger took up useful time of the organization's elderly administration recommending that 'political' factors can have serious implications for an international service.

Economic Factors: Economic factors such as the appearance of small businesses in the global scenario recommend that Advanced Logic Functions In Microsoft Excel is prospering in an atmosphere where there is potential growth of companies. Reality that store customers are mostly looking for office products for home workplaces suggests that the market has a rising pattern of entrepreneurs as well as home based businesses.

Social factors: Social patterns in the economy reveal that customers are seeking convenience in addition to eye-catching prices. Market research demonstrates how the client for Advanced Logic Functions In Microsoft Excel does not have recognition concerning finding services which can provide a mix of benefit and inexpensive.

Technical factors: Technology plays a vital function in Advanced Logic Functions In Microsoft Excel's business technique particularly as the organization is piloting Modern technology facilities which would offer modern technology sales and assistance in the form of memory upgrades, outer installations. (Summary of PEST in appendix 2).

OB Issues and Symptoms.

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

Apprehensions about cultural adjustment: There is apprehension about a social change that would certainly occur when Todd Krasnow leaves from his position as the Exec Vice Head Of State of Marketing with most of the personnel currently revealing unhappiness over this prospective move. This predicted change has actually developed anxiety in the work environment which has actually been paired with the past stress of preparing the firm for a prospective merger with Home Deport.

Stressful Work Environment for Newcomers: There is shortage of personnel that can match the difficult atmosphere of a busy company. Not only does this bring about difficulty in finding the best people, it puts tension on brand-new hires as can not stand up to the rate and pressure that the company expects them to birth.

Twin Reporting Lines: Newcomers find this business society troublesome as well as tough to cope with particularly as dotted line connections are meant to be weak in general and unbiased setting and performance examination is still done by the solid line supervisor. This indicates that beginners can lose clarity about their respective roles as well as purposes especially as dotted line reporting does not maintain them in straight communication with the strong line managers.

Animosity From Cross Departmental Hiring: Krasnow's choice to make Lewis his successor rather than Bridget Coles even though it had been speculated that the last would take Krasnow's position came as a strike to her spirits. Lewis may have been qualified as well as ideal for the task but the truth that Kransnow's separation would certainly make Coles a direct report to Lewis may have been the reason for Coles' resignation from services.

Worry & Task Instability: Fear and also insecurity can be recognized as two significant worries that Lewis would certainly be managing specifically as the merger has now be terminated as well as two senior executives of the advertising division would be leaving. The entire duty of the division would certainly be falling on Lewis's shoulders who would not simply supervise of brining regarding a social adjustment however would certainly likewise have to show herself in her brand-new function.

Inappropriate Management Design of Leader: Lewis's administration style as well as its conflict with the advertising and marketing department's duty can also be seen as an OB challenge particularly as she has actually been made use of to dealing with problems in the procedures department where employees are educated to concentrate on processes and get them. The advertising department on the other hand can be seen as a team of people that are utilized to being supported by Krasnow who focused more on output than procedures.

Interdepartmental Disputes: Interdepartmental disagreements in between 3 departments, advertising, merchandizing and also procedures specifically over the allotment of the marketing mix can be determined as an additional OB issue. Although the marketing department does not share the very same vision as the various other two divisions pertaining to the aloocation of the marketing mix twoards promos as well as advertsing, the merchandizing and also procedures divisions do not agree over the advertising mix allocation among one another either.

Fragmentation in Advertising And Marketing Division: Fragmentation in between the advertising and marketing departments can be determined as one more OB problem which can need additional attention. The truth that the marketing and advertising sections in the marketing department are separated is stopping both divisions from getting from each various other's experience and also proficiency. Assimilation of advertising and marketing with retailing as well as operations would become harder if the advertising and marketing division itself is disintegrated which can be another prospective OB concern.

Advanced Logic Functions In Microsoft Excel Analysis

Various concepts have been utilized to discuss the circumstances to obtain further quality about the situation handy.

McGregor's Theory X & Y: According to Douglas McGregor's Concept X, the majority of managers think that juniors are easy and also lazy, have little ambition as well as withstand adjustment. The situation at Advanced Logic Functions In Microsoft Excel is not completely complying with Theory X, it can be seen that brand-new hires are locating this setting instead demanding which might ultimately lead to a greater disposition of the management towards Theory X. Also while examining Lewis's monitoring design, concept X may have been ideal in the procedures department to some extent however the Advertising division would certainly need dependence on Concept Y in order to obtain the creative thinking and also originality from the teams.

Tuckman's Team effort Theory: As far as Lewis's concern concerning bringing consistency in between the advertising and marketing as well as marketing department is concerned, this would at first lead to conflict as reviewed by Bruce Tuckman in his 'Team effort Concept'. By combining the marketing and also advertising division's job, there may be the same initial disconnect which could lead to the 2nd stage of 'storming' where the teams test one an additional.

When people are offered with change, they enter phase one and so there might be feelings like sadness, unpredictability, aggravation, rage, concern, denial and also disorientation.The situation at the marketing division of Advanced Logic Functions In Microsoft Excel is similar so Lewis can get comfortable with the concept that it is not remarkable habits. It is during this phase that Lewis will have to give advice to the department so that they can find a sense of direction. It can be seen exactly how Krasnow has actually already made this transition less complicated by making Lewis obtain involved in the division a year prior to his real separation.

Maslow's Demand hierarchy: The OB issue related to instability at the workplace has actually been set off first of all by the modification in administration as well as second of all by the fact that the merger will certainly no longer be launched. Abraham Maslow in his Concept of 'Requirements Power structure' (appendix 5) has talks about the value of 'safety and security needs as being a reduced level demand of a human for activating inspiration. As seen in the pyramid shared in appendix 3, we can see how 'the requirement to really feel protected as well as unharmed' is at the 2nd level of requirements. Prior to a staff member can be made to develop mentally, he needs to have his 'Physiological 'as well as 'Safety' needs met. This shows that unless the employees are made to feel protected regarding their existing work standing in Advanced Logic Functions In Microsoft Excel they might not reach 'Self-Fulfillment'. (King, 2009).

SWOT Analysis for Advanced Logic Functions In Microsoft Excel Case Study

Ramification of Analysis.

The OB analysis has actually checked out different theories to recognize exactly how to cope with the existing scenario at hand. The following 3 options have been suggested to help Lewis deal with the organizational obstacles in the advertising division. Each of these choices has actually been recommended for alleviating the transition needed to bring the advertising division according to the requirements of the marketplace as well as for making the social change that would comply with as soon as the existing leader leaves.

Assimilation of advertising and marketing functions. Dividing Adverting and Production features. Integration of Marketing with Workflow.

Analysis of Alternatives.

Assimilation of Advertising & Advertising And Marketing Functions: The internal advertising and marketing company of Advanced Logic Functions In Microsoft Excel is currently toughness for the company in terms of conserving up on overheads connected to advertising and also promo. Given that no new recruitment has actually been done after Bridget Cole's separation with the reporting line being straight designated to Krasnow for the advertising and marketing feature, this is a desirable opportunity for integrating the marketing and advertising functions. Judith Shapiro that has earlier been spoken with by Lewis during the earlier merger days has knowledge in business-to-business marketing in addition to company and retail advertising and marketing experience. Once Krasnow leaves, Lewis can employ Shapiro as an EVP for advertising to deal with both advertising and marketing features.

The benefit of this approach is that it will incorporate both functions while lowering the need for employing an added source for advertising. Lewis would be heading the advertising division and also in any kind of case her replacement would certainly be needed for the present role that she is executing. The downside of this choice is that outside hiring may cause animosity from internal workers who might be considering the placement of EVP after Lewis takes control of Krasnow's position.

Separating Adverting as well as Production: Provided the affordable pressures as well as excellent quality work required from the ad agency, it is recommended that Lewis must allow the production device to be a separate feature from the advertising and marketing system. Given that a lot of ad agency had these two features as different units, it makes more sense to follow the standard. In addition to this, both functions might have the ability to concentrate on their core triggers much more effectively. However, the negative aspect of this strategy would be that extra prices would need to be birthed for setting up separate production functions. A manufacturing head may have to be hired which can increase expenses for the organization.

Assimilation of Advertising with Operations: Because Lewis is currently dealing with the advertising as well as procedures departments all at once; it makes good sense to incorporate both functions since she has been efficiently looking after both ends. The truth that both divisions currently have major differences over allocation of sources suggests that this assimilation may have the ability to bring about harmony specifically as Lewis would certainly be heading both ends.However there are numerous drawbacks of this relocation especially as it would certainly put way too much concern over Lewis's shoulders. The reality that Lewis has to adjust her monitoring style for the advertising and marketing division recommends that these 2 divisions would be culturally varied. Along with this, Lewis might not be able to use one sort of leadership design to both departments which can lead to inadequacy in either one of the two functions.


An examination of the three options indicates that integration of advertising and marketing and also operations would certainly not be a practical move because of the vast differences between the two divisions although that currently Lewis is handling both. While splitting up of the production feature might have been a positive step for the advertising department, the fact that it would suggest positioning a third feature under Lewis's wing indicates this need to be prevented. The combination of the advertising division is the most effective alternative in regards to obtaining the ideal arise from the division. An action prepare for this choice is gone over below.

Action Strategy.

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

Advertising and Marketing functions would certainly be merged.

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

Manufacturing feature will remain part of advertising under marketing function.

Lewis will certainly separate herself from operations.

An autonomous leadership design with worker empowerment will be made use of in advertising and marketing division.

Open up door plan as well as emphasis on cross department communication will certainly be targeted at getting rid of discord.

Contingency strategy.

If the combination does not exercise as intended, a contingency strategy would adhere to which would divide the production function from the marketing feature to decrease the lots on the SVP of marketing and advertising. In case Judith Shapiro does not get hired, Lewis will be heading the advertising and marketing department without an SVP. Because case the manufacturing feature will definitely be divided by positioning it under an SVP manufacturing.