Forcasting hassles

[moxie]

Hi all, Hope someone can shed some light on this, it's being doing my mind in trying to work out how to approach it...

I've built a full production tool for the business, job database, estimating, invoicing, all the normal bells and whistles. I've now got to the forcasting stage of the job, and am stumped how to begin. I've looked/viewed lots of calandars out there, but still seem a bit fuzzy.

I've attached a PDF of the current forecasting tool the manager puts together in Excel to check when jobs are booked in for etc... I obviously have all the Job details etc... that I can link in. It's setting out the forcasting tool so it acts like a gant chart that's got me stumped, hope someone can sheed some light...Also I've looked at numerous gant chart options, but because they generally don't show all the days, it make it hard to balance when incoming work can happen...

Hope this makes sense...

Forcasting.pdf