Lawn Care Business Forum Lawn Care Business Book Lawn Care Business Blog Lawn Care Software
Home Forum Contract & Flyer Templates Blog Software Videos Podcast Calculators / Estimators Store Mower Review Design It Yourself Lawn Business School

Go Back   GopherHaul Landscaping & Lawn Care Business Marketing Forum > Business > General Business Discussions

General Business Discussions A place to talk about general business discussions.

Overhead!!


General Business Discussions

A place to talk about general business discussions.
Reply
 
Thread Tools Search this Thread
  #11  
Old 01-19-2010, 08:48 PM
picframer's Avatar
picframer picframer is offline
Andy
 
Join Date: Jan 2009
Location: Halifax, Nova Scotia
Posts: 2,885
Rep Power: 10
picframer will become famous soon enough
Default

Quote:
Originally Posted by Steve View Post
I think that is fantastic you do that. Would newer lawn care companies have a tough time doing that though? Keeping track of different job categories to see which category they tend to make more money on and which they lose money on?
Gosh we have to know, it is critical as to whether we survive or not. If we are working our butt off and barely making ends meet then we need to know before the repo guy comes calling and what can we do to fix it.

You can make it as simple as you want but everyone of us should be keeping some type of accounting and it should be updated no less than every three days, it honestly doesn't take that long.

Many use Quick Books which is excellent and easy to learn, personally I use Simply Accounting which too is easy but very powerful and a little harder to learn however even if you have to pay someone to do the initial set up it would be in my opinion my first investment. I have the Gopher Software however I couldn't do the tax the way it needs to be done and I need to be able to pull data and run it in Excel which I use to analyze the profit per job, by employee, by crew etc.

Your financial statement is a road map, you know where you want to go however without the map you will never know if you are getting there or even close to the mark.

It's great having money in the bank account however where and which jobs is generating the best cash flow and which ones are an issue.
__________________
Andy
Halifax, Nova Scotia
Reply With Quote

Stop guess-timating. Learn how to estimate and make money! $$$
Mow Time Estimator Lawn Care Price Estimator Mulch and Topsoil Calculator Snow Plow Estimate Calculator


  #12  
Old 01-20-2010, 11:54 AM
clean_cut clean_cut is offline
Junior Member
 
Join Date: Jan 2010
Location: North Carolina
Posts: 7
Rep Power: 6
clean_cut is on a distinguished road
Default

Lawn care business tipsLawn Care Business Book
Quote:
Originally Posted by bnclawncare View Post
I am looking for a "template" or preferably an 'Excel worksheet" that I can use to calculate my overhead expences. Does anyone have a sheet that automaticly calculates this when you enter in the numbers and that is willing to share? Thanks in advance.
Try this, I hope it helps, I didn't make it, so don't give me all the credit

You could substitute your own info in there to fit your personal needs, and there is an Employee table on page 2.
Attached Files
File Type: xls Overhead-Cost-Breakdown.xls (35.0 KB, 168 views)
Reply With Quote
  #13  
Old 01-20-2010, 02:22 PM
Steve's Avatar
Steve Steve is offline
Administrator
 
Join Date: May 2003
Posts: 37,460
Rep Power: 10
Steve has disabled reputation
Default

Oh that is very interesting!

In that chart, is fuel cost for the lifespan of that piece of equipment?
__________________
- Subscribe to my Lawn Care Marketing Blog Feed and get daily tips sent to you. Free!
Download your Free trial of Gopher Lawn Care Software.
Reply With Quote
  #14  
Old 01-20-2010, 09:57 PM
clean_cut clean_cut is offline
Junior Member
 
Join Date: Jan 2010
Location: North Carolina
Posts: 7
Rep Power: 6
clean_cut is on a distinguished road
Default

Quote:
Originally Posted by Steve View Post
Oh that is very interesting!

In that chart, is fuel cost for the lifespan of that piece of equipment?
I'm guessing so, pretty neat little chart though, you'd have to modify it to fit you needs.
Reply With Quote
  #15  
Old 01-21-2010, 03:49 PM
Steve's Avatar
Steve Steve is offline
Administrator
 
Join Date: May 2003
Posts: 37,460
Rep Power: 10
Steve has disabled reputation
Default

For the newer lawn care business owner, what should they be focused on getting out of using such a spread sheet?

Should they be focused on finding what their monthly expenses are or is it more important for them to know what their hourly expenses are so they can take that into account when bidding?

Or are they equally important?
__________________
- Subscribe to my Lawn Care Marketing Blog Feed and get daily tips sent to you. Free!
Download your Free trial of Gopher Lawn Care Software.
Reply With Quote
  #16  
Old 01-22-2010, 05:05 PM
SuperiorPower
Guest
 
Posts: n/a
Default

Clean_cut,

I made one similar to that but not nearly as detailed in the job area.

One thing I would suggest is to find out from your dealer what kind of life expectancy the machine has. There are a few things that I think are missing on determining the machine cost.

Here is what I think is missing:
  • How many hours per year that you expect to use it,
  • How much the yearly maintenance costs are estimated at,
  • How much your yearly fuel cost will be,

By knowing how many hours your machine is expected to last, and by knowing how many hours per year you anticipate the machine to run, you can get a better idea of how much the machine will cost you per year.

Example: Original cost for a trimmer: $350, Expected fuel cost per year $155.40 (from spreadsheet), Yearly maintenance cost, includes a yearly tune-up $125, Misc costs (string, heads, etc) $25.

Now lets say you expect to use the trimmer 600 hours per year and expect the trimmer to last 1800 hours, you figure the costs like this:

$350 base cost divided by 3 years (1800 hours life expectancy, 600 hours use expected per year) = yearly base cost of $116.67 + $155.40 + $125 + $25 =$422.07 is your yearly cost. However, since you expect to use the trimmer 600 hours per year, you have to divide the $422.07 by 600 hours = $0.7034 cost per hour.

I am working on a combined spread sheet to help realize the cost per machine per hour, per year, and per job. If it works like I hope, you would be able to add all this up to see what your cost is per job, add the profit per hour you need and then to see what you need to charge to make a profit.

Any ideas on what all equipment, and how many of each, you guys would want to see added (truck/trailer, mowers, trimmers, blowers, edgers, chain saws, push mowers, etc)?

I enjoy making spread sheets and happen to have a few minutes on my hands since I just had my wisdom teeth removed (ouch)...
Reply With Quote
  #17  
Old 01-22-2010, 05:48 PM
Steve's Avatar
Steve Steve is offline
Administrator
 
Join Date: May 2003
Posts: 37,460
Rep Power: 10
Steve has disabled reputation
Default

Quote:
Any ideas on what all equipment, and how many of each, you guys would want to see added
I haven't played around much with spread sheets and making things with them, but can't you set it up where the user can add as many items as they want?
__________________
- Subscribe to my Lawn Care Marketing Blog Feed and get daily tips sent to you. Free!
Download your Free trial of Gopher Lawn Care Software.
Reply With Quote
  #18  
Old 01-22-2010, 06:37 PM
SuperiorPower
Guest
 
Posts: n/a
Default

Quote:
Originally Posted by Steve View Post
I haven't played around much with spread sheets and making things with them, but can't you set it up where the user can add as many items as they want?
Essentially, yes. However, the formula has to be entered for each individual item. You can only copy and paste the formula if the formula remains in the same position from where you are copying from and pasting to. Example, you copy a formula that looks like this "=F39*C51", which is an actual formula from the spreadsheet I am working on, but where I need to paste it to, the formula must look like this "=F42*C51". If you notice, the "C51" needs to remain the same but when you copy and paste without modifying this, it will look like this "=F42*C54". This will prevent the formula from being accurate and thus, some of the formulas must be individually input. For each individual machine that is entered, you need to add specific formulas. Later tonight I will try to post the spreadsheet I have made so far, using some ideas from the one posted above.

At this point I am still trying to learn some of the formatting techniques (I am learning everything on my own with no book or help. lol).
Reply With Quote
  #19  
Old 01-23-2010, 02:30 AM
SuperiorPower
Guest
 
Posts: n/a
Default

Ok, tell me what you guys think of this spreadsheet. I think the formulas are correct. There is a lot of formula to make all the pages work together and I think they are all correct. Let me know.

The first page lets you insert times to get a real quick estimate on how much to charge, based on time to do the job.

Next page lets you figure out how much your machines cost to operate per hour and per year, based on how much you expect to use them per year. You can insert how much fuel you expect to use, how much you expect the maintenance to cost, and other variables. When its all said and done, it will figure up how much the machine will cost per year and then per hour of operation. Of course most of this information is simply an estimate since the maintenance cost, fuel cost, etc will vary by your use. There are a number of machines listed, including your vehicle. The first time you will need to change the names of your equipment to reflect what you have. You will have to change these names on the first 3 pages. Otherwise, only change the content in the green boxes.

Third page lets you determine exactly how much it will cost to do a job, again, based on length of time to do it. I included a minutes to hour conversion tool to help you with the times. There are fields for several equipment types where all you have to do is enter how long each machine will run and it will do the rest. You can choose how many visits per month and this will help you determine your monthly invoice amount. It gives you options on how much profit you want to make. Then it shows you how much you need to charge to reach your profit goals. It gives you a net profit per month and net profit per hour read out. This page I basically took from the spreadsheet posted above.

The last page is a very simple page that lets you insert your employee wages costs. You will have to change the number of employees and how much you pay each one.

In order for everything to be accurate, you MUST insert certain info, including employee wages, machine base costs, etc. or NONE of it will be accurate. Some of this info you may have to guess at until you get soem experience and see how much your maintenance costs will be, etc. Keep in mind that the current figures are completely arbitrary and have no intentions of being accurate. You may notice too that many of the cells have pop up "note" windows with instructions and/or detailed explanations.

Any green cell that is not applicable, simply insert "0" in them or the spreadsheet will give you inaccurate info.


Good luck and enjoy! This will also be posted on my forum.
Attached Files
File Type: xls Lawncare cost calc.xls (77.0 KB, 37 views)
Reply With Quote
  #20  
Old 01-23-2010, 07:23 AM
bnclawncare bnclawncare is offline
Member
 
Join Date: Jan 2009
Location: North Carolina
Posts: 68
Rep Power: 7
bnclawncare is on a distinguished road
Default

The sheet looks great. When fiquring your charges, where do you start including phone bills, office supplies, other supplies that are not directly charged back to the customer, etc.. All of this, to me, should get reclaimed some how through out the year, correct?
__________________

www.bnclawncare.com
Reply With Quote
Reply

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Entering your overhead costs - Online estimator Steve Online Lawn Care Estimator - Help me bid this job 2 04-13-2009 11:49 AM
Calculating overhead equipment costs. Steve General Business Discussions 5 02-08-2009 06:54 PM

» Recent Threads
  RatingTitle, Username, & Date Last Post Replies Views
Is it too late to do...
markty
06-16-2015 05:28 PM
07-03-2015 07:34 PM
by wolfpacker53
5 2,004
I dont know what to do...
Bradcook21
06-21-2015 08:49 AM
07-03-2015 07:33 PM
by stallman419
12 2,192
Should I buy this Exmark...
googus
07-03-2015 09:22 AM
07-03-2015 03:29 PM
by googus
3 93
Just about mid year, how...
GreenWorx
06-24-2015 07:05 PM
07-03-2015 02:53 PM
by American L&T
6 1,934
another newish job for me
holymoly
06-07-2015 08:34 AM
07-03-2015 02:06 PM
by American L&T
9 2,136
Unemployment rates drop,...
Steve
07-02-2015 12:40 PM
07-03-2015 09:42 AM
by Steve
2 86
Before & After tree...
COREtreeservice
07-01-2015 09:20 PM
07-01-2015 09:20 PM
by COREtreeservice
0 87
Dogs
Mr. Mow
06-29-2015 02:37 PM
07-01-2015 11:28 AM
by Steve
6 1,900
Ready to learn and get...
Koley Lawn & Landscape
06-28-2015 05:16 AM
07-01-2015 11:26 AM
by Steve
8 1,884
Three Stripe Land Care...
hammr04
06-30-2015 07:19 PM
07-01-2015 11:24 AM
by Steve
1 86
Country Life Lawn Care
darleneh
06-29-2015 11:24 AM
06-30-2015 01:25 PM
by Steve
3 1,747
Rubber mulch...
avetslawncare
06-24-2015 09:28 PM
06-29-2015 09:23 PM
by Chilehead
6 1,887
Marketing ideas
xandrew245x
04-29-2014 06:35 AM
06-25-2015 07:11 PM
by GreenWorx
34 5,771
Never ending sod jobs
avetslawncare
06-05-2015 09:46 PM
06-25-2015 11:42 AM
by Steve
11 2,379
Weed and Feed Service...
mike94740
06-23-2015 05:50 PM
06-24-2015 09:56 PM
by avetslawncare
2 1,809
Trimming hedges / trees,...
Hard-Body lawn & garden
06-23-2015 07:08 PM
06-24-2015 09:59 AM
by Steve
1 1,804
Hi Everyone from Arkansas
KellyMarie
06-04-2015 04:16 PM
06-23-2015 01:34 PM
by KellyMarie
4 2,073
how to make customers...
Bradcook21
05-27-2015 05:04 PM
06-23-2015 06:36 AM
by GreenWorx
7 2,312
problems with a customer...
LawnCareMan280
06-16-2015 10:26 PM
06-22-2015 11:11 AM
by Steve
6 2,112
Please review this FREE...
markty
06-21-2015 07:42 AM
06-22-2015 11:00 AM
by Steve
1 1,827
A good commercial bid...
burtle
06-20-2015 09:09 PM
06-22-2015 10:56 AM
by Steve
1 1,891
What would you do with...
holymoly
06-20-2015 06:48 PM
06-22-2015 10:48 AM
by Steve
1 1,854
New Member just joined...
vgoleco@hotmail.com
06-19-2015 03:49 PM
06-22-2015 10:42 AM
by Steve
2 1,849
Credit Cards - What's in...
Shark1611
06-16-2015 03:04 PM
06-21-2015 07:24 PM
by Chilehead
4 1,954
Blade usage
Wolf4dk
06-16-2015 12:18 AM
06-21-2015 05:35 PM
by kslawn
4 1,959
Hello, I am new to the...
adamslawnservices
06-17-2015 08:06 PM
06-19-2015 10:28 AM
by Steve
3 1,880
First commercial bid
SGL1
06-12-2015 08:57 PM
06-18-2015 05:04 PM
by SGL1
9 2,339
Needing a website built
burtle
06-17-2015 09:02 AM
06-18-2015 11:02 AM
by Steve
7 2,031
I have been rude and...
biglee
06-15-2015 10:11 PM
06-18-2015 10:46 AM
by Steve
10 2,114
Start LIKING FACEBOOK...
rlclawncare123
02-26-2015 12:06 AM
06-17-2015 08:38 AM
by burtle
9 3,206
Customer keeps adding...
Mr. Mow
06-13-2015 06:22 AM
06-16-2015 10:23 AM
by Steve
11 2,348
Pass discounts onto...
burnell76
06-03-2015 06:33 PM
06-16-2015 10:02 AM
by burnell76
3 2,050
burned grass only where...
nhauto
06-15-2015 05:28 PM
06-16-2015 09:45 AM
by Steve
2 1,919
Half year mark review.
Steve
06-02-2015 11:24 AM
06-15-2015 01:04 PM
by Steve
18 2,663
These are the days on...
ExtremeLawncareServices
01-11-2015 10:41 AM
06-15-2015 01:01 PM
by Steve
86 9,725
New Member
Bruce Fehr
06-05-2015 07:13 PM
06-15-2015 12:53 PM
by Steve
6 2,051
New to the business,...
CarefreeMowing
06-12-2015 02:36 PM
06-15-2015 12:50 PM
by Steve
1 1,940
Beginner Mistakes:...
Steve
01-31-2007 11:45 AM
06-13-2015 08:48 AM
by holymoly
45 12,057
New to the forum, new to...
CarefreeMowing
06-11-2015 12:35 PM
06-12-2015 10:44 AM
by Steve
2 1,851
problems with a customer
LawnCareMan280
05-19-2015 06:28 PM
06-11-2015 10:50 PM
by stallman419
8 2,412
Website Review
Outdoordesignsknox
06-08-2015 08:44 PM
06-11-2015 09:48 PM
by Just for Cuts
13 2,303
Anyone need help? I have...
biglee
05-06-2015 12:22 PM
06-10-2015 01:45 PM
by holymoly
15 3,001
Hello from the GREAT...
gbfarmsllc
06-09-2015 11:10 AM
06-10-2015 01:29 PM
by Sprinkler Buddy
2 1,920
Hey guys and gals, I'm...
Joeyhall
06-03-2015 03:54 PM
06-08-2015 02:15 PM
by chris2500hd
8 2,169
Mowing Bermuda...
Mr. Mow
06-02-2015 12:45 PM
06-08-2015 12:45 PM
by Steve
12 2,328
Hey Guys
PrattLandscaping
06-07-2015 06:37 PM
06-08-2015 12:23 PM
by Steve
2 1,934
Share your stolen...
SGL1
05-27-2015 09:05 PM
06-08-2015 11:54 AM
by Steve
25 2,886
Hello there My name is...
zwalk1839
06-04-2015 11:10 PM
06-08-2015 11:52 AM
by Steve
4 2,048
Laid off oil field...
Mr. Mow
05-30-2015 09:03 AM
06-08-2015 06:20 AM
by Mr. Mow
4 2,164
How do you find one time...
Greg'slawnandlandscape
06-02-2015 09:57 PM
06-05-2015 09:49 PM
by avetslawncare
4 2,083
» Popular Tags
ad landscaping advertising apartment complex apartment lawn care estimate applying bark billy goat brushcutter blowout bob villa collections commercial curb appeal services demonstration design door hangers edging employee problems equipment dealer equipment rental facebook foreman free advertising free lawn care google growing a lawn care business hardscapes hills how to husqvarna increase customers jobs landscape landscape services landscaping lawn aeration lawn care lawn care busines plan lawn mowing marketing marketing secrets more customers business mr dave new business ordinance past due patio install per hour service plowing pricing push versus ride scripts secrets to landscaping shell shreaded small engine repair snow plowing sq ft square foot trailer trailer mate pro tree tree pics trimmer rack up sell employee web design website website design winterization wood www.greenturion.co.za
Powered by vBadvanced CMPS v3.1.0

All times are GMT -5. The time now is 07:17 AM.


(C) 2011 Riggs Publications - Terms of use & Privacy Policy

All times are GMT -5. The time now is 07:17 AM.

(C) 2011 Riggs Publications - Terms of use & Privacy Policy