Estimate At Completion
Forum Sponsor
Top Posters
Nick Johnson-Pond
3 posts
sairedz25
0 posts
Ahmed Awad
2 posts
Syed Shoeb
0 posts
Vimukthi
0 posts
bal aji
2 posts
Lee Mallek
23 posts
Viet Tran
9 posts
Ola Gbotoso
0 posts
Jaturapit Multongka
1 posts
Karl
You are working with different bases for estimation and real. If there is a payment period, you can work with two milestones:
1. The event and e.g. a transfer to SAP to create the invoice, where no money is assigned
2. The milestone with the payment assigned with the due date. Which then will be the basis for CPI.
Regards
Dieter
Karl
6000 activities in a well structured project in my opinion isnt too much to maintain.
Another idea to your item: CPI is project costing, payment is accounting. This should be separated. The payment itself; thats not your issue - maybe youll have to stop work after non payment. If management agrees you can enter income, when the invoice was written, i. e. not regarding the due period. Needs a reliable customer.
The payment is not your item but the work and the result.
Just an idea, maybe it will work.
Good luck
Dieter
Dear Karthick,
You need to decide all your cost items properties. Are you going to accept them as they performed (Invoiced) or as they paid in cash.
Be aware of that your expenditures will happen same as your income. You will pay mostly a month after you invoice.
My suggestion for a cost control system. You need to plan and monitor the invoices not the money itself. This is the way of creating a budget. Then you can decide the rules of paying and you can have your cash flow from your budget. Ex:
Payments of A Sub-cont. 1 month after invoice.
Payments of X material purchase. Directly @ proc.
Payments of Invoices(Income). 45 days of invoice date
You need to have a budget and a cash plan (flow) which is basis on that budget. You can use activity codes for types of payment and you can create the cash flow in excel or another subproject of your schedule. (At least our system is working like this)
Best Regards,
Safak
Dieter,
using milestone seems to be a nice idea but the problem i have got here is that, I have got close to 6000 activities in the schedule and 90% of them have cost in it. moreover I have got the subcontractors schedule which i have kept as a aubproject with a one line activity in the master. Adding milestone will make the schedule even more bigger and hard to manage. I am just wondering if change the cost to an expense and distribute the cost to the end of an activity, Would it work?????
Thanks
Karl