Practical Management Science, Loose-leaf Version
5th Edition
ISBN: 9781305631540
Author: WINSTON, Wayne L.; Albright, S. Christian
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 8, Problem 37P
Summary Introduction
To assign: The voters to districts using evolutionary solver.
Introduction: The variation between the present value of the
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
You are required to create the following tables in a database named STUDENT_REGISTRATIONS.
Ensure that you create the database and table objects exactly as depicted below.
STUDENTS
STUDENT_ID
VARCHAR(8) NOT NULL
PRIMARY KEY
STUDENT_NAME
VARCHAR(40) NOT NULL
STUDENT_SURNAME VARCHAR(40) NOT NULL
MODULES
MODULE_ID
VARCHAR(8) NOT NULL
PRIMARY KEY
MODULE_NAME
VARCHAR(40) NOT NULL
MODULE_CREDIT SMALLINT NOT NULL
STUDENT_MODULES
STUDENT_ID
VARCHAR(8) NOT NULL
PRIMARY KEY
FOREIGN KEY REFERENCES
STUDENTS(STUDENT_ID)
MODULE ID
VARCHAR(8) NOT NULL
PRIMARY KEY
FOREIGN KEY REFERENCES
MODULES(MODULE_ID)
LECTURERS
LECTURER_ID
VARCHAR(8) NOT NULL
PRIMARY KEY
LECTURER_NAME
VARCHAR(40) NOT NULL
LECTURER_SURNAME VARCHAR(40) NOT NULL
O The Independent Institute of Education (Pty) Ltd 2021
Page 3 of 10
19, 20; 21
2021
LECTURER_MODULES
MODULE_ID
VARCHAR(8) NOT NULL
PRIMARY KEY
FOREIGN KEY REFERENCES
MODULES(MODULE_ID)
LECTURER_ID
VARCHAR(8) NOT NULL
PRIMARY KEY
FOREIGN KEY REFERENCES
LECTURERS(LECTURER_ID)
During the first year software will be purchased from a reputable vendor for $3,000,000. An internal team aided by a hired consulting is also used. The payroll for the internal team is $500,000 for the first year and increases by $500,000 in years two and three. Also, $500,000 will be spent on consulting during the first year and $1,000,000 during each of years two and three. $2,000,000 will need to be invested in hardware during the second year and an additional $500,000 investment in hardware will be needed for year three. $200,000 in training will be needed the first year, $500,000 the second year, and $2,000,000 the third year. Management considers the expenditures for the first three years as investment in the system.
Management estimates the operating cost of the system to be $2,500,000 (for personnel and other costs) in year 4 and to grow by 6% per year for years 5 through 10. The benefits are estimated to be $4,000,000 for year 4 and to grow by 30% per year for years 5…
Using the attached template answer the following question. (Note that the data from P06_40.xlsx is already in the excel sheet)
You are given a group of possible investment projects for your company’s capital. For each project, you are given the NPV the project would add to the firm, as well as the cash outflow required by each project during each year. Given the information in the file P06_40.xlsx, determine the investments that maximize the firm’s NPV. The firm has $25 million available during each of the next five years. All numbers are in millions of dollars.
Chapter 8 Solutions
Practical Management Science, Loose-leaf Version
Ch. 8.3 - Prob. 1PCh. 8.3 - Prob. 2PCh. 8.4 - Prob. 3PCh. 8.4 - Prob. 4PCh. 8.4 - Prob. 5PCh. 8.5 - Prob. 6PCh. 8.5 - Prob. 7PCh. 8.5 - In the lawn mower production problem in Example...Ch. 8.6 - Prob. 9PCh. 8.6 - Prob. 10P
Ch. 8.6 - Prob. 11PCh. 8.6 - Prob. 12PCh. 8.7 - Prob. 13PCh. 8.7 - Prob. 14PCh. 8.8 - Prob. 15PCh. 8.9 - Prob. 17PCh. 8.9 - Prob. 18PCh. 8.10 - Prob. 20PCh. 8.10 - Prob. 21PCh. 8.10 - Prob. 22PCh. 8.10 - Prob. 23PCh. 8.10 - Prob. 24PCh. 8 - Prob. 25PCh. 8 - Prob. 26PCh. 8 - Prob. 27PCh. 8 - Prob. 28PCh. 8 - Prob. 29PCh. 8 - Prob. 30PCh. 8 - Prob. 31PCh. 8 - Prob. 32PCh. 8 - Prob. 33PCh. 8 - Prob. 34PCh. 8 - Prob. 35PCh. 8 - Prob. 36PCh. 8 - Prob. 37PCh. 8 - Prob. 38PCh. 8 - Prob. 39PCh. 8 - Prob. 40PCh. 8 - Prob. 41PCh. 8 - Prob. 42PCh. 8 - Prob. 43PCh. 8 - Prob. 44PCh. 8 - Prob. 46PCh. 8 - Prob. 1CCh. 8 - Prob. 2C
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.Similar questions
- You want to take out a 450,000 loan on a 20-year mortgage with end-of-month payments. The annual rate of interest is 3%. Twenty years from now, you will need to make a 50,000 ending balloon payment. Because you expect your income to increase, you want to structure the loan so at the beginning of each year, your monthly payments increase by 2%. a. Determine the amount of each years monthly payment. You should use a lookup table to look up each years monthly payment and to look up the year based on the month (e.g., month 13 is year 2, etc.). b. Suppose payment each month is to be the same, and there is no balloon payment. Show that the monthly payment you can calculate from your spreadsheet matches the value given by the Excel PMT function PMT(0.03/12,240, 450000,0,0).arrow_forwardMinimize Z= x1+2x2-3x3-2x4 subject to: x1+2x2-3x3+x4=4 x1+2x2+x3+2x4=4 x1, x2, x3,x4 are equal or greater then zeroarrow_forward48. Because of excessive pollution on the Momiss River, the state of Momiss is going to build some pollution control stations. Three sites are under consideration. Momiss is interested in controlling the pollution levels of two pollutants. The state legislature requires that at least 100,000 tons of pollutant 1 and at least 80,000 tons of pollutant 2 be removed from the river. The relevant data for this problem are shown in the file P06_48.xlsx. The last two rows indicate the number of tons of pollutants removed per ton treated. a. Determine how to minimize the cost of meeting the state legislature’s goals. b. Use SolverTable to analyze how a change in the requirement for pollutant 1 changes the optimal solution. Do the same for pollutant 2.arrow_forward
- Long-Life Insurance developed a linear model to determine the amount of term life insurance a family of four should have, based on the head of the household's current age. The equation is: y = 163 -0.45xwherey = Insurance needed ($000)x = Current age of head of household Calculate the amount of term life insurance you would recommend for a family of four if the head of the household is 53 years old. (Round your answer to 2 decimal places.)arrow_forwardIn a metropolitan area, 45,000 people want to travel from the city suburbs to the city center. To do so, they can drive, take a city bus, or use the subway system. Ifx1 number of people drive and x2 number of people take a bus, it will take respectively (0.0006 x1 + 30) and (0.0003 x2 + 40) minutes to make the trip;whereas a subway trip is expected to take 45 minutes. The city bus system can transport a maximum of 20,000 people to the city center, while the subway systemhas a capacity of transporting at most 10,000. Write a programming formulation that minimizes the average travel time for each person.arrow_forwardUse excel for this problem A trust officer at the Blacksburg National Bank needs to determine how to invest $150,000 in the following collection of bonds to maximize the annual return. Bond Annual Return Maturity Risk Tax Free A 9.5% Long High Yes B 8.0% Short Low Yes C 9.0% Long Low No D 9.0% Long High Yes E 9.0% Short High No The officer wants to invest at least 40% of the money in short-term issues and no more than 20% in high-risk issues. At least 25% of the funds should go in tax-free investments, and at least 45% of the total annual return should be tax free. Formulate the LP model for this problem. Create the spreadsheet model and use Solver to solve the problem.arrow_forward
- A study on ethics in the workplace by the Ethics Resource Center and Kronos, Inc., revealed that 35% of employees admit to keeping quiet when they see coworker misconduct. Suppose 70% of employees who admit to keeping quiet when they see coworker misconduct call in sick when they are well. In addition, suppose that 45% of the employees who call in sick when they are well admit to keeping quiet when they see coworker misconduct. If an employee is randomly selected, determine the following probabilities:a. The employee calls in sick when well and admits to keeping quiet when seeing coworker misconduct.b. The employee admits to keeping quiet when seeing coworker misconduct or calls in sick when well.c. Given that the employee calls in sick when well, he or she does not keep quiet when seeing coworker misconduct.d. The employee neither keeps quiet when seeing coworker misconduct nor calls in sick when well.e. The employee admits to keeping quiet when seeing coworker misconduct and does not…arrow_forwardThe Racing Club of America sponsors driver education events that provide high-performance driving instruction on actual race tracks. Because safety is a primary consideration at such events, many owners elect to install roll bars in their cars. Deegan Industries manufactures two types of roll bars for sports cars. Model DRB is bolted to the car using existing holes in the car's frame. Model DRW is a heavier roll bar that must be welded to the car's frame. Model DRB requires 20 pounds of a special high alloy steel, 40 minutes of manufacturing time, and 60 minutes of assembly time. Model DRW requires 25 pounds of the special high alloy steel, 100 minutes of manufacturing time, and 40 minutes of assembly time. Deegan's steel supplier indicated that at most 34,000 pounds of the high-alloy steel will be available next quarter. In addition, Deegan estimates that 2,000 hours of manufacturing time and 1,800 hours of assembly time will be available next quarter. The profit contributions are…arrow_forwardThe Racing Club of America sponsors driver education events that provide high-performance driving instruction on actual race tracks. Because safety is a primary consideration at such events, many owners elect to install roll bars in their cars. Deegan Industries manufactures two types of roll bars for sports cars. Model DRB is bolted to the car using existing holes in the car's frame. Model DRW is a heavier roll bar that must be welded to the car's frame. Model DRB requires 20 pounds of a special high alloy steel, 40 minutes of manufacturing time, and 60 minutes of assembly time. Model DRW requires 25 pounds of the special high alloy steel, 100 minutes of manufacturing time, and 40 minutes of assembly time. Deegan's steel supplier indicated that at most 32,000 pounds of the high-alloy steel will be available next quarter. In addition, Deegan estimates that 2,000 hours of manufacturing time and 1,700 hours of assembly time will be available next quarter. The profit contributions are…arrow_forward
- The Racing Club of America sponsors driver education events that provide high-performance driving instruction on actual race tracks. Because safety is a primary consideration at such events, many owners elect to install roll bars in their cars. Deegan Industries manufactures two types of roll bars for sports cars. Model DRB is bolted to the car using existing holes in the car's frame. Model DRW is a heavier roll bar that must be welded to the car's frame. Model DRB requires 20 pounds of a special high alloy steel, 40 minutes of manufacturing time, and 60 minutes of assembly time. Model DRW requires 25 pounds of the special high alloy steel, 100 minutes of manufacturing time, and 40 minutes of assembly time. Deegan's steel supplier indicated that at most 32,000 pounds of the high-alloy steel will be available next quarter. In addition, Deegan estimates that 2,000 hours of manufacturing time and 1,700 hours of assembly time will be available next quarter. The profit contributions are…arrow_forwardPlease do not give solution in image format thanku Let xi = 1 if Project i is selected, i = 1,2,3,4,5; and 0 otherwise: Which answer below indicates that if Project 2 is selected, then Project 4 must be selected? Group of answer choices None of the above x2 + x4 = 1 x2 + x4 ≤ 1 x4 ≤ x2 x2 ≤ x4arrow_forwardDuring a pandemic, a local public health official wants to run public awareness campaigns on TV and radio about the importance of wearing a face mask and proper hand washing. For each minute that the campaign runs on a local TV channel, she expects to reach about 350 viewers, and for each minute of radio campaigns, she expects to reach about 200 local listeners. A local TV channel charges $150 per minute for public service announcements, and a radio channel charges $85 per minute for similar public announcements. Her goal is to reach at least 20,000 constituents each month. Her part-time assistant can commit up to 120 hours each month to assist her on the TV and radio campaigns. For each minute of the TV campaigns, her assistant needs to spend about 2 hours on administrative support. For each minute spent on the radio campaigns, the assistant needs to spend about 1.5 hours. The awareness campaign expense will be covered in her monthly budget, which is also used for other, on-going…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,