Time & PO Cap Distribution or Allocation

Hi,

I'm looking to forecast 2 scenarios as follows for a project:

Start Date: 07/06/15
End Date: 12/31/15
PO Cap: $125,000

I have an example attached.

I would like to assume standard work hours & holidays & allocate available work hours between these days, as well as distribute or allocate the PO Cap evenly between start & end dates?

2nd Scenario,

Same as above but have the option to Front load by 1/4, 1/2 or 3/4 so it's more representative of a real world project.

Thanks for the assistance.

Hello cyiangou & Others,

Thanks for taking the time to assist.


This is almost what I'm looking for, however for my Hours Distributed row or row 19, I'm looking to distribute or allocate the cumulative total available (planned) hours during specified Start & End Dates.

For example if I have a 2 week work duration & assuming normal work week 0r 40 hours, then I would have 80 hours or 40 hours distributed / allocated per week over 2 weeks. If one week falls on a holiday, then I would have 8 hours less because of this.

Now, I'm looking to do the same except over a much longer duration.

The PO Cap Distributed appears exactly what I'm seeking - Taking the PO Cap & distributing / allocating over the specified Start & End Dates.

As for "Front Loading" - I'm creating this for a project. With most projects, the majority of work effort is "up front" then approximately midway through to 3/4 into the project, it tappers down or less effort is needed.

I'm looking to demonstrate this by putting 1/4 (.25) , 1/2 (.5) or 3/4 (.75) option in & distributing / allocating that across.

I modified your file to include this in a box area called "Front Load Effort Distribution".

Thanks again for the assistance

Hi cyiangou & Others,

The , "=D18*8" works well - Thanks for this.

What's the way to get the PO Cap Distributed / allocated between specified Start & End Dates.

As for "Front Loading" - I'm creating this for a project. With most projects, the majority of work effort is "up front" then approximately midway through to 3/4 into the project, it tappers down or less effort is needed.

I'm looking to demonstrate this by putting 1/4 (.25) , 1/2 (.5) or 3/4 (.75) option in & distributing / allocating that across.

Thanks

Hi cyiangou

I think we have kind of the same intent.

From my perspective, I was taking the PO Cap or budget & trying to demonstrate that during the first 1/4 of the project - Where a large part of the planning takes place may take up to 1/4 to half the budget during the 1/2 of the program duration, then express that in dollars?

Is this making sense? This may be a little more complex to demonstrate but as we probably know with projects, majority of funds are spent up front with a burn down until funds are used up or if going the opposite way - A burn up rate until the budget rate meets or exceeds PO cap.

For the first part of my PO Cap - Simply showing an even distribution or allocation over the specified duration is sufficient - Even though it it's not realistic for the last 3/4 to end of program because the weekly money spent should be decreased.

I hope this make sense.

Thanks again for the assistance.

Hi Group,

Does anyone have a suggestion?

How to take PO Cap or limit & distribute over specified dates - Assuming Standard Work & excluding holidays

Example: $150K between July 6, 2015 through December 31, 2015


Thanks