Cory is a business student at Brick University. He has just finished a course in Information Technology which had a midterm exam, a final exam, assignments and class participation. He earned 82% on the midterm exam, 79% on the final exam, 94% on the assignments and 100% on participation. The instructor is letting the students choose their own weighting scheme for the final course mark, with the following restrictions:
Participation can be no more than 15% of the total course mark.
The weighting for the final exam must be at least 1.5 times the weighting for the midterm exam.
The total of the midterm and final exams must count for at least twice the assignment mark
Each component must count for at least 5% of the total course mark.
The marks assigned to the four components must total 100 and be non-negative.
Provide a write-up of your model formulation ; define your decision variables, state the objective function, and list all constraints. In Excel, use Solver to find the optimal values for the decision variables and Cory’s total course mark.