Quote Originally Posted by CPierce18 View Post
I have a very in depth and very user friendly excel spreadsheet I made up to calculate pricing.

One sheet has all my tooling info on it. Feed rates and amps for different types & materials cut, duty cycle at the given amps etc… also used as a backup for if SheetCam ever goes down.

The next sheet has all my pricing info on it.
-Nozzle Cost & cut inches it will last
-Electrode cost & cut inches it will last
-Swirl Ring cost & cut inches it will last
-General Labor $/hour
-CNC operator $/hour
-Table usage $/hour
-Drafting $/hour

The next sheet is where you enter all your part information. (can enter up to 25 unique parts)
-Material
-Quantity to be cut
-Thickness
-Part Area
-Cut inches

The information it calculates for you is-
-Part Weight
-Sheet to nest the part on
-Cut time for the part
-Possibility to overheat at the given amps to cut that thickness


On that same sheet below the part information is where you enter your material information. (There are 5 different plates you can enter)
-Material type (Carbon, Stainless, Aluminum, Diamond plate)
-Material Thickness
-Size (in inches)
-Cost per plate
-Quantity of each plate

The information this calculates for you (for each plate used) is-
-Material Price/Lb
-Optimization of the plate (% of the plate used)
-Scrap Percentage of the plate
-Cost lost from scrap
-Feedrate for the plate
-Amps for the plate


Under all that is where you enter your time-
-Drafting/programming
-Deslag/Blasting
-Painting
-Packaging

And some misc. things you enter is-
-Material Markup
-Misc. Material cost (paint, etc…)
-Shipping Cost
-Job Markup
-% Discount (if any)
-% Commission (if any)


This will calculate a price for the WHOLE job and give you the estimate of hours.


I know this seams like a ton of information you need to complete an estimate on a couple burnouts, but once you have all your tool info, it can be done in a couple minutes.


But keep in mind, I’m just a small 1 man shop that doesn’t have to pay for other employee labor so I have a lot of freedom to modify the numbers ($) as I see fit to please the customer with a decent price while still paying for equipment, my labor, & putting some in the bank. I just make sure I have enough money in there to cover my expenses + extra to bank.
May I have a copy of the spreadsheet?