Reference no: EM131319789
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 a worksheet, demonstrate the uncertainties. Find the optimal solution which can maximize the average uncertain profit. Paste screen shoots of your model with formulas, model with solutions, solver setting, simulation setting, and the output distribution of the uncertain profit (Hint: you will have to use Psi distribution functions, Psi statistics functions, and simulation optimization)
b.) What is the optimal solution that can maximize average uncertain profit?
[Uncertain Scenario - Minimizing the Probability of Low Profit] The Company also would like to know the optimal solution if the objective is to minimize the probability of having a profit that is less than $1,800,000.
c.) In another worksheet, modify your model from a and find the optimal solution for this new objective. Paste screen shoots of your model with formulas, solutions, and your solver setting. What is the optimal solution that can minimize the probability of having a profit that is less than$1,600,000?
[Uncertain Scenario - Maximizing the Probability of High Profit]
d.) Repeat a, but with a new objective to maximize the probability of having at least $2,500,000 of profit. Paste screen shoots of your model with formulas, solutions, and your solver setting. What is the optimal solution that can maximize the probability of having at least $2,600,000 of profit?
e.) Discuss the optimal solutions you found from all scenarios. If you are the CEO of the company, which solution would you adopt and why?
Analyze how sales of individual items would be entered
: How sales of individual items would be entered? How the database would store the data compared to the current spreadsheet method? How monitoring of inventory levels based on sales using the database would work?
|
Find test statisctic and p value
: Use .05 significance level to test the claim that fewer than half of all teenagers in the population feel that their greatest source of pressure. Find test statisctic and P value.
|
What is the depreciation tax shield-depreciation tax shield
: Fill in the missing numbers for the following income statement. Calculate the OCF. OCF. What is the depreciation tax shield? Depreciation tax shield
|
What is the future value on the day of the last deposit
: Assume that a gallon of milk costs $3.45today. If the average annual inflation rate over the past 30 years was 2.55% p.a., what did a gallon of milk cost 30years ago? What is the future value on the day of the last deposit of 25annual deposits of $75..
|
Find the optimal solution which can maximize
: In a worksheet, demonstrate the uncertainties. Find the optimal solution which can maximize the average uncertain profit. Paste screen shoots of your model with formulas, model with solutions, solver setting, simulation setting, and the output dis..
|
List two advantages and disadvantages of job specialization
: Describe three ways to improve employee motivation through job design, and share a related personal experience about at least one form of employee motivation.Self-leadership is considered a critical practice in the workforce. Do you agree? Why or w..
|
Why can the magnetic flux density vector be expressed
: Discuss the analogy between the magnetic vector potential due to an infinitesimal current element and the electric scalar potential due to a point charge.
|
How you will address jim recent performance issues
: Write a one (1) page paper in which you: Explain how you will address Jim's recent performance issues. Suggest both constructive and positive feedback designed so that Jim will leave motivated to do his best
|
Calculate the annual depreciation
: The price of a railroad car purchased by Rio Corporation was $78,600. Using the MACRS method, calculate the annual depreciation for year 3. (Round all dollar amounts to the nearest cent)
|