Post

1 follower Follow
0
Avatar

Financial performance indicator

Hi

 

I had a question that I have been waiting for Clarizen to get back to me for a while.  Can you advise how I should proceed regarding this question/issue?

Nverci01 Answered

Please sign in to leave a comment.

9 comments

0
Avatar

Hi Naomi,

 

Could you please give more details about your question/issue ?

 

Jonathan, Clarizen Customer Success

Jonathan Angel 0 votes
Comment actions Permalink
0
Avatar

Naomi,

Your response to the post was not logged in the system.  Did you just reply to a notification email that your received? Unfortunately these do not push back into the community, so this is the first we have seen your questions about opening a case.

For a deeper investigation, yes you would have to open a case. However, can you also tell me what the CPI is for that particular work item? This is what drives the financial status field.

Josh

Josh Santos 0 votes
Comment actions Permalink
0
Avatar

Hi Josh

Sorry for late reply.  Yes, I replied to my e-mail notifications.  Now I know where the thread is.  Where can I find CPI?  Or should I open a case?  

Nverci01 0 votes
Comment actions Permalink
0
Avatar

Ah there you are =).  I believe I emailed you this answer as well (hopefully it went to the right person).  If you go to a work item’s properties (right click >> properties) you can access CPI from the Finance tab as seen in the screenshot below:

cpi.jpg

Josh Santos 0 votes
Comment actions Permalink
0
Avatar

Hi Josh

Please see the numbers below.  Since we are customer side, it should not show profit (especially negative profit).  How can I fix it so that Clarizen only look at Budget cost vs. Actual cost?

 

|

Total Estimated Cost

 

|

 

|

 

|

 

|
|

Budgeted Cost

 182,154

|

Fixed Cost

 

|

Actual Cost

 77,198.55

|

Cost Balance

 

|
|

Expected Revenue

 

|

Fixed Price

 

|

Actual Revenue

 

|

Revenue Balance

 

|
|
 
|
|

Budget Status

 

*At Risk

|

Profit

 -77,198.55

|

% Profitability

 

|

% Invested

 

|

 

|

Earned Value

 148,431.68

|

CPI

 1.92

|

SPI

 10.7

|

Cost Variance

 71,233.13

|
|

ETC

 1638.6

|

EAC

 78837.1

|

TCPI

 -0.7

|  
|

Nverci01 0 votes
Comment actions Permalink
0
Avatar

The difference between budgeted cost and actual cost is the Cost Balance field.  You can also create a custom financial field with any formula you would like.  Profit is Actual Revenue minus Actual Cost, so you can ignore this field if you do not need it.

Josh Santos 0 votes
Comment actions Permalink
0
Avatar

Hello

If I create a custom filed that is Cost  (Budgeted minus Actual Cost), can financial indicator used for the cost variance?  i.e. Green if Actual cost is lower than Budgeted, Red if Actual cost is higher than Budgeted?

Nverci01 0 votes
Comment actions Permalink
0
Avatar

Yes, this is entirely possible. You would need a custom field (picklist) for the indicators and then either a workflow rule or scheduled workflow rule that would set it based on budget vs. actual costs (there is already a field for this called Cost Balance).

Josh Santos 0 votes
Comment actions Permalink
0
Avatar

Thanks!  I also attended Q& A session and got some ideas.  i am good now :)

Nverci01 0 votes
Comment actions Permalink