Buscar

09 Exercício Faturamento

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

Exercício
	Exercício
	1) Preparar relatório de acompanhamento de Vendas Diárias
	2) Informações na Planilha "dados TXT"
	3) Fórmulas que permitam automatizar o relatório, de forma que o preenchimento das informações sejam automáticas a cada nova alimentação em "Dados TXT"
	 => Vendas Brutas
	 => Título
	 => Dias Faturados
	 => Média Faturamento
	 => Projeção com base na média faturada e dias úteis no mês
	4) Montar fórmula para cálculo de dias úteis no mês
	5) Ao digitar o 1º dia do mês (célula "b5"), automaticamente os demais dias são alterados / na coluna "C", informar o dia da semana (Ex.: Segunda-Feira)
	6) Na célula "g40", alertar Diretoria caso a projeção das vendas não atinga a meta 
LOJAS
	EVOLUÇÃO VENDAS DIÁRIAS - ABRIL 2014
	LOJA 01
	DATA	VENDAS BRUTAS	DEVOLUÇÃO	VENDAS TOTAIS	CUSTO PRODUTO VENDIDO	MARGEM BRUTA	MARGEM %
	TOTAL
	MÉDIA DIA
	Dias Faturados	PROJEÇÃO
	Dias Úteis	META	* 1,500,000
	1-Jan-13
	1-Feb-13
	1-Mar-13
	1-Apr-13
	1-May-13
	1-Jun-13
	1-Jul-13
	1-Aug-13
	1-Sep-13
	1-Oct-13
	1-Nov-13
	1-Dec-13
	1-Jan-14
	1-Feb-14
	1-Mar-14
	1-Apr-14
	1-May-14
	1-Jun-14
	1-Jul-14
	1-Aug-14
	1-Sep-14
	1-Oct-14
	1-Nov-14
Dados TXT
	DATA	 VENDAS 
	1-Jan-13	* 32,989
	2-Jan-13	* 47,610
	3-Jan-13	* 10,380
	4-Jan-13	* 15,172
	7-Jan-13	* 47,910
	8-Jan-13	* 34,430
	9-Jan-13	* 36,639
	10-Jan-13	* 25,140
	11-Jan-13	* 11,463
	14-Jan-13	* 37,972
	15-Jan-13	* 12,905
	16-Jan-13	* 30,234
	17-Jan-13	* 34,931
	18-Jan-13	* 45,522
	21-Jan-13	* 34,423
	22-Jan-13	* 19,640
	23-Jan-13	* 44,732
	24-Jan-13	* 39,259
	25-Jan-13	* 11,035
	28-Jan-13	* 35,574
	29-Jan-13	* 38,833
	30-Jan-13	* 42,997
	31-Jan-13	* 36,214
	1-Feb-13	* 30,101
	4-Feb-13	* 49,494
	5-Feb-13	* 37,713
	6-Feb-13	* 45,045
	7-Feb-13	* 10,188
	8-Feb-13	* 42,032
	11-Feb-13	* 37,645
	12-Feb-13	* 14,801
	13-Feb-13	* 46,877
	14-Feb-13	* 29,794
	15-Feb-13	* 33,213
	18-Feb-13	* 46,795
	19-Feb-13	* 49,683
	20-Feb-13	* 26,796
	21-Feb-13	* 12,470
	22-Feb-13	* 27,097
	25-Feb-13	* 41,436
	26-Feb-13	* 36,741
	27-Feb-13	* 22,297
	28-Feb-13	* 11,339
	1-Mar-13	* 42,257
	4-Mar-13	* 46,910
	5-Mar-13	* 21,118
	6-Mar-13	* 27,680
	7-Mar-13	* 20,071
	8-Mar-13	* 14,938
	11-Mar-13	* 26,550
	12-Mar-13	* 39,083
	13-Mar-13	* 23,877
	14-Mar-13	* 44,856
	15-Mar-13	* 20,825
	18-Mar-13	* 26,955
	19-Mar-13	* 33,004
	20-Mar-13	* 14,505
	21-Mar-13	* 43,988
	22-Mar-13	* 22,094
	25-Mar-13	* 35,179
	26-Mar-13	* 22,603
	27-Mar-13	* 11,658
	28-Mar-13	* 49,782
	29-Mar-13	* 19,993
	1-Apr-13	* 10,760
	2-Apr-13	* 18,477
	3-Apr-13	* 46,861
	4-Apr-13	* 10,889
	5-Apr-13	* 31,131
	8-Apr-13	* 44,867
	9-Apr-13	* 33,809
	10-Apr-13	* 20,595
	11-Apr-13	* 40,692
	12-Apr-13	* 30,389
	15-Apr-13	* 49,499
	16-Apr-13	* 18,020
	17-Apr-13	* 29,132
	18-Apr-13	* 28,912
	19-Apr-13	* 43,622
	22-Apr-13	* 27,146
	23-Apr-13	* 23,769
	24-Apr-13	* 29,944
	25-Apr-13	* 49,202
	26-Apr-13	* 41,870
	29-Apr-13	* 10,665
	30-Apr-13	* 26,333
	1-May-13	* 14,870
	2-May-13	* 32,140
	3-May-13	* 32,297
	6-May-13	* 26,849
	7-May-13	* 43,931
	8-May-13	* 41,069
	9-May-13	* 12,534
	10-May-13	* 30,347
	13-May-13	* 27,753
	14-May-13	* 24,859
	15-May-13	* 22,971
	16-May-13	* 46,406
	17-May-13	* 11,691
	20-May-13	* 14,011
	21-May-13	* 27,613
	22-May-13	* 14,953
	23-May-13	* 42,053
	24-May-13	* 42,290
	27-May-13	* 35,348
	28-May-13	* 14,847
	29-May-13	* 17,470
	30-May-13	* 22,231
	31-May-13	* 33,258
	3-Jun-13	* 49,587
	4-Jun-13	* 23,799
	5-Jun-13	* 16,539
	6-Jun-13	* 34,893
	7-Jun-13	* 48,560
	10-Jun-13	* 30,068
	11-Jun-13	* 41,837
	12-Jun-13	* 15,258
	13-Jun-13	* 27,351
	14-Jun-13	* 46,510
	17-Jun-13	* 27,075
	18-Jun-13	* 32,330
	19-Jun-13	* 34,698
	20-Jun-13	* 35,370
	21-Jun-13	* 24,869
	24-Jun-13	* 45,633
	25-Jun-13	* 35,007
	26-Jun-13	* 16,671
	27-Jun-13	* 24,889
	28-Jun-13	* 47,937
	1-Jul-13	* 12,600
	2-Jul-13	* 26,878
	3-Jul-13	* 41,703
	4-Jul-13	* 22,542
	5-Jul-13	* 28,433
	8-Jul-13	* 14,997
	9-Jul-13	* 21,796
	10-Jul-13	* 28,712
	11-Jul-13	* 14,905
	12-Jul-13	* 35,337
	15-Jul-13	* 43,623
	16-Jul-13	* 23,785
	17-Jul-13	* 26,672
	18-Jul-13	* 32,491
	19-Jul-13	* 30,072
	22-Jul-13	* 28,376
	23-Jul-13	* 39,730
	24-Jul-13	* 21,961
	25-Jul-13	* 48,132
	26-Jul-13	* 17,797
	29-Jul-13	* 34,412
	30-Jul-13	* 36,265
	31-Jul-13	* 49,776
	1-Aug-13	* 11,271
	2-Aug-13	* 17,983
	5-Aug-13	* 13,454
	6-Aug-13	* 13,202
	7-Aug-13	* 32,675
	8-Aug-13	* 47,721
	9-Aug-13	* 41,021
	12-Aug-13	* 16,320
	13-Aug-13	* 33,646
	14-Aug-13	* 15,103
	15-Aug-13	* 11,010
	16-Aug-13	* 12,318
	19-Aug-13	* 18,094
	20-Aug-13	* 10,674
	21-Aug-13	* 32,422
	22-Aug-13	* 30,556
	23-Aug-13	* 45,391
	26-Aug-13	* 38,005
	27-Aug-13	* 49,509
	28-Aug-13	* 17,495
	29-Aug-13	* 11,644
	30-Aug-13	* 48,939
	2-Sep-13	* 43,808
	3-Sep-13	* 42,122
	4-Sep-13	* 10,472
	5-Sep-13	* 31,056
	6-Sep-13	* 36,891
	9-Sep-13	* 29,706
	10-Sep-13	* 43,518
	11-Sep-13	* 16,979
	12-Sep-13	* 24,286
	13-Sep-13	* 26,934
	16-Sep-13	* 49,066
	17-Sep-13	* 42,656
	18-Sep-13	* 18,315
	19-Sep-13	* 22,339
	20-Sep-13	* 38,642
	23-Sep-13	* 41,288
	24-Sep-13	* 25,222
	25-Sep-13	* 16,179
	26-Sep-13	* 46,382
	27-Sep-13	* 33,991
	30-Sep-13	* 24,173
	1-Oct-13	* 35,264
	2-Oct-13	* 41,707
	3-Oct-13	* 49,977
	4-Oct-13	* 26,545
	7-Oct-13	* 26,087
	8-Oct-13	* 13,853
	9-Oct-13	* 29,311
	10-Oct-13	* 10,296
	11-Oct-13	* 35,374
	14-Oct-13	* 47,114
	15-Oct-13	* 19,452
	16-Oct-13	* 22,444
	17-Oct-13	* 48,204
	18-Oct-13	* 45,760
	21-Oct-13	* 25,126
	22-Oct-13	* 46,909
	23-Oct-13	* 18,033
	24-Oct-13	* 38,630
	25-Oct-13	* 23,611
	28-Oct-13	* 36,005
	29-Oct-13	* 16,865
	30-Oct-13	* 15,948
	31-Oct-13	* 39,451
	1-Nov-13	* 32,288
	4-Nov-13	* 12,644
	5-Nov-13	* 40,392
	6-Nov-13	* 39,715
	7-Nov-13	* 24,263
	8-Nov-13	* 28,089
	11-Nov-13	* 19,607
	12-Nov-13	* 40,313
	13-Nov-13	* 25,482
	14-Nov-13	* 45,638
	15-Nov-13	* 26,001
	18-Nov-13	* 32,992
	19-Nov-13	* 24,112
	20-Nov-13	* 16,543
	21-Nov-13	* 40,116
	22-Nov-13	* 29,965
	25-Nov-13	* 30,918
	26-Nov-13	* 18,455
	27-Nov-13	* 24,572
	28-Nov-13	* 49,845
	29-Nov-13	* 46,909
	2-Dec-13	* 20,655
	3-Dec-13	* 23,972
	4-Dec-13	* 23,934
	5-Dec-13	* 39,173
	6-Dec-13	* 15,020
	9-Dec-13	* 41,170
	10-Dec-13	* 32,356
	11-Dec-13	* 23,128
	12-Dec-13	* 25,318
	13-Dec-13	* 22,613
	16-Dec-13	* 40,408
	17-Dec-13	* 26,377
	18-Dec-13	* 34,829
	19-Dec-13	* 12,751
	20-Dec-13	* 15,005
	23-Dec-13	* 15,179
	24-Dec-13	* 20,464
	25-Dec-13	* 33,343
	26-Dec-13	* 39,710
	27-Dec-13	* 12,749
	30-Dec-13	* 47,099
	31-Dec-13	* 48,877
	1-Jan-14	* 28,226
	2-Jan-14	* 44,156
	3-Jan-14	* 40,645
	6-Jan-14	* 22,182
	7-Jan-14	* 17,821
	8-Jan-14	* 49,709
	9-Jan-14	* 29,605
	10-Jan-14	* 22,169
	13-Jan-14	* 21,742
	14-Jan-14	* 25,615
	15-Jan-14	* 18,780
	16-Jan-14	* 13,548
	17-Jan-14	* 13,706
	20-Jan-14	* 12,299
	21-Jan-14	* 27,012
	22-Jan-14	* 48,263
	23-Jan-14	* 19,698
	24-Jan-14	* 27,673
	27-Jan-14	* 38,801
	28-Jan-14	* 35,080
	29-Jan-14	* 43,044
	30-Jan-14	* 31,038
	31-Jan-14	* 44,764
	3-Feb-14	* 42,731
	4-Feb-14	* 27,546
	5-Feb-14	* 40,337
	6-Feb-14	* 27,769
	7-Feb-14	* 17,778
	10-Feb-14	* 23,992
	11-Feb-14	* 35,219
	12-Feb-14	* 41,354
	13-Feb-14	* 28,586
	14-Feb-14	* 48,869
	17-Feb-14	* 27,183
	18-Feb-14	* 31,931
	19-Feb-14	* 37,488
	20-Feb-14	* 36,543
	21-Feb-14	* 34,201
	24-Feb-14	* 15,092
	25-Feb-14	* 43,079
	26-Feb-14	* 30,903
	27-Feb-14	* 20,943
	28-Feb-14	* 37,090
	3-Mar-14	* 27,162
	4-Mar-14	* 33,841
	5-Mar-14	* 46,964
	6-Mar-14	* 37,412
	7-Mar-14	* 10,558
	10-Mar-14	* 46,362
	11-Mar-14	* 33,983
	12-Mar-14	* 42,314
	13-Mar-14	* 29,297
	14-Mar-14	* 49,047
	17-Mar-14	* 12,203
	18-Mar-14	* 38,385
	19-Mar-14	* 12,867
	20-Mar-14	* 18,603
	21-Mar-14	* 37,288
	24-Mar-14	* 21,937
	25-Mar-14	* 24,728
	26-Mar-14	* 30,998
	27-Mar-14	* 31,921
	28-Mar-14	* 15,771
	31-Mar-14	* 40,018
	1-Apr-14	* 34,009
2-Apr-14	* 27,166
	3-Apr-14	* 15,512
	4-Apr-14	* 26,578
	7-Apr-14	* 20,785
	8-Apr-14	* 41,423
	9-Apr-14	* 49,508
	10-Apr-14	* 16,635
	11-Apr-14	* 30,911
	14-Apr-14	* 39,475
	15-Apr-14	* 11,437
	16-Apr-14	* 42,481
	17-Apr-14	* 34,059
	18-Apr-14	* 35,823
	21-Apr-14	* 49,366
	22-Apr-14	* 49,695
	23-Apr-14	* 13,532
	24-Apr-14	* 44,233
	25-Apr-14	* 22,278
	28-Apr-14	* 41,843
	29-Apr-14	* 10,852
	30-Apr-14	* 36,982
	1-May-14	* 31,455
	2-May-14	* 48,097
	5-May-14	* 26,737
	6-May-14	* 36,721
	7-May-14	* 31,823
	8-May-14	* 24,902
	9-May-14	* 49,791
	12-May-14	* 48,404
	13-May-14	* 41,768
	14-May-14	* 39,468
	15-May-14	* 17,299
	16-May-14	* 10,072
	19-May-14	* 37,708
	20-May-14	* 44,313
	21-May-14	* 16,718
	22-May-14	* 43,661
	23-May-14	* 12,771
	26-May-14	* 47,804

Teste o Premium para desbloquear

Aproveite todos os benefícios por 3 dias sem pagar! 😉
Já tem cadastro?