Consider a small Oil production firm with 5 competing oil production projects, A - E. The table below shows the estimated long-term profit (Net Present Value) for each project as well as the amount of investment capital required to start the project. You have been contacted to help select the best combination of projects to maximize the Net Present Value subject to the capital investment limit of $32 million. Production Project A B C D E Estimated Profit (millions) 25 20 19 28 21 Capital Required (millions) 11 8 14 19 13 Formulate a Binary Integer Programming (BIP) model on a spreadsheet. Solver the model using Solver.
Q: Drylce, Inc. is a manufacturer of air conditioners that has seen its demand grow significantly. The…
A: Since you have submitted multiple question, we solved first queestion clearly for remaining…
Q: n operations manager wants to use cost-profit-volume (CPV) analysis to decide the location of a new…
A: Given that the target production quantity (volume) is 10,000 units total cost of this location,…
Q: (triple constraint)
A: TRIPLE CONSTRAINT
Q: Production and sales estimates for March for Robin Co. are as follows: Estimated inventory (units),…
A: Production estimates link to the number of proposed units to be produced taking into account…
Q: The Advanced Tech Company has a project to design an integrated information data base for a major…
A: A crashing schedule helps the project team to reduce the normal duration for completing the project…
Q: May I have the linear programming graph (or model) or plot with the given following information? 3…
A: Objective Functions and Constraints: Based on the given details, we found the…
Q: 2 Use the simplex algorithm to find the optimal solution to the following LP: min z = -4x, + x2 s.t.…
A:
Q: Dumaguete City Oil Mills, Inc must choose among a series of new investment alternatives. The…
A: Integer programming communicates the improvement of a direct capacity subject to a bunch of straight…
Q: The Lotus Point Condo Project will contain both homes and apartments. The site can accommodate up to…
A:
Q: Suppose a payoff table for player 1 in a two person zero sum game is a follows where both the…
A: The game theory consists of various calculation methods and helps make decisions in a competitive…
Q: Fenerbahçe's authentic licensed products are sold by Fenerbahçe Sportif Inc.'s "Fenerium" stores…
A: Selecting a project makes it binary integer problem where 1 means project is selected and 0 means…
Q: Explain the importance of project risk management for the Aquaponics Project. 2. Identify and…
A: Note: we'll answer the first question since the exact one wasn't specified. Please submit a new…
Q: Four jobs are to be assigned to employees. There are 5 available employees. Durations for each…
A: The aim of an assignment problem is to assign one employee to each task in a way such that the total…
Q: The Advanced Tech Company has a project to design an integrated information data base for a major…
A: A network diagram is a visual representation of a project which helps to identify the project…
Q: A firm has prepared the following binary integer program to evaluate a number of potential locations…
A:
Q: (a) Formulate a linear programme to determine an investment plan that will maximize the the total…
A: Linear programming is a mathematical technique that is also used in operations management…
Q: Assume that an economy is based on two industrial sectors, agriculture (A) and energy (E). The…
A: The economy is based on two Industrial sectors, Agriculture (A) and Energy (E). The crucial thing to…
Q: A firm has prepared the following binary integer program to evaluate a number of potential locations…
A: Objective Function: Max 15x1 + 15x2 + 15x3+ 30x4
Q: Use the Big-M method to find an initial basic feasible solution for the following LP: max z = 3xị +…
A: Solution Max Z=3x1+x2subject to1. x1+x2≥32. 2x1+x2≤43. x1+x2=34. x1,x2≥0The problem is converted to…
Q: Fox Enterprises is considering six projects for possible construction over the next four ycars. Fox…
A: Let 'Bj' be the sum borrowed for year-j. Change the constraints of the original problems as: 10.5 X1…
Q: develope a space matrix for macdonalds.
A: Ans. Introduction The space matrix is a management tool which is used by a company to determine the…
Q: Given the linear program Max 3x+4y S.T. -x+2y/=0 A. Write the…
A:
Q: The Advanced Tech Company has a project to design an integrated information data base for a major…
A: The question is related to Crashing. The project details are given along with activities, normal…
Q: How is linear programming used in real-world applications? expand the answer.
A: Linear programming is the method used to get the best result for a particular problem in a…
Q: In 1862, during the second year of the Civil War, General Thomas J. “Stonewall” Jackson fought a…
A: In this question, there are several locations and no. of days shown in the network diagram. Network…
Q: Solve this problem to optimality and answer the following questions:
A: Linear programming is a mathematical technique that is also used in operations management…
Q: , objective tree and logical framework matrix, and (ii) logical framework matrix, action plan and…
A: Both problem tree and objective tree play important role in goal setting. Logical framework matrix…
Q: 14
A: Determine the iteration 3 table:As it should follow least cost method, in iteration 1 (given), 0…
Q: Use the information below to answer the following question. Maximize: 2X, + 3X2 Subject X2 1. to: 2.…
A: First let me formulate the LP programming Maximize Z=2*X1+3*X2 Constraints are X1 + X2=<6…
Q: Considering the equations shown in figure below as constraints. Determine the optimum solution of…
A: Note: - Since we can answer only up to 3 subparts, we will answer subpart a, b, and c for your…
Q: Refer to the following matrices. A = −1 2 3 −2 5 0 B = 3 2 5 1 −3 3 Compute 2A −…
A:
Q: The first question answer the following questions: 1. What is the optimization (Optimization)? How…
A: Optimization refers to the process of making something fully potential, functional, and effective.
Q: A company imports goods at two ports: Philadelphia and New Orleans. Shipments of one product are…
A: Decision variables: Let , A , D ,C And B are the Customers and P and N are the Suppliers…
Q: Maximize C = 13x + 3y subject to 12x + 14y ≤ 21 15x + 20y ≤ 37 and x ≥ 0, y ≥ 0. What is the…
A: Linear programming is a mathematical technique that is also used in operations management…
Q: Refer to the following matrices. A = −1 5 4 −5 4 0 B = 3 4 2 1 −3 3 Compute A + B.
A:
Q: 4
A: In the decision tree, An expected value is acquired by multiplying the value of each possible…
Q: Consider the following linear program. Max 2A + 3B s.t.…
A: Given data is
Q: Fox Enterprises is considering six projects for possible construction over the next four ycars. Fox…
A: Given Data, Cash Outlay Project Year 1 ` Year 2 Year 3 Year 4 Return ($1000) 1 10.5…
Q: A firm has prepared the following binary integer program to evaluate a number of potential locations…
A: Objective Functions and Constraints: Based on the given details, the objective…
Q: A firm has prepared the following binary integer program to evaluate a number of potential locations…
A:
Q: a) Use integer linear programming to solve the capital rationing problem with the project listed…
A:
Q: A firm has prepared the following binary integer program to evaluate a number of potential locations…
A: Linear programming, often known as linear optimization, is a method for obtaining the best result…
Q: A firm has prepared the following binary integer program to evaluate a number of potential locations…
A:
Q: A firm has prepared the following binary integer program to evaluate a number of potential locations…
A: Given,
Q: Second consulting is considering undertaking several proposed projects for the next fiscal year. The…
A: we would just formulate an ILP model assuming there is no need to solve the so obtained model-
Q: Fox Enterprises is considering six projects for possible construction over the next four ycars. Fox…
A: Since we only answer up to 3 sub-parts, we’ll answer the first 3. Please resubmit the question and…
Q: Identify and explain at least five (5) project constraints, and explain the working of the triple…
A: Project constraints are some limitations, some limit which cannot cross this is just called as…
Q: Company Z is contemplating a product development program encompassing 6 major projects. The company…
A: Here, let me formulate the Linear programming problem, Decision variable: Project 1 is 1, If…
Q: Consider the followingg linear programming problem: Max 3A + 3B st. 2A + 4B ≤ 12 6A + 4B ≤ 24…
A:
Consider a small Oil production firm with 5 competing oil production projects, A - E.
The table below shows the estimated long-term profit (
You have been contacted to help select the best combination of projects to maximize the Net Present Value subject to the capital investment limit of $32 million.
|
Production Project |
||||
|
A |
B |
C |
D |
E |
Estimated Profit (millions) |
25 |
20 |
19 |
28 |
21 |
Capital Required (millions) |
11 |
8 |
14 |
19 |
13 |
- Formulate a Binary Integer Programming (BIP) model on a spreadsheet.
- Solver the model using Solver.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
- If a monopolist produces q units, she can charge 400 4q dollars per unit. The variable cost is 60 per unit. a. How can the monopolist maximize her profit? b. If the monopolist must pay a sales tax of 5% of the selling price per unit, will she increase or decrease production (relative to the situation with no sales tax)? c. Continuing part b, use SolverTable to see how a change in the sales tax affects the optimal solution. Let the sales tax vary from 0% to 8% in increments of 0.5%.Seas Beginning sells clothing by mail order. An important question is when to strike a customer from the companys mailing list. At present, the company strikes a customer from its mailing list if a customer fails to order from six consecutive catalogs. The company wants to know whether striking a customer from its list after a customer fails to order from four consecutive catalogs results in a higher profit per customer. The following data are available: If a customer placed an order the last time she received a catalog, then there is a 20% chance she will order from the next catalog. If a customer last placed an order one catalog ago, there is a 16% chance she will order from the next catalog she receives. If a customer last placed an order two catalogs ago, there is a 12% chance she will order from the next catalog she receives. If a customer last placed an order three catalogs ago, there is an 8% chance she will order from the next catalog she receives. If a customer last placed an order four catalogs ago, there is a 4% chance she will order from the next catalog she receives. If a customer last placed an order five catalogs ago, there is a 2% chance she will order from the next catalog she receives. It costs 2 to send a catalog, and the average profit per order is 30. Assume a customer has just placed an order. To maximize expected profit per customer, would Seas Beginning make more money canceling such a customer after six nonorders or four nonorders?The eTech Company is a fairly recent entry in the electronic device area. The company competes with Apple. Samsung, and other well-known companies in the manufacturing and sales of personal handheld devices. Although eTech recognizes that it is a niche player and will likely remain so in the foreseeable future, it is trying to increase its current small market share in this huge competitive market. Jim Simons, VP of Production, and Catherine Dolans, VP of Marketing, have been discussing the possible addition of a new product to the companys current (rather limited) product line. The tentative name for this new product is ePlayerX. Jim and Catherine agree that the ePlayerX, which will feature a sleeker design and more memory, is necessary to compete successfully with the big boys, but they are also worried that the ePlayerX could cannibalize sales of their existing productsand that it could even detract from their bottom line. They must eventually decide how much to spend to develop and manufacture the ePlayerX and how aggressively to market it. Depending on these decisions, they must forecast demand for the ePlayerX, as well as sales for their existing products. They also realize that Apple. Samsung, and the other big players are not standing still. These competitors could introduce their own new products, which could have very negative effects on demand for the ePlayerX. The expected timeline for the ePlayerX is that development will take no more than a year to complete and that the product will be introduced in the market a year from now. Jim and Catherine are aware that there are lots of decisions to make and lots of uncertainties involved, but they need to start somewhere. To this end. Jim and Catherine have decided to base their decisions on a planning horizon of four years, including the development year. They realize that the personal handheld device market is very fluid, with updates to existing products occurring almost continuously. However, they believe they can include such considerations into their cost, revenue, and demand estimates, and that a four-year planning horizon makes sense. In addition, they have identified the following problem parameters. (In this first pass, all distinctions are binary: low-end or high-end, small-effect or large-effect, and so on.) In the absence of cannibalization, the sales of existing eTech products are expected to produce year I net revenues of 10 million, and the forecast of the annual increase in net revenues is 2%. The ePIayerX will be developed as either a low-end or a high-end product, with corresponding fixed development costs (1.5 million or 2.5 million), variable manufacturing costs ( 100 or 200). and selling prices (150 or 300). The fixed development cost is incurred now, at the beginning of year I, and the variable cost and selling price are assumed to remain constant throughout the planning horizon. The new product will be marketed either mildly aggressively or very aggressively, with corresponding costs. The costs of a mildly aggressive marketing campaign are 1.5 million in year 1 and 0.5 million annually in years 2 to 4. For a very aggressive campaign, these costs increase to 3.5 million and 1.5 million, respectively. (These marketing costs are not part of the variable cost mentioned in the previous bullet; they are separate.) Depending on whether the ePlayerX is a low-end or high-end produce the level of the ePlayerXs cannibalization rate of existing eTech products will be either low (10%) or high (20%). Each cannibalization rate affects only sales of existing products in years 2 to 4, not year I sales. For example, if the cannibalization rate is 10%, then sales of existing products in each of years 2 to 4 will be 10% below their projected values without cannibalization. A base case forecast of demand for the ePlayerX is that in its first year on the market, year 2, demand will be for 100,000 units, and then demand will increase by 5% annually in years 3 and 4. This base forecast is based on a low-end version of the ePlayerX and mildly aggressive marketing. It will be adjusted for a high-end will product, aggressive marketing, and competitor behavior. The adjustments with no competing product appear in Table 2.3. The adjustments with a competing product appear in Table 2.4. Each adjustment is to demand for the ePlayerX in each of years 2 to 4. For example, if the adjustment is 10%, then demand in each of years 2 to 4 will be 10% lower than it would have been in the base case. Demand and units sold are the samethat is, eTech will produce exactly what its customers demand so that no inventory or backorders will occur. Table 2.3 Demand Adjustments When No Competing Product Is Introduced Table 2.4 Demand Adjustments When a Competing Product Is Introduced Because Jim and Catherine are approaching the day when they will be sharing their plans with other company executives, they have asked you to prepare an Excel spreadsheet model that will answer the many what-if questions they expect to be asked. Specifically, they have asked you to do the following: You should enter all of the given data in an inputs section with clear labeling and appropriate number formatting. If you believe that any explanations are required, you can enter them in text boxes or cell comments. In this section and in the rest of the model, all monetary values (other than the variable cost and the selling price) should be expressed in millions of dollars, and all demands for the ePlayerX should be expressed in thousands of units. You should have a scenario section that contains a 0/1 variable for each of the binary options discussed here. For example, one of these should be 0 if the low-end product is chosen and it should be 1 if the high-end product is chosen. You should have a parameters section that contains the values of the various parameters listed in the case, depending on the values of the 0/1 variables in the previous bullet For example, the fixed development cost will be 1.5 million or 2.5 million depending on whether the 0/1 variable in the previous bullet is 0 or 1, and this can be calculated with a simple IF formula. You can decide how to implement the IF logic for the various parameters. You should have a cash flows section that calculates the annual cash flows for the four-year period. These cash flows include the net revenues from existing products, the marketing costs for ePlayerX, and the net revenues for sales of ePlayerX (To calculate these latter values, it will help to have a row for annual units sold of ePlayerX.) The cash flows should also include depreciation on the fixed development cost, calculated on a straight-line four-year basis (that is. 25% of the cost in each of the four years). Then, these annual revenues/costs should be summed for each year to get net cash flow before taxes, taxes should be calculated using a 32% tax rate, and taxes should be subtracted and depreciation should be added back in to get net cash flows after taxes. (The point is that depreciation is first subtracted, because it is not taxed, but then it is added back in after taxes have been calculated.) You should calculate the company's NPV for the four-year horizon using a discount rate of 10%. You can assume that the fixed development cost is incurred now. so that it is not discounted, and that all other costs and revenues are incurred at the ends of the respective years. You should accompany all of this with a line chart with three series: annual net revenues from existing products; annual marketing costs for ePlayerX; and annual net revenues from sales of ePlayerX. Once all of this is completed. Jim and Catherine will have a powerful tool for presentation purposes. By adjusting the 0/1 scenario variables, their audience will be able to see immediately, both numerically and graphically, the financial consequences of various scenarios.
- Suppose you currently have a portfolio of three stocks, A, B, and C. You own 500 shares of A, 300 of B, and 1000 of C. The current share prices are 42.76, 81.33, and, 58.22, respectively. You plan to hold this portfolio for at least a year. During the coming year, economists have predicted that the national economy will be awful, stable, or great with probabilities 0.2, 0.5, and 0.3. Given the state of the economy, the returns (one-year percentage changes) of the three stocks are independent and normally distributed. However, the means and standard deviations of these returns depend on the state of the economy, as indicated in the file P11_23.xlsx. a. Use @RISK to simulate the value of the portfolio and the portfolio return in the next year. How likely is it that you will have a negative return? How likely is it that you will have a return of at least 25%? b. Suppose you had a crystal ball where you could predict the state of the economy with certainty. The stock returns would still be uncertain, but you would know whether your means and standard deviations come from row 6, 7, or 8 of the P11_23.xlsx file. If you learn, with certainty, that the economy is going to be great in the next year, run the appropriate simulation to answer the same questions as in part a. Repeat this if you learn that the economy is going to be awful. How do these results compare with those in part a?Solve Problem 1 with the extra assumption that the investments can be grouped naturally as follows: 14, 58, 912, 1316, and 1720. a. Find the optimal investments when at most one investment from each group can be selected. b. Find the optimal investments when at least one investment from each group must be selected. (If the budget isnt large enough to permit this, increase the budget to a larger value.)