Summary:
-Every month based on the need of our different department we ask different vendors to provide us contractors to meet our work load.
-The contractors that the vendors provide start entering FTE hours as soon as they start working.
- Based on the data we will need a model that will predict the future FTE hours for a particular state, a particular city, a particular job family, a particular position title.
Example:
- We have monthly data from 2014 to 2015 for the total FTE hours entered
- The column headers are as follows:
| | | | | | |
Year | Month | State | City | Job Family | Job Title | Total Hrs |
2014 | April | AL | Selma | PM | PM3 | 10000 |
2015 | Feb | AR | Hot Springs | Analyst | Analyst2 | 2300 |
| | | | | | | | | |
So based on the above data we will be able to predict for
2016 September
2016 October
2016 November
For each state and for each of the city and for each of the job family and for each of the job title
Approximately how much hrs are needed.