Borges Machine Shop, Inc., has a 1-year contract for the production of 75,000 gear housings for a new off-road vehicle. Owner Luis Borges hopes the contract will be extended and the volume increased next year. Borges has developed costs for three alternatives. They are general-purpose equipment (GPE), flexible manufacturing system (FMS), and expensive, but efficient, dedicated machine (DM). The cost data follow: Annual contracted units Annual fixed cost Per unit variable cost General-Purpose Equipment (GPE) 75,000 $100,000 $18.00 Flexible Manufacturing System (FMS) 75,000 $250,000 $14.50 Dedicated Machine (DM) 75,000 $500,000 $13.00

Borges Machine Shop, Inc., has a 1-year contract for the production of 75,000 gear housings for a new off-road vehicle. Owner Luis Borges hopes the contract will be extended and the volume increased next year. Borges has developed costs for three alternatives. They are general-purpose equipment (GPE), flexible manufacturing system (FMS), and expensive, but efficient, dedicated machine (DM). The cost data follow: Annual contracted units Annual fixed cost Per unit variable cost General-Purpose Equipment (GPE) 75,000 $100,000 $18.00 Flexible Manufacturing System (FMS) 75,000 $250,000 $14.50 Dedicated Machine (DM) 75,000 $500,000 $13.00

Operations Research : Applications and Algorithms

4th Edition

ISBN:9780534380588

Author:Wayne L. Winston

Publisher:Wayne L. Winston

Chapter9: Integer Programming

Section9.2: Formulating Integer Programming Problems

Problem 12P

See similar textbooks

Similar questions

Question 1: pertains to the Cherokee School District scenario below. The school board for the Cherokee School District has made the decision to purchase 1370additional Macintosh computers for computer laboratories in all its schools. Based on the past experience, the school board has directed that these computers should be purchased from some combination of three companies Mc Comp, EduElectronics, and Macwin. In all three cases, the companies charge a discounted variable cost per computer and a fixed delivery and installation costs for these large sales to school districts. The table below shows these charges as well as the capacity (the maximum number of computers that can be sold from the limited inventory) for each of the companies.CapacityFixed cost variable costMcComp710 $45,000 $750 EduElectronics690$35,000$780 Macwin1000$50,000 $700 The school board wants to know the optimal plan for meeting its computer needs. 1.Identify the type of integer programming framework (Total Integer,…
A 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)…
Ishan and Hazel plan to retire at age 60 with a retirement income of $48,000 a year from their savings. Rather than pay themselves the whole amount at the beginning of each year, they have decided that payment at the beginning of each quarter of $12,000 gives them the right balance of flexibility and maximized interest earnings. They feel they can safely earn an interest rate of 6.5%, compounded quarterly, on their money and they are budgeting based on the prediction that they will live until they are 90 years old. Now that Ishan and Hazel have their saving goal calculated, and rounded up to the nearest dollar, they want to start budgeting to reach that goal. They are 40 years old currently, so they have just 20 years to save up the total they calculated they would require so that they can still reach their goal of retirement by age 60. If they assume the same interest rate, but compounded monthly, and make deposits into their savings at the beginning of every month, how much…
A 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?
Consider the following task of building a zoo for Drexel! You've gathered m donors to fund the creation ofyour new park, and you've picked the location, so now you just need to choose the inhabitants. Ideally you'dget every animal imaginable, except you just don't have space. As it is, you have room to comfortably tk animals. Since you'd like to ensure that your funding doesn't dry up, you gure your donors should getto make requests about which animals will be kept. After sending out a few emails, you collect from eachdonor i a list of animals Ai which donor i would like to have at the zoo. As you suspected, the total numberof di erent animals appearing on the m lists exceeds k, so you won't be able to satisfy all of their requests.You decide the fairest thing to do is to ensure that at least 1 animal from each Ai is chosen.Given all these lists, we want to know whether we can select a set H of at most k animals to put in thezoo such that each donor i will be able to see at least one…
Damon Davis was working on the company's spreadsheet for Drano Drain and Sewer Service. Based on his estimates, he concluded that a net income of $50,000 would result. He totaled up the amounts in the Total Balance Sheet Columns, which indicated a deficit of $400,000 and a credit of $300,000, and came up with the following: We can only speculate as to the true cause of this disparity. If this isn't the case, then how can he tell where the issue is coming from?
Consider the following task of building a zoo for Drexel! You’ve gathered m donors to fund the creation ofyour new park, and you’ve picked the location, so now you just need to choose the inhabitants. Ideally you’dget every animal imaginable, except you just don’t have space. As it is, you have room to comfortably fitk animals. Since you’d like to ensure that your funding doesn’t dry up, you figure your donors should getto make requests about which animals will be kept. After sending out a few emails, you collect from eachdonor i a list of animals Ai which donor i would like to have at the zoo. As you suspected, the total numberof different animals appearing on the m lists exceeds k, so you won’t be able to satisfy all of their requests.You decide the fairest thing to do is to ensure that at least 1 animal from each Aiis chosen.Given all these lists, we want to know whether we can select a set H of at most k animals to put in thezoo such that each donor i will be able to see at least…
he pulp and paper factory is one of the longest industrial sectors in the world. Thus, international paper company wants to increase their output. Based on its product, the thickness of 500 sheet of papers is 2.027558055 inch. Without decreasing its quality according to scientific experiments they had done, they decided to use rounding off formula from 9 decimal places to 6 decimal places based on thickness of the paper. Discuss the above study in view of absolute and relative errors. If you are quality control manager of the factory, what is your BEST action towards production line with above decision. Justify your answer
You 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…
What if Analysis using Excel I. Cox Electric makes electronic components and has estimated the following for a new design of one ofits products:Fixed Cost = $10,000; Material cost per unit = $0.15; Labor cost per unit = $0.10; Revenue per unit =$0.65Note that fixed cost is incurred regardless of the amount produced. Per-unit material and labor costtogether make up the variable cost per unit. Assuming Cox Electric sells all that it produces, profit iscalculated by subtracting the fixed cost and total variable cost from total revenue. 1. Implement the mathematical model for calculating profit in Excel. If Cox Electric makes 12,000 units ofthe new product, what is the resulting profit? 2. Construct a one-way data table with production volume as the column input and profit as the output.Breakeven occurs when profit goes from a negative to a positive value, that is, breakeven is whenrevenue = total cost, yielding a profit of zero. Vary production volume from 0 to 100,000 in incrementsof…
Question 4It has been observed by management that some faculty members at theuniversity demonstrate a lackadaisical attitude toward teaching. They seldom go to class yet at the end of each month they receive full salary. Management has decided that GHs 200, 300, 400, and 500 will be deducted from a faculty’s salary if he/she offends once, twice, third time and forth time respectively in a month. This means that if a faculty member offends once in a month GHs200 will be deducted, if a faculty member offends twice in a month, GHs 500 (i.e. 200+300) will be deducted, if a faculty member offends three times in a month GHs 900 (i.e. 200+300+400), will be deducted and if a faculty member offends four times in a month GHs 1,400 (i.e. 200+300+400+500). Assuming all faculty members are on a flat salary rate of GHs 2000.a. Write a program to request for the names of four faculty members and number times he/she has absented him/herself from class in a month.One of them should have absented…
Question 4It has been observed by management that some faculty members at theuniversity demonstrate a lackadaisical attitude toward teaching. They seldom go to class yet at the end of each month they receive full salary. Management has decided that GHs 200, 300, 400, and 500 will be deducted from a faculty’s salary if he/she offends once, twice, third time and forth time respectively in a month. This means that if a faculty member offends once in a month GHs200 will be deducted, if a faculty member offends twice in a month, GHs 500 (i.e. 200+300) will be deducted, if a faculty member offends three times in a month GHs 900 (i.e. 200+300+400), will be deducted and if a faculty member offends four times in a month GHs 1,400 (i.e. 200+300+400+500). Assuming all faculty members are on a flat salary rate of GHs 2000.a. Write a java program to request for the names of four faculty members and number times he/she has absented him/herself from class in a month.One of them should have absented…