Redes perts gesto de projetos

Vista previa del material en texto

Sheet1
	Ativ.	Dep.	Duração (Meses)	Custo (R$)	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16
	A 	-	2	R$ 4,000.00	R$ 2,000.00	R$ 2,000.00
	B	A	3	R$ 23,000.00						R$ 7,666.67	R$ 7,666.67	R$ 7,666.67
	C	A	4	R$ 10,000.00					R$ 2,500.00	R$ 2,500.00	R$ 2,500.00	R$ 2,500.00
	D	A	7	R$ 7,000.00			R$ 1,000.00	R$ 1,000.00	R$ 1,000.00	R$ 1,000.00	R$ 1,000.00	R$ 1,000.00	R$ 1,000.00
	E	B, C	6	R$ 15,000.00									R$ 2,500.00	R$ 2,500.00	R$ 2,500.00	R$ 2,500.00	R$ 2,500.00	R$ 2,500.00
	F	B, C, D	3	R$ 30,000.00												R$ 10,000.00	R$ 10,000.00	R$ 10,000.00
	G	C, D	5	R$ 50,000.00										R$ 10,000.00	R$ 10,000.00	R$ 10,000.00	R$ 10,000.00	R$ 10,000.00
	H	E, F, G	2	R$ 11,000.00															R$ 5,500.00	R$ 5,500.00
				Custo/Mês	R$ 2,000.00	R$ 2,000.00	R$ 1,000.00	R$ 1,000.00	R$ 3,500.00	R$ 11,166.67	R$ 11,166.67	R$ 11,166.67	R$ 3,500.00	R$ 12,500.00	R$ 12,500.00	R$ 22,500.00	R$ 22,500.00	R$ 22,500.00	R$ 5,500.00	R$ 5,500.00
				Acumulado	R$ 18,000.00	R$ 16,000.00	R$ 15,000.00	R$ 14,000.00	R$ 40,500.00	R$ 29,333.33	R$ 18,166.67	R$ 7,000.00	R$ 3,500.00	R$ 61,000.00	R$ 48,500.00	R$ 26,000.00	R$ 3,500.00	R$ 31,000.00	R$ 25,500.00	R$ 20,000.00
				R$ 20,000.00					R$ 30,000.00					R$ 70,000.00				R$ 50,000.00
Planilha1
	Ativ.	Dep.	Duração (Meses)	Custo (R$)	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16
	A 	-	2	R$ 14,000.00	R$ 7,000.00	R$ 7,000.00
	B	A	3	R$ 13,000.00						R$ 4,333.33	R$ 4,333.33	R$ 4,333.33
	C	A	4	R$ 10,000.00					R$ 2,500.00	R$ 2,500.00	R$ 2,500.00	R$ 2,500.00
	D	A	7	R$ 7,000.00			R$ 1,000.00	R$ 1,000.00	R$ 1,000.00	R$ 1,000.00	R$ 1,000.00	R$ 1,000.00	R$ 1,000.00
	E	B, C	6	R$ 15,000.00									R$ 2,500.00	R$ 2,500.00	R$ 2,500.00	R$ 2,500.00	R$ 2,500.00	R$ 2,500.00
	F	B, C, D	3	R$ 30,000.00												R$ 10,000.00	R$ 10,000.00	R$ 10,000.00
	G	C, D	5	R$ 50,000.00										R$ 10,000.00	R$ 10,000.00	R$ 10,000.00	R$ 10,000.00	R$ 10,000.00
	H	E, F, G	2	R$ 11,000.00															R$ 5,500.00	R$ 5,500.00
				Custo/Mês	R$ 7,000.00	R$ 7,000.00	R$ 1,000.00	R$ 1,000.00	R$ 3,500.00	R$ 7,833.33	R$ 7,833.33	R$ 7,833.33	R$ 3,500.00	R$ 12,500.00	R$ 12,500.00	R$ 22,500.00	R$ 22,500.00	R$ 22,500.00	R$ 5,500.00	R$ 5,500.00
				Acumulado	R$ 53,000.00	R$ 46,000.00	R$ 45,000.00	R$ 44,000.00	R$ 40,500.00	R$ 32,666.67	R$ 24,833.33	R$ 17,000.00	R$ 13,500.00	R$ 71,000.00	R$ 58,500.00	R$ 36,000.00	R$ 13,500.00	R$ 71,000.00	R$ 65,500.00	R$ 60,000.00
				R$ 60,000.00										R$ 70,000.00				R$ 80,000.00
Inicio
0
0
0
0
A (2)
0
2
2
0
B (3)
5
8
5
2
C (4)
4
8
6
2
D (7)
2
9
9
2
E (6)
8
14
12
6
F (3)
11
14
12
9
G (5)
9
14
14
9
H (2)
14
16
16
14
Fim
16
16
16
16
0000Inicio0220A (2)5852B (3)4862C (4)2992D (7)814126E (6)1114129F (3)914149G (5)14161614H (2)16161616Fim