Hi ahmad Thanks for the videos that always informative I have one question As PMP book showing SPI = EV/PV CPI = EV/AC And when the values are more than 1 that means we are ahead of schedule / Below the budget I think it is the same idea in the video but u used SPI = PV/EV CPI = AC/EV The opposite but it reaches the same idea Can u clarify this if both are applicable?
Thanks Owen for the request. I’ll think about an idea of how to present the video. But from experience I can tell you that the best way for that is professional ERP systems like Xpedeon. Using such systems can give you the actual cost on both resource and prime activity levels. And to get such reports using excel, believe me there will be much missing costs and you will not get the actual VS planned cost that you are looking for.
Hi sir, a slight confusion. Cost overrun means actual cost is more than the budget which we call as over the budget and cpi is less than 1 is over the budget but in your case it is opposite.
![Felix "Unfair" | [Stray Kids : SKZ-PLAYER]](http://i.ytimg.com/vi/Oswujxm2Ag0/mqdefault.jpg)
Always on point!
❤
Thank you 🙌
You're welcome!
Kindly share the template 🙈
Finally. Worth the wait!
I hope you liked it ☺️
@@CEPQS❤
Best cost channel on yt for a reason ❤
Thanks a lot for the continuous support ❤️
Your great teacher, making us clear understanding what I didn’t get in university.. thank you please keep doing
Thank you 😊. Wish you all the best
Watching from Nigeria
Thanks sir ❤
Thank you for watching. All love ❤️
Very informative and very clear explaination
Glad you liked it ☺️
Worth watching ❤
Thank you, hope you enjoyed 😊
Superb 🎉 thanks for uploading
Thanks for watching. Glad you liked it.☺️
Hi Ahmed, superb video...can you please make this spreadsheet available....and where can we find it?
Thanks for watching 😊. I’ll make it available soon
Eagerly waiting for excel sheet
Once I prepare the link, it will be in the description
Hi ahmad
Thanks for the videos that always informative
I have one question
As PMP book showing
SPI = EV/PV
CPI = EV/AC
And when the values are more than 1 that means we are ahead of schedule / Below the budget
I think it is the same idea in the video but u used
SPI = PV/EV
CPI = AC/EV
The opposite but it reaches the same idea
Can u clarify this if both are applicable?
Yes correct in most resources, the EV is divided by AC. In that case you divide by the CPI to get Cost At Completion.
Can you please do a video on Cost Value Reconciliation? A big part of a QS’s monthly duties
Thanks Owen for the request. I’ll think about an idea of how to present the video. But from experience I can tell you that the best way for that is professional ERP systems like Xpedeon. Using such systems can give you the actual cost on both resource and prime activity levels. And to get such reports using excel, believe me there will be much missing costs and you will not get the actual VS planned cost that you are looking for.
Great sir ; but this topic isn't available in your CEP Course sir!
Thank you 😊. Right, the course is about cost estimation.
Where can I get the Excel format I need?
I’ll make it available shortly
Hi sir, a slight confusion. Cost overrun means actual cost is more than the budget which we call as over the budget and cpi is less than 1 is over the budget but in your case it is opposite.
Because I’m dividing by the earned value. Don’t memorize formulas. Focus on the concept 👍
❤❤❤❤
❤️
want excel sheet please, and thanks for the great vedio!
I will make it available soon. Thanks for watching