If anyone can advise how to start or direct me to some links to create a spreadsheet to assist me in completing this task.
I have 30 clients, with packs ranging from a count of 9 to 400. I would like to be able to 1) know that I am meeting the goal or if ahead by how much; 2) know if I am behind goal and by how much; 3) I would need to monitor by volume by due dates. While we have Mon-Fri work week, Sat and Sun packs will need to completed during the 5-day work week. I would like to create this as a dashboard so that I can view not only numbers but graphically. Each worker is expected to produce 25 count per hour. I am using Excel 2003 in the office and have Excel 2010 at home.
Productivity vs Goal.xlsx
Thank you
Bookmarks