planilha

Prévia do material em texto

Planilha1
	Quantidade Vendida de Bolo de Paçoca
				x
	Materia Prima utilizada na fabricação
	De Setembro de 2019 á Agosto 2020 - Analise no Periodo Pandemico
		INDEPENDENTE			DEPENDENTE
	Mês	Quant. Vendida		Custo un.	Materia prima
	Sep-19	900		R$ 2.34	R$ 2,106.00
	Oct-19	921		R$ 2.34	R$ 2,155.14
	Nov-19	1002		R$ 2.34	R$ 2,344.68
	Dec-19	2306		R$ 2.34	R$ 5,396.04
	Jan-20	2298		R$ 2.34	R$ 5,377.32
	Feb-20	2197		R$ 2.34	R$ 5,140.98
	Mar-20	2190		R$ 2.34	R$ 5,124.60
	Apr-20	805		R$ 2.34	R$ 1,883.70
	May-20	602		R$ 2.89	R$ 1,739.78
	Jun-20	315		R$ 2.89	R$ 910.35
	Jul-20	206		R$ 2.89	R$ 595.34
	Aug-20	185		R$ 2.89	R$ 534.65
	Media	1161			R$ 2,775.71
Quantidade Vendida x Materia Prima
Mês	set/19	out/19	nov/19	dez/19	jan/20	fev/20	mar/20	abr/20	mai/20	jun/20	jul/20	ago/20	0	900	921	1002	2306	2298	2197	2190	805	602	315	206	185	Mês	set/19	out/19	nov/19	dez/19	jan/20	fev/20	mar/20	abr/20	mai/20	jun/20	jul/20	ago/20	Mês	set/19	out/19	nov/19	dez/19	jan/20	fev/20	mar/20	abr/20	mai/20	jun/20	jul/20	ago/20	0	2106	2155.14	2344.6799999999998	5396.04	5377.32	5140.9799999999996	5124.5999999999995	1883.6999999999998	1739.78	910.35	595.34	534.65	Mês	set/19	out/19	nov/19	dez/19	jan/20	fev/20	mar/20	abr/20	mai/20	jun/20	jul/20	ago/20	
Planilha2
		Matéria Prima- Y	Quantidade	X*Y	X²
			-X
		2,106.00	900	1,895,400.00	810,000.00
		2,155.14	921	1,984,883.94	848,241.00
		2,344.68	1,002	2,349,369.36	1,004,004.00		Memória de Cálculo (a)
		5,396.04	2,306	12,443,268.24	5,317,636.00
		5,377.32	2,298	12,357,081.36	5,280,804.00		102,307,871.94	193,961,329.00
		5,140.98	2,197	11,294,733.06	4,826,809.00		46,737,761.00	463,888,593.66
		5,124.60	2,190	11,222,874.00	4,796,100.00		2.1889767449	566,196,465.60
		1,883.70	805	1,516,378.50	648,025.00			102,307,871.94
		1,739.78	602	1,047,347.56	362,404.00		Memória de Cálculo (b)
		910.35	315	286,760.25	99,225.00
		595.34	206	122,640.04	42,436.00		30,485.88
		534.65	185	98,910.25	34,225.00		2,822.70
		33,308.58	13927	56,619,646.56	24,069,909.00		282.27
			a =	(10*56.619.646,56-13.927*33.308,58)/10*24.069.909,00-193.961.329,00)
			a =	102.307.871,94/46.737.761,00
			a =	2.19
			 b =	(33.308,58-2,19*13.927)/10
			 b =	2.822,70/10
			 b =	282.27
				Y= 2,19x + 282,27
Matéria Prima x Quantidade
Quantidade	-X	2106	2155.14	2344.6799999999998	5396.04	5377.32	5140.9799999999996	5124.6000000000004	1883.7	1739.78	910.35	595.34	534.65	900	921	1002	2306	2298	2197	2190	805	602	315	206	185