Simple Pen Pricing Model - International Association of Penturners
     International Association of Penturners
Pens for Service Members
Support The IAP

Go Back   International Association of Penturners > Community Forums > Build the Tips, Tricks, & FAQ Files
  Forgot Password
Register FAQ Members List Search Today's Posts Mark Forums Read
Build the Tips, Tricks, & FAQ Files Have a tip, trick, or a Q&A for the FAQ? Post it here.

Logged on members can hide ads!

Welcome to!

You've found the home of The International Association of Penturners. You are currently viewing our site as a guest, which gives you limited access to view discussions, photos, and library articles.

Consider joining our community today. You'll have full access to all of our content, be able to enter our contests, find local chapters near you, and post your questions and share your experience with our members all over the world.

Membership is completely free!!

If you have any problems with the registration process or your account login, please contact us.

Closed Thread
LinkBack Thread Tools Display Modes
Old 02-19-2007, 03:27 PM   #1 (permalink)
YoYoSpin's Avatar
Join Date: Feb 2004
Location: Colorado Springs, Colorado, USA
Posts: 1,335
Photos: 559

Default Simple Pen Pricing Model

If you have Excel, dial in here and use your own numbers to play with the model:

Note that page one of this file has a similar model for bottle stopper pricing.

And, if you don't have Excel, here are the same files in pdf:
Best regards,
Ed Davidson
Colorado Springs, CO
YoYoSpin is offline   Top
Old 02-19-2007, 03:49 PM   #2 (permalink)
thewishman's Avatar
Join Date: Mar 2006
Location: Reynoldsburg, Ohio, USA.
Posts: 7,771
Photos: 0


Thanks, Ed. I have been trying to figure out pricing - pretty much guesswork and local conditions up to now. I wish I could turn 5 pens/hour.


Non Impedite Raditioni Cogitationis.
(Unencumbered by the thought process.)
Tom and Ray Magliozzi
thewishman is offline   Top
Old 02-19-2007, 03:58 PM   #3 (permalink)
Join Date: Apr 2006
Location: Billings, MT, USA.
Posts: 1,511
Photos: 0


Ed, thanks, that is very helpful. Also, I bought your closed end pen DVD from AS and it came the other day. Lots of information, I learned a lot. Great value for the price.
Billings, MT
Stevej72 is offline   Top
Old 02-19-2007, 05:03 PM   #4 (permalink)
Join Date: Jun 2004
Location: Columbus, GA, USA.
Posts: 900
Photos: 0


Thanks Ed.... that's excellent... get it?... excel lent? ... geez, I crack myself up [:D]

All kidding aside, that spreadsheet is great... thanks again [:)]
Marc Phillips
Columbus, GA
Marc Phillips is offline   Top
Old 02-19-2007, 06:28 PM   #5 (permalink)
Join Date: Jan 2005
Location: Sherwood Park, AB, Canada.
Posts: 404
Photos: 0


Thanks for sharing, Ed.'d better be careful with that sense of's getting close to being as sharp as a skew!! [:D]
Bill in Sherwood Park, Alberta
Making lots of shavings is easy...leaving something pretty behind is harder.
wicook is offline   Top
Old 02-19-2007, 07:24 PM   #6 (permalink)
Rudy Vey's Avatar
Join Date: Jan 2004
Location: South Plainfield, NJ, USA.
Posts: 2,011
Photos: 14


this is great!! I tried it for a number of my pen types I make and sell a lot (Barons, FT's and Slimline) and I was amazed how close the different pricing calculations came to mine. I worked very well for standard wood pens, but then I used it for my Titanium pens and here the difference between the program and what I can get for them was quite large. The problem was that Titanium prices went up like hell and it is very labor intensive.
But nevertheless, I like this approach and keep a copy on my computer.
Central New Jersey
'If you lend someone $20 and never see that person again, it was probably worth it.'
Rudy Vey is offline   Top
Old 02-19-2007, 08:08 PM   #7 (permalink)
Join Date: Feb 2004
Location: Webb, AL, USA.
Posts: 896
Photos: 0


Nice job, Ed. That is a very intelligent pricing model. I am due to update my prices and will use this with a great deal of weight in the final decision. Thanks for sharing it!
Jim Lambert (Webb, AL)
IAP Shirts & Bethlehem Olivewood
woodpens is offline   Top
Old 02-19-2007, 09:22 PM   #8 (permalink)
Join Date: Feb 2007
Location: Northwest Arkansas, USA.
Posts: 62
Photos: 0


Thanks for the spreadsheet. One thing though, you show $30 per hour for your labor, unless you are paying someone else, or are incorporated, this is profit also and is taxable. If you are a self proprietor, your labor expense it taxable.
JohnLifer is offline   Top
Old 02-19-2007, 09:40 PM   #9 (permalink)
YoYoSpin's Avatar
Join Date: Feb 2004
Location: Colorado Springs, Colorado, USA
Posts: 1,335
Photos: 559


There are lots of ways to slice and dice the tax code, and that’s not really what this model is trying to address.

Everyone should feel free to change the model to accommodate their particular situation. If you’re just a hobbyist for example, with no business entity, then the direct labor rate and profit figures could be merged into one item.

For me, the model is set up so that there are two taxable entities...Davidson LatheCraft LLC pays tax on the 8% profit and I would have personal taxable income based on the $30 per hour rate that the LLC pays me.
Best regards,
Ed Davidson
Colorado Springs, CO
YoYoSpin is offline   Top
Old 02-19-2007, 10:17 PM   #10 (permalink)
Join Date: Apr 2006
Location: Plantsville, CT, USA.
Posts: 180
Photos: 2


very nice spread sheet will come in handy
Hiram33 is offline   Top
Related Content
Logged on members can hide ads
Closed Thread


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

All times are GMT -5. The time now is 05:55 PM.

Powered by vBulletin® Version 3.7.6
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.6.0

Content Copyright © 2003-2018 by, LLC; All Rights Reserved
Terms Of Service   Acceptable Use Policy