Roll Vinyl Calculator

[skaa]

Thanks for the post.  I was doing it manually with a calculator.  I can't wait to try this out. I appreciate sharing your work.   

[LockTee]

Great tool to add to the arsenal...it works great thank you very much for the time you spent putting this together for us.

[Ls Creation]

Great tool to add to the arsenal...it works great thank you very much for the time you spent putting this together for us.

Same here, nice work.Thank you.
LS

[sarconastic]

I'm glad everyone is getting good use out of it. Thanks for the compliments.

Kevin

[midsouthprosigns]

Thats awesome. Hey does it include app tape?

[sarconastic]

You can put whatever materials you want in it. It just automatically calculates the cost by the size of decal/sign etc your using. You put in the cost you pay for a roll, and the dimensions of the roll, like 24" x 10 yds, and it calculates the cost per square inch, foot and yard.

kevin

[wickedstangs]

You can put whatever materials you want in it. It just automatically calculates the cost by the size of decal/sign etc your using. You put in the cost you pay for a roll, and the dimensions of the roll, like 24" x 10 yds, and it calculates the cost per square inch, foot and yard.

kevin

Sarconastic.. Awesome



Got a couple of questions?
On your Last 2 cells #color layers and Total Cost?
# color layer = is this for one color only and if the customer want multiple items cut?
Total Cost = Total Cost of what? per inch? Not understanding

[sarconastic]

First off let me clarify one thing. the user has to enter the First 6 columns "Name of roll   Color   Supplier   Width (in)   Length(yds)   Cost of roll This data is then converted into the Cost per whatever. Once you enter your inventory. you can use the last 4 columns to get your information. You enter the length and width of your decal and the number of layers. it then tabulates the cost of the decal for you. If your using multiple colors or types.You can enter all of them on teh right, including your app tape and get a complete cost of materials summed up at the bottom of the table.

# of color layers, is the number of layers that you will use for color. Example if your decal is 2' square your dimension would be 24" x 24", it will then take that dimension and multiply it to get 576 square inches of material for one layer. If the decal is 2 layers, and your using the color uniformly across the whole decal, you can put a number 2 in this box and it will give you the cost of materials for that 1 decal with both colors. If you are say making the same decal and the second color is only covering half the decal, then you could put in 1.5 to get a correct materials calculation.

The final total is the dollar amount that you have invested in the materials. This is based off of the data you enter in the roll dimensions and costs of rolls. This stakes the number of square inches in based on the Length and width, then multiplies it by the "Cost Sq in" to give you a dollar amount. Using line one of your table I'll break it down for you.

it takes  12" x 12" == 144 sq in. it then takes 144 x "Cost Sq in" which is .00243 which equals $.34992 per layer. you then have 3 layers, so it triples this which totals to $1.04976. the program rounds it off and you have you cost for that part of the decal.

You would also want to figure your cost for your application tape as well, to get a true estimate. You can enter any roll stock into this table and use it to calculate expenses. This is meant to be a tool to help people figures estimates. and to do a proper estimate you have to know what you have invested in materials. A prime example would be that you normally use Oracal 651 for most decals. You get a nice Commercial vehicle job and need to buy what the customer wants 3m cast vinyl. Your Oracal runs you $23 a roll, the 3m runs $90. That's more than three times the amount. SO if you bid a job not knowing the cost of this stuff and being able to figure it you will lose your butt on that job. The 3m costs you about $1.50 a square foot where the Oracal is only $.35. on an 8 sq ft job that's $36 for the 3m and $8.40 for the Oracal.

Hop that helps.

Kevin

[ViciousVinyl]

Thanks a ton for all the hard work.  I know this is going to be one of my handiest resources! 

[tshirtn00b]

I use this table every day - it's awesome.

[JoeDirt]

thanks

[Z]

Sarconastic,
                   This is super  ! It takes the pricing "quandry" down a peg for those of us who; like me, already struggle to know where to put pricing. Great job and thanks for sharing! 

Z

PS:
       I have a basic understanding of creating spreadsheets and feel pretty sure that this could also be used to track/update inventory by adding a few cells with the proper functions embedded in them. I may play around with it when I have time just to see what I can come up with. Thanks again so much!

[sarconastic]

I whipped that out one evening in about an hour, I have always intended to go back and make it forms based, but haven't had the time to get back to it. Feel free to work with it and we could collaborate on it. I'm pretty good with the formulation side of things.

I wanted to do something that is more Access database based, but a lot less people have that software since it's not part of the Office Basic installation.

Kevin

[manwayvan]

I am working on a visual basic program for vinyl calc and mark up. It is going to be laid out just like signexpert's free calculators.. The problem I am running into is I do not know the calculations that they are using for the mathematics. If someone could provide me with industry markups or something like that then I can have us a program that will do invoicing, quotes along with pricing for each substrate material.

[Brandon_Davis]

This is a great post... You guys really make this board valuable! Amazing tool.