Hi, math whizzes. Have a business problem. This is not homework, but rather a problem I need to figure out at work...
Suppose an employee has been allotted 500 hours to work over the period of 1/18/2017 through 6/13/2017. I need to get the expected number of hours they'll work per month during the 6-month period. If the date range were 1/1/2017 through 6/30/2017, then the problem would be simple to solve by doing an average (83.33... hours per month). But when they don't start on the first day of a month or end on a last day of month, this is where I need help. Conceptually, I am thinking that partial start/end months need to have the same 'pull' from the 500-hour allotment as the full months in between (in this case Feb. - May). So immediately weighted averages, or something of the sort, comes to mind. But I'm not sure how to apply this concept mathematically.
Any ideas on how to how to solve my problem?