Excel Pricing Worksheet

[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

[urbnsr]

Thank you, Danny. I appreciate this.
Paul

[kbenz]

thanks for putting this back up, I use it alot. my computer died and was having a hard time finding it again.........

[JakeSM]

Thank You Danny,

Very helpful
Jake

[Limitless]

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

Mel

[trtilton61]

Thanks for the updated worksheet.

[d2day]

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

[LakeCruiser]

Thanks Danny,

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

thanks - much appreciated!

[Phil@rvc]

Book1.xlsm

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

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

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]

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

[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

[Phil@rvc]

You need to enable your macros in excel

[tnbndr]

You need to enable your macros in excel

Did that already!

[Phil@rvc]

I will check it out

[Phil@rvc]

CNC Plasma Priceer.xlsm

Here is the Updated/Corrected Version

[tnbndr]

That works.
Thanks for posting, always like pricing options. This one is pretty straight forward.

[Dooggins1]

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

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

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]

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.

[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