what is schedule variance and give the formula

Answer Posted / sridhar

The purpose of SV is to know whether the delivery is done on time or not. If not, what is the variance.

PED- Planned END Date
PSD- Planned START Date
ASD- Actual START Date
AED- Actual END Date

Formula:
=IF(OR(ASD="",AED=""),"",IF(AED=PED,0%,IF(AED>PED,((NETWORKDAYS(ASD,AED)-NETWORKDAYS(PSD,PED))/NETWORKDAYS(PSD,PED))%,0%)))

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

WHAT IS OBJECT REPOSITORY? AND IT TYPES? HOW MANY TYPES OF ACTIONS ARE THERE IN QTP? CAN WE ADD NEW OBJECTS AND PROPERTIES INTO SHARED OBJECT REPOSITORY?

1460


can anyone help me in getting unix on manual testing i.e can u forward material & web sites to my mail id (suresh_57599@yahoo.com) to understand how the work flow working on manual testing on unix and the contents.plzzzzzzzz help me its urgent.

1425


What do you think the role of test-group manager should be? Relative to senior management?

1672


How can you do the scalability testing?

696


What and why is api testing?

953






What is a test severity and test priority? difference between them with suitable examples?

1311


When first time we are testing the screen then we have to write that this screen should contains so & so columns [ suppose there r 10 columns on that screen]in the expected result

1315


what is agile model and spiral maodel?pls explain with an example?

2150


Changes and enhancements to system?

1597


what r u r responsibilities in current project

2027


What are the advantages of waterfall model?

671


How can I done a Web Testing? Which steps are include in it?

1441


what is the difference between website and web based application ?

2258


what is data guidelines

1643


write test cases on wall

1722