Business Finance Homework Help

Linear Programming Hours of Studying Excel

 

Can you help me understand this Excel question?

A student is trying to determine how many hours of studying to devote to each of his subjects to maximize his overall grade point average this semester. To do so, the student predicts the grade average he will receive for studying different amounts of time in each of his classes. The table below displays his predictions (ATTACHED).

The student wants to study no more than a total of 35 hours per week. He estimates that the amount of time he should study physics is at least double the amount of time he should study economics, and the amount of time he should study calculus is in between those two values. Formulate this problem as an optimization model and use the solver to find the optimal solution. (Hint: Use Excel’s VLOOKUP function; Select “Evolutionary” for solving method in Solver)