You work for F&T Inc. which organizes events.
Plot an automated Gantt chart using Microsoft Excel. Create two milestones. Start the project on June 1st, 2020. Plan for a 5 day work week with normal holidays off (federal holidays). Color code activities based on responsibilities.

Task Name Duration Responsibility Constraint
Survey clients 30 days You
Determine convention goals 5 days Rudy Starts 15 days
after activity
"Survey clients" starts
Determine number
of attendees 2 days Jake
Set budget 3 days F&T Inc.
Set agenda 4 days F&T Inc.
Book entertainment 10 days You
Determine menu 3 days Daniel
Develop promotional
brochure 15 days You
Mail brochure 3 days Jake
Enroll attendees 3 months F&T Inc.
Convention 3 days F&T Inc.
Post assessment 2 weeks You