Hi SharkTamer:
I built a spreadsheet in Excel that I use to quote the work we do, and I've found it very worthwhile even though my business partner scorns it and prefers to guess differently than I do.
I have a bunch of one-time costs that I estimate, and a bunch of cycle time costs that I estimate.
Since I have the important ones written into the spreadsheet I tend not to overlook them, and I can name and estimate every operation separately if I think it's necessary.
Some operations will kill you if you don't watch it, and I've become aware what they are; for example lots of drilled and tapped holes always take longer than you think, especially if they are on several part faces and are several different sizes.
Ditto for tight tolerances between features that are created in different setups; for me going through all that makes me more aware of what I'm up against; especially when the part run sizes grow and I'm trying to compete with marginally competitive equipment.
Some costs are amortized into the run; setup, programming, fixtures, custom tooling will typically fall into the amortized cost category and the spreadsheet divides them into the total part run.
Others are individual operation times and they get tabulated per part.
Materials are estimated separately and added per part.
The grand total comes up and the spreadsheet is structured so I can simply change the part count and the spreadsheet updates automatically.
I lock the cells, the sheets and the workbook with my operation breakdown hidden so the customer can't see my time estimates, and then send a copy to him.
He can see how much ordering a hundred will cost him and how much a thousand will cost him by editing the one number that is still editable, and that's the run size.
It's useful to me because I tend to overlook a lot less doing it this way, so my quotes seem to me more accurate than they were when I just guessed at an overall price.
Keith prefers to say..."how many days to make this job", and quotes that way.
Sometimes I'm higher and sometimes lower than his guesstimates, and sometimes I'm closer and sometimes he's closer to the actual time a job takes.
I notice though, that when he has a boner to do a particular job, his quotes get more optimistic than when he's not that eager.
I pretend to myself that my quotes are more balanced and sober, but I'm probably just bullshitting myself.
After all, it's all just a guess, and my method is no exception; I just guess in smaller bites than he does.
We all win some and lose some and we have to accept that.
With regard to job acceptance I do two things.
1) my quote describes EXACTLY what I undertake to do for the price I'm agreeing to, and specifically excludes in words, which bits I do not offer on this job, like anodizing or special packaging or whatever.
2) I rely on the customer's purchase order as his commitment to what we have agreed, and will not normally begin work until I receive one.
I do have a few customers of very long standing whom I trust and like; they get some slack on the formalities but only because they've earned it.
Cheers
Marcus
Implant Mechanix • Design & Innovation > HOME
www.vancouverwireedm.com