Spreadsheet: 761307d1640810299-conditional-formatting-to-change-colour-based-on-percentage-bands-bobs-project-list1
Sheet: Guide

 | WESCO HOSTED EVENT PLANNING GUIDE
 | · Use this spreadsheet to stay within budget and on track with all important deadlines and tasks related to your event.
 | · Add this spreadsheet to OneDrive, SharePoint or a Teams Channel to create a shareable link for group collaboration.
 | · The team can check the status of all tasks and provide updates on their assignments.
 | [NAME] Event Budget
 | · Include all expected costs and revenue (supplier sponsor fee, customer fee)
 | · Use the questions below to help define your event details and create an accurate estimate for your event budget.
 | What type of event are you hosting? |  |  |  |  |  |  |  |  | What will be provided for attendees?
 | · Customer Appreciation, Branch Opening, [NAME], [NAME], Counter Day |  |  |  |  |  |  |  |  | · Food (breakfast, lunch, dinner, appetizers, snacks)
 |  |  |  |  |  |  |  |  |  | · Beverages (coffee, water, soda, alcohol)
 | Who will be invited and what are your attendance goals? |  |  |  |  |  |  |  |  | · Giveaways/Prizes (door prizes, branded items, swag bag)
 | · How many people will attend, including employees, customers, and suppliers |  |  |  |  |  |  |  |  | · Entertainment (professional speaker, band/DJ, game rentals)
 | · This will help determine catering, rentals, gifts and more. |  |  |  |  |  |  |  |  | · Transportation (shuttle to/from event)
 | Who are your target suppliers and what are the sponsorship fees? |  |  |  |  |  |  |  |  | What marketing and communication items will you need?
 | · How many suppliers do you need to cover costs? Is sponsorship limited? |  |  |  |  |  |  |  |  | · Onsite signage (company branding, supplier sponsor promotion)
 | · What will they get in return for their sponsorship? |  |  |  |  |  |  |  |  | · Printed literature (flyers, event packet with schedule, maps)
 | · What suppliers have expressed interest / been a previous event sponsor? |  |  |  |  |  |  |  |  | · [NAME] (large event over multiple days; 300+ attendees)
 | [NAME] Event Planning Tracker
 | · Add due dates and assign staff to each task as needed
 | · When a task is in progress, update status in Column D with a value >1 (don't include % symbol). Columns B and C will update automatically.
 | · When the task is complete add 100 to Column D. Column C will show  '[NAME]' and Column B will show a green circle.
 | · If you need to add more rows, highlight the last row in columns B,C,D and drag down. Adjust column C as needed based on completion percentage.
 | [NAME]
 | Events Homepage on Compass |  |  |  |  | Order Branded Materials ([NAME], Tablecloth) |  |  |  |  | SAR (Special Activity Request)
 | Strategic Marketing Team Directory |  |  |  |  | Order Branded Merchandise |  |  |  |  | Company Levels Of Authority
 | Marketing Request Form |  |  |  |  | [NAME] Literature |  |  |  |  | Post-Event Survey |  | <--- Use this link to copy the post event survey template and update as needed
 | Create Event Invitations
 | Have questions or need assistance? Contact our events team:
 | LYNETTE BARANOWSKI |  |  |  |  | KATY MOGG |  |  | CHELSEA ROSS |  |  | [NAME] |  |  | JENNIFER SERVELLO
 | Director of Events |  |  |  |  | Events Manager - EES |  |  | Events Manager - CSS |  |  | Sr. Event Specialist |  |  | Events Specialist
 | Woodbury, NY |  |  |  |  | Pittsburgh, PA |  |  | Denver, CO |  |  | Sun Prairie, WI |  |  | Toronto, ON
 | [EMAIL] |  |  |  |  | [EMAIL] |  |  | [EMAIL] |  |  | [EMAIL] |  |  | [EMAIL]
 | [PHONE] |  |  |  |  | [PHONE] |  |  | [PHONE] |  |  |  |  |  | [PHONE]