Job Estimating Sheet and Actual Job Cost Sheet [Archive] - LawnSite.com™

EgansCountryGardens

12-15-2008, 03:05 PM

Okay guys, here is a program that I've been working on that is excel based. You'll see at the bottom of the screen it has two pages. The first page is for the original estimate company records only, the second page is so you can job cost the job at the end, and see what you really made. I even have on the second sheet, an area for commission for a sales person, as I pay my sales person on a commision of the profit of the job.

Now on the "Job Cost " sheet, pay no attention to the error formula in the box at the bottom for profit margin. It will correct itself as you enter the numbers. Also in the "profit margin" box, it is not in percent. it is .__ You have to move the decimal place over two places. For example .37 = 37%. In the "commission of profit" box, you have to enter also in decimal form the percent of profit that you intend to give your salesperson. For example, I pay my sales person 30% of profit, so I enter it as .30

My pay is based out of my company overhead that is approx. $950 per day for my approx. 140 working day season. This pays all my utilities, rent, insurance, my pay, and secretary for season. Make sense?

It is really a simple program. All you have to enter is your material name, quantities and unit prices. The program figures out the rest.

You may be better off printing it first before you enter anything, this way you can see how it all looks when done. Again, this is not to give to the customer as an estimate, just for your records so that you know what sort of profit margin you are running on your jobs.

I hope this helps some guys, this took me a few years to actually perfect. And the best part is that its free for you guys. :)
I also included a sample estimate that I have done.

EgansCountryGardens

12-15-2008, 03:08 PM

Sorry, I'm trying to upload the program, but it's not letting me. Let me try this......

This is not working, does anybody know how to upload an excel file. It is saying that it is invalid. Is it not possible???

RhinoL&L

12-16-2008, 07:28 AM

im not sure why it wont let you load it... but if you cant could you send it to me in an email? smileyrine@yahoo.com

thanks

EgansCountryGardens

12-16-2008, 11:02 AM

I sent that email to you.

RhinoL&L

12-16-2008, 07:52 PM

thanks that is a nice spreadsheet. did you set it up yourself? that is good!

Tyler7692

12-16-2008, 08:03 PM

EgansGardens,

I sent you a PM, wondering if I could check out your program as well?

Thanks,
Tyler

EgansCountryGardens

12-17-2008, 11:12 AM

Yeah, I set it up myself. The most important thing is to make sure that you include your overhead into your estimates. This way, you cover all your bills. The profit of course should be after your overhead, and after paying yourself. You are an employee of your company just like any other employees you have. The profit is for the company's future.

I've got a few more bugs to work out, but overall it works really good. Thanks.

audubonlandscape

12-19-2008, 10:22 AM

I'd love to have a coopy of that as well! Thanks. audubonlandscape@hotmail.com

AJ Lawnscapes

12-19-2008, 10:43 AM

Just change the extention from XLS to JPG

If you can't see the extention, open the folder that it's in, at the top click on Tools - Folder Options - View -- Show Hidden Files an Folders should have the bullet in it, and below that Hide Extentions for Known File Types should be UN-checked. -- then OK (you only need to ever do this once, as it's a system wide change)

Then if you right click on the file, select RENAME, and you should be able to change the extention. Say OK to changing it.

Upload it here, then anyone that downloads it will have to repeat the steps above to change it back to XLS and view it.

If you don't have MS Office -- you can get OpenOffice at www.openoffice.org -- has the ability to read/write office documents.

Enjoy!

Abe

aqualawn

12-19-2008, 10:43 AM

I would like a copy too. Thanks! info@outdoorsolutionsinc.us

andy'slawncare

12-19-2008, 10:46 AM

Copy Please! andybirkholz@hotmail.com
Thanks

JodyLee

12-20-2008, 06:40 PM

I would also love to see a copy j.l.landscapes@live.com

Thanks, Jody Lee

1wezil

12-20-2008, 07:04 PM

Okay guys, here is a program that I've been working on that is excel based. You'll see at the bottom of the screen it has two pages. The first page is for the original estimate company records only, the second page is so you can job cost the job at the end, and see what you really made. I even have on the second sheet, an area for commission for a sales person, as I pay my sales person on a commision of the profit of the job.

Now on the "Job Cost " sheet, pay no attention to the error formula in the box at the bottom for profit margin. It will correct itself as you enter the numbers. Also in the "profit margin" box, it is not in percent. it is .__ You have to move the decimal place over two places. For example .37 = 37%. In the "commission of profit" box, you have to enter also in decimal form the percent of profit that you intend to give your salesperson. For example, I pay my sales person 30% of profit, so I enter it as .30

My pay is based out of my company overhead that is approx. $950 per day for my approx. 140 working day season. This pays all my utilities, rent, insurance, my pay, and secretary for season. Make sense?

It is really a simple program. All you have to enter is your material name, quantities and unit prices. The program figures out the rest.

You may be better off printing it first before you enter anything, this way you can see how it all looks when done. Again, this is not to give to the customer as an estimate, just for your records so that you know what sort of profit margin you are running on your jobs.

I hope this helps some guys, this took me a few years to actually perfect. And the best part is that its free for you guys. :)
I also included a sample estimate that I have done.

I must be blind but I do not see anything here to download. please HELP !

tazman

12-22-2008, 01:05 AM

Could I also get a copy of your program emailed to me? pristinelandscape@centurytel.net

Thanks

creative land

12-22-2008, 01:33 AM

Hi there...
just wondering if you could send a copy my way as well.
cheers
Sherilyn
info@beneathyourfeet.ca

Loadsmasher

12-22-2008, 01:35 PM

Please add me to the list!

Thanks,

JD

lodesmasher@yahoo.com

1wezil

12-22-2008, 01:39 PM

Please send me a copy . thanks yankepacker@yahoo.com

born2farm

12-23-2008, 02:51 PM

not to be a bug but can i get a copy? brockgoodman_29@hotmail.com

thanks

GreenClips

12-23-2008, 05:03 PM

One more! messermatt@yahoo.com
Thanks
-Matt

phasthound

12-26-2008, 09:15 AM

Me too, please.
techterra@comcast.net

Rangerpro1253

12-26-2008, 12:22 PM

HAPPY HOLIDAYS!! please send me a copy of the excel file.

Rangerpro1253@hotmail.com

thegreek

12-26-2008, 02:01 PM

Could I get a copy of that please georgeb1000@yahoo.com

capnsac

12-26-2008, 02:42 PM

Any chance of getting a copy please?

SaccysLCO@Hotmail.com

Keegan

12-26-2008, 07:09 PM

Can you send me a copy as well?

moriartyslawncare@yahoo.com

Paradise Landscapes

12-26-2008, 07:53 PM

May I have one please?

chmiller1229@yahoo.com

Lucky Star Lawn Care

12-26-2008, 10:03 PM

Add me to the list if you dont mind. Thanks for your time!!
luckystarlawncare@sbcglobal.net

agm

12-26-2008, 11:07 PM

me too.....please? abqgroundsmaintenance@q.com

c landscaping

12-26-2008, 11:34 PM

could i have a copy too please happy holidays
FPFD133@yahoo.com

shade tree landscaping

12-27-2008, 05:11 PM

If your not sick of people asking for a copy yet...can I please get one too!
thomas@shadetree-landscaping.com

thanks!

elite lawns

12-27-2008, 10:31 PM

am i too late may i have a copy please.

EgansCountryGardens

12-28-2008, 02:08 PM

I would love to send copies to everyone here. I've actually sent out alot already. But it's just too hard to send them out all the time. If anyone knows how I can post an excel file to this board, please let me know, this way people can download them on their own. Or if someone could post it for me, please let me know, and I would be happy to email it to them. Thanks.

Lucky Star Lawn Care

12-28-2008, 07:08 PM

Totally understandable!! Hopefully someone knowshow to post it. Thanks for making this availableto us.:drinkup:

TomberLawn

12-28-2008, 08:12 PM

Okay, I'm testing an upload to see if it works. If it does, I'll tell you how to do it, or you can email it to me and I'll upload it for you.

TomberLawn

12-28-2008, 08:16 PM

Okay, well that worked for me. What you need to do is right click on the icon for the file when you open the folder that it is in. Or, if you have it saved to your desktop, just right click on the icon on your desktop. On the menu, you'll see a "Send To" option with a menu that goes out to the right. Select "Compressed (zipped) Folder" on this menu. This will create a zip folder with a compressed version of the file in it. Upload the zipped folder, and it should work. To download, just click the link and then click "Okay". The folder should decompress automatically and be ready to open. I hope this helps. If you have any questions, just ask and I'll try to explain it better.

EgansCountryGardens

12-28-2008, 09:17 PM

Great. I'll try first thing tomorrow when I get to the office. Thanks.

EgansCountryGardens

12-29-2008, 12:54 PM

Ok, here goes nothing. I hope this works.*trucewhiteflag*

1wezil

12-29-2008, 05:52 PM

That worked great !

FINELAWNS

12-29-2008, 06:44 PM

I think this is a great thing you are doing,wish You were arround 20 years ago. the new
start-ups dont know what dey are geting in to .(no ofense intended)
by the Youre not payng 29 per yard of stone dust,are You? Thanks great job.
Frank.

DBL

12-29-2008, 07:08 PM

good stuff.....

ECS

12-29-2008, 09:13 PM

EgansCountryGardens, here is one similar to yours that I did in WORKS before I had Excel. This one also has a mileage and gas/fuel table on it to add it into the estimate. If anyone wishes to use it, for those who do not have Excel, feel free to use it.

NEW CITY LAWN CARE LLC

12-29-2008, 09:22 PM

I don't have works, are there any Works Viewer programs?

EgansCountryGardens

12-29-2008, 10:29 PM

I'm glad its working for everyone. By the way, yes, I am paying 29 a yard for stonedust. Why is that alot compared to what you are paying. That's the cheapest around me right now.

Coumbe

01-01-2009, 08:06 PM

PRSLawnservice@consolidated.net

Magician1211

01-01-2009, 11:31 PM

Could you sent to me also
scottm1211@verizon.net
Thank you

Lucky Star Lawn Care

01-02-2009, 08:11 AM

Look at page 4

:hammerhead:

Magician1211

01-02-2009, 11:03 AM

Just wanted to say that after three years of trying to figure all that stuff out on my own that all the help from this forum and other doing the same things is great!

A Cut Above25

01-02-2009, 06:10 PM

Here is a question on that sheet? When you enter the actual job cost, then you enter the amount billed it comes up with a profit margin based of the difference of those numbers. However, isn't there a profit already built in to the amount billed? So shouldn't the true profit be that amount plus the difference? Thanks for sharing your hard work, that was really cool of you.

JKOOPERS

01-02-2009, 09:18 PM

heres the one i use for lawn care estimates

Fiano Landscapes

01-03-2009, 12:43 PM

I really like your estimate sheet I have made several estimate sheets over time. The only thing that isn't nessesarily wrong, but I would correct is the way you figure you overhead. I did this for a long time making it a daily charge to attach to estimates. The problem is is that on any job it is easy to miscalculate. I would look at our estimate Vs. actuals and realize that we were losing money doing it this way. I ended up figuring how many man hrs we have in a given year, by how much our annual overhead is. So now we figure our overhead into every hour of labor instead of a daily charge. There is no full proof plan, to be exact, but we did this and noticed we were collecting on a much higher percentage than before. You might even price your way right out of a job that way too! If you have 2 guys on one job, and three guys on another. What is you method for charging your overhead for the day. Do you charge half a day here and there. If you charge an entire day to both, on a small job you might price you way right out of the market. It's to much to keep track of. Figure it into your hourly payroll and you will charge right everytime.

Hope this help you , it did me very much so. If your not collecting all of your overhead it is coming right out of your profits.

Thanks,
Nick

JMLandscaping

01-03-2009, 10:01 PM

Okay guys, here is a program that I've been working on that is excel based. You'll see at the bottom of the screen it has two pages. The first page is for the original estimate company records only, the second page is so you can job cost the job at the end, and see what you really made. I even have on the second sheet, an area for commission for a sales person, as I pay my sales person on a commision of the profit of the job.

Now on the "Job Cost " sheet, pay no attention to the error formula in the box at the bottom for profit margin. It will correct itself as you enter the numbers. Also in the "profit margin" box, it is not in percent. it is .__ You have to move the decimal place over two places. For example .37 = 37%. In the "commission of profit" box, you have to enter also in decimal form the percent of profit that you intend to give your salesperson. For example, I pay my sales person 30% of profit, so I enter it as .30

My pay is based out of my company overhead that is approx. $950 per day for my approx. 140 working day season. This pays all my utilities, rent, insurance, my pay, and secretary for season. Make sense?

It is really a simple program. All you have to enter is your material name, quantities and unit prices. The program figures out the rest.

You may be better off printing it first before you enter anything, this way you can see how it all looks when done. Again, this is not to give to the customer as an estimate, just for your records so that you know what sort of profit margin you are running on your jobs.

I hope this helps some guys, this took me a few years to actually perfect. And the best part is that its free for you guys. :)
I also included a sample estimate that I have done.

Not working for me either I am real interested my email is JMansolillo@verizon.net

thanks in advance

lawnandsnow

01-26-2009, 04:23 PM

Can I get a copy of that spread sheet? njdeerhunter34@aol.com

Thanks

nikkidavis

01-27-2009, 10:39 AM

Could you please email me the spreadsheet that you made, I could really use it. My email address is nikkidavis@thecleancrue.com. Thanks so much for your help.

NIKKI

Frontier-Lawn

01-27-2009, 10:50 AM

me 3 please david@frontierlawn.biz

1wezil

01-27-2009, 10:53 AM

HEY guys look back a few posts someone posted them on here for all to down load and look at ....:hammerhead:

hustler king

03-07-2009, 12:36 PM

IM VERY INTERESTED TO SEE IT AS WELL melaniepemberton@att.net

gmeeks

01-25-2010, 10:01 PM

I was wondering if I could still get a copy of this or another one if someone has one. Thanks

xclusive

01-25-2010, 10:33 PM

I was wondering if I could still get a copy of this or another one if someone has one. Thanks

It is on page 4 in a zip file

datkinsonsr

01-28-2010, 02:41 PM

Thank you very much!

hustler king

03-19-2010, 08:41 AM

I would like a copy as well. Thanks. melaniepemberton@att.net (http://melaniepemberton@att.net)

underESTIMATED

05-18-2010, 11:59 AM

Thanks for the time invested in the spreadsheet!

Glenn Lawn Care

05-18-2010, 04:23 PM

i would also like a copy glennlawncare@yahoo.com

thanks

Vogel-Landscaping

05-24-2010, 08:48 PM

could i check it out? dvogel10@comcast.net

Zackster

05-24-2010, 08:59 PM

I'd like a copy also;
jgagel@insightbb.com

underESTIMATED

05-26-2010, 11:48 AM

The files are posted here: http://www.lawnsite.com/showpost.php?p=2666802&postcount=36 (4th page)

It`ll look nice...

10-17-2010, 09:50 PM

Yeah I would love to have one of those sheets, I just started a year ago and i really find it hard to do estimates. junet_one@hotmail.com Thank you...

kylesturf

10-17-2010, 10:45 PM

Awsome!! Could u please send it to me kyleshaffer73@yahoo.com
Posted via Mobile Device