i need a gantt Excel sheet for the following table for 3 year 2020 november to 2023 november i will attach the following document
Finance plan
Task | Resource(type) | Resource (Qty) | Working Days | Working Hours | Rate/Hr | Total(cad) | |
1.Increasing customer base Giving free advices by conducting meetings in the colleges Customer financing Referral programs | Sr manager one staff | 1 | 72 1095 | 576 8,760 | n/a 14 | n/a $122,640 | |
2.Modifying the marketing strategies Marketing in social media Analyzing the data by using online SEO tools like software Ahref’s | Branch manager (1-time purchase) | 1 3(2 renewal) | 1,095 1,095 | 8,760 8,760 | 20 500/monthly | $175,200 $18,000 | |
3.Increase in community engagement For the branch in India | Director | | 695 | 5,560 | n/a | n/a | |
4. Increase customer services with faster response times Virtual assistant online pop-up chat Hiring staff Regular training and development of employees | One staff Sr manager Branch Manager | 1 1 | 1,095 36 360 | 8,760 288 2,880 | 14 n/a 20 | $122,640 n/a $57,600 | |
Total | $496,080 |
72 days- (jan 2021 to March 2021)
1095 days- (November 2020 to November 2023)
695 days- (JAN 2021 to dec 2022)
360 days – (Jan 2021 to jan 2022)