Customer Service Evaluation

            Graziano Food Service Inc. is a family owned and operated business located in Portland, OR. The company procures, acquires, and delivers food items to customers in close proximity. Annual revenues are above $10 million. On average, there are between 25-35 employees. Since inception in 1985, no improvements have been made to the operating system. Additionally, customer service has never been tracked to ensure clients are receiving what they want and how they want to receive it. To assist a newly hired employee with monitoring the service rendered, I have created a program to automate much of the process for him.

            To start the process, while in the field, the customer service representative will complete a Google form respective to a survey conducted with each individual client. This information will be stored online. Once the user enters Excel, a form control button pulls this information from the web and stores it into an Excel sheet. This information is manipulated on a separate sheet to a more organized, user-friendly interface. A different control button allows the user to graph the four numeric criteria and see text box outputs of the clients’ preferred service and suggestions for improvement. A separate functionality of the project presents a user form to allow the user the ability to send an email regarding customer service to anyone of interest.

http://files.gove.net/shares/files/14w/nickgraz/Final_Project_Write_Up.pdf
http://files.gove.net/shares/files/14w/nickgraz/Customer_Service_Evaluation.xlsm