Introduction to mathematical programming
4th Edition
ISBN: 9780534359645
Author: Jeffrey B. Goldberg
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
The WIX Company Civil Engineers consists of two divisions. The divisions are Water and Waste Water. The company sells engineering services to various customers. The following are the bill rates for the various staff classifications:
Vice President $200/hour
Senior Engineer $180/hour
Staff Engineer $150/hour.
The two divisions expect to bill the following hours:
Water- 10000 hours, vice president at 10% of the time, 30% of Senior Engineer time and remaining to Staff Engineers.
Waste Water- 6000 hours, vice president at 20% of the time, 20% of Senior Engineer time and remaining to Staff Engineers.
The Direct Labor costs per hours are as follows:
Vice President $80/hour
Senior Engineer $60/hour
Staff Engineer $40/hour.
The utilization for each staff members are as follows:
Vice President 60%
Senior Engineer 80%
Staff Engineer 90%.
The company has the following other costs:
Admin Salaries $90,000
Rent $100,000
Utilities $6,000
Benefits $76,000
Assume 20% of time for each staff member…
Problem 3: Location Selection for EXP Logistics
EXP logistics is a third party logistic company that operates several distribution centers at multiple
locations. The company recently decided to expand its warehouse coverage in Texas and planned to
construct new warehouses in several candidate sites. The company has two types of warehouses: Mega
warehouses and Regular warehouses. Mega warehouses have larger capacity than Regular warehouses.
There are 8 different sites available for the company to build new warehouses. The company can build
either type of warehouses at a given site. However, the company can build at most one warehouse at
any location. The following table summarizes the estimated net present value (NPV) of the cash flows (in
million) resulting from locating each type of warehouse at each of the sites and also indicates which
sites are within 20 miles of each other.
Site
1
2
3
4
5
6
7
8
Mega Warehouse NPV Regular Warehous NPV Other Sites within 20
miles
2,3,5,6
1,3,4,7…
A company manufactures 3 products in 2 different factories. The cost of production and time required for production for each product varies depending on which factory produces it.
The time and cost required for production of each product in each factory is provided in the tables in this worksheet.
Demand for products 1, 2 and 3 are 200, 240 and 100 units, respectively.
There are a total of 3,000 hours available in each factory.
Additionally, at least 60% of the total units of Product 1 must be produced in Factory A, and at least 40% of of the total units of Product 2 must be produced in Factory B.
Create a linear programming model and use the Solver add-in to determine the optimal production plan that will minimize total cost.
Note: The cost is per unit not per hour. All demand must be met.
Chapter 9 Solutions
Introduction to mathematical programming
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Similar questions
- An oil and gas exploration firm invested $2,000,000 in drilling for natural gas in a new gas field. The firm's geologist believes the field has the potential to produce gas for many years. The revenue resulting from the gas well the first year after drilling is $600,000; based on previous experiences with similar types of wells, it is expected the annual revenue will decrease at an annual rate of 3%. Likewise, the costs of operating the well the first year totals $100,000; costs are expected to increase at an annual rate of 7%. If the firm's MARR is 17%, how long will it take for the firm to recover its investment? Hint: Using Excel's Goal Seek or SOLVER tool leave cell for the number of years required to recover the investment empty. Click here to access the TVM Factor Table calculator. n = L1 yearsarrow_forwardKatanga Stars is a team of women who perform cultural dance at various functions across the country. The team has a fixed membership of 9 members. Within these 9 members, there is a management committee of 4 members. For each function where they are hired to perform, the amount collected is different and is distributed as follows;• 50% of the fees goes to the consolidated account where each member owns equal shares.• The remaining 50% is shared among the 9 members such that each of the 4 management committee members gets 6.25% and each of the other members not on management committee gets 5%.For example, suppose Katanga Stars is paid UGX 1,000,000/= for a performance at a certain wedding ceremony, then, UGX 500,000/= goes to the consolidated account. Each management committee member gets UGX 62,5000/= while each of the other members gets UGX 50,000/=By assuming that Katanga Stars performs in exactly 5 places in a year, write a C program that performs the following tasks;• Uses a loop…arrow_forwardSprocket manufacturing. The manager of this production firm is faced with a potential problem: shortages in the supply of a vital gear sprocket. He is considering the development of an in-house capability to make the sprockets, knowing that the firm needs 35,000 such sprockets each year. If the firm elects to make the sprockets internally, then it must select one of the three possible production processes. Each has different costs, as shown in Table 10.17. Adopting a manual process may lead to union problems. The manager estimates the probability of these problems as 25%, and knows that if they do occur, then the variable cost will increase by $0.50 per sprocket. Further, if the semi-automatic or fully automatic option is selected, then additional training of personnel will be required. The amount and therefore the cost of training are uncertain. For the semi-automatic process, the fixed cost of basic training will add $15,000. However, there is a 20% chance the workers will need extra…arrow_forward
- A company manufactures three products 1, 2, and 3. Each product requires production time in three departments as shown below: PRODUCT DEPARTMENT 1 DEPARTMENT 2 DEPARTMENT 3 1 3 hr/unit 2 hr/unit 1 hr/unit 2 4 hr/unit 1 hr/unit 3 hr/unit 3 2 hr/unit 2 hr/unit 3 hr/unit There are 500, 400, and 300 hours of production time available in the three departments, respectively. If products 1, 2, and 3 contribute $3, $4, and $2.5 per unit to profit, answer the following questions: (You may attach your solution or write in the box) a) Define the decision variables (2 marks). b) Write all constraints (3 marks). c) Write the objective function (define whether it is a maximization or minimization) (1.5 marks)arrow_forwardGENERATE THE DECISION VARIABLE SOLUTION AND GENERATE AN ANSWER REPORT 2. During the winter WeeMow Lawn Service contracts with customers for cutting lawns starting in the spring. WeeMow provides service to residential and commercial customers. The service has identified 50 possible residential customers and 15 potential commercial customers it has contacted. WeeMow services a customer once every 2 weeks during the growing season. A residential lawn on average takes 1.2 hours to cut, and a commercial property requires 5 hours to cut; the service's available work time is 8 hours, 6 days per week. The profit for a residential lawn is $23, and the profit for a commercial property is $61. The service has established a weekly budget of $350 for management, gas, and other materials, plus equipment repair. A residential lawn averages $12 in management, gas, material, and repair costs, and a commercial property averages $20 in costs. WeeMow wants to know how many residential and commercial jobs…arrow_forwardQ2 G-Motor manufactures airplane engines and has an annual capacity of K units. For the current production facilities, the company has an annual cost of $C, million. G-motor plans to expand its current aircraft engine capacity in light of anticipated growth in aircraft engine demand in the coming years. The company intends to expand its manufacturing capacity by establishing new facilities. Production facilities can be set up in two ways (called as type A and type B). While the cost of establishing a type A manufacturing facility in any given year is $Ca, the production capacity of such a facility is Pa units. The cost of establishing a Type B manufacturing facility is $C3, and the anticipated production capacity is Pg units. Annual expenditures for any facility of type A or B are projected to be $E million dollars. G-Motor aims to make a decision about the establishment of a new facility during the planned period t=2022, 2023,.,T. The demand for aircraft engines in the coming years is…arrow_forward
- BU School of Witchcraft and Wizardry is a school of magic that sends admission letters only to children with magical abilities. The admissions process for BU School of Witchcraft and Wizardry is as follows:- If both parents of the child have previously studied at BU, they do not need to reply to the admission letter. Otherwise they need to reply to the admissions letter by July 31. If they do not reply by the specified date, they are not accepted to the school. BU has 4 houses that students are sorted into by the sorting hat “Hayri”. These houses are; Gryffindor, Hufflepuff, Ravenclaw and Slytherin. Hayri sorts the students into houses according to 2 characteristics; braveness and intelligence.- If Hayri finds the student to be brave and intelligent, they are sorted into Gryffindor.- If the student is found to only be brave, they are sorted into Slytherin.- If the student is found to only be intelligent, they are sorted into Ravenclaw.- Finally, if they are neither brave nor…arrow_forwardA company's board consists of 4 people: Abigail (the CEO), Benoit, Charlie, and Debra. When they take a vote, if there is a majority (either up or down), that vote prevails. If, however, there is a tie, then Abigail's vote is the tie-breaker (e.g. if A&B vote up, and C&D vote down, the outcome is "up", because A's vote breaks the tie). The truth table will show all possible combinations of the 4 votes, and the final decision for each.arrow_forwardThe Livewright Medical Supplies Company has a total of 12 salespeople it wants to assign to three regionsthe South, the East, and the Midwest. A salesperson in the South earns $600 in profit per month for the company, a salesperson in the East eams $540, and a salesperson in the Midwest earns $375. The southern region can have a maximum assignment of 5 salespeople. The.company has a total of $750 per day available for expenses for all 12 salespeople. A salesperson in the South has average expenses of $80 per day, a salesperson in the East has average expenses of$70_pér day, and a salesperson in the Midwest has average daily expenses of $50. The company wants to detemine the number of salespeople to assign to each region to maximize profit. a. Formulate an integer programming model for this problem. b. Solve this model by using the computer.arrow_forward
- Kevin bought a new moulding machine for $3,000. The machine deteriorates with age and requires to trade in for a new one every fifth year of usage. The resale value and the running cost are given in below table. Age of machine (year) 1 3 4 5 Maintenance cost ($) 600 700 800 900 1,000 Resale value ($) 2,000 1,333 1,000 750 500arrow_forwardNizwa AC Maintenance company has been providing Air conditioners maintenance and service for their customers in Nizwa. Currentiy, they are handling Split AC, Window AC and charging the service charge according to the following table. | Air Conditoner Type Service Charge Split AC Window AC 15 Rials |20 Rials The total service cost is calculated based on the service charge of the AC and spare parts costs based on the formula show below: Total service cost = service charge + spare parts costs Write a Python program named acservice.py that should take two inputs: the air conditioner type and spare parts costs for 5 customers and store them in two different lists. The program has to calculate the total service cost for each customer and store them in a list. Finally, your program has to display the total service cost for 5 customers and maximum service cost. Run and test your program. Once done, submit the file named acservice.py at the link below.…arrow_forwardThe Livewright Medical Supplies Company has a total of 12 salespeople it wants to assign to three regions-the South, the East, and the Midwest. A salesperson in the South earns $600 in profit per month for the company, a salesperson in the East earns $540, and a salesperson in the Midwest earns $375. The southern region can have a maximum assignment of five sales- people. The company has a total of $750 per day available for expenses for all 12 salespeople. A salesperson in the South has average expenses of $80 per day, a salesperson in the East has average expenses of $70 per day, and a salesperson in the Midwest has average daily expenses of $50. The company wants to determine the number of salespeople to assign to each region to maximize profit. a. Formulate an integer programming model for this problem. b. Solve this model by using the computer.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Operations Research : Applications and AlgorithmsComputer ScienceISBN:9780534380588Author:Wayne L. WinstonPublisher:Brooks Cole
Operations Research : Applications and Algorithms
Computer Science
ISBN:9780534380588
Author:Wayne L. Winston
Publisher:Brooks Cole