Here are the details. The Director of Loss Prevention has reached out to me to assist with two graphs to show where his department is and what direction he would like to see the department headed.
They have a WIG ( wildly important goal) to boost their well being score from 60.5 percent to 63 percent by October 2013. I simply need the first graph to show the months of the year at the bottom, January - December,and on the x axis, bottom to top, 0 to one hundred. Each month the hotel gets a score and he can input the score each month in order to see what direction the department is headed.
Second graph: he has 24 officers. Each officer is asked to engage 5 hotel guest per shift to increase this score. He would like to see if engaging the guests directly relates to this WIG score.
If each officer engages 5 guests, then they are achieving 100 percent of their goal, if not, then he'd like to know the percentage they are attaining. There are 3 shifts, 6a-2p, 2p-10p, 10p-6a.
Think you can help me out and have this by Tuesday sometime?