vn novos produtos.xls

35
Gerencial Venda Nova - Simulador Atualizado em: 13-abr 38% Actual Budget Forecast Actual Plano vs Forecast Total 2014 2015 2015 Oct-14 Nov-14 Dec-14 Jan-15 Feb-15 Mar-15 Apr-15 May-15 Jun-15 Jul-15 Aug-15 Sep-15 2015 +/- % TS TSA - R$ 437,482 838,429 ### 125,089 87,512 ### ### ### ### 31,534 - - - - - 675,650 -970,104 -59% TS TSR - R$ 55,703 71,024 102,412 7,209 8,302 10,018 12,096 19,424 19,546 2,551 - - - - - 79,146 -23,265 -23% KA KAE - R$ 147,762 827,056 777,799 22,657 23,420 12,518 15,633 26,121 19,750 - - - - - - 120,098 -657,700 -85% Re Receptivo - R$ 284,477 404,671 733,559 62,952 70,875 32,120 56,552 36,109 51,349 10,474 - - - - - 320,431 -413,128 -56% E- E-Commerce - R$ 4,948 16,151 31,693 - 2,999 1,008 - - 948 - - - - - - 4,955 -26,738 -84% Re Representantes - R$ 79,817 321,413 125,447 30,996 17,243 8,500 10,404 13,212 4,090 - - - - - - 84,444 -41,003 -33% SA Mala Boleto - R$ - - - - - - - - - - - - - - - - 0 0% Total - R$ 1,010,189 ### ### 248,903 ### ### ### ### ### 44,559 - - - - - ### ### -62% Qtd 537 1,120 1,938 161 136 124 144 137 146 31 - - - - - 879 -1,059 -55% TKM 1,881 2,213 1,763 1,546 1,547 1,383 1,458 1,447 1,379 1,437 - - - - - 1,462 - - - - - - - - Actual Budget Forecast Actual Plano vs Forecast Escritório 2014 2015 2015 Oct-14 Nov-14 Dec-14 Jan-15 Feb-15 Mar-15 Apr-15 May-15 Jun-15 Jul-15 Aug-15 Sep-15 2015 +/- % TS TSA - R$ 313,591 544,965 ### 97,077 70,028 80,818 ### 89,839 92,658 26,505 - - - - - 561,078 -708,933 -56% TS Qtd 193 272 942 75 54 69 86 72 80 22 458 -484 -51% TS TSR - R$ 19,252 32,641 62,783 5,395 5,603 4,838 2,064 7,598 13,664 2,551 - - - - - 41,713 -21,069 -34% TS Qtd 11 16 56 4 5 5 2 6 10 1 33 -23 -41% KA KAE - R$ 48,759 399,741 209,487 3,348 5,608 2,296 4,052 2,291 5,683 - - - - - - 23,278 -186,209 -89% KA Qtd 25 168 84 2 3 1 3 2 4 - 15 -69 -82% Re Receptivo - R$ 203,027 290,721 515,972 41,677 55,106 25,555 45,608 25,748 42,423 5,580 - - - - - 241,697 -274,274 -53% Re Qtd 113 144 325 32 38 21 29 23 30 4 177 -148 -46% E- E-Commerce - R$ 3,348 16,151 13,732 - - 1,008 - - 948 - - - - - - 1,956 -11,776 -86% E- Qtd 2 8 6 - - 1 - - 1 - 2 -4 -67% Re Representantes - R$ 71,429 278,641 113,053 25,668 13,800 4,876 5,580 11,196 1,090 - - - - - - 62,209 -50,843 -45% Re Qtd 39 138 57 17 10 3 4 8 1 - 43 -14 -25% SA Mala Boleto - R$ - - - - - - - - - - - - - - - - 0 0% SA Qtd - - - - - - - - - - - 0 0% Total - R$ 659,405 ### ### 173,165 ### ### ### ### ### 34,636 - - - - - 931,931 ### -57% Qtd 383 746 1,470 130 110 100 124 111 126 27 - - - - - 728 -742 -50% TKM 1,722 2,095 1,486 1,332 1,365 1,194 1,302 1,231 1,242 1,283 - - - - - 1,280 1,231 - - - - - - Actual Budget Forecast Actual Plano vs Forecast Empresa 2014 2015 2015 Oct-14 Nov-14 Dec-14 Jan-15 Feb-15 Mar-15 Apr-15 May-15 Jun-15 Jul-15 Aug-15 Sep-15 2015 +/- % TS TSA - R$ 123,890 293,463 375,744 28,012 17,484 26,451 11,075 13,496 13,025 5,030 - - - - - 114,572 -261,171 -70% TS Qtd 54 124 158 12 8 13 5 6 6 2 52 -106 -67% TS TSR - R$ 36,452 38,382 39,629 1,814 2,699 5,180 10,032 11,826 5,882 - - - - - - 37,433 -2,196 -6% TS Qtd 17 16 15 1 1 2 4 5 3 - 16 1 7% KA KAE - R$ 99,004 427,315 568,312 19,309 17,812 10,222 11,581 23,830 14,067 - - - - - - 96,821 -471,491 -83% KA Qtd 43 168 192 7 7 4 4 9 6 - 37 -155 -81% Re Receptivo - R$ 81,450 113,951 217,587 21,275 15,769 6,565 10,944 10,361 8,926 4,894 - - - - - 78,734 -138,853 -64% Re Qtd 35 48 91 9 7 3 5 5 4 2 35 -56 -62% E- E-Commerce - R$ 1,600 - 17,961 - 2,999 - - - - - - - - - - 2,999 -14,962 -83% E- Qtd 1 - 6 - 1 - - - - - 1 -5 -83% Re Representantes - R$ 8,388 42,772 12,395 5,328 3,443 3,624 4,824 2,016 3,000 - - - - - - 22,235 9,840 79% Re Qtd 4 18 6 2 2 2 2 1 1 - 10 4 67% SA Mala Boleto - R$ - - - - - - - - - - - - - - - - 0 0% SA Qtd - - - - - - - - - - - 0 0% Total - R$ 350,784 915,884 ### 75,738 60,206 52,042 48,456 61,529 44,900 9,924 - - - - - 352,794 -878,833 -71% Qtd 154 374 468 31 26 24 20 26 20 4 - - - - - 151 -317 -68% TKM 2,278 2,449 2,632 2,443 2,316 2,168 2,423 2,366 2,245 2,481 - - - - - 2,336 2,366 - - - - - - - Tabela vs TKM Escritório Limitado Mensal 84 84 84 84 84 84 84 84 84 84 84 84 Limitado Anual 1,008 1,008 1,008 1,008 1,008 1,008 1,008 1,008 1,008 1,008 1,008 1,008 Ilimitado Mensal 213 213 213 213 213 213 213 213 213 213 213 213 Ilimitado Anual 2,551 2,551 2,551 2,551 2,551 2,551 2,551 2,551 2,551 2,551 2,551 2,551 TKM Actual 1,332 1,365 1,194 1,302 1,231 1,242 1,283 - - - - - Desconto 0% 0% 0% 0% 0% 0% 0% 20% 20% 20% 20% 20% Empresa Limitado Mensal 168 168 168 168 168 168 168 168 168 168 168 168 Limitado Anual 2,016 2,016 2,016 2,016 2,016 2,016 2,016 2,016 2,016 2,016 2,016 2,016 Ilimitado Mensal 250 250 250 250 250 250 250 250 250 250 250 250 Ilimitado Anual 2,999 2,999 2,999 2,999 2,999 2,999 2,999 2,999 2,999 2,999 2,999 2,999 TKM Actual 2,443 2,316 2,168 2,423 2,366 2,245 2,481 - - - - - Desconto 0% 0% 0% 0% 0% 0% 0% 20% 20% 20% 20% 20%

Upload: felipegonzalez4940

Post on 06-Feb-2016

212 views

Category:

Documents


0 download

TRANSCRIPT

Page 1: VN Novos Produtos.xls

Gerencial Venda Nova - Simulador Atualizado em: 13-abr

38%

Actual Budget Forecast Actual Plano vs Forecast

Total 2014 2015 2015 Oct-14 Nov-14 Dec-14 Jan-15 Feb-15 Mar-15 Apr-15 May-15 Jun-15 Jul-15 Aug-15 Sep-15 2015 +/- %

TS TSA - R$ 437,482 838,429 1,645,755 125,089 87,512 107,270 115,229 103,334 105,682 31,534 - - - - - 675,650 -970,104 -59%

TS TSR - R$ 55,703 71,024 102,412 7,209 8,302 10,018 12,096 19,424 19,546 2,551 - - - - - 79,146 -23,265 -23%

KAKAE - R$ 147,762 827,056 777,799 22,657 23,420 12,518 15,633 26,121 19,750 - - - - - - 120,098 -657,700 -85%

Re Receptivo - R$ 284,477 404,671 733,559 62,952 70,875 32,120 56,552 36,109 51,349 10,474 - - - - - 320,431 -413,128 -56%

E- E-Commerce - R$ 4,948 16,151 31,693 - 2,999 1,008 - - 948 - - - - - - 4,955 -26,738 -84%

Re Representantes - R$ 79,817 321,413 125,447 30,996 17,243 8,500 10,404 13,212 4,090 - - - - - - 84,444 -41,003 -33%

SA Mala Boleto - R$ - - - - - - - - - - - - - - - - 0 0%

Total - R$ 1,010,189 2,478,744 3,416,664 248,903 210,352 171,433 209,913 198,200 201,365 44,559 - - - - - 1,284,725 -2,131,939 -62%

Qtd 537 1,120 1,938 161 136 124 144 137 146 31 - - - - - 879 -1,059 -55%

TKM 1,881 2,213 1,763 1,546 1,547 1,383 1,458 1,447 1,379 1,437 - - - - - 1,462

- - - - - - - -

Actual Budget Forecast Actual Plano vs Forecast

Escritório 2014 2015 2015 Oct-14 Nov-14 Dec-14 Jan-15 Feb-15 Mar-15 Apr-15 May-15 Jun-15 Jul-15 Aug-15 Sep-15 2015 +/- %

TS TSA - R$ 313,591 544,965 1,270,011 97,077 70,028 80,818 104,154 89,839 92,658 26,505 - - - - - 561,078 -708,933 -56%

TS Qtd 193 272 942 75 54 69 86 72 80 22 458 -484 -51%

TS TSR - R$ 19,252 32,641 62,783 5,395 5,603 4,838 2,064 7,598 13,664 2,551 - - - - - 41,713 -21,069 -34%

TS Qtd 11 16 56 4 5 5 2 6 10 1 33 -23 -41%

KAKAE - R$ 48,759 399,741 209,487 3,348 5,608 2,296 4,052 2,291 5,683 - - - - - - 23,278 -186,209 -89%

KAQtd 25 168 84 2 3 1 3 2 4 - 15 -69 -82%

Re Receptivo - R$ 203,027 290,721 515,972 41,677 55,106 25,555 45,608 25,748 42,423 5,580 - - - - - 241,697 -274,274 -53%

Re Qtd 113 144 325 32 38 21 29 23 30 4 177 -148 -46%

E- E-Commerce - R$ 3,348 16,151 13,732 - - 1,008 - - 948 - - - - - - 1,956 -11,776 -86%

E- Qtd 2 8 6 - - 1 - - 1 - 2 -4 -67%

Re Representantes - R$ 71,429 278,641 113,053 25,668 13,800 4,876 5,580 11,196 1,090 - - - - - - 62,209 -50,843 -45%

Re Qtd 39 138 57 17 10 3 4 8 1 - 43 -14 -25%

SA Mala Boleto - R$ - - - - - - - - - - - - - - - - 0 0%

SA Qtd - - - - - - - - - - - 0 0%

Total - R$ 659,405 1,562,861 2,185,037 173,165 150,146 119,391 161,458 136,671 156,466 34,636 - - - - - 931,931 -1,253,105 -57%

Qtd 383 746 1,470 130 110 100 124 111 126 27 - - - - - 728 -742 -50%

TKM 1,722 2,095 1,486 1,332 1,365 1,194 1,302 1,231 1,242 1,283 - - - - - 1,280 1,231

- - - - - -

Actual Budget Forecast Actual Plano vs Forecast

Empresa 2014 2015 2015 Oct-14 Nov-14 Dec-14 Jan-15 Feb-15 Mar-15 Apr-15 May-15 Jun-15 Jul-15 Aug-15 Sep-15 2015 +/- %

TS TSA - R$ 123,890 293,463 375,744 28,012 17,484 26,451 11,075 13,496 13,025 5,030 - - - - - 114,572 -261,171 -70%

TS Qtd 54 124 158 12 8 13 5 6 6 2 52 -106 -67%

TS TSR - R$ 36,452 38,382 39,629 1,814 2,699 5,180 10,032 11,826 5,882 - - - - - - 37,433 -2,196 -6%

TS Qtd 17 16 15 1 1 2 4 5 3 - 16 1 7%

KAKAE - R$ 99,004 427,315 568,312 19,309 17,812 10,222 11,581 23,830 14,067 - - - - - - 96,821 -471,491 -83%

KAQtd 43 168 192 7 7 4 4 9 6 - 37 -155 -81%

Re Receptivo - R$ 81,450 113,951 217,587 21,275 15,769 6,565 10,944 10,361 8,926 4,894 - - - - - 78,734 -138,853 -64%

Re Qtd 35 48 91 9 7 3 5 5 4 2 35 -56 -62%

E- E-Commerce - R$ 1,600 - 17,961 - 2,999 - - - - - - - - - - 2,999 -14,962 -83%

E- Qtd 1 - 6 - 1 - - - - - 1 -5 -83%

Re Representantes - R$ 8,388 42,772 12,395 5,328 3,443 3,624 4,824 2,016 3,000 - - - - - - 22,235 9,840 79%

Re Qtd 4 18 6 2 2 2 2 1 1 - 10 4 67%

SA Mala Boleto - R$ - - - - - - - - - - - - - - - - 0 0%

SA Qtd - - - - - - - - - - - 0 0%

Total - R$ 350,784 915,884 1,231,627 75,738 60,206 52,042 48,456 61,529 44,900 9,924 - - - - - 352,794 -878,833 -71%

Qtd 154 374 468 31 26 24 20 26 20 4 - - - - - 151 -317 -68%

TKM 2,278 2,449 2,632 2,443 2,316 2,168 2,423 2,366 2,245 2,481 - - - - - 2,336 2,366

- - - - - - -

Tabela vs TKM

Escritório Limitado Mensal 84 84 84 84 84 84 84 84 84 84 84 84

Limitado Anual 1,008 1,008 1,008 1,008 1,008 1,008 1,008 1,008 1,008 1,008 1,008 1,008

Ilimitado Mensal 213 213 213 213 213 213 213 213 213 213 213 213

Ilimitado Anual 2,551 2,551 2,551 2,551 2,551 2,551 2,551 2,551 2,551 2,551 2,551 2,551

TKM Actual 1,332 1,365 1,194 1,302 1,231 1,242 1,283 - - - - -

Desconto 0% 0% 0% 0% 0% 0% 0% 20% 20% 20% 20% 20%

Empresa Limitado Mensal 168 168 168 168 168 168 168 168 168 168 168 168

Limitado Anual 2,016 2,016 2,016 2,016 2,016 2,016 2,016 2,016 2,016 2,016 2,016 2,016

Ilimitado Mensal 250 250 250 250 250 250 250 250 250 250 250 250

Ilimitado Anual 2,999 2,999 2,999 2,999 2,999 2,999 2,999 2,999 2,999 2,999 2,999 2,999

TKM Actual 2,443 2,316 2,168 2,423 2,366 2,245 2,481 - - - - -

Desconto 0% 0% 0% 0% 0% 0% 0% 20% 20% 20% 20% 20%

Page 2: VN Novos Produtos.xls

Gerencial Venda Nova - E-Social Atualizado em:

Actual Budget Forecast

2014 2015 2015 Oct-14 Nov-14 Dec-14 Jan-15

T TSA - R$ 642,463 797,125 283,115 35,241 9,158 12,675 3,574

T TSR - R$ 33,099 81,341 38,575 3,382 - - 1,980

K KAE - R$ 31,037 73,000 3,690 1,845 1,845 - -

RReceptivo - R$ 63,104 227,335 137,770 - - - 1,660

E E-Commerce - R$ 12,884 24,783 - - - - -

RRepresentantes - R$ 88,861 181,826 123,091 3,682 - - 1,845

S Mala Boleto - R$ 33,571 65,866 20,229 - - - -

Total - R$ 905,019 1,451,275 606,469 44,150 11,003 12,675 9,059

Qtd 519 766 304 26 6 7 5

TKM 1,744 1,895 1,995 1,698 1,834 1,811 1,812

44,150 11,003 12,675 9,059

104,680 88,975 88,627 116,158

44,150 11,003 12,675 9,204

Oct-14 Nov-14 Dec-14 Jan-15 Feb-15 Mar-15 Apr-15 May-15 Jun-15 Jul-15 Aug-15 Sep-150

20,000

40,000

60,000

80,000

100,000

120,000

140,000

160,000

180,000

Real X Fcst/Plano

Actual 2015

Forecast

Budget 2015

TSA80%

TSR6%

KAE2%

Receptivo7%

Representantes5%

Share Canal

Page 3: VN Novos Produtos.xls

TSA80%

TSR6%

KAE2%

Receptivo7%

Representantes5%

Share Canal

Page 4: VN Novos Produtos.xls

Atualizado em: 13-abr

Actual Fcst Abr/15

Feb-15 Mar-15 Apr-15 May-15 Jun-15 Jul-15 Aug-15 Sep-15 2015 +/-

3,705 47,851 17,262 129,465 11,645

- 2,396 1,845 9,602 1,845

- - - 3,690 0

1,845 7,451 - 10,957 -19,007

- - - - 0

1,845 - - 7,372 -16,975

- - - - 0

7,394 57,698 19,107 - - - - - 161,086 -22,492

4 30 10 - - - - - 88 -11

1,849 1,923 1,911 - - - - - 1,831

- -

7,394 57,698 19,107 - - - - -

110,834 116,511 112,718 135,095 131,366 144,978 158,070 143,264 TSA ###

9,204 22,214 41,599 41,599 91,788 104,306 107,677 111,049 TSR ### TSA

KAE ### TSR

Receptivo### KAE

E-Commerc### Receptivo

Representan### E-Commerc

SAV ### Representan

### SAV

Oct-14 Nov-14 Dec-14 Jan-15 Feb-15 Mar-15 Apr-15 May-15 Jun-15 Jul-15 Aug-15 Sep-150

20,000

40,000

60,000

80,000

100,000

120,000

140,000

160,000

180,000

Real X Fcst/Plano

Actual 2015

Forecast

Budget 2015

TSA80%

TSR6%

KAE2%

Receptivo7%

Representantes5%

Share Canal

Page 5: VN Novos Produtos.xls

TSA80%

TSR6%

KAE2%

Receptivo7%

Representantes5%

Share Canal

Page 6: VN Novos Produtos.xls

Fcst Abr/15 Bdgt Abr/15 Fcst YTD Bdgt YTD

% +/- % +/- % +/- %

207% -48,904 -74% 42,844 49% -257,915 -67%

0% -4,289 -70% 6,220 184% -37,359 -80%

0% -6,134 -100% 0 0% -38,329 -91%

-100% -19,007 -100% -8,051 -42% -97,615 -90%

0% 0 0% 0 -100% -16,535 -100%

-100% -15,278 -100% -29,977 -80% -97,286 -93%

0% 0 0% 0 -100% -32,378 -100%

-54% -93,611 -83% 11,036 7% -577,417 -78%

-52% -49 -83% 7 9% -307 -78%

1,911 1,831

TSA TSA TSA ### TSA TSA TSA TSA

TSR TSR TSR ### TSR TSR TSR TSR

KAE KAE KAE ### KAE KAE KAE KAE

Receptivo Receptivo Receptivo### Receptivo Receptivo Receptivo Receptivo

E-Commerc E-Commerc E-Commerc### E-Commerc E-Commerc E-Commerc E-Commerce

RepresentanRepresentanRepresentan### RepresentanRepresentanRepresentanRepresentantes

SAV SAV SAV ### SAV SAV SAV SAV

Page 7: VN Novos Produtos.xls

Gerencial Venda Nova - Lucro Fiscal 2015

Actual Budget Forecast

2014 2015 2015 Oct-14 Nov-14 Dec-14 Jan-15

T TSA - R$ 525,222 473,744 396,294 - - 217,169 93,776

T TSR - R$ 111,949 - 10,550 - 869 - 1,738

K KAE - R$ 56,672 41,425 64,928 - - 4,931 24,107

RReceptivo - R$ 102,893 75,490 78,862 - 11,991 13,545 11,543

E E-Commerce - R$ 29,751 21,777 63,367 - 27,747 22,359 22,985

RRepresentantes - R$ 84,339 64,906 47,713 - 3,320 25,031 10,928

MMala Boleto - R$ 85,798 62,533 33,796 - - - -

Total - R$ 996,625 739,875 695,509 - 43,927 283,035 165,076

Qtd 1,253 877 823 - 51 338 195

TKM 795 844 845 - 861 837 847

- 43,927 283,035 165,076

- 89,420 259,744 141,126

- 43,927 283,035 199,870

Oct-14 Nov-14 Dec-14 Jan-15 Feb-15 Mar-15 Apr-15 May-15 Jun-15 Jul-15 Aug-15 Sep-150

50,000

100,000

150,000

200,000

250,000

300,000

Real X Fcst/Plano

Actual 2015

Forecast

Budget 2015

TSA62%

TSR2%

KAE5%

Receptivo8%

E-Commerce15%

Representantes7%

Share Canal

Page 8: VN Novos Produtos.xls

TSA62%

TSR2%

KAE5%

Receptivo8%

E-Commerce15%

Representantes7%

Share Canal

Page 9: VN Novos Produtos.xls

Atualizado em: 13-abr

Actual Fcst Abr/15

Feb-15 Mar-15 Apr-15 May-15 Jun-15 Jul-15 Aug-15 Sep-15 2015 +/-

83,943 45,910 6,859 447,657 -301

3,477 5,937 790 12,811 790

3,424 6,868 - 39,330 -895

9,301 9,248 - 55,629 -8,056

23,706 14,057 - 110,854 -1,790

8,316 4,102 870 52,567 870

- - - - 0

132,168 86,122 8,519 - - - - - 718,847 -9,382

159 104 11 - - - - - 858 -10

831 828 774 - - - - - 838

- - 0

132,168 86,122 8,519 - - - - -

122,877 47,447 19,161 16,424 10,706 8,760 18,736 5,475 TSA ###

83,345 35,908 17,901 16,201 8,951 6,372 - - TSR ### TSA

KAE ### TSR

Receptivo### KAE

E-Commerc### Receptivo

Representan### E-Commerc

SAV ### Representan

### SAV

Oct-14 Nov-14 Dec-14 Jan-15 Feb-15 Mar-15 Apr-15 May-15 Jun-15 Jul-15 Aug-15 Sep-150

50,000

100,000

150,000

200,000

250,000

300,000

Real X Fcst/Plano

Actual 2015

Forecast

Budget 2015

TSA62%

TSR2%

KAE5%

Receptivo8%

E-Commerce15%

Representantes7%

Share Canal

Page 10: VN Novos Produtos.xls

TSA62%

TSR2%

KAE5%

Receptivo8%

E-Commerce15%

Representantes7%

Share Canal

Page 11: VN Novos Produtos.xls

Fcst Abr/15 Bdgt Abr/15 Fcst YTD Bdgt YTD

% +/- % +/- % +/- %

-4% -4,090 -37% 66,670 17% -8,568 -2%

0% 790 0% 2,261 21% 12,811 -100%

-100% -1,642 -100% -18,422 -32% 581 1%

-100% -3,285 -100% -15,983 -22% 4,896 10%

-100% -2,190 -100% 49,277 80% 97,106 706%

0% -225 -21% 4,854 10% -5,708 -10%

0% 0 0% -33,796 -100% -62,047 -100%

-52% -10,642 -56% 54,861 8% 39,072 6%

-48% -13 -55% 71 9% 73 9%

774 838

TSA TSA TSA ### TSA TSA TSA TSA

TSR TSR TSR ### TSR TSR TSR TSR

KAE KAE KAE ### KAE KAE KAE KAE

Receptivo Receptivo Receptivo### Receptivo Receptivo Receptivo Receptivo

E-Commerc E-Commerc E-Commerc### E-Commerc E-Commerc E-Commerc E-Commerce

RepresentanRepresentanRepresentan### RepresentanRepresentanRepresentanRepresentantes

SAV SAV SAV ### SAV SAV SAV SAV

Page 12: VN Novos Produtos.xls

Gerencial Venda Nova - Cenize Atualizado em:

Forecast

2015 Oct-14 Nov-14 Dec-14 Jan-15 Feb-15 Mar-15

T TSA - R$ 483,624 - 5,712 13,574 16,992 16,729 40,735

T TSR - R$ - - - - - - -

K KAE - R$ - - - - - - -

RReceptivo - R$ - - - - - - -

E E-Commerce - R$ - - - - - - -

RRepresentantes - R$ - - - - - - -

MMala Boleto - R$ - - - - - - -

Total - R$ 483,624 - 5,712 13,574 16,992 16,729 40,735

Qtd 383 - 4 13 21 18 49

TKM 1,263 - 1,428 1,044 809 929 831

- 5,712 13,574 16,992 16,729 40,735

- 5,712 13,574 30,817 50,034 52,584

Oct-14 Nov-14 Dec-14 Jan-15 Feb-15 Mar-15 Apr-15 May-15 Jun-15 Jul-15 Aug-15 Sep-150

10,000

20,000

30,000

40,000

50,000

60,000

70,000

Real x Forecast

Actual 2015

Budget 2015

TSA100%

Share Canal

Page 13: VN Novos Produtos.xls

TSA100%

Share Canal

Page 14: VN Novos Produtos.xls

13-abr

Actual Abril

Apr-15 May-15 Jun-15 Jul-15 Aug-15 Sep-15 2015 +/- %

- 93,742 -52,584 -100%

- - 0 0%

- - 0 0%

- - 0 0%

- - 0 0%

- - 0 0%

- - 0 0%

- - - - - - 93,742 -52,584 -100%

- - - - - - 105 -41 -100%

- - - - - - 893 0

- -

- - - - - -

52,584 52,584 54,408 54,408 58,458 58,458 TSA ###

TSR ### TSA TSA ###

KAE ### TSR TSR ###

Receptivo ### KAE KAE ###

E-Commerce### Receptivo Receptivo###

Representan### E-Commerc E-Commerc###

SAV ### RepresentanRepresentan###

### SAV SAV ###

Oct-14 Nov-14 Dec-14 Jan-15 Feb-15 Mar-15 Apr-15 May-15 Jun-15 Jul-15 Aug-15 Sep-150

10,000

20,000

30,000

40,000

50,000

60,000

70,000

Real x Forecast

Actual 2015

Budget 2015

TSA100%

Share Canal

Page 15: VN Novos Produtos.xls

TSA100%

Share Canal

Page 16: VN Novos Produtos.xls

YTD

+/- %

-111,564 -54%

0 -100%

0 -100%

0 -100%

0 -100%

0 -100%

0 -100%

-111,564 -54%

-68 -39%

893

TSA TSA

TSR TSR

KAE KAE

Receptivo Receptivo

E-Commerc E-Commerce

RepresentanRepresentantes

SAV SAV

Page 17: VN Novos Produtos.xls

Gerencial Venda Nova - Auditor

Budget Forecast

2015 2015 Oct-14 Nov-14 Dec-14 Jan-15

T TSA - R$ 1,765,328 1,870,727 206,766 168,078 119,868 125,543

T TSR - R$ 123,251 22,377 12,020 - - 3,400

K KAE - R$ 924,067 870,442 54,274 121,481 50,476 71,090

RReceptivo - R$ 199,962 156,507 11,256 9,828 6,599 19,644

E E-Commerce - R$ - - - - - -

RRepresentantes - R$ 350,305 42,046 3,372 6,840 4,212 2,808

MMala Boleto - R$ - - - - - -

Total - R$ 3,362,913 2,962,099 287,688 306,227 181,155 222,485

Qtd 846 648 50 56 34 41

TKM 3,975 4,571 5,754 5,468 5,328 5,426

- - - -

287,688 306,227 181,155 222,485

279,819 259,374 280,660 296,448

287,688 306,227 181,155 261,686

Oct-14 Nov-14 Dec-14 Jan-15 Feb-15 Mar-15 Apr-15 May-15 Jun-15 Jul-15 Aug-15 Sep-150

50,000

100,000

150,000

200,000

250,000

300,000

350,000

Real X Fcst/Plano

Actual 2015

Forecast

Budget 2015

TSA62%

TSR2%

KAE27%

Receptivo5%

Representantes3%

Share Canal

Page 18: VN Novos Produtos.xls

TSA62%

TSR2%

KAE27%

Receptivo5%

Representantes3%

Share Canal

Page 19: VN Novos Produtos.xls

Atualizado em: 13-abr

Actual

Feb-15 Mar-15 Apr-15 May-15 Jun-15 Jul-15 Aug-15 Sep-15 2015

93,810 170,358 15,860 900,283

2,244 14,592 - 32,256

39,984 48,414 5,612 391,331

14,628 12,084 5,054 79,093

- - - -

12,524 16,116 3,480 49,352

- - - -

163,190 261,564 30,006 - - - - - 1,452,314

31 58 8 - - - - - 278

5,264 4,510 3,751 - - - - - 5,224

- - - - - 0

163,190 261,564 30,006 - - - - -

281,286 266,952 288,754 280,160 280,543 281,802 285,312 281,802 TSA ###

229,473 228,945 247,948 249,330 234,140 247,327 244,363 243,816 TSR ###

KAE ###

Receptivo ###

E-Commerce ###

Representantes###

SAV ###

###

Oct-14 Nov-14 Dec-14 Jan-15 Feb-15 Mar-15 Apr-15 May-15 Jun-15 Jul-15 Aug-15 Sep-150

50,000

100,000

150,000

200,000

250,000

300,000

350,000

Real X Fcst/Plano

Actual 2015

Forecast

Budget 2015

TSA62%

TSR2%

KAE27%

Receptivo5%

Representantes3%

Share Canal

AO24
Tirando o efeito das vendas Diretas e Retenção.
AP24
Tirando o efeito das vendas Diretas e Retenção.
Page 20: VN Novos Produtos.xls

TSA62%

TSR2%

KAE27%

Receptivo5%

Representantes3%

Share Canal

Page 21: VN Novos Produtos.xls

Fcst Abr/15 Bdgt Abr/15 Fcst YTD Bdgt YTD

+/- % +/- % +/- % +/- %

-134,970 -89% -134,267 -89% -196,221 -18% -106,756 -11%

-3,452 -100% -10,356 -100% 13,390 71% -38,687 -55%

-73,784 -93% -70,951 -93% -126,937 -24% -156,132 -29%

-6,147 -55% -11,747 -70% -3,846 -5% -36,004 -31%

0 0% 0 0% 0 -100% 0 -100%

411 13% -31,427 -90% 22,806 86% -163,402 -77%

0 0% 0 0% 0 -100% 0 -100%

-217,942 -88% -258,747 -90% -290,808 -17% -500,980 -26%

-52 -87% -66 -89% -89 -24% -220 -44%

3,751 5,224

TSA TSA TSA TSA ### TSA TSA TSA TSA

TSR TSR TSR TSR ### TSR TSR TSR TSR

KAE KAE KAE KAE ### KAE KAE KAE KAE

Receptivo Receptivo Receptivo Receptivo### Receptivo Receptivo Receptivo Receptivo

E-Commerc E-Commerc E-Commerc E-Commerc### E-Commerc E-Commerc E-Commerc E-Commerce

RepresentanRepresentanRepresentanRepresentan### RepresentanRepresentanRepresentanRepresentantes

SAV SAV SAV SAV ### SAV SAV SAV SAV

Page 22: VN Novos Produtos.xls

Gerencial Venda Nova - Novo OT Atualizado em:

Budget Forecast

2015 2015 Oct-14 Nov-14 Dec-14 Jan-15 Feb-15

T TSA - R$ 438,575 259,726 - - 2,156 - 11,999

T TSR - R$ 34,808 27,846 - - - 2,263 2,430

K KAE - R$ 24,098 172,549 - - 2,449 - 2,560

RReceptivo - R$ 62,654 38,045 - - - 7,029 17,495

E E-Commerce - R$ 13,923 9,394 - - - - 2,302

RRepresentantes - R$ 83,538 45,941 - - - 2,448 1,068

MMala Boleto - R$ 41,769 22,545 - - - 1 4,898

Total - R$ 699,363 576,046 - - 4,605 11,741 42,752

Qtd 425 343 - - 2 8 23

TKM 1,646 1,679 - - 2,302 1,468 1,859

- - - - -

- - 4,605 11,741 42,752

13,862 98,938 114,703 87,250 92,958

- - 4,605 49,859 105,362

Oct-14 Nov-14 Dec-14 Jan-15 Feb-15 Mar-15 Apr-15 May-15 Jun-15 Jul-15 Aug-15 Sep-150

20,000

40,000

60,000

80,000

100,000

120,000

140,000

Real X Fcst/Plano

Actual 2015

Forecast

Budget 2015

TSA26%

TSR8%

KAE16%

Receptivo33%

E-Commerce4%

Representantes9%

SAV4%

Share Canal

Page 23: VN Novos Produtos.xls

TSA26%

TSR8%

KAE16%

Receptivo33%

E-Commerce4%

Representantes9%

SAV4%

Share Canal

Page 24: VN Novos Produtos.xls

Atualizado em: 13-abr

Actual Fcst Abr/15

Mar-15 Apr-15 May-15 Jun-15 Jul-15 Aug-15 Sep-15 2015 +/- %

12,493 3,204 29,852 -21,512 -87%

4,205 - 8,898 -3,276 -100%

13,075 - 18,084 -18,900 -100%

9,519 3,024 37,067 -154 -5%

2,263 - 4,565 -785 -100%

6,967 - 10,483 -4,708 -100%

- - 4,899 -1,883 -100%

48,522 6,228 - - - - - 113,848 -51,217 -89%

25 5 - - - - - 63 -29 -85%

1,941 1,246 - - - - - 1,807

-

- -

48,522 6,228 - - - - -

73,388 39,412 56,264 45,936 29,083 31,802 15,765 TSA ###

87,849 57,445 72,525 63,282 48,202 50,634 36,284 TSR ### TSA TSA

KAE ### TSR TSR

Receptivo### KAE KAE

E-Commerc### Receptivo Receptivo

Representan### E-Commerc E-Commerc

SAV ### RepresentanRepresentan

### SAV SAV

Oct-14 Nov-14 Dec-14 Jan-15 Feb-15 Mar-15 Apr-15 May-15 Jun-15 Jul-15 Aug-15 Sep-150

20,000

40,000

60,000

80,000

100,000

120,000

140,000

Real X Fcst/Plano

Actual 2015

Forecast

Budget 2015

TSA26%

TSR8%

KAE16%

Receptivo33%

E-Commerce4%

Representantes9%

SAV4%

Share Canal

Page 25: VN Novos Produtos.xls

TSA26%

TSR8%

KAE16%

Receptivo33%

E-Commerce4%

Representantes9%

SAV4%

Share Canal

Page 26: VN Novos Produtos.xls

Bdgt Abr/15 Fcst YTD Bdgt YTD

+/- % +/- % +/- %

-21,512 -87% -117,716 -80% -296,564 -91%

-1,962 -100% -2,568 -22% -17,008 -66%

-1,358 -100% -59,965 -77% 149 1%

-507 -14% 13,442 57% -9,564 -21%

-785 -100% -1,268 -22% -5,798 -56%

-4,708 -100% -14,095 -57% -51,692 -83%

-2,354 -100% -9,101 -65% -26,188 -84%

-33,184 -84% -191,271 -63% -406,665 -78%

-19 -79% -120 -66% -253 -80%

1,246 1,807

TSA TSA ### TSA TSA TSA TSA

TSR TSR ### TSR TSR TSR TSR

KAE KAE ### KAE KAE KAE KAE

Receptivo Receptivo### Receptivo Receptivo Receptivo Receptivo

E-Commerc E-Commerc### E-Commerc E-Commerc E-Commerc E-Commerce

RepresentanRepresentan### RepresentanRepresentanRepresentanRepresentantes

SAV SAV ### SAV SAV SAV SAV

Page 27: VN Novos Produtos.xls

Gerencial Migração - Novo OT Atualizado em:

Oct-14 Nov-14 Dec-14 Jan-15 Feb-15 Mar-15 Apr-15

T TSA - R$ - - - - - - -

T TSR - R$ 17,838 15,879 18,937 32,420 59,217 25,565 10,095

K KAE - R$ - - - 982 1,826 - -

RReceptivo - R$ - - - - - - -

E E-Commerce - R$ - - - - - - -

RRepresentantes - R$ - - - - - - -

MMala Boleto - R$ - - - - - - -

Total - R$ 17,838 15,879 18,937 33,402 61,043 25,565 10,095

Qtd 9 8 9 16 31 15 5

TKM 1,982 1,985 2,104 2,088 1,969 1,704 2,019

17,838 15,879 18,937 33,402 61,043 25,565 10,095

#REF! #REF! #REF! #REF! #REF! #REF! #REF!

#REF! #REF! #REF! #REF! #REF! #REF! #REF!

Oct-14 Nov-14 Dec-14 Jan-15 Feb-15 Mar-15 Apr-15 May-15 Jun-15 Jul-15 Aug-15 Sep-150

10,000

20,000

30,000

40,000

50,000

60,000

70,000

Real X Fcst/Plano

Actual 2015

Forecast

Budget 2015

TSR98%

KAE2%

Share Canal

Page 28: VN Novos Produtos.xls

TSR98%

KAE2%

Share Canal

Page 29: VN Novos Produtos.xls

Atualizado em: 13-abr

Actual

May-15 Jun-15 Jul-15 Aug-15 Sep-15 2015

-

179,952

2,808

-

-

-

-

- - - - - 182,760 Ticket Médio

- - - - - 93 Apr-15 YTD

- - - - - 1,965 2,019 1,965

- -

- - - - -

#REF! #REF! #REF! #REF! #REF! TSA ###

#REF! #REF! #REF! #REF! #REF! TSR ### TSA TSA

KAE ### TSR TSR

Receptivo### KAE KAE

E-Commerc### Receptivo Receptivo

Representan### E-Commerce E-Commerce

SAV ### Representantes Representantes

### SAV SAV

Oct-14 Nov-14 Dec-14 Jan-15 Feb-15 Mar-15 Apr-15 May-15 Jun-15 Jul-15 Aug-15 Sep-150

10,000

20,000

30,000

40,000

50,000

60,000

70,000

Real X Fcst/Plano

Actual 2015

Forecast

Budget 2015

TSR98%

KAE2%

Share Canal

Page 30: VN Novos Produtos.xls

TSR98%

KAE2%

Share Canal

Page 31: VN Novos Produtos.xls

TSA TSA ### TSA TSA TSA TSA

TSR TSR ### TSR TSR TSR TSR

KAE KAE ### KAE KAE KAE KAE

Receptivo Receptivo### Receptivo Receptivo Receptivo Receptivo

E-Commerc E-Commerc### E-Commerc E-Commerc E-Commerc E-Commerce

RepresentanRepresentan### RepresentanRepresentanRepresentanRepresentantes

SAV SAV ### SAV SAV SAV SAV