Purchase Solution

Answer to Statistics question: Quantitative Methods

Not what you're looking for?

Ask Custom Question

Joe is going to invest $250,000 in the development of new products. The new products have the following expected costs, yields, and degrees of risk.

Expected Expected Expected
Product Cost Yield Risk
A $100,000 0.20 8
B $50,000 0.10 4
C $50,000 0.15 10
D $150,000 0.10 0

Joe can do each product at its full cost or he may attempt a partial development and still expect a yield proportional to the level of expenditure on the product. Joe wants to limit his total weighted risk(degree of risk times budgeted amount) to 1000000 units; that is, an adopted plan for a $10000 expenditure with a degree of risk of 7 would be 70000 riskunits.

What should Joe invest to net the highest yield given his risk constraints?

Answer:

Decision Variable Product A Product B Product C Product D
100000 50000 0 150000

Objective function:
Maximize the yield 20000 5000 0 15000
Total Yield 40000

Constraints
Risk 800000 200000 0 0
Total Risk 1000000
Limit on Risk 1000000

Limit on investment in each product
Available 100000 50000 50000 150000
Used 100000 50000 0 150000

Run solver to solve the LP
See the solver output. Thus, the following investments should be made in four products
A 100000
B 50000
C 0
D 150000

Decision Variable Product A Product B Product C Product D
100000 50000 0 150000

Objective function:
Maximize the yield 20000 5000 0 15000
Total Yield 40000

Constraints
Risk 800000 200000 0 0
Total Risk 1000000
Limit on Risk 1000000

Limit on investment in each product
Available 100000 50000 50000 150000
Used 100000 50000 0 150000

The following investments should be made in 4 products:
A 0
B 0
C 0
D 0

This is an investment problem in linear programming. Please solve and show work

Purchase this Solution

Solution Summary

Word document contains complete formulation and explanation. The excel file contains formulation in Solver tool dialogue box and optimal solution.

Purchase this Solution


Free BrainMass Quizzes
Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.