Question about Microsoft Computers & Internet
I m having difficulties solving this problem with "Linear" Model. can you guys help?
The Aberdeen Development Corporation (ADC) is trying to complete its investment plans for the next five years.
Currently ADC has $6.1 million available for investment. At 1 year intervals, ADC expects the following
income streams from other business ventures over the next 4 years: $2.8 million (one year from now), $2.4
million (two years from now), $2.3 million (three years from now), and $2.7 million (four years from now).
This income stream is also available for investment.
There are three development projects that ADC is considering. The first is the Aberdeen Resort
Hotel, a four-star deluxe hotel on the picturesque banks of Grays Harbor. If ADC participates fully in this
project, it would have the following projected cash flow streams at one year intervals over the next four years
(negative numbers represent investments, positive numbers represent income): –$6 million (now); –$2.1
million (one year from now); $1.5 million (two years from now); $1.9 million (three years from now); and $2.4
million (four years from now). The estimated value of the project five years from now would be $8 million.
A second project, the Aberdeen South Shore Mall, would be a shopping complex adjacent to the
Aberdeen Resort Hotel. The cash flow stream for this project, if ADC participates fully, would be (at 1 year
intervals): –$5 million (now); –$3.1 million (one year from now); $2.1 million (two years from now); $2.4
million (three years from now); $2.6 million (four years from now). The estimated value of the project five
years from now would be $7 million.
The third project, the Bank of Aberdeen building, is a 30-story office building to be built in
downtown Aberdeen starting in two years, after the demolition of several smaller buildings. This project
would have the following cash flow stream (at 1 year intervals) if ADC participates fully: $0 (now); –$0.5
million (one year from now); –$3.5 million (two years from now); –$2.1 million (three years from now); and
–$1.3 million (four years from now). The estimated value of the project five years from now would be $10
a. Assume that ADC may participate either fully, fractionally (with a partner), or not at all in any or all of the
three projects. If ADC participates in a project at less than 100%, all the cash flows, and the final value of
that project for ADC are reduced proportionally. For example, if ADC participates at 50% in the Aberdeen
Resort Hotel, the cash flows would be –$3 million (now); –$1.05 million (one year from now); $0.75 million
(two years from now); $0.95 million (three years from now); and $1.2 million (four years from now). The
estimated value to ADC five years from now would be $4 million. ADC can borrow money at 6% interest per
year. At most $5 million can be borrowed in any one year. The loan must be paid back the following year with
interest (e.g., if $1 million is borrowed, $1.06 million is due the following year). However, a new loan can be
taken out the following year. ADC can invest surplus funds, and earn a 4% return per year (e.g., if $1 million
in surplus funds are invested in year 3, then $1.04 million are available in year 4). The goal is to maximize
their net worth in five years (the value of their developments plus any surplus funds and interest minus any
borrowed principal and interest due). You may assume that all income from other business ventures, loan
proceeds, savings interest, or current projects are received at the start of each year, followed immediately by
any required cash outflows. Set up and solve a linear programming spreadsheet model for this problem.
b. Now suppose that there are no other potential investors in the Aberdeen Resort Hotel project. Thus, ADC
must participate either fully or not at all in this particular project. The other two projects have other
developers that are interested, so these projects can be undertaken by ADC either in full, fractionally, or not
at all. Suppose further that ADC would only consider investing in the Mall (at any level) if they are also
developing the Aberdeen Resort Hotel. Finally, suppose that ADC does not want to participate in all three
projects. They would consider pursuing at most two of them (at any level). revise the model to incorporate these changes. The resulting model must be linear.
A positive number is 5 times another number.If 21 is added to both the numbers,then one of the new numbers becomes twice the other number.What are the numbers
Posted on Jun 30, 2008
Sorry to tell you this but Project 2007 isn't listed as an option to upgrade to the Office Professional. If you had Project through an Office Suite previously it would have been. Go to the URL pasted below and it will show products elegible for the upgrade. Good luck.
Posted on May 08, 2009
not sure if this is what you are after entirely but should at least help you out some what
As you said you cant just divide by 3 but I have divided the formula by 3 to see how many 3 months will go into the output you could maybe have another formula to divide it by 2 to see if it will divide by 2 to see if you get a whole number or not, if you do then you can just return the first part before the dot ( using split function ) and if the value is less then 1 then obviously the 3 months has not passed between the 2 dates
Posted on May 09, 2009
Tips for a great answer:
May 21, 2012 | Casio Scientific Calculator Fx-570 Fx570...
Mar 17, 2012 | Casio FX-9860G Graphic Calculator
Mar 17, 2012 | Casio Office Equipment & Supplies
Jan 12, 2012 | Office Equipment & Supplies
Sep 12, 2011 | Office Equipment & Supplies
Mar 02, 2011 | Casio FX-115ES Scientific Calculator
Aug 01, 2010 | Texas Instruments TI-89 Calculator
May 31, 2010 | Casio fx-300ES Calculator
Nov 19, 2009 | Texas Instruments TI-30XA Calculator
90 people viewed this question
Usually answered in minutes!