Skip to main content
Loading video...

Reprints, Freights, and Profit - Let's make sure you make money

Transcript 18:20

hey everybody edo here and finally i have a little bit of a break from the mall peak kickstarter which has been moving along and i wanted to share a sheet that jessica and i have been using for some time uh with with other publishers this is really sort of in that zone of still indie small pub maybe you know you've done two three titles you have a reprint maybe four or five i don't know exactly but it's a way to think about all of your different products and their the print cost and then the cost for bringing them you know manufacturing them and shipping them uh in freight and then um how much revenue you're gonna make and basically one of the things that i discovered no i didn't discover but i got reminded of recently was how many publishers don't realize how much money they're gonna make on a standard print kickstarter makes it a little weird and interesting um but just generally speaking i'm gonna print one thousand two thousand three thousand four thousand copies of this if i sell them all do i make money do i lose money uh you'd be surprised and actually the you know the increased freight and all those other expenses have um been a big part of that so uh i'm just gonna walk through this spreadsheet and make it available to anyone who wants to use it like i've done with a number of other spreadsheets so hopefully it's helpful as always let me know if you think something should be added adjusted folks are going to have to make their own copy to edit it if they want to okay let's flip it around and take a look all right here we go as i mentioned

there are a lot of pieces of information in here so off here on the left you'll notice that we have a series of games small game a tiny game medium game small game whatever with their quantity and price per unit this is something you'd get from your manufacturer um you have to update it fairly regularly but usually even older quotes are reasonable i have to say uh this will come up in other videos as well but having a spreadsheet that actually has these values just in a table is so helpful it'll save you from going back to old quotes again and again and again also when thinking about future prints and updates and those sorts of things it's really good to get more price quotes than just the one count you're pretty confident you're going to be doing whether starting at a thousand or going big et cetera so it's just a series of items also uh there might be some other item that has you know really small print associated with it as well if you're doing a demo or something like that okay so that's just this table but we do pull from it um again i mentioned jessica earlier she is a spreadsheet wizard and has been you know helping out making these very useful spreadsheets as we've been you know building out and growing the business so we have our game oh and so the purpose here again for me as a business owner saying hey we want to do a print run shipping cost is crazy right now how do we maximize what we put on the boat or in in you know in in in the cargo in the in on

freight um and how do we um you know what what money are we going to make it if i do all of this if i make this print run and it all sells how much money am i going to make at the end of the day so like it's critical you have to think about it you have to understand what it's all worth at the end of the day because you can kick all this off and then again like numerous times folks say oh well you know i ended up having to pay money or or whatever right like so it's worth understanding let's go through it so we have our game we have the quantity and again in this case our objective um and and all these numbers have been adjusted and tuned they're not actually arc jessica did a nice job of making this not already not our numbers spreadsheet but the time we were we were using it we were looking at how we could make a maximize what was in a 20-foot container that's what we wanted to do so i i me you know and and that's by cbm i'll get there in a second but basically thinking about what we were going to print was around how do we min max that space i'm going to talk about sales in a second after i get through this but that's the idea so you have a quantity and again super neat if i change this so let's go to medium game c price per unit at three thousand eight sixty but if i change this to two thousand dude that updates against this table isn't that neat and if i go under like one thousand on small game a it knows that threshold i think if i go to even if i go to 2 200 it's gonna that

let me go to three three three hundred it's gonna give me 375 right because you don't hit that next threshold anyway so what you're going to find out is the quantity the cost per unit and then how much it's just going to cost to print um this isn't really taking into account stuff like this is a lot of reprints for us but not you know sunk costs like molds or that kind of thing that's covered elsewhere this is the pure unit to unit manufacturing cost right so cbm this is in red orange or whatever because what jessica ended up doing is for the purpose of this document for for folks just gave like a a ratio on size for cbm uh cubic meters by the way uh for thinking about your games this is the the common way to think about how much is going to fit you know in your car in your carton not carton why can't i think of that word i'll come back to it it'll hit me but when you shipping container thank you um and uh you know ultimately there's some a couple key things in here which i so don't i it's good shorthand but this should not be shorthand this should not be shorthand you need to understand and find out from your manufacturer exactly how much these things are sized to and then you can multiply from there but you it shouldn't be a rate some guesswork it should be exacting you're going to be talking about two ways of shipping either palletized or floor loaded floor

loaded is basically all the boxes just loaded in to the shipping container and your cbm is basically you know a factor of you know your the size of your cartons and your boxes palletize is a little different you need room for the pallets and all those things um and and it'll be heavier too and so really when when i look at this on our sheet this is like exacting um and we have some reference points that we use but for shorthand basically you're going to want to know this because this is what how you're going to determine what fits in your in your ship in your shipping container so we have you know a percentage a ratio could be helpful it's worth knowing it's always going to add up to 100 and then shipping cost so this number here is based on this number here let me use a different color here just to let's go with a blue so if if if you want to think about like hey what if it cost what if a 20 foot container actually cost 25 000 what would that mean that's what it's going to be it's the cost per title and how much it would cost what if it was 45 000 right um boom it'd get bigger the um target cbm isn't um actually using this this is more of an eyeball thing hey this is how much we're going to have in this kind of situation you know what do we want it what do we want to go from there and again floor loaded bot you're going to have different different ways of thinking about it and different numbers you want to use here you should certainly get latest numbers

or different target numbers that you'd like but you can sort of think about it but again this is helping me understand what does it mean to ship all the stuff if shipping costs twenty thousand dollars for the for not for manufacturing for just doing this the other thing isn't here is like this is sort of assuming shipping to one location if you're doing multiple locations and other things like that you have to take that into account you can expand this as you needed so anyway so then we have the rev per unit so this is going to be different based on how you sell your titles um you know this is based on different price points um but you know jessica just inputted some things in here here's what i would say this number should be the sort of largest worst case sales volume that you get that is to say if most of my titles are sold into distribution and i get 40 of msrp this number should be 40 of msrp if if you say but wait every once in a while you sell direct or every once a while you're selling at conventions and it's better than 40 it's like sure but you might as well get the number on the lowest amount because you're trying to sell volume and then you can always do better so i like to think of this as the base um you know if you're using a consolidator it's less than 40 like an impressions or a psi so there's all different ways to think about it i'll talk i'll talk about sort of numb percent sales but this is a good way to think about that again are there places you're going to do better than um

this number probably also for example on our end we have herbaceous pocket edition which does not get sold at retail so we don't have to use that number we use just like direct sales number anyway so now this is the magic it's gonna basically say hey if you sell every copy that you printed at that amount you're gonna make this much money this is the maximum amount of money give or take some of those other things you're gonna make if you sell everything this is hugely important hugely important if i sell every copy how much it's not a digital game and a mobile game right like that's i'm used to a world where you can you you you as you sell more things digitally you can just sell more things but that world is not board game manufacturing board game manufacturing is you only printed this many so you can only sell that you know this is your maximum um again based on this percentage so what were your expenses so this is adding together the cost of manufacturing the cost is shipped per title um and then on the other other end of that you have a subtitle a subtotal subtotal so in this case you know if we stop there you're looking at generating sixty seven thousand dollars um but hold on perhaps you have some back-end deals and i think again here uh jessica put in some just different royalty rates you know can be different percentages um just make this specific so just be clear and she obfuscated and changed a whole bunch of numbers but like on our end all

these games have names and they all have their own deals and so i know when herbaceous is sold the royalties i owe on herbaceous versus something else versus something else so you should know your exact royalties and then they should be included here because your expectation is you're going to pay those but either on print or after they're sold it's some amount of money that you're going to have to spend now this next column is sunk cost now i often use this spreadsheet when thinking about reprints but this is something you're going to want to think about when you're thinking about first-time prints and this is where you're going to see things like was there any development cost art cost you know molds that kind of thing you would add that as well again if if this is your first time printing through and and that's going to really eat into what your cost is now depending on how you do this and how you want to think about it you could say the kickstarter covered all of that and this is really um sort of we're going to assume it's zero in this case but if it's if it's a title that's skipping kickstarter um it's super relevant um and so after and you might have a title uh here for example this last thing this other item uh in our case we're making a uh retailer um sort of shipping stand with you know like a a display so that we're not selling it actually so in this case you know it's just a loss as part of a marketing retailer program right but you know it's worth knowing the main thing i'd call out here when you're thinking about this that you really want to keep in mind and think about

is look you might you know if i saw a hundred percent of what i'm going to print at the end of the day with all those other costs and you know as written here i'm going to make 50 grand i will say it's worth note that's making 50 grand on you know 90 grand of expenses right like you know it's it's a lot of of you know it's not the greatest multiplier because you have to print everything um you know and and that's where this capital when anyone even when jamie stegmeier stone meyer games talks about having you know all this all this expense manufacturing expenses it's this kind of thing it's like yeah we had to sprint 200 000 and after we print everything we only make 250 000 or maybe in his case 400 000 whatever um the other thing is you might not sell all of it so what you might want to do is say like okay well what happens if i only sell 75 of what i print well suddenly you know that might not look as good right like suddenly if i if i only sold that many uh this isn't it's not wait this isn't going to work the way i want exactly hold on that didn't work if i didn't sell let's just assume that my expenses are the same um my royalties see the royalties would change i mean you can do your math but like and i don't know why it's giving me a hard time but like the lose thing would just be like oh hey the diff here is you know let's just do the easy one here for me i'm actually going to remove all this but

um if we just say this minus this right 38 000 and then this minus 38 000 is like you know i mean this is the kind of thing you just want to be thinking about right so like i didn't go over royalties and stuff but like very quickly if i only send sell 75 of what i thought it was going to sell and the rest like literally don't sell then it's only 15. so if i sell 50 if if this 5 000 unit print i mean it's going to be a title by title thing but like if this is a dud and it's miscalculated you're going to be hurting so that's why this math is so important so important two last things so one jessica put some terms in here and what we we typically use when we talk about here we don't have four loaded or palletized um but that's something you'd want to be thinking about also you might not pay for you know if you're lcl if you're sharing a container with somebody else it might not work that way either i mean this is meant to give you an idea the other thing that we have here is a sales calculator so so that's not a calculator it's just a tracker sheet we have a like way more robust year-over-year one but this is as you're getting it to be a bigger company you can start looking at or having more sales how much product you sell year over year and what your sales trends are and what they happen and where you have big sales and small sales and all that kind of stuff as you're thinking about new products so for example game a here you know and these are all should all update live so if i were to make this 400 it'll update this little graph

if you need a graph but basically you're looking at your title and you're saying hey here's what we've done in the past you know here's what we have in stock we've got 200 copies in stock and you know we think in the next two or three years we're gonna we're gonna sell 5500 based on historic data well in that case this is a no-brainer i should reprint this title um because i'm totally out of stock and i expect there to be sales frankly if if you're in this situation it means you should have printed stock you're behind you should have already reprinted because you're gonna you know in my case in the case of herbaceous it's gonna be out of stock for a while um here's a different example well here's a title that we're looking at we think is going to have 500 sales over the next two years um but or it still has 800 in stock so in this case it doesn't really make sense to reprint because this is going to last this year's already you know here's another case where perhaps here's an example where sales is higher than stock but not by a ton and so given this ratio it'd be like well am i going to print is it going to be a thousand unit print well you might look back and be like well at a thousand unit print you know there's very little margin and if i'm not 100 confident that it's going to sell it's not worth doing that kind of thought and then then you have these maybes then you have these places where you know you have a lot of stock sales are pretty good but isn't it good enough

and you know the the discussion this debate typically turns into um is it going to look like this where it's growing and i don't want to be in a situation where i don't have stock available or is it going to look something more like this where it's shrinking and that's the challenge so anyway um look you can make this your own so if you go to file it's um make a copy you make a duplicate you can edit it and do whatever you want with it i you know and and and to be fair we have like a whole swarm of other spreadsheets and things we use as well but i feel like this is a pretty good one to just hone in on like what it what it takes like what you should be thinking about in terms of expenses and and and freight and and and really does it make sense to print this what does it make sense to print these many copies you know what do i what is my sales prediction this is sort of you know a lot to do with sort of reprints but i've i used to have this with just three titles or two titles or one title so it's not a terrible chart even if you're smaller we're now getting into some like mid publisher range stuff so anyway hopefully that was helpful again let us know if you'd like to see any additional information thanks bye hey everybody edo here and thanks for watching gaming with edo reviews over here on this playlist league and insider videos over here on this one subscribe share all that good

stuff but most importantly play some great games thanks bye

Progress saved