Numbers dont add up
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-04-2025 11:37 AM
So, I know I’m not the brightest crayon in the box when it comes to math .. but looking at 2 very similar sales, only 5 products apart, both priced the same on their respective product pages, yet one customer paid considerably less .. neither product on sale … plus the math does not seem to add up for me .. according to my math, I should have made $38.05746 on the $160.58, and $.45 on the 5% totaling $38.50846 on the one and $25.06275 on the other sale of $105.75 . And why are these 2 sales only 5 cards apart but a difference of $54.83.. thats a huge difference for only a 5 card variance. What am I missing here?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-04-2025 11:53 AM - edited 05-04-2025 12:03 PM
They're both right - it's the extra 5 invitations plus whatever type of paper they chose on that wedding order (see that extra 5% line?)
Birthday Invitation 50% MRF (marketing royalty fee)
For the wedding invitation 50% MRF
plus the 5% on the 9.02 for the wedding order
$17.13+ $0.23 = $17.33
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-04-2025 02:10 PM - edited 05-04-2025 02:16 PM
First of all , thank you very much .. … and .. Wow that is seriously sad .. just for kicks .. if you don't mind .. I know there were examples before , but I just couldnt get it , could you use this sale and show me what it would have been at 10% and then at say 25% .. or is this a calculator we have access to so I could do this myself? ? Thank you .. ps.. I still dont understand how there is so much difference in the ‘full retail price’ between the 2 orders.. both cards being the same individual price and only a difference of 5 cards .. did that extra 5% on the one order make up all that difference ? $54.83?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-04-2025 03:10 PM
@Deb The difference could be the type of paper used for the wedding invitation.
or the customer could have had a coupon code for the birthday invitations. We'll never really know
My MRF calculator isn't coded to work out any other royalties than 3rd party referred and there's no space for inputting a quantity so it wouldn't calculate the total (eg 80 x 2.82 @ 10%) - it's just coded for the total RRP x 1
You could download @ColsCreations spreadsheet and see if that can help you
but if you want to use it - more than welcome
https://creativegiftstudio.my.canva.site/marketing-royalty-fee-estimated-earnings-calculator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-04-2025 05:17 PM
Where ever I click on the calculator page, it flicks me straight through to your buy me a coffee page, without the opportunity to enter any numbers into the calculator.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-04-2025 05:25 PM - edited 05-04-2025 05:39 PM
What o/s are you using? Mobile or desktop?
edited to add - I just tested it from my end (windows/desktop) and it seems to work ok
edited take 2 - try again - should be good now (cross fingers)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-05-2025 04:20 AM - edited 05-05-2025 04:22 AM
Desktop PC, Chrome browser. Works now - thanks.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-04-2025 11:41 PM - edited 05-04-2025 11:46 PM
The birthday card sale on 5/4:
They got a 50% discount because that's the bulk discount shown in the drop-down for orders of 75 or more cards.
My calculator depends on using Zazzle's calculator to enter a % to see what the actual resulting product price will be and plugging that price into my sheet. So to show the math comparing this to if you had your royalty at 10% or 25% instead, I'd need to access the royalty calculator on one of my own products published on the same blank you used to see what the product price changes to. I don't have many cards and a quick check, none were published on this _invitation3 blank. But If you download my spreadsheet (free) you can compare different percentages yourself. There's a link to download it in this post.
As for the sale on 5/2 of the wedding _flatcard - when you click through directly from your royalty report, you should be able to see what size, paper type, corner style, etc they went with. Without that info it's impossible to say exactly what went down here. What we do know is -
They paid a total of $169.60 for 80 cards. Assuming the same 50% bulk discount, list price would have been $339.20 ($4.24 per card.) On the birthday card sale, list price would have been $211.50 ($2.82 per card). That's $1.42 per-card difference. But these were different products on different blanks and we don't know what the wedding buyer choose that increased their cost but I suspect they choose a larger size as nothing else really would add up to that price increase.
Congrats on the nice bulk orders BTW 😀👍
* Edited for text formatting fix

