Explanation of Solution
Selecting the project using the preemptive goal
Consider the following variables
For every project values related to each attribute are tabulated.
The table is given below,
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | |
ROI | 2070 | 456 | 670 | 350 | 495 | 380 | 1500 | 480 |
Cost | 900 | 240 | 335 | 700 | 410 | 190 | 500 | 160 |
Productivity improvement | 3 | 2 | 2 | 0 | 1 | 0 | 3 | 2 |
Manpower needed | 18 | 18 | 27 | 36 | 42 | 6 | 48 | 24 |
Degree of risk | 3 | 2 | 4 | 1 | 1 | 0 | 2 | 3 |
The company has the following goals.
Goal 1: Archive a return on investment of at least
Goal 2: Limit cost to
Goal 3: Archive a productivity improvement of at least 6. Thus the constraint formed is,
Goal 4: Limit manpower use to 108. Thus the constraint formed is,
Goal 5: Limit technological risk to a total of 4. Thus the constraint formed is
Hence the linear programming can be formulated as given below,
Minimize
Subject to the constraints,
Here, it is observed that for these set of constraints, there is no region which is feasible. That is all the constraints cannot be met. Hence e assign a cost value incurred if any of the goal is not meet. So introduce deviational variables as follows
Want to see the full answer?
Check out a sample textbook solutionChapter 4 Solutions
Introduction to mathematical programming
- The city of Bloomington is about to build a new watertreatment plant. Once the plant is designed (D), we canselect the site (S), the building contractor (C), and theoperating personnel (P). Once the site is selected, we canerect the building (B). We can order the water treatmentmachine (W) and prepare the operations manual (M) onlyafter the contractor is selected. We can begin training (T)the operators when both the operations manual and operatingpersonnel selection are completed. When the treatment plantand the building are finished, we can install the treatmentmachine (I). Once the treatment machine is installed andoperators are trained, we can obtain an operating license(L). The estimated mean and standard deviation of the time(in months) needed to complete each activity are given inTable 8. Use simulation to estimate the probability that theproject will be completed in (a) under 50 days and (b) morethan 55 days. Also estimate the probabilities that B, I, andT are critical…arrow_forwardA blood bank wants to determine the least expensive way to transport available blood donations from Pittsburgh and Staunton to hospitals in Charleston, Roanoke, Richmond, Norfolk, and Suffolk. The supply and demand for donated blood is shown in the figure along with the unit cost of shipping along each possible arc. Provide the complete linear programing formulation. Clearly specify decision variables, objective function and constraints. Build a model in Excel and paste a screenshot here. Use “FORMULATEXT” in your model to show calculations. According to Excel Solver, what is the optimal transportation plan for blood bank? What is the minimum total shipping cost?arrow_forwardYou are trying to estimate NPV of profit for a newcomputer product, which you are confident will sell for tenyears. You are given the following information.The hurdle rate is 15%. Assume end of year for profits.The total cost of developing the product will be spreadequally over the product’s life. Total development cost willbe between $2 billion and $11 billion. There is a 25% chancethat total fixed cost is $3 billion or less, a 50% chance of $6billion or less, and a 75% chance of $9 billion or less.The total year 1 market size (in terms of annual unitsales) is unknown but is believed to be between 0 and 600million units. Unit sales of 100 million and 500 million areequally likely. Unit sales of 200 million and 400 million areequally likely, and are 4 times as likely as sales of 100million. Sales of 300 million are 5 times as likely as salesof 100 million. Each year, market growth is expected toaverage 5%, and during each year we are 95% sure thatmarket growth will be between 3% and…arrow_forward
- ACE Hardware wants to develop a daily schedule for its employees in one of its stores in Omaha. Currently,this store has five employees and the store is opened from 12pm to 9pm. The store must always have at leasttwo people on hand. Each employee must work at least four hours and no more than eight hours per day.Employee #1 goes to school and cannot start before 4pm while all other employees can work at any time.Furthermore, employee #1 earns $10 per hour while all other employees earn $12 per hour. Because all fiveemployees live so close to the store, you must assume that they do not need to work consecutive hours.a) Formulate an optimization model for this problem.b) Solve the optimization model using either the Microsoft Excel Solver or the IBM ILOG CPLEXOptimization Studio.arrow_forwardAs a project your team is given the task of designing a space station consisting of four different habitats. Each habitat is an enclosed sphere containing all necessary life support and laboratory facilities. The masses of these habitats are 1.0 x 106 kg, 2.0 x 106 kg, 3.0 x 106 kg, and 4.0 x 106 kg. The entire station must spin so that the inhabitants will experience an artificial gravity. Your team has decided to arrange the habitats at corners of a square with 1.0 km sides. The axis of rotation will be perpendicular to the plane of the square and through the center of mass. To help decide if this plan is practical, you calculate how much energy would be necessary to set the space station spinning at 1.0 revolution per minute. In your team's design, the size of each habitat is small compared to the size of the space between the habitats and the structure that holds the habitats together is much less massive than any single habitat. how much energy would be necessary to set the space…arrow_forwardDe anza is looking to hire teachers and TAs to fill its staffing needs for its summer program at minimum cost. The average monthly salary of a teacher is $2400 and the average monthly salary of a TA is $1100. The program can accommodate up to 45 staff members, needs at least 30 to run properly, and must have teachers (they will NOT employee only TAs). They must have at least 10 TAs and may have up to 3 TA’s for every 2 teachers. How many teachers and TAs the should the program hire to minimize costs. What is the minimum cost? use python code & explain each steparrow_forward
- After the San Onofre Nuclear Generating Station (SONGS) closed in 2012, the Diablo Canyon Power Plant is the last remaining nuclear power plant operating in California. Located near San Luis Obispo, the Diablo Canyon facility is operated by PG&E and is composed of two pressurized-water nuclear reactors. Each reactor can produce electricity at a rate of 1,100 MW and the plant typically operates at an average capacity factor of 0.89. Nuclear power plants such as Diablo Canyon are important sources of baseload electricity because of their high output capability and low variable operating costs. In June 2016 due to a number of factors (including proximity to earthquake fault lines), PG&E announced that it plans to close Diablo Canyon when the current operating license expires in 2025. The following chart shows California’s electricity generation mixes in 2011 (the last year the SONGS nuclear plant of southern California operated) and 2016, respectively. Fill in your answer from…arrow_forwardAn engineering company has determined that P5.2 million per year will be needed to maintain a new bridge. How much money is needed in a fund today to maintain the bridge indefinitely if the annual interest rate is 4.5 percent?arrow_forwardSuppose we are starting at Hirsova and trying to navigate to Neamt. Assuming that we will move from one city to the next city in one moving step. a. Formulate the problem with state space, successor function, goal, and step cost function. b. How large is the state space, list some of the state space? c. Formulate the problem with the assumption that we know ahead of time that Urziceni is on the path and Bucharest is not on the path.arrow_forward
- Consider the following project activites Draw the AoN and use the Critical path method to compute the CP, and total slack [5] Use PERT to analyze the chance the delays on CP activities does not push the project duration beyond 30 days.[5] x: is a last digit of your roll number y: is a # of sibilings (0,1…….) z: is a last digit of your mobile number Activity predecessors Optimistic Most likely Pessimistic A - 5 6 8 B - 3 4 5 C A 2 3 4 D B x-1 x +4 x+6 E B 1 3 4 F - 1 10 -z+x 15-z+x G E,F 2 3 4 H C,D 2+y 2+y 2+y I G, H 3 4 5arrow_forwardThe Rebel Alliance buys and sells Starfighters. The Rebel Alliancemust determine how many X-Wing Fighters and Y-Wing Fightersshould be stocked. It costs the Rebel Alliance 4 credits to purchasean X-Wing Fighter and 2 credits to purchase a Y-Wing Fighter.The Rebel Alliance has set the following goals (listed in order ofimportance):• Goal 1: A maximum of 32 credits can be spent on purchasing XWing Fighters and Y-Wing Fighters.• Goal 2: The Rebel Alliance should store at least 7 X-Wing Fighters.• Goal 3: The Rebel Alliance should store at least 10 Y-Wing Fighters.a. Formulate a Goal Programming Model to meet the Rebel Alliance requirements. b. Determine the optimal solution, using the Goal Simplex Algorithm, for the RebelAlliance. Specify at each iteration, how much the goals are under or above theirrequirements.arrow_forwardA coach is trying to choose the starting line-up for the basketball team. The team consists ofseven players who have been rated (on a scale of 1= poor to 3 = excellent) according to theirball-handling, shooting, rebounding, and defensive abilities. The positions that each playeris allowed to play (G = guard, C = center, F = forward) and the player’s abilities are:Player Position Defense Ability1 G 32 C 23 G-F 24 F-C 15 G-F 16 F-C 37 G-F 3Formulate an IP to choose the starting lineup such that the five-player starting line-up satisfiesthe following restrictions, then solve your IP using python (if you have not taken and are notcurrently taking python you may use the excel solver - be sure to document this in yourhomework submission). Submit your python file on canvas and include the optimal solutionin your written submission.(a)…arrow_forward
- Operations Research : Applications and AlgorithmsComputer ScienceISBN:9780534380588Author:Wayne L. WinstonPublisher:Brooks Cole