Week 6 Homework,

Week 7 Homework and quiz 

Week 8  home work and Assignment 1:Assignment 1. Linear Programming Case Study

Your instructor will assign a linear programming project for this assignment according to the following specifications.

It will be a problem with at least three (3) constraints and at least two (2) decision variables. The problem will be bounded and feasible. It will also have a single optimum solution (in other words, it won’t have alternate optimal solutions). The problem will also include a component that involves sensitivity analysis and the use of the shadow price.

You will be turning in two (2) deliverables, a short writeup of the project and the spreadsheet showing your work.

Writeup.

Your writeup should introduce your solution to the project by describing the problem. Correctly identify what type of problem this is. For example, you should note if the problem is a maximization or minimization problem, as well as identify the resources that constrain the solution. Identify each variable and explain the criteria involved in setting up the model. This should be encapsulated in one (1) or two (2) succinct paragraphs.

After the introductory paragraph, write out the L.P. model for the problem. Include the objective function and all constraints, including any non-negativity constraints. Then, you should present the optimal solution, based on your work in Excel. Explain what the results mean.

Finally, write a paragraph addressing the part of the problem pertaining to sensitivity analysis and shadow price.

Excel.

As previously noted, please set up your problem in Excel and find the solution using Solver. Clearly label the cells in your spreadsheet. You will turn in the entire spreadsheet, showing the setup of the model, and the results.

Case Study 15.1: TRANSACT INSURANCE CORPORATION Steven L. McShane, University of Western Australia, and Terrance Bogyo, WorkSafeBC TransAct Insurance Corporation (TIC) provides automobile insurance throughout the southeastern United States. Last year, a new president was hired by TIC’s board of directors to improve the company’s competitiveness and customer service. After spending several months assessing the situation, the new president introduced a strategic plan to strengthen TIC’s competitive position. He also replaced three vice presidents. Jim Leon was hired as vice president of claims, TIC’s largest division, with 1,500 employees, 50 claims center managers, and 5 regional directors. Jim immediately met with all claims managers and directors, and he visited employees at TIC’s 50 claims centers. As an outsider, this was a formidable task, but his strong interpersonal skills and uncanny ability to remember names and ideas helped him through the process. Through these visits and discussions, Jim discovered that the claims division had been managed in a relatively authoritarian, top-down manner. He could also see that morale was very low and employee- management relations were guarded. High workloads and isolation (adjusters work in tiny cubicles) were two other common complaints. Several managers acknowledged that the high turnover among claims adjusters was partly due to these conditions. Following discussions with TIC’s president, Jim decided to make morale and supervisory leadership his top priority. He initiated a divisional newsletter with a tear-off feedback form for employees to register their comments. He announced an open-door policy in which any claims division employee could speak to him directly and confidentially without going first to the immediate supervisor. Jim also fought organizational barriers to initiate a flextime program so that employees could design work schedules around their needs. This program later became a model for other areas of TIC. One of Jim’s most pronounced symbols of change was the “Claims Management Credo” outlining the philosophy that every claims manager would follow. At his first meeting with the complete claims management team, Jim presented a list of what he thought were important philosophies and actions of effective managers. The management group was asked to select and prioritize items from this list. They were told that the resulting list would be the division’s management philosophy and all managers would be held accountable for abiding by its principles. Most claims managers were uneasy about this process, but they also understood that the organization was under competitive pressure and that Jim was using this exercise to demonstrate his leadership. The claims managers developed a list of 10 items, such as encouraging teamwork, fostering a trusting work environment, setting clear and reasonable goals, and so on. The list was circulated to senior management in the organization for their comments and approval and sent back to all claims managers for their endorsement. Once this was done, a copy of the final document was sent to every claims division employee. Jim also announced plans to follow up with an annual survey to evaluate each claims manager’s performance. This concerned the managers, but most of them believed that the credo exercise was a result of Jim’s initial enthusiasm and that he would be too busy to introduce a survey after settling into the job. One year after the credo had been distributed, Jim announced that the first annual survey would be conducted. All claims employees would complete the survey and return it confidentially to the human resource department where the survey results would be compiled for each claims center manager. The survey asked the extent to which the manager had lived up to each of the 10 items in the credo. Each form also provided space for comments. Claims center managers were surprised that a survey would be conducted, but they were even more worried about Jim’s statement that the results would be shared with employees. What results would employees see? Who would distribute these results? What happens if a manager gets poor ratings from his or her subordinates? “We’ll work out the details later,” said Jim in response to these questions. “Even if the survey results aren’t great, the information will give us a good baseline for next year’s survey.” The claims division survey had a high response rate. In some centers, every employee completed and returned a form. Each report showed the claims center manager’s average score for each of the 10 items, as well as how many employees rated the manager at each level of the 5-point scale. The reports also included every comment made by employees at that center. No one was prepared for the results of the first survey. Most managers received moderate or poor ratings on the 10 items. Very few managers averaged above 3.0 (out of the 5 points) on more than a couple of items. This suggested that, at best, employees were ambivalent about whether their claims center manager had abided by the 10 management philosophy items. The comments were even more devastating than the ratings. Comments ranged from mildly disappointed to extremely critical of the claims managers. Employees also described their long-standing frustration with TIC, high workloads, and isolated working conditions. Several people bluntly stated that they were skeptical about the changes that Jim had promised. “We’ve heard the promises before, but now we’ve lost faith,” wrote one claims adjuster. The survey results were sent to each claims manager, the regional director, and employees at the claims center. Jim instructed managers to discuss the survey data and comments with their regional manager and directly with employees. The claims center managers, who thought employees would see only the average scores, went into shock when they realized that the reports included individual comments. Some managers went to their regional director, complaining that revealing the personal comments would ruin their careers. Many directors sympathized, but the results were already available to employees. When Jim heard about these concerns, he agreed that the results were lower than expected and that the comments should not have been shown to employees. After discussing the situation with his directors, he decided that the discussion meetings between claims managers and their employees should proceed as planned. To delay or withdraw the reports would undermine the credibility and trust that Jim was trying to develop with employees. However, the regional director attended the meeting in each claims center to minimize direct conflict between the claims center manager and employees. Although many of these meetings went smoothly, a few created harsh feelings between managers and their employees. The sources of some comments were easily identified by their content, and this created a few delicate moments in several sessions. A few months after the meetings, two claims center managers quit and three others asked for transfers back to nonmanagement positions in TIC. Meanwhile, Jim wondered how to manage this process more effectively, particularly since employees expected another survey the following year. Discussion Questions 1. What symptom(s) exist in this case to suggest that something has gone wrong? 2. What are the root causes that have led to these symptoms? 3. What actions should the company take to correct these problems?

what’s the range of the quadratic parents function?

1 PAGE