training time= IF THEN ELSE( Time>0 , training time look up(Time*normalizing factor),1) ~ Month ~ | training time look up( [(0,0)-(100,10)],(0,0),(1,1),(6,2),(11,3),(21,4),(50,5),(100,5)) ~ Month ~ | month wages paid rate= IF THEN ELSE( project end=1 , 0 , (Project staff+Staff in training)*AVG WAGE FOR PROJECT STAFF\ ) ~ dollars/Month ~ | productivity= productivity table lookup((Project staff+Staff in training)*tablelookup factor) ~ Dmnl/person ~ | project end= IF THEN ELSE( INITIAL PROJECT LOAD+work additions cmulative-Project work completed<0.001\ , 1 , 0 ) ~ Dmnl ~ | training rate= IF THEN ELSE( project end=1 , 0 , Staff in training/training time) ~ person/Month ~ | Assignment rate= ( IF THEN ELSE( (Project work to be done/available time)>(Project staff-project staff assigned to rework\ ), IF THEN ELSE ( (Project work to be done/available time)-(Project staff-project staff assigned to rework\ )0 , Earned Value-Total Planned Value , 0 ) ~ dollars ~ | Cost Variance= IF THEN ELSE( Time>0 , Earned Value-Project staff wages , 0 ) ~ dollars ~ | rejection normal= 0.05*schedule pressure factor*normalizing factor ~ Dmnl/Month ~ typically the rejection rate normal is 5% | accumulation rate= (work additions+work obsoleted)*AVG WAGE FOR PROJECT STAFF ~ dollars/Month ~ | additions accumulation rate= work additions ~ (person*Month)/Month ~ | staff turnover normal= 0.01*schedule pressure factor*normalizing factor ~ Dmnl/Month ~ | CHANGE REQUEST TIME= 19 ~ Month ~ Change Request point during the project execution. | PV for additions= "Planned Value -for changes per month" ~ dollars/Month ~ | work obsoleted= IF THEN ELSE( Time=CHANGE REQUEST TIME, Project work completed*OBSOLESCENCE NORMAL ,\ 0 ) ~ person*Month/Month ~ | "Planned Value -for changes per month"= (IF THEN ELSE( work additions>1, ((work additions+work obsoleted )*AVG WAGE FOR PROJECT STAFF\ )/(SCHEDULED COMPLETION TIME -Time),0))/nrmalizing factor ~ dollars/Month ~ | Planned Value for additions after change request= IF THEN ELSE( SCHEDULED COMPLETION TIME-Time>=0, total value for additions and changes\ -(SCHEDULED COMPLETION TIME-Time )*stored monthly charge*nrmalizing factor, total value for additions and changes) ~ dollars ~ | "Planned Value-basecase"= (IF THEN ELSE( SCHEDULED COMPLETION TIME-Time>=0 ,(INITIAL PROJECT LOAD*AVG WAGE FOR PROJECT STAFF\ )*(Time/SCHEDULED COMPLETION TIME ),INITIAL PROJECT LOAD*AVG WAGE FOR PROJECT STAFF)) ~ dollars ~ | work additions= IF THEN ELSE( Time=CHANGE REQUEST TIME , INITIAL PROJECT LOAD*INCREASE IN WORK NORMAL\ , 0 ) ~ person*Month/Month ~ | Project work to be done= INTEG ( work additions-work flow, INITIAL PROJECT LOAD) ~ person*Month ~ | stored monthly charge= INTEG ( PV for additions, 0) ~ dollars ~ | Schedule Performance index= IF THEN ELSE( Time>0 , Earned Value/Total Planned Value,0) ~ Dmnl ~ | Cost Performance Index= IF THEN ELSE( Time>0 ,Earned Value/Project staff wages,0) ~ Dmnl ~ | Earned Value= Total Planned Value*(Project work completed/(INITIAL PROJECT LOAD+work additions cmulative\ )) ~ dollars ~ | nrmalizing factor= 1 ~ Dmnl/Month ~ | total value for additions and changes= INTEG ( accumulation rate, 0) ~ dollars ~ | work additions cmulative= INTEG ( additions accumulation rate, 0) ~ Month*person ~ | Total Planned Value= Planned Value for additions after change request+"Planned Value-basecase" ~ dollars ~ | rework rate= IF THEN ELSE( "Project Work-In-Progress">2 ,"Project Work-In-Progress"*rejection normal\ ,0) ~ person*Month/Month ~ | schedule pressure factor= schedule pressure tab lookup(available time/SCHEDULED COMPLETION TIME) ~ Dmnl ~ | schedule pressure tab lookup( [(0,0.8)-(1,2)],(0,2),(0.1,1.8),(0.15,1.5),(0.25,1.25),(0.5,1.1),(1,1)) ~ Dmnl ~ | work acceptance rate= IF THEN ELSE( "Project Work-In-Progress"*acceptance normal>2, "Project Work-In-Progress"\ *acceptance normal, "Project Work-In-Progress"*normalizing factor ) ~ (person*Month)/Month ~ | Project staff wages= INTEG ( month wages paid rate, 0) ~ dollars ~ | AVG WAGE FOR PROJECT STAFF= 5000 ~ dollars/(Month*person) ~ average wages are taken at $5,000/month for a project staff | Project work completed= INTEG ( work acceptance rate-work obsoleted, 0) ~ person*Month ~ | INITIAL PROJECT LOAD= 100 ~ person*Month ~ | Rework identified= INTEG ( +rework rate-rework processing rate+work obsoleted, 0) ~ person*Month ~ | INCREASE IN WORK NORMAL= 0.2 ~ Dmnl/Month ~ | OBSOLESCENCE NORMAL= 0.4 ~ Dmnl/Month ~ | availability rate= ( IF THEN ELSE( (Project work to be done/available time)<(Project staff-project staff assigned to rework\ ), (Project staff -project staff assigned to rework)-(Project work to be done/available time\ ) , 0 )*availability rate normal ) ~ person/Month ~ | normalizing factor= 1 ~ Dmnl/Month ~ to convert the work to be done to a rate, if need be. | work flow= IF THEN ELSE( Project work to be done*normalizing factor>0.5, IF THEN ELSE( Project work to be done\ *normalizing factor>(Project staff-project staff assigned to rework)*productivity*workflow normal\ , (Project staff-project staff assigned to rework) * productivity*workflow normal, \ Project work to be done*normalizing factor ), Project work to be done*normalizing factor\ ) ~ person*Month/Month ~ | rework processing rate= (IF THEN ELSE( Rework identified>1, IF THEN ELSE( project staff assigned to rework*productivity\ *rework normal*(1/normalizing factor)0, SCHEDULED COMPLETION TIME-Time, 1) ~ Month ~ available time depending upon targetted completion time | hiring normal= 1 ~ Dmnl/Month ~ | productivity table lookup( [(0,0)-(100,1)],(0,0),(0.01,1),(1,1),(10,0.5455),(20,0.531),(30,0.5065),(40,0.472),(\ 50,0.4275),(60,0.373),(70,0.3085),(80,0.234),(90,0.1495),(100,0.055)) ~ Dmnl/person ~ | project staff assigned to rework= IF THEN ELSE( Rework identified/rework time1, Project staff*staff turnover normal, 0) ~ person/Month ~ | workflow normal= 1 ~ person*Month/Month ~ | ******************************************************** .Control ********************************************************~ Simulation Control Parameters | FINAL TIME = 40 ~ Month ~ The final time for the simulation. | INITIAL TIME = 0 ~ Month ~ The initial time for the simulation. | SAVEPER = TIME STEP ~ Month [0,?] ~ The frequency with which output is stored. | TIME STEP = 1 ~ Month [0,?] ~ The time step for the simulation. | \\\---/// Sketch information - do not modify anything except names V300 Do not put anything below this section - it will be ignored *Project Dynamics $192-192-192,0,Times New Roman|12||0-0-0|0-0-0|0-0-255|-1--1--1|-1--1--1|96,96,75 10,1,Project work to be done,307,372,44,37,3,3,0,0,0,0,0,0 10,2,"Project Work-In-Progress",556,369,83,38,3,3,0,0,0,0,0,0 10,3,Project work completed,802,373,97,39,3,3,0,0,0,0,0,0 10,4,Rework identified,557,518,83,38,3,3,0,0,0,0,0,0 1,5,7,4,4,0,0,22,0,0,0,-1--1--1,,1|(611,463)| 1,6,7,2,100,0,0,22,0,0,0,-1--1--1,,1|(611,421)| 11,7,1164,611,441,8,6,33,3,0,0,2,0,0,0 10,8,rework rate,565,441,38,11,40,3,0,0,-1,0,0,0 1,9,11,2,4,0,0,22,0,0,0,-1--1--1,,1|(496,424)| 1,10,11,4,100,0,0,22,0,0,0,-1--1--1,,1|(496,466)| 11,11,1084,496,447,8,6,33,3,0,0,2,0,0,0 10,12,rework processing rate,440,447,48,19,40,3,0,0,-1,0,0,0 1,13,15,2,4,0,0,22,0,0,0,-1--1--1,,1|(440,371)| 1,14,15,1,100,0,0,22,0,0,0,-1--1--1,,1|(373,371)| 11,15,1180,402,371,6,8,34,3,0,0,1,0,0,0 10,16,work flow,402,390,33,11,40,3,0,0,-1,0,0,0 1,17,19,3,4,0,0,22,0,0,0,-1--1--1,,1|(691,369)| 1,18,19,2,100,0,0,22,0,0,0,-1--1--1,,1|(652,369)| 11,19,1036,672,369,6,8,34,3,0,0,1,0,0,0 10,20,work acceptance rate,672,400,55,19,40,3,0,0,-1,0,0,0 12,21,48,130,366,10,8,0,3,0,0,-1,0,0,0 1,22,24,1,4,0,0,22,0,0,0,-1--1--1,,1|(235,366)| 1,23,24,21,100,0,0,22,0,0,0,-1--1--1,,1|(167,366)| 11,24,48,201,366,6,8,34,3,0,0,1,0,0,0 10,25,work additions,201,385,47,11,40,3,0,0,-1,0,0,0 10,26,Available staff,240,-41,48,32,3,3,0,0,0,0,0,0 10,27,Project staff,530,103,48,32,3,3,0,0,0,0,0,0 12,28,48,75,-39,10,8,0,3,0,0,-1,0,0,0 1,29,31,26,4,0,0,22,0,0,0,-1--1--1,,1|(165,-41)| 1,30,31,28,100,0,0,22,0,0,0,-1--1--1,,1|(105,-41)| 11,31,48,132,-41,6,8,34,3,0,0,1,0,0,0 10,32,new hire rate,132,-22,41,11,40,3,0,0,-1,0,0,0 12,33,48,722,106,10,8,0,3,0,0,-1,0,0,0 1,34,36,33,4,0,0,22,0,0,0,-1--1--1,,1|(689,103)| 1,35,36,27,100,0,0,22,0,0,0,-1--1--1,,1|(616,103)| 11,36,48,660,103,6,8,34,3,0,0,1,0,0,0 10,37,turnover,660,122,27,11,40,3,0,0,-1,0,0,0 1,38,36,31,1,0,0,0,0,64,0,-1--1--1,,1|(425,-188)| 10,39,productivity,383,290,38,11,8,3,0,0,0,0,0,0 1,40,39,15,1,0,0,0,0,64,0,-1--1--1,,1|(376,329)| 1,41,27,15,1,0,0,0,0,64,0,-1--1--1,,1|(462,243)| 1,42,44,26,4,0,0,22,0,0,0,-1--1--1,,1|(240,102)| 1,43,44,27,100,0,0,22,0,0,0,-1--1--1,,1|(395,102)| 11,44,380,302,102,6,8,34,3,0,0,1,0,0,0 10,45,availability rate,302,121,47,11,40,3,0,0,-1,0,0,0 1,46,26,31,1,0,0,0,0,64,0,-1--1--1,,1|(180,-64)| 1,47,27,31,1,0,0,0,0,64,0,-1--1--1,,1|(351,89)| 1,48,27,44,1,0,0,0,0,64,0,-1--1--1,,1|(406,205)| 1,49,27,36,1,0,0,0,0,64,0,-1--1--1,,1|(606,72)| 10,50,staff turnover normal,861,-30,42,19,8,3,0,0,0,0,0,0 1,51,50,36,1,0,0,0,0,64,0,-1--1--1,,1|(771,-107)| 10,52,acceptance normal,747,294,59,11,8,3,0,0,0,0,0,0 1,53,52,19,1,0,0,0,0,64,0,-1--1--1,,1|(695,317)| 1,54,2,19,1,0,0,0,0,64,0,-1--1--1,,1|(615,318)| 1,55,2,7,1,0,0,0,0,64,0,-1--1--1,,1|(590,415)| 10,56,rejection normal,735,453,51,11,8,3,0,0,0,0,0,0 1,57,56,7,1,0,0,0,0,64,0,-1--1--1,,1|(668,463)| 10,58,productivity table lookup,181,249,55,19,8,3,0,0,0,0,0,0 1,59,58,39,1,0,0,0,0,64,0,-1--1--1,,1|(299,254)| 1,60,27,39,1,0,0,0,0,64,0,-1--1--1,,1|(452,267)| 10,61,project staff assigned to rework,719,228,61,19,8,3,0,0,0,0,0,0 1,62,4,61,1,0,0,0,0,64,0,-1--1--1,,1|(892,524)| 1,63,61,15,1,0,0,0,0,64,0,-1--1--1,,1|(493,246)| 1,64,56,52,1,0,0,0,0,64,0,-1--1--1,,1|(651,370)| 10,65,SCHEDULED COMPLETION TIME,124,534,54,28,8,3,0,0,0,0,0,0 10,66,available time,136,451,43,11,8,3,0,0,0,0,0,0 10,67,Time,237,506,26,11,8,2,0,3,-1,0,0,0,128-128-128,0-0-0,|12||128-128-128 1,68,67,66,1,0,0,0,0,64,0,-1--1--1,,1|(185,487)| 1,69,65,66,1,0,0,0,0,64,0,-1--1--1,,1|(92,487)| 1,70,39,11,1,0,0,0,0,64,0,-1--1--1,,1|(419,378)| 1,71,61,11,1,0,0,0,0,64,0,-1--1--1,,1|(480,295)| 1,72,27,61,0,0,0,0,0,64,0,-1--1--1,,1|(628,167)| 10,73,rework time,704,170,39,11,8,3,0,0,0,0,0,0 1,74,73,61,1,0,0,0,0,64,0,-1--1--1,,1|(710,186)| 1,75,1,15,1,0,0,0,0,64,0,-1--1--1,,1|(365,424)| 10,76,assignment rate normal,402,-141,41,27,8,3,0,0,0,0,0,0 10,77,availability rate normal,147,100,46,18,8,3,0,0,0,0,0,0 1,78,77,44,0,0,0,0,0,64,0,-1--1--1,,1|(237,100)| 1,79,66,44,1,0,0,0,0,64,0,-1--1--1,,1|(121,186)| 1,80,1,44,1,0,0,0,0,64,0,-1--1--1,,1|(275,166)| 1,81,61,44,1,0,0,0,0,64,0,-1--1--1,,1|(404,106)| 10,82,hiring normal,112,-144,41,11,8,3,0,0,0,0,0,0 1,83,82,31,1,0,0,0,0,64,0,-1--1--1,,1|(113,-78)| 10,84,workflow normal,362,492,54,11,8,3,0,0,0,0,0,0 1,85,84,15,1,0,0,0,0,64,0,-1--1--1,,1|(395,435)| 10,86,rework normal,381,523,47,11,8,3,0,0,0,0,0,0 1,87,86,11,1,0,0,0,0,64,0,-1--1--1,,1|(443,502)| 10,88,normalizing factor,482,571,55,11,8,3,0,0,0,0,0,0 1,89,88,15,1,0,0,0,0,64,0,-1--1--1,,1|(329,493)| 1,90,88,11,1,0,0,0,0,64,0,-1--1--1,,1|(430,490)| 1,91,4,11,1,0,0,0,0,64,0,-1--1--1,,1|(523,455)| 1,92,1,31,1,0,0,0,0,64,0,-1--1--1,,1|(281,237)| 1,93,66,31,1,0,0,0,0,64,0,-1--1--1,,1|(102,41)| 1,94,61,31,1,0,0,0,0,64,0,-1--1--1,,1|(531,270)| 1,95,67,24,1,0,0,0,0,64,0,-1--1--1,,1|(191,420)| 1,96,98,4,4,0,0,22,0,0,0,-1--1--1,,1|(738,520)| 1,97,98,3,100,0,0,22,0,0,0,-1--1--1,,1|(843,462)| 11,98,252,843,520,6,8,34,3,0,0,1,0,0,0 10,99,work obsoleted,843,548,47,20,40,3,0,0,-1,0,0,0 1,100,67,98,1,0,0,0,0,64,0,-1--1--1,,1|(572,631)| 10,101,INITIAL PROJECT LOAD,133,302,60,19,8,3,0,0,0,0,0,0 1,102,101,24,1,0,0,0,0,64,0,-1--1--1,,1|(139,340)| 10,103,INCREASE IN WORK NORMAL,259,303,64,19,8,3,0,0,0,0,0,0 1,104,103,24,1,0,0,0,0,64,0,-1--1--1,,1|(236,343)| 10,105,OBSOLESCENCE NORMAL,742,714,65,19,8,3,0,0,0,0,0,0 1,106,105,98,1,0,0,0,0,64,0,-1--1--1,,1|(865,599)| 1,107,3,98,1,0,0,0,0,64,0,-1--1--1,,1|(895,455)| 10,108,Project staff wages,850,-183,52,37,3,3,0,0,0,0,0,0 10,109,AVG WAGE FOR PROJECT STAFF,855,-116,62,19,8,3,0,0,0,0,0,0 12,110,48,655,-185,10,8,0,3,0,0,-1,0,0,0 1,111,113,108,4,0,0,22,0,0,0,-1--1--1,,1|(767,-185)| 1,112,113,110,100,0,0,22,0,0,0,-1--1--1,,1|(695,-185)| 11,113,48,731,-185,6,8,34,3,0,0,1,0,0,0 10,114,month wages paid rate,731,-158,42,19,40,3,0,0,-1,0,0,0 1,115,27,113,1,0,0,0,0,64,0,-1--1--1,,1|(630,-61)| 1,116,109,113,1,0,0,0,0,64,0,-1--1--1,,1|(757,-129)| 1,117,88,19,1,0,0,0,0,64,0,-1--1--1,,1|(649,554)| 10,118,schedule pressure factor,500,660,57,19,8,3,0,0,0,0,0,0 10,119,schedule pressure tab lookup,127,603,57,19,8,3,0,0,0,0,0,0 1,120,66,118,1,0,0,0,0,64,0,-1--1--1,,1|(251,582)| 1,121,119,118,1,0,0,0,0,64,0,-1--1--1,,1|(204,650)| 1,122,65,118,1,0,0,0,0,64,0,-1--1--1,,1|(247,626)| 1,123,118,56,1,0,0,0,0,64,0,-1--1--1,,1|(708,554)| 1,124,118,50,1,0,0,0,0,64,0,-1--1--1,,1|(912,496)| 1,125,88,56,1,0,0,0,0,64,0,-1--1--1,,1|(663,567)| 1,126,88,50,1,0,0,0,0,64,0,-1--1--1,,1|(912,511)| 10,127,CHANGE REQUEST TIME,128,666,58,19,8,3,0,0,0,0,0,0 1,128,127,24,1,0,0,0,0,64,0,-1--1--1,,1|(60,484)| 1,129,127,98,1,0,0,0,0,64,0,-1--1--1,,1|(526,697)| 10,130,tablelookup factor,367,219,57,11,8,3,0,0,0,0,0,0 1,131,130,39,1,0,0,0,0,64,0,-1--1--1,,1|(405,255)| 10,132,Staff in training,533,-51,49,33,3,3,0,0,0,0,0,0 1,133,135,132,4,0,0,22,0,0,0,-1--1--1,,1|(438,-40)| 1,134,135,26,100,0,0,22,0,0,0,-1--1--1,,1|(334,-40)| 11,135,332,386,-40,6,8,34,3,0,0,1,0,0,0 10,136,Assignment rate,386,-21,50,11,40,3,0,0,-1,0,0,0 1,137,139,27,4,0,0,22,0,0,0,-1--1--1,,1|(531,54)| 1,138,139,132,100,0,0,22,0,0,0,-1--1--1,,1|(531,4)| 11,139,524,531,32,8,6,33,3,0,0,4,0,0,0 10,140,training rate,576,32,37,11,40,3,0,0,-1,0,0,0 1,141,76,136,0,0,0,0,0,64,0,-1--1--1,,1|(394,-80)| 10,142,training time,744,32,38,11,8,3,0,0,0,0,0,0 1,143,142,140,1,0,0,0,0,64,0,-1--1--1,,1|(664,5)| 1,144,26,135,1,0,0,0,0,64,0,-1--1--1,,1|(314,-86)| 1,145,27,136,0,0,0,0,0,64,0,-1--1--1,,1|(450,35)| 1,146,132,140,1,0,0,0,0,64,0,-1--1--1,,1|(508,-1)| 1,147,1,136,0,0,0,0,0,64,0,-1--1--1,,1|(347,169)| 1,148,61,136,1,0,0,0,0,64,0,-1--1--1,,1|(627,-150)| 10,149,available time,253,-140,52,11,8,2,0,3,-1,0,0,0,128-128-128,0-0-0,|12||128-128-128 1,150,149,136,0,0,0,0,0,64,0,-1--1--1,,1|(313,-86)| 1,151,132,113,1,0,0,0,0,64,0,-1--1--1,,1|(590,-204)| 1,152,132,39,1,0,0,0,0,64,0,-1--1--1,,1|(399,152)| 10,153,training time look up,860,90,39,19,8,3,0,0,0,0,0,0 10,154,Time,707,-60,26,11,8,2,0,3,-1,0,0,0,128-128-128,0-0-0,|12||128-128-128 1,155,154,142,1,0,0,0,0,64,0,-1--1--1,,1|(762,-31)| 1,156,153,142,1,0,0,0,0,64,0,-1--1--1,,1|(769,78)| 10,157,normalizing factor,862,40,41,19,8,2,0,3,-1,0,0,0,128-128-128,0-0-0,|12||128-128-128 1,158,157,142,1,0,0,0,0,64,0,-1--1--1,,1|(755,28)| 10,159,work additions cmulative,1031,-30,53,19,8,2,0,3,-1,0,0,0,128-128-128,0-0-0,|12||128-128-128 10,160,INITIAL PROJECT LOAD,1055,425,65,19,8,2,0,3,-1,0,0,0,128-128-128,0-0-0,|12||128-128-128 10,161,project end,932,200,37,11,8,3,0,0,0,0,0,0 1,162,159,161,1,0,0,0,0,64,0,-1--1--1,,1|(1032,118)| 1,163,160,161,1,0,0,0,0,64,0,-1--1--1,,1|(1070,340)| 1,164,3,161,1,0,0,0,0,64,0,-1--1--1,,1|(841,249)| 1,165,161,139,1,0,0,0,0,64,0,-1--1--1,,1|(723,77)| 1,166,161,113,1,0,0,0,0,64,0,-1--1--1,,1|(888,-237)| 1,167,101,1,0,0,0,0,0,0,1,-1--1--1,,1|(214,334)| \\\---/// Sketch information - do not modify anything except names V300 Do not put anything below this section - it will be ignored *Earned Value Tracking $192-192-192,0,Times New Roman|12||0-0-0|0-0-0|0-0-255|-1--1--1|-1--1--1|96,96,75 10,1,SCHEDULED COMPLETION TIME,492,349,54,28,8,2,0,3,-1,0,0,0,128-128-128,0-0-0,|12||128-128-128 10,2,INITIAL PROJECT LOAD,492,410,65,19,8,2,0,3,-1,0,0,0,128-128-128,0-0-0,|12||128-128-128 10,3,work additions,492,296,56,11,8,2,0,3,-1,0,0,0,128-128-128,0-0-0,|12||128-128-128 10,4,Time,492,260,26,11,8,2,0,3,-1,0,0,0,128-128-128,0-0-0,|12||128-128-128 10,5,AVG WAGE FOR PROJECT STAFF,492,500,67,19,8,2,0,3,-1,0,0,0,128-128-128,0-0-0,|12||128-128-128 10,6,"Planned Value-basecase",770,365,51,19,8,3,0,0,0,0,0,0 1,7,4,6,1,0,0,0,0,64,0,-1--1--1,,1|(645,285)| 1,8,1,6,1,0,0,0,0,64,0,-1--1--1,,1|(646,335)| 1,9,2,6,1,0,0,0,0,64,0,-1--1--1,,1|(651,401)| 1,10,5,6,1,0,0,0,0,64,0,-1--1--1,,1|(657,456)| 10,11,work obsoleted,492,454,59,11,8,2,0,3,-1,0,0,0,128-128-128,0-0-0,|12||128-128-128 10,12,"Planned Value -for changes per month",242,366,60,19,8,3,0,0,0,0,0,0 1,13,4,12,1,0,0,0,0,64,0,-1--1--1,,1|(355,284)| 1,14,3,12,1,0,0,0,0,64,0,-1--1--1,,1|(354,312)| 1,15,1,12,1,0,0,0,0,64,0,-1--1--1,,1|(358,347)| 1,16,11,12,1,0,0,0,0,64,0,-1--1--1,,1|(363,426)| 1,17,5,12,1,0,0,0,0,64,0,-1--1--1,,1|(360,456)| 10,18,stored monthly charge,116,258,40,20,3,3,0,0,0,0,0,0 12,19,48,269,257,10,8,0,3,0,0,-1,0,0,0 1,20,22,18,4,0,0,22,0,0,0,-1--1--1,,1|(178,257)| 1,21,22,19,100,0,0,22,0,0,0,-1--1--1,,1|(236,257)| 11,22,48,207,257,6,8,34,3,0,0,1,0,0,0 10,23,PV for additions,207,276,52,11,40,3,0,0,-1,0,0,0 1,24,12,23,0,0,0,0,0,64,0,-1--1--1,,1|(225,323)| 10,25,nrmalizing factor,192,424,51,11,8,3,0,0,0,0,0,0 10,26,Planned Value for additions after change request,109,495,69,28,8,3,0,0,0,0,0,0 1,27,18,26,1,0,0,0,0,64,0,-1--1--1,,1|(83,371)| 1,28,4,26,1,0,0,0,0,64,0,-1--1--1,,1|(133,398)| 1,29,1,26,1,0,0,0,0,64,0,-1--1--1,,1|(266,475)| 10,30,total value for additions and changes,89,160,43,28,3,3,0,0,0,0,0,0 12,31,48,269,172,10,8,0,3,0,0,-1,0,0,0 1,32,34,30,4,0,0,22,0,0,0,-1--1--1,,1|(166,171)| 1,33,34,31,100,0,0,22,0,0,0,-1--1--1,,1|(235,171)| 11,34,48,206,171,6,8,34,3,0,0,3,0,0,0 10,35,accumulation rate,206,152,55,11,40,3,0,0,-1,0,0,0 1,36,5,34,1,0,0,0,0,64,0,-1--1--1,,1|(311,342)| 1,37,11,34,1,0,0,0,0,64,0,-1--1--1,,1|(352,267)| 1,38,3,34,1,0,0,0,0,64,0,-1--1--1,,1|(350,217)| 1,39,30,26,1,0,0,0,0,64,0,-1--1--1,,1|(43,279)| 10,40,Total Planned Value,290,582,44,19,8,3,0,0,0,0,0,0 1,41,26,40,1,0,0,0,0,64,0,-1--1--1,,1|(196,553)| 1,42,6,40,1,0,0,0,0,64,0,-1--1--1,,1|(560,556)| 10,43,Earned Value,718,578,43,11,8,3,0,0,0,0,0,0 1,44,2,43,1,0,0,0,0,64,0,-1--1--1,,1|(650,493)| 10,45,Project work completed,492,602,47,19,8,2,0,3,-1,0,0,0,128-128-128,0-0-0,|12||128-128-128 1,46,45,43,1,0,0,0,0,64,0,-1--1--1,,1|(601,585)| 10,47,Schedule Performance index,146,694,60,19,8,3,0,0,0,0,0,0 1,48,40,47,1,0,0,0,0,64,0,-1--1--1,,1|(223,633)| 1,49,43,47,1,0,0,0,0,64,0,-1--1--1,,1|(441,683)| 10,50,Cost Performance Index,844,694,58,19,8,3,0,0,0,0,0,0 10,51,Project staff wages,492,696,44,19,8,2,0,3,-1,0,0,0,128-128-128,0-0-0,|12||128-128-128 1,52,43,50,0,0,0,0,0,64,0,-1--1--1,,1|(770,627)| 1,53,51,50,1,0,0,0,0,64,0,-1--1--1,,1|(672,704)| 1,54,4,47,1,0,0,0,0,64,0,-1--1--1,,1|(226,466)| 1,55,4,50,1,0,0,0,0,64,0,-1--1--1,,1|(785,498)| 10,56,work additions cmulative,792,169,41,24,3,3,0,0,0,0,0,0 12,57,48,627,170,10,8,0,3,0,0,-1,0,0,0 1,58,60,56,4,0,0,22,0,0,0,-1--1--1,,1|(725,170)| 1,59,60,57,100,0,0,22,0,0,0,-1--1--1,,1|(662,170)| 11,60,48,694,170,6,8,34,3,0,0,1,0,0,0 10,61,additions accumulation rate,694,197,56,19,40,3,0,0,-1,0,0,0 11,62,828,694,170,6,8,2,3,0,0,3,0,0,0 1,63,62,60,4,0,0,22,0,0,0,-1--1--1,,1|(694,170)| 1,64,62,60,100,0,0,22,0,0,0,-1--1--1,,1|(694,170)| 1,65,3,62,1,0,0,0,0,64,0,-1--1--1,,1|(638,242)| 1,66,56,43,1,0,0,0,0,64,0,-1--1--1,,1|(849,311)| 1,67,40,43,1,0,0,0,0,64,0,-1--1--1,,1|(502,646)| 1,68,25,12,1,0,0,0,0,64,0,-1--1--1,,1|(228,387)| 1,69,25,26,1,0,0,0,0,64,0,-1--1--1,,1|(139,473)| 10,70,Cost Variance,656,784,46,11,8,3,0,0,0,0,0,0 10,71,Schedule Variance,363,783,59,11,8,3,0,0,0,0,0,0 1,72,4,70,1,0,0,0,0,64,0,-1--1--1,,1|(644,548)| 1,73,43,70,1,0,0,0,0,64,0,-1--1--1,,1|(719,690)| 1,74,51,70,1,0,0,0,0,64,0,-1--1--1,,1|(552,744)| 1,75,4,71,1,0,0,0,0,64,0,-1--1--1,,1|(359,559)| 1,76,40,71,1,0,0,0,0,64,0,-1--1--1,,1|(302,715)| 1,77,43,71,1,0,0,0,0,64,0,-1--1--1,,1|(588,680)| ///---\\\ :GRAPH GRAPH :TITLE GRAPH :SCALE :VAR Project work completed :VAR Rework identified :VAR Project work to be done :L<%^E!@ 9:PM_t19 15:0,0,0,0,0,0 19:75,0 27:2, 5:Project work completed 24:0 25:0 26:0