Forecasting Workload Needs

[mycon73]

A Project is being planned:
-- The Given Parameters are defined as we know or plan today
-- Looking to forecast if this is a realistic plan or to see the "true" efforts needed to get project done by target date

1st Assistance Request:
-- Calculate or verify total duration with known deliverables against estimated duration per each deliverable

2nd Assistance Request:
-- Determine number of resources needed to work project deliverables - preferably by original target date to complete
-- If full project can't be completed by target date, then forecast how much more workdays or duration is needed

Once I have calculations, I would then like to graph this out - I believe once I have the cals, I can take care of the rest

See attachment....

Thanks again...

[shg]

Project would be better suited to this.

[mycon73]

Yes,

Project would be (better) suitable for some of these intents, but at the same time, it's more of a pain to use, a bit restrictive & does not chart as well or all for some of the things that I plan to chart later.

Who can assist here?

It would be greatly appreciated.

Thanks....

[mycon73]

Hi Group,

Here's another reason that I'm trying to conduct / calculate my forecasts within Excel rather than using MS Project. As stated, I have 300 deliverables. At this time, I do not want to or need to insert all 300 deliverable within MS Project. More importantly, I rather use Excel to calculate / forecast the project # of deliverables per week through a graph chart.

I believe once I have the 2 primary questions answered, I can then conduct some scenarios to see how we can jockey the schedule around to develop a realistic project plan.

As good as MS Project it is, it still has some restrictions or not as user-friendly as Excel is.

Please help....


Thanks

[mycon73]

Hi Group,

I revised my template with some functions in it. However, I don't think these functions are fully calculating or forecasting my intents correctly. Cells highlighted in yellow are areas that I need assistance with or verification that it's calculating properly.

I’m mainly concerned with getting the # of deliverables & getting that distributed through the weeks needed until target date is reached.

Thanks

[mycon73]

Hi Group,

Please assist by reviewing the Forecasting Workload Needs_v2 file. I need to be certain that my calculations are accurate.


Thanks