0% ont trouvé ce document utile (0 vote)
38 vues12 pages

Analyse des ventes et coûts 2023

Transféré par

norma.glez.gtz
Copyright
© © All Rights Reserved
Nous prenons très au sérieux les droits relatifs au contenu. Si vous pensez qu’il s’agit de votre contenu, signalez une atteinte au droit d’auteur ici.
Formats disponibles
Téléchargez aux formats XLSX, PDF, TXT ou lisez en ligne sur Scribd
0% ont trouvé ce document utile (0 vote)
38 vues12 pages

Analyse des ventes et coûts 2023

Transféré par

norma.glez.gtz
Copyright
© © All Rights Reserved
Nous prenons très au sérieux les droits relatifs au contenu. Si vous pensez qu’il s’agit de votre contenu, signalez une atteinte au droit d’auteur ici.
Formats disponibles
Téléchargez aux formats XLSX, PDF, TXT ou lisez en ligne sur Scribd

CONSOLIDADO I&C

VENTAS Jan-23 Feb-23 Mar-23

Producto 1 2,020,458 1,771,747 1,918,082


Producto 2 1,177,307 1,235,485 1,314,531
Producto 3 0 0 0
Producto 4 84,850 105,289 79,976
Producto 5 241,014 306,038 306,158
Producto 6 1,494,691 1,468,981 1,655,940
Producto 7 256,789 474,061 396,398
Producto 8 836,303 337,388 319,773
TOTAL VENTAS 5,854,624 5,224,928 5,594,459

COSTOS DE OPERACIÓN
SUELDOS OPERADORES Y AUXILIARES 370,236 310,996 311,232
SUELDOS MANTENIMIENTO 116,559 114,385 122,135
SUELDOS ADMON. DE OPERACIONES 124,557 141,392 171,841
MTTO. PREVENTIVO Y CORRECTIVO 182,817 159,123 165,411
MTTO. EQU. SOPORTE 117,313 98,253 91,876
TALLER CENTRAL 11,710 13,263 13,266
DIESEL Y GASOLINA 496,751 392,749 472,425
LLANTAS 49,810 68,413 50,739
SEGUROS Y FIANZAS 55,458 63,501 68,233
RELLENO SANITARIO 645,831 578,787 710,307
DEPRECIACIONES Y AMORTIZACIONES 589,814 584,544 584,544
AMORTIZACION CONCESIÓN 0 0 0
COSTOS DE VIAJE Y AUTOPISTAS 20,143 18,395 28,610
OTROS COSTOS FIJOS 130,664 117,835 156,217
OTROS COSTOS DE OPERACIÓN 1,080,825 873,175 808,744
TOTAL COSTOS DE OPERACIÓN 3,992,489 3,534,810 3,755,581
68.2% 67.7% 67.1%
UTILIDAD BRUTA 1,862,134 1,690,117 1,838,878
31.8% 32.3% 32.9%

GASTOS DE VENTA Y ADMÓN


SUELDOS VENTAS 161,809 183,293 94,240
OTROS GASTOS DE VENTA 35,183 38,224 34,926
SUELDOS ADMINISTRACIÓN 336,171 286,635 312,751
OTROS GASTOS DE ADMÓN. 25,101 13,162 19,624
RESPONSABILIDAD SOCIAL EMPRESARIAL 0 0 0
PROV. CREDITOS INCOBRABLES 29,273 29,273 24,824
STAFF CORPORATIVO 256,789 474,061 396,398
STAFF REGIONAL 164,500 108,414 136,912
OTRAS DEPRECIACIONES Y AMORTIZ. 20,833 20,833 20,832
TOTAL GASTOS 1,029,658 1,134,562 1,040,507
17.6% 21.7% 18.6%
UTILIDAD DE OPERACIÓN (UAFIR) 832,476 555,555 798,371
14.2% 10.6% 14.3%

FLUJO DE OPERACIÓN (UAFIRDA) 1,443,123 1,160,931 1,403,747


24.6% 22.2% 25.1%
REAL 2023
Apr-23 May-23 Jun-23 Jul-23 Aug-23 Sep-23

1,885,259 2,067,301 2,495,447 2,029,025 1,799,900 1,788,668


1,288,794 1,281,020 1,307,534 1,288,285 1,350,751 1,333,745
5,000 15,000 45,000 74,796 227,796 106,796
85,864 36,850 53,412 46,953 56,379 44,456
384,847 420,732 404,610 409,084 409,713 364,163
1,618,092 1,480,494 1,843,569 1,522,659 1,476,529 1,289,281
400,282 479,044 462,811 542,412 415,229 480,500
428,901 360,542 277,209 1,155,486 383,132 981,310
5,696,758 5,661,940 6,426,780 6,526,287 5,704,199 5,908,420

318,806 340,643 461,413 465,950 370,366 334,544


104,695 119,447 105,876 105,685 98,269 91,622
161,676 161,238 161,673 130,138 240,991 110,121
186,937 152,395 205,963 167,286 421,118 176,426
73,515 132,394 169,321 185,928 221,925 195,342
13,767 13,517 16,075 15,856 9,362 17,806
541,217 547,594 690,265 513,768 579,899 498,952
67,078 41,113 47,970 47,426 44,896 34,582
68,233 68,278 54,209 64,458 54,975 58,647
642,310 699,524 822,907 859,411 779,277 724,972
596,602 596,605 594,971 594,971 619,096 619,096
0 0 0 0 0 0
36,667 33,807 58,160 31,103 125,704 44,274
169,398 104,681 179,109 112,677 114,885 111,682
879,553 590,954 679,884 1,054,858 922,822 1,178,131
3,860,452 3,602,191 4,247,797 4,349,516 4,603,583 4,196,196
67.8% 63.6% 66.1% 66.6% 80.7% 71.0%
1,836,305 2,059,749 2,178,983 2,176,771 1,100,616 1,712,224
32.2% 36.4% 33.9% 33.4% 19.3% 29.0%

161,911 148,141 143,872 177,396 145,290 167,914


28,492 90,174 80,670 80,958 94,115 79,328
435,147 472,464 308,008 329,352 297,501 296,426
29,077 59,905 55,460 138,701 31,550 71,194
0 0 10,389 21,656 0 1,250
0 0 0 0 -694,806 0
400,282 479,044 462,811 542,412 415,229 480,500
130,635 128,628 150,473 198,440 125,169 119,248
20,724 19,367 19,367 19,312 19,312 18,588
1,206,268 1,397,724 1,231,049 1,508,227 433,360 1,234,448
21.2% 24.7% 19.2% 23.1% 7.6% 20.9%
630,037 662,025 947,933 668,544 667,256 477,776
11.1% 11.7% 14.7% 10.2% 11.7% 8.1%

1,247,363 1,277,998 1,562,271 1,282,827 1,305,663 1,115,460


21.9% 22.6% 24.3% 19.7% 22.9% 18.9%
Oct-23 Nov-23 Dec-23 Jan-22 Feb-22

1,880,961 1,982,900 1,875,320 1,676,356 1,783,685


1,322,782 1,386,778 1,378,129 1,439,273 1,477,412
74,796 74,796 81,764 198,180 248,072
46,598 81,964 48,414 104,473 122,549
280,317 242,313 249,563 264,079 273,075
1,311,018 1,476,872 1,203,584 1,807,077 1,730,161
448,934 442,665 447,837 266,158 313,564
549,194 634,299 547,042 472,785 342,621
5,465,665 5,879,921 5,383,816 6,228,382 5,977,575

347,478 380,324 480,614 308,278 373,011


113,393 117,920 95,492 97,637 107,449
135,645 198,367 143,584 176,935 170,702
180,891 162,881 158,935 219,610 164,643
201,504 196,723 184,210 156,233 139,883
11,713 16,452 12,103 13,817 16,042
524,775 584,411 500,954 624,565 581,710
42,562 46,484 156,473 39,631 30,259
58,647 58,250 58,250 122,865 119,206
827,796 760,602 720,272 804,698 787,185
615,444 609,487 605,867 578,488 572,538
0 0 0 0 0
87,802 32,293 57,685 28,321 42,862
144,962 139,197 174,796 119,326 148,706
884,987 743,482 872,238 828,131 655,872
4,177,596 4,046,873 4,221,472 4,118,536 3,910,068
76.4% 68.8% 78.4% 66.1% 65.4%
1,288,069 1,833,048 1,162,343 1,843,688 2,067,507
23.6% 31.2% 21.6% 29.6% 34.6%

132,566 142,742 74,333 224,096 95,162


100,113 91,177 90,363 67,366 71,376
310,401 295,858 333,850 346,689 282,167
102,785 99,131 149,628 20,333 29,281
19,985 0 0 0 0
0 0 -562,847 63,427 62,239
448,934 442,665 447,837 266,158 313,564
128,821 212,146 98,999 143,341 154,314
19,190 24,777 24,628 24,711 23,988
1,262,795 1,308,497 656,791 1,156,123 1,032,092
23.1% 18.6% 17.3%
25,274 524,550 505,552 687,565 1,035,416
0.5% 8.9% 9.4% 11.0% 17.3%

659,908 1,158,815 1,136,047 1,290,764 1,631,942


12.1% 19.7% 21.1% 21.6% 27.3%

REGALIAS 186,851
EBITDA #REF!
Mgn % #REF!
REAL 2022
Mar-22 Apr-22 May-22 Jun-22 Jul-22 Aug-22

1,578,962 1,163,296 975,953 1,614,291 1,579,502 1,685,606


1,546,452 1,350,198 1,078,172 1,138,401 1,383,964 1,269,566
183,500 61,600 0 210,300 227,000 293,600
120,514 116,432 127,735 68,794 80,979 84,670
218,201 229,230 220,512 236,827 232,282 244,323
1,884,800 1,384,614 1,097,805 1,646,862 1,784,993 1,594,540
281,487 211,206 191,501 240,719 217,306 475,879
675,145 75,806 306,528 509,106 833,205 1,354,619
6,207,574 4,381,175 3,806,705 5,424,581 6,121,924 6,526,925

408,803 223,618 256,986 342,471 383,555 341,371


171,518 94,093 113,703 114,087 104,312 98,345
175,827 226,421 143,642 146,921 145,164 133,823
95,843 54,951 78,124 121,575 245,308 195,758
156,620 144,889 144,148 191,709 159,196 176,782
14,526 10,824 9,928 13,392 13,736 19,062
582,049 288,694 267,006 427,995 492,284 526,835
62,012 46,606 31,429 36,151 52,415 37,827
122,808 113,473 113,168 116,040 112,576 119,495
875,119 465,415 471,003 759,293 722,582 639,412
567,034 541,035 541,035 540,995 540,995 540,995
0 0 0 0 0 0
48,616 10,323 8,758 36,354 24,899 64,480
121,740 237,092 95,774 169,271 97,768 127,645
826,892 401,844 402,927 1,747,940 1,082,394 1,320,022
4,229,407 2,859,281 2,677,629 4,764,193 4,177,181 4,341,852
68.1% 65.3% 70.3% 87.8% 68.2% 66.5%
1,978,167 1,521,894 1,129,077 660,388 1,944,742 2,185,073
31.9% 34.7% 29.7% 12.2% 31.8% 33.5%

349,750 130,395 136,640 112,057 186,727 125,701


73,516 71,066 74,055 76,210 75,838 75,159
269,661 303,735 291,674 289,716 300,667 383,045
26,189 84,657 37,101 34,372 16,354 43,860
0 0 1,358 0 0 0
64,188 67,428 6,069 54,246 61,219 65,269
281,487 211,206 191,501 240,719 217,306 475,879
128,879 125,824 110,691 143,684 159,185 202,978
23,988 23,948 20,753 20,753 21,862 20,912
1,217,657 1,018,259 869,843 971,758 1,039,158 1,392,802
19.6% 23.2% 22.9% 17.9% 17.0% 21.3%
760,510 503,635 259,233 -311,370 905,584 792,271
12.3% 11.5% 6.8% -5.7% 14.8% 12.1%

1,351,533 1,068,618 821,022 250,378 1,468,441 1,354,178


21.8% 24.4% 21.6% 4.6% 24.0% 20.7%
Sep-22 Oct-22 Nov-22 Dec-22

1,666,639 1,987,294 1,956,782 1,890,763


1,313,737 1,255,538 1,221,835 1,294,140
86,800 0 20,100 5,852
118,507 71,284 93,847 61,588
242,410 234,698 299,988 248,265
1,729,794 1,793,382 1,590,048 1,527,837
347,515 410,733 406,738 201,563
1,005,215 1,228,172 1,058,921 968,979
6,163,103 6,570,370 6,241,520 5,997,424

313,138 343,841 369,515 368,314


125,153 131,011 130,774 172,033
133,574 172,140 151,540 173,017
167,779 189,396 155,476 141,792
162,443 206,840 163,986 164,677
15,119 18,243 16,357 19,821
467,047 512,989 498,688 493,405
42,563 55,722 56,251 95,163
118,894 5,575 1,518 -189,646
743,140 737,599 659,970 638,835
593,252 589,627 594,799 594,798
0 0 0 0
24,899 22,221 24,849 30,700
140,628 98,120 159,969 218,054
1,238,487 1,372,085 1,196,459 1,156,245
4,286,116 4,455,409 4,180,150 4,077,207
69.5% 67.8% 67.0% 68.0%
1,876,987 2,114,960 2,061,370 1,920,216
30.5% 32.2% 33.0% 32.0%

130,697 166,609 154,712 135,307


79,206 82,419 97,621 100,442
304,640 305,871 296,172 363,008
42,452 85,985 47,889 44,643
1,190 22,750 0 0
0 0 0 0
347,515 410,733 406,738 201,563
157,810 164,851 154,056 466,829
20,912 20,936 20,833 20,833
1,084,422 1,260,153 1,178,021 1,332,626
17.6% 19.2% 18.9% 22.2%
792,565 854,807 883,349 587,590
12.9% 13.0% 14.2% 9.8%

1,406,730 1,465,369 1,498,981 1,203,221


22.8% 22.3% 24.0% 20.1%
Ventas Año Producto 1 Producto 2 Producto 3 Producto 4 Producto 5 Producto 6
Jan-22 2022 1,676,356 1,439,273 198,180 104,473 264,079 1,807,077
Feb-22 2022 1,783,685 1,477,412 248,072 122,549 273,075 1,730,161
Mar-22 2022 1,578,962 1,546,452 183,500 120,514 218,201 1,884,800
Apr-22 2022 1,163,296 1,350,198 61,600 116,432 229,230 1,384,614
May-22 2022 975,953 1,078,172 0 127,735 220,512 1,097,805
Jun-22 2022 1,614,291 1,138,401 210,300 68,794 236,827 1,646,862
Jul-22 2022 1,579,502 1,383,964 227,000 80,979 232,282 1,784,993
Aug-22 2022 1,685,606 1,269,566 293,600 84,670 244,323 1,594,540
Sep-22 2022 1,666,639 1,313,737 86,800 118,507 242,410 1,729,794
Oct-22 2022 1,987,294 1,255,538 0 71,284 234,698 1,793,382
Nov-22 2022 1,956,782 1,221,835 20,100 93,847 299,988 1,590,048
Dec-22 2022 1,890,763 1,294,140 5,852 61,588 248,265 1,527,837
Jan-23 2023 2,020,458 1,177,307 0 84,850 241,014 1,494,691
Feb-23 2023 1,771,747 1,235,485 0 105,289 306,038 1,468,981
Mar-23 2023 1,918,082 1,314,531 0 79,976 306,158 1,655,940
Apr-23 2023 1,885,259 1,288,794 5,000 85,864 384,847 1,618,092
May-23 2023 2,067,301 1,281,020 15,000 36,850 420,732 1,480,494
Jun-23 2023 2,495,447 1,307,534 45,000 53,412 404,610 1,843,569
Jul-23 2023 2,029,025 1,288,285 74,796 46,953 409,084 1,522,659
Aug-23 2023 1,799,900 1,350,751 227,796 56,379 409,713 1,476,529
Sep-23 2023 1,788,668 1,333,745 106,796 44,456 364,163 1,289,281
Oct-23 2023 1,880,961 1,322,782 74,796 46,598 280,317 1,311,018
Nov-23 2023 1,982,900 1,386,778 74,796 81,964 242,313 1,476,872
Dec-23 2023 1,875,320 1,378,129 81,764 48,414 249,563 1,203,584
Jan-24 2024 2,106,307 1,296,199 32,911 42,924 357,677 1,396,035
Producto 7 Producto 8
266,158 472,785
313,564 342,621
281,487 675,145
211,206 75,806
191,501 306,528
240,719 509,106
217,306 833,205
475,879 1,354,619
347,515 1,005,215
410,733 1,228,172
406,738 1,058,921
201,563 968,979
256,789 836,303
474,061 337,388
396,398 319,773
400,282 428,901
479,044 360,542
462,811 277,209
542,412 1,155,486
415,229 383,132
480,500 981,310
448,934 549,194
442,665 634,299
447,837 547,042
504,487 676,191

Vous aimerez peut-être aussi