Usaremos la fórmula:

PV = Costo del Producto / (1 - % de Ganancia)

 Cómo aplicarlo en tu hoja de cálculo (.xls)?

Ingresa tus datos:

En una celda (por ejemplo, A2), escribe el Costo del Producto.

En otra celda (por ejemplo, B2), escribe tu % de Ganancia deseado. ¡Ojo! Este porcentaje debe estar en formato decimal. Si quieres un 30% de ganancia, escribe 0.30 (o 30% si tu celda está formateada como porcentaje, la hoja de cálculo lo convertirá automáticamente a 0.30).

Aplica la fórmula: 

=A2/(1-B2)

Presiona "Enter" y ¡listo! La celda C2 te mostrará el Precio de Venta de tu producto, ya con el margen de utilidad incluido.

Ejemplo

Imagina que tu producto cuesta $50 y quieres una ganancia del 20%.

Costo del Producto (celda A2): 50

% de Ganancia (celda B2): (%20)

La fórmula en la celda C2 sería: =A2/(1-B2)

El cálculo sería: 50 / (1 - %20) = 50 / 0.80 = 62.50

Así, tu precio de venta sería $62.50, 63 redondeado...la casa siempre gana!

¡Espero te sea útil !

👨🏻‍💻💰🍳🤖 24.7.365

Read More

<script>window.alert("📦Se entrega en orden de solicitud. 🚴🏻Verifique la página:📅AGENDA");</script> <div align="center"><div id="divInputLoad" style="font-size: small;"><div class="separator" style="clear: both;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEheVHVNr3uhF_FIODk4B24004K7SiIn4e9sebOwBItbQ3OF4a3DoRCGjnwf9D1O1CWnT0L590ludZIdTC-IDWCsOppnikQ9S5CINQf0qP1b4ByijblCq_vIL7EMB5K4G9svaYooS9szf5KlTX3FwNDHaz7mxzJcqLHI9KuqKIC_1EpBmg/s1600/VAMPaficheBYN2025.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="512" data-original-width="512" height="200" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjz-uAVLEfWHt2GulWZnEhZrrCnxMH9WBPOF4eostWnhAV3x7-FE1gWSDfPklcYn00UUUV1ePkAjFpOkGA6KFaV7BtMveoevWxVBzbgfP_iaGHoJLCWTcNdpNExUViOSzOVL9JYUEgMauz2KqhNPKTx3J5UDM-XdRuCW6q2gFt667Hf7w/s150/1.png" width="200" /></a></div><br /> <h1><span style="color: #000000;">Artículos distribuidos de manera rápida y confiable.</span></h1> <select name="dirflg=b">         <option value="a">VISTA PREVIA (no es comprobante)</option>                 <option value="v">Cliente (ORIGINAL)</option>         <option value="s">Mensajero (COPIA)</option>        </select><br /> <div id="divFileUpload"> <input accept="image/*" id="file-upload" type="file" />     </div> <div id="file-preview-zone"> </div> </div> <script>     function readFile(input) {         if (input.files && input.files[0]) {             var reader = new FileReader();               reader.onload = function (e) {                 var filePreview = document.createElement('img');                 filePreview.id = 'file-preview';                 //e.target.result contents the base64 data from the image uploaded                 filePreview.src = e.target.result;                 console.log(e.target.result);                   var previewZone = document.getElementById('file-preview-zone');                 previewZone.appendChild(filePreview);             }               reader.readAsDataURL(input.files[0]);         }     }       var fileUpload = document.getElementById('file-upload');     fileUpload.onchange = function (e) {         readFile(e.srcElement);     }   </script><span style="color: #003055; font-size: x-small;">"Fotografía del elemento a transportar"</span><span style="color: #f50087; font-size: x-small;">. <script>     function buscarRuta() {         var inicio = document.getElementById('saddr').value;         var fin = document.getElementById('daddr').value;         var url = 'https://maps.google.com/maps/dir/?saddr=' + inicio + '&daddr=' + fin + '&dirflg=b';         window.open(url, '_blank');     } </script> <div>     <label>Dirección de inicio:</label>     <input id="saddr" placeholder="Código Postal, Recolección" required="" type="text" /> </div> <div>     <label>Dirección de destino:</label>     <input id="daddr" placeholder="Código Postal,Entrega" required="" type="text" /> </div> <button id="previas" onclick="buscarRuta()">Ruta y Distancia</button> <br />     <script type="text/javascript">     function numeroDecimales(numero,decimales,moneda)//pasa un número a decimales puntuando los millares y poniendo la moneda elegida por defecto dos decimales sin mostrar moneda     {     moneda = moneda || '';     decimales=decimales || 2;     num=numero.toFixed(decimales);     var splitStr = num.split('.');     var splitLeft = splitStr[0];     var splitRight = splitStr.length > 1 ? ',' + splitStr[1] : '';     var regx = /(\d+)(\d{3})/;     while (regx.test(splitLeft)) {     splitLeft = splitLeft.replace(regx, '$1' + '.' + '$2');     }     return splitLeft + splitRight + moneda;     }     function valor_id(id) //Obtiene el valor de un id dado     {         return document.getElementById(id).value;     }     function productoDosNumeros(num1,num2,_decimales) //Multiplica el valor de dos valores, lo convierte a número con x decimales, por defecto 2     {         _decimales=_decimales || 2;         valor1=parseFloat(num1);         valor2=parseFloat(num2);         producto=valor1*valor2;         return producto.toFixed(_decimales);     }     function mostrarNumeroEnId(valor,idDestino,_decimales,_moneda) //Muestra u número en un id concreto     {         _moneda=_moneda || "";         _decimales=_decimales || 2;         valor_origen=parseFloat(valor);         Numero=numeroDecimales(valor_origen,_decimales,_moneda);         document.getElementById(idDestino).value=Numero;     }     function mostrar_resultado()     {         valor_ruta=valor_id('ruta');             switch (valor_ruta)                 {                     case "ocho": valor_precio=8.0; break;                     case "nueve": valor_precio=9.0; break;                     case "diez": valor_precio=10.0;break;                     case "once": valor_precio=11.0;                 }         valor_unidades=valor_id('medida');         producto=productoDosNumeros(valor_precio,valor_unidades,2);         numero_unidades=valor_id("unidades");         producto=productoDosNumeros(producto,numero_unidades,2);             if (producto=="NaN")                 resultado="666"             else                 resultado=producto;         mostrarNumeroEnId(resultado,"resultado",2,'$');     }   </script>   <br />   <form action="" method="post">     Carga/Tamaño:     <select id="ruta" name="ruta">              <option value="ocho">        🎒       </option><option value="nueve">        🎒🎒       </option><option value="diez">        🎒🎒🎒       </option><option value="once">        🎒🎒🎒🎒     </option></select>     <br />Prioridad/Horario:     <select id="medida" name="medida"> <option value="1.5">matutino</option> <option value="1.0">vespertino</option> <option value="2.0">nocturno</option>       <option value="3.0">urgente</option> <option value="4.0">para ayer!</option>           </select><br />✨Distancia en<b> <span style="color: orange;">KILÓMETROS</span>:</b><input id="unidades" name="unidades" size="3" type="text" />           <input id="calcular" name="calcular" onclick="mostrar_resultado();" type="button" value="calcular" /><br />     <input disabled="disabled" id="resultado" size="6" type="text" />   </form><br /><span style="color: #003055; font-size: medium;"><div align="center"><br /></div><div align="center">1. Ingresa las DIRECCIONES de recoleccion y entrega.</div><div align="center">2. Click en MOSTRAR RUTA y DISTANCIA (recuerda que voy en bicicleta).</div><div align="center">3. Selecciona la CARGA o tamaño.</div><div align="center">4. Elegir la prioridad/CUENTA del cliente.</div><div align="center">5. Ingresa los KILÓMETROS, distancia de la ruta.</div><div align="center"><span style="color: #003055; font-size: small;">6. Haz click en CALCULAR.   </span></div><div align="center"><span style="color: #003055; font-size: small;"><br /></span></div><div align="center"><span style="color: #003055; font-size: small;">IMPRIME esta guia de PREPAGO y PÉGALA en tu paquete.<br /> *Antes de comenzar a pedalear, se verifican a detalle las solicitudes</span><span style="color: #c1981a; font-size: x-small;">.</span></div></span><div class="separator" style="clear: both; font-size: medium; text-align: center;"> <style> #saddr {     font-weight: bold;     font-size: 22px;     text-align: center;     letter-spacing: 0px;     color: #00ff00;     cursor: pointer;     padding: 5px;     margin: 0 5px 10px 0;     border: 3px dotted LIME;     background: #000000;     border-radius: 8px 8px 8px 8px; }    #daddr {     font-weight: bold;     font-size: 22px;     text-align: center;     letter-spacing: 0px;     color: #00ff00;     cursor: pointer;     padding: 5px;     margin: 0 5px 10px 0;     border: 3px dotted LIME;     background: #000000;     border-radius: 8px 8px 8px 8px; }    #previas {      font-weight: bold;     font-size: 20px;     text-align: center;     letter-spacing: 1px;     color: #ff8800;     cursor: pointer;     padding: 5px;     margin: 0 10px 10px 0;     border: 3px dotted #ff8800;     background: #000000;     border-radius: 8px 8px 8px 8px; }    #ruta {     font-weight: bold;     font-size: 18px;     text-align: center;     letter-spacing: 1px;     color: #ffffff;     cursor: pointer;     padding: 5px;     margin: 0 10px 10px 0;     border: 3px dotted RED;     background: #000000;     border-radius: 8px 8px 8px 8px; }      #medida {     font-weight: bold;     font-size: 18px;     text-align: center;     letter-spacing: 1px;     color: #ffffff;     cursor: pointer;     padding: 5px;     margin: 0 10px 20px 0;     border: 3px dotted RED;     background: #000000;     border-radius: 8px 8px 8px 8px; }    #unidades {     font-weight: bold;     font-size: 44px;     text-align: center;     letter-spacing: 1px;     color: #c1981a;     cursor: pointer;     padding: 5px;     margin: 0 10px 20px 0;     border: 3px dotted #c1981a;     background: #000000;     border-radius: 8px 8px 8px 8px; }    #calcular {      font-weight: bold;     font-size: 22px;     text-align: center;     letter-spacing: 1px;     color: #c1981a;     cursor: pointer;     padding: 5px;     margin: 0 10px 20px 0;     border: 3px dotted #c1981a;     background: #000000;     border-radius: 8px 8px 8px 8px; } #calcular:hover {   color: #f50087;      border: 3px dotted #c1981a; }    #resultado{     font-weight: bold;     font-size: 44px;     text-shadow: 3px 3px 3px rgba(0, 0, 0, 0.9);      text-align: center;     letter-spacing: 2px;     color: #00ff00;     cursor: pointer;     padding: 5px;     margin: 0 10px 20px 0;     border: 3px dotted #00ff00;     background-image:url(https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhO18hTcnHdHEFk2nWWVSlzPOxSOOtbhsD95MLNQppjno1jVO6scGQJpghimqcf19yABUnE5GF4MPbWszrfVTYoMQlIDhNVFsulM50WvmletMbalShSCKDTqvxlHIyOGjn89q2zDw5f95Ob37Ft5yBYAnBSRvfgZNITWhUwttstUFmjkA/s150/wallet-money-finance-cash-currency-rich-1452115-pxhere.com.jpg);   background-repeat:yes;   height:150px;   width:150px;   background-position:center;     border-radius: 8px 8px 8px 8px;     }    #resultado:hover {   color: #f50087;      border: 3px dotted #c1981a;   text-shadow: 1px 1px 1px rgba(193, 152, 26, 0.9);   background-image:url(https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEheVHVNr3uhF_FIODk4B24004K7SiIn4e9sebOwBItbQ3OF4a3DoRCGjnwf9D1O1CWnT0L590ludZIdTC-IDWCsOppnikQ9S5CINQf0qP1b4ByijblCq_vIL7EMB5K4G9svaYooS9szf5KlTX3FwNDHaz7mxzJcqLHI9KuqKIC_1EpBmg/s150/VAMPaficheBYN2025.png);   background-repeat:yes;   height:150px;   width:150px;   background-position:center; </style> <a href="javascript:window.print()">🌱.💾PDF</a> </div></span></div>

Read More

GoogleCalendar

Read More

para facebook Widget Seguidores Reales de Facebook

Read More

antes de <head> colocar el código :

Read More

Read More

• 

  Bulbasaur

  Bulbasaur is a grass/poison type Pokémon that evolves into Ivysaur. Bulbasaur is also one of the three starter Pokémon in Red/Blue.

• 

  Charmander

  Charmander is the fire-type starter Pokémon first seen in Pokémon Red/Blue. Charmander uses the power of its fiery tail to attack the enemy and eventually evolves into Charmeleon.

• 

  Charmeleon

  Charmeleon is a fire-type Pokémon first found in Pokémon Red/Blue. Charmander evolves from the fire-type starter Pokémon Charmander and eventually into Charizard, all while using his awesome fiery powers.

• 

  Squirtle

  Squirtle is a Water-type starter Pokémon from the original Pokémon Red/Blue. With enough experience it can evolve into a Wartortle.

• 

  Wigglytuff

  Wigglytuff is a normal/fairy type Pokémon that evolves from Jigglypuff with a Moon Stone.

• 

  Zubat

  Zubat is a Poison/Flying type Pokémon that evolves into Golbat.

• 

  Sandslash

  Sandslash is a ground type Pokémon that evolves from Sandshrew.

• 

  Nidorina

  Nidorina is a poison type Pokémon that evolves from Nidoran (female) and can evolve into Nidoqueen with a Moon Stone.

• 

  Vulpix

  Vulpix is a fire type Pokémon that evolves into Ninetales with a Fire Stone.

• 

  Gloom

  Gloom is a Grass/Poison type Pokémon that evolves from Oddish and can evolve into Vileplume with a Leaf Stone, or Bellossom with a Sun Stone.

• 

  Paras

  Paras is a Bug/Grass type Pokémon that evolves into Parasect.

• 

  Alakazam

  Alakazam is a psychic-type pokemon from the original Pokemon Red/Blue. As the evolution of Kadabra, Alakazam is the third in a line of powerful spoon-bending psychics.

• 

  Poliwrath

  Poliwrath is a water/fighting-type pokemon first found in the original Pokemon Red/Blue. Poliwrath is the evolved form of Poliwag and Poliwhirl, and it loves to get up-close and personal, using its confusing belly to misdirect opponents before it goes in for the final punch.

• 

  Mankey

  Mankey is a fighting-type pokemon first featured in the original Pokemon Red/Blue. Mankey uses its dense form to the fullest advantage, dodging nimbly as it strikes blows on its opponents.

• 

  Tentacruel

  Tentacruel is a water/poison-type pokemon first found in the original Pokemon Red/Blue. Tentacruel is the evolution of Tentacool, its spindly tentacles more numerous and more poisonous.

• 

  Farfetch'd

  Farfetch'd is a Normal/Flying type Pokémon. Farfetch'd is very protective of its leek, and can use the vegetable to attack opponents, even as Farfetch'd moves out of harm's way.

• 

  Voltorb

  Voltorb is an electric-type pokemon first found in the original Pokemon Red/Blue. Voltorb is commonly mistaken for a hidden pokeball, often to the detriment of the one who finds it.

• 

  Rhyhorn

  Rhyhorn is a ground/rock-type pokemon first found in the original Pokemon Red/Blue. Rhyhorn has a short stocky body that it uses to full advantage by rushing opponents to hit them with his horn-adorned head. It evolves into Rhydon when it reaches level 42.

• 

  Tangela

  Tangela is a grass-type pokemon first found in the original Pokemon Red/Blue. Tangela uses vines growing out of its body to obscure it so that only its eyes and feet can be seen.

• 

  Mr. Mime

  Mr. Mime is a psychic-type pokemon from the original Pokemon Red/Blue. Like his name indicates, this pokemon doesn't say much - but watch out! Mr. Mime can copy even the most deadly attack and use it as its own.

Read More