What is the total net present value of these projects?Total net present value Your employer is trying to select from a list of possible capital projects. The projects, along with their cost and benefits, are listedbelow. The capital budget available is $1 million. In addition to spending constraints, your employer would like to select at least 2projects. Projects 5 and 4 cannot both be selected together. Formulate the problem as a linear program and determine the optimalsolution.ProjectCostNet Present Value$295,000$285,000$300,000$250,000$240,000$680,000$610,000$470,000$630,000$650,000134Which projects should be selected?Project 1 willProject 2 willProject 3 willProject 4 willProject 5 willbe selectednot be selected

Let xi be the binary number whether the project i is selected if 1, 0 if not The NPV must be…

Answered: Your employer is trying to select from…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Company F needs to determine the amount of units to produce for the coming holiday season. They currently have 2,000 units in their beginning inventory. They are expecting a market demand of 18,000 units. Their ending inventory needs to be 20% of the current market demand. How many units do they need to produce for the holiday season?
A car rental firm needs to relocate cars for the coming month. Three of the cities are projected to have a surplus of cars, and three are expected to have a shortage. The following table shows the cost (in hundred shillings) of relocating a car from a surplus city to a shortage city. Als shown are the projected shortages and surplus for the different cities. Surplus city F1 F2 F3 No. of cars short a. 21950 O b. 152000 19500 C. D1 8 4 7 90 d. 219500 Shortage city D2 6 9 6 65 Use the North-West corner method to determine the initia basic feasible solution in shillings. D3 10 8 5 145 Surplus car 105 120 75
The following payoff table shows profit for a decision analysis problem with two decision alternatives and three states of nature. Decision Alternative d₁ d₂ = EV(d₁) EV(d₂) The optimal decision is ? States of Nature $1 $2 230 80 $3 80 5 Suppose that the decision maker obtained the probabilities P(S₁) = 0.65, P(S₂) = 0.15, and P(S3) = 0.20. Use the expected value approach to determine the optimal decision. 80 55
Assume that $1,285,673 is to be invested in a project whose annual projected cash flows are as follows: Year 1 = $235,678, Year 2 = $267,854, Year 3 = $298,054, Year 4 = $314,567, and Year 5 = $325,678. Assume that the required rate of return is 5.25%. Compute the NPV by using Microsoft Excel's NPV function. Be sure to show your work. Should the project be pursued? Why or why not?
The DellaVecchia Garden Center purchases and sells Christmas trees during the holiday season. It purchases the trees for $10 each and sells them for $20 each. Any trees not sold by Christmas day are sold for $2 each to a company that makes wood chips. The garden center estimates that four levels of demand are possible: 100, 200, 500, and 1,000 trees.a. Compute the payoffs for purchasing 100, 200, 500, or1,000 trees for each of the four levels of demand.b. Construct a payoff table, indicating the events and alternative courses of action.c. Construct a decision tree.d. Construct an opportunity loss table. Use the Optimistic (maximax) to choose the best choice.e.Use the Pessimistic (maximin) to choose the best choice.f.Use the Criterion of realism (Hurwicz) to choose the best choice. α = 0.6g.Use the Equally likely (Laplace) to choose the best choice.h.Use the Minimax regret to choose the best choice.i.Use the expected monetary value to make a choice. ( Probability for the four level…
Four proposals are being considered with investment and NPW shown below. C can only beconsidered if B is implemented. B and D and E are mutually exclusive. The budget is $80.A B C D EInvestment $10 $20 $30 $40 $50NPW $34 $28 $20 $16 $32a) Formulate this as a 0-1 integer program (objective function and constraints).b) Use trial and error to find all feasible solutions, and indicate which is optimal.c) Set up this problem in Excel, and use Solver to find the same optimal solution
Donald Harris received a windfall and needs to invest it for tax reasons. He went to his brother-in-law, Joe Harris, who is a financial advisor. Joe prepared a matrix that illustrated the possible returns on investment for different investment strategies under different economic conditions. That matrix is given below. Given these values, what type of investment strategy would be selected by the Maximincriterion? Future Air Traffic Strategies Major Downturn Downturn Upturn Major Upturn Contrarian 20% 10% 5% -15% Risk Averse 2% 4% 7% 10% Growth -10% -8% 13% 20% Aggressive -25% -20% 11% 35% Group of answer choices
Georgia Electronics produce two calculators: Graphic (G) and Financial (F). The model is given below: Max Total Profit = 5*G + 10 F S.T.: Contract w/supplier 30*G + 15 F >= 600 4'G - 8'F >= 50 12 G+ 6*F = 0 The optimal solution is (G=55.83, F=21.67) and total profit = 495.83. See sensitivity %3D report below.
Using Goal Seek for the following problem, how much is needed for John to deposit each year into an account to save $5,000 for his new Specialized Mountain bike. Assumes both deposit and withdrawal are at beg of each year Deposit = Interest= Yr 0 Yr 1 Yr 2 Beg Balance $0.00 $0.00 $0.00 Deposit $0.00 $0.00 -$5,000.00 Interest Earned 8% $0.00 $0.00 na End Balance $0.00 $0.00 -$5,000.00
Andy Mendoza makes handcrafted dolls, which he sells at craft fairs. He is considering mass producing the dolls to sell in stores. He estimates that the initial investment for plant and equipment will be $10,000, while labor, material, packaging, and shipping will be about $8 per doll. He has determined that monthly sales volume is related to price, according to the following equation: v=5000-90p. Develop the nonlinear profit function as a function of price.

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS