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

  What is the probability that this show will be cancelled

What is the probability that this show will be cancelled if 13.4% of all viewing households are watching it? That is, what is the probability that a sample will lead to rejection of the null hypothesis?

  Population mean weight of non-athlete

At the 5% level of significance, can we infer that the population mean weight of athletic men is lower than the population mean weight of non-athletic men by more than 2 pounds?

  What is variance on in general population

She samples a group of 100 new fathers and finds that their mean is 64.5. What is the variance on this questionnaire in the general population?

  To estimate the average time required for certain repairs

With reference to Exercise 25, use the large-sample confidence-interval formula of Exercise 19 to construct a 98% confidence interval for the standard deviation of the time it takes a mechanic to perform the given task.

  Question on chi square test for goodness of fit

A personnel manager is concerned about absenteeism. She decides to sample the records to determine if absenteeism is distributed evenly throughout the six-day workweek.

  Determine test t-statistic

The changing ecology of the swamps in Louisiana has been the subject of much environmental research. One water-quality parameter of concern is the total phosphorous level.

  A symmetric traveling salesman problem

Traveling Salesman Problem/Triangle Inequality) Consider a symmetric traveling salesman problem where the arc costs are nonnegative and satisfy the following triangle inequality:

  Chi-square for the standard deviation

If 20 measurements are taken and their standard deviation is 1.8, is there enough evidence to reject the claim that her standard deviation is within the limit at ∞ = .01?

  Question about mean value

A normal distributed population has a mean of 250 pounds and a standard deviation of 10 pounds. Given n = 20, what is the probability that this sample will have a mean value between 245 and 255 pounds?

  Classify each scenario as one of the following sampling

a bank with branches in a large metropolitan area is considering opening its offices on saturday but it is uncertain

  There are 1000 natural numbers a1 a2 a1000 prove that of

there are 1000 natural numbers a1 a2.... a1000. prove that of the numbers 3a1 3a2.... 3a1000 there must be 56 of them

  What is the probability that there will be a severe weather

the weather forecast for tomorrow indicates that there is a 70 chance that there will be a high wind speed. the

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