Gabarito_A1_Mov_Arm_29_04_14

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

Plan1
	Questão 1 - R$ 15,00
	PEPS
	DATA	ENTRADA	SAÍDA	SALDO	VENDAS	* 16,000
	QNT	VL.UN	TOTAL	QNT	VL.UN	TOTAL	QNT	VL.UN	TOTAL	(-) CMV	* 9,000
	1-Jan	0.0	0.0	* 200	* 15	* 3,000	(=) RCM	* 7,000
	2-Jan	0.0	* 150	* 15	* 2,250	* 50	* 15	* 750	EST.FINAL	* 500
	5-Jan	* 250	* 20	* 5,000	* 50	* 15	* 750
	0.0	* 250	* 20	* 5,000
	9-Jan	0.0	* 50	* 15	* 750	* 100	* 20	* 2,000
	0.0	* 150	* 20	* 3,000	0.0
	15-Jan	* 150	* 10	* 1,500	0.0	* 100	* 20	* 2,000
	0.0	0.0	* 150	* 10	* 1,500
	25-Jan	0.0	* 100	* 20	* 2,000	* 50	* 10	* 500
	* 100	* 10	* 1,000
	SOMA	* 400	* 6,500	* 550	* 9,000	* 50	* 500
	UEPS
	DATA	ENTRADA	SAÍDA	SALDO	VENDAS	* 16,000
	QNT	VL.UN	TOTAL	QNT	VL.UN	TOTAL	QNT	VL.UN	TOTAL	(-) CMV	* 8,750
	1-Jan	0.0	0.0	* 200	* 15	* 3,000	(=) RCM	* 7,250
	2-Jan	0.0	* 150	* 15	* 2,250	* 50	* 15	* 750	EST.FINAL	* 750
	5-Jan	* 250	* 20	* 5,000	0.0	* 50	* 15	* 750
	0.0	0.0	* 250	* 20	* 5,000
	9-Jan	0.0	* 200	* 20	* 4,000	* 50	* 15	* 750
	0.0	0.0	* 50	* 20	* 1,000
	15-Jan	* 150	* 10	* 1,500	0.0	* 50	* 15	* 750
	* 50	* 20	* 1,000
	0.0	0.0	* 150	* 10	* 1,500
	25-Jan	0.0	* 150	* 10	* 1,500	* 50	* 15	* 750
	* 50	* 20	* 1,000
	SOMA	* 400	* 6,500	* 550	* 8,750	* 50	* 750
	Média Ponderada
	DATA	ENTRADA	SAÍDA	SALDO
	QNT	VL.UN	TOTAL	QNT	VL.UN	TOTAL	QNT	VL.UN	TOTAL	VENDAS	* 16,000
	1-Jan	0.0	0.0	* 200	* 15.00	* 3,000.00	(-) CMV	* 8,818
	2-Jan	0.0	* 150	* 15	* 2,250	50	* 15.00	* 750.00	(=) RCM	* 7,182
	5-Jan	* 250	* 20	* 5,000	0.0	* 300	* 19.17	* 5,750.00	EST.FINAL	* 684
	0.0	0.0
	9-Jan	0.0	* 200	* 19	* 3,834	* 100	* 19.17	* 1,917.00
	0.0	0.0	0.0
	15-Jan	* 150	* 10	* 1,500	0.0	* 250	* 13.67	* 3,417.00
	0.0	0.0	0.0
	25-Jan	0.0	* 200	* 14	* 2,734	* 50	* 13.67	* 683.50
	0.0
	SOMA	* 400	* 6,500	* 550	* 8,818	* 50	* 683.50
	Questão 2
	Dem 2013	* 5,000	Dem 2012	* 10,000
	Dem 2014	* 5,750	Dem 2013	* 12,000
	Arm	Transp	Arm	Transp
	CG-001	3%	2%	CG-001	3%	2%
	ABC-001	2%	2%	ABC-001	2%	2%
	XYZ-001	2%	1%	XYZ-001	2%	1%
	Qnt Perda	Arm	Transp	Qnt Perda	Arm	Transp
	CG-001	* 173	* 115	CG-001	* 360	* 240
	ABC-001	* 115	* 115	ABC-001	* 240	* 240
	XYZ-001	* 115	* 58	XYZ-001	* 240	* 120
	$ Perda	Arm	Transp	$ Perda	Arm	Transp
	CG-001	R$ 20,700.00	R$ 13,800.00	CG-001	R$ 28,800.00	R$ 19,200.00
	ABC-001	R$ 13,800.00	R$ 13,800.00	ABC-001	R$ 19,200.00	R$ 19,200.00
	XYZ-001	R$ 13,800.00	R$ 6,900.00	XYZ-001	R$ 19,200.00	R$ 9,600.00
	$ Emb.	$ Emb.
	CG-001	R$ 28,750.00	CG-001	R$ 28,750.00
	ABC-001	R$ 34,500.00	ABC-001	R$ 34,500.00
	XYZ-001	R$ 46,000.00	XYZ-001	R$ 46,000.00
	Custo Total	Custo Total
	CG-001	R$ 63,250.00	CG-001	R$ 76,750.00
	ABC-001	R$ 62,100.00	ABC-001	R$ 72,900.00
	XYZ-001	R$ 66,700.00	XYZ-001	R$ 74,800.00
	Questão 3
	(7+8+2)*4	68	(7+8+2)*4	68
	A empresa deveria investir em maquinário para fazer o transporte
	Fazer um rodizio entre os funcionários
	Contratar outro funcionário para que pudesse compartilhar a carga
	Questão 4
	Deveria marcar na figura o limiar informando o quanto deveria ser de depósito público e quanto de depósito próprio. A quantidade de depósito próprio deveria ser a base da demanda pois assim você teria certeza que utilizaria toda a capacidade disponível. Enquanto as flutuações de demanda você atenderia com os depósitos público pois te traz flexibilidade de contratação quando quiser.
	Questão 1 - R$ 120,00
	PEPS
	DATA	ENTRADA	SAÍDA	SALDO	VENDAS	* 252,500
	QNT	VL.UN	TOTAL	QNT	VL.UN	TOTAL	QNT	VL.UN	TOTAL	(-) CMV	* 14,400
	1-Jan	0.0	0.0	* 300	* 18	* 5,400	(=) RCM	* 238,100
	2-Jan	0.0	* 250	* 18	* 4,500	* 50	* 18	* 900	EST.FINAL	* 500
	5-Jan	* 350	* 20	* 7,000	* 50	* 18	* 900
	0.0	* 350	* 20	* 7,000
	9-Jan	0.0	* 50	* 18	* 900	* 100	* 20	* 2,000
	0.0	* 250	* 20	* 5,000	0.0
	15-Jan	* 250	* 10	* 2,500	0.0	* 100	* 20	* 2,000
	0.0	0.0	* 250	* 10	* 2,500
	25-Jan	0.0	* 100	* 20	* 2,000	* 50	* 10	* 500
	* 200	* 10	* 2,000
	SOMA	* 600	* 9,500	* 850	* 14,400	* 50	* 500
	UEPS
	DATA	ENTRADA	SAÍDA	SALDO	VENDAS	* 252,500
	QNT	VL.UN	TOTAL	QNT	VL.UN	TOTAL	QNT	VL.UN	TOTAL	(-) CMV	* 14,000
	1-Jan	0.0	0.0	* 300	* 18	* 5,400	(=) RCM	* 238,500
	2-Jan	0.0	* 250	* 18	* 4,500	* 50	* 18	* 900	EST.FINAL	* 900
	5-Jan	* 350	* 20	* 7,000	* 50	* 18	* 900
	0.0	* 350	* 20	* 7,000
	9-Jan	0.0	* 300	* 20	* 6,000	* 50	* 18	* 900
	0.0	0.0	* 50	* 20	* 1,000
	15-Jan	* 250	* 10	* 2,500	0.0	* 50	* 18	* 900
	0.0	0.0	* 50	* 20	* 1,000
	* 250	* 10	* 2,500
	25-Jan	0.0	* 250	* 10	* 2,500	* 50	* 18	* 900
	* 50	* 20	* 1,000
	SOMA	* 600	* 9,500	* 850	* 14,000	* 50	* 900
	Média Ponderada
	DATA	ENTRADA	SAÍDA	SALDO
	QNT	VL.UN	TOTAL	QNT	VL.UN	TOTAL	QNT	VL.UN	TOTAL	VENDAS	* 252,500
	1-Jan	0.0	0.0	* 300	* 18.00	* 5,400	(-) CMV	* 14,262
	2-Jan	0.0	* 250	* 18.00	* 4,500	50	* 18.00	* 900	(=) RCM	* 238,238
	5-Jan	* 350	* 20	* 7,000	0.0	* 400	* 19.75	* 7,900	EST.FINAL	* 640
	0.0	0.0
	9-Jan	0.0	* 300	* 19.75	* 5,925	* 100	* 19.75	* 1,975
	0.0	0.0	0.0
	15-Jan	* 250	* 10	* 2,500	0.0	* 350	* 12.79	* 4,475
	0.0	0.0	0.0
	25-Jan	0.0	* 300	* 12.79	* 3,837	* 50	* 12.79	* 640
	0.0
	SOMA	* 600	* 9,500	* 850	* 14,262	* 50	* 640
Plan2
Plan3