YTD & FYFCST Budget Control Current Year 2021

M11 Last Year 2020

Settings Accounting

Distribution Analytic Accounts

Budget Forecasts

Full-Year Forecast Budget

YOY & YTD Budget Control Print all Reports
Control
 Months selection and Reports Home

Q1 Q2 Q3 Q4
Year Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Available? YES YES YES YES YES YES YES YES YES YES YES YES
2020
Month Select Ok Ok Ok Ok Ok Ok

Available? YES YES YES YES YES YES NO NO NO NO NO NO

2021
Month Select Ok Ok Ok Ok Ok Ok

Code Analysis Chart Chart 1 Chart 2

Actual YTD Bgt Control
CEA YOY Reporting View YTD Budget Control View View by Department

Monthly Control
Results Accruals Control
 Last Year YTD Current Year YTD
2020 2021 Deviations
% Over Month % Over Month
Analytic P&L YOY Jan-20 Feb-20 Mar-20 Apr-20 May-20 Jun-20 Total
Revenue Average
Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21 Total
Revenue Average
Total %

Sales 1.006.525 1.052.715 1.103.266 1.011.337 1.403.210 1.315.887 6.892.940 100,0% 1.148.823 1.780.926 1.417.478 1.268.033 1.179.164 1.209.818 1.137.140 7.992.559 100,0% 1.332.093 1.099.619 16,0%
Total Revenue 1.006.525 1.052.715 1.103.266 1.011.337 1.403.210 1.315.887 6.892.940 100,0% 1.148.823 1.780.926 1.417.478 1.268.033 1.179.164 1.209.818 1.137.140 7.992.559 100,0% 1.332.093 1.099.619 16,0%

Cost of Goods Sold -825.417 -770.264 -753.514 -529.326 -615.932 -827.621 -4.322.074 -62,7% -720.346 -829.038 -848.682 -529.378 -573.990 -783.590 -560.475 -4.125.153 -51,6% -687.526 196.921 -4,6%
Total Direct Costs -825.417 -770.264 -753.514 -529.326 -615.932 -827.621 -4.322.074 -62,7% -720.346 -829.038 -848.682 -529.378 -573.990 -783.590 -560.475 -4.125.153 -51,6% -687.526 196.921 -4,6%
Gross Margin 181.108 282.451 349.752 482.011 787.278 488.266 2.570.866 37,3% 428.478 951.888 568.796 738.655 605.174 426.228 576.665 3.867.406 48,4% 644.568 1.296.540 50,4%

Employees -463.298 -429.619 -411.899 -452.009 -418.386 -492.128 -2.667.339 -38,7% -444.557 -479.277 -411.291 -415.975 -450.802 -428.910 -489.665 -2.675.920 -33,5% -445.987 -8.581 0,3%
Management Expenses -13.697 -17.367 -17.627 -14.365 -12.785 -13.249 -89.090 -1,3% -14.848 -14.926 -10.726 -10.102 -15.356 -12.150 -19.478 -82.738 -1,0% -13.790 6.352 -7,1%
General Expenses -43.885 -43.974 -37.528 -46.170 -43.282 -47.968 -262.807 -3,8% -43.801 -40.703 -45.044 -41.664 -42.996 -41.839 -45.310 -257.556 -3,2% -42.926 5.251 -2,0%
Marketing Expenses -10.585 -19.457 -13.187 -16.443 -16.332 -15.008 -91.012 -1,3% -15.169 -11.723 -17.020 -19.734 -11.124 -16.768 -18.176 -94.545 -1,2% -15.758 -3.533 3,9%
Total Overhead Costs -531.465 -510.417 -480.241 -528.987 -490.785 -568.353 -3.110.248 -45,1% -518.375 -546.629 -484.081 -487.475 -520.278 -499.667 -572.629 -3.110.759 -38,9% -518.460 -511 0,0%
EBITDA -350.357 -227.966 -130.489 -46.976 296.493 -80.087 -539.382 -7,8% -89.897 405.259 84.715 251.180 84.896 -73.439 4.036 756.647 9,5% 126.108 1.296.029 -240,3%

Total Depreciations

Financial Expenses -6.799 -12.534 -7.278 -9.005 -5.908 -9.101 -50.625 -0,7% -8.438 -8.494 -7.975 -7.071 -6.567 -7.976 -12.910 -50.993 -0,6% -8.499 -368 0,7%
Financial Income 5.201 5.278 4.610 4.085 4.643 5.420 29.237 0,4% 4.873 3.196 5.293 4.395 3.311 3.186 5.572 24.953 0,3% 4.159 -4.284 -14,7%
Total Financial Result -1.598 -7.256 -2.668 -4.920 -1.265 -3.681 -21.388 -0,3% -3.565 -5.298 -2.682 -2.676 -3.256 -4.790 -7.338 -26.040 -0,3% -4.340 -4.652 21,8%

Other Income 12.984 11.727 10.220 11.050 15.853 10.184 72.018 1,0% 12.003 16.913 17.598 11.074 12.896 16.670 11.269 86.420 1,1% 14.403 14.402 20,0%
Total Extraordinary Results 12.984 11.727 10.220 11.050 15.853 10.184 72.018 1,0% 12.003 16.913 17.598 11.074 12.896 16.670 11.269 86.420 1,1% 14.403 14.402 20,0%

EBT -338.971 -223.495 -122.937 -40.846 311.081 -73.584 -488.752 -7,1% -81.459 416.874 99.631 259.578 94.536 -61.559 7.967 817.027 10,2% 136.171 1.305.779 267,2%
Corporate Profit Taxes
Net Income After Taxes -338.971 -223.495 -122.937 -40.846 311.081 -73.584 -488.752 -7,1% -81.459 416.874 99.631 259.578 94.536 -61.559 7.967 817.027 10,2% 136.171 1.305.779 267,2%
 Analytic P&L YOY Reporting

2020
1.600.000
2021
2.000.000
1.400.000
1.800.000
1.200.000 1.600.000
1.000.000 Revenue 1.400.000
Revenue
1.200.000
800.000 Direct Costs
1.000.000 Direct Costs
600.000 Overhead Costs 800.000 Overhead Costs
Operation Costs 600.000
400.000 Operation Costs
400.000
200.000
200.000
0 0
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec

2020 2021
1.600.000 2.000.000
1.400.000 1.800.000
1.600.000
1.200.000
1.400.000
1.000.000
Overhead Costs 1.200.000 Overhead Costs
800.000 1.000.000
Direct Costs Direct Costs
600.000 800.000
Revenue Revenue
600.000
400.000
400.000
200.000
200.000
0 0
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
 Budget YTD Actual YTD
2021 2021 Deviations
% Over Month % Over Month
YTD Budget Control Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21 Total
Revenue Average
Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21 Total
Revenue Average
Total %

Sales 1.056.851 1.105.351 1.158.429 1.061.904 1.473.371 1.381.681 7.237.587 100,0% 1.206.265 1.780.926 1.417.478 1.268.033 1.179.164 1.209.818 1.137.140 7.992.559 100,0% 1.332.093 754.972 10,4%
Total Revenue 1.056.851 1.105.351 1.158.429 1.061.904 1.473.371 1.381.681 7.237.587 100,0% 1.206.265 1.780.926 1.417.478 1.268.033 1.179.164 1.209.818 1.137.140 7.992.559 100,0% 1.332.093 754.972 10,4%

Cost of Goods Sold -784.146 -731.751 -715.838 -502.860 -585.135 -786.240 -4.105.970 -56,7% -684.328 -829.038 -848.682 -529.378 -573.990 -783.590 -560.475 -4.125.153 -51,6% -687.526 -19.183 0,5%
Total Direct Costs -784.146 -731.751 -715.838 -502.860 -585.135 -786.240 -4.105.970 -56,7% -684.328 -829.038 -848.682 -529.378 -573.990 -783.590 -560.475 -4.125.153 -51,6% -687.526 -19.183 0,5%
Gross Margin 272.705 373.600 442.591 559.044 888.235 595.441 3.131.617 43,3% 521.936 951.888 568.796 738.655 605.174 426.228 576.665 3.867.406 48,4% 644.568 735.789 23,5%

Employees -440.133 -408.138 -391.304 -429.409 -397.467 -467.522 -2.533.972 -35,0% -422.329 -479.277 -411.291 -415.975 -450.802 -428.910 -489.665 -2.675.920 -33,5% -445.987 -141.948 5,6%
Management Expenses -13.012 -16.499 -16.746 -13.647 -12.146 -12.587 -84.636 -1,2% -14.106 -14.926 -10.726 -10.102 -15.356 -12.150 -19.478 -82.738 -1,0% -13.790 1.898 -2,2%
General Expenses -41.691 -41.775 -35.652 -43.862 -41.118 -45.570 -249.667 -3,4% -41.611 -40.703 -45.044 -41.664 -42.996 -41.839 -45.310 -257.556 -3,2% -42.926 -7.889 3,2%
Marketing Expenses -10.056 -18.484 -12.528 -15.621 -15.515 -14.258 -86.461 -1,2% -14.410 -11.723 -17.020 -19.734 -11.124 -16.768 -18.176 -94.545 -1,2% -15.758 -8.084 9,3%
Total Overhead Costs -504.892 -484.896 -456.229 -502.538 -466.246 -539.935 -2.954.736 -40,8% -492.456 -546.629 -484.081 -487.475 -520.278 -499.667 -572.629 -3.110.759 -38,9% -518.460 -156.023 5,3%
EBITDA -232.187 -111.296 -13.638 56.507 421.989 55.506 176.881 2,4% 29.480 405.259 84.715 251.180 84.896 -73.439 4.036 756.647 9,5% 126.108 579.766 327,8%

Total Depreciations

Financial Expenses -6.459 -11.907 -6.914 -8.555 -5.613 -8.646 -48.094 -0,7% -8.016 -8.494 -7.975 -7.071 -6.567 -7.976 -12.910 -50.993 -0,6% -8.499 -2.899 6,0%
Financial Income 5.461 5.542 4.841 4.289 4.875 5.691 30.699 0,4% 5.116 3.196 5.293 4.395 3.311 3.186 5.572 24.953 0,3% 4.159 -5.746 -18,7%
Total Financial Result -998 -6.365 -2.074 -4.266 -737 -2.955 -17.395 -0,2% -2.899 -5.298 -2.682 -2.676 -3.256 -4.790 -7.338 -26.040 -0,3% -4.340 -8.645 49,7%

Other Income 13.633 12.313 10.731 11.603 16.646 10.693 75.619 1,0% 12.603 16.913 17.598 11.074 12.896 16.670 11.269 86.420 1,1% 14.403 10.801 14,3%
Total Extraordinary Results 13.633 12.313 10.731 11.603 16.646 10.693 75.619 1,0% 12.603 16.913 17.598 11.074 12.896 16.670 11.269 86.420 1,1% 14.403 10.801 14,3%

EBT -219.551 -105.348 -4.981 63.844 437.898 63.244 235.105 3,2% 39.184 416.874 99.631 259.578 94.536 -61.559 7.967 817.027 10,2% 136.171 581.922 247,5%
Corporate Profit Taxes
Net Income After Taxes -219.551 -105.348 -4.981 63.844 437.898 63.244 235.105 3,2% 39.184 416.874 99.631 259.578 94.536 -61.559 7.967 817.027 10,2% 136.171 581.922 247,5%
 YTD Budget Control Reporting

Budget Actual

2021 Budget 2021 Actual

1.600.000
2.000.000
1.400.000 1.800.000
1.200.000 1.600.000
1.400.000
1.000.000 Revenue Revenue
1.200.000
800.000 Direct Costs 1.000.000 Direct Costs
Overhead Costs 800.000 Overhead Costs
600.000
Operation Costs 600.000 Operation Costs
400.000 400.000
200.000 200.000
0
0
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec

2021 Budget 2021 Actual

1.600.000 2.000.000

1.800.000
1.400.000
1.600.000
1.200.000
1.400.000
1.000.000 1.200.000
Overhead Costs Overhead Costs
800.000 1.000.000
Direct Costs Direct Costs
Revenue 800.000 Revenue
600.000
600.000
400.000
400.000
200.000 200.000

0 0
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
 YTD Budget Control Reporting

Revenue Analysis Direct Costs Analysis

2021 YTD 2021 YTD

2.000.000 900.000
1.800.000 800.000
1.600.000 700.000
1.400.000
600.000
1.200.000
500.000
1.000.000 Budget Revenue Budget Direct Costs
400.000
800.000 Actual Revenue Actual Direct Costs
600.000 300.000

400.000 200.000
200.000 100.000
0 0
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec

Overhead Costs Analysis

2021 YTD
700.000

600.000

500.000

400.000
Budget Overhead Costs
300.000 Actual Overhead Costs
200.000

100.000

0
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
 FyFcst Months selection and Reports Home

Q1 Q2 Q3 Q4
Actuals Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Analysis (Actuals
+ Projections) FY
Forecast FY should always be
6+6 12
(Projections) 12
Month Control Ok Ok Ok Ok Ok Ok Ok Ok Ok Ok Ok Ok

Code Chart 1 Chart 2

FyFcst Budget Control FY Fcst Budget Control Action Plan Actual
CEA View View
by Departments FYFcst

Action Plan Settings

Departments View
Responsibles View
Relevance View
State View
Type View
 Budget FY FY Fcst
6+6 2021 2021 Deviations
% Over Month % Over Month
FyFcst Budget Control Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21 Jul-21 Aug-21 Sep-21 Oct-21 Nov-21 Dec-21 Total
Revenue Average
Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21 Jul-21 Aug-21 Sep-21 Oct-21 Nov-21 Dec-21 Total
Revenue Average
Total %

Sales 1.056.851 1.105.351 1.158.429 1.061.904 1.473.371 1.381.681 1.879.613 1.246.685 2.077.610 1.779.448 2.084.160 1.140.693 17.445.795 100,0% 1.453.816 1.780.926 1.417.478 1.268.033 1.179.164 1.209.818 1.137.140 1.843.811 1.222.939 2.038.036 1.745.553 2.044.461 1.118.965 18.006.325 100,0% 1.500.527 560.530 3,2%
Total Revenue 1.056.851 1.105.351 1.158.429 1.061.904 1.473.371 1.381.681 1.879.613 1.246.685 2.077.610 1.779.448 2.084.160 1.140.693 17.445.795 100,0% 1.453.816 1.780.926 1.417.478 1.268.033 1.179.164 1.209.818 1.137.140 1.843.811 1.222.939 2.038.036 1.745.553 2.044.461 1.118.965 18.006.325 100,0% 1.500.527 560.530 3,2%

Cost of Goods Sold -784.146 -731.751 -715.838 -502.860 -585.135 -786.240 -678.964 -552.888 -678.125 -829.522 -576.442 -728.384 -8.150.295 -46,7% -679.191 -829.038 -848.682 -529.378 -573.990 -783.590 -560.475 -693.258 -564.527 -692.402 -846.986 -588.578 -743.718 -8.254.621 -45,8% -687.885 -104.326 1,3%
Total Direct Costs -784.146 -731.751 -715.838 -502.860 -585.135 -786.240 -678.964 -552.888 -678.125 -829.522 -576.442 -728.384 -8.150.295 -46,7% -679.191 -829.038 -848.682 -529.378 -573.990 -783.590 -560.475 -693.258 -564.527 -692.402 -846.986 -588.578 -743.718 -8.254.621 -45,8% -687.885 -104.326 1,3%
Gross Margin 272.705 373.600 442.591 559.044 888.235 595.441 1.200.649 693.797 1.399.485 949.926 1.507.718 412.309 9.295.500 53,3% 774.625 951.888 568.796 738.655 605.174 426.228 576.665 1.150.553 658.411 1.345.635 898.568 1.455.884 375.247 9.751.704 54,2% 812.642 456.204 4,9%

Employees -440.133 -408.138 -391.304 -429.409 -397.467 -467.522 -400.644 -399.888 -416.286 -400.059 -429.977 -467.840 -5.048.667 -28,9% -420.722 -479.277 -411.291 -415.975 -450.802 -428.910 -489.665 -409.079 -408.307 -425.050 -408.482 -439.029 -477.689 -5.243.556 -29,1% -436.963 -194.889 3,9%
Management Expenses -13.012 -16.499 -16.746 -13.647 -12.146 -12.587 -17.247 -15.270 -15.190 -12.208 -17.737 -14.336 -176.624 -1,0% -14.719 -14.926 -10.726 -10.102 -15.356 -12.150 -19.478 -17.610 -15.592 -15.509 -12.465 -18.111 -14.638 -176.663 -1,0% -14.722 -39 0,0%
General Expenses -41.691 -41.775 -35.652 -43.862 -41.118 -45.570 -51.133 -51.594 -45.645 -40.788 -38.454 -37.895 -515.175 -3,0% -42.931 -40.703 -45.044 -41.664 -42.996 -41.839 -45.310 -52.209 -52.680 -46.606 -41.647 -39.264 -38.692 -528.654 -2,9% -44.054 -13.479 2,6%
Marketing Expenses -10.056 -18.484 -12.528 -15.621 -15.515 -14.258 -18.232 -10.768 -12.954 -18.430 -13.307 -18.844 -178.997 -1,0% -14.916 -11.723 -17.020 -19.734 -11.124 -16.768 -18.176 -18.616 -10.995 -13.227 -18.818 -13.587 -19.241 -189.029 -1,0% -15.752 -10.032 5,6%
Total Overhead Costs -504.892 -484.896 -456.229 -502.538 -466.246 -539.935 -487.257 -477.520 -490.075 -471.485 -499.475 -538.915 -5.919.462 -33,9% -493.289 -546.629 -484.081 -487.475 -520.278 -499.667 -572.629 -497.515 -487.573 -500.392 -481.411 -509.990 -550.261 -6.137.901 -34,1% -511.492 -218.439 3,7%
EBITDA -232.187 -111.296 -13.638 56.507 421.989 55.506 713.392 216.277 909.410 478.441 1.008.243 -126.606 3.376.038 19,4% 281.336 405.259 84.715 251.180 84.896 -73.439 4.036 653.038 170.838 845.243 417.157 945.894 -175.014 3.613.803 20,1% 301.150 237.765 7,0%

Total Depreciations

Financial Expenses -6.459 -11.907 -6.914 -8.555 -5.613 -8.646 -8.392 -8.265 -9.052 -12.907 -8.881 -9.432 -105.022 -0,6% -8.752 -8.494 -7.975 -7.071 -6.567 -7.976 -12.910 -8.569 -8.439 -9.242 -13.178 -9.068 -9.630 -109.119 -0,6% -9.093 -4.098 3,9%
Financial Income 5.461 5.542 4.841 4.289 4.875 5.691 4.412 6.225 5.101 6.250 4.123 4.418 61.229 0,4% 5.102 3.196 5.293 4.395 3.311 3.186 5.572 4.328 6.107 5.004 6.131 4.045 4.334 54.901 0,3% 4.575 -6.327 -10,3%
Total Financial Result -998 -6.365 -2.074 -4.266 -737 -2.955 -3.980 -2.040 -3.951 -6.657 -4.757 -5.013 -43.793 -0,3% -3.649 -5.298 -2.682 -2.676 -3.256 -4.790 -7.338 -4.241 -2.332 -4.238 -7.048 -5.023 -5.296 -54.218 -0,3% -4.518 -10.425 23,8%

Other Income 13.633 12.313 10.731 11.603 16.646 10.693 10.820 11.636 14.665 13.635 20.490 18.883 165.749 1,0% 13.812 16.913 17.598 11.074 12.896 16.670 11.269 10.614 11.414 14.386 13.376 20.099 18.524 174.833 1,0% 14.569 9.084 5,5%
Total Extraordinary Results 13.633 12.313 10.731 11.603 16.646 10.693 10.820 11.636 14.665 13.635 20.490 18.883 165.749 1,0% 13.812 16.913 17.598 11.074 12.896 16.670 11.269 10.614 11.414 14.386 13.376 20.099 18.524 174.833 1,0% 14.569 9.084 5,5%

EBT -219.551 -105.348 -4.981 63.844 437.898 63.244 720.233 225.874 920.125 485.419 1.023.975 -112.736 3.497.994 20,1% 291.499 416.874 99.631 259.578 94.536 -61.559 7.967 659.412 179.920 855.390 423.485 960.970 -161.786 3.734.418 20,7% 311.201 236.424 6,8%
Corporate Profit Taxes
Net Income After Taxes -219.551 -105.348 -4.981 63.844 437.898 63.244 720.233 225.874 920.125 485.419 1.023.975 -112.736 3.497.994 20,1% 291.499 416.874 99.631 259.578 94.536 -61.559 7.967 659.412 179.920 855.390 423.485 960.970 -161.786 3.734.418 20,7% 311.201 236.424 6,8%
 FyFcst Budget Control 6 + 6 Reporting

Budget FY Forecast

2021 Budget 2021 FYFcst

2.500.000
2.500.000

2.000.000 2.000.000

1.500.000 Revenue Revenue

1.500.000
Direct Costs Direct Costs
1.000.000 Overhead Costs 1.000.000 Overhead Costs
Operation Costs Operation Costs
500.000 500.000

0
0
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec

2021 Budget 2021 FYFcst

2.500.000 2.500.000

2.000.000 2.000.000

1.500.000 1.500.000
Overhead Costs Overhead Costs
Direct Costs Direct Costs
1.000.000 Revenue 1.000.000 Revenue

500.000 500.000

0 0
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
 FyFcst Budget Control 6 + 6 Reporting

Revenue Analysis Direct Costs Analysis

2021 FYFcst 2021 FYFcst

2.500.000 900.000
800.000
2.000.000
700.000
600.000
1.500.000
Budget Revenue 500.000
Budget Direct Costs
1.000.000 Actual Revenue 400.000
Actual Direct Costs
300.000
500.000 200.000
100.000
0 0
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec

Overhead Costs Analysis

2021 FYFcst
700.000

600.000

500.000

400.000
Budget Overhead Costs
300.000 Actual Overhead Costs
200.000

100.000

0
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec