Practical Management Science
6th Edition
ISBN: 9781337406659
Author: WINSTON, Wayne L.
Publisher: Cengage,
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 8.3, Problem 2P
Summary Introduction
To determine: Whether evolutionary solver find the correct solution.
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
A company has one machine which can be used to make product Alpha and product Beta.
Each unit of product Alpha requires 45 minutes of machine time, while
each unit of product Beta requires 37 minutes of machine time.
The machine can be used for 8 hours per day and 5 days per week.
Next week the company will produce 23 units of product Alpha.
After completing the production of Alpha, the company will produce product Beta.
How many units of product Beta can be produced next week?
Use at least 4 decimals.You must showm your calculation steps and brief explanation on your Excel spreadsheets.
Which of the following statements about linear programming is NOT correct?
A.
Minimization problems are often unbounded inward.
B.
The iso-cost approach attempts to move the objective function in towards the origin as far as possible.
C.
The feasible region is determined the same way for a minimization problem as for a maximization problem.
D.
LP problems can be structured to minimize costs as well as maximize profits.
(Don't hand writing solution)
please solve by excal steep by steep to learn me how i can solve in exxal and but all the pic and steep.
Chapter 8 Solutions
Practical Management Science
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.8 - Prob. 16PCh. 8.8 - Prob. 17PCh. 8.8 - Prob. 18PCh. 8.8 - Prob. 19PCh. 8 - Prob. 20PCh. 8 - Prob. 21PCh. 8 - Prob. 22PCh. 8 - Prob. 23PCh. 8 - 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. 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
- Which of the following is not one of the reasons an optimization model can become nonlinear? Group of answer choices Nonconstant returns to scale. The model objective is to minimize the sum of squared differences. The model objective is a function of a variable times multiplied by a function of that same variable The model objective is to minimize the sum of absolute errors.arrow_forwardWhich of the following is true? 1.Multistart feature in Solver guarantees that the solution obtained from Solver is a global optimal solution. 2.A nonlinear optimization problem can have multiple global optimal solutions. 3.A local optimum for an optimization problem is the best point in the feasible region. 4.There is no guarantee that a solution of a linear programming model obtained from Solver is a global solution.arrow_forwardTRUE OR FALSE In a simplex maximization slack variable is added to convert the objective function to equation.arrow_forward
- Can another example be provided for c. Solve a Simple Linear Programming Problem using Simplex. The one above is a bit confarrow_forwardHome mortgage lenders often charge points on a loan in order to avoid exceeding a legal limit on interest rates or to make their rates appear competitive with those of other lenders. As an example, with a two-point loan, the lender would loan only $98 for each $100 borrowed. The borrower would receive only $98 but would have to make payments just as if he or she had received $100. In this way, the lender can make more money while keeping his or her interest rate lower. Suppose that you receive a loan of $260,000 payable at the end each month for 30 years with an interest rate of 9% compounded monthly, but you have been charged three points. What is the effective interest rate on this home mortgage loan?arrow_forwardUse simplex method for linear programming. Show solution for each iteration table. Problem: A small firm that assembles computers is about to start production of two new types of personal computers. Each type will require assembly time, inspection time, and storage space. The amount of each of these resources that can be devoted to the production of the computers is limited. The manager of the firm would like to determine the quantity of each computer to produce in order to maximize the profit generated by sales of these computers. In order to develop a suitable model of the problem, the manager has met with design and manufacturing personnel. As a result of those meetings, the manager has obtained the following information: Type 1 Type 2 Profit per unit $60 $50 Assembly time per unit 4 hours 10 hours Inspection time per…arrow_forward
- Which of the following statement is not true? A. We can get the optimal solution for IP by rounding the optimal solution for LP. B. IP is an extension of LP in which some or all of the decision variables are constrained to be an integer. C. There are three types of IP. They are Pure IP, Mixed IP, and Binary IP. D. The binary variable takes on values of 0 or 1.arrow_forwardLINGO SOFTWARE Consider a production-mix problem where we are concerned with what mix of four products we should produce during the upcoming week. For each product, each unit produced requires a known amount of production time on each of the three machines. Each machine has a certain number of hours of production time available per week. Each product provides a certain profit per unit produced. Figure 3S1.2 shows three types of data: machine-related data, product-related data, and data related to combinations of a machine and product. The objective is to determine how much to produce for each product so that total profit is maximized while not exceeding the limited production capacity of each machine. Requirement: Solve this problem in LINGO software.arrow_forwardPlease do not give solution in image format thanku A farmer in Wood County has 900 acres of land. She is going to plant each acre with corn, soybeans, or wheat. Each acre planted with corn yields a $2000 profit; each with soybeans yields a $2,500 profit; and each with wheat yields a $3,000 profit. She has 100 workers and 150 tons of fertilizer. The table below shows the requirement per acre of each of the crops. Assuming a linear relationship, use Excel Solver to determine the optimal planting mix of corn, soybeans, and wheat to maximize her profits. Corn Soybeans Wheat Labor(workers) 0.1 0.3 0.2 Fertilizer(tons) 0.2 0.1 0.4arrow_forward
- Use the simplex method to maximize the given function. Assume all variables are nonnegative.Maximize f = 7x + 8y subject to x + 2y ≤ 10 x + y ≤ 7 (x,y)= f=arrow_forwardThe method for rating teams in Example 7.8 is based on actual and predicted point spreads. This method can be biased if some teams run up the score in a few games. An alternative possibility is to base the ratings only on wins and losses. For each game, you observe whether the home team wins. Then from the proposed ratings, you predict whether the home team will win. (You predict the home team will win if the home team advantage plus the home teams rating is greater than the visitor teams rating.) You want the ratings such that the number of predictions that match the actual outcomes is maximized. Try modeling this. Do you run into difficulties? (Remember that Solver doesnt like IF functions.) EXAMPLE 7.8 RATING NFL TEAMS9 We obtained the results of the 256 regular-season NFL games from the 2015 season (the 2016 season was still ongoing as we wrote this) and entered the data into a spreadsheet, shown at the bottom of Figure 7.38. See the file NFL Ratings Finished.xlsx. (Some of these results are hidden in Figure 7.38 to conserve space.) The teams are indexed 1 to 32, as shown at the top of the sheet. For example, team 1 is Arizona, team 2 is Atlanta, and so on. The first game entered (row 6) is team 19 New England versus team 25 Pittsburgh, played at New England. New England won the game by a score of 28 to 21, and the point spread (home team score minus visitor team score) is calculated in column J. A positive point spread in column J means that the home team won; a negative point spread indicates that the visiting team won. The goal is to determine a set of ratings for the 32 NFL teams that most accurately predicts the actual outcomes of the games played.arrow_forwardYou 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_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,