JLS Design 39 Posted September 6, 2017 So I've been doing more research around my area, regarding pricing structures, to calculate, material cost, labor cost, overhead and profit. I found this calculator on google, and watched a video of a CEO explaining how this worked. I modified it a bit, and was able to get it to work out pretty decently. However, the only thing I have not figured out is a quantity break. In other words, if 1 decal is $5.00, then 20 should be $3.50, or something along those lines. If anyone who is a bit more skilled than I at excel, take a poke at it, and see if you can figure the formula to get that to work. OR if nothing else, anyone is welcome to use this sheet to help them quote out jobs if needed. Love to hear you're feedback too, what you all think about it. Vinyl Quote & Sale Price.xls Share this post Link to post Share on other sites
darcshadow 1,626 Posted September 6, 2017 Quantity discounts only make sense if it is actually easier, faster, or cheaper to make multiple items. With vinyl cutting since so much of the cost is your time weeding and preparing and that won't really change no matter how many you do a quantity discount doesn't really work. Some designs are rather simple and can be easily grouped in a way that weeding and preparing can go quicker so you could apply a discount then, but it would be determined by your time rather than anything else. Now if you're printing it and you just hit go, a decent discount would be reasonable, since you'll only do a bit more work, but produce a lot more quantity. On the spreadsheet, personally I'd change it so that your labor cost are cost per hour rather than minute. I'd also rework the material cost so that you simply enter the size and cost of the roll your using, the length of vinyl to be used for the decal, and the qty. This way you factor in the cost of the waste vinyl if the design doesn't fill the width, it also adds a little bonus if you can get multiple copies within the width. But unless you're working with expensive vinyl and large designs the material cost is usually pretty small and a very small percentage of the actual cost. Share this post Link to post Share on other sites
Primal Decals 621 Posted September 6, 2017 Try @busterbay or @buster . one of them helped me with modding mine to hold more info for my calc i had. But i know the name had buster in it lol. Share this post Link to post Share on other sites
carwash 47 Posted November 8, 2017 Does anyone have a pricing calculator that they can post up that they are happy with overall and incorporates all the changes needed on this one? I'm looking for one as well, I always seem to underquote my jobs. I hate leaving money on the table. Share this post Link to post Share on other sites
Primal Decals 621 Posted November 9, 2017 @carwash...the only one i have is it tells you what it costs YOU in just material only to make something ( width x length ) .( that includes vinyl and transtape) and now i have HTV on my list....... From there i just make my cost for selling for what i feel is fair and still make good money.Helps me a lot.. Send pm If interested. Share this post Link to post Share on other sites