Friday, February 14, 2020

Using Power and Influence to Get a Promotion Research Paper

Using Power and Influence to Get a Promotion - Research Paper Example Case in point is a person who has been working as a fiber optic network technician for the past 13 years in the organization and feels ready and qualified to take the next step into a management role. Having the requisite work experience, background, education and passion, it does not make sense why the person has not been promoted yet. An interview reveals: â€Å"My education has given me the tools & skills to work as an effective manager. Given the company’s organizational structure it is very difficult to move up without relocating, but not impossible. Relocating is not an option for me. The company typically will not allow someone to supervise current peers†. This case shows an instance in the organization where a qualified person is facing a ceiling towards their steady career progression, with no obvious means at their disposal to help the situation. This raises the question of whether it is possible to utilize power and influence within the organization to get the promotion without having to relocate. Despite having appropriate work experience and education in the field to be able to take on a management role at the company, a person is overlooked for promotion based on the inability of the person to relocate. Without the option of relocating, there are very limited chances of getting a promotion. Is it possible to use power and influence to get a promotion in the company without relocating? Having power and influence in an organization means having access to more information, having control and influence over peers and subordinates and having a say in the decision making process. This power wielding can be done formally or informally. Therefore, power is in a way a product of ability and willingness to control other persons, important information and ‘instrumentalities’ (Mechanic 1962). To attain power, one must not only have the knowledge and the deep

Saturday, February 1, 2020

Goal Seek and Solver Essay Example | Topics and Well Written Essays - 1000 words

Goal Seek and Solver - Essay Example The miles per hour are constant, and Excel is goal seeking to determine the number of miles traveled. A data table is a collection of cells that display how changing certain value in worksheet formulas affects the result of those applied formulas. Data tables provide a shortcut for calculating multiple versions in one operation, and a way to view and compare the results of all of the different variations together on one's worksheet. Using the bicycle example again, one could create a table that summarizes the number of miles traveled at different speeds and different elapsed minutes traveled. Excel can save a set of values and substitute them automatically in a worksheet to allow one to forecast the outcome of a worksheet model. One can create and save different scenarios on a worksheet, and then switch to any of these scenarios to view different results. For the bicycle example, one could switch between two or more different number of miles traveled using combinations of different speeds and elapsed minutes traveled. Using solver, one can find an optimal value for a formula in a target worksheet cell. Solver works with a group of cells related to a target cell's formula (Paul 2005, p. xix). Solver changes the values of adjustable cells to produce the desired results one specifies in the target cell formula. One can also apply upper, lower, and exact constraints to restrict the values Solver can choose from to adjust the cells. Using the bicycle example again, one could determine the least and greatest possible number of miles traveled at a given speed and distance. Here's a summary of when one would use each of these tools: Use Goal seeker when one wants to find the correct single input value to achieve the desired single output value. Use Solver to find the best solution to problems that revolve around the manipulation of several changing cells, variables, and constraints (Paul 2005, p. xx). The productivity of electricity is causing profit deterioration. Is electricity being wasted Or is it due to a change in manufacturing process Is it possible to cut down the electric consumption without affecting the production If so, what should be the electricity consumption for it not to affect profitability negatively The answers to some of these questions can be determined by using the "Goal Seeker" and the "Solver" features of Excel. Goal Seeker and Solver features are found in the Tools means of Microsoft Excel. Goal Seeker is the opposite of What-if analysis. Using Goal seeker, we begin with the target value in a dependent cell and determine the correspondent value in the independent cell upon which the target cell is dependent. Goal seeker and solver can change independent cell values, but only Solver can change a range of cells and accept constraints, making it a powerful feature. It can also be used to solve complex optimization problem such as linear programming and integer programming problems. Following is a description of finding answers to some of the questions above: What should be the electricity consumption for it not to affect profitability negatively As shown in figure 2, the company is losing $748 because it is currently using 48,000 kWh of electricity. To reduce this loss to zero, go to Tools menu and choose Goal Seeker, and set cell Q15 (profitability of total energy) to zero, by changing