| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | AC | AD | AE | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | ENERO | FEBRERO | MARZO | ABRIL | MAYO | JUNIO | JULIO | AGOSTO | SEPTIEMBRE | OCTUBRE | NOVIEMBRE | DICIEMBRE | TOTAL | |||||||||||||||||||
2 | Ventas Netas 2024 | S/87,462 | S/88,626 | S/92,770 | S/97,406 | S/83,372 | S/85,755 | S/73,567 | S/78,055 | S/93,727 | S/70,515 | S/123,890 | S/218,167 | ANALISIS OBJETIVOS con CIO | ||||||||||||||||||
3 | Ventas Netas 2025 | S/74,444 | S/66,722 | S/101,034 | S/102,514 | S/88,730 | S/85,069 | S/73,808 | S/80,137 | S/79,401 | S/93,809 | S/152,279 | S/210,418 | S/183,000 | AOV | 273 | ||||||||||||||||
4 | 4 | TC | 3.37 | 3.36 | 3.39 | 3.44 | 3.4 | 3.4 | 3.38 | 3.36 | SEPT | OCT | NOV | DIC | ||||||||||||||||||
5 | OBJETIVO VENTAS NETAS | S/80,000 | S/100,000 | S/120,000 | S/120,000 | S/110,000 | S/102,000 | S/85,000 | S/96,000 | S/96,000 | S/113,000 | S/183,000 | S/255,000 | S/1,460,000 | Objetivo | 102,742 | 105,000 | 217,671 | 260,000 | |||||||||||||
6 | TOTAL VENTAS NETAS CASIOPIA | S/109,125 | S/91,647 | S/116,434 | S/103,742 | S/100,011 | S/79,144 | S/104,807 | S/115,798 | S/66,171 | S/0 | S/0 | S/0 | S/886,879 | N pedidos | 376 | 385 | 797 | 952 | |||||||||||||
7 | TOTAL COSTO VENTAS CASIOPIA | S/28,350 | S/22,000 | S/28,369 | S/29,394 | S/26,423 | S/20,796 | S/28,160 | S/29,599 | S/213,091 | Puntos de equilibrio | |||||||||||||||||||||
8 | MG Bruto | 74.02 % | 75.99 % | 75.64 % | 71.67 % | 73.58 % | 73.72 % | 73.13 % | 74.44 % | 100.00 % | #DIV/0! | #DIV/0! | #DIV/0! | 75.97 % | Online | S/30,000 | ||||||||||||||||
9 | TOTAL GASTOS CASIOPIA | -S/67,579 | -S/64,387 | -S/72,966 | -S/70,357 | -S/71,086 | -S/62,528 | -S/69,369 | -S/62,271 | -S/30,784 | -S/30,784 | -S/30,784 | -S/30,716 | -S/663,611 | La Mar | S/12,000 | ||||||||||||||||
10 | MARGEN NETO CASIOPIA | S/13,196 | S/5,260 | S/15,099 | S/3,990 | S/2,502 | -S/4,181 | S/7,279 | S/23,928 | S/35,387 | -S/30,784 | -S/30,784 | S/40,893 | Polo | S/35,000 | |||||||||||||||||
11 | MG Neto | 12.09 % | 5.74 % | 12.97 % | 3.85 % | 2.50 % | -5.28 % | 6.94 % | 20.66 % | 53.48 % | #DIV/0! | #DIV/0! | #DIV/0! | 4.61 % | ||||||||||||||||||
12 | 11.45 % | 5.80 % | 12.32 % | 2.66 % | 1.42 % | -6.53 % | 5.67 % | 19.62 % | ||||||||||||||||||||||||
13 | TOTAL G/P delivery | S/421 | S/974 | S/434 | -S/186 | -S/89 | -S/202 | -S/302 | -S/77 | S/779 | S/0 | S/0 | S/0 | TOTAL | S/77,000 | |||||||||||||||||
14 | RENTA DE 3ra | -S/1,120 | -S/917 | -S/1,186 | -S/1,049 | -S/998 | -S/786 | -S/1,038 | -S/1,129 | S/0 | S/0 | S/0 | ||||||||||||||||||||
15 | MARGEN DP de Impuestos | S/12,497 | S/5,317 | S/14,347 | S/2,755 | S/1,415 | -S/5,168 | S/5,938 | S/22,722 | S/36,166 | -S/30,784 | -S/30,784 | S/0 | S/34,422 | ||||||||||||||||||
16 | 11.45 % | 5.80 % | 12.32 % | 2.66 % | 1.42 % | -6.53 % | 5.67 % | 19.62 % | 54.66 % | #DIV/0! | #DIV/0! | #DIV/0! | ||||||||||||||||||||
17 | Número de pedidos | 415 | 542 | 719 | 396 | 392 | 282 | 296 | 352 | |||||||||||||||||||||||
18 | tiquet medio | 310 | 200 | 191 | 309 | 301 | 331 | 418 | 388 | |||||||||||||||||||||||
19 | ventas web+rrss 2024 | S/19,508 | S/23,154 | S/20,516 | S/16,559 | S/19,540 | S/27,554 | S/13,246 | S/14,988 | S/20,291 | S/14,563 | S/44,060 | S/41,596 | |||||||||||||||||||
21 | ventas web+rrss 2025 | S/26,994 | S/20,212 | S/28,038 | S/20,101 | S/23,493 | S/24,612 | S/22,745 | S/18,237 | S/21,274 | S/14,053 | S/67,069 | S/45,424 | S/36,567 | ||||||||||||||||||
22 | VENTAS NETAS WEB | S/26,406 | S/32,935 | S/38,188 | S/36,035 | S/30,741 | S/20,381 | S/28,718 | S/27,245 | S/16,483 | S/0 | S/0 | S/0 | S/257,131 | 0 | 0 | Costo de venta total considerando 4,22 por producto por costura | |||||||||||||||
23 | VENTAS NETAS RRSS | S/10,161 | S/4,030 | S/7,453 | S/7,083 | S/7,915 | S/5,326 | S/8,898 | S/15,457 | S/6,291 | S/0 | S/0 | S/0 | S/72,614 | 0 | |||||||||||||||||
24 | COSTO VENTAS WEB | S/6,860 | S/7,906 | S/11,456 | S/10,210 | -S/8,122 | S/5,355 | S/7,716 | S/6,964 | S/0 | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | S/7,540 | |||||||||||||||||
25 | COSTO VENTAS RRSS | S/2,640 | S/968 | S/2,236 | S/2,007 | -S/2,091 | S/1,399 | S/2,391 | S/3,951 | S/0 | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | ||||||||||||||||||
26 | objetivo web | 20000 | 30000 | 35000 | 35000 | 40000 | 40000 | 40000 | 40000 | 280000 | ||||||||||||||||||||||
27 | objetivo RRSS | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 80000 | ||||||||||||||||||||||
28 | -$79 | Fee web | -S/165 | -S/165 | -S/166 | -S/169 | -S/167 | -S/167 | -S/166 | -S/165 | S/0 | S/0 | S/0 | S/0 | S/0 | S/9,500 | S/8,873 | S/13,692 | S/12,217 | -S/10,213 | S/6,755 | S/10,107 | S/10,915 | S/0 | Costo de tela | #DIV/0! | #DIV/0! | |||||
29 | 5.16% | Mercado Pago | -S/1,397 | -S/1,645 | -S/2,002 | -S/1,709 | -S/1,521 | -S/988 | -S/1,566 | -S/1,289 | -S/12,117 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | Estimado costura por mes | |||||||||||
30 | 1.0% | Shopify | -S/537 | -S/471 | -S/374 | -S/402 | -S/354 | -S/221 | -S/341 | -S/292 | -S/2,993 | 107 | 139 | 200 | 70 | 70 | 93 | 89 | 81 | 75 | Num de pedidos | |||||||||||
31 | Klaviyo | -S/674 | -S/672 | -S/678 | -S/688 | -S/680 | -S/680 | -S/676 | -S/672 | S/0 | S/0 | S/0 | S/0 | -S/5,420 | S/150 | S/195 | S/280 | S/98 | S/98 | S/130 | S/125 | S/113 | S/105 | Costo packaging | 1.4 | |||||||
32 | -S/325 | -S/293 | -S/316 | -S/323 | -S/245 | -S/473 | -S/689 | -S/2,664 | S/10,650 | S/10,068 | S/14,972 | S/13,315 | -S/9,115 | S/7,885 | S/11,232 | S/12,028 | S/1,105 | |||||||||||||||
33 | S/288 | Hosting y dominio | -S/24 | -S/24 | -S/24 | -S/24 | -S/24 | -S/24 | -S/24 | -S/24 | -S/24 | -S/24 | -S/24 | -S/24 | -S/288 | |||||||||||||||||
34 | 86% | Gastos de Marketing | -S/12,837 | -S/10,810 | -S/13,859 | -S/12,065 | -S/16,456 | -S/10,489 | -S/10,777 | -S/13,288 | -S/4,042 | -S/4,042 | -S/4,042 | -S/4,042 | ||||||||||||||||||
35 | 37 % | Gastos generales | -S/11,506 | -S/11,210 | -S/12,815 | -S/12,164 | -S/11,376 | -S/10,988 | -S/11,761 | -S/9,628 | -S/8,454 | -S/8,454 | -S/8,454 | -S/8,428 | -S/125,238 | |||||||||||||||||
36 | GASTOS WEB | -S/27,141 | -S/25,322 | -S/30,211 | -S/27,537 | -S/30,901 | -S/23,802 | -S/25,783 | -S/26,046 | -S/12,520 | -S/12,520 | -S/12,520 | -S/12,494 | -S/266,797 | ||||||||||||||||||
37 | MARGEN NETO WEB | -S/74 | S/2,770 | S/1,737 | S/3,364 | S/17,968 | -S/4,850 | S/1,726 | S/5,740 | S/10,253 | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | ||||||||||||||||||
38 | MG Neto | -0.28 % | 8.41 % | 4.55 % | 9.34 % | 58.45 % | -23.80 % | 6.01 % | 21.07 % | 0.00 % | #DIV/0! | #DIV/0! | #DIV/0! | 0.00 % | ||||||||||||||||||
39 | ||||||||||||||||||||||||||||||||
40 | ||||||||||||||||||||||||||||||||
41 | Vntas Netas 2024 La Mar | 19684 | 18421 | 19090 | 34212 | 19121 | 17253 | 19461 | 18252 | 29183 | 18017 | 30185 | 63269 | 306148 | ||||||||||||||||||
42 | Vntas Netas 2025 La Mar | S/17,833 | S/15,449 | S/25,158 | S/40,116 | S/25,075 | S/29,670 | S/17,411 | S/17,835 | S/25,194 | S/22,316 | S/27,392 | S/57,646 | S/321,096 | ||||||||||||||||||
43 | VENTAS NETAS LA MAR | S/17,866 | S/21,116 | S/21,389 | S/17,882 | S/22,060 | S/19,348 | S/13,455 | S/26,193 | S/17,539 | S/0 | S/0 | S/0 | S/176,848 | ||||||||||||||||||
44 | COSTO VENTAS LA MAR | S/4,641 | S/5,069 | S/5,211 | S/5,067 | S/5,828 | S/5,084 | S/3,615 | S/6,695 | S/0 | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | ||||||||||||||||||
45 | objetivo La Mar | 20000 | 17000 | 30000 | 30000 | 25000 | 25000 | 20000 | 20000 | 25000 | 212000 | -51.42% | ||||||||||||||||||||
46 | Alquiler la Mar | -S/1,800 | -S/1,800 | -S/1,800 | -S/1,800 | -S/1,800 | -S/1,800 | -S/1,800 | -S/1,800 | -S/2,400 | -S/2,400 | -S/2,400 | -S/2,400 | -S/24,000 | ||||||||||||||||||
47 | Mantenimiento la Mar | -S/140 | -S/140 | -S/140 | -S/140 | -S/140 | -S/140 | -S/140 | -S/140 | -S/140 | -S/140 | -S/140 | -S/140 | -S/1,680 | ||||||||||||||||||
48 | Arbitrios La Mar | -S/97 | -S/97 | -S/97 | -S/97 | -S/97 | -S/97 | -S/97 | -S/97 | -S/97 | -S/97 | -S/97 | -S/97 | -S/1,164 | Actualizado 2025 | |||||||||||||||||
49 | Luz La Mar | -S/40 | -S/40 | -S/40 | -S/40 | -S/40 | -S/40 | -S/40 | -S/40 | -S/40 | -S/40 | -S/40 | -S/40 | -S/480 | ||||||||||||||||||
50 | Internet La Mar | -S/57 | -S/57 | -S/57 | -S/57 | -S/57 | -S/57 | -S/57 | -S/57 | -S/57 | -S/57 | -S/57 | -S/57 | -S/684 | Detalle gastos | |||||||||||||||||
51 | Planilla | -S/1,700 | -S/1,654 | -S/1,654 | -S/1,635 | -S/1,635 | -S/1,635 | -S/2,567 | -S/1,635 | -S/14,115 | ||||||||||||||||||||||
52 | comisiones La Mar | -S/208 | -S/331 | S/0 | S/0 | S/0 | S/0 | S/0 | -S/539 | |||||||||||||||||||||||
53 | Caja Chica La Mar | -S/286 | -S/173 | -S/135 | -S/147 | -S/180 | -S/324 | -S/320 | S/0 | -S/1,565 | ||||||||||||||||||||||
54 | Comision VISA | -S/665 | -S/708 | -S/714 | -S/616 | -S/760 | -S/725 | -S/449 | -S/814 | -S/5,451 | ||||||||||||||||||||||
55 | mejoras La Mar | S/0 | ||||||||||||||||||||||||||||||
56 | 5% | Gastos de Marketing | -S/746 | -S/629 | -S/806 | -S/701 | -S/957 | -S/610 | -S/627 | -S/773 | -S/235 | -S/235 | -S/235 | -S/235 | -S/6,788 | |||||||||||||||||
57 | 19 % | Gastos generales | -S/5,796 | -S/5,647 | -S/6,455 | -S/6,127 | -S/5,730 | -S/5,535 | -S/5,924 | -S/4,850 | -S/4,258 | -S/4,258 | -S/4,258 | -S/4,245 | -S/63,084 | |||||||||||||||||
58 | GASTOS LA MAR | -S/11,535 | -S/11,276 | -S/11,898 | -S/11,360 | -S/11,396 | -S/10,963 | -S/12,020 | -S/10,205 | -S/7,227 | -S/7,227 | -S/7,227 | -S/7,214 | -S/119,550 | ||||||||||||||||||
59 | MARGEN NETO LA MAR | S/1,689 | S/4,772 | S/4,279 | S/1,455 | S/4,836 | S/3,302 | -S/2,181 | S/9,292 | S/10,312 | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | ||||||||||||||||||
60 | ||||||||||||||||||||||||||||||||
61 | ||||||||||||||||||||||||||||||||
62 | Ventas Netas Polo 2024 | 28705 | 19831 | 21675 | 30477 | 29718 | 27207 | 26247 | 25647 | 29073 | 37592 | 46347 | 106712 | 429231 | ||||||||||||||||||
63 | Ventas Polo 2025 | S/25,106 | S/25,150 | S/40,470 | S/41,105 | S/38,287 | S/29,200 | S/32,687 | S/42,346 | S/31,250 | S/55,364 | S/56,141 | S/101,155 | S/518,263 | ||||||||||||||||||
64 | VENTAS NETAS POLO | S/43,246 | S/29,354 | S/42,777 | S/40,293 | S/38,098 | S/33,597 | S/52,878 | S/45,739 | S/23,806 | S/0 | S/0 | S/0 | S/349,787 | ||||||||||||||||||
65 | COSTO VENTAS POLO | S/11,235 | S/7,339 | S/10,694 | S/10,073 | S/9,524 | S/8,399 | S/13,220 | S/11,435 | S/5,951 | S/0 | S/0 | S/87,870 | |||||||||||||||||||
66 | Objetivo El Polo | 30000 | 40000 | 50000 | 45000 | 40000 | 40000 | 40000 | 55000 | 40000 | 70000 | 70000 | 120000 | 640000 | 28% de crecimiento | |||||||||||||||||
67 | Alquiler Polo | -S/8,765 | -S/8,739 | -S/8,817 | -S/8,947 | -S/8,843 | -S/8,843 | -S/8,843 | -S/8,739 | S/0 | S/0 | S/0 | S/0 | -S/70,539 | ||||||||||||||||||
68 | Mantenimiento Polo | -S/447 | -S/445 | -S/448 | -S/446 | -S/447 | -S/446 | -S/446 | -S/446 | -S/446 | -S/446 | -S/446 | -S/446 | -S/5,355 | ||||||||||||||||||
69 | Arbitrios Polo | -S/152 | -S/152 | -S/152 | -S/152 | -S/152 | -S/152 | -S/152 | -S/152 | -S/152 | -S/152 | -S/152 | -S/152 | -S/1,821 | ||||||||||||||||||
70 | Luz Polo | -S/65 | -S/65 | -S/65 | -S/65 | -S/65 | -S/65 | -S/65 | -S/110 | -S/565 | ||||||||||||||||||||||
71 | Internet Polo + celular | -S/178 | -S/178 | -S/178 | -S/178 | -S/178 | -S/178 | -S/178 | -S/178 | -S/178 | -S/178 | -S/178 | -S/178 | -S/2,136 | ||||||||||||||||||
72 | Caja chica El Polo | -S/121 | -S/158 | -S/134 | -S/319 | -S/352 | -S/399 | -S/485 | -S/140 | -S/2,108 | ||||||||||||||||||||||
73 | Planilla el POLO | -S/1,852 | -S/2,285 | -S/2,705 | -S/3,786 | -S/1,931 | -S/2,149 | -S/3,458 | -S/2,212 | -S/20,378 | ||||||||||||||||||||||
74 | Mejoras el POLO | S/0 | -S/70 | S/0 | -S/359 | S/0 | S/0 | S/0 | S/0 | -S/429 | ||||||||||||||||||||||
75 | Comisiones El Polo | -S/994 | -S/121 | -S/492 | -S/455 | -S/459 | -S/369 | -S/1,156 | -S/4,046 | |||||||||||||||||||||||
76 | Comision VISA | -S/1,596 | -S/1,102 | -S/1,502 | -S/1,335 | -S/1,402 | -S/1,279 | -S/1,969 | -S/1,448 | -S/11,633 | ||||||||||||||||||||||
77 | 9% | Gastos de Marketing | -S/1,343 | -S/1,131 | -S/1,450 | -S/1,263 | -S/1,722 | -S/1,098 | -S/1,128 | -S/1,391 | -S/423 | -S/423 | -S/423 | -S/423 | -S/12,218 | |||||||||||||||||
78 | 40% | Gastos generales | -S/12,202 | -S/11,888 | -S/13,590 | -S/12,899 | -S/12,064 | -S/11,652 | -S/12,471 | -S/10,210 | -S/8,965 | -S/8,965 | -S/8,965 | -S/8,938 | -S/132,808 | |||||||||||||||||
79 | GASTOS POLO | -S/27,715 | -S/26,334 | -S/29,534 | -S/30,204 | -S/27,615 | -S/26,630 | -S/30,351 | -S/25,025 | -S/10,164 | -S/10,164 | -S/10,164 | -S/10,137 | -S/264,036 | ||||||||||||||||||
80 | MARGEN NETO POLO | S/4,295 | -S/4,319 | S/2,549 | S/16 | S/958 | -S/1,432 | S/9,308 | S/9,279 | S/7,691 | -S/10,164 | -S/10,164 | -S/10,137 | S/525,953 | ||||||||||||||||||
81 | ||||||||||||||||||||||||||||||||
82 | Ventas netas ambos canales | |||||||||||||||||||||||||||||||
83 | VENTAS NETAS Falabella | S/598 | S/1,053 | S/2,555 | S/2,211 | S/342 | S/38 | S/858 | S/1,164 | S/2,053 | S/0 | S/0 | S/0 | S/10,873 | ||||||||||||||||||
84 | VENTAS NETAS Ripley y otros | S/10,848 | S/3,159 | S/4,072 | S/238 | S/855 | S/454 | S/0 | S/0 | S/0 | S/0 | S/0 | S/0 | S/19,626 | ||||||||||||||||||
85 | COSTO VENTA Falabella | S/155 | S/253 | S/623 | S/626 | S/90 | S/10 | S/230 | S/298 | S/0 | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | ||||||||||||||||||
86 | COSTO VENTA Ripley | S/2,818 | S/758 | S/992 | S/67 | S/226 | S/119 | S/0 | S/0 | S/0 | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | ||||||||||||||||||
87 | Objetivo Otros | |||||||||||||||||||||||||||||||
88 | % costo | 30.00 % | 30.00 % | 30.00 % | 30.00 % | 30.00 % | 30.00 % | 30.00 % | 30.00 % | 30.00 % | 30.00 % | 30.00 % | 30.00 % | |||||||||||||||||||
89 | comisión y gastos Falabella | -S/298 | -S/298 | -0.41 % | ||||||||||||||||||||||||||||
90 | 4 % | Gastos generales | -S/1,188 | -S/1,157 | -S/1,323 | -S/1,256 | -S/1,174 | -S/1,134 | -S/1,214 | -S/994 | -S/873 | -S/873 | -S/873 | -S/870 | -S/12,929 | -17.81 % | Insumos | |||||||||||||||
91 | GASTOS Falabella | -S/1,188 | -S/1,456 | -S/1,323 | -S/1,256 | -S/1,174 | -S/1,134 | -S/1,214 | -S/994 | -S/873 | -S/873 | -S/873 | -S/870 | -S/13,228 | ||||||||||||||||||
92 | MARGEN NETO Falabella | S/7,285 | S/1,745 | S/3,690 | S/499 | -S/293 | -S/771 | -S/587 | -S/127 | S/1,180 | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | ||||||||||||||||||
93 | ||||||||||||||||||||||||||||||||
94 | ||||||||||||||||||||||||||||||||
95 | GASTOS CASIOPIA | |||||||||||||||||||||||||||||||
96 | Alquileres General | -S/4,700 | -S/4,700 | -S/4,700 | -S/4,700 | -S/4,700 | -S/4,700 | -S/4,700 | -S/4,700 | -S/4,700 | -S/4,700 | -S/4,700 | -S/4,700 | -S/56,400 | ||||||||||||||||||
97 | Internet General | -S/72 | -S/72 | -S/72 | -S/72 | -S/72 | -S/72 | -S/72 | -S/72 | -S/72 | -S/72 | -S/72 | -S/72 | -S/864 | ||||||||||||||||||
98 | Luz Taller General | -S/124 | -S/124 | -S/124 | -S/124 | -S/124 | -S/124 | -S/124 | -S/124 | -S/124 | -S/124 | -S/124 | -S/124 | -S/1,488 | ||||||||||||||||||
99 | Celular Entel | -S/27 | -S/27 | -S/27 | -S/27 | -S/27 | -S/27 | -S/27 | -S/27 | -S/27 | -S/27 | -S/27 | -S/27 | -S/324 | ||||||||||||||||||
100 | Alarma | -S/139 | -S/139 | -S/139 | -S/139 | -S/139 | -S/139 | -S/139 | -S/139 | -S/139 | -S/139 | -S/139 | -S/139 | -S/185 | ||||||||||||||||||
101 | Facturador | -S/175 | -S/175 | -S/883 | -S/175 | -S/175 | -S/175 | -S/175 | -S/175 | -S/175 | -S/175 | -S/175 | -S/175 | -S/2,807 | ||||||||||||||||||