PS Budget Report

[Former Member]

Hi,

My Client wants the report to be in below format, I dont understand the purpose of 4th column.

Column 1   Col 2           Col3	Col4
Budget  Commitment   Distributed	Forecast tll completion(Current0

Is there any possibility to add the 4th column, Please suggest.

Thanks.

[sushrut_sheth · Accepted solution]

Dear Pavan,

Business requirement is that the the budget and the commitment are known till date

but the company wants to know how much shall be my forecasted cost to complete a  given activity.

say for example

Budget Cost till date for 1000 sgft of work is 3000000 inr so budget cost per square feet is 3000

but the actual cost for 500 sqft is 2500000 so actual cost per square feet is 5000/sqft

so forecasted cost to completion shall be 5000*1000=5000000

hope this shall help you to understand the exact requirement.if answer is right mark as answered.

[Former Member · Accepted solution]

Hi Sushruth,

Can you give me one more example on this?

Is this possible to add this column in standard report, please confirm.

I need to develop this report for my client.

Thanks,

[sushrut_sheth · Accepted solution]

Dear Pavan,

the above example is best suited for construction industry

the same needs to be developed it is not standard.

another example can be:

cost to be incurred for the work to complete.is 1000 for  quantity of work 10 so cost to complete for one unit of work is 100

but in actual you have completed 5 unit of work for which you incurred a cost of 800 so now here for one unit of work cost is 800/5=160

so the total forecast cost shall be 160*10=1600

so the difference can also be calculated with this

hope this shall suffice

regards

[Former Member · Accepted solution]

HI,

Thanks, Can you check is the below calculation is correct

Total Forecast – Actual cost = Balance cost to complete

1600 –      800 =      800            

Thanks,

[sushrut_sheth · Accepted solution]

Dear Pavan,

it is okay

Please mark the answer correct instead of helpful.

Message was edited by: Sushrut Sheth

[Former Member]

Hi,

Check the Table BPGE. Pass OBJNR(Object no) of WBS. For WBS OBJNR, you have to check in PRPS table.

Check the column VOGRA(Budget Type)

KBUD: Original Bugut

KBUS:Supplement

KBUE:Return/Transfer

You will find the Current Budget against the WBS.

Regards

Shishir

[former_member189209]

Hi

Project Budget Report Use - S_ALR_87013558 ( Budget/actual/commitment/rem plan/assigned

Mahesh

[Former Member]

Hi Mahesh,

I proposed this report they are not okay with this, they  need columns 4,5,6 to be added as below.

Column 1   Col 2           Col3	Col4                                           Col5             Col6
Budget  Commitment   Distributed	Forecast tll completion(Current0   O/s Vendors   Payments

Thanks,

[former_member189209]

Hi

whatever I give T code - budget only pls check columns as per screen shot

otherwise you have to develop customized Zreport

mahesh

[sushrut_sheth]

Dear Pavan,

Standard reports are available or you can also go for the developments,but as per the question i think you wanted the clarification of forecasted cost.

[Former Member]

Hi,

check the standard reports available.

Regards,

Raman