It is currently Thu Dec 14, 2017 9:28 pm

 

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.
mdwalker
Elite Contributing Member
Elite Contributing Member
Posts: 421
Joined: Fri Nov 14, 2008 10:20 am

Excel Pricing Worksheet

Postby 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: 318
Joined: Wed Dec 26, 2012 6:13 am

Re: Excel Pricing Worksheet

Postby urbnsr » Fri Mar 15, 2013 11:39 am

Thank you, Danny. I appreciate this.
Paul

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

Re: Excel Pricing Worksheet

Postby 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

Postby JakeSM » Tue Oct 08, 2013 9:34 pm

Thank You Danny,

Very helpful
Jake

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

Re: Excel Pricing Worksheet

Postby Limitless » Mon Sep 15, 2014 11:56 am

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

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

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

Re: Excel Pricing Worksheet

Postby 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: 100
Joined: Wed Sep 17, 2014 7:59 pm

Re: Excel Pricing Worksheet

Postby 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
Elite Contributing Member
Elite Contributing Member
Posts: 166
Joined: Tue Jun 08, 2010 5:51 pm

Re: Excel Pricing Worksheet

Postby 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: 736
Joined: Wed Aug 13, 2014 8:30 am
Location: Hertfordshire, England
Contact:

Re: Excel Pricing Worksheet

Postby 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: 135
Joined: Wed Nov 20, 2013 10:34 am
Location: Louisiana

Re: Excel Pricing Worksheet

Postby 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

Postby [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

Postby 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

Postby [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

Postby [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: 1363
Joined: Mon Jan 09, 2012 4:30 pm
Location: New Berlin, WI
Contact:

Re: Excel Pricing Worksheet

Postby 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

Postby [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: 1363
Joined: Mon Jan 09, 2012 4:30 pm
Location: New Berlin, WI
Contact:

Re: Excel Pricing Worksheet

Postby 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

Postby [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

Postby [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: 1363
Joined: Mon Jan 09, 2012 4:30 pm
Location: New Berlin, WI
Contact:

Re: Excel Pricing Worksheet

Postby 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: 9
Joined: Sun Jul 23, 2017 9:16 pm

Re: Excel Pricing Worksheet

Postby Dooggins1 » Mon Nov 06, 2017 9:18 pm

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


Return to “Tech Tips”

Who is online

Users browsing this forum: No registered users and 1 guest