This model is for an Operation Research Course.

Please Provide a model if using excel.

You sleep 8 hours a day. Every day you spend 1 hour eating breakfast and generally taking care of your physical appearance This leaves 15 hours of freedom each day. Note, we are only dealing with the 5 days of the week. The goal is to have weekends off so you can go vacation or do something cool. The question is how best to spend those hours. As with anything, there is a diminishing returns on activities. The more time you spend, the less benefit you receive. The data is given in the following table Daily Activities Table Activity Low Level Medium Level High Level Hours Hours Hours Min Max Benefit/hr Min Max Benefit/hr Min max Benefit/hr 6 4 4 Exercise 4 1 2 2 6 TV/Video games 3 1 6 Social media 8 1 3 4 6 2 Friends Friends S h 4 1 1 5 Dealing with 6 9 6 9 11 4 11 13 E Work 1 2 3 3 Eating Home Maintenance Over the five days of a week, you must have at least one hour in each category and work at least 40 hours Write and solve an integer program that maximizes your benefit of the way you spend your hours during a M-F schedule. You should assume that the benefits are cumulative and that you get the lower benefit for the lower times (similar to taxes). For instance if I worked 12 hours and exercised for 3 hours on Monday, then my total benefit for Monday would be Working benefit is 9*6+2 4-1 2- 64 Exercising Monday is 6(.5) +4*.5+2 1 37. Thus, Monday would contribute 71 units towards my benefit for the week