grumpy is that your spreadsheet for all roof jobs or do you use it only for insurance estimates?
i know ins co's like to see it broken down but most guys don't do that for homeowners unless they are asked.
I price every job using that spreadsheet. The only difference is the materials I input. So for this job, I had to price the job twice. Once for the real work to be done, as previously stated, and once for the insurance company "like replacement". It only takes 5 minutes to figure a materials list since I do hundreds of them every year.
I do it this way, because this is the ONLY way I have found to accurately predict my gross profit per job. Maybe there is another way, but I don't know. I know how much I will make on a job before the job even starts, and for the most part the P&L at the end of the job is pretty much in line with what is forecasted. When I used price lists just too much was lumped together. Some jobs I was way high and didn't get some I was kind of low and got but didn't make enough, but it was based on averages. Originally the spreadsheet was developed for the production manager and myself to check what the salesmen were selling.
It's also nice when you are talking about real numbers and a salesman undersells a job, uses the excuse we are too expensive, and you throw the spreadsheet in his face and say "tell me where I made a mistake." Too often these salesmen are pricing jobs based on what other people think we should charge... the "going rate".
Again I said in a previous thread that I do not show this spreadsheet to home owners, but will show it to insurance companies However I have shown it to home owners in the past. However only a select few and only if I thought it would get me the job. I also always pre-emp the showing of the spreadsheet with a question "how much do you think is fair for us to make on this job?" You'd be suprised how often times they say more than we are actually going to make. Then I show them how much we are going to make. My accountant always says "Numbers don't lie." This is the price, this is how I arrived at the price. Take it or leave it. That's only happened less than a handful number of times, and all but once it got me the job. Then again some people think $1,000 a day is just way way too much and have this idea I am making a quarter million a year (I wish!!!), like it's all going in my pocket or something. Those are the kinds of people I typically don't target in my marketing... but really very very very few people do I ever discuss actual nitty gritty numbers. Most people can honestly care less how many boxes of nails I need to buy.
