{"text_format":"2","workbook":"xls","n_sheets":3,"sheets":["Hoja1","Hoja2","Hoja3"],"not_rendered":{"charts":1,"images":0,"macros":0,"external_links":1,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Hoja1","index":0,"n_rows":32,"n_cols":7,"rows_kept":32,"cut":false,"hidden":false,"merged":[[19,0,19,6],[0,0,0,6]],"flags":["formulas_cached_only"]}
["Problema GESTION DE COSTOS DE PROYECTOS"]
[]
["Una empresa de sistemas ha contratado un proyecto que tiene la siguiente PLANIFICACIÓN de AVANCE y de COSTOS"]
["Mes",1,2,3,4,5,6]
["avance ACUM (1)",0.1,0.25,0.4,0.45,0.8,1]
["Costos Acumul Planeados (2)",20000,30000,45000,90000,200000,230000]
[]
["Hasta el mes 3 el avance real ha sido"]
["Mes",1,2,3]
["avance ACUM (3)",0.05,0.15,0.45]
["Costos Reales Acumul",17000,54000,70000]
[]
["Calcular para el mes 3 (solamente)"]
["El EV (earned value= valor del presupuesto que amerita el avance real)"]
["La CV (variación de Costo)"]
["La SV (Variación de Avance) "]
["EAC (estimación de costo final del proyecto considerando los resultados logrados hasta el mes 3)"]
[]
[]
["RESOLUCION = RESPUESTA (no imprimir para los alumnos)"]
["Mes",1,2,3,4,5,6]
["Costos Acumul Planeados= BCWS",20000,30000,45000,90000,200000,230000]
["Costos Reales Acumul=ACWP",17000,54000,70000]
["Earned Value = BCWP = { [(3) / (1) ] x (2) }",10000,18000,50625]
["CV = BCWP - ACWP",-7000,-36000,-19375,null,"el AVANCE REAL logrado tiene una desviación NEGATIVA de SobreCosto de $19.375"]
["SV = BCWP - BCWS",-10000,-12000,5625,null,"el AVANCE REAL logrado tiene una desviación POSITIVA de desarrollo del proyecto de $5.625"]
["CPI = BCWP / ACWP",0.5882352941176471,0.3333333333333333,0.7232142857142857]
["SPI = BCWP / BCWS",0.5,0.6,1.125]
["EAC = ACWP + (230000-BCWP)",237000,266000,249375]
["EAC con CPI = ACWP + (230000-BCWP)/CPI",391000,690000,318024.6913580247,null,"el costo total previsto del proyecto considerando el avance "]
["ETC = EAC - ACWP",374000,636000,248024.69135802472,0,"hasta el mes 3 será de $318.025 (=$88.025 más de lo previsto)"]
["VAC = 190000 - EAC",-161000,-460000,-88024.69135802472,230000]

{"sheet":"Hoja2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}

{"sheet":"Hoja3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}