Recuperação Paralela 1 - Cadeia de Suprimentos certa (version 1).xlsb

Esta é uma pré-visualização de arquivo. Entre para ver o arquivo original

Planilha1
	GOD. Materia prima	Demanda Mensal	Custo Unitario	Coluna4	Valor total	GOD. Materia prima	Demanda mensal	Custo unitario	Coluna1	Fator de segurança 2	menos 25%	GOD. Materia prima	Demanda mensal	Custo unitario	Coluna1	Fator de segurança 2	Valor total fator segurança	MENOS 25%	VALOR TOTAL MENOS 25%
	dos mais caros	Mediano
	M1	1500	R$1.20	R$1,800.00	M1	1500	R$1.20	R$1,800.00	3000	2250	M1	1500	R$1.20	R$1,800.00	3000	R$3,600.00	2250	R$2,700.00
	M2	2500	R$1.35	R$3,375.00	M2	2500	R$1.35	R$3,375.00	5000	3750	M2	2500	R$1.35	R$3,375.00	5000	R$6,750.00	3750	R$5,062.50
	M3	9000	R$4.30	R$38,700.00	M3	9000	R$4.30	R$38,700.00	18000	13500	M3	9000	R$4.30	R$38,700.00	18000	R$77,400.00	13500	R$58,050.00
	M4	4500	R$1.35	R$6,075.00	M4	4500	R$1.35	R$6,075.00	9000	6750	M4	4500	R$1.35	R$6,075.00	9000	R$12,150.00	6750	R$9,112.50
	M5	1000	R$0.95	R$950.00	M5	1000	R$0.95	R$950.00	2000	1500	M5	1000	R$0.95	R$950.00	2000	R$1,900.00	1500	R$1,425.00
	M6	2000	R$1.45	R$2,900.00	M6	2000	R$1.45	R$2,900.00	4000	3000	M6	2000	R$1.45	R$2,900.00	4000	R$5,800.00	3000	R$4,350.00
	M7	8000	R$3.20	R$25,600.00	M7	8000	R$3.20	R$25,600.00	16000	12000	M7	8000	R$3.20	R$25,600.00	16000	R$51,200.00	12000	R$38,400.00
	M8	9000	R$2.20	R$19,800.00	M8	9000	R$2.20	R$19,800.00	18000	13500	M8	9000	R$2.20	R$19,800.00	18000	R$39,600.00	13500	R$29,700.00
	M9	6000	R$2.25	R$13,500.00	M9	6000	R$2.25	R$13,500.00	12000	9000	M9	6000	R$2.25	R$13,500.00	12000	R$27,000.00	9000	R$20,250.00
	M10	5500	R$1.30	R$7,150.00	M10	5500	R$1.30	R$7,150.00	11000	8250	M10	5500	R$1.30	R$7,150.00	11000	R$14,300.00	8250	R$10,725.00
	TOTAL	R$119,850.00	TOTAL	R$119,850.00	TOTAL	R$119,850.00	R$239,700.00	R$179,775.00