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

Can you explain the concept of tailoring?

0 Answers  


describe Bug life Cycle and the process taken in your organization.

4 Answers   HCL,


"Why are you looking for a change?". This is the common question that is asked in any interview. Can anyone tell me wat kind of answer would impress the interviewer.

5 Answers  


How will you test language converter e.g. (English to Spanish) without Automation tool? OR What are the test cases or scenarios for language converter? Conditions: 1. without Automation tool, 2. You know only English language. 3. Make sure the tests should produce 80-90% pass result.

2 Answers   Mastek,


why sanity testing and why smoke testing?

6 Answers  


As you are working with cmmi level 5 company ,can you tell me what processes you r following as QA engineer?

0 Answers   Xansa, Zensar,


how to access a build & wat is its configuration

0 Answers   Tech Mahindra,


What r the types of Test case design techniques

15 Answers   TCS, Wipro,


How the value of P in cyclomatic complexity is calculated? P:The number of connected path.

1 Answers  


Hi can any body clarify me plz What are responsibilities of a test engineer in the company,and how he communicates wiht t.l as well as test manager, In wich situation this type of i mean serious commnication takes place(give me one example).and how the interaction will takes place between tester and client can anybody plz clatify me

1 Answers  


difference between load testing and stress testing?

4 Answers  


get the employees details ordered by employee name in alphabetical orders

1 Answers   IBM,


Categories