Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started