Gantt Chart: Excel or Google Sheets with Man Hours or Revenue/Crew Style

This is the all-in-one template for any organization that has crews to manage and a sales pipeline to track. The database is simple user entry and from there everything populates dynamically and the visuals adjust accordingly.

Style 1 - In Excel and Has Revenue Allocation



Pricing
You will be taken to a template download page after purchase.

This model gives the user an easy way to visually see (in a color coded gantt schedule) what crews/teams are working on in terms of various jobs and when they are working on them. Based on what crews you have assigned to what jobs, everything auto populates. You simply need to enter the start and end dates.

The benefit of this is to keep things organized and avoid over-booking your work force.

The second part of this that has been tied in is a sales pipeline tracker. It matches well with the gantt style because you may have revenue that is earned over many months and it is important to see how this revenue looks when it is spread out over the amount of months the job takes.

When you enter in the start/end dates for the crews and time frame they are working within, this doubles as the source for monthly estimated revenues by job. From there, you also get a summary of profit based on a margin % you put in as well as a labor/other cost entry.

Finally, you will get two visuals. The first shows average revenue and profit by month on a consolidated level across all jobs.

The second shows jobs won by month and average profit per job per month.

An instructions tab has been added as well as notes where necessary. The video should walk you through everything that you have questions on.

Style 2 ($45 as well) - Google Sheet Gantt Chart - Included in Purchase Above


If you purchase through the purchase button above for $45, this G sheet version will also be included on the template download page.

This is the google sheet version with just the crew scheduling aspect. Both a copy of the google sheet version and the excel full version with pipeline are included in the one-time price of $45. The benefit of this version is that multiple people can view it at one time. Hopefully it will make your labor hours more efficient.

Style 3 - Upper Tier (Man Hours/Job) *Includes versions above at no extra charge.




Pricing
You will be taken to the download page after purchase, which will include all 3 styles made available to you.

This upper tier version is functional for scheduling the man hours you plan on using for each project and based on that allocation and the available man hours you input for each period, it will show you how much available hours / space you have each day/week/month.

There is no coloring in this gantt because you are defining your view in the lens of man hours rather than crews working. It is a really nice visual for managers/owners to use to see where your busy frames are and at a level of man hours allocated/available, which is not included in the other version.

The way the google sheets versions work is that once payment is received I will send you full access to a copy of the primary version. Then, you will make your own copy and become the owner of your own version that is as fully functional as the original.

No comments:

Post a Comment