Formulate an lp model for problem

Assignment Help Basic Statistics
Reference no: EM131319085

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

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: EM131319085

Questions Cloud

Is there any relationship between probability distribution : Is there any relationship between the probability distribution of the time taken for all trajectories to coalesce, and the equilibration time of a Markov chain? Prove that there is a relationship, or find a single chain that can be realized in two..
Calculate the test statistic : Use a 5% level of significance. Make sure to 1. give the null and alternative hypotheses, 2. Calculate the test statistic, and 3. give the conclusion (including a comparison to alpha or the critical value) to receive full credit.
Explains the behavioral criteria : Describes treatment options based on theoretical models and current research.Explains the behavioral criteria.Discusses potential causes and incidence rates.
Explore three of the most critical topics you have included : Create a one page outline in which you select topics and subtopics around your recommendations to improve the employee's involvement. Explain three of the most critical topics you have included in your outline, and propose a pote..
Formulate an lp model for problem : A company has $1,00,000 to invest in new R&D projects.  The company wants to determine what set of projects should be selected. The following table summarizes the initial cost and revenue potential for each of the projects.
How the economy described by the as-ad model : Understanding of how the economy described by the AS/AD model responds to various shocks under various assumed parameter values.
Analyzes the development of the system in your plan : Analyze the new system and determine the design issues with this new system.Describe how you would correct the design issues with the system to make the restaurant managers happy.Analyzes the implementation of the system in your plan. Examine how t..
Investigate the application of perfect sampling : The concept of coalescence has many applications. Some surnames are more frequent than others, and some die out altogether.
Discuss the how contrast between mythos and logos plays : Discuss the how contrast between mythos and logos plays out in the development of ancient Greek literature and philosophy

Reviews

Write a Review

Basic Statistics Questions & Answers

  Statistics-probability assignment

MATH1550H: Assignment:  Question:  A word is selected at random from the following poem of Persian poet and mathematician Omar Khayyam (1048-1131), translated by English poet Edward Fitzgerald (1808-1883). Find the expected value of the length of th..

  What is the least number

MATH1550H: Assignment:  Question:     what is the least number of applicants that should be interviewed so as to have at least 50% chance of finding one such secretary?

  Determine the value of k

MATH1550H: Assignment:  Question:     Experience shows that X, the number of customers entering a post office during any period of time t, is a random variable the probability mass function of which is of the form

  What is the probability

MATH1550H: Assignment:Questions: (Genetics) What is the probability that at most two of the offspring are aa?

  Binomial distributions

MATH1550H: Assignment:  Questions:  Let’s assume the department of Mathematics of Trent University has 11 faculty members. For i = 0; 1; 2; 3; find pi, the probability that i of them were born on Canada Day using the binomial distributions.

  Caselet on mcdonald’s vs. burger king - waiting time

Caselet on McDonald’s vs. Burger King - Waiting time

  Generate descriptive statistics

Generate descriptive statistics. Create a stem-and-leaf plot of the data and box plot of the data.

  Sampling variability and standard error

Problems on Sampling Variability and Standard Error and Confidence Intervals

  Estimate the population mean

Estimate the population mean

  Conduct a marketing experiment

Conduct a marketing experiment in which students are to taste one of two different brands of soft drink

  Find out the probability

Find out the probability

  Linear programming models

LINEAR PROGRAMMING MODELS

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