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

If you find a crashing bug and the developer resolves it Not Repro, what would you do? What if s/he resolves it as Won’t Fix?

0 Answers  


define Testing of Procedure, Triggers and Functions in data base testing ?

0 Answers   CSS, Hexaware,


wat is the role of tester in SDLC

8 Answers   IBM, STC,


What exactly are semi-random test cases?

0 Answers  


Currently iam working in testing line, iam trying in other company in the testing line itself, but my friends are telling without any reference it is unable to get a job in a reputated company, is it true?

3 Answers   Satyam,






What is the difference between load testing and performace testing?

0 Answers   Infosys,


If you are a test lead. Then how should you know all the requirements are covered in Test Cases if your team member has wrote the test cases?

3 Answers   Virtusa,


write 3 major bugs in inventory management system ...give 3 system test case and 3 integration test case

1 Answers   IBM,


1) how will you do validation testing in combo box ? (2)Suppose user does not want maximum length validation message, but when tester inserts data in textbox and it gets truncated, how will you resolve this issue ? (3)if a user inserts maximum number in quantity textbox in a PHP based web application then what result will show?

0 Answers  


hi.i joined in a software testing course recently.but i dnt knw 'c' or 'c++',would it mind? my stream is ece. so i just had a C&DS IN OUR 1ST SEMESTER.

1 Answers  


What is the difference between smoke and sanity testing? and when we perform smoke testing and when we perform sanity testing?

8 Answers   Tanla Solutions,


What is the best testing tool to test an desktop application(extJS app)?

2 Answers   Nagarro,


Categories