Formulate an lp model for problem

Assignment Help Basic Statistics
Reference no: EM131319783

A company has $1,000,000 to invest in new R&D projects. The company wants to determine what set of projects should be selected.

[Deterministic Scenario] The following table summarizes the initial cost and revenue potential for each of the projects:

Project

Initial Cost

Expected Revenue

1

$500,000

$1,500,000

2

$500,000

$1,500,000

3

$500,000

$1,800,000

4

$500,000

$1,800,000

a.) Formulate an LP model for this problem with the objective of maximizing total profit

b.) Implement your model in a spreadsheet and solve it

c.) What is the optimal solution?

Reference no: EM131319783

Questions Cloud

Why can the magnetic flux density vector be expressed : Discuss the analogy between the magnetic vector potential due to an infinitesimal current element and the electric scalar potential due to a point charge.
How you will address jim recent performance issues : Write a one (1) page paper in which you: Explain how you will address Jim's recent performance issues. Suggest both constructive and positive feedback designed so that Jim will leave motivated to do his best
Calculate the annual depreciation : The price of a railroad car purchased by Rio Corporation was $78,600. Using the MACRS method, calculate the annual depreciation for year 3. (Round all dollar amounts to the nearest cent)
Gamma and vega of a delta-neutral portfolio : The gamma and vega of a delta-neutral portfolio are 60 per $ per $ and 25 per %, respectively. Estimate what happens to the value of the portfolio when there is a shock to the market causing the underlying asset price to decrease by $3 and its volati..
Formulate an lp model for problem : a.) Formulate an LP model for this problem with the objective of maximizing total profit b.) Implement your model in a spreadsheet and solve it. c.) What is the optimal solution?
Bonds make seminannual payments : Stone Sour Corp issued 20 year bonds two years ago at a coupon rate of 7.1 percent. The bonds make seminannual payments. If these bonds currently sell for 105 percent of par value, what is the YTM?
Who is skill at persuavive messages : Who is skill at persuavive messages. Write a 350- to 700-word persuasive e-mail in a Microsoft Word document to a manager or coworker requesting a change to the workplace.
Market has dividend payout ratio : Buster’s Market has a dividend payout ratio of 30 percent. The firm does not want to issue additional equity shares nor increase its debt at this time. The firm is profitable. Which one of the following defines the maximum rate at which this firm can..
Discuss the application of the magnetic vector : Discuss the application of the magnetic vector potential in the determination of the electromagnetic fields due to an antenna.

Reviews

Write a Review

Basic Statistics Questions & Answers

  Assuming the incomes are normally distributed find the

for women age 25-34 with full-time jobs the average income in 2004 was 32000 and the sd for income was 26000. assuming

  A certain single-server system

A certain single-server system has been simulated, with the following sequence of waiting times before service for the respective customers. Use the regenerative method to obtain a point estimate and 90 percent confidence interval for the steady-s..

  Making evaluative judgment about work of literature

Literary criticism implies close reading more than making an evaluative judgment about a work of literature. Look up the term online. In your own words, what will you do to analyze textual material? What was your initial response to the poem you a..

  How many sides does the polygon have.

ratio of corresponding sides of similar triangles is 4:9, ratio of the area of the smaller to the larger triangle is?

  Random or systematic sources of error

Which of the following are random or systematic sources of error? (a) Power failure during equipment test

  Level of satisfaction in a consumer survey

The level of satisfaction in a consumer survey would represent what level of measurement?

  Underlying population and testing procedure

Suppose that n = 9, ¯X = 85 and the sample standard deviation is s = 2. Test H0: μ = 83 against H1 : μ ≠ 83, stating any assumptions made about the underlying population, and the testing procedure.

  Perform the appropriate test to substantiate kumons claims

kumon promotes a method of studying mathematics that it claims develops mathematical ability. do data support this

  Find the probability that the one-year return of this stock

suppose that the annual rate of return for a common biotechnology stock is normally distributed with a mean of 5 and a

  The following data represent the amount of sugar consumed

the following data represent the amount of sugar consumed in lbs. in a household during five randomly selected weeks.

  Development of the european union

Discuss the development of the European Union. What led to its formation, what were its objectives, and what challenges has the EU faced?

  An experiment involves selecting a random sample of 256

an experiment involves selecting a random sample of 256 middle managers at a random for study. one item of interest is

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd