Explain linear programming - fair-wind corps

Assignment Help Operation Research

Reference no: EM13711375

Explain Linear Programming - Fair-wind corps

Problem- Create an Excel worksheet that solves this problem with Solver.

Part 1- The Fair-winds Development Corporation is considering taking part in one or more of three different development projects A, B, and C that are about to be launched. Each project requires a significant investment over the next few years and then would be sold upon completion. The projected cash flows (in millions of dollars) associated with each project are shown in the table below:

Year Project A Project B Project C

1 -4 -8 -10

2 -6 -8 -7

3 -6 -4 -7

4 24 -4 -5

5 0 30 -3

6 0 0 44

Fairwinds has $10 million available now and expects to receive $6 million from other projects by the end of each year (1 through 6) that would be available for the ongoing investments the following year in projects A, B, and C. By acting now, the company may participate in each project either fully, fractionally (with other development partners), or not at all. If Fairwinds participates at less than 100 percent, then all the cash flows associated with that project are reduced proportionally. Company policy requires ending each year with a cash balance of at least $1 million.

I need help to describe linear programming fair-wind corps and resolve the above problem.

Reference no: EM13711375

Questions Cloud

Explain zephyr inc. end of their first year of operations : Illustrates how to compute a corporation's deferred tax asset, deferred tax liability, current tax expense, deferred tax expense, and total tax expense.

Implement a function called findmax : Implement a function called findMax that finds the maximum value in a 2¬dimensional array.

Describe cost-benefit trade-off lp : Consider a cost-benefit-trade-off problem. Formulate a linear programming model for this problem on a spreadsheet.

Write complete java program assuming that the variables gpa : Write a complete java program assuming that the variables gpa, studentName and deanList have been declared, you should read in the gpa and studentName from keyboard.

Explain linear programming - fair-wind corps : The Fair-winds Development Corporation is considering taking part in one or more of three different development projects A, B, and C that are about to be launched.

Provide the corresponding memory snapshot : Provide the corresponding memory snapshot, and the value of the stream state flags, after each of the subsequent sets of statements is executed:

Explain local franchises co-operation : In your opinion, does 7/11 Japan ensure that local decision-makers simultaneously do what's best for customers and the corporate parent.

Explain about company research : For each company please answers the following by researching the company: Please be comprehensive and provide sources. APA format.

Describe the manager''s role in a food and beverage operation : What is a manager's role in a food and beverage operation. How may this role affect the operation's profitability.

User Account

All Pages