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

  Regression analysis-current salaries

Your employer asks you to determine whether current salaries (DV) can be predicted from years of experience (IV) What is the right statistical test one should use and why?

  Find the least squares estimates of regression coefficients

The determination of the shear strength of spot welds is relatively difficult, whereas measuring the weld diameter of spot welds is relatively simple. Draw a scatter diagram. Find the least squares estimates of the regression coefficients

  Dms odor thresholds

Here are the DMS odor thresholds for 10 untrained students:

  Which hypothesis is used to test the claim

A professor of statistics refutes the claim that the average student spends 3 hours studying for the midterm exam.  Which hypothesis is used to test the claim

  Courseware to find these steady-state probabilities

A student is concerned about her car and does not like dents. When she drives to school, she has a choice of parking it on the street in one space, parking it on the street and taking up two spaces, or parking in the lot. If she parks on the stree..

  Minimum cost binary hypothesis

Consider a binary hypothesis in which there is a cost associated with each type of decision. In addition to the cost C'10 for a false alarm and C'01 for a miss, we also have the costs C'00 for correctly guessing hypothesis H0 and the C'11 for correct..

  The police department for a major city has found that the

the police department for a major city has found that the average height of their 1250 officers is 71 inches with a

  If on average 10 passengers who have booked fail to turn up

overbooking of passengers on intercontincontinental flights is como practice among airlines. aircraft which are capable

  Assuming that the heart-rate distribution is approximately

a triathlon consisting of swimming cycling and running is one of the more strenuous amateur sporting events. an article

  A teletronix company purchases large shipments of

acceptance samplinga teletronix company purchases large shipments of fluorscent bulbs. they randomly select and test 24

  Statistical t-tests for means

The publisher of Celebrity Living claims that the mean sales for personality magazines that feature people such as Angelina Jolie or Paris Hilton are 1.5 million copies per week.

  Confidence interval on proportion difference

A survey reported in Time magazine included the question ''Do you favor a federal law requiring a 15 day waiting period to purchase a gun?" Results from a random sample of US citizens showed that318 of the 520 men who were surveyed supported this ..

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