+ Reply to Thread
Results 1 to 2 of 2

How to use Solver & Dynamic Programming to solve this problem?

  1. #1
    Registered User
    Join Date
    10-26-2013
    Location
    Brooklyn, NY
    MS-Off Ver
    Excel 2010
    Posts
    1

    How to use Solver & Dynamic Programming to solve this problem?

    Hello all

    This problem is on the study guide for my midterm and calls for the use of dynamic programming.. which wasn't discussed in class or mentioned in the textbook. We've been using solver for all problems but I'm not sure how to incorporate "dynamic programming." Any help would be greatly appreciated. Thank you


    A student has four final exams to prepare for but can allocate only 25 hours of studying time. The expected grade for each course depends on the study time for its final exam. She estimates her grade as follows:

    Hours of Study
    Course 0 5 10 15 20 25
    Economics F B B B B A
    Management F D C B A A
    Computers F C C B B A
    Health care F C B B A A

    All courses are 3 credits each. She wishes to maximize her expected GPA. A=4, B=3, C=2, D=1, F=0. Use dynamic programming to determine how the student should allocate her studying time.

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,819

    Re: How to use Solver & Dynamic Programming to solve this problem?

    Since I don't work in computer science (at least, not to that level), I figure a lot of this question is really about "what is dynamic programming." So, in the spirit of "let me google that for you" I put "dynamic programming into my favorite search engine and found a couple of different wikipedia pages as well as several tutorials/introductions to the idea of dynamic programming. Perhaps one of these will remind you how this was discussed in class:
    http://en.wikipedia.org/wiki/Dynamic_programming
    http://20bits.com/article/introducti...ic-programming
    http://www.cprogramming.com/tutorial...theory/dp.html

    In short, it would appear that "dynamic programming" is simply a reference to what kind of algorithm you might come up with to ultimately optimize this kind of problem. I'm not sure if they are expecting you to program some kind of VBA/spreadsheet "what-if" scenario for this, or if they are saying that Solver has the dynamic programming algorithms already built in, or exactly what they are intending for you. I wish I could help more.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How can I solve the problem by solver (with attachment)
    By lubbamkt in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-09-2013, 10:19 AM
  2. Excel2007 Solver fails to solve apparently easy problem
    By Itsatwap in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-12-2011, 12:29 PM
  3. Solver and Interger Programming Problem
    By hpman247 in forum Excel General
    Replies: 5
    Last Post: 10-08-2010, 12:51 AM
  4. Replies: 0
    Last Post: 11-10-2008, 12:26 PM
  5. Replies: 2
    Last Post: 02-08-2006, 08:10 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1