Project Management Central

Please login or join to subscribe to this thread

Topics: Digital Project Management, Scheduling, Strategy
Excel Forecast template
Network:175



I am in need of a sophisticated excel template that can provide an analysis of forecast hours vs. actual hours worked. Ideally it would also have the 52 weeks itemized to show gaps or congestion in workload. Thanks.
Sort By:
Network:83607



Did you check the Deliverable, Courtni? I remember seeing something a lot like what you are asking for.
Network:175



I did but didn't find what I was needing. The template that was listed is resource hours and I really need something for forecast vs. actual. Thanks.
Network:4425



Check out Smartsheet, they have useful templates -

https://www.smartsheet.com/top-excel-budget-templates
Network:1


I would start with using a regression model. Start with the actuals as the observations and then the coefficients would be the 'trend'/Slope and a deviation from the average/Constant.

If you have additional prospective variables that you think 'drive' the trends, you can include these in a multivariate regression. (multiple regression)

If you would be able to provide a sample of the observations for the actuals, I could provide more precisely how this can be performed in Excel if the number of separate regression models is less than 3 or 4.

Hope this helps.
Network:717



If you can draw up a simple draft I can try to create one if you don't find one online

/sd
Network:3468



Thanks Anupam for sharing smart sheet

Please login or join to reply

Content ID:
ADVERTISEMENTS

"Enjoy yourself. It's later than you think."

- Chinese Proverb

ADVERTISEMENT

Sponsors

Vendor Events

See all Vendor Events