Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.

Get a Professional Answer

Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.

100% Satisfaction Guarantee

Rate the answer you receive.

Ask R.R. Jha Your Own Question

R.R. Jha, Tutor

Category: Homework

Satisfied Customers: 5471

Experience: B.Tech

20870358

Type Your Homework Question Here...

R.R. Jha is online now

Hello, I need help in ExcelThe question is below, dynamic

This answer was rated:

★★★★★

Hello, I need help in Excel The question is below, dynamic programming must be used in order to solve it, in a similar way how the transportation problems are solved in excel, I think it should be divided in stages, and I think the table might need to be transposed so each course is a separate stage

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

EXPECTED GRADE Course Hours of Study 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 grade-point total (GPA). (The GPA is computed assuming A = 4, B = 3, C = 2, D = 1,F = 0). Use dynamic programming to determine how the student should allocate her studying time.

Is dynamic programming used? My professor told me that the solution of this should be very similar to a transportation problem that we did in class, this one is a little different