Your employer is trying to select from a list of possible capital projects. The projects, along with their cost and benefits, are listed below. The capital budget available is $1 million. In addition to spending constraints, your employer would like to select at least 2 projects. Projects 2 and 4 cannot both be selected together. Formulate the problem as a linear program and determine the optimal solution. Project 1 SAWNH 2 3 5 Project 1 will Project 2 will Cost $ 250,000 $ 500,000 $ 290,000 $ 650,000 $ 750,000 Which projects should be selected? Project 3 will Project 4 will Project 5 will be selected be selected Net Present Value $ 500,000 $750,000 $ 333,000 $ 400,000 $ 600,000 be selected be selected not be selected

Your employer is trying to select from a list of possible capital projects. The projects, along with their cost and benefits, are listed below. The capital budget available is $1 million. In addition to spending constraints, your employer would like to select at least 2 projects. Projects 2 and 4 cannot both be selected together. Formulate the problem as a linear program and determine the optimal solution. Project 1 SAWNH 2 3 5 Project 1 will Project 2 will Cost $ 250,000 $ 500,000 $ 290,000 $ 650,000 $ 750,000 Which projects should be selected? Project 3 will Project 4 will Project 5 will be selected be selected Net Present Value $ 500,000 $750,000 $ 333,000 $ 400,000 $ 600,000 be selected be selected not be selected

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

Formulate an LP model for the following problems.1. Bernadette intends to invest up to ₱50,000 in either Best Fund, or a time deposit orboth. The Best Fund pays 8% per year and the time deposit pays 9%. Because theBest Fund is riskier than the time deposit, so she intends to put at most ₱30,000 intothe time deposit and at least ₱10,000 into the Best Fund. How much should she allotto each investment in order to maximize her returns?
1. A company would like to invest in the metal stock market, and the maximum available investment is $4,500,000. Write all associated equations (Profit equation, metals constrain equations and special comtrain equations), then use Excel to find the best compensation of stocks to maximize the profit, if Metal Interest return ($) Up to allowed investment Gold 0.45 Silver 0.35 Copper 0.17 0:37 1,200,000 And the compsey put the following two constrains a. At least 35% of the stocks must be Copper b. 25% of the stocks should be Gold and silver Copper must be less than won Iron 5,600,000 3,500,000 Styles 1,500,000
DONT SOLVE WRONG... SOLVE IF YOU ARE 5000% SURE Jaclyn is considering opening a location on campus to sell bubble tea. Her rent would be $500/month and she expects to sell each drink for $5. Variable costs are $0.85 and labor is $1.77. She also has the option to share space with a friend, which would cost her only $300/month in rent. Her friend wants $0.03 per bubble tea revenue sharing. What is Jaclyn’s new break-even point? If she sells 264 bubble teas, which option does she prefer? a. She prefers sharing space with her friend at Q=264. b. She is indifferent between the two choices at Q=264. c. She prefers working by herself at Q=264.
Conoly Co. has identified an investment projectwith the following cash flows. If the discount rate is 10 percent, what is the present valueof these cash flows? What is the present value at 18 percent? At 24 percent?Year Cash Flow1 $ 9602 8403 9354 1,350
Rollo Megabux has $1 million to invest in stocks orbonds. The percentage yield on each investment during thecoming year depends on whether the economy has a goodor a bad year (see Table 17). It is equally likely that theeconomy will have a good or a bad year.a If Rollo is risk-neutral, how should he invest hismoney?b For $10,000, Rollo can hire a consulting firm toforecast the state of the economy. The consulting firm’sforecasts have the following properties:P(good forecast|economy good) .80P(good forecast|economy bad) .20Should Rollo hire the consulting firm? What are EVSIand EVPI? Economy EconomyHas Good Has BadYear YearYield on stocks 22% 10%Yield on bonds 16% 14%
A company is considering a new product launch. There is a 0.6 chance thatdemand for the product will be strong and a 0.4 chance that demand will beweak. Two strategies for the launch are possible: 1 has high promotion costs anda net cash outflow of K120 000 if demand proves to be strong, and if demandproves weak a net cash outflow of (K30 000) will result. Strategy 2 has lowpromotion costs and if demand is strong will generate a cash inflow of only K80000 but with weak demand a net cash inflow of K20 000. i. Draw a decision tree and advise which course of action generates thegreatest expected profit. ii. What is the maximum amount that should be paid for market research todetermine with certainty whether demand will be strong or weak?
Consider a project with the following cash flows: year 1, 2$400; year 2, $200; year 3, $600; year 4, 2$900; year 5, $1000; year 6, $250; year 7, $230. Assume a discount rate of 15% per year.a. Find the project’s NPV if cash flows occur at the ends of the respective years.b. Find the project’s NPV if cash flows occur at the beginnings of the respective years.c. Find the project’s NPV if cash flows occur at the middles of the respective years.
A business student has $3,500 available from a summer job and has identified three potential stocks in which to invest. The cost per share and expected return over the next two years are given in the table. Complete parts a and b. A $12 $8 Stock Price/share Return/share B $16 $5 A. Amount invested in stock A B. Amount invested in stock B C. Return for each stock D. Amount invested in stock C E. Price of each stock C $25 $11 a. Identify the decision variables, objective function, and constraints in simple verbal expressions. Identify the decision variables. Select all that apply.
A. Write a document with the following information: 1. What do you expect your job to pay when you start? 2. What benefits are musts for you? 3. What benefits would you like to have even though they are not musts? 4. Include the graph you generate in step B below. B. Create a spreadsheet and a graph of life vs funds For each year of your remaining life specify the amount you plan to save/invest/withdraw that year and how much you expect that amount to increase during the year (base on actual data – typical savings interest rate, typical stock market interest rate, typical CDs, typical…). Calculate how much your funds will increase/decrease over your life and create a life (x-axis) vs funds (y-axis) plot.
Lisa purchased her home 5 years ago for $265,000. Lisa stopped making payments on her home loan, id unfortunately, the real estate market has gone down significantly in recent years. Lisa needs to sell her me immediately to avoid foreclosure; however, her property is now only worth $189,000. What should sa do next? Work with her lender to sell her property as a short sale. Take out a second mortgage to catch up on her home loan payments. Sell her property off as an REO. Simply walk away from the property.
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
Vivian and Wayne are planning on going to Lamazenatural childbirth classes. Lamaze classes meet once a weekfor five weeks. Each class gives 20% of the knowledge neededfor “natural” childbirth. If Vivian and Wayne finish theirclasses before the birth of their child, they will forget duringeach week 5% of what they have learned in class. To maximizetheir expected knowledge at the time of childbirth, duringwhich week of pregnancy should they begin classes? Assumethat the number of weeks from conception to childbirthfollows the probability distribution given in Table 9. Week of Birth Probability36 .0537 .1539 .2040 .3041 .1542 .1043 .05