Workforce management using looker

Job ID: 34748400

Budget: ₹2,500 – ₹0 INR

Please find attached, the average incoming workload per hour of a weekday. Kindly design an optimal schedule for the day to cover the incoming work while reaching the SLAs. Please consider absenteeism and utilization rate as factors in calculating outcomes.

a.Attached you can find the average incoming workload per hour of a weekday. Please design an optimal schedule for the day to cover the incoming work while reaching the SLAs.
b.Please consider absenteeism and utilization rate as factors in calculating outcomes
c.Please use the data given to you and answer the following questions:

i.Is there a need to hire additional people to the team and if so, how many people should we hire next quarter? How many people should we have available by the end of 2022 based on what you have seen so far?
ii.If there is a chance to improve primary tasks by 11% or reduce total workload by 7%, which would you choose? Bare in mind that all initiatives and projects could also not have the expected impact.
Note: It takes only 2-3 hrs to complete!
Related categories: SQL Database Administration