Concept explainers
Explanation of Solution
Formulation of LP:
Where,
The formulation of problem is more like, transportation problem. Here, sources at one end and demand at the other. Here, source is the amount of dollars, pounds, marks and yen and at the beginning of the day and demand is the amount want at the end of the day. With variable
Requirement Constraints:
Here, it is required 6 Billion Pounds, 1 Billion pounds and 8 Billion marks.
Supply Constraints:
At the start of the day, there are 8 Billion dollars, 1 Billion pounds and 8 Billion marks. So,
Demand constraints:
While converting from one currency to another, it need to keep account of the conversion rate
Want to see the full answer?
Check out a sample textbook solutionChapter 3 Solutions
Introduction to mathematical programming
- (b) Using VLOOKUP, write a formula in cell G24 to find the rate per hour from Table 8 for the given server size. Copy the formula to G25 to G41. (c) Using IF and VLOOKUP functions, write a formula in cell H24 to find the spot server's discount rate. For on-demand servers, the discount rate is 0%. Copy the formula to H25 to H41. SCREENSHOTS ARE ATTACHED BELOW Write down the formula needed to solve for the cells neededarrow_forwardPortfolio manager Max Gaines needs to develop an investment portfolio for his clients who are willing to accept a moderate amount of risk. His task is to determine the proportion of the portfolio to invest in each of the five mutual funds listed below so that the portfolio maximizes the expected return but provides an annual return of no less than 3%. for each of the following scenarios. Annual Returns (Planning Scenarios): mutual fund yr 1 yr 2 yr 3 yr 4 international stock 22.37 26.73 6.46 -3.19 low-cap blend 14.88 18.61 10.52 5.25 mid-cap blend 19.45 18.04 5.91 -1.94 small-cap blend 13.79 11.33 -2.07 6.85 intermediate bond 7.29 8.05 9.18 3.92 Formulate the appropriate linear program for this situation. (state the objective function, the decision variables, and the constraints)arrow_forwardIf you have a column of cash flows from years 0 to n and you wish to calculate the present worth of the cash flows. You could use the following EXCEL function(s) for solving the problem with an excel spread sheet: None of these answers is correct RATE IRR PMT PV or NPVarrow_forward
- Operations Research : Applications and AlgorithmsComputer ScienceISBN:9780534380588Author:Wayne L. WinstonPublisher:Brooks Cole