[brice]

I've created a spreadsheet to help you price your heat pressed vinyl garments. It includes basic instructions and a sample pricing. It allows you to calculate/estimate your cost of doing business and use this very important number to get an accurate product cost.

The rules of use are simple. If you find a problem you post the fix to the spreadsheet here. If you improve the spreadsheet, you post the spreadsheet here for everyone to use. If you can't abide by the simple rules, don't use it.

Let me know if you have any suggestions. I attached a version compatible with most versions of Excel.

 

[VernsVinylGrafx]

awesome job!

Im new to the tshirt "biz" ive been doing vinyl decals for almost 2 yrs now. i created a complete pricing "tool" in excel for my own use. i was thinking about making one for tshirts but had no idea where to begin. this helps out A LOT. Im sure ill be tweaking it haha. I will most def post any changes!

Thanks again!!!

 

[wormil]

heres a link to mine. sorry if linking isnt allowed. please remove if so!

Vinyl Pricer, Calculator, Invoice

There is no link there for me, maybe because I am not a member of that forum. Perhaps you could link it directly so everyone here can reach it.

 

[kirkmansigns]

Brice, I'd suggest a couple other algorithms to find a true price. I don't see any "design time" alotted for the initial time on the PC. Also I think an A,B,C choice of complexity should be allowed for also. We usually take in account for an "A" style design that would mainly be just large text. A "B" design would have more picks with more details. A "C" design would be complex, time consuming, hard to weed layout. The price would increase with each. Just some thoughts....

 

[VernsVinylGrafx]

There is no link there for me, maybe because I am not a member of that forum. Perhaps you could link it directly so everyone here can reach it.

I will post a new thread, i wouldnt want to hijack the OP

 

[brice]

Brice, I'd suggest a couple other algorithms to find a true price. I don't see any "design time" alotted for the initial time on the PC. Also I think an A,B,C choice of complexity should be allowed for also. We usually take in account for an "A" style design that would mainly be just large text. A "B" design would have more picks with more details. A "C" design would be complex, time consuming, hard to weed layout. The price would increase with each. Just some thoughts....

Actually the spreadsheet as is does this. You can specify the unique time for each of up to 4 layers in the design. I thought about the simple, medium, complex algorithm, but I decided to ask for in put for each element for cutting and weeding. Take another look at the spreadsheet. You CAN specify unique cutting and weeding time for each part of the design.

I should tweak the sheet and allow for an overall "design"element. That is a good idea.

 

[brice]

I will post a new thread, i wouldnt want to hijack the OP

Can you post a link to your new thread here?

 

[VernsVinylGrafx]

Can you post a link to your new thread here?

yes. http://www.t-shirtforums.com/pricing-heat-transfer-heat-pressing-services/t174375.html

you also had a lil miscalculation on the garment comparison sheet. your percentage formula was wrong for the gross profit.

in the selling price cells you had =B14/(1-B11)

it should be =B14*(1+B11) otherwise when you try to put 100% you get a div by 0 error

 

[JonLauren]

We need a heat press for aour company we are looking to do some in house embroidery can someone help us out? We dont know exactly what we need but we would love some one to help! Thank You

 

[brice]

yes. http://www.t-shirtforums.com/pricing-heat-transfer-heat-pressing-services/t174375.html

you also had a lil miscalculation on the garment comparison sheet. your percentage formula was wrong for the gross profit.

in the selling price cells you had =B14/(1-B11)

it should be =B14*(1+B11) otherwise when you try to put 100% you get a div by 0 error

Actually, my calculation is correct. Gross profit and %markup are two different things. 50% GP = 100% markup. Mine is based on GP. I do need to correct the divide by 0 issue.

GP = (revenue-cost)/revenue
Therefore
Revenue=cost/(1-GP)

Take a look,at the first tab. It explains this.

Gross Profit should never be zero, therefore, my calculation would never have a divide by zero mistake.

A lot of people confuse markup and gross profit. If you try to use gross profit in your calculation, you will grossly undersell yourself.

Gross profit allows you to evaluate your business financiall. Markup does not. I can assure you major retailers price their items based on gross and net profit. They do not use markup in setting prices. Besides, do you want to tell your clients you are making a 100% markup on your sales or a mere 50% gross profit. Which sounds better from a consumer point of view?

 

[VernsVinylGrafx]

gotcha, i didnt realize that. i understand it now

 

[CHILLAHTEEZ]

Hello, do you think you can email me that spreadsheet. Im new to this and looking for pointers on my pricing. Thank you. [email protected] I tried to download it but I keep on getting error messages

 

[hill graphix]

I'm getting the error message as well. I would really like to see this calculator. I am new to the business and trying to get a handle on all the costs.

 

[hoolabaloonnm]

I cant get the calculator to open either, can you email me a copy? [email protected]
thanks

 

[CHILLAHTEEZ]

I never recieve the calculator. Just a form to full out and nothing after that

 

[lilmag212]

pls email also the spreadsheet to me i can't open the link. thanks. my email ad is [email protected]
thanks