Page 1 of 1

Excel Pricing Worksheet

Posted: Fri Mar 15, 2013 11:11 am
by mdwalker
I have noticed a lot of discussion on product pricing. Here is the original Excel pricing worksheet (with a few updates and modifications) that I posted a few years back. It has made the rounds through other forums and has been modified several times by other users. Feel free to use it and to modify it to suit your needs.

Danny
Plasma Pricing.PNG

Re: Excel Pricing Worksheet

Posted: Fri Mar 15, 2013 11:39 am
by urbnsr
Thank you, Danny. I appreciate this.
Paul

Re: Excel Pricing Worksheet

Posted: Tue May 28, 2013 10:43 pm
by kbenz
thanks for putting this back up, I use it alot. my computer died and was having a hard time finding it again.........

Re: Excel Pricing Worksheet

Posted: Tue Oct 08, 2013 9:34 pm
by JakeSM
Thank You Danny,

Very helpful
Jake

Re: Excel Pricing Worksheet

Posted: Mon Sep 15, 2014 11:56 am
by Limitless
Thanks for that. I am new to this so it will be very helpful.

Mel

Re: Excel Pricing Worksheet

Posted: Mon Sep 15, 2014 8:22 pm
by trtilton61
Thanks for the updated worksheet.

Re: Excel Pricing Worksheet

Posted: Thu Sep 18, 2014 7:42 pm
by d2day
Thank You for the spreadsheet. I am new to plasma cutting and I am sure it will be helpful. :mrgreen:

Re: Excel Pricing Worksheet

Posted: Fri Oct 03, 2014 4:49 pm
by LakeCruiser
Thanks Danny,

Re: Excel Pricing Worksheet

Posted: Thu Oct 09, 2014 12:50 pm
by davek0974
Worksheet looks good, been messing with it this afternoon, converted it to metric and ??? etc :)

What I'm wondering is how to arrive at the the preset costs like pierce cost and cost per distance cut.

Design time seems easy, metal costs plus 50% is ok too.

I've tried a few figures but not happy with it yet.

I run a home micro business - garden stuff etc but also occasionally get asked to cut custom stuff and find it really hard to keep plucking figures out of the air, this sheet should help when I get the framework correct.

Re: Excel Pricing Worksheet

Posted: Fri May 22, 2015 12:46 pm
by odha
thanks - much appreciated!

Re: Excel Pricing Worksheet

Posted: Thu Oct 06, 2016 10:43 pm
Book1.xlsm
Here is another One
Enable your macros
I do this also for a Hobby
Enjoy

Re: Excel Pricing Worksheet

Posted: Wed Oct 12, 2016 10:32 am
by CajunPlasma
Thanks for the excel spreadsheets guys! Much appreciated! I'm just getting into plate cutting and this will help a lot. [email protected], I have a question about your spreadsheet (I hope you don't think it's a dumb question).... GST & PST. What do those blocks stand for in your spreadsheet? Thank you in advance!

Re: Excel Pricing Worksheet

Posted: Thu Oct 13, 2016 10:14 pm
In Canada we have two taxes
Provincial Sales Tax
Goods and Services Tax
Nice EH??
LOL
If you have no Taxes Then those Blocks Should be "0%"

Re: Excel Pricing Worksheet

Posted: Thu Oct 13, 2016 10:15 pm
PS
The only dumb question is the one that is never asked!!

Re: Excel Pricing Worksheet

Posted: Mon Oct 17, 2016 7:01 am
by tnbndr
So if I am reading your spreadsheet correctly the only factor that affects price is material cost, number of pierces and Mark Up???
If I change Total design time it doesn't affect Total job cost
If I change Job Time it doesn't affect Total job cost.
If I change number of pierces Total job cost changes.
If I change Design cost per minute Total job cost doesn't change
If I change Job Cost per minute Total job cost doesn't change.

Doesn't seem right. I am running Xcel 2007 on Windows 10 platform which may be the issue??

Thanks

Re: Excel Pricing Worksheet

Posted: Sat Oct 22, 2016 7:03 pm
You need to enable your macros in excel

Re: Excel Pricing Worksheet

Posted: Mon Oct 24, 2016 7:51 am
by tnbndr
You need to enable your macros in excel

Did that already!

Re: Excel Pricing Worksheet

Posted: Tue Oct 25, 2016 10:38 am
I will check it out

Re: Excel Pricing Worksheet

Posted: Wed Oct 26, 2016 7:49 pm
CNC Plasma Priceer.xlsm
Here is the Updated/Corrected Version

Re: Excel Pricing Worksheet

Posted: Thu Oct 27, 2016 8:42 am
by tnbndr
That works.
Thanks for posting, always like pricing options. This one is pretty straight forward.

Re: Excel Pricing Worksheet

Posted: Mon Nov 06, 2017 9:18 pm
by Dooggins1
Hey Phil how do you add the mark up for material? Thanks