Announcement

Collapse
No announcement yet.

Overhead!!

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • #16
    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)...

    Comment


    • #17
      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.

      Comment


      • #18
        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).

        Comment


        • #19
          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

          Comment


          • #20
            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?
            sigpic
            www.bnclawncare.com

            Comment


            • #21
              Sorry, thats a good point. I will make a section for that and upload it again. It will be tomorrow before I get that done though. It will show how much these administrative cost will be based on the total number of hours you expect to work for the year. I may be able to work in some other features I have on my mind. We shall see.

              Comment


              • #22
                All of this, to me, should get reclaimed some how through out the year, correct?
                Absolutely. If you add up all these costs and divide them by the amount of hours you work per year it will tell you how much you need to charge per hour to cover these overhead costs.
                - 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.

                Comment

                Working...
                X