what is schedule variance and give the formula

Answers were Sorted based on User's Feedback



what is schedule variance and give the formula..

Answer / 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

what is schedule variance and give the formula..

Answer / harihara sudhan

Can any one explain with example?

Is This Answer Correct ?    3 Yes 7 No

what is schedule variance and give the formula..

Answer / vijayan

schedule variance=(actual end date)-(planned end
daie)/planned end date*100

Is This Answer Correct ?    2 Yes 6 No

what is schedule variance and give the formula..

Answer / anonymous

S.V = ((Actual Duration - Planned Duration)/Planned
Duration)*100

Actual Duration = Actual End Date - Planned Start Date
Planned Duration = Planned End Date - Planned Start Date

Is This Answer Correct ?    7 Yes 13 No

Post New Answer

More Manual Testing Interview Questions

Hi all, i am planning to take ISTQB CERTIFICATION, can any one guide me by giving the links for preparing for the exams. If anyone have some materials can u send me to my mail id vpbharathi@gmail.com. Thanks in advance, Bharathi.P

0 Answers  


what is use case

7 Answers  


1.The effectiveness of a test suite in detecting errors can be determined by counting the total number of test cases present in the test suite. is it true

0 Answers  


What is the RTM(Requirement Traceability Matrix)

1 Answers   Philips,


which of the following is NOT a characteristic of User Acceptance Testing?? A.Use of automated test execution tools B.Testing performed by user C.testing against acceptance test criteria D.integration of system with user documentation.

2 Answers   ADITI,






Write the test cases for file transfer from one user to other from Google Drive/drop box?

0 Answers   IBM, PanTerra,


Entry and Exit Ceiteria for System Testing?

2 Answers   Patni,


i want to take the questions of software testing of QA infotech company

0 Answers   Infotech,


can anbody tell me wht are microsoft 6 rules

5 Answers   Hoch Technologies,


How will you know if you wrote sufficient test cases for a particular business requirement.

4 Answers   McAfee,


how to write the test cases for mark as read/unread mails for gmail inbox?and what are the testings we will do?

0 Answers   3D PLM,


how will you test transfer funds module...explain in detail

0 Answers   Tarang,


Categories