ER Tracking Tool

New contacts Timeline Graph_products Products_Money Communication Revenue overview Intro Petrus communications notes Korn/Ferry TSR hp Deloitte BSCE Tech Data Partners UniGlobal Research Morgan Stanley Ceska posta grafton recruitment Synergie recruitment assessment systems Saint Gobain Deloitte CE Monsters Assessment S. Cool people Obch.tiskarny Profesia Unipetrol Services Česká pojišťovna XC Vision Total Grafton Exxon GMC Lidl Contact Offer Approval Contract sent Contract signed Boston Kraft PG dm market kimberly A.T. Kearney GmbH Kimberley MTG LC account LC account LC account x x x x x x AAA AAB June McKinsey Nestle TMF Company Et Netera HP HVB Plus Deutsche Börse Difference x Newton IT Mindshare Pedersencee Coca Cola Hills BPP Telefonica CEZ Inbev Microsoft Česká spořitelna Accenture Adecco AWD Boston Consulting Grp Coca Cola HBC Česká rafinérská ČSOB Deloitte Economia Fincentrum HVB Bank ING JIP KMV Komerční banka Mazars MUVS TPCA prk Opavia-LU/Danone RWE Transgas SAP Tambor T-Mobile Unilever August September October November December January February May April March TPA Horwath Danone Aon Stach Konec smlouvy TO mtg Nova spoluprace Opavia Prazdroj GE Real Estate L'Oreal This tracking was developed in order to track ER performance. The tool contains following tables: 1)Revenue overview - split to years and companies, tracks also percentage of revenue plan fullfilment 2)Communication - tracks communication with companies, helps to prioritize 3)Products_Money - tracks income brought by different products 4)Timeline - scheme for company meetings 5)New contacts - tracks new contacted companies If you have any additional questions, please feel free to contact petrav@ai.aiesec.org. ------- Petra Vondrackova Corporate Relations Manager AIESEC International September 2008 Company AAC Company Product A Product B Product C … .. Total per product Overview - revenue per product AAD x x x Chart tracking company communication Difference 2006/2007 2005/2006 AAA AAB AAC AAD 2004/2005 2003/2004 50 000 Total 45 000 50 000 70 000 20 000 My term Planned revenue Income raised till now Total revenue overview (per year, per company) Approached by mail call mtg ami communicatons 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 … … … 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 000000.00 00000.00 00000.00 00000.00 000000.00 000000.00 00000.00 00000.00 000000.00 00000.00 00000.00 000000.00 00000.00 00000.00 00000.00 00000.00 000000.00 000000.00 00000.00 00000.00 00000.00 00000.00 0.00 0.00 0.00 000000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $0,000.00 00.00 0.00 0.00 Petra Vondrackova: explanation - company received an offer but we are still waiting for their approval Petra Vondrackova: Company AAB didn’t approve our offer Petra Vondrackova: Our offer was approved but we still haven't sent the contract 000000.00 000000.00 000000.00 000000.00 0.00 000000.00 00000.00 0.00 00000.00 00000.00 0.00 -00000.00 0.00 00000.00 0.00 000000.00 000000.00 000000.00 00000.00 000000.00 000000.00 000000.00 000000.00 000000.00 000000.00 00000.00 000000.00 0.00 4Tracking tool intro