Website Upgrade Incoming - we're working on a new look (and speed!) standby while we deliver the project

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Store Period Performance

3 replies [Last post]
Wed, 2010-07-21 20:36
Rifky Soedirdja
User offline. Last seen 7 years 24 weeks ago. Offline
Joined: 22 Apr 2010
Posts: 22
Groups: Petro-Chem / Oil & Gas
Another question about how to use Store Period Performance.

For example, I have 1 activity, let’s say Activity A, with budgeted labor Units = 100 Mhrs. Progress for this week = 50%, so Actual Labor units = 50 Mhrs and I run the Store Period Performance based on Financial Period for this week.

The following week, we achieve another 20% progress, means actual Labor units for that period is 20 mhrs. So, total Cumulative Actual Labor Units = 70 mhrs.

But in Activity Usage Spreadsheet, the distribution of Actual Labor Units is not 50 mhrs & 20 mhrs. It shows 32 mhrs & 38 mhrs. Total manhours is still the same 70 mhrs.

So, how to freeze the Actual labor units from the previous week (50 mhrs + 20 mhrs, instead of 32 mhrs + 38 mhrs)actually? Did I make a mistake when I apply Store Period Performance? Can somebody guide me the steps?

Your help is appreciated. Thanks.

Rgds,

Rifky
Top

Replies

Wed, 2010-07-21 21:39
#1
Rodel Marasigan
User offline. Last seen 1 week 22 hours ago. Offline
Joined: 25 Oct 2006
Posts: 1699
Groups: Petro-Chem / Oil & Gas
Rifky,
Unfortunately not both at the same time. You can either show % complete or Units and Cost.
Percent complete can be showed using Spreadsheet Options-> Calculate Average then enter the total cost or unit over 100.
For Planned use Period Planned Value Cost or Unit and for Actual use Period Earned Value Cost or Unit.
Top
Wed, 2010-07-21 21:31
#2
Rifky Soedirdja
User offline. Last seen 7 years 24 weeks ago. Offline
Joined: 22 Apr 2010
Posts: 22
Groups: Petro-Chem / Oil & Gas
Thanks Rodel.
Is it possible to show % complete for that Period also besides the Units, Cost, etc?

Rgds,

Rifky
Top
Wed, 2010-07-21 21:13
#3
Rodel Marasigan
User offline. Last seen 1 week 22 hours ago. Offline
Joined: 25 Oct 2006
Posts: 1699
Groups: Petro-Chem / Oil & Gas
Rifky,
Don’t use Actual Labor unit field from Units and use Financial Period Value instead on your spreadsheet. That is where all the data stored (i.e. Period Actual Labor Unit, etc…). Using original data will proportion from actual start to data date.
Top