Question about Microsoft Computers & Internet

Open Question

Excel Solver Problem

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
million.
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.

Posted by on

5 Suggested Answers

SOURCE: Stacked Bar/Column chart with Negative Values

use a line chart instead with up/down bars

Posted on Oct 16, 2007


  • 10 Answers

SOURCE: Office 2007 wont upgrade from project 2007

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.

http://office.microsoft.com/en-us/products/FX101754511033.aspx

Posted on May 08, 2009

the_fire
  • 432 Answers

SOURCE: Calculate Quarters between any two dates

not sure if this is what you are after entirely but should at least help you out some what

=DATEDIF(A3,C3,"m")/3

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

  • 9 Answers

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

  • 18 Answers

SOURCE: Hello,

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 lucho_lnc@yahoo.com

Posted on Mar 04, 2010

Testimonial: "The solution that Lucho provided me was really excellent, it helped."

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

4 Answers

Using excel to solve problem by trial and error method


In A1, put a random value of d as 0.1. Then in B1, put your equation 5*d^4 - 10.29*d^(-1.333), wherein refer d as A1. Then use goal seek function on Tools Menu. First "Set cell" as B1, "To value" as 0.124 and "By Changing Cell" as A1. Excel will do the Trial & Error and will give you the answer in Cell A1.

Nilesh

Mar 31, 2009 | Microsoft EXCEL 2004 for Mac

1 Answer

CODES for entering an I.D number using vba


Try the help built into Excel and give yourself time to absorb it; Excel has some of the best help in the business. VBA may be more complex than you need to solve a data entry problem. If you're trying to add data input masks in a database, why don't you try Access (the help for which is admittedly weaker because database programming is among the most complex of all productivity apps)? I learned VBA from 3 books I rented from a good public library over the course of a project that was about a month long, (because) at some point Microsoft abandoned the idea of teaching it via help screens. Still, you might join a MS developer site and those are loaded with detailed explanations and many other experts. I hope this helps... I feel your pain.

Mar 22, 2009 | Microsoft Office Excel 2003 for PC

6 Answers

I have forgot my excel password how do i open the sheet


Excel Password Recovery 2009

This Excel add-in (password.xla) works fine in Excel 5.0 and above (including Excel 2000, XP and 2003).
This program will remove passwords of any length, also passwords containing special characters.

zipped: password.zip

Mar 06, 2009 | Microsoft Word 2000 for PC

3 Answers

I want to remove forgotten password of my only 3 exel files


Nowadays, with the development of the technology, you are able to remove excel password so as to access your files again safely and very easily with excel password reset programs. And Excel password recovery is a popular tool that can reset Excel password from Excel 97 to Excel 2007. Meanwhile, it can open your file again without any damage or data loss at all.
To recover your password, you can follow a step-by-step guide on how to recover Excel password for 2007 edition.
Step 1:Download Excel Password Recovery and install it.
Step 2:Click Open and select the file you need.
Step 3: Choose an attack type to recover Excel 2007 password.
Step 4: Attack settings.
Step 5: Click Start on the taskbar, and when the operation finished, you will recover the lost Excel 2007 password

Nov 26, 2008 | Microsoft Excel for PC

2 Answers

Import data from access into excel where one column go into one worksheet and other into next


Can't be done.

Access will only put the data into one worksheet. It is very picky when it comes to exporting data into an Excel spreadsheet.

There are two ways to get around it:

1) You can export the data from Access into two files. One for the the first worksheet and another file for the second workshet.

2) You can import everything into one spreadsheet and build a macro into Excel to cut the information one spreadsheet and paste it into the other if this is a redundant task to do all the time.

Hope that helps you out.

Jun 10, 2008 | Microsoft Office Access 2003 (077-02871)...

4 Answers

Forgot password


Try this link http://www.download.com/Free-Word-Excel-Password-Wizard/3000-2092_4-10249516.html?tag=lst-0-1 It should help you unlock the Excel file and break the password. Good luck

Sep 02, 2007 | Microsoft Office Standard for PC

1 Answer

MS Access 2003 Development - Format Problem


Hi, the difficulty to solve your problem is that we are not familiar with Appx. I have faced this problem numerous time, but usually it was from Excel to Access. Now if you can transfer it to Excel then you can change the format in Excel to Text and import it into Access. I have also read a little of the Appx manuals and it says there that you can work with ODBC, are you using it? ODBC will create a connection between the APPX application Database and Access, you should be able to do your queries directly from the ODBC connection without the need to import the table. Here is a PDF manual of how to set it up from their website: http://www.appx.com/ftp/appx/documents/manuals/appx/appxodbc/current/appxodbc-manual.pdf I hope it helps, let me know and I will try to do my best to solve your problem. Daniel

Aug 10, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

86 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2635 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18333 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...