Reference no: EM131319061
Uncertain Scenario-Maximizing the Mean
The potential revenues of all projects are in fact uncertain. The company determines that the revenue for project 1 is following a uniform distribution ranging from $1,200,000 to $2,000,000. The revenue for project 2 is distributed normally, with a mean of $1,500,000 and a standard deviation of $200,000. The revenue for project 3 follows a triangular distribution with a minimum of $1,350,000, maximum of $1,600,000, and it is most likely to be $1,500,000. The revenue for project 4 is distributed normally, with a mean of $1,800,000 and a standard deviation of $800,000. The bank wants to find the optimal solution which takes all these uncertainties into account.
a) In Excel, formulate an LP model for this problem with the objective of maximizing total profit, incorporating all uncertainties.
b.) Find the optimal solution which can maximize the average uncertain profit.
c.) Past screen shots of your model with formulas, model with solutions, solver setting, simulation setting and the output distribution of the uncertain profit.
|
Understanding or enhancing interpersonal communication
: Provide a brief summary of the article you located in the Kaplan library for this unit's Reading. Be sure to include the full reference information so other students can read the article. Describe a scenario within your concentration in which the ..
|
|
Minimizing the probability of having a profit
: a.) Formulate and LP model for this problem with the objective of minimizing the probability of having a profit that is less than $1,600,000? b.) Paste screen shots of your model with formulas, solutions and your solver setting.
|
|
Brief description of the selected court case or lawsuit
: "The Supreme Court has held that the selection guidelines in the federal government's Uniform Guidelines on Employee Selection Procedures also apply to performance measurement" (Noe, Hollenbeck, Gerhart, & Wright, 2011, p. 249).
|
|
Assume risk-free rate and market risk premium
: You are going to value Lauryn's Doll Co. using the FCF model. After consulting various sources, you find that Lauryn has a reported equity beta of 1.7, a debt-to-equity ratio of .7, and a tax rate of 40 percent. Assume a risk-free rate of 3 percent a..
|
|
Uncertain scenario-maximizing the mean
: The potential revenues of all projects are in fact uncertain. The company determines that the revenue for project 1 is following a uniform distribution ranging from $1,200,000 to $2,000,000. The revenue for project 2 is distributed normally, with..
|
|
Find the bayesian inference about the bias pa of the coin
: Find the Bayesian inference about the bias pa of the coin given the data, and determine whether a Bayesian's inferences depend on what stopping rule was in force.
|
|
Develop the strategic objectives for your new division
: Develop the strategic objectives for your new division of the existing business in a balanced scorecard format in the context of key trends, assumptions, and risks.The strategic objectives are measures of attaining your vision and mission.
|
|
Joint venture using the equity method
: During the early 1990’s Mylan had a 50% interest in a company which produced and sold a very successful drug for the treatment of Parkinson’s disease. We accounted for this joint venture using the equity method. Which of the following is correct rega..
|
|
Explore the significance of any ethics-based decision
: Explain the significance of any ethics-based decision your research finds and the affect it had or has on overall morale, relationships within the organization, and ultimately overall productivity levels.
|