PDA

Vollständige Version anzeigen : Ebaygebühren Kalkulation 3-Satz???


Superkot1
07.04.2012, 11:59
Hallo Liebe Mitglieder,

sitze gerade dabei mir eine VK-Preis Kalkulation zu machen bezüglich Ebaygebühren, das ist mittlerweile mein 3 Anlauf ich komme aber einfach nicht weiter, wahrscheinlich stehe ich auf dem Schlauch....

Excel 2007:
netto EK 280,00
marge 35,00
Selbstkostenpreis 315,00
Mwst 19 % 59,85
Gesamtpreis 374,85
netto Ebaygebühren 5 % 19,73
Rabatt auf Gebühren 10 % 1,97
Gesamtgebühren 17,76
Mwst 19 % von Gebühren 3,37
Gebühren inkl. 19 % 21,13
Brutto Ebay VK 395,98


Wenn ich jetzt jedoch von dem Brutto Ebay VK die Gebühren i.H.v. 5 % rückwärts kalkuliere kommt 19,799 raus und nicht 19,73 wie oben aufgeführt.

Vielleicht könnt Ihr mir ja weiterhelfen.

Danke gruß Flo

Hajo_Zi
07.04.2012, 12:22
man könnte vermuten Du berechnst die Prozentwerte von unterschiedlichen Werte. Ich baue keine Datei nach, die Zeit hat schon jemand investiert.

<img src="http://Hajo-Excel.de/images/grusz1.gif" align="middle" height="40" alt="Grußformel"><a href="http://Hajo-Excel.de/index.htm" onclick="window.open(this.href);return false"><img border="0" src="http://Hajo-Excel.de/images/logo_hajo3.gif" align="middle" height="40" alt="Homepage"></a>

< Peter >
07.04.2012, 13:25
Hallo,

mir ist im Moment nicht klar woher die 19,73 Euro kommen.

Wenn ich auf 374,85 Euro draufrechne komme ich auf 18,74 Euro.

hary
07.04.2012, 13:47
Hallo Flo
hatte mal was aehnliches gemacht. In dieser Rechnung wird, egal wieviel Rabatt gewaehrt wird, der Bruttobetrag immer erhoeht. Damit der Verdienst immer gleich bleibt. Die gelben Felder koennen geaendert werden.

<b><em>Tabelle1</em></b><table border="1" cellspacing="0" cellpadding="0" style="border-color:#000000; border-width: 1px; font-size:11pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "><colgroup><col style="font-weight:bold; width:40px;" /><col style="width:292px;" /><col style="width:97px;" /><col style="width:97px;" /></colgroup><tr style="background-color:#99CCFF; text-align:center; font-weight:bold; "><td>&nbsp;</td><td>A</td><td>B</td><td>C</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">1</td><td style="color:#000000; background-color:#FFFFFF; text-align:left; " >Preiskalkulation:</td><td style="color:#000000; background-color:#FFFFFF; ">&nbsp; </td><td style="color:#000000; background-color:#FFFFFF; ">&nbsp; </td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">2</td><td style="color:#000000; background-color:#FFFFFF; ">&nbsp; </td><td style="color:#000000; background-color:#FFFFFF; ">&nbsp; </td><td style="color:#000000; background-color:#FFFFFF; ">&nbsp; </td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">3</td><td style="color:#000000; background-color:#FFFFFF; text-align:left; " ><b>EK d. Produktes (€):</b></td><td style="color:#000000; background-color:#FFFF00; text-align:right; " >280,00</td><td style="color:#000000; background-color:#FFFFFF; text-align:center; " >€</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">4</td><td style="color:#000000; background-color:#FFFFFF; text-align:left; " >Verdienst in (%):</td><td style="color:#000000; background-color:#FFFF00; text-align:right; " >12,50%</td><td style="color:#000000; background-color:#FFFFFF; text-align:center; " >%</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">5</td><td style="color:#006100; background-color:#FFFFFF; text-align:left; " >Kalkulationspreis (€):</td><td style="color:#000000; background-color:#FFFFFF; text-align:right; " >315,00</td><td style="color:#000000; background-color:#FFFFFF; text-align:center; " >€</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">6</td><td style="color:#006100; background-color:#FFFFFF; text-align:left; " >Verdienst entspricht (€):</td><td style="color:#000000; background-color:#FFFFFF; text-align:right; " >35,00</td><td style="color:#000000; background-color:#FFFFFF; text-align:center; " >€</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">7</td><td style="color:#000000; background-color:#FFFFFF; ">&nbsp; </td><td style="color:#000000; background-color:#FFFFFF; ">&nbsp; </td><td style="color:#000000; background-color:#FFFFFF; ">&nbsp; </td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">8</td><td style="color:#000000; background-color:#FFFFFF; text-align:left; " >Gebühren (%):</td><td style="color:#000000; background-color:#FFFF00; text-align:right; " >5,00%</td><td style="color:#000000; background-color:#FFFFFF; text-align:center; " >%</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">9</td><td style="color:#000000; background-color:#FFFFFF; text-align:left; " >Zielverkaufspreis (€):</td><td style="color:#000000; background-color:#FFFFFF; text-align:right; " >331,58 €</td><td style="color:#000000; background-color:#FFFFFF; text-align:center; " >€</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">10</td><td style="color:#000000; background-color:#FFFFFF; ">&nbsp; </td><td style="color:#000000; background-color:#FFFFFF; ">&nbsp; </td><td style="color:#000000; background-color:#FFFFFF; ">&nbsp; </td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">11</td><td style="color:#000000; background-color:#FFFFFF; text-align:left; " >Rabatt für Kundenzufriedenheit (%):</td><td style="color:#000000; background-color:#FFFF00; text-align:right; " >0,00%</td><td style="color:#000000; background-color:#FFFFFF; text-align:center; " >%</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">12</td><td style="color:#000000; background-color:#FFFFFF; text-align:left; " >Nach Kundenzufriedenheitsrabatt (€):</td><td style="color:#000000; background-color:#FFFFFF; text-align:right; " >331,58 €</td><td style="color:#000000; background-color:#FFFFFF; text-align:center; " >€</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">13</td><td style="color:#000000; background-color:#FFFFFF; ">&nbsp; </td><td style="color:#000000; background-color:#FFFFFF; ">&nbsp; </td><td style="color:#000000; background-color:#FFFFFF; ">&nbsp; </td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">14</td><td style="color:#000000; background-color:#FFFFFF; text-align:left; " >Rabatt für Mengenstaffelung (%):</td><td style="color:#000000; background-color:#FFFF00; text-align:right; " >0,00%</td><td style="color:#000000; background-color:#FFFFFF; text-align:center; " >%</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">15</td><td style="color:#000000; background-color:#FFFFFF; text-align:left; " >Nach Mengenstaffelrabatt (€):</td><td style="color:#000000; background-color:#FFFFFF; text-align:right; " >331,58 €</td><td style="color:#000000; background-color:#FFFFFF; text-align:center; " >€</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">16</td><td style="color:#000000; background-color:#FFFFFF; ">&nbsp; </td><td style="color:#000000; background-color:#FFFFFF; ">&nbsp; </td><td style="color:#000000; background-color:#FFFFFF; ">&nbsp; </td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">17</td><td style="color:#000000; background-color:#FFFFFF; text-align:left; " >Rabatt für Premiumkunden (%):</td><td style="color:#000000; background-color:#FFFF00; text-align:right; " >0,00%</td><td style="color:#000000; background-color:#FFFFFF; text-align:center; " >%</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">18</td><td style="color:#000000; background-color:#FFFFFF; text-align:left; " >Nach Premiumkundenrabatt (€):</td><td style="color:#000000; background-color:#FFFFFF; text-align:right; " >331,58 €</td><td style="color:#000000; background-color:#FFFFFF; text-align:center; " >€</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">19</td><td style="color:#000000; background-color:#FFFFFF; ">&nbsp; </td><td style="color:#000000; background-color:#FFFFFF; ">&nbsp; </td><td style="color:#000000; background-color:#FFFFFF; ">&nbsp; </td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">20</td><td style="color:#000000; background-color:#FFFFFF; text-align:left; " >Listenpreis (€):</td><td style="color:#000000; background-color:#FFFFFF; text-align:right; " >331,58 €</td><td style="color:#000000; background-color:#FFFFFF; text-align:center; " >€</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">21</td><td style="color:#000000; background-color:#FFFFFF; ">&nbsp; </td><td style="color:#000000; background-color:#FFFFFF; ">&nbsp; </td><td style="color:#000000; background-color:#FFFFFF; ">&nbsp; </td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">22</td><td style="color:#000000; background-color:#FFFFFF; text-align:left; " >Bruttoverkaufspreis (€) incl. MwSt.:</td><td style="color:#000000; background-color:#FFFFFF; text-align:right; " >394,58 €</td><td style="color:#000000; background-color:#FFFFFF; text-align:center; " >€</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">23</td><td style="color:#000000; background-color:#FFFFFF; ">&nbsp; </td><td style="color:#000000; background-color:#FFFFFF; ">&nbsp; </td><td style="color:#000000; background-color:#FFFFFF; ">&nbsp; </td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">24</td><td style="color:#000000; background-color:#FFFFFF; text-align:left; " >Mehrwertsteuer</td><td style="color:#000000; background-color:#FFFF00; text-align:right; " >19,00%</td><td style="color:#000000; background-color:#FFFFFF; ">&nbsp; </td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">25</td><td style="color:#000000; background-color:#FFFFFF; ">&nbsp; </td><td style="color:#000000; background-color:#FFFFFF; ">&nbsp; </td><td style="color:#000000; background-color:#FFFFFF; ">&nbsp; </td></tr></table><br/><table border="1" cellspacing="0" cellpadding="0" style="border-color:#000000; border-width: 1px; font-size:11pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "><tr style="background-color:#FFCC66; text-align:center; font-weight:bold; "><td colspan="3" > verwendete Formeln </td></tr><tr valign="top" style="background-color:#FFCC66; text-align:center; font-weight:bold; "><td> Zelle </td><td> Formel </td><td> Bereich </td></tr><tr><td>B5 </td><td>=B3+B6</td><td>&nbsp;</td></tr><tr><td>B6 </td><td>=AUFRUNDEN(B3*B4;2)</td><td>&nbsp;</td></tr><tr><td>B9 </td><td>=B5+((B5/(1-B8))*B8)</td><td>&nbsp;</td></tr><tr><td>B12 </td><td>=B9+((B9/(1-B11))*B11)</td><td>&nbsp;</td></tr><tr><td>B15 </td><td>=B12+((B12/(1-B14))*B14)</td><td>&nbsp;</td></tr><tr><td>B18 </td><td>=B15+((B15/(1-B17))*B17)</td><td>&nbsp;</td></tr><tr><td>B20 </td><td>=MAX(B8:B18)</td><td>&nbsp;</td></tr><tr><td>B22 </td><td>=B20+(B20*B24)</td><td>&nbsp;</td></tr></table><br/><a href="http://c.excelhost.de/c_beverly/getfile.php?id=122" onclick="window.open(this.href);return false">Tabellendarstellung in Foren Version 5.30</a><br/><br/>
vlt. hilft es weiter.
gruss hary