Question: Hi can I please get help on this question, it relates to linear optimisation and may need excel to solve. I really appreciate the help.
Hi can I please get help on this question, it relates to linear optimisation and may need excel to solve. I really appreciate the help. Thanks
Facing 3 Final Assessments in this semester, Jeffrey has to use a model to optimise his level of preparedness across the 3 courses. All 3 Final Assessments are happening on the same day, 2 days from now. This means Jeffrey has to fit all his preparation within 48 hours. In order to avoid burnout, Jeffrey must rest for at least 8 hours during this period. It is believed that each hour of rest will relax the brain, and thus gives Jeffrey 2 points of preparedness. Among the 3 courses, course A is Jeffrey's favourite, and thus the time spent studying for this course is most effective. Each hour spent on course A will result in 7 points of preparedness. Course B is tricky, and it's not a subject that Jeffrey liked. Each hour spent on course B will only result in 3 points of preparedness. Recently, Jeffrey has acquired a very useful guidebook related to course C. As a result, each hour spent on course C will result in 5 points of preparedness. To prepare for courses A and C, Jeffrey needs to use a computer. The only computer he can access in these 2 days is his sister's, which he can only use for 16 hours during this period. In order to pass all 3 courses satisfactorily, Jeffrey will need at least 20 points of preparedness from the time spent studying for each course. Using this information, formulate an optimisation model on paper" that can be solved to recommend the number of hours that Jeffrey should spend on preparing for each course's Final Assessment and to rest, in order to maximise the level of preparedness and let Jeffrey pass all 3 courses satisfactorily