More of three different development projects

Assignment Help Operation Management

Reference no: EM132097944

The Fairwinds 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-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%, 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. a. create an excel worksheet that solves this problem with Solver.

Reference no: EM132097944

Questions Cloud

What might be the key reasons for globaloney : What might be the key reasons for globaloney? Pick as many responses as strike you as important. (select all that apply)

Haul should lease to minimize total initial capital outlay : Construct, in equation form, linear programming model that determines the number of each truck We-Haul should lease to minimize its total initial capital outlay

Example of organizational-individual adaptations required : Share an example of organizational and individual adaptations required when operating outside your home country.

Focus on multiple issues due to customer interaction : In service layout, it is more important to focus on multiple issues due to customer interaction.

More of three different development projects : The Fairwinds Development Corporation is considering taking part in one or more of three different development projects.

How would this affect the businesses and the economy : How would this affect the businesses and the economy?

Health care-related topic that would be studied using survey : Choose a health care-related topic that would be best studied using a SURVEY.

Samantha is in charge of the local doughnut shop : Samantha is in charge of the local doughnut shop. One of her challenges is that coffee drinkers are more loyal than tea drinkers.

Enthusiastic about the market for the product : Madhu’s design and marketing staff are very enthusiastic about the market for the product and the potential of follow-on circus train cars.

User Account

All Pages