Excel Pricing Worksheet

Share tips and tricks regarding cut cutting, material handling, metal finishing, marketing, or anything you find helpful.
Post Reply
mdwalker
3.5 Star Elite Contributing Member
3.5 Star Elite Contributing Member
Posts: 524
Joined: Fri Nov 14, 2008 10:20 am

Excel Pricing Worksheet

Post 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

You currently do not have access to download this file.
To gain download access for DXF, SVG & other files Click Here

Danny Walker
Walker Manufacturing
Tishomingo, Oklahoma USA
www.walkermfg.net
urbnsr
3 Star Member
3 Star Member
Posts: 329
Joined: Wed Dec 26, 2012 6:13 am

Re: Excel Pricing Worksheet

Post by urbnsr »

Thank you, Danny. I appreciate this.
Paul
kbenz
3 Star Elite Contributing Member
3 Star Elite Contributing Member
Posts: 465
Joined: Sun Oct 31, 2010 1:26 pm
Location: Kannapolis,NC
Contact:

Re: Excel Pricing Worksheet

Post by kbenz »

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
Hypertherm 65 machine torch
Millermatic 210
Passport plus
Spoolmate 150
Miller Bobcat 225
http://benzweldingandfabrication.com/
https://www.facebook.com/pages/Benz-Wel ... 468?ref=hl
JakeSM
1/2 Star Member
1/2 Star Member
Posts: 2
Joined: Tue Oct 08, 2013 7:13 pm

Re: Excel Pricing Worksheet

Post by JakeSM »

Thank You Danny,

Very helpful
Jake
User avatar
Limitless
1.5 Star Member
1.5 Star Member
Posts: 30
Joined: Wed Aug 27, 2014 12:30 pm
Location: Jogues, Ontario, Canada
Contact:

Re: Excel Pricing Worksheet

Post by Limitless »

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
2 Star Member
2 Star Member
Posts: 63
Joined: Mon Jul 15, 2013 4:45 pm

Re: Excel Pricing Worksheet

Post by trtilton61 »

Thanks for the updated worksheet.
Precision Plasma HDSE-4x8
CandCNC Bladerunner dragon cut
Hypertherm 65
Mach3
sheetcam
User avatar
d2day
2.5 Star Member
2.5 Star Member
Posts: 114
Joined: Wed Sep 17, 2014 7:59 pm

Re: Excel Pricing Worksheet

Post by d2day »

Thank You for the spreadsheet. I am new to plasma cutting and I am sure it will be helpful. :mrgreen:
LakeCruiser
2.5 Star Elite Contributing Member
2.5 Star Elite Contributing Member
Posts: 204
Joined: Tue Jun 08, 2010 5:51 pm

Re: Excel Pricing Worksheet

Post by LakeCruiser »

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
4 Star Member
4 Star Member
Posts: 764
Joined: Wed Aug 13, 2014 8:30 am
Location: Hertfordshire, England
Contact:

Re: Excel Pricing Worksheet

Post 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.
odha
2.5 Star Member
2.5 Star Member
Posts: 170
Joined: Wed Nov 20, 2013 10:34 am
Location: Louisiana

Re: Excel Pricing Worksheet

Post by odha »

thanks - much appreciated!
Phil@rvc
1 Star Member
1 Star Member
Posts: 19
Joined: Wed Apr 27, 2016 8:47 am
Location: Assiniboia,Canada

Re: Excel Pricing Worksheet

Post by Phil@rvc »

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

You currently do not have access to download this file.
To gain download access for DXF, SVG & other files Click Here

CajunPlasma
1/2 Star Member
1/2 Star Member
Posts: 1
Joined: Wed Oct 12, 2016 9:03 am

Re: Excel Pricing Worksheet

Post by CajunPlasma »

Thanks for the excel spreadsheets guys! Much appreciated! I'm just getting into plate cutting and this will help a lot. Phil@rvc, 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!
Phil@rvc
1 Star Member
1 Star Member
Posts: 19
Joined: Wed Apr 27, 2016 8:47 am
Location: Assiniboia,Canada

Re: Excel Pricing Worksheet

Post by Phil@rvc »

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%"
Phil@rvc
1 Star Member
1 Star Member
Posts: 19
Joined: Wed Apr 27, 2016 8:47 am
Location: Assiniboia,Canada

Re: Excel Pricing Worksheet

Post by Phil@rvc »

PS
The only dumb question is the one that is never asked!!
User avatar
tnbndr
4.5 Star Elite Contributing Member
4.5 Star Elite Contributing Member
Posts: 1668
Joined: Mon Jan 09, 2012 4:30 pm
Location: New Berlin, WI
Contact:

Re: Excel Pricing Worksheet

Post 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
Dennis
LDR 4x8, Scribe, DTHCIV
Hypertherm PM45, Macair Dryer
DeVilbiss Air America 6.5HP, 80Gal., 175psi, Two Stage
16.9scfm@100psi, 16.0scfm@175psi
Miller 215 MultiMatic
RW 390E Slip Roll (Powered)
AutoCAD, SheetCAM, Mach 3
http://ikescreations.com
Phil@rvc
1 Star Member
1 Star Member
Posts: 19
Joined: Wed Apr 27, 2016 8:47 am
Location: Assiniboia,Canada

Re: Excel Pricing Worksheet

Post by Phil@rvc »

You need to enable your macros in excel
User avatar
tnbndr
4.5 Star Elite Contributing Member
4.5 Star Elite Contributing Member
Posts: 1668
Joined: Mon Jan 09, 2012 4:30 pm
Location: New Berlin, WI
Contact:

Re: Excel Pricing Worksheet

Post by tnbndr »

You need to enable your macros in excel
Did that already!
Dennis
LDR 4x8, Scribe, DTHCIV
Hypertherm PM45, Macair Dryer
DeVilbiss Air America 6.5HP, 80Gal., 175psi, Two Stage
16.9scfm@100psi, 16.0scfm@175psi
Miller 215 MultiMatic
RW 390E Slip Roll (Powered)
AutoCAD, SheetCAM, Mach 3
http://ikescreations.com
Phil@rvc
1 Star Member
1 Star Member
Posts: 19
Joined: Wed Apr 27, 2016 8:47 am
Location: Assiniboia,Canada

Re: Excel Pricing Worksheet

Post by Phil@rvc »

I will check it out
Phil@rvc
1 Star Member
1 Star Member
Posts: 19
Joined: Wed Apr 27, 2016 8:47 am
Location: Assiniboia,Canada

Re: Excel Pricing Worksheet

Post by Phil@rvc »

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

You currently do not have access to download this file.
To gain download access for DXF, SVG & other files Click Here

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

Re: Excel Pricing Worksheet

Post by tnbndr »

That works.
Thanks for posting, always like pricing options. This one is pretty straight forward.
Dennis
LDR 4x8, Scribe, DTHCIV
Hypertherm PM45, Macair Dryer
DeVilbiss Air America 6.5HP, 80Gal., 175psi, Two Stage
16.9scfm@100psi, 16.0scfm@175psi
Miller 215 MultiMatic
RW 390E Slip Roll (Powered)
AutoCAD, SheetCAM, Mach 3
http://ikescreations.com
Dooggins1
1 Star Member
1 Star Member
Posts: 13
Joined: Sun Jul 23, 2017 9:16 pm

Re: Excel Pricing Worksheet

Post by Dooggins1 »

Hey Phil how do you add the mark up for material? Thanks
Welder Kenny
2 Star Member
2 Star Member
Posts: 70
Joined: Wed May 15, 2019 8:12 am

Re: Excel Pricing Worksheet

Post by Welder Kenny »

this a great spread sheet to work from, Up here in Northern Michigan people look at me like I'm insane, they always want it done cheaper bad thing is 45 min away we have a company that has a laser and they are cutting things for a fraction of my cost..So I've had to modify the spreadsheet a little to work for me I do quality over quantity. still a great spreadsheet.
James79
1 Star Member
1 Star Member
Posts: 11
Joined: Fri Jan 31, 2020 2:56 pm

Re: Excel Pricing Worksheet

Post by James79 »

I found this the other day, and thanks a lot to the OP for it. I hope you don't mind but I've adapted it to metric and am happy to share if that's allowed / of interest to anyone?
mdwalker
3.5 Star Elite Contributing Member
3.5 Star Elite Contributing Member
Posts: 524
Joined: Fri Nov 14, 2008 10:20 am

Re: Excel Pricing Worksheet

Post by mdwalker »

James79 wrote: Thu Feb 27, 2020 1:31 pm I found this the other day, and thanks a lot to the OP for it. I hope you don't mind but I've adapted it to metric and am happy to share if that's allowed / of interest to anyone?
Feel free to modify it any way you wish and share updated version.
Danny Walker
Walker Manufacturing
Tishomingo, Oklahoma USA
www.walkermfg.net
James79
1 Star Member
1 Star Member
Posts: 11
Joined: Fri Jan 31, 2020 2:56 pm

Re: Excel Pricing Worksheet

Post by James79 »

This should be it. Sorry its taken so long to upload, time is running away at the moment!

There is a tab called 'OMS" - this is my steel supplier. The idea being that I would be able to update the prices centrally rather than modify the front sheet. The front should now run in metric units and GBP.

Feel free to modify / comment etc

James

You currently do not have access to download this file.
To gain download access for DXF, SVG & other files Click Here

Post Reply

Return to “Tech Tips From Other Members”