70 likes | 176 Views
MGS 351 Team 2. Nicholas Buckley Anna Gwak Kwanghyuk Kim Xi Shi Andrew Yates. Time Warner Cable. National call center in Buffalo, NY Covers multiple regions and call types Several supervisors each with a team of employees. Objective .
E N D
MGS 351Team 2 Nicholas Buckley Anna Gwak Kwanghyuk Kim Xi Shi Andrew Yates
Time Warner Cable • National call center in Buffalo, NY • Covers multiple regions and call types • Several supervisors each with a team of employees
Objective • Identify strength and weaknesses within the call center using quantitative measures. • Identify and have an overview of the employee’s work efficiency • Build meaningful reports that can help better organize the company
Reports • Call by Date • Calls by Employees • Calls by Line • Calls by Region • Team Average
Forms • Calls Shows average time calls • Supervisors and Employees Organizes which employees are under which supervisors.
Conclusion • Transferring all the data from spreadsheet to Access helps to extract the information more efficiently. • It also cuts down real time when it comes to searching for employees and call time information. • Lastly, the reports are grouped together which helps to display the productivity of each regions, employees, and teams.