Easyscriber engrave attachment for Hypertherm torch's
 

Excel Pricing Worksheet

Share tips and tricks you know of in this forum. Plasma cutting, material handling, metal finishing, marketing, or anything that you feel is helpful.
Post Reply
mdwalker
Elite Contributing Member
Elite Contributing Member
Posts: 445
Joined: Fri Nov 14, 2008 10:20 am

Excel Pricing Worksheet

Post by mdwalker » Fri Mar 15, 2013 11:11 am

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

You do not have access to download this dxf file.
Become a Contributing Member to gain access to the thousands of files shared by our members. Click Here


urbnsr
Posts: 329
Joined: Wed Dec 26, 2012 6:13 am

Re: Excel Pricing Worksheet

Post by urbnsr » Fri Mar 15, 2013 11:39 am

Thank you, Danny. I appreciate this.
Paul

kbenz
Posts: 424
Joined: Sun Oct 31, 2010 1:26 pm
Location: Kannapolis,NC
Contact:

Re: Excel Pricing Worksheet

Post by kbenz » Tue May 28, 2013 10:43 pm

thanks for putting this back up, I use it alot. my computer died and was having a hard time finding it again.........
CandCNC
Mach3
Sheetcam
Draftsight
Hypertherm65 machine torch
Millermatic 210
Spoolmatic 30a w/ WC-115a
Miller Bobcat 225
http://benzweldingandfabrication.com/
https://www.facebook.com/pages/Benz-Wel ... 468?ref=hl

JakeSM
Posts: 2
Joined: Tue Oct 08, 2013 7:13 pm

Re: Excel Pricing Worksheet

Post by JakeSM » Tue Oct 08, 2013 9:34 pm

Thank You Danny,

Very helpful
Jake

User avatar
Limitless
Posts: 28
Joined: Wed Aug 27, 2014 12:30 pm
Location: Jogues, Ontario, Canada
Contact:

Re: Excel Pricing Worksheet

Post by Limitless » Mon Sep 15, 2014 11:56 am

Thanks for that. I am new to this so it will be very helpful.

Mel
Mel & Jess
Owner/Operator
Limitless Metal & Wood Custom Design
Torchmate 3 - 5x10 - Plasma/Router/Plate Marker
Hypertherm Powermax 85
Torchmate Cad

User avatar
trtilton61
Posts: 58
Joined: Mon Jul 15, 2013 4:45 pm

Re: Excel Pricing Worksheet

Post by trtilton61 » Mon Sep 15, 2014 8:22 pm

Thanks for the updated worksheet.
Precision Plasma HDSE-4x8
CandCNC Bladerunner dragon cut
Hypertherm 65
Mach3
sheetcam

User avatar
d2day
Elite Contributing Member
Elite Contributing Member
Posts: 112
Joined: Wed Sep 17, 2014 7:59 pm

Re: Excel Pricing Worksheet

Post by d2day » Thu Sep 18, 2014 7:42 pm

Thank You for the spreadsheet. I am new to plasma cutting and I am sure it will be helpful. :mrgreen:

LakeCruiser
Posts: 170
Joined: Tue Jun 08, 2010 5:51 pm

Re: Excel Pricing Worksheet

Post by LakeCruiser » Fri Oct 03, 2014 4:49 pm

Thanks Danny,
Homemade 36X36 table
Can go from Plasma to Router in 10 Minutes
American Modified Chinese Controller
Proma Electronics THC
Cambam and Mach3
Longevity Forcecut 40D
Miller 211 MIG Welder

davek0974
Posts: 743
Joined: Wed Aug 13, 2014 8:30 am
Location: Hertfordshire, England
Contact:

Re: Excel Pricing Worksheet

Post by davek0974 » Thu Oct 09, 2014 12:50 pm

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.

odha
Posts: 155
Joined: Wed Nov 20, 2013 10:34 am
Location: Louisiana

Re: Excel Pricing Worksheet

Post by odha » Fri May 22, 2015 12:46 pm

thanks - much appreciated!

[email protected]
Posts: 19
Joined: Wed Apr 27, 2016 8:47 am
Location: Assiniboia,Canada

Re: Excel Pricing Worksheet

Post by [email protected] » Thu Oct 06, 2016 10:43 pm

Book1.xlsm
Here is another One
Enable your macros
I do this also for a Hobby
Enjoy

You do not have access to download this dxf file.
Become a Contributing Member to gain access to the thousands of files shared by our members. Click Here


CajunPlasma
Posts: 1
Joined: Wed Oct 12, 2016 9:03 am

Re: Excel Pricing Worksheet

Post by CajunPlasma » Wed Oct 12, 2016 10:32 am

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!

[email protected]
Posts: 19
Joined: Wed Apr 27, 2016 8:47 am
Location: Assiniboia,Canada

Re: Excel Pricing Worksheet

Post by [email protected] » 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%"

[email protected]
Posts: 19
Joined: Wed Apr 27, 2016 8:47 am
Location: Assiniboia,Canada

Re: Excel Pricing Worksheet

Post by [email protected] » Thu Oct 13, 2016 10:15 pm

PS
The only dumb question is the one that is never asked!!

User avatar
tnbndr
Elite Contributing Member
Elite Contributing Member
Posts: 1422
Joined: Mon Jan 09, 2012 4:30 pm
Location: New Berlin, WI
Contact:

Re: Excel Pricing Worksheet

Post by tnbndr » Mon Oct 17, 2016 7:01 am

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
Dennis
LDR 4x8, Scribe, DTHCIV
PM45
DeVilbiss Air America 6.5HP, 80Gal., 175psi, Two Stage
[email protected], [email protected]
Miller 211
RW 390E Slip Roll
AutoCAD, SheetCAM, Mach 3
https://www.facebook.com/ikescreations?ref=hl
http://ikescreations.com

[email protected]
Posts: 19
Joined: Wed Apr 27, 2016 8:47 am
Location: Assiniboia,Canada

Re: Excel Pricing Worksheet

Post by [email protected] » Sat Oct 22, 2016 7:03 pm

You need to enable your macros in excel

User avatar
tnbndr
Elite Contributing Member
Elite Contributing Member
Posts: 1422
Joined: Mon Jan 09, 2012 4:30 pm
Location: New Berlin, WI
Contact:

Re: Excel Pricing Worksheet

Post by tnbndr » Mon Oct 24, 2016 7:51 am

You need to enable your macros in excel
Did that already!
Dennis
LDR 4x8, Scribe, DTHCIV
PM45
DeVilbiss Air America 6.5HP, 80Gal., 175psi, Two Stage
[email protected], [email protected]
Miller 211
RW 390E Slip Roll
AutoCAD, SheetCAM, Mach 3
https://www.facebook.com/ikescreations?ref=hl
http://ikescreations.com

[email protected]
Posts: 19
Joined: Wed Apr 27, 2016 8:47 am
Location: Assiniboia,Canada

Re: Excel Pricing Worksheet

Post by [email protected] » Tue Oct 25, 2016 10:38 am

I will check it out

[email protected]
Posts: 19
Joined: Wed Apr 27, 2016 8:47 am
Location: Assiniboia,Canada

Re: Excel Pricing Worksheet

Post by [email protected] » Wed Oct 26, 2016 7:49 pm

CNC Plasma Priceer.xlsm
Here is the Updated/Corrected Version

You do not have access to download this dxf file.
Become a Contributing Member to gain access to the thousands of files shared by our members. Click Here


User avatar
tnbndr
Elite Contributing Member
Elite Contributing Member
Posts: 1422
Joined: Mon Jan 09, 2012 4:30 pm
Location: New Berlin, WI
Contact:

Re: Excel Pricing Worksheet

Post by tnbndr » Thu Oct 27, 2016 8:42 am

That works.
Thanks for posting, always like pricing options. This one is pretty straight forward.
Dennis
LDR 4x8, Scribe, DTHCIV
PM45
DeVilbiss Air America 6.5HP, 80Gal., 175psi, Two Stage
[email protected], [email protected]
Miller 211
RW 390E Slip Roll
AutoCAD, SheetCAM, Mach 3
https://www.facebook.com/ikescreations?ref=hl
http://ikescreations.com

Dooggins1
Posts: 13
Joined: Sun Jul 23, 2017 9:16 pm

Re: Excel Pricing Worksheet

Post by Dooggins1 » Mon Nov 06, 2017 9:18 pm

Hey Phil how do you add the mark up for material? Thanks

Post Reply