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.
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
SOURCE: How to link vb 6.0 to msaccess?
You Need ODBC to solve your link... ODBC is a gateway. Can Access by Microsoft Access or VB in same time... Note: Please in Code Programming you must lock or unlock you data if you want application running same time..
Posted on Nov 08, 2009
There are two ways to solve it, with a macro and without.
In either way, the concept is to determine the difference between rows, if it is more than 1 hour, then you have detected the missing row.
With a formula, you can tell excel to put true if it is the case and correct it manually.
For a macro, basically you detect the same thing and then insert a line with all the appropiate information. I can write the code for you, but i would prefer to have the sheet. You can send me the information to my mail firstname.lastname@example.org
Posted on Mar 04, 2010
Testimonial: "The solution that Lucho provided me was really excellent, it helped."
Tips for a great answer:
Mar 31, 2009 | Microsoft EXCEL 2004 for Mac
Mar 22, 2009 | Microsoft Office Excel 2003 for PC
Mar 06, 2009 | Microsoft Word 2000 for PC
Nov 26, 2008 | Microsoft Excel for PC
Jun 10, 2008 | Microsoft Office Access 2003 (077-02871)...
Oct 12, 2007 | Microsoft Office Standard for PC
Aug 10, 2007 | Microsoft Office Standard for PC
86 people viewed this question
Usually answered in minutes!