CNC Plasma Cutting Excel Pricing Worksheet

Learn & share techniques, strategies, and experiences on marketing your plasma cut products in this forum.
User avatar
tnbndr
4.5 Star Elite Contributing Member
4.5 Star Elite Contributing Member
Posts: 1688
Joined: Mon Jan 09, 2012 4:30 pm
Location: New Berlin, WI
Contact:

Re: Excel Pricing Worksheet

Post by tnbndr »

Staying with the excel version unless some has figured a way for the program to accept input data and save it.
If this is the app you are referring to: http://plasmaspider.com/viewtopic.php?f=88&t=17569
Follow the entire thread, I had the same issues and it has to do with where Windows is storing your files. It is saving your files with changes but in a location the program is not looking for them. You have to move them to the PlasmaEst folders and overwrite.
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
RhinoRearends
1/2 Star Member
1/2 Star Member
Posts: 5
Joined: Tue Dec 12, 2017 11:03 am

Re: Excel Pricing Worksheet

Post by RhinoRearends »

Are you referring to the DD Metal Products Plasma Estimator? If you go into the File -> Setup, this should update your particular setup variations, steel prices, pierce charges, etc.

Eddie Tabor
Tabor Services
Mcallen, TX
Hazzard Engineering
1/2 Star Member
1/2 Star Member
Posts: 2
Joined: Sun Aug 05, 2018 7:26 am

Re: Excel Pricing Worksheet

Post by Hazzard Engineering »

Cheers for that, I will have a play and see how it goes.

Cheers
Hugh
GreenDeere
1/2 Star Member
1/2 Star Member
Posts: 1
Joined: Sat Sep 29, 2018 2:53 pm

Re: Excel Pricing Worksheet

Post by GreenDeere »

Hello all - we are new to the CNC world and have been surfing around for a good way to figure prices on our product. I see that an Excel spreadsheet was shared a while back, but I dont' see a link or attachment to the post. How do I go about being able to see it? I saw something that said about becoming a contributing member???

Any help is appreciated. Thanks so much.
plasmanewbie
5 Star Elite Contributing Member
5 Star Elite Contributing Member
Posts: 2746
Joined: Thu Jul 24, 2008 11:15 am

Re: Excel Pricing Worksheet

Post by plasmanewbie »

GreenDeere wrote:Hello all - we are new to the CNC world and have been surfing around for a good way to figure prices on our product. I see that an Excel spreadsheet was shared a while back, but I dont' see a link or attachment to the post. How do I go about being able to see it? I saw something that said about becoming a contributing member???

Any help is appreciated. Thanks so much.
Welcome to the site! The Excel spreadsheet is on the first post on the first page. To become a contributing member just click on your username near the upper right corner of the screen when logged in and from the drop down menu click on membership renewal.
Kenneth
1/2 Star Member
1/2 Star Member
Posts: 1
Joined: Wed Dec 05, 2018 4:06 pm

Re: Excel Pricing Worksheet

Post by Kenneth »

Thanks Danny.
ForceDesigns
1.5 Star Member
1.5 Star Member
Posts: 45
Joined: Mon Oct 22, 2018 7:08 pm

Re: Excel Pricing Worksheet

Post by ForceDesigns »

Awesome, this should help those of us just starting out a ton. Appreciate the help. Love this site. Tons of help.
Home Built 4x4 CNC Plasma Table
Ethernet Smoothstepper
C25 BOB
MiniTHC
Hypertherm Powermax 45XP
Software: Mach3 and Sheetcam, Solidworks 2019 for serious design work and Inkscape for signs
User avatar
East German
4 Star Elite Contributing Member
4 Star Elite Contributing Member
Posts: 592
Joined: Sat Jan 05, 2013 8:21 am
Location: Stapelburg Germany

Re: Excel Pricing Worksheet

Post by East German »

Thanks Danny / mdwalker ;)

Here is a Test Version:

Input in mm or inch.
Display Dollar and Euro!

Peter

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

Sorry for my language! The last English class was in 1982.

Homemade CNC Plasma-Watertable
MyPlasmCNC
Hypertherm Powermax 85
Machine Torch
Hypertherm Powermax 1100
Machine Torch
MaverickMetal
1/2 Star Member
1/2 Star Member
Posts: 1
Joined: Thu Feb 07, 2019 10:49 am

Re: Excel Pricing Worksheet

Post by MaverickMetal »

Thank you very much! This spreadsheet will help a lot with upcoming material quotes nd jobs!
Gearheadmex
2 Star Elite Contributing Member
2 Star Elite Contributing Member
Posts: 56
Joined: Sat Apr 27, 2013 9:10 pm

Re: Excel Pricing Worksheet

Post by Gearheadmex »

EZ Router APC 4 x 8
V- Carve Pro
SheetCam
Mach3
dblas
1 Star Member
1 Star Member
Posts: 12
Joined: Wed Jun 06, 2018 11:33 am

Re: Excel Pricing Worksheet

Post by dblas »

Thanks for .xls, I will play with it over the next week and see if I can get the boss to sign off on using it.

One question, how is everyone figuring up cut inches? I understand pierce points, and after a certain number on really intricate pieces, I assume folks just flat rate it?

Thanks in advance.
dblas
1 Star Member
1 Star Member
Posts: 12
Joined: Wed Jun 06, 2018 11:33 am

Re: Excel Pricing Worksheet

Post by dblas »

dblas wrote: Sun Feb 24, 2019 11:04 am Thanks for .xls, I will play with it over the next week and see if I can get the boss to sign off on using it.

One question, how is everyone figuring up cut inches? I understand pierce points, and after a certain number on really intricate pieces, I assume folks just flat rate it?

Thanks in advance.
Never mind, read further down the forum and found that Sheetcam has a report for cut inches and number of pierce points.

Thanks.
Soter907
1 Star Member
1 Star Member
Posts: 11
Joined: Mon Feb 04, 2019 9:30 pm

Re: Excel Pricing Worksheet

Post by Soter907 »

following to see if there is an updated file.
karensmc
1 Star Member
1 Star Member
Posts: 20
Joined: Mon Jan 02, 2017 3:30 pm

Re: Excel Pricing Worksheet

Post by karensmc »

How do you figure inches cut? It there somewhere in inkscape, sheet-cam or Mach that shows the total inches to be cut?
User avatar
firecapt
1/2 Star Member
1/2 Star Member
Posts: 8
Joined: Sat Oct 15, 2016 11:53 am

Re: Excel Pricing Worksheet

Post by firecapt »

karensmc wrote: Wed Mar 06, 2019 2:08 pm How do you figure inches cut? It there somewhere in inkscape, sheet-cam or Mach that shows the total inches to be cut?
You can roughly figure cut inches in InkScape by selecting the image and going to "Extensions" > "Visualize Path" > "Measure Path"
Make sure the image is made into a complete combined Path.
menu.png
box.png

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

------------------------------------------------------
Always carry a little crazy with you,
you never know when you will need it!
User avatar
Ironken
3 Star Member
3 Star Member
Posts: 322
Joined: Thu Nov 30, 2017 7:29 pm

Re: Excel Pricing Worksheet

Post by Ironken »

karensmc wrote: Wed Mar 06, 2019 2:08 pm How do you figure inches cut? It there somewhere in inkscape, sheet-cam or Mach that shows the total inches to be cut?
In sheetcam, do a jet report. The icon is in the upper left corner of the screen. Tells elapsed time, pierces and length.
karensmc
1 Star Member
1 Star Member
Posts: 20
Joined: Mon Jan 02, 2017 3:30 pm

Re: Excel Pricing Worksheet

Post by karensmc »

Ironken wrote: Wed Mar 06, 2019 6:05 pm
karensmc wrote: Wed Mar 06, 2019 2:08 pm How do you figure inches cut? It there somewhere in inkscape, sheet-cam or Mach that shows the total inches to be cut?
In sheetcam, do a jet report. The icon is in the upper left corner of the screen. Tells elapsed time, pierces and length.
Does it need to be put into a .tap file? I tried with a dxf and it didn't work.
thanks for the help?
karensmc
1 Star Member
1 Star Member
Posts: 20
Joined: Mon Jan 02, 2017 3:30 pm

Re: Excel Pricing Worksheet

Post by karensmc »

firecapt wrote: Wed Mar 06, 2019 3:36 pm
karensmc wrote: Wed Mar 06, 2019 2:08 pm How do you figure inches cut? It there somewhere in inkscape, sheet-cam or Mach that shows the total inches to be cut?
You can roughly figure cut inches in InkScape by selecting the image and going to "Extensions" > "Visualize Path" > "Measure Path"
Make sure the image is made into a complete combined Path.menu.pngbox.png
I tried this with a .svg file, but I couldn't see anything that looked like approx cut length/inches. Does it need to be
in a .dxf file or am I missing something?
thanks for the help!!!
User avatar
Ironken
3 Star Member
3 Star Member
Posts: 322
Joined: Thu Nov 30, 2017 7:29 pm

Re: Excel Pricing Worksheet

Post by Ironken »

karensmc wrote: Wed Mar 06, 2019 7:31 pm
Ironken wrote: Wed Mar 06, 2019 6:05 pm
karensmc wrote: Wed Mar 06, 2019 2:08 pm How do you figure inches cut? It there somewhere in inkscape, sheet-cam or Mach that shows the total inches to be cut?
In sheetcam, do a jet report. The icon is in the upper left corner of the screen. Tells elapsed time, pierces and length.
Does it need to be put into a .tap file? I tried with a dxf and it didn't work.
thanks for the help?
For artsy/trinket stuff, I price the item whatever I think it's worth if I charge at all. I usually only do that kind of work for friends and family. It's just not worth it for me to mess with by the time I add up CAD time, cut time, picky customers that want more than they're willing to pay for, etc. My machine makes its money on contract parts. For that, I want my machine to make $200/hr+....so I take cut time in minutes and multiply by $3.50/min, then add the price of steel with a 50% markup on the steel.

This pricing is probably low but, I nest half sheets with little waste. I do this in volume and it leaves a little meat on the bone for the customer. The beauty of going by the minute is that on thicker material, the slower cut already has a price increase built in because I charge by the minute.

To generate a "job report" work from the bottom pic up.....I can't put them in the correct order.....

-Import your drawing
-Edit Contours
-Apply jet cutting operations
-Click on the icon that looks like a pencil and paper (job report)
-choose "job summary" click OK
-your info should be on the generated page.....it is printable should your customer question time or length.

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

Re: Excel Pricing Worksheet

Post by tnbndr »

.I can't put them in the correct order.....
Just insert the images in reverse order, last one first, first one last.
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
User avatar
Ironken
3 Star Member
3 Star Member
Posts: 322
Joined: Thu Nov 30, 2017 7:29 pm

Re: Excel Pricing Worksheet

Post by Ironken »

tnbndr wrote: Thu Mar 07, 2019 5:09 pm
.I can't put them in the correct order.....
Just insert the images in reverse order, last one first, first one last.
That makes waaaay too much sense.
karensmc
1 Star Member
1 Star Member
Posts: 20
Joined: Mon Jan 02, 2017 3:30 pm

Re: Excel Pricing Worksheet

Post by karensmc »

Ironken wrote: Thu Mar 07, 2019 6:44 pm
tnbndr wrote: Thu Mar 07, 2019 5:09 pm
.I can't put them in the correct order.....
Just insert the images in reverse order, last one first, first one last.
That makes waaaay too much sense.
THANK YOU!!! It worked perfectly and gave me what I was looking for! I don't do much that I charge for as we use our
machine mostly for our parts and personal things. But it's nice if someone is willing to pay me and makes it easier for me
to give them a fair price.
User avatar
Ironken
3 Star Member
3 Star Member
Posts: 322
Joined: Thu Nov 30, 2017 7:29 pm

Re: Excel Pricing Worksheet

Post by Ironken »

karensmc wrote: Thu Mar 07, 2019 7:50 pm
Ironken wrote: Thu Mar 07, 2019 6:44 pm
tnbndr wrote: Thu Mar 07, 2019 5:09 pm
Just insert the images in reverse order, last one first, first one last.
That makes waaaay too much sense.
THANK YOU!!! It worked perfectly and gave me what I was looking for! I don't do much that I charge for as we use our
machine mostly for our parts and personal things. But it's nice if someone is willing to pay me and makes it easier for me
to give them a fair price.
You are very welcome! Glad I could help. If I remember correctly, one of the local steel shops is charging .17-.21 a linear inch and possibly .25 per pierce.
53hudson
2 Star Elite Contributing Member
2 Star Elite Contributing Member
Posts: 61
Joined: Tue Aug 22, 2017 4:22 pm

Re: Excel Pricing Worksheet

Post by 53hudson »

Thanks for a start on this Danny
MalekMetalworks
1/2 Star Member
1/2 Star Member
Posts: 5
Joined: Mon Jul 01, 2019 10:35 pm

Re: Excel Pricing Worksheet

Post by MalekMetalworks »

Hey guys! I'm new to this forum (been in the background soaking up info for a couple months) and also new to CNC plasma cutting. I have been scouring the web for pricing info. I've downloaded the excel page and the phone app to compare the two and figure out what works best/easiest for me. That has brought up a couple questions I have relating to specific price points. Sorry ahead of time for the ignorance of question number one. lol
1. what is it referring to when it says "total indexes"? (I asked a buddy that has had his table for almost a year and he was also unsure.)
2. How are you guys figure out your "Price Per Cut Inch"? Is the cost of the metal x 50% + a fee for cutting?
3. What are you guys currently charging for Design time and Price per pierce?

I haven't seen anything updated on these prices anywhere, which I think it could help some other people out also. Thank You, in Advance for any help for this NOOBY.
Post Reply

Return to “Pricing, Advertising, & Marketing Your Products Forum”